consensus_index

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

10 rows where inventory_id = 136594

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
395160 395160 136594 136594 77610 3 0.233844402049605
395161 395161 136594 136594 77920 2 0.0507880698260596
395162 395162 136594 136594 102535 13 0.176200786879063
395163 395163 136594 136594 230532 2 0.0369848415474184
395164 395164 136594 136594 243569 1 0.212461739241428
395165 395165 136594 136594 253212 1 0.084984695696571
395166 395166 136594 136594 258346 1 0.0424923478482855
395167 395167 136594 136594 259336 1 0.0531154348103569
395168 395168 136594 136594 278059 1 0.0607033540689793
395169 395169 136594 136594 309884 1 0.0326864214217581 
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)
);