consensus_index

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

20 rows where inventory_id = 221328

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
563130 563130 221328 221328 4475 1 0.0236730486981896
563131 563131 221328 221328 9025 1 0.0434005892800142
563132 563132 221328 221328 36277 12 0.260403535680085
563133 563133 221328 221328 138629 4 0.0868011785600284
563134 563134 221328 221328 168814 4 0.130201767840043
563135 563135 221328 221328 189209 2 0.0368266211848682
563136 563136 221328 221328 216878 2 0.0582280007361962
563137 563137 221328 221328 232110 1 0.0260403535680085
563138 563138 221328 221328 238187 3 0.0428776396957072
563139 563139 221328 221328 240716 4 0.0457456235636475
563140 563140 221328 221328 243372 4 0.0480306474605313
563141 563141 221328 221328 289329 3 0.0312972406200944
563142 563142 221328 221328 291224 2 0.0217760376090068
563143 563143 221328 221328 292114 1 0.0186002525485775
563144 563144 221328 221328 294501 1 0.0217002946400071
563145 563145 221328 221328 296522 2 0.0186478845152967
563146 563146 221328 221328 308296 3 0.0214388198478536
563147 563147 221328 221328 309724 2 0.0163071019527328
563148 563148 221328 221328 320992 3 0.0249713789414476
563149 563149 221328 221328 343738 3 0.0186183638088498 
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)
);