consensus_index

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

12 rows where inventory_id = 291788

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
841688 841688 291788 291788 32816 1 0.0513257586198155
841689 841689 291788 291788 42770 1 0.036661256157011
841690 841690 291788 291788 75199 3 0.141228267464131
841691 841691 291788 291788 104074 3 0.101843204032701
841692 841692 291788 291788 118280 6 0.145585628518438
841693 841693 291788 291788 141589 1 0.0641571982747693
841694 841694 291788 291788 224975 1 0.0285143103443419
841695 841695 291788 291788 225637 1 0.128314396549539
841696 841696 291788 291788 229823 2 0.0604879866160257
841697 841697 291788 291788 263657 1 0.128314396549539
841698 841698 291788 291788 271199 2 0.0662612694553357
841699 841699 291788 291788 329598 2 0.0370411756943903 
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)
);