consensus_index

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

9 rows where inventory_id = 99751

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
294669 294669 99751 99751 71670 8 0.204661512831368
294670 294670 99751 99751 111287 1 0.0800781444667113
294671 294671 99751 99751 138307 1 0.0400390722333557
294672 294672 99751 99751 187972 4 0.130767062328213
294673 294673 99751 99751 195529 1 0.0457589396952636
294674 294674 99751 99751 195982 4 0.320312577866845
294675 294675 99751 99751 198853 1 0.0640625155733691
294676 294676 99751 99751 282506 2 0.0653835311641063
294677 294677 99751 99751 294678 1 0.0355902864296495 
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)
);