consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
127 rows where inchi_id = 49123
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 3108 | 3108 | 882 882 | 49123 | 9 | 0.270701643776996 |
| 8321 | 8321 | 2518 2518 | 49123 | 1 | 0.3125 |
| 8324 | 8324 | 2519 2519 | 49123 | 1 | 0.2510567450641 |
| 22298 | 22298 | 6559 6559 | 49123 | 1 | 0.2510567450641 |
| 26305 | 26305 | 7695 7695 | 49123 | 1 | 0.3125 |
| 40581 | 40581 | 12296 12296 | 49123 | 6 | 0.359080848025192 |
| 85476 | 85476 | 30730 30730 | 49123 | 6 | 0.359080848025192 |
| 85478 | 85478 | 30731 30731 | 49123 | 1 | 0.3125 |
| 85481 | 85481 | 30732 30732 | 49123 | 1 | 0.2510567450641 |
| 139498 | 139498 | 49697 49697 | 49123 | 1 | 0.3125 |
| 139501 | 139501 | 49698 49698 | 49123 | 1 | 0.2510567450641 |
| 139505 | 139505 | 49699 49699 | 49123 | 9 | 0.270701643776996 |
| 202397 | 202397 | 71750 71750 | 49123 | 6 | 0.26947293832624 |
| 221308 | 221308 | 76587 76587 | 49123 | 1 | 0.257142857142857 |
| 228220 | 228220 | 78447 78447 | 49123 | 2 | 0.310344827586207 |
| 283384 | 283384 | 96092 96092 | 49123 | 6 | 0.26947293832624 |
| 430048 | 430048 | 154882 154882 | 49123 | 1 | 0.257142857142857 |
| 434576 | 434576 | 156134 156134 | 49123 | 2 | 0.310344827586207 |
| 503096 | 503096 | 201361 201361 | 49123 | 3 | 0.266569063578951 |
| 524469 | 524469 | 209025 209025 | 49123 | 6 | 0.26947293832624 |
| 555628 | 555628 | 218995 218995 | 49123 | 6 | 0.26947293832624 |
| 662997 | 662997 | 237721 237721 | 49123 | 6 | 0.26947293832624 |
| 672259 | 672259 | 240535 240535 | 49123 | 2 | 0.261744966442953 |
| 684111 | 684111 | 244103 244103 | 49123 | 2 | 0.314285714285714 |
| 709854 | 709854 | 251867 251867 | 49123 | 9 | 0.270701643776996 |
| 743944 | 743944 | 261854 261854 | 49123 | 1 | 0.253012048192771 |
| 743947 | 743947 | 261855 261855 | 49123 | 2 | 0.261744966442953 |
| 743950 | 743950 | 261856 261856 | 49123 | 1 | 0.2510567450641 |
| 743953 | 743953 | 261857 261857 | 49123 | 1 | 0.253012048192771 |
| 743956 | 743956 | 261858 261858 | 49123 | 2 | 0.214886757703598 |
| 766105 | 766105 | 268278 268278 | 49123 | 2 | 0.314285714285714 |
| 766107 | 766107 | 268279 268279 | 49123 | 1 | 0.3 |
| 808745 | 808745 | 281579 281579 | 49123 | 6 | 0.359080848025192 |
| 808748 | 808748 | 281580 281580 | 49123 | 7 | 0.345940642084653 |
| 808752 | 808752 | 281581 281581 | 49123 | 6 | 0.26947293832624 |
| 860674 | 860674 | 297636 297636 | 49123 | 1 | 0.3 |
| 978803 | 978803 | 353737 353737 | 49123 | 2 | 0.261744966442953 |
| 1030540 | 1030540 | 365734 365734 | 49123 | 2 | 0.314285714285714 |
| 1061369 | 1061369 | 374841 374841 | 49123 | 6 | 0.359080848025192 |
| 1061372 | 1061372 | 374842 374842 | 49123 | 6 | 0.359080848025192 |
| 1061375 | 1061375 | 374843 374843 | 49123 | 6 | 0.359080848025192 |
| 1061378 | 1061378 | 374844 374844 | 49123 | 6 | 0.359080848025192 |
| 1061381 | 1061381 | 374845 374845 | 49123 | 6 | 0.359080848025192 |
| 1061384 | 1061384 | 374846 374846 | 49123 | 6 | 0.359080848025192 |
| 1061387 | 1061387 | 374847 374847 | 49123 | 6 | 0.359080848025192 |
| 1061390 | 1061390 | 374848 374848 | 49123 | 6 | 0.359080848025192 |
| 1061393 | 1061393 | 374849 374849 | 49123 | 6 | 0.359080848025192 |
| 1061396 | 1061396 | 374850 374850 | 49123 | 6 | 0.359080848025192 |
| 1061399 | 1061399 | 374851 374851 | 49123 | 6 | 0.359080848025192 |
| 1061402 | 1061402 | 374852 374852 | 49123 | 6 | 0.359080848025192 |
| 1061405 | 1061405 | 374853 374853 | 49123 | 6 | 0.359080848025192 |
| 1061408 | 1061408 | 374854 374854 | 49123 | 6 | 0.359080848025192 |
| 1061411 | 1061411 | 374855 374855 | 49123 | 6 | 0.359080848025192 |
| 1061414 | 1061414 | 374856 374856 | 49123 | 6 | 0.359080848025192 |
| 1061417 | 1061417 | 374857 374857 | 49123 | 6 | 0.359080848025192 |
| 1061420 | 1061420 | 374858 374858 | 49123 | 6 | 0.359080848025192 |
| 1061423 | 1061423 | 374859 374859 | 49123 | 6 | 0.359080848025192 |
| 1061426 | 1061426 | 374860 374860 | 49123 | 6 | 0.359080848025192 |
| 1061429 | 1061429 | 374861 374861 | 49123 | 6 | 0.359080848025192 |
| 1061432 | 1061432 | 374862 374862 | 49123 | 6 | 0.359080848025192 |
| 1061435 | 1061435 | 374863 374863 | 49123 | 6 | 0.359080848025192 |
| 1061438 | 1061438 | 374864 374864 | 49123 | 6 | 0.359080848025192 |
| 1061441 | 1061441 | 374865 374865 | 49123 | 6 | 0.359080848025192 |
| 1061444 | 1061444 | 374866 374866 | 49123 | 6 | 0.359080848025192 |
| 1061447 | 1061447 | 374867 374867 | 49123 | 6 | 0.359080848025192 |
| 1061450 | 1061450 | 374868 374868 | 49123 | 6 | 0.359080848025192 |
| 1061453 | 1061453 | 374869 374869 | 49123 | 6 | 0.359080848025192 |
| 1061456 | 1061456 | 374870 374870 | 49123 | 6 | 0.359080848025192 |
| 1061459 | 1061459 | 374871 374871 | 49123 | 6 | 0.359080848025192 |
| 1061462 | 1061462 | 374872 374872 | 49123 | 6 | 0.359080848025192 |
| 1061465 | 1061465 | 374873 374873 | 49123 | 6 | 0.359080848025192 |
| 1061468 | 1061468 | 374874 374874 | 49123 | 6 | 0.359080848025192 |
| 1061471 | 1061471 | 374875 374875 | 49123 | 6 | 0.359080848025192 |
| 1061474 | 1061474 | 374876 374876 | 49123 | 6 | 0.359080848025192 |
| 1061477 | 1061477 | 374877 374877 | 49123 | 6 | 0.359080848025192 |
| 1061480 | 1061480 | 374878 374878 | 49123 | 6 | 0.359080848025192 |
| 1061483 | 1061483 | 374879 374879 | 49123 | 6 | 0.359080848025192 |
| 1061486 | 1061486 | 374880 374880 | 49123 | 6 | 0.359080848025192 |
| 1061489 | 1061489 | 374881 374881 | 49123 | 6 | 0.359080848025192 |
| 1061492 | 1061492 | 374882 374882 | 49123 | 6 | 0.359080848025192 |
| 1061495 | 1061495 | 374883 374883 | 49123 | 6 | 0.359080848025192 |
| 1061498 | 1061498 | 374884 374884 | 49123 | 6 | 0.359080848025192 |
| 1061501 | 1061501 | 374885 374885 | 49123 | 6 | 0.359080848025192 |
| 1061504 | 1061504 | 374886 374886 | 49123 | 6 | 0.359080848025192 |
| 1061507 | 1061507 | 374887 374887 | 49123 | 6 | 0.359080848025192 |
| 1061510 | 1061510 | 374888 374888 | 49123 | 6 | 0.359080848025192 |
| 1061513 | 1061513 | 374889 374889 | 49123 | 6 | 0.359080848025192 |
| 1061516 | 1061516 | 374890 374890 | 49123 | 6 | 0.359080848025192 |
| 1061519 | 1061519 | 374891 374891 | 49123 | 6 | 0.359080848025192 |
| 1061522 | 1061522 | 374892 374892 | 49123 | 6 | 0.359080848025192 |
| 1187001 | 1187001 | 397653 397653 | 49123 | 2 | 0.261744966442953 |
| 1249028 | 1249028 | 411941 411941 | 49123 | 2 | 0.314285714285714 |
| 1285599 | 1285599 | 422606 422606 | 49123 | 6 | 0.359080848025192 |
| 1285602 | 1285602 | 422607 422607 | 49123 | 6 | 0.359080848025192 |
| 1285605 | 1285605 | 422608 422608 | 49123 | 6 | 0.359080848025192 |
| 1285608 | 1285608 | 422609 422609 | 49123 | 6 | 0.359080848025192 |
| 1285611 | 1285611 | 422610 422610 | 49123 | 6 | 0.359080848025192 |
| 1285614 | 1285614 | 422611 422611 | 49123 | 6 | 0.359080848025192 |
| 1285617 | 1285617 | 422612 422612 | 49123 | 6 | 0.359080848025192 |
| 1285620 | 1285620 | 422613 422613 | 49123 | 6 | 0.359080848025192 |
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)
);