consensus_index

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

8 rows where inventory_id = 1947

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
6334 6334 1947 1947 28967 1 0.0840400179464281
6335 6335 1947 1947 41970 1 0.0672320143571425
6336 6336 1947 1947 50175 12 0.266810425791173
6337 6337 1947 1947 54383 1 0.112053357261904
6338 6338 1947 1947 76425 3 0.128269073983619
6339 6339 1947 1947 124004 8 0.225953838017523
6340 6340 1947 1947 155158 1 0.0480228673979589
6341 6341 1947 1947 181493 1 0.0560266786309521 
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)
);