consensus_index

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

22 rows where inchi_id = 83455

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
18787 18787 5521 5521 83455 8 0.461538461538462
19625 19625 5756 5756 83455 1 0.0874544499828781
100531 100531 35533 35533 83455 8 0.461538461538462
101172 101172 35749 35749 83455 3 0.5
101229 101229 35757 35757 83455 1 0.0874544499828781
130071 130071 46319 46319 83455 1 0.0735430547796543
159852 159852 57491 57491 83455 8 0.0963863181842898
216426 216426 75148 75148 83455 8 0.462908011869436
250145 250145 85056 85056 83455 1 0.3125
426621 426621 153876 153876 83455 8 0.462908011869436
733134 733134 258543 258543 83455 8 0.461538461538462
735310 735310 259368 259368 83455 1 0.0735430547796543
852454 852454 294943 294943 83455 5 0.455696202531646
852458 852458 294944 294944 83455 8 0.461538461538462
852462 852462 294945 294945 83455 8 0.462908011869436
857067 857067 296438 296438 83455 1 0.0874544499828781
1174313 1174313 394119 394119 83455 1 0.0874544499828781
1429697 1429697 445744 445744 83455 1 0.0874544499828781
1586938 1586938 479041 479041 83455 1 0.0874544499828781
1607065 1607065 485510 485510 83455 1 0.0874544499828781
1612074 1612074 486667 486667 83455 8 0.461538461538462
1613317 1613317 487061 487061 83455 1 0.0874544499828781 
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)
);