consensus_index

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

20 rows where inventory_id = 499739

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1650142 1650142 499739 499739 37598 7 0.259217357535169
1650143 1650143 499739 499739 47895 3 0.129608678767585
1650144 1650144 499739 499739 75665 1 0.0185155255382264
1650145 1650145 499739 499739 120043 1 0.0144009643075094
1650146 1650146 499739 499739 136365 2 0.0289813816198253
1650147 1650147 499739 499739 146241 1 0.0324021696918962
1650148 1650148 499739 499739 149807 2 0.0748296055757767
1650149 1650149 499739 499739 169215 2 0.105825043072293
1650150 1650150 499739 499739 169433 2 0.0386418421597671
1650151 1650151 499739 499739 169454 1 0.0432028929225282
1650152 1650152 499739 499739 169542 1 0.023565214321379
1650153 1650153 499739 499739 169543 1 0.0259217357535169
1650154 1650154 499739 499739 184623 1 0.0199397967334746
1650155 1650155 499739 499739 185082 1 0.0172811571690113
1650156 1650156 499739 499739 188244 2 0.0352750143574309
1650157 1650157 499739 499739 198596 1 0.0216014464612641
1650158 1650158 499739 499739 217708 1 0.0370310510764528
1650159 1650159 499739 499739 236990 1 0.0162010848459481
1650160 1650160 499739 499739 271778 2 0.0265951397315801
1650161 1650161 499739 499739 271837 2 0.0237624162056114 
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)
);