consensus_index

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

9 rows where inventory_id = 59645

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
166710 166710 59645 59645 21402 3 0.0697305469328902
166711 166711 59645 59645 51836 3 0.159643100430226
166712 166712 59645 59645 73275 1 0.0328921704282908
166713 166713 59645 59645 74761 4 0.230245192998036
166714 166714 59645 59645 137682 3 0.115122596499018
166715 166715 59645 59645 158446 1 0.057561298249509
166716 166716 59645 59645 169273 1 0.230245192998036
166717 166717 59645 59645 181166 2 0.0469986032144852
166718 166718 59645 59645 266298 1 0.0460490385996072 
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)
);