consensus_index

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

27 rows where inchi_id = 1499

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
21695 21695 6401 6401 1499 8 0.413793103448276
94694 94694 33617 33617 1499 8 0.413793103448276
132973 132973 47216 47216 1499 2 0.286666451421531
193508 193508 68796 68796 1499 8 0.413793103448276
220516 220516 76352 76352 1499 8 0.519685039370079
429478 429478 154715 154715 1499 8 0.519685039370079
594700 594700 231658 231658 1499 5 0.51063829787234
597392 597392 235400 235400 1499 8 0.519685039370079
670873 670873 240185 240185 1499 12 0.417391304347826
741070 741070 261078 261078 1499 6 0.514285714285714
741073 741073 261079 261079 1499 5 0.51063829787234
741076 741076 261080 261080 1499 8 0.413793103448276
741080 741080 261081 261081 1499 5 0.51063829787234
928002 928002 330093 330093 1499 4 0.506024096385542
974188 974188 352880 352880 1499 8 0.413793103448276
974192 974192 352881 352881 1499 8 0.413793103448276
974196 974196 352882 352882 1499 8 0.413793103448276
974200 974200 352883 352883 1499 8 0.413793103448276
974204 974204 352884 352884 1499 8 0.413793103448276
974208 974208 352885 352885 1499 8 0.413793103448276
1184492 1184492 396988 396988 1499 8 0.413793103448276
1184496 1184496 396989 396989 1499 8 0.413793103448276
1437894 1437894 448060 448060 1499 8 0.413793103448276
1437898 1437898 448061 448061 1499 8 0.413793103448276
1589929 1589929 479941 479941 1499 8 0.413793103448276
1616058 1616058 487974 487974 1499 8 0.413793103448276
1719371 1719371 526584 526584 1499 8 0.413793103448276 
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)
);