consensus_index

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

22 rows where inchi_id = 77730

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
61628 61628 19792 19792 77730 1 0.157894736842105
77885 77885 28079 28079 77730 6 0.384615384615385
103195 103195 36305 36305 77730 1 0.157894736842105
125225 125225 44685 44685 77730 3 0.375
134302 134302 47667 47667 77730 1 0.155243426343009
247760 247760 84312 84312 77730 6 0.323529411764706
357800 357800 121421 121421 77730 1 0.154245691772616
441936 441936 158425 158425 77730 6 0.323529411764706
484847 484847 179206 179206 77730 1 0.121075206765317
536472 536472 212912 212912 77730 6 0.323529411764706
707463 707463 251287 251287 77730 1 0.157894736842105
804981 804981 280520 280520 77730 1 0.155844155844156
804986 804986 280521 280521 77730 1 0.157894736842105
849184 849184 293772 293772 77730 6 0.384615384615385
888525 888525 309904 309904 77730 3 0.375
1169606 1169606 392820 392820 77730 6 0.384615384615385
1425183 1425183 444401 444401 77730 6 0.384615384615385
1583813 1583813 478140 478140 77730 6 0.384615384615385
1606131 1606131 485224 485224 77730 6 0.384615384615385
1630586 1630586 492767 492767 77730 6 0.384615384615385
1671795 1671795 507266 507266 77730 1 0.157894736842105
1727973 1727973 529179 529179 77730 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)
);