consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
106 rows where inchi_id = 7470
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 165 | 165 | 34 34 | 7470 | 12 | 0.336448598130841 |
| 25431 | 25431 | 7469 7469 | 7470 | 8 | 0.461538461538462 |
| 44968 | 44968 | 13747 13747 | 7470 | 1 | 0.3125 |
| 83614 | 83614 | 30095 30095 | 7470 | 1 | 0.3125 |
| 94382 | 94382 | 33507 33507 | 7470 | 8 | 0.461538461538462 |
| 133475 | 133475 | 47362 47362 | 7470 | 1 | 0.102184501141478 |
| 139354 | 139354 | 49657 49657 | 7470 | 1 | 0.3125 |
| 140058 | 140058 | 49892 49892 | 7470 | 15 | 0.337349397590361 |
| 207257 | 207257 | 73378 73378 | 7470 | 8 | 0.334661354581673 |
| 226079 | 226079 | 77875 77875 | 7470 | 8 | 0.334661354581673 |
| 295292 | 295292 | 99968 99968 | 7470 | 1 | 0.310344827586207 |
| 309361 | 309361 | 104513 104513 | 7470 | 1 | 0.107981133350711 |
| 433430 | 433430 | 155807 155807 | 7470 | 8 | 0.334661354581673 |
| 459504 | 459504 | 165195 165195 | 7470 | 1 | 0.310344827586207 |
| 519679 | 519679 | 207674 207674 | 7470 | 8 | 0.461538461538462 |
| 519683 | 519683 | 207675 207675 | 7470 | 8 | 0.334661354581673 |
| 519689 | 519689 | 207676 207676 | 7470 | 8 | 0.334661354581673 |
| 519695 | 519695 | 207677 207677 | 7470 | 8 | 0.334661354581673 |
| 519701 | 519701 | 207678 207678 | 7470 | 8 | 0.334661354581673 |
| 541543 | 541543 | 214407 214407 | 7470 | 1 | 0.310344827586207 |
| 582595 | 582595 | 227779 227779 | 7470 | 1 | 0.107981133350711 |
| 585561 | 585561 | 228686 228686 | 7470 | 8 | 0.334661354581673 |
| 599467 | 599467 | 236158 236158 | 7470 | 10 | 0.335664335664336 |
| 679033 | 679033 | 242746 242746 | 7470 | 12 | 0.354251703197398 |
| 725749 | 725749 | 256409 256409 | 7470 | 1 | 0.241935483870968 |
| 756360 | 756360 | 265721 265721 | 7470 | 8 | 0.461538461538462 |
| 756364 | 756364 | 265722 265722 | 7470 | 7 | 0.45993031358885 |
| 756368 | 756368 | 265723 265723 | 7470 | 8 | 0.334661354581673 |
| 837893 | 837893 | 290692 290692 | 7470 | 1 | 0.3125 |
| 837895 | 837895 | 290693 290693 | 7470 | 1 | 0.3125 |
| 918076 | 918076 | 325437 325437 | 7470 | 1 | 0.3 |
| 919126 | 919126 | 326009 326009 | 7470 | 4 | 0.452830188679245 |
| 919144 | 919144 | 326014 326014 | 7470 | 1 | 0.212215885571685 |
| 953387 | 953387 | 342194 342194 | 7470 | 1 | 0.113314768100125 |
| 1009668 | 1009668 | 360532 360532 | 7470 | 8 | 0.461538461538462 |
| 1009672 | 1009672 | 360533 360533 | 7470 | 8 | 0.461538461538462 |
| 1009676 | 1009676 | 360534 360534 | 7470 | 8 | 0.461538461538462 |
| 1009680 | 1009680 | 360535 360535 | 7470 | 8 | 0.461538461538462 |
| 1009684 | 1009684 | 360536 360536 | 7470 | 8 | 0.461538461538462 |
| 1009688 | 1009688 | 360537 360537 | 7470 | 8 | 0.461538461538462 |
| 1009692 | 1009692 | 360538 360538 | 7470 | 8 | 0.461538461538462 |
| 1009696 | 1009696 | 360539 360539 | 7470 | 8 | 0.461538461538462 |
| 1009700 | 1009700 | 360540 360540 | 7470 | 8 | 0.461538461538462 |
| 1009704 | 1009704 | 360541 360541 | 7470 | 8 | 0.461538461538462 |
| 1009708 | 1009708 | 360542 360542 | 7470 | 8 | 0.461538461538462 |
| 1009712 | 1009712 | 360543 360543 | 7470 | 8 | 0.461538461538462 |
| 1009716 | 1009716 | 360544 360544 | 7470 | 8 | 0.461538461538462 |
| 1009720 | 1009720 | 360545 360545 | 7470 | 8 | 0.461538461538462 |
| 1009724 | 1009724 | 360546 360546 | 7470 | 8 | 0.461538461538462 |
| 1119356 | 1119356 | 383571 383571 | 7470 | 1 | 0.3125 |
| 1119358 | 1119358 | 383572 383572 | 7470 | 1 | 0.3125 |
| 1119360 | 1119360 | 383573 383573 | 7470 | 1 | 0.3125 |
| 1119362 | 1119362 | 383574 383574 | 7470 | 1 | 0.3125 |
| 1119364 | 1119364 | 383575 383575 | 7470 | 1 | 0.3125 |
| 1220873 | 1220873 | 404915 404915 | 7470 | 8 | 0.461538461538462 |
| 1220877 | 1220877 | 404916 404916 | 7470 | 8 | 0.461538461538462 |
| 1220881 | 1220881 | 404917 404917 | 7470 | 8 | 0.461538461538462 |
| 1220885 | 1220885 | 404918 404918 | 7470 | 8 | 0.461538461538462 |
| 1220889 | 1220889 | 404919 404919 | 7470 | 8 | 0.461538461538462 |
| 1220893 | 1220893 | 404920 404920 | 7470 | 8 | 0.461538461538462 |
| 1220897 | 1220897 | 404921 404921 | 7470 | 8 | 0.461538461538462 |
| 1220901 | 1220901 | 404922 404922 | 7470 | 8 | 0.461538461538462 |
| 1220905 | 1220905 | 404923 404923 | 7470 | 8 | 0.461538461538462 |
| 1220909 | 1220909 | 404924 404924 | 7470 | 8 | 0.461538461538462 |
| 1220913 | 1220913 | 404925 404925 | 7470 | 8 | 0.461538461538462 |
| 1220917 | 1220917 | 404926 404926 | 7470 | 8 | 0.461538461538462 |
| 1220921 | 1220921 | 404927 404927 | 7470 | 8 | 0.461538461538462 |
| 1220925 | 1220925 | 404928 404928 | 7470 | 8 | 0.461538461538462 |
| 1220929 | 1220929 | 404929 404929 | 7470 | 8 | 0.461538461538462 |
| 1220933 | 1220933 | 404930 404930 | 7470 | 8 | 0.461538461538462 |
| 1220937 | 1220937 | 404931 404931 | 7470 | 8 | 0.461538461538462 |
| 1220941 | 1220941 | 404932 404932 | 7470 | 8 | 0.461538461538462 |
| 1220945 | 1220945 | 404933 404933 | 7470 | 8 | 0.461538461538462 |
| 1220949 | 1220949 | 404934 404934 | 7470 | 8 | 0.461538461538462 |
| 1355920 | 1355920 | 432441 432441 | 7470 | 1 | 0.3125 |
| 1355922 | 1355922 | 432442 432442 | 7470 | 1 | 0.3125 |
| 1355924 | 1355924 | 432443 432443 | 7470 | 1 | 0.3125 |
| 1355926 | 1355926 | 432444 432444 | 7470 | 1 | 0.3125 |
| 1355928 | 1355928 | 432445 432445 | 7470 | 1 | 0.3125 |
| 1355930 | 1355930 | 432446 432446 | 7470 | 1 | 0.3125 |
| 1355932 | 1355932 | 432447 432447 | 7470 | 1 | 0.3125 |
| 1461527 | 1461527 | 453376 453376 | 7470 | 8 | 0.461538461538462 |
| 1461531 | 1461531 | 453377 453377 | 7470 | 8 | 0.461538461538462 |
| 1461535 | 1461535 | 453378 453378 | 7470 | 8 | 0.461538461538462 |
| 1461539 | 1461539 | 453379 453379 | 7470 | 8 | 0.461538461538462 |
| 1461543 | 1461543 | 453380 453380 | 7470 | 8 | 0.461538461538462 |
| 1461547 | 1461547 | 453381 453381 | 7470 | 8 | 0.461538461538462 |
| 1461551 | 1461551 | 453382 453382 | 7470 | 8 | 0.461538461538462 |
| 1461555 | 1461555 | 453383 453383 | 7470 | 8 | 0.461538461538462 |
| 1461559 | 1461559 | 453384 453384 | 7470 | 8 | 0.461538461538462 |
| 1461563 | 1461563 | 453385 453385 | 7470 | 8 | 0.461538461538462 |
| 1461567 | 1461567 | 453386 453386 | 7470 | 8 | 0.461538461538462 |
| 1461571 | 1461571 | 453387 453387 | 7470 | 8 | 0.461538461538462 |
| 1461575 | 1461575 | 453388 453388 | 7470 | 8 | 0.461538461538462 |
| 1544507 | 1544507 | 470825 470825 | 7470 | 1 | 0.3125 |
| 1544509 | 1544509 | 470826 470826 | 7470 | 1 | 0.3125 |
| 1544511 | 1544511 | 470827 470827 | 7470 | 1 | 0.3125 |
| 1544513 | 1544513 | 470828 470828 | 7470 | 1 | 0.3125 |
| 1544515 | 1544515 | 470829 470829 | 7470 | 1 | 0.3125 |
| 1593031 | 1593031 | 480864 480864 | 7470 | 8 | 0.461538461538462 |
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)
);