consensus_index

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

10 rows where inventory_id = 86767

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
255686 255686 86767 86767 48 1 0.110698580795237
255687 255687 86767 86767 67507 1 0.0474422489122442
255688 255688 86767 86767 83760 5 0.202035207762018
255689 255689 86767 86767 141432 3 0.263584565408618
255690 255690 86767 86767 186506 1 0.0830239355964274
255691 255691 86767 86767 197913 1 0.0664191484771419
255692 255692 86767 86767 220547 2 0.0782757171480387
255693 255693 86767 86767 258249 1 0.033209574238571
255694 255694 86767 86767 260111 1 0.0553492903976183
255695 255695 86767 86767 287466 1 0.0415119677982137 
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)
);