consensus_index

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

9 rows where inventory_id = 241607

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
675898 675898 241607 241607 4765 9 0.230769230769231
675899 675899 241607 241607 17401 1 0.0769230769230769
675900 675900 241607 241607 36133 1 0.115384615384615
675901 675901 241607 241607 57713 1 0.115384615384615
675902 675902 241607 241607 114952 3 0.230769230769231
675903 675903 241607 241607 153325 1 0.0576923076923077
675904 675904 241607 241607 196547 1 0.0461538461538462
675905 675905 241607 241607 226304 1 0.0769230769230769
675906 675906 241607 241607 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)
);