consensus_index

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

11 rows where inventory_id = 249687

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
700861 700861 249687 249687 37151 6 0.325157476158637
700862 700862 249687 249687 75858 1 0.0812893690396594
700863 700863 249687 249687 136433 1 0.0650314952317275
700864 700864 249687 249687 168961 2 0.162578738079319
700865 700865 249687 249687 173739 1 0.0541929126931062
700866 700866 249687 249687 211077 1 0.0325157476158637
700867 700867 249687 249687 211078 1 0.0464510680226625
700868 700868 249687 249687 218705 1 0.0406446845198297
700869 700869 249687 249687 227644 1 0.108385825386212
700870 700870 249687 249687 227763 1 0.0295597705598761
700871 700871 249687 249687 240501 1 0.0361286084620708 
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)
);