consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
87 rows where inchi_id = 154200
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 40805 | 40805 | 12374 12374 | 154200 | 1 | 0.141766630316249 |
| 102412 | 102412 | 36078 36078 | 154200 | 1 | 0.141766630316249 |
| 141236 | 141236 | 50346 50346 | 154200 | 1 | 0.140845070422535 |
| 284426 | 284426 | 96440 96440 | 154200 | 1 | 0.124164278892073 |
| 455799 | 455799 | 163771 163771 | 154200 | 1 | 0.141766630316249 |
| 502086 | 502086 | 200346 200346 | 154200 | 1 | 0.145480500279263 |
| 554732 | 554732 | 218737 218737 | 154200 | 1 | 0.140845070422535 |
| 710715 | 710715 | 252101 252101 | 154200 | 1 | 0.141766630316249 |
| 810271 | 810271 | 282057 282057 | 154200 | 1 | 0.140845070422535 |
| 810278 | 810278 | 282058 282058 | 154200 | 1 | 0.140845070422535 |
| 810285 | 810285 | 282059 282059 | 154200 | 1 | 0.140845070422535 |
| 810292 | 810292 | 282060 282060 | 154200 | 1 | 0.141766630316249 |
| 810299 | 810299 | 282061 282061 | 154200 | 1 | 0.141987829614604 |
| 810312 | 810312 | 282062 282062 | 154200 | 1 | 0.0696459663377829 |
| 810320 | 810320 | 282063 282063 | 154200 | 2 | 0.132890365448505 |
| 883121 | 883121 | 307160 307160 | 154200 | 1 | 0.140845070422535 |
| 1063146 | 1063146 | 375256 375256 | 154200 | 1 | 0.140845070422535 |
| 1063153 | 1063153 | 375257 375257 | 154200 | 1 | 0.140845070422535 |
| 1063160 | 1063160 | 375258 375258 | 154200 | 1 | 0.140845070422535 |
| 1063167 | 1063167 | 375259 375259 | 154200 | 1 | 0.140845070422535 |
| 1063174 | 1063174 | 375260 375260 | 154200 | 1 | 0.140845070422535 |
| 1063181 | 1063181 | 375261 375261 | 154200 | 1 | 0.140845070422535 |
| 1063188 | 1063188 | 375262 375262 | 154200 | 1 | 0.140845070422535 |
| 1063195 | 1063195 | 375263 375263 | 154200 | 1 | 0.140845070422535 |
| 1063202 | 1063202 | 375264 375264 | 154200 | 1 | 0.140845070422535 |
| 1063209 | 1063209 | 375265 375265 | 154200 | 1 | 0.140845070422535 |
| 1063216 | 1063216 | 375266 375266 | 154200 | 1 | 0.140845070422535 |
| 1063223 | 1063223 | 375267 375267 | 154200 | 1 | 0.140845070422535 |
| 1063230 | 1063230 | 375268 375268 | 154200 | 1 | 0.140845070422535 |
| 1063237 | 1063237 | 375269 375269 | 154200 | 1 | 0.140845070422535 |
| 1063244 | 1063244 | 375270 375270 | 154200 | 1 | 0.140845070422535 |
| 1063251 | 1063251 | 375271 375271 | 154200 | 1 | 0.140845070422535 |
| 1063258 | 1063258 | 375272 375272 | 154200 | 1 | 0.140845070422535 |
| 1063265 | 1063265 | 375273 375273 | 154200 | 1 | 0.140845070422535 |
| 1063272 | 1063272 | 375274 375274 | 154200 | 1 | 0.140845070422535 |
| 1063279 | 1063279 | 375275 375275 | 154200 | 1 | 0.140845070422535 |
| 1063286 | 1063286 | 375276 375276 | 154200 | 1 | 0.140845070422535 |
| 1063293 | 1063293 | 375277 375277 | 154200 | 1 | 0.140845070422535 |
| 1063300 | 1063300 | 375278 375278 | 154200 | 1 | 0.140845070422535 |
| 1063307 | 1063307 | 375279 375279 | 154200 | 1 | 0.140845070422535 |
| 1063314 | 1063314 | 375280 375280 | 154200 | 1 | 0.140845070422535 |
| 1063321 | 1063321 | 375281 375281 | 154200 | 1 | 0.140845070422535 |
| 1287043 | 1287043 | 422970 422970 | 154200 | 1 | 0.140845070422535 |
| 1287050 | 1287050 | 422971 422971 | 154200 | 1 | 0.140845070422535 |
| 1287057 | 1287057 | 422972 422972 | 154200 | 1 | 0.140845070422535 |
| 1287064 | 1287064 | 422973 422973 | 154200 | 1 | 0.140845070422535 |
| 1287071 | 1287071 | 422974 422974 | 154200 | 1 | 0.140845070422535 |
| 1287078 | 1287078 | 422975 422975 | 154200 | 1 | 0.140845070422535 |
| 1287085 | 1287085 | 422976 422976 | 154200 | 1 | 0.140845070422535 |
| 1287092 | 1287092 | 422977 422977 | 154200 | 1 | 0.140845070422535 |
| 1287099 | 1287099 | 422978 422978 | 154200 | 1 | 0.140845070422535 |
| 1287106 | 1287106 | 422979 422979 | 154200 | 1 | 0.140845070422535 |
| 1287113 | 1287113 | 422980 422980 | 154200 | 1 | 0.140845070422535 |
| 1287120 | 1287120 | 422981 422981 | 154200 | 1 | 0.140845070422535 |
| 1287127 | 1287127 | 422982 422982 | 154200 | 1 | 0.140845070422535 |
| 1287134 | 1287134 | 422983 422983 | 154200 | 1 | 0.140845070422535 |
| 1287141 | 1287141 | 422984 422984 | 154200 | 1 | 0.140845070422535 |
| 1287148 | 1287148 | 422985 422985 | 154200 | 1 | 0.140845070422535 |
| 1287155 | 1287155 | 422986 422986 | 154200 | 1 | 0.140845070422535 |
| 1287162 | 1287162 | 422987 422987 | 154200 | 1 | 0.140845070422535 |
| 1287169 | 1287169 | 422988 422988 | 154200 | 1 | 0.140845070422535 |
| 1287176 | 1287176 | 422989 422989 | 154200 | 1 | 0.140845070422535 |
| 1287183 | 1287183 | 422990 422990 | 154200 | 1 | 0.140845070422535 |
| 1287190 | 1287190 | 422991 422991 | 154200 | 1 | 0.140845070422535 |
| 1287197 | 1287197 | 422992 422992 | 154200 | 1 | 0.140845070422535 |
| 1287204 | 1287204 | 422993 422993 | 154200 | 1 | 0.140845070422535 |
| 1287211 | 1287211 | 422994 422994 | 154200 | 1 | 0.140845070422535 |
| 1287218 | 1287218 | 422995 422995 | 154200 | 1 | 0.140845070422535 |
| 1287225 | 1287225 | 422996 422996 | 154200 | 1 | 0.140845070422535 |
| 1287232 | 1287232 | 422997 422997 | 154200 | 1 | 0.140845070422535 |
| 1287239 | 1287239 | 422998 422998 | 154200 | 1 | 0.140845070422535 |
| 1287246 | 1287246 | 422999 422999 | 154200 | 1 | 0.140845070422535 |
| 1287253 | 1287253 | 423000 423000 | 154200 | 1 | 0.140845070422535 |
| 1501304 | 1501304 | 464371 464371 | 154200 | 1 | 0.140845070422535 |
| 1501311 | 1501311 | 464372 464372 | 154200 | 1 | 0.140845070422535 |
| 1501318 | 1501318 | 464373 464373 | 154200 | 1 | 0.140845070422535 |
| 1501325 | 1501325 | 464374 464374 | 154200 | 1 | 0.140845070422535 |
| 1501332 | 1501332 | 464375 464375 | 154200 | 1 | 0.140845070422535 |
| 1501339 | 1501339 | 464376 464376 | 154200 | 1 | 0.140845070422535 |
| 1501346 | 1501346 | 464377 464377 | 154200 | 1 | 0.140845070422535 |
| 1501353 | 1501353 | 464378 464378 | 154200 | 1 | 0.140845070422535 |
| 1501360 | 1501360 | 464379 464379 | 154200 | 1 | 0.140845070422535 |
| 1501367 | 1501367 | 464380 464380 | 154200 | 1 | 0.140845070422535 |
| 1501374 | 1501374 | 464381 464381 | 154200 | 1 | 0.140845070422535 |
| 1600759 | 1600759 | 483563 483563 | 154200 | 1 | 0.140845070422535 |
| 1647224 | 1647224 | 498775 498775 | 154200 | 1 | 0.140845070422535 |
| 1736661 | 1736661 | 532022 532022 | 154200 | 1 | 0.141766630316249 |
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)
);