consensus_index

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

10 rows where inventory_id = 275567

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
788997 788997 275567 275567 3517 2 0.155524228388044
788998 788998 275567 275567 30094 1 0.103682818925363
788999 788999 275567 275567 30594 1 0.0518414094626813
789000 789000 275567 275567 30754 8 0.311048456776088
789001 789001 275567 275567 39265 1 0.077762114194022
789002 789002 275567 275567 39624 1 0.0622096913552176
789003 789003 275567 275567 136518 1 0.0345609396417876
789004 789004 275567 275567 209095 1 0.038881057097011
789005 789005 275567 275567 216670 1 0.103682818925363
789006 789006 275567 275567 233966 1 0.0444354938251554 
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)
);