consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
85 rows where inchi_id = 67789
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 7754 | 7754 | 2336 2336 | 67789 | 1 | 0.239130434782609 |
| 12901 | 12901 | 3973 3973 | 67789 | 12 | 0.400071212034661 |
| 19670 | 19670 | 5761 5761 | 67789 | 1 | 0.173228346456693 |
| 20444 | 20444 | 6002 6002 | 67789 | 8 | 0.461538461538462 |
| 30494 | 30494 | 8887 8887 | 67789 | 1 | 0.3125 |
| 82627 | 82627 | 29753 29753 | 67789 | 1 | 0.3125 |
| 82632 | 82632 | 29755 29755 | 67789 | 8 | 0.461538461538462 |
| 96498 | 96498 | 34208 34208 | 67789 | 1 | 0.173228346456693 |
| 155607 | 155607 | 55965 55965 | 67789 | 1 | 0.3125 |
| 155609 | 155609 | 55966 55966 | 67789 | 14 | 0.400875114756642 |
| 206069 | 206069 | 73032 73032 | 67789 | 1 | 0.239130434782609 |
| 206805 | 206805 | 73302 73302 | 67789 | 8 | 0.397837341614278 |
| 218123 | 218123 | 75638 75638 | 67789 | 1 | 0.111553784860558 |
| 242930 | 242930 | 82616 82616 | 67789 | 1 | 0.239130434782609 |
| 246040 | 246040 | 83734 83734 | 67789 | 8 | 0.397837341614278 |
| 441325 | 441325 | 158210 158210 | 67789 | 8 | 0.309278350515464 |
| 504054 | 504054 | 201656 201656 | 67789 | 1 | 0.239130434782609 |
| 522226 | 522226 | 208363 208363 | 67789 | 8 | 0.397837341614278 |
| 522231 | 522231 | 208364 208364 | 67789 | 8 | 0.397837341614278 |
| 533052 | 533052 | 211465 211465 | 67789 | 1 | 0.11214953271028 |
| 543815 | 543815 | 215105 215105 | 67789 | 12 | 0.279664635935305 |
| 549731 | 549731 | 217365 217365 | 67789 | 1 | 0.3125 |
| 663810 | 663810 | 237899 237899 | 67789 | 1 | 0.239130434782609 |
| 664598 | 664598 | 238138 238138 | 67789 | 8 | 0.397837341614278 |
| 716919 | 716919 | 253568 253568 | 67789 | 1 | 0.241935483870968 |
| 723280 | 723280 | 255657 255657 | 67789 | 12 | 0.400071212034661 |
| 735415 | 735415 | 259399 259399 | 67789 | 1 | 0.173228346456693 |
| 800544 | 800544 | 279263 279263 | 67789 | 1 | 0.3125 |
| 820083 | 820083 | 284609 284609 | 67789 | 1 | 0.3125 |
| 820085 | 820085 | 284610 284610 | 67789 | 1 | 0.304347826086957 |
| 832988 | 832988 | 289117 289117 | 67789 | 8 | 0.461538461538462 |
| 832992 | 832992 | 289118 289118 | 67789 | 5 | 0.455696202531646 |
| 832996 | 832996 | 289119 289119 | 67789 | 8 | 0.461538461538462 |
| 857246 | 857246 | 296495 296495 | 67789 | 1 | 0.173228346456693 |
| 857249 | 857249 | 296496 296496 | 67789 | 1 | 0.111553784860558 |
| 874245 | 874245 | 302073 302073 | 67789 | 1 | 0.0438441098440923 |
| 880459 | 880459 | 305817 305817 | 67789 | 1 | 0.3 |
| 891012 | 891012 | 312333 312333 | 67789 | 4 | 0.452830188679245 |
| 943488 | 943488 | 337853 337853 | 67789 | 1 | 0.168674698795181 |
| 1074235 | 1074235 | 377216 377216 | 67789 | 1 | 0.3125 |
| 1074237 | 1074237 | 377217 377217 | 67789 | 1 | 0.3125 |
| 1074239 | 1074239 | 377218 377218 | 67789 | 1 | 0.3125 |
| 1074241 | 1074241 | 377219 377219 | 67789 | 1 | 0.3125 |
| 1074243 | 1074243 | 377220 377220 | 67789 | 1 | 0.3125 |
| 1074245 | 1074245 | 377221 377221 | 67789 | 1 | 0.3125 |
| 1074247 | 1074247 | 377222 377222 | 67789 | 1 | 0.3125 |
| 1112379 | 1112379 | 383004 383004 | 67789 | 8 | 0.461538461538462 |
| 1112383 | 1112383 | 383005 383005 | 67789 | 8 | 0.461538461538462 |
| 1112387 | 1112387 | 383006 383006 | 67789 | 8 | 0.461538461538462 |
| 1112391 | 1112391 | 383007 383007 | 67789 | 8 | 0.461538461538462 |
| 1300623 | 1300623 | 425212 425212 | 67789 | 1 | 0.3125 |
| 1300625 | 1300625 | 425213 425213 | 67789 | 1 | 0.3125 |
| 1300627 | 1300627 | 425214 425214 | 67789 | 1 | 0.3125 |
| 1300629 | 1300629 | 425215 425215 | 67789 | 1 | 0.3125 |
| 1300631 | 1300631 | 425216 425216 | 67789 | 1 | 0.3125 |
| 1300633 | 1300633 | 425217 425217 | 67789 | 1 | 0.3125 |
| 1300635 | 1300635 | 425218 425218 | 67789 | 1 | 0.3125 |
| 1300637 | 1300637 | 425219 425219 | 67789 | 1 | 0.3125 |
| 1300639 | 1300639 | 425220 425220 | 67789 | 1 | 0.3125 |
| 1300641 | 1300641 | 425221 425221 | 67789 | 1 | 0.3125 |
| 1300643 | 1300643 | 425222 425222 | 67789 | 1 | 0.3125 |
| 1300645 | 1300645 | 425223 425223 | 67789 | 1 | 0.3125 |
| 1300647 | 1300647 | 425224 425224 | 67789 | 1 | 0.3125 |
| 1346273 | 1346273 | 431734 431734 | 67789 | 8 | 0.461538461538462 |
| 1346277 | 1346277 | 431735 431735 | 67789 | 8 | 0.461538461538462 |
| 1346281 | 1346281 | 431736 431736 | 67789 | 8 | 0.461538461538462 |
| 1346285 | 1346285 | 431737 431737 | 67789 | 8 | 0.461538461538462 |
| 1346289 | 1346289 | 431738 431738 | 67789 | 8 | 0.461538461538462 |
| 1346293 | 1346293 | 431739 431739 | 67789 | 8 | 0.461538461538462 |
| 1509417 | 1509417 | 465810 465810 | 67789 | 1 | 0.3125 |
| 1509419 | 1509419 | 465811 465811 | 67789 | 1 | 0.3125 |
| 1509421 | 1509421 | 465812 465812 | 67789 | 1 | 0.3125 |
| 1509423 | 1509423 | 465813 465813 | 67789 | 1 | 0.3125 |
| 1538261 | 1538261 | 470395 470395 | 67789 | 8 | 0.461538461538462 |
| 1538265 | 1538265 | 470396 470396 | 67789 | 8 | 0.461538461538462 |
| 1538269 | 1538269 | 470397 470397 | 67789 | 8 | 0.461538461538462 |
| 1538273 | 1538273 | 470398 470398 | 67789 | 8 | 0.461538461538462 |
| 1601863 | 1601863 | 483871 483871 | 67789 | 1 | 0.3125 |
| 1603556 | 1603556 | 484488 484488 | 67789 | 8 | 0.461538461538462 |
| 1613361 | 1613361 | 487067 487067 | 67789 | 1 | 0.173228346456693 |
| 1627518 | 1627518 | 491594 491594 | 67789 | 1 | 0.3125 |
| 1629783 | 1629783 | 492464 492464 | 67789 | 8 | 0.461538461538462 |
| 1726954 | 1726954 | 528816 528816 | 67789 | 1 | 0.310344827586207 |
| 1727657 | 1727657 | 529079 529079 | 67789 | 8 | 0.461538461538462 |
| 1735692 | 1735692 | 531703 531703 | 67789 | 1 | 0.3125 |
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)
);