consensus_index

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

20 rows where inventory_id = 111152

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
329752 329752 111152 111152 16848 4 0.0718640409504017
329753 329753 111152 111152 22989 13 0.170588428608853
329754 329754 111152 111152 23531 2 0.0675359922261951
329755 329755 111152 111152 24705 1 0.0335589043434821
329756 329756 111152 111152 136621 1 0.0604060278182678
329757 329757 111152 111152 140424 4 0.0912546431510815
329758 329758 111152 111152 188171 2 0.0659083797401954
329759 329759 111152 111152 189204 1 0.0755075347728348
329760 329760 111152 111152 224826 2 0.0200024346017667
329761 329761 111152 111152 256715 2 0.0711891864914007
329762 329762 111152 111152 259451 2 0.0455327566702193
329763 329763 111152 111152 261980 2 0.0337679961130975
329764 329764 111152 111152 288029 1 0.0274572853719399
329765 329765 111152 111152 294612 1 0.0251691782576116
329766 329766 111152 111152 297901 1 0.0215735813636671
329767 329767 111152 111152 309074 1 0.0201353426060893
329768 329768 111152 111152 309786 2 0.0238775790386523
329769 329769 111152 111152 320411 1 0.0335589043434821
329770 329770 111152 111152 320728 1 0.0177664787700788
329771 329771 111152 111152 326358 1 0.0167794521717411 
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)
);