consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
296 rows where inchi_id = 39
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 11365 | 11365 | 3463 3463 | 39 | 12 | 0.315527262662607 |
| 21222 | 21222 | 6263 6263 | 39 | 8 | 0.519685039370079 |
| 35149 | 35149 | 10422 10422 | 39 | 1 | 0.3125 |
| 97508 | 97508 | 34600 34600 | 39 | 8 | 0.519685039370079 |
| 191591 | 191591 | 68113 68113 | 39 | 15 | 0.419117647058824 |
| 192452 | 192452 | 68417 68417 | 39 | 1 | 0.3125 |
| 200613 | 200613 | 71285 71285 | 39 | 8 | 0.31413612565445 |
| 219792 | 219792 | 76122 76122 | 39 | 8 | 0.31413612565445 |
| 259726 | 259726 | 87951 87951 | 39 | 2 | 0.314285714285714 |
| 336490 | 336490 | 113427 113427 | 39 | 1 | 0.310344827586207 |
| 428968 | 428968 | 154566 154566 | 39 | 8 | 0.31413612565445 |
| 446654 | 446654 | 160025 160025 | 39 | 1 | 0.310344827586207 |
| 516117 | 516117 | 206824 206824 | 39 | 8 | 0.31413612565445 |
| 516124 | 516124 | 206825 206825 | 39 | 8 | 0.31413612565445 |
| 516131 | 516131 | 206826 206826 | 39 | 7 | 0.4125 |
| 516135 | 516135 | 206827 206827 | 39 | 8 | 0.31413612565445 |
| 523482 | 523482 | 208711 208711 | 39 | 2 | 0.314285714285714 |
| 523484 | 523484 | 208712 208712 | 39 | 2 | 0.314285714285714 |
| 575303 | 575303 | 225369 225369 | 39 | 1 | 0.310344827586207 |
| 596486 | 596486 | 232209 232209 | 39 | 8 | 0.31413612565445 |
| 596903 | 596903 | 235263 235263 | 39 | 8 | 0.31413612565445 |
| 596910 | 596910 | 235264 235264 | 39 | 11 | 0.272531675830743 |
| 669297 | 669297 | 239755 239755 | 39 | 8 | 0.519685039370079 |
| 688209 | 688209 | 245431 245431 | 39 | 1 | 0.3125 |
| 738102 | 738102 | 260209 260209 | 39 | 8 | 0.519685039370079 |
| 738105 | 738105 | 260210 260210 | 39 | 8 | 0.31413612565445 |
| 747622 | 747622 | 262915 262915 | 39 | 1 | 0.0985221674876847 |
| 772114 | 772114 | 270145 270145 | 39 | 1 | 0.139211136890951 |
| 782285 | 782285 | 273531 273531 | 39 | 1 | 0.099009900990099 |
| 782291 | 782291 | 273532 273532 | 39 | 1 | 0.099009900990099 |
| 783949 | 783949 | 274032 274032 | 39 | 1 | 0.0987876066457117 |
| 784611 | 784611 | 274256 274256 | 39 | 1 | 0.0985221674876847 |
| 785527 | 785527 | 274515 274515 | 39 | 1 | 0.0685834872065418 |
| 785640 | 785640 | 274547 274547 | 39 | 1 | 0.0985221674876847 |
| 786764 | 786764 | 274832 274832 | 39 | 1 | 0.139211136890951 |
| 786902 | 786902 | 274840 274840 | 39 | 1 | 0.099009900990099 |
| 786908 | 786908 | 274841 274841 | 39 | 1 | 0.099009900990099 |
| 789512 | 789512 | 275729 275729 | 39 | 1 | 0.0985221674876847 |
| 789519 | 789519 | 275731 275731 | 39 | 1 | 0.0863500498173364 |
| 792149 | 792149 | 276546 276546 | 39 | 1 | 0.0985221674876847 |
| 804996 | 804996 | 280525 280525 | 39 | 1 | 0.0991987790919496 |
| 806687 | 806687 | 280947 280947 | 39 | 1 | 0.0862068965517241 |
| 814466 | 814466 | 283041 283041 | 39 | 1 | 0.0985221674876847 |
| 814472 | 814472 | 283042 283042 | 39 | 1 | 0.0985221674876847 |
| 851700 | 851700 | 294707 294707 | 39 | 1 | 0.139211136890951 |
| 851705 | 851705 | 294708 294708 | 39 | 1 | 0.139211136890951 |
| 854681 | 854681 | 295625 295625 | 39 | 1 | 0.139211136890951 |
| 862059 | 862059 | 297970 297970 | 39 | 1 | 0.3 |
| 925095 | 925095 | 328804 328804 | 39 | 4 | 0.506024096385542 |
| 925114 | 925114 | 328810 328810 | 39 | 3 | 0.690983005625053 |
| 944717 | 944717 | 338336 338336 | 39 | 1 | 0.0993218909560183 |
| 968436 | 968436 | 351485 351485 | 39 | 8 | 0.519685039370079 |
| 968439 | 968439 | 351486 351486 | 39 | 8 | 0.519685039370079 |
| 968442 | 968442 | 351487 351487 | 39 | 8 | 0.519685039370079 |
| 968445 | 968445 | 351488 351488 | 39 | 8 | 0.519685039370079 |
| 968448 | 968448 | 351489 351489 | 39 | 8 | 0.519685039370079 |
| 968451 | 968451 | 351490 351490 | 39 | 8 | 0.519685039370079 |
| 968454 | 968454 | 351491 351491 | 39 | 8 | 0.519685039370079 |
| 968457 | 968457 | 351492 351492 | 39 | 8 | 0.519685039370079 |
| 968460 | 968460 | 351493 351493 | 39 | 8 | 0.519685039370079 |
| 968463 | 968463 | 351494 351494 | 39 | 8 | 0.519685039370079 |
| 968466 | 968466 | 351495 351495 | 39 | 8 | 0.519685039370079 |
| 968469 | 968469 | 351496 351496 | 39 | 8 | 0.519685039370079 |
| 968472 | 968472 | 351497 351497 | 39 | 8 | 0.519685039370079 |
| 968475 | 968475 | 351498 351498 | 39 | 8 | 0.519685039370079 |
| 968478 | 968478 | 351499 351499 | 39 | 8 | 0.519685039370079 |
| 968481 | 968481 | 351500 351500 | 39 | 8 | 0.519685039370079 |
| 968484 | 968484 | 351501 351501 | 39 | 8 | 0.519685039370079 |
| 968487 | 968487 | 351502 351502 | 39 | 8 | 0.519685039370079 |
| 968490 | 968490 | 351503 351503 | 39 | 8 | 0.519685039370079 |
| 968493 | 968493 | 351504 351504 | 39 | 8 | 0.519685039370079 |
| 968496 | 968496 | 351505 351505 | 39 | 8 | 0.519685039370079 |
| 968499 | 968499 | 351506 351506 | 39 | 8 | 0.519685039370079 |
| 968502 | 968502 | 351507 351507 | 39 | 8 | 0.519685039370079 |
| 968505 | 968505 | 351508 351508 | 39 | 8 | 0.519685039370079 |
| 968508 | 968508 | 351509 351509 | 39 | 8 | 0.519685039370079 |
| 968511 | 968511 | 351510 351510 | 39 | 8 | 0.519685039370079 |
| 968514 | 968514 | 351511 351511 | 39 | 8 | 0.519685039370079 |
| 968517 | 968517 | 351512 351512 | 39 | 8 | 0.519685039370079 |
| 968520 | 968520 | 351513 351513 | 39 | 8 | 0.519685039370079 |
| 968523 | 968523 | 351514 351514 | 39 | 8 | 0.519685039370079 |
| 968526 | 968526 | 351515 351515 | 39 | 8 | 0.519685039370079 |
| 968529 | 968529 | 351516 351516 | 39 | 8 | 0.519685039370079 |
| 968532 | 968532 | 351517 351517 | 39 | 8 | 0.519685039370079 |
| 968535 | 968535 | 351518 351518 | 39 | 8 | 0.519685039370079 |
| 968538 | 968538 | 351519 351519 | 39 | 8 | 0.519685039370079 |
| 968541 | 968541 | 351520 351520 | 39 | 8 | 0.519685039370079 |
| 968544 | 968544 | 351521 351521 | 39 | 8 | 0.519685039370079 |
| 968547 | 968547 | 351522 351522 | 39 | 8 | 0.519685039370079 |
| 968550 | 968550 | 351523 351523 | 39 | 8 | 0.519685039370079 |
| 968553 | 968553 | 351524 351524 | 39 | 8 | 0.519685039370079 |
| 968556 | 968556 | 351525 351525 | 39 | 8 | 0.519685039370079 |
| 968559 | 968559 | 351526 351526 | 39 | 8 | 0.519685039370079 |
| 968562 | 968562 | 351527 351527 | 39 | 8 | 0.519685039370079 |
| 968565 | 968565 | 351528 351528 | 39 | 8 | 0.519685039370079 |
| 968568 | 968568 | 351529 351529 | 39 | 8 | 0.519685039370079 |
| 968571 | 968571 | 351530 351530 | 39 | 8 | 0.519685039370079 |
| 968574 | 968574 | 351531 351531 | 39 | 8 | 0.519685039370079 |
| 968577 | 968577 | 351532 351532 | 39 | 8 | 0.519685039370079 |
| 968580 | 968580 | 351533 351533 | 39 | 8 | 0.519685039370079 |
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)
);