consensus_index

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

9 rows where inventory_id = 55504

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
154326 154326 55504 55504 4765 9 0.230769230769231
154327 154327 55504 55504 17401 1 0.0769230769230769
154328 154328 55504 55504 36133 1 0.115384615384615
154329 154329 55504 55504 57713 1 0.115384615384615
154330 154330 55504 55504 114952 3 0.230769230769231
154331 154331 55504 55504 153325 1 0.0576923076923077
154332 154332 55504 55504 196547 1 0.0461538461538462
154333 154333 55504 55504 226304 1 0.0769230769230769
154334 154334 55504 55504 264881 1 0.0384615384615385 
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)
);