consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
80 rows where inchi_id = 26771
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 11022 | 11022 | 3362 3362 | 26771 | 8 | 0.9 |
| 11023 | 11023 | 3363 3363 | 26771 | 1 | 0.0939759036144578 |
| 11029 | 11029 | 3364 3364 | 26771 | 2 | 0.155830052441634 |
| 19860 | 19860 | 5829 5829 | 26771 | 1 | 0.115384615384615 |
| 29710 | 29710 | 8606 8606 | 26771 | 8 | 0.9 |
| 33084 | 33084 | 9763 9763 | 26771 | 2 | 0.217628593632124 |
| 117000 | 117000 | 40826 40826 | 26771 | 8 | 0.9 |
| 117124 | 117124 | 40882 40882 | 26771 | 1 | 0.115384615384615 |
| 117460 | 117460 | 41006 41006 | 26771 | 2 | 0.217628593632124 |
| 137979 | 137979 | 49121 49121 | 26771 | 16 | 0.642857142857143 |
| 137981 | 137981 | 49122 49122 | 26771 | 1 | 0.0946196660482375 |
| 137987 | 137987 | 49123 49123 | 26771 | 3 | 0.157223627144589 |
| 218580 | 218580 | 75768 75768 | 26771 | 1 | 0.0939759036144578 |
| 240269 | 240269 | 81678 81678 | 26771 | 8 | 0.9 |
| 254933 | 254933 | 86568 86568 | 26771 | 2 | 0.155830052441634 |
| 428032 | 428032 | 154294 154294 | 26771 | 1 | 0.0862068965517241 |
| 438741 | 438741 | 157245 157245 | 26771 | 8 | 0.625 |
| 444413 | 444413 | 159326 159326 | 26771 | 2 | 0.217628593632124 |
| 515346 | 515346 | 206616 206616 | 26771 | 1 | 0.0939759036144578 |
| 515352 | 515352 | 206617 206617 | 26771 | 1 | 0.0738916256157636 |
| 521690 | 521690 | 208169 208169 | 26771 | 8 | 0.9 |
| 521691 | 521691 | 208170 208170 | 26771 | 8 | 0.9 |
| 532278 | 532278 | 211111 211111 | 26771 | 1 | 0.0862068965517241 |
| 552643 | 552643 | 218219 218219 | 26771 | 8 | 0.9 |
| 585091 | 585091 | 228545 228545 | 26771 | 2 | 0.155830052441634 |
| 599525 | 599525 | 236253 236253 | 26771 | 2 | 0.155830052441634 |
| 663563 | 663563 | 237828 237828 | 26771 | 8 | 0.625 |
| 679551 | 679551 | 242868 242868 | 26771 | 2 | 0.217628593632124 |
| 713241 | 713241 | 252652 252652 | 26771 | 12 | 0.636363636363636 |
| 735945 | 735945 | 259581 259581 | 26771 | 1 | 0.0866261398176292 |
| 807150 | 807150 | 281094 281094 | 26771 | 1 | 0.196779964221825 |
| 814600 | 814600 | 283078 283078 | 26771 | 8 | 0.9 |
| 858093 | 858093 | 296832 296832 | 26771 | 1 | 0.0939759036144578 |
| 858098 | 858098 | 296833 296833 | 26771 | 1 | 0.115384615384615 |
| 885012 | 885012 | 308131 308131 | 26771 | 4 | 0.833333333333333 |
| 895413 | 895413 | 314385 314385 | 26771 | 1 | 0.113207547169811 |
| 928876 | 928876 | 330448 330448 | 26771 | 1 | 0.212215885571685 |
| 1010530 | 1010530 | 360797 360797 | 26771 | 2 | 0.217628593632124 |
| 1071319 | 1071319 | 376404 376404 | 26771 | 8 | 0.9 |
| 1071320 | 1071320 | 376405 376405 | 26771 | 8 | 0.9 |
| 1071321 | 1071321 | 376406 376406 | 26771 | 8 | 0.9 |
| 1071322 | 1071322 | 376407 376407 | 26771 | 8 | 0.9 |
| 1071323 | 1071323 | 376408 376408 | 26771 | 8 | 0.9 |
| 1071324 | 1071324 | 376409 376409 | 26771 | 8 | 0.9 |
| 1175188 | 1175188 | 394407 394407 | 26771 | 1 | 0.115384615384615 |
| 1175192 | 1175192 | 394408 394408 | 26771 | 1 | 0.115384615384615 |
| 1175196 | 1175196 | 394409 394409 | 26771 | 1 | 0.115384615384615 |
| 1175200 | 1175200 | 394410 394410 | 26771 | 1 | 0.115384615384615 |
| 1221789 | 1221789 | 405189 405189 | 26771 | 2 | 0.217628593632124 |
| 1297275 | 1297275 | 424304 424304 | 26771 | 8 | 0.9 |
| 1297276 | 1297276 | 424305 424305 | 26771 | 8 | 0.9 |
| 1297277 | 1297277 | 424306 424306 | 26771 | 8 | 0.9 |
| 1297278 | 1297278 | 424307 424307 | 26771 | 8 | 0.9 |
| 1297279 | 1297279 | 424308 424308 | 26771 | 8 | 0.9 |
| 1297280 | 1297280 | 424309 424309 | 26771 | 8 | 0.9 |
| 1297281 | 1297281 | 424310 424310 | 26771 | 8 | 0.9 |
| 1297282 | 1297282 | 424311 424311 | 26771 | 8 | 0.9 |
| 1297283 | 1297283 | 424312 424312 | 26771 | 8 | 0.9 |
| 1297284 | 1297284 | 424313 424313 | 26771 | 8 | 0.9 |
| 1430724 | 1430724 | 446086 446086 | 26771 | 1 | 0.115384615384615 |
| 1430728 | 1430728 | 446087 446087 | 26771 | 1 | 0.115384615384615 |
| 1430732 | 1430732 | 446088 446088 | 26771 | 1 | 0.115384615384615 |
| 1430736 | 1430736 | 446089 446089 | 26771 | 1 | 0.115384615384615 |
| 1430740 | 1430740 | 446090 446090 | 26771 | 1 | 0.115384615384615 |
| 1430744 | 1430744 | 446091 446091 | 26771 | 1 | 0.115384615384615 |
| 1462072 | 1462072 | 453541 453541 | 26771 | 2 | 0.217628593632124 |
| 1507280 | 1507280 | 465203 465203 | 26771 | 8 | 0.9 |
| 1507281 | 1507281 | 465204 465204 | 26771 | 8 | 0.9 |
| 1507282 | 1507282 | 465205 465205 | 26771 | 8 | 0.9 |
| 1587596 | 1587596 | 479258 479258 | 26771 | 1 | 0.115384615384615 |
| 1587600 | 1587600 | 479259 479259 | 26771 | 1 | 0.115384615384615 |
| 1593151 | 1593151 | 480903 480903 | 26771 | 2 | 0.217628593632124 |
| 1601302 | 1601302 | 483691 483691 | 26771 | 8 | 0.9 |
| 1607223 | 1607223 | 485559 485559 | 26771 | 1 | 0.115384615384615 |
| 1613654 | 1613654 | 487169 487169 | 26771 | 1 | 0.115384615384615 |
| 1626058 | 1626058 | 491023 491023 | 26771 | 8 | 0.9 |
| 1633590 | 1633590 | 493808 493808 | 26771 | 2 | 0.217628593632124 |
| 1718416 | 1718416 | 526290 526290 | 26771 | 1 | 0.0862068965517241 |
| 1726334 | 1726334 | 528589 528589 | 26771 | 8 | 0.625 |
| 1729598 | 1729598 | 529690 529690 | 26771 | 1 | 0.212215885571685 |
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)
);