consensus_index

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

22 rows where inchi_id = 31942

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
37344 37344 11201 11201 31942 1 0.3125
37539 37539 11277 11277 31942 8 0.519685039370079
58895 58895 18616 18616 31942 1 0.310344827586207
79287 79287 28622 28622 31942 1 0.310344827586207
101531 101531 35844 35844 31942 8 0.519685039370079
127826 127826 45700 45700 31942 1 0.310344827586207
224278 224278 77369 77369 31942 1 0.205788682372584
269418 269418 91350 91350 31942 2 0.314285714285714
270325 270325 91667 91667 31942 8 0.364485981308411
343898 343898 116130 116130 31942 1 0.307692307692308
432297 432297 155473 155473 31942 1 0.205788682372584
450376 450376 161560 161560 31942 2 0.314285714285714
450709 450709 161706 161706 31942 8 0.364485981308411
479760 479760 175500 175500 31942 1 0.3
698407 698407 248962 248962 31942 1 0.310344827586207
791740 791740 276415 276415 31942 1 0.310344827586207
791742 791742 276416 276416 31942 1 0.189189189189189
895383 895383 314362 314362 31942 4 0.506024096385542
1640625 1640625 496357 496357 31942 1 0.3125
1641069 1641069 496540 496540 31942 8 0.519685039370079
1675934 1675934 508785 508785 31942 1 0.307692307692308
1752968 1752968 537049 537049 31942 1 0.307692307692308 
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)
);