consensus_index

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

9 rows where inchi_id = 83954

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
31961 31961 9391 9391 83954 1 0.0787599668868335
97076 97076 34414 34414 83954 1 0.0787599668868335
249214 249214 84766 84766 83954 1 0.0795381739959279
249219 249219 84767 84767 83954 6 0.615384615384615
559563 559563 220126 220126 83954 1 0.239130434782609
733552 733552 258695 258695 83954 1 0.0787599668868335
1623385 1623385 490220 490220 83954 1 0.239130434782609
1631113 1631113 492942 492942 83954 1 0.0787599668868335
1631118 1631118 492943 492943 83954 7 0.620689655172414 
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)
);