consensus_index

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

7 rows where inventory_id = 157502

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
439428 439428 157502 157502 4765 6 0.25974025974026
439429 439429 157502 157502 17401 1 0.12987012987013
439430 439430 157502 157502 114952 2 0.25974025974026
439431 439431 157502 157502 144395 1 0.12987012987013
439432 439432 157502 157502 169892 1 0.051948051948052
439433 439433 157502 157502 196548 2 0.0865800865800866
439434 439434 157502 157502 226304 1 0.0649350649350649 
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)
);