consensus_index

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

11 rows where inventory_id = 215861

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
545424 545424 215861 215861 64737 6 0.32481232858678
545425 545425 215861 215861 137302 1 0.16240616429339
545426 545426 215861 215861 148075 1 0.0541353880977966
545427 545427 215861 215861 181567 1 0.0649624657173559
545428 545428 215861 215861 189143 1 0.108270776195593
545429 545429 215861 215861 217758 1 0.0812030821466949
545430 545430 215861 215861 234163 1 0.0295283935078891
545431 545431 215861 215861 234286 1 0.032481232858678
545432 545432 215861 215861 261937 1 0.0464017612266828
545433 545433 215861 215861 286558 1 0.0406015410733475
545434 545434 215861 215861 286559 1 0.0360902587318644 
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)
);