consensus_index

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

15 rows where inventory_id = 79006

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
230693 230693 79006 79006 17230 1 0.0356878593905631
230694 230694 79006 79006 31906 8 0.285502875124505
230695 230695 79006 79006 136807 2 0.142751437562252
230696 230696 79006 79006 138446 1 0.0317225416805005
230697 230697 79006 79006 164385 1 0.057100575024901
230698 230698 79006 79006 182760 2 0.0440540500555199
230699 230699 79006 79006 195673 2 0.0951676250415016
230700 230700 79006 79006 233303 1 0.0356878593905631
230701 230701 79006 79006 238262 1 0.0285502875124505
230702 230702 79006 79006 238988 2 0.0713757187811262
230703 230703 79006 79006 239123 2 0.052125454979424
230704 230704 79006 79006 240549 1 0.0259548068295004
230705 230705 79006 79006 253639 2 0.0359699812463509
230706 230706 79006 79006 320702 1 0.0237919062603754
230707 230707 79006 79006 334605 2 0.025040258616316 
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)
);