consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
111 rows where inchi_id = 200190
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 33227 | 33227 | 9799 9799 | 200190 | 1 | 0.0693650297374967 |
| 33969 | 33969 | 10049 10049 | 200190 | 2 | 0.147438915605432 |
| 104333 | 104333 | 36778 36778 | 200190 | 1 | 0.0677225897116289 |
| 144926 | 144926 | 51666 51666 | 200190 | 3 | 0.096485318112918 |
| 190677 | 190677 | 67913 67913 | 200190 | 2 | 0.205551395584946 |
| 255149 | 255149 | 86622 86622 | 200190 | 1 | 0.0698698762000353 |
| 256493 | 256493 | 86999 86999 | 200190 | 2 | 0.130744839061932 |
| 303708 | 303708 | 102710 102710 | 200190 | 3 | 0.303329135150687 |
| 444539 | 444539 | 159359 159359 | 200190 | 1 | 0.0635432493333915 |
| 445486 | 445486 | 159616 159616 | 200190 | 2 | 0.130744839061932 |
| 463645 | 463645 | 166569 166569 | 200190 | 3 | 0.303329135150687 |
| 463959 | 463959 | 166686 166686 | 200190 | 1 | 0.196213125578806 |
| 501021 | 501021 | 199215 199215 | 200190 | 1 | 0.196213125578806 |
| 522813 | 522813 | 208541 208541 | 200190 | 1 | 0.0635432493333915 |
| 582744 | 582744 | 227834 227834 | 200190 | 2 | 0.130744839061932 |
| 584775 | 584775 | 228446 228446 | 200190 | 1 | 0.0698698762000353 |
| 591339 | 591339 | 230701 230701 | 200190 | 3 | 0.303329135150687 |
| 599600 | 599600 | 236280 236280 | 200190 | 2 | 0.100617057131831 |
| 679867 | 679867 | 242953 242953 | 200190 | 1 | 0.0679029254748506 |
| 681675 | 681675 | 243460 243460 | 200190 | 2 | 0.147438915605432 |
| 757875 | 757875 | 266136 266136 | 200190 | 2 | 0.100617057131831 |
| 757883 | 757883 | 266137 266137 | 200190 | 1 | 0.0677225897116289 |
| 932854 | 932854 | 332359 332359 | 200190 | 1 | 0.205179828463401 |
| 946251 | 946251 | 339041 339041 | 200190 | 2 | 0.630993034743972 |
| 1012268 | 1012268 | 361295 361295 | 200190 | 1 | 0.0677225897116289 |
| 1012275 | 1012275 | 361296 361296 | 200190 | 1 | 0.0677225897116289 |
| 1012282 | 1012282 | 361297 361297 | 200190 | 1 | 0.0677225897116289 |
| 1012289 | 1012289 | 361298 361298 | 200190 | 1 | 0.0677225897116289 |
| 1012296 | 1012296 | 361299 361299 | 200190 | 1 | 0.0677225897116289 |
| 1012303 | 1012303 | 361300 361300 | 200190 | 1 | 0.0677225897116289 |
| 1012310 | 1012310 | 361301 361301 | 200190 | 1 | 0.0677225897116289 |
| 1012317 | 1012317 | 361302 361302 | 200190 | 1 | 0.0677225897116289 |
| 1012324 | 1012324 | 361303 361303 | 200190 | 1 | 0.0677225897116289 |
| 1012331 | 1012331 | 361304 361304 | 200190 | 1 | 0.0677225897116289 |
| 1012338 | 1012338 | 361305 361305 | 200190 | 1 | 0.0677225897116289 |
| 1012345 | 1012345 | 361306 361306 | 200190 | 1 | 0.0677225897116289 |
| 1012352 | 1012352 | 361307 361307 | 200190 | 1 | 0.0677225897116289 |
| 1012359 | 1012359 | 361308 361308 | 200190 | 1 | 0.0677225897116289 |
| 1012366 | 1012366 | 361309 361309 | 200190 | 1 | 0.0677225897116289 |
| 1012373 | 1012373 | 361310 361310 | 200190 | 1 | 0.0677225897116289 |
| 1012380 | 1012380 | 361311 361311 | 200190 | 1 | 0.0677225897116289 |
| 1012387 | 1012387 | 361312 361312 | 200190 | 1 | 0.0677225897116289 |
| 1012394 | 1012394 | 361313 361313 | 200190 | 1 | 0.0677225897116289 |
| 1012401 | 1012401 | 361314 361314 | 200190 | 1 | 0.0677225897116289 |
| 1012408 | 1012408 | 361315 361315 | 200190 | 1 | 0.0677225897116289 |
| 1012415 | 1012415 | 361316 361316 | 200190 | 1 | 0.0677225897116289 |
| 1025933 | 1025933 | 364647 364647 | 200190 | 2 | 0.147438915605432 |
| 1225237 | 1225237 | 406267 406267 | 200190 | 1 | 0.0677225897116289 |
| 1225244 | 1225244 | 406268 406268 | 200190 | 1 | 0.0677225897116289 |
| 1225251 | 1225251 | 406269 406269 | 200190 | 1 | 0.0677225897116289 |
| 1225258 | 1225258 | 406270 406270 | 200190 | 1 | 0.0677225897116289 |
| 1225265 | 1225265 | 406271 406271 | 200190 | 1 | 0.0677225897116289 |
| 1225272 | 1225272 | 406272 406272 | 200190 | 1 | 0.0677225897116289 |
| 1225279 | 1225279 | 406273 406273 | 200190 | 1 | 0.0677225897116289 |
| 1225286 | 1225286 | 406274 406274 | 200190 | 1 | 0.0677225897116289 |
| 1225293 | 1225293 | 406275 406275 | 200190 | 1 | 0.0677225897116289 |
| 1225300 | 1225300 | 406276 406276 | 200190 | 1 | 0.0677225897116289 |
| 1225307 | 1225307 | 406277 406277 | 200190 | 1 | 0.0677225897116289 |
| 1225314 | 1225314 | 406278 406278 | 200190 | 1 | 0.0677225897116289 |
| 1225321 | 1225321 | 406279 406279 | 200190 | 1 | 0.0677225897116289 |
| 1225328 | 1225328 | 406280 406280 | 200190 | 1 | 0.0677225897116289 |
| 1225335 | 1225335 | 406281 406281 | 200190 | 1 | 0.0677225897116289 |
| 1225342 | 1225342 | 406282 406282 | 200190 | 1 | 0.0677225897116289 |
| 1225349 | 1225349 | 406283 406283 | 200190 | 1 | 0.0677225897116289 |
| 1225356 | 1225356 | 406284 406284 | 200190 | 1 | 0.0677225897116289 |
| 1225363 | 1225363 | 406285 406285 | 200190 | 1 | 0.0677225897116289 |
| 1225370 | 1225370 | 406286 406286 | 200190 | 1 | 0.0677225897116289 |
| 1225377 | 1225377 | 406287 406287 | 200190 | 1 | 0.0677225897116289 |
| 1225384 | 1225384 | 406288 406288 | 200190 | 1 | 0.0677225897116289 |
| 1225391 | 1225391 | 406289 406289 | 200190 | 1 | 0.0677225897116289 |
| 1225398 | 1225398 | 406290 406290 | 200190 | 1 | 0.0677225897116289 |
| 1225405 | 1225405 | 406291 406291 | 200190 | 1 | 0.0677225897116289 |
| 1225412 | 1225412 | 406292 406292 | 200190 | 1 | 0.0677225897116289 |
| 1225419 | 1225419 | 406293 406293 | 200190 | 1 | 0.0677225897116289 |
| 1225426 | 1225426 | 406294 406294 | 200190 | 1 | 0.0677225897116289 |
| 1225433 | 1225433 | 406295 406295 | 200190 | 1 | 0.0677225897116289 |
| 1225440 | 1225440 | 406296 406296 | 200190 | 1 | 0.0677225897116289 |
| 1225447 | 1225447 | 406297 406297 | 200190 | 1 | 0.0677225897116289 |
| 1225454 | 1225454 | 406298 406298 | 200190 | 1 | 0.0677225897116289 |
| 1225461 | 1225461 | 406299 406299 | 200190 | 1 | 0.0677225897116289 |
| 1225468 | 1225468 | 406300 406300 | 200190 | 1 | 0.0677225897116289 |
| 1225475 | 1225475 | 406301 406301 | 200190 | 1 | 0.0677225897116289 |
| 1225482 | 1225482 | 406302 406302 | 200190 | 1 | 0.0677225897116289 |
| 1243807 | 1243807 | 410726 410726 | 200190 | 2 | 0.147438915605432 |
| 1463588 | 1463588 | 453982 453982 | 200190 | 1 | 0.0677225897116289 |
| 1463595 | 1463595 | 453983 453983 | 200190 | 1 | 0.0677225897116289 |
| 1463602 | 1463602 | 453984 453984 | 200190 | 1 | 0.0677225897116289 |
| 1463609 | 1463609 | 453985 453985 | 200190 | 1 | 0.0677225897116289 |
| 1463616 | 1463616 | 453986 453986 | 200190 | 1 | 0.0677225897116289 |
| 1463623 | 1463623 | 453987 453987 | 200190 | 1 | 0.0677225897116289 |
| 1463630 | 1463630 | 453988 453988 | 200190 | 1 | 0.0677225897116289 |
| 1463637 | 1463637 | 453989 453989 | 200190 | 1 | 0.0677225897116289 |
| 1463644 | 1463644 | 453990 453990 | 200190 | 1 | 0.0677225897116289 |
| 1463651 | 1463651 | 453991 453991 | 200190 | 1 | 0.0677225897116289 |
| 1463658 | 1463658 | 453992 453992 | 200190 | 1 | 0.0677225897116289 |
| 1463665 | 1463665 | 453993 453993 | 200190 | 1 | 0.0677225897116289 |
| 1463672 | 1463672 | 453994 453994 | 200190 | 1 | 0.0677225897116289 |
| 1463679 | 1463679 | 453995 453995 | 200190 | 1 | 0.0677225897116289 |
| 1463686 | 1463686 | 453996 453996 | 200190 | 1 | 0.0677225897116289 |
| 1463693 | 1463693 | 453997 453997 | 200190 | 1 | 0.0677225897116289 |
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)
);