consensus_index

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

12 rows where inventory_id = 153766

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
426289 426289 153766 153766 51651 3 0.100750794899838
426290 426290 153766 153766 66029 1 0.0251876987249595
426291 426291 153766 153766 79580 2 0.201501589799676
426292 426292 153766 153766 101684 6 0.179517508055772
426293 426293 153766 153766 107775 1 0.201501589799676
426294 426294 153766 153766 159706 2 0.0450571252366353
426295 426295 153766 153766 161203 1 0.033583598299946
426296 426296 153766 153766 174074 2 0.067167196599892
426297 426297 153766 153766 192485 3 0.039279614856823
426298 426298 153766 153766 200324 1 0.0287859413999537
426299 426299 153766 153766 260865 2 0.0411313397807341
426300 426300 153766 153766 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)
);