consensus_index

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

10 rows where inventory_id = 239581

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
668709 668709 239581 239581 46528 3 0.211204802174614
668710 668710 239581 239581 81277 5 0.185313883588293
668711 668711 239581 239581 142861 3 0.12088457257247
668712 668712 239581 239581 182554 1 0.152305017591599
668713 668713 239581 239581 183469 1 0.0380762543978998
668714 668714 239581 239581 189605 1 0.0338455594647998
668715 668715 239581 239581 195229 1 0.0609220070366396
668716 668716 239581 239581 231209 2 0.0879333429054404
668717 668717 239581 239581 290463 1 0.0507683391971997
668718 668718 239581 239581 308242 1 0.0435157193118854 
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)
);