consensus_index

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

10 rows where inventory_id = 120003

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
354519 354519 120003 120003 27930 2 0.206362167533141
354520 354520 120003 120003 53076 4 0.206362167533141
354521 354521 120003 120003 63470 2 0.0450319168236085
354522 354522 120003 120003 96745 1 0.206362167533141
354523 354523 120003 120003 136425 4 0.103181083766571
354524 354524 120003 120003 169214 1 0.0343936945888569
354525 354525 120003 120003 188255 1 0.0515905418832853
354526 354526 120003 120003 208628 1 0.0412724335066282
354527 354527 120003 120003 212701 1 0.0257952709416426
354528 354528 120003 120003 311040 1 0.0687873891777137 
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)
);