consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
98 rows where inchi_id = 18643
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 14008 | 14008 | 4300 4300 | 18643 | 1 | 0.192307692307692 |
| 14011 | 14011 | 4301 4301 | 18643 | 6 | 0.329227479858064 |
| 25502 | 25502 | 7484 7484 | 18643 | 1 | 0.192307692307692 |
| 53975 | 53975 | 16831 16831 | 18643 | 6 | 0.329227479858064 |
| 101953 | 101953 | 35942 35942 | 18643 | 1 | 0.192307692307692 |
| 101956 | 101956 | 35943 35943 | 18643 | 6 | 0.329227479858064 |
| 139725 | 139725 | 49765 49765 | 18643 | 6 | 0.329227479858064 |
| 139731 | 139731 | 49766 49766 | 18643 | 1 | 0.192307692307692 |
| 226244 | 226244 | 77915 77915 | 18643 | 3 | 0.192982456140351 |
| 323752 | 323752 | 109090 109090 | 18643 | 7 | 0.393523744609447 |
| 331874 | 331874 | 111870 111870 | 18643 | 2 | 0.293405853909751 |
| 433520 | 433520 | 155828 155828 | 18643 | 1 | 0.1875 |
| 471713 | 471713 | 170962 170962 | 18643 | 8 | 0.379810138829143 |
| 474770 | 474770 | 172686 172686 | 18643 | 1 | 0.290089364147732 |
| 519749 | 519749 | 207683 207683 | 18643 | 2 | 0.158215010141988 |
| 570626 | 570626 | 223715 223715 | 18643 | 1 | 0.290089364147732 |
| 573907 | 573907 | 224882 224882 | 18643 | 8 | 0.343643540231876 |
| 585476 | 585476 | 228666 228666 | 18643 | 2 | 0.192982456140351 |
| 599490 | 599490 | 236163 236163 | 18643 | 3 | 0.192982456140351 |
| 679241 | 679241 | 242802 242802 | 18643 | 1 | 0.192307692307692 |
| 689524 | 689524 | 245890 245890 | 18643 | 8 | 0.379810138829143 |
| 756677 | 756677 | 265812 265812 | 18643 | 1 | 0.191489361702128 |
| 756680 | 756680 | 265813 265813 | 18643 | 1 | 0.192307692307692 |
| 774765 | 774765 | 271012 271012 | 18643 | 4 | 0.392156862745098 |
| 774771 | 774771 | 271013 271013 | 18643 | 4 | 0.392156862745098 |
| 774777 | 774777 | 271014 271014 | 18643 | 4 | 0.392156862745098 |
| 774783 | 774783 | 271015 271015 | 18643 | 8 | 0.379810138829143 |
| 926189 | 926189 | 329332 329332 | 18643 | 1 | 0.1875 |
| 1010109 | 1010109 | 360658 360658 | 18643 | 1 | 0.192307692307692 |
| 1010112 | 1010112 | 360659 360659 | 18643 | 1 | 0.192307692307692 |
| 1010115 | 1010115 | 360660 360660 | 18643 | 1 | 0.192307692307692 |
| 1010118 | 1010118 | 360661 360661 | 18643 | 1 | 0.192307692307692 |
| 1010121 | 1010121 | 360662 360662 | 18643 | 1 | 0.192307692307692 |
| 1010124 | 1010124 | 360663 360663 | 18643 | 1 | 0.192307692307692 |
| 1010127 | 1010127 | 360664 360664 | 18643 | 1 | 0.192307692307692 |
| 1010130 | 1010130 | 360665 360665 | 18643 | 1 | 0.192307692307692 |
| 1010133 | 1010133 | 360666 360666 | 18643 | 1 | 0.192307692307692 |
| 1010136 | 1010136 | 360667 360667 | 18643 | 1 | 0.192307692307692 |
| 1010139 | 1010139 | 360668 360668 | 18643 | 1 | 0.192307692307692 |
| 1010142 | 1010142 | 360669 360669 | 18643 | 1 | 0.192307692307692 |
| 1010145 | 1010145 | 360670 360670 | 18643 | 1 | 0.192307692307692 |
| 1010148 | 1010148 | 360671 360671 | 18643 | 1 | 0.192307692307692 |
| 1010151 | 1010151 | 360672 360672 | 18643 | 1 | 0.192307692307692 |
| 1010154 | 1010154 | 360673 360673 | 18643 | 1 | 0.192307692307692 |
| 1010157 | 1010157 | 360674 360674 | 18643 | 1 | 0.192307692307692 |
| 1010160 | 1010160 | 360675 360675 | 18643 | 1 | 0.192307692307692 |
| 1010163 | 1010163 | 360676 360676 | 18643 | 1 | 0.192307692307692 |
| 1010166 | 1010166 | 360677 360677 | 18643 | 1 | 0.192307692307692 |
| 1010169 | 1010169 | 360678 360678 | 18643 | 1 | 0.192307692307692 |
| 1010172 | 1010172 | 360679 360679 | 18643 | 1 | 0.192307692307692 |
| 1010175 | 1010175 | 360680 360680 | 18643 | 1 | 0.192307692307692 |
| 1010178 | 1010178 | 360681 360681 | 18643 | 1 | 0.192307692307692 |
| 1010181 | 1010181 | 360682 360682 | 18643 | 1 | 0.192307692307692 |
| 1010184 | 1010184 | 360683 360683 | 18643 | 1 | 0.192307692307692 |
| 1010187 | 1010187 | 360684 360684 | 18643 | 1 | 0.192307692307692 |
| 1010190 | 1010190 | 360685 360685 | 18643 | 1 | 0.192307692307692 |
| 1010193 | 1010193 | 360686 360686 | 18643 | 1 | 0.192307692307692 |
| 1010196 | 1010196 | 360687 360687 | 18643 | 1 | 0.192307692307692 |
| 1010199 | 1010199 | 360688 360688 | 18643 | 1 | 0.192307692307692 |
| 1010202 | 1010202 | 360689 360689 | 18643 | 1 | 0.192307692307692 |
| 1010205 | 1010205 | 360690 360690 | 18643 | 1 | 0.192307692307692 |
| 1010208 | 1010208 | 360691 360691 | 18643 | 1 | 0.192307692307692 |
| 1010211 | 1010211 | 360692 360692 | 18643 | 1 | 0.192307692307692 |
| 1010214 | 1010214 | 360693 360693 | 18643 | 1 | 0.192307692307692 |
| 1010217 | 1010217 | 360694 360694 | 18643 | 1 | 0.192307692307692 |
| 1010220 | 1010220 | 360695 360695 | 18643 | 1 | 0.192307692307692 |
| 1010223 | 1010223 | 360696 360696 | 18643 | 1 | 0.192307692307692 |
| 1010226 | 1010226 | 360697 360697 | 18643 | 1 | 0.192307692307692 |
| 1038808 | 1038808 | 368075 368075 | 18643 | 8 | 0.379810138829143 |
| 1038814 | 1038814 | 368076 368076 | 18643 | 8 | 0.379810138829143 |
| 1038820 | 1038820 | 368077 368077 | 18643 | 8 | 0.379810138829143 |
| 1038826 | 1038826 | 368078 368078 | 18643 | 8 | 0.379810138829143 |
| 1221363 | 1221363 | 405053 405053 | 18643 | 1 | 0.192307692307692 |
| 1221366 | 1221366 | 405054 405054 | 18643 | 1 | 0.192307692307692 |
| 1221369 | 1221369 | 405055 405055 | 18643 | 1 | 0.192307692307692 |
| 1221372 | 1221372 | 405056 405056 | 18643 | 1 | 0.192307692307692 |
| 1221375 | 1221375 | 405057 405057 | 18643 | 1 | 0.192307692307692 |
| 1221378 | 1221378 | 405058 405058 | 18643 | 1 | 0.192307692307692 |
| 1221381 | 1221381 | 405059 405059 | 18643 | 1 | 0.192307692307692 |
| 1221384 | 1221384 | 405060 405060 | 18643 | 1 | 0.192307692307692 |
| 1221387 | 1221387 | 405061 405061 | 18643 | 1 | 0.192307692307692 |
| 1221390 | 1221390 | 405062 405062 | 18643 | 1 | 0.192307692307692 |
| 1258732 | 1258732 | 414658 414658 | 18643 | 8 | 0.379810138829143 |
| 1461837 | 1461837 | 453463 453463 | 18643 | 1 | 0.192307692307692 |
| 1461840 | 1461840 | 453464 453464 | 18643 | 1 | 0.192307692307692 |
| 1461843 | 1461843 | 453465 453465 | 18643 | 1 | 0.192307692307692 |
| 1461846 | 1461846 | 453466 453466 | 18643 | 1 | 0.192307692307692 |
| 1461849 | 1461849 | 453467 453467 | 18643 | 1 | 0.192307692307692 |
| 1461852 | 1461852 | 453468 453468 | 18643 | 1 | 0.192307692307692 |
| 1461855 | 1461855 | 453469 453469 | 18643 | 1 | 0.192307692307692 |
| 1483711 | 1483711 | 459094 459094 | 18643 | 8 | 0.379810138829143 |
| 1593098 | 1593098 | 480883 480883 | 18643 | 1 | 0.192307692307692 |
| 1596034 | 1596034 | 481798 481798 | 18643 | 8 | 0.379810138829143 |
| 1619788 | 1619788 | 489124 489124 | 18643 | 1 | 0.192307692307692 |
| 1667183 | 1667183 | 505568 505568 | 18643 | 8 | 0.379810138829143 |
| 1722279 | 1722279 | 527486 527486 | 18643 | 1 | 0.1875 |
| 1748486 | 1748486 | 535555 535555 | 18643 | 6 | 0.329227479858064 |
| 1749989 | 1749989 | 536040 536040 | 18643 | 2 | 0.293405853909751 |
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)
);