consensus_index

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

10 rows where inventory_id = 284086

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
818214 818214 284086 284086 61362 1 0.0782171619160019
818215 818215 284086 284086 93475 1 0.156434323832004
818216 818216 284086 284086 115440 3 0.312868647664007
818217 818217 284086 284086 136965 1 0.0521447746106679
818218 818218 284086 284086 175515 1 0.0625737295328015
818219 818219 284086 284086 215542 1 0.104289549221336
818220 818220 284086 284086 232952 1 0.0312868647664007
818221 818221 284086 284086 248765 1 0.0446955210948582
818222 818222 284086 284086 277607 1 0.0347631830737786
818223 818223 284086 284086 296576 1 0.0391085809580009 
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)
);