consensus_index

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

11 rows where inventory_id = 247425

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
693660 693660 247425 247425 25677 3 0.143350774816685
693661 693661 247425 247425 123733 9 0.245126376873998
693662 693662 247425 247425 138505 1 0.0280763529189104
693663 693663 247425 247425 187194 3 0.107068807114356
693664 693664 247425 247425 188660 3 0.0888485370393653
693665 693665 247425 247425 190422 3 0.0716753874083423
693666 693666 247425 247425 194915 3 0.0993938759060473
693667 693667 247425 247425 229342 1 0.0257366568423345
693668 693668 247425 247425 314065 3 0.0993938759060473
693669 693669 247425 247425 316301 2 0.0476550284111641
693670 693670 247425 247425 317963 1 0.034315542456446 
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)
);