consensus_index

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

15 rows where inchi_id = 138986

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1021 1021 223 223 138986 1 0.0373504174198248
1049 1049 228 228 138986 2 0.0638447688334388
1069 1069 231 231 138986 2 0.0660668161867619
45782 45782 13967 13967 138986 1 0.273438896365992
46364 46364 14125 14125 138986 1 0.199255474041014
95944 95944 33988 33988 138986 1 0.199255474041014
95951 95951 33990 33990 138986 1 0.273438896365992
297080 297080 100484 100484 138986 1 0.224617769417053
460159 460159 165437 165437 138986 1 0.224617769417053
527726 527726 209757 209757 138986 1 0.0438075079156545
539816 539816 213932 213932 138986 1 0.224617769417053
728664 728664 257174 257174 138986 1 0.199255474041014
841012 841012 291604 291604 138986 1 0.273438896365992
841024 841024 291606 291606 138986 1 0.0479215238013506
843506 843506 292261 292261 138986 1 0.199255474041014 
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)
);