consensus_index

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

11 rows where inventory_id = 12010

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
39721 39721 12010 12010 43709 4 0.240231747417857
39722 39722 12010 12010 115772 5 0.248703501694828
39723 39723 12010 12010 137144 3 0.0990415629723361
39724 39724 12010 12010 182460 3 0.0786093406254305
39725 39725 12010 12010 203840 3 0.0729744475329323
39726 39726 12010 12010 208589 2 0.0385217984356743
39727 39727 12010 12010 216641 3 0.0579198573902875
39728 39728 12010 12010 238210 2 0.0408121861826931
39729 39729 12010 12010 250732 2 0.0412351216878912
39730 39730 12010 12010 296223 2 0.0388768455580805
39731 39731 12010 12010 333101 2 0.0341459247745256 
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)
);