consensus_index

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

10 rows where inventory_id = 485721

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1607858 1607858 485721 485721 46097 10 0.280127953834851
1607859 1607859 485721 485721 57065 2 0.126978320975487
1607860 1607860 485721 485721 106356 1 0.0399054363668661
1607861 1607861 485721 485721 136413 1 0.179574463650898
1607862 1607862 485721 485721 140820 1 0.119716309100598
1607863 1607863 485721 485721 149684 1 0.071829785460359
1607864 1607864 485721 485721 169069 1 0.0513069896145422
1607865 1607865 485721 485721 172093 1 0.0326499024819814
1607866 1607866 485721 485721 237459 1 0.0448936159127244
1607867 1607867 485721 485721 247645 1 0.0359148927301795 
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)
);