consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
1,027 rows where inchi_id = 32227
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 2554 | 2554 | 692 692 | 32227 | 2 | 0.198675496688742 |
| 7120 | 7120 | 2169 2169 | 32227 | 1 | 0.0167576731494586 |
| 10234 | 10234 | 3100 3100 | 32227 | 1 | 0.3125 |
| 11373 | 11373 | 3464 3464 | 32227 | 8 | 0.461538461538462 |
| 14840 | 14840 | 4675 4675 | 32227 | 8 | 0.461538461538462 |
| 16069 | 16069 | 4838 4838 | 32227 | 1 | 0.037942598827253 |
| 16313 | 16313 | 4870 4870 | 32227 | 1 | 0.0167576731494586 |
| 22842 | 22842 | 6705 6705 | 32227 | 1 | 0.3125 |
| 31031 | 31031 | 9086 9086 | 32227 | 2 | 0.198675496688742 |
| 58737 | 58737 | 18554 18554 | 32227 | 6 | 0.408676458674231 |
| 60235 | 60235 | 19152 19152 | 32227 | 1 | 0.162294146168804 |
| 103980 | 103980 | 36666 36666 | 32227 | 2 | 0.198675496688742 |
| 110696 | 110696 | 38776 38776 | 32227 | 8 | 0.461538461538462 |
| 110713 | 110713 | 38784 38784 | 32227 | 1 | 0.037942598827253 |
| 114025 | 114025 | 39826 39826 | 32227 | 1 | 0.0167576731494586 |
| 116315 | 116315 | 40556 40556 | 32227 | 6 | 0.408676458674231 |
| 133330 | 133330 | 47315 47315 | 32227 | 1 | 0.326530612244898 |
| 152800 | 152800 | 54967 54967 | 32227 | 1 | 0.013751776802937 |
| 156953 | 156953 | 56453 56453 | 32227 | 8 | 0.461538461538462 |
| 156962 | 156962 | 56458 56458 | 32227 | 1 | 0.0376486631796917 |
| 174556 | 174556 | 62353 62353 | 32227 | 1 | 0.177583423460665 |
| 191411 | 191411 | 68082 68082 | 32227 | 2 | 0.198675496688742 |
| 198383 | 198383 | 70527 70527 | 32227 | 2 | 0.198675496688742 |
| 201150 | 201150 | 71441 71441 | 32227 | 1 | 0.0167576731494586 |
| 202274 | 202274 | 71732 71732 | 32227 | 4 | 0.833333333333333 |
| 202305 | 202305 | 71736 71736 | 32227 | 1 | 0.3 |
| 207839 | 207839 | 73638 73638 | 32227 | 8 | 0.461538461538462 |
| 211904 | 211904 | 74140 74140 | 32227 | 1 | 0.037942598827253 |
| 212406 | 212406 | 74208 74208 | 32227 | 1 | 0.0167576731494586 |
| 222037 | 222037 | 76786 76786 | 32227 | 1 | 0.3125 |
| 244406 | 244406 | 83186 83186 | 32227 | 2 | 0.198675496688742 |
| 259583 | 259583 | 87902 87902 | 32227 | 2 | 0.10920446762941 |
| 421480 | 421480 | 152989 152989 | 32227 | 8 | 0.461538461538462 |
| 423653 | 423653 | 153243 153243 | 32227 | 1 | 0.037942598827253 |
| 423897 | 423897 | 153272 153272 | 32227 | 1 | 0.0167576731494586 |
| 430638 | 430638 | 155044 155044 | 32227 | 1 | 0.3125 |
| 440685 | 440685 | 158000 158000 | 32227 | 2 | 0.198675496688742 |
| 501923 | 501923 | 200217 200217 | 32227 | 3 | 0.410359656926802 |
| 502816 | 502816 | 201208 201208 | 32227 | 1 | 0.196078431372549 |
| 511164 | 511164 | 205847 205847 | 32227 | 8 | 0.461538461538462 |
| 511168 | 511168 | 205848 205848 | 32227 | 8 | 0.461538461538462 |
| 512098 | 512098 | 206003 206003 | 32227 | 1 | 0.037942598827253 |
| 512119 | 512119 | 206004 206004 | 32227 | 1 | 0.037942598827253 |
| 512140 | 512140 | 206005 206005 | 32227 | 1 | 0.037942598827253 |
| 512340 | 512340 | 206022 206022 | 32227 | 1 | 0.0167576731494586 |
| 512466 | 512466 | 206023 206023 | 32227 | 1 | 0.0167576731494586 |
| 517608 | 517608 | 207176 207176 | 32227 | 1 | 0.3125 |
| 517610 | 517610 | 207177 207177 | 32227 | 1 | 0.3 |
| 522076 | 522076 | 208316 208316 | 32227 | 2 | 0.198675496688742 |
| 522082 | 522082 | 208317 208317 | 32227 | 2 | 0.198675496688742 |
| 529163 | 529163 | 210127 210127 | 32227 | 6 | 0.408676458674231 |
| 529167 | 529167 | 210128 210128 | 32227 | 6 | 0.408676458674231 |
| 529171 | 529171 | 210129 210129 | 32227 | 6 | 0.408676458674231 |
| 546223 | 546223 | 216116 216116 | 32227 | 1 | 0.013751776802937 |
| 547742 | 547742 | 216600 216600 | 32227 | 1 | 0.037942598827253 |
| 548409 | 548409 | 216814 216814 | 32227 | 2 | 0.198675496688742 |
| 558577 | 558577 | 219844 219844 | 32227 | 8 | 0.891927367625413 |
| 565307 | 565307 | 222043 222043 | 32227 | 6 | 0.408676458674231 |
| 592673 | 592673 | 231056 231056 | 32227 | 2 | 0.190176513656274 |
| 599061 | 599061 | 235816 235816 | 32227 | 1 | 0.0493040021220573 |
| 662147 | 662147 | 237290 237290 | 32227 | 6 | 0.408676458674231 |
| 662757 | 662757 | 237638 237638 | 32227 | 8 | 0.461538461538462 |
| 662761 | 662761 | 237639 237639 | 32227 | 12 | 0.468172484599589 |
| 663919 | 663919 | 237952 237952 | 32227 | 2 | 0.198675496688742 |
| 664014 | 664014 | 237976 237976 | 32227 | 1 | 0.037942598827253 |
| 664038 | 664038 | 237978 237978 | 32227 | 2 | 0.0377407578422941 |
| 664255 | 664255 | 238044 238044 | 32227 | 2 | 0.0167689878330504 |
| 673238 | 673238 | 240783 240783 | 32227 | 1 | 0.3125 |
| 688051 | 688051 | 245394 245394 | 32227 | 1 | 0.310344827586207 |
| 698031 | 698031 | 248825 248825 | 32227 | 6 | 0.408676458674231 |
| 706399 | 706399 | 251076 251076 | 32227 | 8 | 0.461538461538462 |
| 718395 | 718395 | 254064 254064 | 32227 | 2 | 0.198675496688742 |
| 721136 | 721136 | 254916 254916 | 32227 | 1 | 0.0167576731494586 |
| 745876 | 745876 | 262405 262405 | 32227 | 1 | 0.3125 |
| 745878 | 745878 | 262406 262406 | 32227 | 1 | 0.3 |
| 755493 | 755493 | 265498 265498 | 32227 | 1 | 0.0141493202732023 |
| 790933 | 790933 | 276133 276133 | 32227 | 6 | 0.408676458674231 |
| 790936 | 790936 | 276134 276134 | 32227 | 3 | 0.524040820577346 |
| 803407 | 803407 | 280138 280138 | 32227 | 8 | 0.461538461538462 |
| 803410 | 803410 | 280139 280139 | 32227 | 8 | 0.891927367625413 |
| 822326 | 822326 | 285531 285531 | 32227 | 2 | 0.198675496688742 |
| 824474 | 824474 | 286139 286139 | 32227 | 1 | 0.037942598827253 |
| 827245 | 827245 | 287120 287120 | 32227 | 1 | 0.0167576731494586 |
| 830603 | 830603 | 288233 288233 | 32227 | 4 | 0.452830188679245 |
| 854495 | 854495 | 295563 295563 | 32227 | 4 | 0.31304347826087 |
| 854500 | 854500 | 295564 295564 | 32227 | 4 | 0.31304347826087 |
| 926418 | 926418 | 329449 329449 | 32227 | 1 | 0.3 |
| 933822 | 933822 | 332763 332763 | 32227 | 3 | 0.524040820577346 |
| 939817 | 939817 | 335979 335979 | 32227 | 4 | 0.833333333333333 |
| 939871 | 939871 | 336016 336016 | 32227 | 1 | 0.212215885571685 |
| 939893 | 939893 | 336032 336032 | 32227 | 1 | 0.3 |
| 1050276 | 1050276 | 371540 371540 | 32227 | 6 | 0.408676458674231 |
| 1050280 | 1050280 | 371541 371541 | 32227 | 6 | 0.408676458674231 |
| 1050284 | 1050284 | 371542 371542 | 32227 | 6 | 0.408676458674231 |
| 1050288 | 1050288 | 371543 371543 | 32227 | 6 | 0.408676458674231 |
| 1050292 | 1050292 | 371544 371544 | 32227 | 6 | 0.408676458674231 |
| 1050296 | 1050296 | 371545 371545 | 32227 | 6 | 0.408676458674231 |
| 1050300 | 1050300 | 371546 371546 | 32227 | 6 | 0.408676458674231 |
| 1050304 | 1050304 | 371547 371547 | 32227 | 6 | 0.408676458674231 |
| 1050308 | 1050308 | 371548 371548 | 32227 | 6 | 0.408676458674231 |
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)
);