consensus_index

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

8 rows where inventory_id = 33742

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
95256 95256 33742 33742 53069 7 0.316921335597057
95257 95257 33742 33742 133227 1 0.158460667798529
95258 95258 33742 33742 136275 2 0.158460667798529
95259 95259 33742 33742 174475 1 0.0528202225995095
95260 95260 33742 33742 197836 1 0.0792303338992643
95261 95261 33742 33742 208857 1 0.0633842671194114
95262 95262 33742 33742 237120 1 0.0452744765138653
95263 95263 33742 33742 332556 1 0.105640445199019 
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)
);