consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
454 rows where inchi_id = 185860
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 15333 | 15333 | 4737 4737 | 185860 | 1 | 0.0836653386454183 |
| 23496 | 23496 | 6871 6871 | 185860 | 3 | 0.296362819937135 |
| 78787 | 78787 | 28457 28457 | 185860 | 1 | 0.0836653386454183 |
| 93975 | 93975 | 33405 33405 | 185860 | 4 | 0.298507462686567 |
| 148071 | 148071 | 53281 53281 | 185860 | 2 | 0.050870359896128 |
| 148139 | 148139 | 53284 53284 | 185860 | 4 | 0.237342991446405 |
| 209712 | 209712 | 73889 73889 | 185860 | 1 | 0.0440059747910423 |
| 222871 | 222871 | 76991 76991 | 185860 | 4 | 0.298083747338538 |
| 422317 | 422317 | 153107 153107 | 185860 | 1 | 0.0440059747910423 |
| 431349 | 431349 | 155212 155212 | 185860 | 4 | 0.298083747338538 |
| 476213 | 476213 | 173492 173492 | 185860 | 2 | 0.332472184987301 |
| 479588 | 479588 | 175387 175387 | 185860 | 2 | 0.380952380952381 |
| 553704 | 553704 | 218483 218483 | 185860 | 1 | 0.0440059747910423 |
| 591750 | 591750 | 230820 230820 | 185860 | 2 | 0.295566502463054 |
| 663282 | 663282 | 237794 237794 | 185860 | 1 | 0.0440059747910423 |
| 663338 | 663338 | 237795 237795 | 185860 | 1 | 0.0644083114823969 |
| 674232 | 674232 | 241023 241023 | 185860 | 6 | 0.298507462686567 |
| 712420 | 712420 | 252491 252491 | 185860 | 1 | 0.0383803212371946 |
| 747847 | 747847 | 262964 262964 | 185860 | 4 | 0.297596337275849 |
| 747853 | 747853 | 262965 262965 | 185860 | 3 | 0.296362819937135 |
| 747859 | 747859 | 262966 262966 | 185860 | 4 | 0.297596337275849 |
| 783604 | 783604 | 273910 273910 | 185860 | 4 | 0.225848766212864 |
| 783614 | 783614 | 273911 273911 | 185860 | 4 | 0.289757516317978 |
| 783622 | 783622 | 273912 273912 | 185860 | 4 | 0.290335414030826 |
| 813221 | 813221 | 282802 282802 | 185860 | 1 | 0.0836653386454183 |
| 813225 | 813225 | 282803 282803 | 185860 | 1 | 0.113924050632911 |
| 813230 | 813230 | 282804 282804 | 185860 | 2 | 0.136420264182258 |
| 813234 | 813234 | 282805 282805 | 185860 | 1 | 0.115384615384615 |
| 813238 | 813238 | 282806 282806 | 185860 | 1 | 0.113924050632911 |
| 813273 | 813273 | 282807 282807 | 185860 | 1 | 0.0440059747910423 |
| 813328 | 813328 | 282808 282808 | 185860 | 1 | 0.113924050632911 |
| 868254 | 868254 | 299525 299525 | 185860 | 2 | 0.332472184987301 |
| 915042 | 915042 | 324067 324067 | 185860 | 2 | 0.630993034743972 |
| 915860 | 915860 | 324612 324612 | 185860 | 2 | 0.294599018003273 |
| 938909 | 938909 | 335514 335514 | 185860 | 1 | 0.113207547169811 |
| 1065163 | 1065163 | 375724 375724 | 185860 | 1 | 0.0836653386454183 |
| 1065169 | 1065169 | 375725 375725 | 185860 | 1 | 0.0836653386454183 |
| 1065175 | 1065175 | 375726 375726 | 185860 | 1 | 0.0836653386454183 |
| 1065181 | 1065181 | 375727 375727 | 185860 | 1 | 0.0836653386454183 |
| 1065187 | 1065187 | 375728 375728 | 185860 | 1 | 0.0836653386454183 |
| 1065193 | 1065193 | 375729 375729 | 185860 | 1 | 0.0836653386454183 |
| 1065199 | 1065199 | 375730 375730 | 185860 | 1 | 0.0836653386454183 |
| 1065205 | 1065205 | 375731 375731 | 185860 | 1 | 0.0836653386454183 |
| 1065211 | 1065211 | 375732 375732 | 185860 | 1 | 0.0836653386454183 |
| 1065217 | 1065217 | 375733 375733 | 185860 | 1 | 0.0836653386454183 |
| 1065223 | 1065223 | 375734 375734 | 185860 | 1 | 0.0836653386454183 |
| 1065229 | 1065229 | 375735 375735 | 185860 | 1 | 0.0836653386454183 |
| 1065235 | 1065235 | 375736 375736 | 185860 | 1 | 0.0836653386454183 |
| 1065241 | 1065241 | 375737 375737 | 185860 | 1 | 0.0836653386454183 |
| 1065247 | 1065247 | 375738 375738 | 185860 | 1 | 0.0836653386454183 |
| 1065253 | 1065253 | 375739 375739 | 185860 | 1 | 0.0836653386454183 |
| 1065259 | 1065259 | 375740 375740 | 185860 | 1 | 0.0836653386454183 |
| 1065265 | 1065265 | 375741 375741 | 185860 | 1 | 0.0836653386454183 |
| 1065271 | 1065271 | 375742 375742 | 185860 | 1 | 0.0836653386454183 |
| 1065277 | 1065277 | 375743 375743 | 185860 | 1 | 0.0836653386454183 |
| 1065283 | 1065283 | 375744 375744 | 185860 | 1 | 0.0836653386454183 |
| 1065289 | 1065289 | 375745 375745 | 185860 | 1 | 0.0836653386454183 |
| 1065295 | 1065295 | 375746 375746 | 185860 | 1 | 0.0836653386454183 |
| 1065301 | 1065301 | 375747 375747 | 185860 | 1 | 0.0836653386454183 |
| 1065307 | 1065307 | 375748 375748 | 185860 | 1 | 0.0836653386454183 |
| 1065313 | 1065313 | 375749 375749 | 185860 | 1 | 0.0836653386454183 |
| 1065319 | 1065319 | 375750 375750 | 185860 | 1 | 0.0836653386454183 |
| 1065325 | 1065325 | 375751 375751 | 185860 | 1 | 0.0836653386454183 |
| 1065331 | 1065331 | 375752 375752 | 185860 | 1 | 0.0836653386454183 |
| 1065337 | 1065337 | 375753 375753 | 185860 | 1 | 0.0836653386454183 |
| 1065343 | 1065343 | 375754 375754 | 185860 | 1 | 0.0836653386454183 |
| 1065349 | 1065349 | 375755 375755 | 185860 | 1 | 0.0836653386454183 |
| 1065355 | 1065355 | 375756 375756 | 185860 | 1 | 0.0836653386454183 |
| 1065361 | 1065361 | 375757 375757 | 185860 | 1 | 0.0836653386454183 |
| 1065367 | 1065367 | 375758 375758 | 185860 | 1 | 0.0836653386454183 |
| 1065373 | 1065373 | 375759 375759 | 185860 | 1 | 0.0836653386454183 |
| 1065379 | 1065379 | 375760 375760 | 185860 | 1 | 0.0836653386454183 |
| 1065385 | 1065385 | 375761 375761 | 185860 | 1 | 0.0836653386454183 |
| 1065391 | 1065391 | 375762 375762 | 185860 | 1 | 0.0836653386454183 |
| 1065397 | 1065397 | 375763 375763 | 185860 | 1 | 0.0836653386454183 |
| 1065403 | 1065403 | 375764 375764 | 185860 | 1 | 0.0836653386454183 |
| 1065409 | 1065409 | 375765 375765 | 185860 | 1 | 0.0836653386454183 |
| 1065415 | 1065415 | 375766 375766 | 185860 | 1 | 0.0836653386454183 |
| 1065421 | 1065421 | 375767 375767 | 185860 | 1 | 0.0836653386454183 |
| 1065427 | 1065427 | 375768 375768 | 185860 | 1 | 0.0836653386454183 |
| 1065433 | 1065433 | 375769 375769 | 185860 | 1 | 0.0836653386454183 |
| 1065439 | 1065439 | 375770 375770 | 185860 | 1 | 0.0836653386454183 |
| 1065445 | 1065445 | 375771 375771 | 185860 | 1 | 0.0836653386454183 |
| 1065451 | 1065451 | 375772 375772 | 185860 | 1 | 0.0836653386454183 |
| 1065457 | 1065457 | 375773 375773 | 185860 | 1 | 0.0836653386454183 |
| 1065463 | 1065463 | 375774 375774 | 185860 | 1 | 0.0836653386454183 |
| 1065469 | 1065469 | 375775 375775 | 185860 | 1 | 0.0836653386454183 |
| 1065475 | 1065475 | 375776 375776 | 185860 | 1 | 0.0836653386454183 |
| 1065481 | 1065481 | 375777 375777 | 185860 | 1 | 0.0836653386454183 |
| 1065487 | 1065487 | 375778 375778 | 185860 | 1 | 0.0836653386454183 |
| 1065493 | 1065493 | 375779 375779 | 185860 | 1 | 0.0836653386454183 |
| 1065499 | 1065499 | 375780 375780 | 185860 | 1 | 0.0836653386454183 |
| 1065505 | 1065505 | 375781 375781 | 185860 | 1 | 0.0836653386454183 |
| 1065511 | 1065511 | 375782 375782 | 185860 | 1 | 0.0836653386454183 |
| 1065517 | 1065517 | 375783 375783 | 185860 | 1 | 0.0836653386454183 |
| 1065523 | 1065523 | 375784 375784 | 185860 | 1 | 0.0836653386454183 |
| 1065529 | 1065529 | 375785 375785 | 185860 | 1 | 0.0836653386454183 |
| 1065535 | 1065535 | 375786 375786 | 185860 | 1 | 0.0836653386454183 |
| 1065541 | 1065541 | 375787 375787 | 185860 | 1 | 0.0836653386454183 |
| 1065547 | 1065547 | 375788 375788 | 185860 | 1 | 0.0836653386454183 |
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)
);