consensus_index

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

12 rows where inventory_id = 294322

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
850742 850742 294322 294322 51651 3 0.100750794899838
850743 850743 294322 294322 66029 1 0.0251876987249595
850744 850744 294322 294322 79580 2 0.201501589799676
850745 850745 294322 294322 101684 6 0.179517508055772
850746 850746 294322 294322 107775 1 0.201501589799676
850747 850747 294322 294322 159706 2 0.0450571252366353
850748 850748 294322 294322 161203 1 0.033583598299946
850749 850749 294322 294322 174074 2 0.067167196599892
850750 850750 294322 294322 192485 3 0.039279614856823
850751 850751 294322 294322 200324 1 0.0287859413999537
850752 850752 294322 294322 260865 2 0.0411313397807341
850753 850753 294322 294322 290895 1 0.0287859413999537 
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)
);