consensus_index

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

8 rows where inchi_id = 42452

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
164054 164054 58758 58758 42452 4 0.6
243090 243090 82674 82674 42452 1 0.206896551724138
278161 278161 94325 94325 42452 6 0.615384615384615
440006 440006 157734 157734 42452 1 0.206896551724138
703587 703587 250547 250547 42452 8 0.625
717185 717185 253659 253659 42452 1 0.208695652173913
900156 900156 316642 316642 42452 4 0.6
1644668 1644668 497845 497845 42452 8 0.625 
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)
);