consensus_index

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

10 rows where inventory_id = 15000

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
48741 48741 15000 15000 41670 4 0.245154346814511
48742 48742 15000 15000 95833 3 0.0935438908074767
48743 48743 15000 15000 104242 1 0.245154346814511
48744 48744 15000 15000 230151 2 0.0447588552735842
48745 48745 15000 15000 264676 2 0.0707699640631825
48746 48746 15000 15000 264863 3 0.0972895670069829
48747 48747 15000 15000 267592 2 0.0548181784456806
48748 48748 15000 15000 294648 2 0.0378281369712476
48749 48749 15000 15000 309063 2 0.0327601275949377
48750 48750 15000 15000 309178 2 0.0288917168449833 
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)
);