consensus_index

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

8 rows where inventory_id = 35863

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
101598 101598 35863 35863 16464 2 0.0513020773994042
101599 101599 35863 35863 43800 6 0.271806957662542
101600 101600 35863 35863 137983 3 0.111953818449881
101601 101601 35863 35863 140401 3 0.155248884457658
101602 101602 35863 35863 169008 3 0.0678111963171566
101603 101603 35863 35863 169009 4 0.158953673114989
101604 101604 35863 35863 208324 2 0.0507758883369138
101605 101605 35863 35863 219377 2 0.118477072786132 
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)
);