consensus_index

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

9 rows where inventory_id = 102962

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
304478 304478 102962 102962 5804 2 0.246227761653275
304479 304479 102962 102962 115944 1 0.0615569404133189
304480 304480 102962 102962 139097 2 0.142159664472478
304481 304481 102962 102962 205785 3 0.102163164935634
304482 304482 102962 102962 216006 1 0.0410379602755459
304483 304483 102962 102962 224732 1 0.0307784702066594
304484 304484 102962 102962 235042 1 0.123113880826638
304485 304485 102962 102962 259310 2 0.142159664472478
304486 304486 102962 102962 292277 1 0.0492455523306551 
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)
);