consensus_index

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

12 rows where inventory_id = 240719

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
672974 672974 240719 240719 3084 12 0.289408334327701
672975 672975 240719 240719 136918 2 0.0528384910137595
672976 672976 240719 240719 182326 1 0.0361760417909626
672977 672977 240719 240719 184330 2 0.144704167163851
672978 672978 240719 240719 216902 1 0.0482347223879502
672979 672979 240719 240719 217320 2 0.0964694447759003
672980 672980 240719 240719 240675 1 0.0413440477611001
672981 672981 240719 240719 284023 1 0.0578816668655402
672982 672982 240719 240719 286567 1 0.0723520835819253
672983 672983 240719 240719 290526 1 0.0413440477611001
672984 672984 240719 240719 291648 1 0.0723520835819253
672985 672985 240719 240719 320754 1 0.0361760417909626 
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)
);