consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
110 rows where inchi_id = 19023
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 4736 | 4736 | 1442 1442 | 19023 | 2 | 0.0812093837711256 |
| 45977 | 45977 | 14015 14015 | 19023 | 1 | 0.113575414678218 |
| 108558 | 108558 | 38067 38067 | 19023 | 1 | 0.103374966061747 |
| 191350 | 191350 | 68071 68071 | 19023 | 1 | 0.0999705287340702 |
| 199478 | 199478 | 70962 70962 | 19023 | 1 | 0.153059285823108 |
| 297451 | 297451 | 100582 100582 | 19023 | 1 | 0.152610086000557 |
| 324354 | 324354 | 109283 109283 | 19023 | 1 | 0.466666666666667 |
| 460425 | 460425 | 165498 165498 | 19023 | 1 | 0.152610086000557 |
| 525599 | 525599 | 209259 209259 | 19023 | 1 | 0.152610086000557 |
| 525603 | 525603 | 209260 209260 | 19023 | 1 | 0.158823575646609 |
| 525607 | 525607 | 209261 209261 | 19023 | 1 | 0.144306340826157 |
| 539426 | 539426 | 213829 213829 | 19023 | 1 | 0.152610086000557 |
| 573735 | 573735 | 224813 224813 | 19023 | 2 | 0.470588235294118 |
| 665740 | 665740 | 238411 238411 | 19023 | 1 | 0.153059285823108 |
| 665744 | 665744 | 238412 238412 | 19023 | 1 | 0.153059285823108 |
| 665748 | 665748 | 238413 238413 | 19023 | 2 | 0.102376962841454 |
| 727908 | 727908 | 256969 256969 | 19023 | 1 | 0.103374966061747 |
| 841857 | 841857 | 291834 291834 | 19023 | 1 | 0.103374966061747 |
| 841863 | 841863 | 291835 291835 | 19023 | 1 | 0.155879405572427 |
| 841867 | 841867 | 291836 291836 | 19023 | 1 | 0.153059285823108 |
| 841871 | 841871 | 291837 291837 | 19023 | 2 | 0.102376962841454 |
| 841879 | 841879 | 291838 291838 | 19023 | 1 | 0.158823575646609 |
| 946391 | 946391 | 339106 339106 | 19023 | 1 | 0.158823575646609 |
| 1152349 | 1152349 | 388437 388437 | 19023 | 1 | 0.113575414678218 |
| 1152354 | 1152354 | 388438 388438 | 19023 | 1 | 0.113575414678218 |
| 1152359 | 1152359 | 388439 388439 | 19023 | 1 | 0.113575414678218 |
| 1152364 | 1152364 | 388440 388440 | 19023 | 1 | 0.113575414678218 |
| 1152369 | 1152369 | 388441 388441 | 19023 | 1 | 0.113575414678218 |
| 1152374 | 1152374 | 388442 388442 | 19023 | 1 | 0.113575414678218 |
| 1152379 | 1152379 | 388443 388443 | 19023 | 1 | 0.113575414678218 |
| 1152384 | 1152384 | 388444 388444 | 19023 | 1 | 0.113575414678218 |
| 1152389 | 1152389 | 388445 388445 | 19023 | 1 | 0.113575414678218 |
| 1152394 | 1152394 | 388446 388446 | 19023 | 1 | 0.113575414678218 |
| 1152399 | 1152399 | 388447 388447 | 19023 | 1 | 0.113575414678218 |
| 1152404 | 1152404 | 388448 388448 | 19023 | 1 | 0.113575414678218 |
| 1152409 | 1152409 | 388449 388449 | 19023 | 1 | 0.113575414678218 |
| 1152414 | 1152414 | 388450 388450 | 19023 | 1 | 0.113575414678218 |
| 1152419 | 1152419 | 388451 388451 | 19023 | 1 | 0.113575414678218 |
| 1152424 | 1152424 | 388452 388452 | 19023 | 1 | 0.113575414678218 |
| 1152429 | 1152429 | 388453 388453 | 19023 | 1 | 0.113575414678218 |
| 1152434 | 1152434 | 388454 388454 | 19023 | 1 | 0.113575414678218 |
| 1152439 | 1152439 | 388455 388455 | 19023 | 1 | 0.113575414678218 |
| 1152444 | 1152444 | 388456 388456 | 19023 | 1 | 0.113575414678218 |
| 1152449 | 1152449 | 388457 388457 | 19023 | 1 | 0.113575414678218 |
| 1152454 | 1152454 | 388458 388458 | 19023 | 1 | 0.113575414678218 |
| 1152459 | 1152459 | 388459 388459 | 19023 | 1 | 0.113575414678218 |
| 1403430 | 1403430 | 438994 438994 | 19023 | 1 | 0.113575414678218 |
| 1403435 | 1403435 | 438995 438995 | 19023 | 1 | 0.113575414678218 |
| 1403440 | 1403440 | 438996 438996 | 19023 | 1 | 0.113575414678218 |
| 1403445 | 1403445 | 438997 438997 | 19023 | 1 | 0.113575414678218 |
| 1403450 | 1403450 | 438998 438998 | 19023 | 1 | 0.113575414678218 |
| 1403455 | 1403455 | 438999 438999 | 19023 | 1 | 0.113575414678218 |
| 1403460 | 1403460 | 439000 439000 | 19023 | 1 | 0.113575414678218 |
| 1403465 | 1403465 | 439001 439001 | 19023 | 1 | 0.113575414678218 |
| 1403470 | 1403470 | 439002 439002 | 19023 | 1 | 0.113575414678218 |
| 1403475 | 1403475 | 439003 439003 | 19023 | 1 | 0.113575414678218 |
| 1403480 | 1403480 | 439004 439004 | 19023 | 1 | 0.113575414678218 |
| 1403485 | 1403485 | 439005 439005 | 19023 | 1 | 0.113575414678218 |
| 1403490 | 1403490 | 439006 439006 | 19023 | 1 | 0.113575414678218 |
| 1403495 | 1403495 | 439007 439007 | 19023 | 1 | 0.113575414678218 |
| 1403500 | 1403500 | 439008 439008 | 19023 | 1 | 0.113575414678218 |
| 1403505 | 1403505 | 439009 439009 | 19023 | 1 | 0.113575414678218 |
| 1403510 | 1403510 | 439010 439010 | 19023 | 1 | 0.113575414678218 |
| 1403515 | 1403515 | 439011 439011 | 19023 | 1 | 0.113575414678218 |
| 1403520 | 1403520 | 439012 439012 | 19023 | 1 | 0.113575414678218 |
| 1403525 | 1403525 | 439013 439013 | 19023 | 1 | 0.113575414678218 |
| 1403530 | 1403530 | 439014 439014 | 19023 | 1 | 0.113575414678218 |
| 1403535 | 1403535 | 439015 439015 | 19023 | 1 | 0.113575414678218 |
| 1403540 | 1403540 | 439016 439016 | 19023 | 1 | 0.113575414678218 |
| 1403545 | 1403545 | 439017 439017 | 19023 | 1 | 0.113575414678218 |
| 1403550 | 1403550 | 439018 439018 | 19023 | 1 | 0.113575414678218 |
| 1403555 | 1403555 | 439019 439019 | 19023 | 1 | 0.113575414678218 |
| 1403560 | 1403560 | 439020 439020 | 19023 | 1 | 0.113575414678218 |
| 1403565 | 1403565 | 439021 439021 | 19023 | 1 | 0.113575414678218 |
| 1403570 | 1403570 | 439022 439022 | 19023 | 1 | 0.113575414678218 |
| 1403575 | 1403575 | 439023 439023 | 19023 | 1 | 0.113575414678218 |
| 1403580 | 1403580 | 439024 439024 | 19023 | 1 | 0.113575414678218 |
| 1403585 | 1403585 | 439025 439025 | 19023 | 1 | 0.113575414678218 |
| 1403590 | 1403590 | 439026 439026 | 19023 | 1 | 0.113575414678218 |
| 1403595 | 1403595 | 439027 439027 | 19023 | 1 | 0.113575414678218 |
| 1403600 | 1403600 | 439028 439028 | 19023 | 1 | 0.113575414678218 |
| 1403605 | 1403605 | 439029 439029 | 19023 | 1 | 0.113575414678218 |
| 1403610 | 1403610 | 439030 439030 | 19023 | 1 | 0.113575414678218 |
| 1403615 | 1403615 | 439031 439031 | 19023 | 1 | 0.113575414678218 |
| 1403620 | 1403620 | 439032 439032 | 19023 | 1 | 0.113575414678218 |
| 1403625 | 1403625 | 439033 439033 | 19023 | 1 | 0.113575414678218 |
| 1403630 | 1403630 | 439034 439034 | 19023 | 1 | 0.113575414678218 |
| 1403635 | 1403635 | 439035 439035 | 19023 | 1 | 0.113575414678218 |
| 1570099 | 1570099 | 474516 474516 | 19023 | 1 | 0.113575414678218 |
| 1570104 | 1570104 | 474517 474517 | 19023 | 1 | 0.113575414678218 |
| 1570109 | 1570109 | 474518 474518 | 19023 | 1 | 0.113575414678218 |
| 1570114 | 1570114 | 474519 474519 | 19023 | 1 | 0.113575414678218 |
| 1570119 | 1570119 | 474520 474520 | 19023 | 1 | 0.113575414678218 |
| 1570124 | 1570124 | 474521 474521 | 19023 | 1 | 0.113575414678218 |
| 1570129 | 1570129 | 474522 474522 | 19023 | 1 | 0.113575414678218 |
| 1570134 | 1570134 | 474523 474523 | 19023 | 1 | 0.113575414678218 |
| 1570139 | 1570139 | 474524 474524 | 19023 | 1 | 0.113575414678218 |
| 1570144 | 1570144 | 474525 474525 | 19023 | 1 | 0.113575414678218 |
| 1570149 | 1570149 | 474526 474526 | 19023 | 1 | 0.113575414678218 |
| 1570154 | 1570154 | 474527 474527 | 19023 | 1 | 0.113575414678218 |
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)
);