consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
555 rows where inchi_id = 27449
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 890 | 890 | 187 187 | 27449 | 1 | 0.140395660497766 |
| 1857 | 1857 | 485 485 | 27449 | 1 | 0.0657894736842105 |
| 12179 | 12179 | 3707 3707 | 27449 | 1 | 0.173228346456693 |
| 15329 | 15329 | 4737 4737 | 27449 | 8 | 0.334661354581673 |
| 15894 | 15894 | 4812 4812 | 27449 | 1 | 0.141227593699077 |
| 17764 | 17764 | 5203 5203 | 27449 | 1 | 0.0661000944287063 |
| 21607 | 21607 | 6374 6374 | 27449 | 1 | 0.173228346456693 |
| 32103 | 32103 | 9432 9432 | 27449 | 1 | 0.0537593315767721 |
| 47218 | 47218 | 14517 14517 | 27449 | 1 | 0.201551961652106 |
| 78780 | 78780 | 28456 28456 | 27449 | 5 | 0.51063829787234 |
| 78783 | 78783 | 28457 28457 | 27449 | 8 | 0.334661354581673 |
| 78801 | 78801 | 28461 28461 | 27449 | 1 | 0.0537593315767721 |
| 82041 | 82041 | 29546 29546 | 27449 | 1 | 0.173228346456693 |
| 82112 | 82112 | 29581 29581 | 27449 | 1 | 0.141227593699077 |
| 116662 | 116662 | 40689 40689 | 27449 | 1 | 0.0661000944287063 |
| 127269 | 127269 | 45499 45499 | 27449 | 1 | 0.141227593699077 |
| 131739 | 131739 | 46786 46786 | 27449 | 5 | 0.51063829787234 |
| 141837 | 141837 | 50558 50558 | 27449 | 1 | 0.0289274473615963 |
| 148038 | 148038 | 53281 53281 | 27449 | 16 | 0.143883105775809 |
| 149211 | 149211 | 53613 53613 | 27449 | 1 | 0.243864228693887 |
| 149488 | 149488 | 53695 53695 | 27449 | 1 | 0.0665188470066519 |
| 174553 | 174553 | 62352 62352 | 27449 | 1 | 0.25 |
| 175922 | 175922 | 62768 62768 | 27449 | 1 | 0.176165803108808 |
| 205960 | 205960 | 73008 73008 | 27449 | 1 | 0.140395660497766 |
| 207723 | 207723 | 73582 73582 | 27449 | 1 | 0.0657894736842105 |
| 209681 | 209681 | 73889 73889 | 27449 | 8 | 0.176023899164169 |
| 211547 | 211547 | 74088 74088 | 27449 | 2 | 0.174976307759342 |
| 220382 | 220382 | 76309 76309 | 27449 | 1 | 0.173228346456693 |
| 249794 | 249794 | 84934 84934 | 27449 | 1 | 0.0560891296756824 |
| 299838 | 299838 | 101524 101524 | 27449 | 1 | 0.201551961652106 |
| 336098 | 336098 | 113285 113285 | 27449 | 1 | 0.0713456531306411 |
| 364420 | 364420 | 123869 123869 | 27449 | 1 | 0.25 |
| 422286 | 422286 | 153107 153107 | 27449 | 8 | 0.176023899164169 |
| 423460 | 423460 | 153217 153217 | 27449 | 1 | 0.139211136890951 |
| 425804 | 425804 | 153640 153640 | 27449 | 1 | 0.065359477124183 |
| 429394 | 429394 | 154688 154688 | 27449 | 1 | 0.172413793103448 |
| 442778 | 442778 | 158711 158711 | 27449 | 1 | 0.0553911729790587 |
| 461642 | 461642 | 165867 165867 | 27449 | 1 | 0.201551961652106 |
| 487272 | 487272 | 181197 181197 | 27449 | 1 | 0.25 |
| 511851 | 511851 | 205968 205968 | 27449 | 1 | 0.120849647396056 |
| 511857 | 511857 | 205969 205969 | 27449 | 1 | 0.139211136890951 |
| 514304 | 514304 | 206368 206368 | 27449 | 1 | 0.065359477124183 |
| 514310 | 514310 | 206369 206369 | 27449 | 1 | 0.0661000944287063 |
| 533268 | 533268 | 211534 211534 | 27449 | 1 | 0.0561547478201071 |
| 533850 | 533850 | 211811 211811 | 27449 | 1 | 0.201551961652106 |
| 537048 | 537048 | 213141 213141 | 27449 | 1 | 0.0661000944287063 |
| 550057 | 550057 | 217476 217476 | 27449 | 2 | 0.174976307759342 |
| 553580 | 553580 | 218465 218465 | 27449 | 1 | 0.25 |
| 553673 | 553673 | 218483 218483 | 27449 | 8 | 0.176023899164169 |
| 568640 | 568640 | 223066 223066 | 27449 | 1 | 0.0713456531306411 |
| 594984 | 594984 | 231770 231770 | 27449 | 1 | 0.173228346456693 |
| 663251 | 663251 | 237794 237794 | 27449 | 8 | 0.176023899164169 |
| 663335 | 663335 | 237795 237795 | 27449 | 7 | 0.23334452753955 |
| 663783 | 663783 | 237890 237890 | 27449 | 3 | 0.138158411412266 |
| 663790 | 663790 | 237891 237891 | 27449 | 1 | 0.139211136890951 |
| 670561 | 670561 | 240110 240110 | 27449 | 1 | 0.175438596491228 |
| 698255 | 698255 | 248909 248909 | 27449 | 5 | 0.575225406714006 |
| 711883 | 711883 | 252371 252371 | 27449 | 1 | 0.25 |
| 712387 | 712387 | 252491 252491 | 27449 | 12 | 0.153521284948778 |
| 717143 | 717143 | 253647 253647 | 27449 | 2 | 0.176035243557152 |
| 730566 | 730566 | 257726 257726 | 27449 | 1 | 0.0661000944287063 |
| 734141 | 734141 | 258984 258984 | 27449 | 1 | 0.201551961652106 |
| 734803 | 734803 | 259209 259209 | 27449 | 1 | 0.0552059546178442 |
| 740553 | 740553 | 260923 260923 | 27449 | 1 | 0.173228346456693 |
| 740556 | 740556 | 260924 260924 | 27449 | 1 | 0.173228346456693 |
| 783803 | 783803 | 273986 273986 | 27449 | 5 | 0.545454545454546 |
| 785762 | 785762 | 274575 274575 | 27449 | 4 | 0.34294202045145 |
| 791678 | 791678 | 276386 276386 | 27449 | 4 | 0.338028169014085 |
| 813217 | 813217 | 282802 282802 | 27449 | 8 | 0.334661354581673 |
| 813223 | 813223 | 282803 282803 | 27449 | 5 | 0.455696202531646 |
| 813228 | 813228 | 282804 282804 | 27449 | 8 | 0.38585477557814 |
| 813232 | 813232 | 282805 282805 | 27449 | 8 | 0.461538461538462 |
| 813236 | 813236 | 282806 282806 | 27449 | 5 | 0.455696202531646 |
| 813242 | 813242 | 282807 282807 | 27449 | 8 | 0.176023899164169 |
| 813326 | 813326 | 282808 282808 | 27449 | 5 | 0.455696202531646 |
| 820462 | 820462 | 284810 284810 | 27449 | 1 | 0.141227593699077 |
| 820467 | 820467 | 284811 284811 | 27449 | 1 | 0.13986013986014 |
| 823718 | 823718 | 285922 285922 | 27449 | 4 | 0.254237288135593 |
| 830556 | 830556 | 288205 288205 | 27449 | 4 | 0.34294202045145 |
| 848428 | 848428 | 293519 293519 | 27449 | 1 | 0.0661000944287063 |
| 848434 | 848434 | 293520 293520 | 27449 | 1 | 0.0661000944287063 |
| 856070 | 856070 | 296138 296138 | 27449 | 1 | 0.0537593315767721 |
| 856076 | 856076 | 296139 296139 | 27449 | 1 | 0.0549682899158515 |
| 874904 | 874904 | 302434 302434 | 27449 | 3 | 0.524040820577346 |
| 888941 | 888941 | 310218 310218 | 27449 | 1 | 0.386876596835389 |
| 937425 | 937425 | 334859 334859 | 27449 | 2 | 0.408628001184222 |
| 938907 | 938907 | 335514 335514 | 27449 | 4 | 0.452830188679245 |
| 939174 | 939174 | 335638 335638 | 27449 | 1 | 0.0549682899158515 |
| 940611 | 940611 | 336502 336502 | 27449 | 1 | 0.139211136890951 |
| 946638 | 946638 | 339245 339245 | 27449 | 1 | 0.168674698795181 |
| 954110 | 954110 | 342553 342553 | 27449 | 1 | 0.065359477124183 |
| 973415 | 973415 | 352714 352714 | 27449 | 1 | 0.173228346456693 |
| 973418 | 973418 | 352715 352715 | 27449 | 1 | 0.173228346456693 |
| 1065159 | 1065159 | 375724 375724 | 27449 | 8 | 0.334661354581673 |
| 1065165 | 1065165 | 375725 375725 | 27449 | 8 | 0.334661354581673 |
| 1065171 | 1065171 | 375726 375726 | 27449 | 8 | 0.334661354581673 |
| 1065177 | 1065177 | 375727 375727 | 27449 | 8 | 0.334661354581673 |
| 1065183 | 1065183 | 375728 375728 | 27449 | 8 | 0.334661354581673 |
| 1065189 | 1065189 | 375729 375729 | 27449 | 8 | 0.334661354581673 |
| 1065195 | 1065195 | 375730 375730 | 27449 | 8 | 0.334661354581673 |
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)
);