consensus_index

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

25 rows where inchi_id = 143178

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
95 95 26 26 143178 1 0.245283018867925
3677 3677 1041 1041 143178 2 0.370021052114536
54790 54790 17117 17117 143178 2 0.370021052114536
80133 80133 28913 28913 143178 2 0.370021052114536
180292 180292 64416 64416 143178 3 0.645027620562502
338031 338031 113969 113969 143178 3 0.479599916783518
477228 477228 174018 174018 143178 1 0.442982015251035
567626 567626 222775 222775 143178 1 0.442982015251035
695633 695633 248032 248032 143178 2 0.370021052114536
695636 695636 248033 248033 143178 1 0.189764506496982
876301 876301 303320 303320 143178 1 0.442982015251035
1046640 1046640 370428 370428 143178 2 0.370021052114536
1046642 1046642 370429 370429 143178 2 0.370021052114536
1046644 1046644 370430 370430 143178 2 0.370021052114536
1267882 1267882 417311 417311 143178 2 0.370021052114536
1267884 1267884 417312 417312 143178 2 0.370021052114536
1267886 1267886 417313 417313 143178 2 0.370021052114536
1267888 1267888 417314 417314 143178 2 0.370021052114536
1489218 1489218 460793 460793 143178 2 0.370021052114536
1489220 1489220 460794 460794 143178 2 0.370021052114536
1489222 1489222 460795 460795 143178 2 0.370021052114536
1597542 1597542 482459 482459 143178 2 0.370021052114536
1673357 1673357 507814 507814 143178 2 0.370021052114536
1673362 1673362 507816 507816 143178 1 0.189764506496982
1751536 1751536 536549 536549 143178 2 0.370021052114536 
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)
);