consensus_index

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

9 rows where inventory_id = 247157

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
692757 692757 247157 247157 24231 12 0.250245022823377
692758 692758 247157 247157 58699 2 0.0474636186903141
692759 692759 247157 247157 136674 4 0.234932926449016
692760 692760 247157 247157 185004 1 0.110748443610733
692761 692761 247157 247157 196797 1 0.0830613327080498
692762 692762 247157 247157 196798 1 0.0664490661664398
692763 692763 247157 247157 196799 1 0.0553742218053665
692764 692764 247157 247157 219289 1 0.0830613327080498
692765 692765 247157 247157 240529 1 0.0553742218053665 
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)
);