consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
78 rows where inventory_id = 42021
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 120685 | 120685 | 42021 42021 | 4755 | 8 | 0.180733971978136 |
| 120686 | 120686 | 42021 42021 | 44093 | 2 | 0.0245947783629392 |
| 120687 | 120687 | 42021 42021 | 46537 | 1 | 0.0451834929945339 |
| 120688 | 120688 | 42021 42021 | 64739 | 1 | 0.00695130661454368 |
| 120689 | 120689 | 42021 42021 | 92353 | 1 | 0.00430318980900323 |
| 120690 | 120690 | 42021 42021 | 136467 | 2 | 0.0903669859890678 |
| 120691 | 120691 | 42021 42021 | 151125 | 1 | 0.0451834929945339 |
| 120692 | 120692 | 42021 42021 | 169416 | 1 | 0.0139026132290874 |
| 120693 | 120693 | 42021 42021 | 169422 | 1 | 0.012048931465209 |
| 120694 | 120694 | 42021 42021 | 169431 | 1 | 0.0180733971978136 |
| 120695 | 120695 | 42021 42021 | 169445 | 1 | 0.00860637961800646 |
| 120696 | 120696 | 42021 42021 | 169472 | 1 | 0.00328607221778428 |
| 120697 | 120697 | 42021 42021 | 169486 | 1 | 0.00602446573260452 |
| 120698 | 120698 | 42021 42021 | 169488 | 1 | 0.00821518054446071 |
| 120699 | 120699 | 42021 42021 | 169524 | 1 | 0.022591746497267 |
| 120700 | 120700 | 42021 42021 | 169562 | 1 | 0.0200815524420151 |
| 120701 | 120701 | 42021 42021 | 169571 | 1 | 0.00463420440969579 |
| 120702 | 120702 | 42021 42021 | 169574 | 1 | 0.0150611643315113 |
| 120703 | 120703 | 42021 42021 | 169594 | 1 | 0.0129095694270097 |
| 120704 | 120704 | 42021 42021 | 169597 | 1 | 0.0301223286630226 |
| 120705 | 120705 | 42021 42021 | 169614 | 1 | 0.00623220593028054 |
| 120706 | 120706 | 42021 42021 | 169654 | 1 | 0.0112958732486335 |
| 120707 | 120707 | 42021 42021 | 169718 | 1 | 0.00951231431463872 |
| 120708 | 120708 | 42021 42021 | 169728 | 1 | 0.00251019405525188 |
| 120709 | 120709 | 42021 42021 | 169783 | 1 | 0.0258191388540194 |
| 120710 | 120710 | 42021 42021 | 184131 | 1 | 0.00903669859890678 |
| 120711 | 120711 | 42021 42021 | 185616 | 1 | 0.00583012812832696 |
| 120712 | 120712 | 42021 42021 | 185986 | 1 | 0.0602446573260452 |
| 120713 | 120713 | 42021 42021 | 186524 | 1 | 0.00311610296514027 |
| 120714 | 120714 | 42021 42021 | 186526 | 1 | 0.0106314101163609 |
| 120715 | 120715 | 42021 42021 | 186529 | 1 | 0.0164303610889214 |
| 120716 | 120716 | 42021 42021 | 186536 | 1 | 0.0100407762210075 |
| 120717 | 120717 | 42021 42021 | 189017 | 1 | 0.00502038811050377 |
| 120718 | 120718 | 42021 42021 | 190443 | 1 | 0.00273839351482024 |
| 120719 | 120719 | 42021 42021 | 203966 | 1 | 0.0025455489011005 |
| 120720 | 120720 | 42021 42021 | 206574 | 1 | 0.00368844840771705 |
| 120721 | 120721 | 42021 42021 | 207693 | 1 | 0.00286879320600215 |
| 120722 | 120722 | 42021 42021 | 207710 | 1 | 0.00753058216575565 |
| 120723 | 120723 | 42021 42021 | 207711 | 1 | 0.00722935887912543 |
| 120724 | 120724 | 42021 42021 | 208261 | 1 | 0.0361467943956271 |
| 120725 | 120725 | 42021 42021 | 209597 | 1 | 0.00440814565800331 |
| 120726 | 120726 | 42021 42021 | 224023 | 1 | 0.00785799878165807 |
| 120727 | 120727 | 42021 42021 | 228263 | 1 | 0.00301223286630226 |
| 120728 | 120728 | 42021 42021 | 229004 | 1 | 0.00645478471350485 |
| 120729 | 120729 | 42021 42021 | 231623 | 1 | 0.00451834929945339 |
| 120730 | 120730 | 42021 42021 | 234442 | 1 | 0.00392899939082904 |
| 120731 | 120731 | 42021 42021 | 237117 | 1 | 0.00564793662431674 |
| 120732 | 120732 | 42021 42021 | 240878 | 1 | 0.00547678702964048 |
| 120733 | 120733 | 42021 42021 | 241458 | 1 | 0.00531570505818046 |
| 120734 | 120734 | 42021 42021 | 241601 | 1 | 0.00516382777080388 |
| 120735 | 120735 | 42021 42021 | 243275 | 1 | 0.00488470194535502 |
| 120736 | 120736 | 42021 42021 | 250963 | 1 | 0.00475615715731936 |
| 120737 | 120737 | 42021 42021 | 258814 | 1 | 0.0042031156273985 |
| 120738 | 120738 | 42021 42021 | 258815 | 1 | 0.00410759027223036 |
| 120739 | 120739 | 42021 42021 | 258816 | 1 | 0.00401631048840301 |
| 120740 | 120740 | 42021 42021 | 261410 | 1 | 0.00384540365910927 |
| 120741 | 120741 | 42021 42021 | 261411 | 1 | 0.00376529108287783 |
| 120742 | 120742 | 42021 42021 | 261971 | 2 | 0.0466653109043492 |
| 120743 | 120743 | 42021 42021 | 263244 | 1 | 0.00361467943956271 |
| 120744 | 120744 | 42021 42021 | 270336 | 1 | 0.00354380337212031 |
| 120745 | 120745 | 42021 42021 | 275218 | 1 | 0.00341007494298369 |
| 120746 | 120746 | 42021 42021 | 275256 | 1 | 0.00347565330727184 |
| 120747 | 120747 | 42021 42021 | 275257 | 1 | 0.00322739235675242 |
| 120748 | 120748 | 42021 42021 | 275258 | 1 | 0.00317077143821291 |
| 120749 | 120749 | 42021 42021 | 285486 | 1 | 0.00306328766064637 |
| 120750 | 120750 | 42021 42021 | 286329 | 1 | 0.00261933292721936 |
| 120751 | 120751 | 42021 42021 | 287636 | 1 | 0.00296285199964157 |
| 120752 | 120752 | 42021 42021 | 295957 | 1 | 0.00291506406416348 |
| 120753 | 120753 | 42021 42021 | 310431 | 1 | 0.00282396831215837 |
| 120754 | 120754 | 42021 42021 | 310432 | 1 | 0.00278052264581747 |
| 120755 | 120755 | 42021 42021 | 314812 | 1 | 0.00334692540700251 |
| 120756 | 120756 | 42021 42021 | 321785 | 1 | 0.00269752196982292 |
| 120757 | 120757 | 42021 42021 | 323040 | 1 | 0.00265785252909023 |
| 120758 | 120758 | 42021 42021 | 323915 | 1 | 0.00258191388540194 |
| 120759 | 120759 | 42021 42021 | 330619 | 1 | 0.00247580783531693 |
| 120760 | 120760 | 42021 42021 | 330620 | 1 | 0.00244235097267751 |
| 120761 | 120761 | 42021 42021 | 331528 | 1 | 0.00240978629304181 |
| 120762 | 120762 | 42021 42021 | 334338 | 1 | 0.00237807857865968 |
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)
);