consensus_index

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

25 rows where inchi_id = 87531

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
19736 19736 5785 5785 87531 8 0.461538461538462
80959 80959 29193 29193 87531 8 0.461538461538462
146482 146482 52360 52360 87531 4 0.473684210526316
150433 150433 53927 53927 87531 8 0.461538461538462
180598 180598 64501 64501 87531 3 0.645027620562502
218288 218288 75687 75687 87531 7 0.45993031358885
427843 427843 154237 154237 87531 7 0.45993031358885
532714 532714 211299 211299 87531 8 0.375903614457831
563756 563756 221521 221521 87531 4 0.473684210526316
600111 600111 236289 236289 87531 1 1.82940971666042e-06
857667 857667 296668 296668 87531 8 0.461538461538462
857671 857671 296669 296669 87531 4 0.452830188679245
935134 935134 333721 333721 87531 2 0.454545454545455
958653 958653 344880 344880 87531 4 0.452830188679245
1052441 1052441 372157 372157 87531 4 0.473684210526316
1174695 1174695 394236 394236 87531 8 0.461538461538462
1274740 1274740 419372 419372 87531 4 0.473684210526316
1430072 1430072 445866 445866 87531 8 0.461538461538462
1493535 1493535 462089 462089 87531 4 0.473684210526316
1587202 1587202 479121 479121 87531 8 0.461538461538462
1598729 1598729 482887 482887 87531 4 0.473684210526316
1607145 1607145 485530 485530 87531 8 0.461538461538462
1613457 1613457 487100 487100 87531 8 0.461538461538462
1642417 1642417 497041 497041 87531 4 0.473684210526316
1718298 1718298 526251 526251 87531 8 0.461538461538462 
CREATE TABLE [consensus_index] (
        [inventory_id] integer,
        [inchi_id] text,
        [consensus_score] text,
        [consensus_count] integer,
        FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);