consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
69 rows where inchi_id = 47020
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 8517 | 8517 | 2571 2571 | 47020 | 1 | 0.209016393442623 |
| 19825 | 19825 | 5816 5816 | 47020 | 1 | 0.259842519685039 |
| 97218 | 97218 | 34479 34479 | 47020 | 1 | 0.259842519685039 |
| 160073 | 160073 | 57556 57556 | 47020 | 1 | 0.174107142857143 |
| 218526 | 218526 | 75753 75753 | 47020 | 1 | 0.207446808510638 |
| 359059 | 359059 | 121872 121872 | 47020 | 9 | 0.50715808005068 |
| 427985 | 427985 | 154281 154281 | 47020 | 1 | 0.207446808510638 |
| 515253 | 515253 | 206591 206591 | 47020 | 1 | 0.207446808510638 |
| 515257 | 515257 | 206592 206592 | 47020 | 1 | 0.207446808510638 |
| 532322 | 532322 | 211123 211123 | 47020 | 1 | 0.207446808510638 |
| 557111 | 557111 | 219426 219426 | 47020 | 11 | 0.515311093617938 |
| 667212 | 667212 | 238983 238983 | 47020 | 1 | 0.207446808510638 |
| 667217 | 667217 | 238984 238984 | 47020 | 1 | 0.147398843930636 |
| 735889 | 735889 | 259561 259561 | 47020 | 1 | 0.259842519685039 |
| 836503 | 836503 | 290213 290213 | 47020 | 2 | 0.136351237885241 |
| 836507 | 836507 | 290214 290214 | 47020 | 1 | 0.113207547169811 |
| 857973 | 857973 | 296789 296789 | 47020 | 1 | 0.259842519685039 |
| 857976 | 857976 | 296790 296790 | 47020 | 1 | 0.258620689655172 |
| 857979 | 857979 | 296791 296791 | 47020 | 1 | 0.207446808510638 |
| 857983 | 857983 | 296792 296792 | 47020 | 1 | 0.25531914893617 |
| 857986 | 857986 | 296793 296793 | 47020 | 1 | 0.25531914893617 |
| 957012 | 957012 | 344078 344078 | 47020 | 1 | 0.253012048192771 |
| 1175036 | 1175036 | 394344 394344 | 47020 | 1 | 0.259842519685039 |
| 1175039 | 1175039 | 394345 394345 | 47020 | 1 | 0.259842519685039 |
| 1175042 | 1175042 | 394346 394346 | 47020 | 1 | 0.259842519685039 |
| 1175045 | 1175045 | 394347 394347 | 47020 | 1 | 0.259842519685039 |
| 1175048 | 1175048 | 394348 394348 | 47020 | 1 | 0.259842519685039 |
| 1175051 | 1175051 | 394349 394349 | 47020 | 1 | 0.259842519685039 |
| 1175054 | 1175054 | 394350 394350 | 47020 | 1 | 0.259842519685039 |
| 1175057 | 1175057 | 394351 394351 | 47020 | 1 | 0.259842519685039 |
| 1175060 | 1175060 | 394352 394352 | 47020 | 1 | 0.259842519685039 |
| 1175063 | 1175063 | 394353 394353 | 47020 | 1 | 0.259842519685039 |
| 1175066 | 1175066 | 394354 394354 | 47020 | 1 | 0.259842519685039 |
| 1175069 | 1175069 | 394355 394355 | 47020 | 1 | 0.259842519685039 |
| 1175072 | 1175072 | 394356 394356 | 47020 | 1 | 0.259842519685039 |
| 1175075 | 1175075 | 394357 394357 | 47020 | 1 | 0.259842519685039 |
| 1175078 | 1175078 | 394358 394358 | 47020 | 1 | 0.259842519685039 |
| 1430540 | 1430540 | 446010 446010 | 47020 | 1 | 0.259842519685039 |
| 1430543 | 1430543 | 446011 446011 | 47020 | 1 | 0.259842519685039 |
| 1430546 | 1430546 | 446012 446012 | 47020 | 1 | 0.259842519685039 |
| 1430549 | 1430549 | 446013 446013 | 47020 | 1 | 0.259842519685039 |
| 1430552 | 1430552 | 446014 446014 | 47020 | 1 | 0.259842519685039 |
| 1430555 | 1430555 | 446015 446015 | 47020 | 1 | 0.259842519685039 |
| 1430558 | 1430558 | 446016 446016 | 47020 | 1 | 0.259842519685039 |
| 1430561 | 1430561 | 446017 446017 | 47020 | 1 | 0.259842519685039 |
| 1430564 | 1430564 | 446018 446018 | 47020 | 1 | 0.259842519685039 |
| 1430567 | 1430567 | 446019 446019 | 47020 | 1 | 0.259842519685039 |
| 1430570 | 1430570 | 446020 446020 | 47020 | 1 | 0.259842519685039 |
| 1430573 | 1430573 | 446021 446021 | 47020 | 1 | 0.259842519685039 |
| 1430576 | 1430576 | 446022 446022 | 47020 | 1 | 0.259842519685039 |
| 1430579 | 1430579 | 446023 446023 | 47020 | 1 | 0.259842519685039 |
| 1430582 | 1430582 | 446024 446024 | 47020 | 1 | 0.259842519685039 |
| 1430585 | 1430585 | 446025 446025 | 47020 | 1 | 0.259842519685039 |
| 1430588 | 1430588 | 446026 446026 | 47020 | 1 | 0.259842519685039 |
| 1587467 | 1587467 | 479205 479205 | 47020 | 1 | 0.259842519685039 |
| 1587470 | 1587470 | 479206 479206 | 47020 | 1 | 0.259842519685039 |
| 1587473 | 1587473 | 479207 479207 | 47020 | 1 | 0.259842519685039 |
| 1587476 | 1587476 | 479208 479208 | 47020 | 1 | 0.259842519685039 |
| 1587479 | 1587479 | 479209 479209 | 47020 | 1 | 0.259842519685039 |
| 1587482 | 1587482 | 479210 479210 | 47020 | 1 | 0.259842519685039 |
| 1587485 | 1587485 | 479211 479211 | 47020 | 1 | 0.259842519685039 |
| 1587488 | 1587488 | 479212 479212 | 47020 | 1 | 0.259842519685039 |
| 1587491 | 1587491 | 479213 479213 | 47020 | 1 | 0.259842519685039 |
| 1587494 | 1587494 | 479214 479214 | 47020 | 1 | 0.259842519685039 |
| 1587497 | 1587497 | 479215 479215 | 47020 | 1 | 0.259842519685039 |
| 1587500 | 1587500 | 479216 479216 | 47020 | 1 | 0.259842519685039 |
| 1607202 | 1607202 | 485550 485550 | 47020 | 1 | 0.259842519685039 |
| 1613614 | 1613614 | 487154 487154 | 47020 | 1 | 0.259842519685039 |
| 1718388 | 1718388 | 526280 526280 | 47020 | 1 | 0.25531914893617 |
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)
);