consensus_index

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

21 rows where inchi_id = 43434

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
6084 6084 1859 1859 43434 1 0.0592515592515592
39650 39650 11987 11987 43434 6 0.384615384615385
112200 112200 39240 39240 43434 6 0.384615384615385
155001 155001 55751 55751 43434 6 0.384615384615385
229417 229417 78681 78681 43434 1 0.0590551181102362
279586 279586 94817 94817 43434 6 0.323529411764706
435326 435326 156278 156278 43434 1 0.0590551181102362
453943 453943 163045 163045 43434 6 0.323529411764706
474175 474175 172374 172374 43434 4 0.380952380952381
484491 484491 178915 178915 43434 1 0.230769230769231
495194 495194 188432 188432 43434 1 0.0598911070780399
520515 520515 207854 207854 43434 1 0.0590551181102362
559682 559682 220164 220164 43434 6 0.323529411764706
577993 577993 226415 226415 43434 1 0.0590551181102362
660901 660901 236602 236602 43434 1 0.0590551181102362
704131 704131 250719 250719 43434 9 0.326086956521739
769424 769424 269180 269180 43434 1 0.0590551181102362
801299 801299 279533 279533 43434 6 0.384615384615385
891272 891272 312465 312465 43434 3 0.375
1645268 1645268 498074 498074 43434 6 0.384615384615385
1735931 1735931 531788 531788 43434 6 0.384615384615385 
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)
);