consensus_index

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

26 rows where inchi_id = 55049

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
15800 15800 4799 4799 55049 9 0.388377537559307
36923 36923 11061 11061 55049 1 0.161764705882353
92217 92217 32879 32879 55049 9 0.388377537559307
151971 151971 54659 54659 55049 1 0.0792718949777638
151980 151980 54660 54660 55049 14 0.326692686697527
153242 153242 55076 55076 55049 1 0.161764705882353
211262 211262 74042 74042 55049 10 0.392779682536047
265326 265326 89911 89911 55049 1 0.137931034482759
267206 267206 90576 90576 55049 1 0.161764705882353
423323 423323 153198 153198 55049 10 0.392779682536047
449451 449451 161178 161178 55049 1 0.161764705882353
550713 550713 217661 217661 55049 9 0.370858167983831
568540 568540 223038 223038 55049 1 0.161764705882353
694783 694783 247795 247795 55049 1 0.161764705882353
715751 715751 253252 253252 55049 1 0.0717493152758634
715802 715802 253268 253268 55049 14 0.326692686697527
783959 783959 274036 274036 55049 1 0.161764705882353
783963 783963 274037 274037 55049 1 0.1875
818375 818375 284122 284122 55049 9 0.388377537559307
818381 818381 284123 284123 55049 10 0.374771421718391
818388 818388 284124 284124 55049 6 0.461173577395733
940976 940976 336650 336650 55049 5 0.453281772390335
944937 944937 338447 338447 55049 1 0.1875
1609061 1609061 485906 485906 55049 9 0.388377537559307
1639561 1639561 495968 495968 55049 1 0.161764705882353
1715576 1715576 525527 525527 55049 9 0.388377537559307 
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)
);