consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
242 rows where inchi_id = 7017
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 18333 | 18333 | 5364 5364 | 7017 | 1 | 0.0428310585123457 |
| 23787 | 23787 | 6974 6974 | 7017 | 1 | 0.134258947327282 |
| 25216 | 25216 | 7416 7416 | 7017 | 8 | 0.297467900805702 |
| 29199 | 29199 | 8459 8459 | 7017 | 1 | 0.0303304483664433 |
| 30066 | 30066 | 8727 8727 | 7017 | 1 | 0.0330519889784114 |
| 30978 | 30978 | 9070 9070 | 7017 | 1 | 0.053715308863026 |
| 30988 | 30988 | 9072 9072 | 7017 | 1 | 0.0542444857928019 |
| 31001 | 31001 | 9073 9073 | 7017 | 1 | 0.0758261209161081 |
| 32652 | 32652 | 9621 9621 | 7017 | 1 | 0.173228346456693 |
| 107686 | 107686 | 37848 37848 | 7017 | 8 | 0.297467900805702 |
| 108669 | 108669 | 38098 38098 | 7017 | 1 | 0.134258947327282 |
| 108890 | 108890 | 38158 38158 | 7017 | 1 | 0.0428310585123457 |
| 111693 | 111693 | 39080 39080 | 7017 | 1 | 0.0303304483664433 |
| 115407 | 115407 | 40252 40252 | 7017 | 1 | 0.0330519889784114 |
| 122649 | 122649 | 42630 42630 | 7017 | 1 | 0.0542444857928019 |
| 123474 | 123474 | 42877 42877 | 7017 | 1 | 0.173228346456693 |
| 143931 | 143931 | 51327 51327 | 7017 | 1 | 0.0387057600297427 |
| 149262 | 149262 | 53633 53633 | 7017 | 12 | 0.298038960541294 |
| 176338 | 176338 | 62902 62902 | 7017 | 1 | 0.0331154400601437 |
| 176731 | 176731 | 63032 63032 | 7017 | 1 | 0.00839908336687741 |
| 177081 | 177081 | 63104 63104 | 7017 | 1 | 0.0221682007774484 |
| 177170 | 177170 | 63128 63128 | 7017 | 1 | 0.134400472550537 |
| 177660 | 177660 | 63324 63324 | 7017 | 1 | 0.0303949162992696 |
| 178195 | 178195 | 63494 63494 | 7017 | 1 | 0.0540002842120222 |
| 178324 | 178324 | 63542 63542 | 7017 | 1 | 0.0544065685204803 |
| 178473 | 178473 | 63601 63601 | 7017 | 1 | 0.0659874470766123 |
| 178572 | 178572 | 63642 63642 | 7017 | 1 | 0.139130434782609 |
| 196688 | 196688 | 69808 69808 | 7017 | 1 | 0.0133297308929861 |
| 198154 | 198154 | 70472 70472 | 7017 | 1 | 0.0167422399646408 |
| 209906 | 209906 | 73910 73910 | 7017 | 1 | 0.0210237903965387 |
| 209979 | 209979 | 73911 73911 | 7017 | 1 | 0.0159458911686544 |
| 223239 | 223239 | 77118 77118 | 7017 | 1 | 0.134258947327282 |
| 223260 | 223260 | 77120 77120 | 7017 | 1 | 0.110323089046493 |
| 223370 | 223370 | 77154 77154 | 7017 | 1 | 0.00839869839693106 |
| 225490 | 225490 | 77758 77758 | 7017 | 8 | 0.297467900805702 |
| 228590 | 228590 | 78543 78543 | 7017 | 1 | 0.0253691249723686 |
| 238784 | 238784 | 81249 81249 | 7017 | 1 | 0.0157403433936959 |
| 238817 | 238817 | 81252 81252 | 7017 | 1 | 0.0303304483664433 |
| 241311 | 241311 | 82022 82022 | 7017 | 1 | 0.0330519889784114 |
| 244328 | 244328 | 83154 83154 | 7017 | 1 | 0.053715308863026 |
| 244337 | 244337 | 83156 83156 | 7017 | 1 | 0.0542444857928019 |
| 244351 | 244351 | 83158 83158 | 7017 | 1 | 0.0758261209161081 |
| 252903 | 252903 | 85919 85919 | 7017 | 1 | 0.173228346456693 |
| 422471 | 422471 | 153119 153119 | 7017 | 1 | 0.0210237903965387 |
| 422544 | 422544 | 153120 153120 | 7017 | 1 | 0.0159458911686544 |
| 431667 | 431667 | 155315 155315 | 7017 | 1 | 0.134258947327282 |
| 431688 | 431688 | 155317 155317 | 7017 | 1 | 0.110323089046493 |
| 431776 | 431776 | 155348 155348 | 7017 | 1 | 0.00839869839693106 |
| 433157 | 433157 | 155752 155752 | 7017 | 8 | 0.9 |
| 438137 | 438137 | 157053 157053 | 7017 | 1 | 0.0303304483664433 |
| 439264 | 439264 | 157434 157434 | 7017 | 1 | 0.0330519889784114 |
| 440622 | 440622 | 157974 157974 | 7017 | 1 | 0.053715308863026 |
| 440632 | 440632 | 157977 157977 | 7017 | 1 | 0.0542444857928019 |
| 440646 | 440646 | 157979 157979 | 7017 | 1 | 0.0758261209161081 |
| 489946 | 489946 | 183728 183728 | 7017 | 2 | 0.630993034743972 |
| 518759 | 518759 | 207420 207420 | 7017 | 1 | 0.110323089046493 |
| 519547 | 519547 | 207637 207637 | 7017 | 8 | 0.297467900805702 |
| 519562 | 519562 | 207638 207638 | 7017 | 8 | 0.297467900805702 |
| 548626 | 548626 | 216863 216863 | 7017 | 1 | 0.0542444857928019 |
| 548639 | 548639 | 216866 216866 | 7017 | 1 | 0.053715308863026 |
| 551161 | 551161 | 217813 217813 | 7017 | 1 | 0.0330519889784114 |
| 555000 | 555000 | 218819 218819 | 7017 | 1 | 0.0303304483664433 |
| 555035 | 555035 | 218823 218823 | 7017 | 1 | 0.0125359617652613 |
| 586258 | 586258 | 228912 228912 | 7017 | 8 | 0.297467900805702 |
| 590772 | 590772 | 230538 230538 | 7017 | 1 | 0.173228346456693 |
| 590800 | 590800 | 230544 230544 | 7017 | 1 | 0.0428310585123457 |
| 590948 | 590948 | 230584 230584 | 7017 | 1 | 0.134258947327282 |
| 598610 | 598610 | 235700 235700 | 7017 | 1 | 0.134258947327282 |
| 598676 | 598676 | 235713 235713 | 7017 | 1 | 0.00839869839693106 |
| 598782 | 598782 | 235716 235716 | 7017 | 1 | 0.0428310585123457 |
| 598809 | 598809 | 235717 235717 | 7017 | 1 | 0.173228346456693 |
| 599322 | 599322 | 235882 235882 | 7017 | 8 | 0.297467900805702 |
| 660782 | 660782 | 236546 236546 | 7017 | 1 | 0.0253691249723686 |
| 663085 | 663085 | 237743 237743 | 7017 | 1 | 0.0303304483664433 |
| 663379 | 663379 | 237812 237812 | 7017 | 1 | 0.0159458911686544 |
| 663652 | 663652 | 237856 237856 | 7017 | 1 | 0.0330519889784114 |
| 663907 | 663907 | 237947 237947 | 7017 | 1 | 0.0542444857928019 |
| 674835 | 674835 | 241194 241194 | 7017 | 1 | 0.173228346456693 |
| 675014 | 675014 | 241377 241377 | 7017 | 1 | 0.134258947327282 |
| 675172 | 675172 | 241429 241429 | 7017 | 1 | 0.00839908336687741 |
| 675333 | 675333 | 241449 241449 | 7017 | 1 | 0.0428310585123457 |
| 678350 | 678350 | 242581 242581 | 7017 | 8 | 0.297467900805702 |
| 710450 | 710450 | 252041 252041 | 7017 | 1 | 0.0125359617652613 |
| 710488 | 710488 | 252045 252045 | 7017 | 1 | 0.0303304483664433 |
| 712676 | 712676 | 252547 252547 | 7017 | 1 | 0.0167422399646408 |
| 714962 | 714962 | 253048 253048 | 7017 | 1 | 0.0330519889784114 |
| 718298 | 718298 | 254036 254036 | 7017 | 1 | 0.053715308863026 |
| 718309 | 718309 | 254039 254039 | 7017 | 1 | 0.0542444857928019 |
| 718328 | 718328 | 254041 254041 | 7017 | 1 | 0.0758261209161081 |
| 748985 | 748985 | 263332 263332 | 7017 | 1 | 0.173228346456693 |
| 749362 | 749362 | 263474 263474 | 7017 | 1 | 0.134258947327282 |
| 749392 | 749392 | 263482 263482 | 7017 | 1 | 0.110323089046493 |
| 749700 | 749700 | 263590 263590 | 7017 | 1 | 0.00839869839693106 |
| 749912 | 749912 | 263629 263629 | 7017 | 1 | 0.0428310585123457 |
| 755119 | 755119 | 265401 265401 | 7017 | 8 | 0.297467900805702 |
| 755129 | 755129 | 265402 265402 | 7017 | 8 | 0.9 |
| 767076 | 767076 | 268561 268561 | 7017 | 1 | 0.0253691249723686 |
| 809817 | 809817 | 281928 281928 | 7017 | 1 | 0.0157403433936959 |
| 809872 | 809872 | 281937 281937 | 7017 | 1 | 0.0303304483664433 |
| 813755 | 813755 | 282914 282914 | 7017 | 1 | 0.0210237903965387 |
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)
);