consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
120 rows where inventory_id = 156243
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 435021 | 435021 | 156243 156243 | 3251 | 1 | 0.00185971966422432 |
| 435022 | 435022 | 156243 156243 | 12440 | 8 | 0.145058133809497 |
| 435023 | 435023 | 156243 156243 | 53069 | 1 | 0.00216504677327607 |
| 435024 | 435024 | 156243 156243 | 136389 | 2 | 0.0592197351456054 |
| 435025 | 435025 | 156243 156243 | 137819 | 1 | 0.0725290669047484 |
| 435026 | 435026 | 156243 156243 | 151229 | 1 | 0.0290116267618994 |
| 435027 | 435027 | 156243 156243 | 168927 | 1 | 0.00296037007774483 |
| 435028 | 435028 | 156243 156243 | 169371 | 1 | 0.0362645334523742 |
| 435029 | 435029 | 156243 156243 | 169385 | 1 | 0.00159404542647799 |
| 435030 | 435030 | 156243 156243 | 169390 | 1 | 0.00414451810884277 |
| 435031 | 435031 | 156243 156243 | 169408 | 1 | 0.0241763556349161 |
| 435032 | 435032 | 156243 156243 | 169412 | 1 | 0.00906613336309355 |
| 435033 | 435033 | 156243 156243 | 169425 | 1 | 0.00557915899267295 |
| 435034 | 435034 | 156243 156243 | 169449 | 1 | 0.00725290669047484 |
| 435035 | 435035 | 156243 156243 | 169455 | 1 | 0.00659355153679531 |
| 435036 | 435036 | 156243 156243 | 169478 | 1 | 0.0120881778174581 |
| 435037 | 435037 | 156243 156243 | 169481 | 1 | 0.0063068753830216 |
| 435038 | 435038 | 156243 156243 | 169491 | 1 | 0.00604408890872903 |
| 435039 | 435039 | 156243 156243 | 169492 | 1 | 0.00453306668154678 |
| 435040 | 435040 | 156243 156243 | 169499 | 1 | 0.0181322667261871 |
| 435041 | 435041 | 156243 156243 | 169530 | 1 | 0.0161175704232774 |
| 435042 | 435042 | 156243 156243 | 169579 | 1 | 0.00483527112698323 |
| 435043 | 435043 | 156243 156243 | 169600 | 1 | 0.0145058133809497 |
| 435044 | 435044 | 156243 156243 | 169627 | 1 | 0.00439570102453021 |
| 435045 | 435045 | 156243 156243 | 169647 | 1 | 0.00426641570027932 |
| 435046 | 435046 | 156243 156243 | 169656 | 1 | 0.0131871030735906 |
| 435047 | 435047 | 156243 156243 | 169675 | 1 | 0.00223166359706918 |
| 435048 | 435048 | 156243 156243 | 169677 | 1 | 0.0111583179853459 |
| 435049 | 435049 | 156243 156243 | 169681 | 1 | 0.0103612952721069 |
| 435050 | 435050 | 156243 156243 | 169687 | 1 | 0.00967054225396645 |
| 435051 | 435051 | 156243 156243 | 169708 | 1 | 0.00853283140055864 |
| 435052 | 435052 | 156243 156243 | 169724 | 1 | 0.00805878521163871 |
| 435053 | 435053 | 156243 156243 | 169742 | 1 | 0.00183617890898097 |
| 435054 | 435054 | 156243 156243 | 169749 | 1 | 0.0290116267618994 |
| 435055 | 435055 | 156243 156243 | 169760 | 1 | 0.00690753018140461 |
| 435056 | 435056 | 156243 156243 | 169777 | 1 | 0.0207225905442138 |
| 435057 | 435057 | 156243 156243 | 169798 | 1 | 0.00207225905442138 |
| 435058 | 435058 | 156243 156243 | 173842 | 1 | 0.00580232535237987 |
| 435059 | 435059 | 156243 156243 | 177991 | 1 | 0.0207225905442138 |
| 435060 | 435060 | 156243 156243 | 181622 | 1 | 0.00302204445436452 |
| 435061 | 435061 | 156243 156243 | 186007 | 1 | 0.00290116267618994 |
| 435062 | 435062 | 156243 156243 | 186445 | 1 | 0.00308634327254249 |
| 435063 | 435063 | 156243 156243 | 190181 | 1 | 0.00152692772431049 |
| 435064 | 435064 | 156243 156243 | 190185 | 1 | 0.00154317163627124 |
| 435065 | 435065 | 156243 156243 | 207139 | 1 | 0.00467929463901603 |
| 435066 | 435066 | 156243 156243 | 207241 | 1 | 0.00763463862155246 |
| 435067 | 435067 | 156243 156243 | 207243 | 1 | 0.00139478974816824 |
| 435068 | 435068 | 156243 156243 | 207246 | 1 | 0.00500200461412058 |
| 435069 | 435069 | 156243 156243 | 207685 | 1 | 0.00371943932844864 |
| 435070 | 435070 | 156243 156243 | 214283 | 1 | 0.0362645334523742 |
| 435071 | 435071 | 156243 156243 | 217714 | 1 | 0.00402939260581936 |
| 435072 | 435072 | 156243 156243 | 217715 | 1 | 0.00145058133809497 |
| 435073 | 435073 | 156243 156243 | 218088 | 1 | 0.00392049010295937 |
| 435074 | 435074 | 156243 156243 | 230825 | 1 | 0.00381731931077623 |
| 435075 | 435075 | 156243 156243 | 232217 | 1 | 0.00362645334523742 |
| 435076 | 435076 | 156243 156243 | 232537 | 1 | 0.0024586124374491 |
| 435077 | 435077 | 156243 156243 | 232828 | 1 | 0.00353800326364626 |
| 435078 | 435078 | 156243 156243 | 232898 | 1 | 0.0034537650907023 |
| 435079 | 435079 | 156243 156243 | 232899 | 1 | 0.00213320785013966 |
| 435080 | 435080 | 156243 156243 | 232968 | 1 | 0.00337344497231388 |
| 435081 | 435081 | 156243 156243 | 233127 | 1 | 0.00329677576839766 |
| 435082 | 435082 | 156243 156243 | 233158 | 1 | 0.00322351408465549 |
| 435083 | 435083 | 156243 156243 | 233205 | 1 | 0.0031534376915108 |
| 435084 | 435084 | 156243 156243 | 234443 | 1 | 0.00284427713351955 |
| 435085 | 435085 | 156243 156243 | 234495 | 1 | 0.00278957949633648 |
| 435086 | 435086 | 156243 156243 | 234496 | 1 | 0.0027369459209339 |
| 435087 | 435087 | 156243 156243 | 234529 | 1 | 0.0026862617372129 |
| 435088 | 435088 | 156243 156243 | 234530 | 1 | 0.0021978505122651 |
| 435089 | 435089 | 156243 156243 | 234545 | 1 | 0.00250100230706029 |
| 435090 | 435090 | 156243 156243 | 234559 | 1 | 0.00263742061471812 |
| 435091 | 435091 | 156243 156243 | 234563 | 1 | 0.00259032381802673 |
| 435092 | 435092 | 156243 156243 | 234565 | 1 | 0.00254487954051749 |
| 435093 | 435093 | 156243 156243 | 237523 | 1 | 0.00237800219359831 |
| 435094 | 435094 | 156243 156243 | 238380 | 1 | 0.0483527112698323 |
| 435095 | 435095 | 156243 156243 | 238699 | 1 | 0.00193410845079329 |
| 435096 | 435096 | 156243 156243 | 238900 | 1 | 0.00233964731950801 |
| 435097 | 435097 | 156243 156243 | 238901 | 1 | 0.0023025100604682 |
| 435098 | 435098 | 156243 156243 | 238902 | 1 | 0.00226653334077339 |
| 435099 | 435099 | 156243 156243 | 239479 | 1 | 0.00241763556349161 |
| 435100 | 435100 | 156243 156243 | 240950 | 1 | 0.0181322667261871 |
| 435101 | 435101 | 156243 156243 | 241454 | 1 | 0.00210229179434053 |
| 435102 | 435102 | 156243 156243 | 241508 | 1 | 0.00151102222718226 |
| 435103 | 435103 | 156243 156243 | 242299 | 1 | 0.00204307230717601 |
| 435104 | 435104 | 156243 156243 | 243276 | 1 | 0.00201469630290968 |
| 435105 | 435105 | 156243 156243 | 245870 | 1 | 0.00198709772341776 |
| 435106 | 435106 | 156243 156243 | 250801 | 1 | 0.00190865965538812 |
| 435107 | 435107 | 156243 156243 | 251402 | 1 | 0.0241763556349161 |
| 435108 | 435108 | 156243 156243 | 255625 | 1 | 0.0018838718676558 |
| 435109 | 435109 | 156243 156243 | 255675 | 1 | 0.00181322667261871 |
| 435110 | 435110 | 156243 156243 | 258661 | 1 | 0.00176900163182313 |
| 435111 | 435111 | 156243 156243 | 260191 | 1 | 0.0161175704232774 |
| 435112 | 435112 | 156243 156243 | 261712 | 1 | 0.00172688254535115 |
| 435113 | 435113 | 156243 156243 | 267249 | 1 | 0.00168672248615694 |
| 435114 | 435114 | 156243 156243 | 275510 | 1 | 0.00166733487137353 |
| 435115 | 435115 | 156243 156243 | 275511 | 1 | 0.00162986667201682 |
| 435116 | 435116 | 156243 156243 | 290646 | 1 | 0.0145058133809497 |
| 435117 | 435117 | 156243 156243 | 296145 | 1 | 0.00196024505147969 |
| 435118 | 435118 | 156243 156243 | 296184 | 1 | 0.0015767188457554 |
| 435119 | 435119 | 156243 156243 | 314293 | 1 | 0.00518064763605346 |
| 435120 | 435120 | 156243 156243 | 314574 | 1 | 0.00537252347442581 |
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)
);