consensus_index

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

11 rows where inchi_id = 100017

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
97188 97188 34468 34468 100017 1 0.3125
174454 174454 62310 62310 100017 1 0.206896551724138
227447 227447 78218 78218 100017 1 0.206896551724138
309282 309282 104487 104487 100017 5 0.28898667231727
434118 434118 155992 155992 100017 1 0.206896551724138
466403 466403 168458 168458 100017 5 0.28898667231727
582659 582659 227800 227800 100017 5 0.28898667231727
682146 682146 243602 243602 100017 1 0.3125
762771 762771 267485 267485 100017 1 0.3125
958376 958376 344728 344728 100017 3 0.414003226156891
1620440 1620440 489330 489330 100017 1 0.3125 
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)
);