consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
99 rows where inchi_id = 31491
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 10606 | 10606 | 3225 3225 | 31491 | 1 | 0.240740740740741 |
| 26338 | 26338 | 7706 7706 | 31491 | 1 | 0.10329403032785 |
| 27152 | 27152 | 7897 7897 | 31491 | 6 | 0.385964912280702 |
| 40123 | 40123 | 12144 12144 | 31491 | 2 | 0.174652091778393 |
| 57611 | 57611 | 18124 18124 | 31491 | 1 | 0.155070415739335 |
| 61814 | 61814 | 19869 19869 | 31491 | 1 | 0.310344827586207 |
| 118117 | 118117 | 41197 41197 | 31491 | 6 | 0.385964912280702 |
| 118120 | 118120 | 41198 41198 | 31491 | 2 | 0.174652091778393 |
| 118130 | 118130 | 41200 41200 | 31491 | 1 | 0.10329403032785 |
| 118205 | 118205 | 41224 41224 | 31491 | 1 | 0.155070415739335 |
| 160613 | 160613 | 57730 57730 | 31491 | 9 | 0.167508240548114 |
| 160632 | 160632 | 57731 57731 | 31491 | 3 | 0.172315508219319 |
| 160698 | 160698 | 57739 57739 | 31491 | 1 | 0.155070415739335 |
| 161132 | 161132 | 57849 57849 | 31491 | 1 | 0.10329403032785 |
| 174733 | 174733 | 62415 62415 | 31491 | 1 | 0.3125 |
| 200936 | 200936 | 71375 71375 | 31491 | 1 | 0.240740740740741 |
| 228270 | 228270 | 78463 78463 | 31491 | 1 | 0.106708549418785 |
| 230435 | 230435 | 78953 78953 | 31491 | 6 | 0.384615384615385 |
| 271038 | 271038 | 91931 91931 | 31491 | 2 | 0.226279508484369 |
| 281368 | 281368 | 95428 95428 | 31491 | 2 | 0.16952834413753 |
| 338952 | 338952 | 114294 114294 | 31491 | 1 | 0.153846153846154 |
| 358876 | 358876 | 121809 121809 | 31491 | 1 | 0.3125 |
| 428446 | 428446 | 154420 154420 | 31491 | 1 | 0.3125 |
| 434616 | 434616 | 156148 156148 | 31491 | 1 | 0.106708549418785 |
| 435617 | 435617 | 156349 156349 | 31491 | 3 | 0.375 |
| 450973 | 450973 | 161819 161819 | 31491 | 2 | 0.226279508484369 |
| 477612 | 477612 | 174206 174206 | 31491 | 1 | 0.153846153846154 |
| 485301 | 485301 | 179524 179524 | 31491 | 1 | 0.310344827586207 |
| 515744 | 515744 | 206729 206729 | 31491 | 1 | 0.3125 |
| 515746 | 515746 | 206730 206730 | 31491 | 1 | 0.304347826086957 |
| 520742 | 520742 | 207915 207915 | 31491 | 6 | 0.384615384615385 |
| 531500 | 531500 | 210809 210809 | 31491 | 1 | 0.240740740740741 |
| 558683 | 558683 | 219877 219877 | 31491 | 2 | 0.16952834413753 |
| 565867 | 565867 | 222198 222198 | 31491 | 5 | 0.384615384615385 |
| 579623 | 579623 | 226925 226925 | 31491 | 1 | 0.104713228574825 |
| 660642 | 660642 | 236483 236483 | 31491 | 1 | 0.106708549418785 |
| 662086 | 662086 | 237268 237268 | 31491 | 6 | 0.384615384615385 |
| 667412 | 667412 | 239148 239148 | 31491 | 1 | 0.318181818181818 |
| 684174 | 684174 | 244123 244123 | 31491 | 1 | 0.10329403032785 |
| 696013 | 696013 | 248138 248138 | 31491 | 1 | 0.155070415739335 |
| 697351 | 697351 | 248628 248628 | 31491 | 8 | 0.388888888888889 |
| 706238 | 706238 | 251030 251030 | 31491 | 2 | 0.174652091778393 |
| 736514 | 736514 | 259758 259758 | 31491 | 1 | 0.314285714285714 |
| 766283 | 766283 | 268325 268325 | 31491 | 1 | 0.104713228574825 |
| 766287 | 766287 | 268326 268326 | 31491 | 1 | 0.10329403032785 |
| 786650 | 786650 | 274796 274796 | 31491 | 1 | 0.155070415739335 |
| 789754 | 789754 | 275820 275820 | 31491 | 5 | 0.384615384615385 |
| 789757 | 789757 | 275821 275821 | 31491 | 5 | 0.382978723404255 |
| 789760 | 789760 | 275822 275822 | 31491 | 5 | 0.382978723404255 |
| 789763 | 789763 | 275823 275823 | 31491 | 6 | 0.385964912280702 |
| 789766 | 789766 | 275824 275824 | 31491 | 3 | 0.378378378378378 |
| 803175 | 803175 | 280064 280064 | 31491 | 1 | 0.174630715011015 |
| 803180 | 803180 | 280065 280065 | 31491 | 2 | 0.174652091778393 |
| 859193 | 859193 | 297221 297221 | 31491 | 1 | 0.3125 |
| 859195 | 859195 | 297222 297222 | 31491 | 1 | 0.3125 |
| 927188 | 927188 | 329758 329758 | 31491 | 3 | 0.375 |
| 958820 | 958820 | 344943 344943 | 31491 | 1 | 0.150741041020006 |
| 959248 | 959248 | 345146 345146 | 31491 | 1 | 0.104713228574825 |
| 959277 | 959277 | 345157 345157 | 31491 | 1 | 0.174630715011015 |
| 1047429 | 1047429 | 370699 370699 | 31491 | 1 | 0.155070415739335 |
| 1049458 | 1049458 | 371310 371310 | 31491 | 6 | 0.385964912280702 |
| 1049461 | 1049461 | 371311 371311 | 31491 | 6 | 0.385964912280702 |
| 1049464 | 1049464 | 371312 371312 | 31491 | 6 | 0.385964912280702 |
| 1049467 | 1049467 | 371313 371313 | 31491 | 6 | 0.385964912280702 |
| 1049470 | 1049470 | 371314 371314 | 31491 | 6 | 0.385964912280702 |
| 1049473 | 1049473 | 371315 371315 | 31491 | 6 | 0.385964912280702 |
| 1049476 | 1049476 | 371316 371316 | 31491 | 6 | 0.385964912280702 |
| 1049479 | 1049479 | 371317 371317 | 31491 | 6 | 0.385964912280702 |
| 1268705 | 1268705 | 417599 417599 | 31491 | 1 | 0.155070415739335 |
| 1271274 | 1271274 | 418332 418332 | 31491 | 6 | 0.385964912280702 |
| 1271277 | 1271277 | 418333 418333 | 31491 | 6 | 0.385964912280702 |
| 1271280 | 1271280 | 418334 418334 | 31491 | 6 | 0.385964912280702 |
| 1271283 | 1271283 | 418335 418335 | 31491 | 6 | 0.385964912280702 |
| 1271286 | 1271286 | 418336 418336 | 31491 | 6 | 0.385964912280702 |
| 1271289 | 1271289 | 418337 418337 | 31491 | 6 | 0.385964912280702 |
| 1271292 | 1271292 | 418338 418338 | 31491 | 6 | 0.385964912280702 |
| 1271295 | 1271295 | 418339 418339 | 31491 | 6 | 0.385964912280702 |
| 1271298 | 1271298 | 418340 418340 | 31491 | 6 | 0.385964912280702 |
| 1489770 | 1489770 | 460988 460988 | 31491 | 1 | 0.155070415739335 |
| 1491359 | 1491359 | 461463 461463 | 31491 | 6 | 0.385964912280702 |
| 1491362 | 1491362 | 461464 461464 | 31491 | 6 | 0.385964912280702 |
| 1491365 | 1491365 | 461465 461465 | 31491 | 6 | 0.385964912280702 |
| 1491368 | 1491368 | 461466 461466 | 31491 | 6 | 0.385964912280702 |
| 1491371 | 1491371 | 461467 461467 | 31491 | 6 | 0.385964912280702 |
| 1491374 | 1491374 | 461468 461468 | 31491 | 6 | 0.385964912280702 |
| 1491377 | 1491377 | 461469 461469 | 31491 | 6 | 0.385964912280702 |
| 1491380 | 1491380 | 461470 461470 | 31491 | 6 | 0.385964912280702 |
| 1597681 | 1597681 | 482525 482525 | 31491 | 1 | 0.155070415739335 |
| 1598142 | 1598142 | 482687 482687 | 31491 | 6 | 0.385964912280702 |
| 1614076 | 1614076 | 487315 487315 | 31491 | 1 | 0.3125 |
| 1621021 | 1621021 | 489509 489509 | 31491 | 1 | 0.103585843033628 |
| 1621979 | 1621979 | 489762 489762 | 31491 | 6 | 0.385964912280702 |
| 1646007 | 1646007 | 498352 498352 | 31491 | 1 | 0.16921310877339 |
| 1673776 | 1673776 | 507965 507965 | 31491 | 1 | 0.155070415739335 |
| 1718701 | 1718701 | 526382 526382 | 31491 | 1 | 0.3 |
| 1723112 | 1723112 | 527706 527706 | 31491 | 1 | 0.10329403032785 |
| 1723753 | 1723753 | 527889 527889 | 31491 | 6 | 0.385964912280702 |
| 1736203 | 1736203 | 531873 531873 | 31491 | 2 | 0.174652091778393 |
| 1751819 | 1751819 | 536649 536649 | 31491 | 1 | 0.155070415739335 |
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)
);