consensus_index

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

9 rows where inventory_id = 1154

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
3987 3987 1154 1154 7599 2 0.189930190912615
3988 3988 1154 1154 55062 2 0.268601851892731
3989 3989 1154 1154 157921 2 0.0949650954563073
3990 3990 1154 1154 176250 3 0.186238122321284
3991 3991 1154 1154 194762 2 0.0600611999714476
3992 3992 1154 1154 208862 2 0.0693526999427345
3993 3993 1154 1154 260161 2 0.0447669753154551
3994 3994 1154 1154 281614 2 0.038371693127533
3995 3995 1154 1154 309111 1 0.0335752314865913 
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)
);