consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
166 rows where inchi_id = 47694
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 18839 | 18839 | 5535 5535 | 47694 | 1 | 0.147588763410113 |
| 23203 | 23203 | 6809 6809 | 47694 | 1 | 0.0829446985461313 |
| 25800 | 25800 | 7564 7564 | 47694 | 4 | 0.18001114114928 |
| 26765 | 26765 | 7804 7804 | 47694 | 3 | 0.299063076399583 |
| 31823 | 31823 | 9348 9348 | 47694 | 3 | 0.17422280422313 |
| 43865 | 43865 | 13382 13382 | 47694 | 1 | 0.0334179094507541 |
| 102657 | 102657 | 36168 36168 | 47694 | 1 | 0.0829446985461313 |
| 102692 | 102692 | 36176 36176 | 47694 | 7 | 0.258365372610623 |
| 102705 | 102705 | 36179 36179 | 47694 | 1 | 0.147247867243193 |
| 102752 | 102752 | 36187 36187 | 47694 | 3 | 0.17422280422313 |
| 102772 | 102772 | 36190 36190 | 47694 | 3 | 0.157129486676237 |
| 102780 | 102780 | 36191 36191 | 47694 | 1 | 0.20979020979021 |
| 133745 | 133745 | 47444 47444 | 47694 | 1 | 0.0526695191270198 |
| 141881 | 141881 | 50560 50560 | 47694 | 5 | 0.194554524323649 |
| 141890 | 141890 | 50561 50561 | 47694 | 7 | 0.258365372610623 |
| 141901 | 141901 | 50563 50563 | 47694 | 1 | 0.0756825781683987 |
| 158851 | 158851 | 57190 57190 | 47694 | 2 | 0.129116258460385 |
| 158861 | 158861 | 57191 57191 | 47694 | 5 | 0.212701534456653 |
| 158885 | 158885 | 57195 57195 | 47694 | 1 | 0.0432537168271167 |
| 158901 | 158901 | 57196 57196 | 47694 | 1 | 0.0412173590229569 |
| 158938 | 158938 | 57200 57200 | 47694 | 3 | 0.104140276466311 |
| 162689 | 162689 | 58264 58264 | 47694 | 1 | 0.034094554881594 |
| 166667 | 166667 | 59635 59635 | 47694 | 1 | 0.0999211149092821 |
| 216532 | 216532 | 75175 75175 | 47694 | 2 | 0.144745911522907 |
| 227106 | 227106 | 78120 78120 | 47694 | 4 | 0.175468765975356 |
| 229199 | 229199 | 78637 78637 | 47694 | 2 | 0.13097544988996 |
| 229205 | 229205 | 78638 78638 | 47694 | 1 | 0.0805410723221617 |
| 230876 | 230876 | 79033 79033 | 47694 | 1 | 0.033995403374841 |
| 244637 | 244637 | 83254 83254 | 47694 | 1 | 0.14608590707227 |
| 248717 | 248717 | 84604 84604 | 47694 | 3 | 0.104140276466311 |
| 264511 | 264511 | 89608 89608 | 47694 | 1 | 0.3125 |
| 270934 | 270934 | 91893 91893 | 47694 | 1 | 0.0756825781683987 |
| 338529 | 338529 | 114150 114150 | 47694 | 1 | 0.0536032325638092 |
| 339576 | 339576 | 114546 114546 | 47694 | 2 | 0.072424000378878 |
| 359255 | 359255 | 121942 121942 | 47694 | 1 | 0.0731707317073171 |
| 426703 | 426703 | 153896 153896 | 47694 | 1 | 0.147588763410113 |
| 433959 | 433959 | 155943 155943 | 47694 | 5 | 0.194554524323649 |
| 435170 | 435170 | 156250 156250 | 47694 | 2 | 0.13097544988996 |
| 435176 | 435176 | 156251 156251 | 47694 | 1 | 0.0805410723221617 |
| 437596 | 437596 | 156877 156877 | 47694 | 7 | 0.258365372610623 |
| 442366 | 442366 | 158570 158570 | 47694 | 2 | 0.122252748675204 |
| 485432 | 485432 | 179604 179604 | 47694 | 1 | 0.0727402501396315 |
| 534761 | 534761 | 212203 212203 | 47694 | 4 | 0.170011665233743 |
| 534908 | 534908 | 212244 212244 | 47694 | 2 | 0.122252748675204 |
| 549692 | 549692 | 217355 217355 | 47694 | 1 | 0.0674410676082163 |
| 565093 | 565093 | 221961 221961 | 47694 | 1 | 0.0756825781683987 |
| 578333 | 578333 | 226526 226526 | 47694 | 2 | 0.131154077169619 |
| 583544 | 583544 | 228057 228057 | 47694 | 3 | 0.157129486676237 |
| 666836 | 666836 | 238737 238737 | 47694 | 2 | 0.144745911522907 |
| 673735 | 673735 | 240918 240918 | 47694 | 1 | 0.0829446985461313 |
| 681161 | 681161 | 243315 243315 | 47694 | 7 | 0.173173653245206 |
| 685464 | 685464 | 244492 244492 | 47694 | 3 | 0.188028618837694 |
| 719105 | 719105 | 254262 254262 | 47694 | 2 | 0.0228375728096774 |
| 732993 | 732993 | 258498 258498 | 47694 | 3 | 0.135966194989547 |
| 733301 | 733301 | 258589 258589 | 47694 | 4 | 0.151894198445379 |
| 746951 | 746951 | 262726 262726 | 47694 | 1 | 0.0829446985461313 |
| 760705 | 760705 | 266938 266938 | 47694 | 5 | 0.144802561985801 |
| 760714 | 760714 | 266939 266939 | 47694 | 3 | 0.157129486676237 |
| 760723 | 760723 | 266940 266940 | 47694 | 3 | 0.14821238155147 |
| 760732 | 760732 | 266941 266941 | 47694 | 3 | 0.157129486676237 |
| 768877 | 768877 | 269010 269010 | 47694 | 2 | 0.212335692618807 |
| 768882 | 768882 | 269011 269011 | 47694 | 1 | 0.20979020979021 |
| 768887 | 768887 | 269012 269012 | 47694 | 1 | 0.211267605633803 |
| 779365 | 779365 | 272528 272528 | 47694 | 1 | 0.3125 |
| 790793 | 790793 | 276108 276108 | 47694 | 1 | 0.033995403374841 |
| 823753 | 823753 | 285936 285936 | 47694 | 1 | 0.0261182942557781 |
| 823763 | 823763 | 285937 285937 | 47694 | 1 | 0.034094554881594 |
| 852127 | 852127 | 294845 294845 | 47694 | 3 | 0.135966194989547 |
| 852134 | 852134 | 294846 294846 | 47694 | 3 | 0.104140276466311 |
| 852141 | 852141 | 294847 294847 | 47694 | 2 | 0.0942502339035784 |
| 852149 | 852149 | 294848 294848 | 47694 | 2 | 0.119777593903151 |
| 852156 | 852156 | 294849 294849 | 47694 | 2 | 0.125323822141718 |
| 852738 | 852738 | 295029 295029 | 47694 | 4 | 0.186921384753026 |
| 852749 | 852749 | 295030 295030 | 47694 | 2 | 0.147859008961714 |
| 852759 | 852759 | 295031 295031 | 47694 | 1 | 0.147247867243193 |
| 852769 | 852769 | 295032 295032 | 47694 | 2 | 0.128884564660297 |
| 852781 | 852781 | 295033 295033 | 47694 | 3 | 0.168983151194871 |
| 852796 | 852796 | 295034 295034 | 47694 | 1 | 0.147041661804178 |
| 862040 | 862040 | 297965 297965 | 47694 | 3 | 0.157129486676237 |
| 883519 | 883519 | 307373 307373 | 47694 | 1 | 0.147041661804178 |
| 990845 | 990845 | 355725 355725 | 47694 | 1 | 0.0829446985461313 |
| 990855 | 990855 | 355726 355726 | 47694 | 1 | 0.0829446985461313 |
| 990865 | 990865 | 355727 355727 | 47694 | 1 | 0.0829446985461313 |
| 990875 | 990875 | 355728 355728 | 47694 | 1 | 0.0829446985461313 |
| 990885 | 990885 | 355729 355729 | 47694 | 1 | 0.0829446985461313 |
| 990895 | 990895 | 355730 355730 | 47694 | 1 | 0.0829446985461313 |
| 990905 | 990905 | 355731 355731 | 47694 | 1 | 0.0829446985461313 |
| 990915 | 990915 | 355732 355732 | 47694 | 1 | 0.0829446985461313 |
| 990925 | 990925 | 355733 355733 | 47694 | 1 | 0.0829446985461313 |
| 990935 | 990935 | 355734 355734 | 47694 | 1 | 0.0829446985461313 |
| 990945 | 990945 | 355735 355735 | 47694 | 1 | 0.0829446985461313 |
| 990955 | 990955 | 355736 355736 | 47694 | 1 | 0.0829446985461313 |
| 990965 | 990965 | 355737 355737 | 47694 | 1 | 0.0829446985461313 |
| 990975 | 990975 | 355738 355738 | 47694 | 1 | 0.0829446985461313 |
| 1021883 | 1021883 | 363599 363599 | 47694 | 5 | 0.144802561985801 |
| 1021892 | 1021892 | 363600 363600 | 47694 | 5 | 0.144802561985801 |
| 1021901 | 1021901 | 363601 363601 | 47694 | 5 | 0.144802561985801 |
| 1171366 | 1171366 | 393421 393421 | 47694 | 2 | 0.147859008961714 |
| 1171376 | 1171376 | 393422 393422 | 47694 | 2 | 0.147859008961714 |
| 1171386 | 1171386 | 393423 393423 | 47694 | 2 | 0.147859008961714 |
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)
);