consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
170 rows where inchi_id = 420
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1908 | 1908 | 504 504 | 420 | 8 | 0.316921335597057 |
| 1916 | 1916 | 505 505 | 420 | 2 | 0.630993034743972 |
| 47554 | 47554 | 14638 14638 | 420 | 8 | 0.625 |
| 48948 | 48948 | 15045 15045 | 420 | 6 | 0.374562667215476 |
| 51050 | 51050 | 15840 15840 | 420 | 2 | 0.314285714285714 |
| 102161 | 102161 | 36009 36009 | 420 | 6 | 0.374562667215476 |
| 102168 | 102168 | 36010 36010 | 420 | 8 | 0.625 |
| 167673 | 167673 | 59914 59914 | 420 | 6 | 0.374562667215476 |
| 167680 | 167680 | 59915 59915 | 420 | 12 | 0.318181818181818 |
| 167935 | 167935 | 59972 59972 | 420 | 4 | 0.319543834892091 |
| 300265 | 300265 | 101681 101681 | 420 | 8 | 0.316921335597057 |
| 303593 | 303593 | 102684 102684 | 420 | 6 | 0.374562667215476 |
| 311665 | 311665 | 105216 105216 | 420 | 1 | 0.304347826086957 |
| 461885 | 461885 | 165952 165952 | 420 | 8 | 0.316921335597057 |
| 463508 | 463508 | 166532 166532 | 420 | 6 | 0.374562667215476 |
| 500957 | 500957 | 199168 199168 | 420 | 4 | 0.37261069441084 |
| 526802 | 526802 | 209555 209555 | 420 | 8 | 0.316921335597057 |
| 526810 | 526810 | 209556 209556 | 420 | 8 | 0.316921335597057 |
| 591450 | 591450 | 230730 230730 | 420 | 6 | 0.374562667215476 |
| 595949 | 595949 | 232045 232045 | 420 | 4 | 0.6 |
| 597050 | 597050 | 235295 235295 | 420 | 8 | 0.316921335597057 |
| 597058 | 597058 | 235296 235296 | 420 | 8 | 0.316921335597057 |
| 598545 | 598545 | 235677 235677 | 420 | 6 | 0.374562667215476 |
| 669327 | 669327 | 239764 239764 | 420 | 12 | 0.318181818181818 |
| 674294 | 674294 | 241035 241035 | 420 | 6 | 0.374562667215476 |
| 682764 | 682764 | 243844 243844 | 420 | 1 | 0.266245718268997 |
| 738193 | 738193 | 260229 260229 | 420 | 8 | 0.316921335597057 |
| 738201 | 738201 | 260230 260230 | 420 | 4 | 0.6 |
| 738203 | 738203 | 260231 260231 | 420 | 8 | 0.625 |
| 738205 | 738205 | 260232 260232 | 420 | 5 | 0.608695652173913 |
| 747943 | 747943 | 262989 262989 | 420 | 6 | 0.374562667215476 |
| 747950 | 747950 | 262990 262990 | 420 | 6 | 0.875 |
| 954151 | 954151 | 342578 342578 | 420 | 4 | 0.6 |
| 954160 | 954160 | 342584 342584 | 420 | 2 | 0.630993034743972 |
| 969510 | 969510 | 351748 351748 | 420 | 8 | 0.625 |
| 969512 | 969512 | 351749 351749 | 420 | 8 | 0.625 |
| 969514 | 969514 | 351750 351750 | 420 | 8 | 0.625 |
| 969516 | 969516 | 351751 351751 | 420 | 8 | 0.625 |
| 969518 | 969518 | 351752 351752 | 420 | 8 | 0.625 |
| 969520 | 969520 | 351753 351753 | 420 | 8 | 0.625 |
| 969522 | 969522 | 351754 351754 | 420 | 8 | 0.625 |
| 969524 | 969524 | 351755 351755 | 420 | 8 | 0.625 |
| 969526 | 969526 | 351756 351756 | 420 | 8 | 0.625 |
| 969528 | 969528 | 351757 351757 | 420 | 8 | 0.625 |
| 969530 | 969530 | 351758 351758 | 420 | 8 | 0.625 |
| 969532 | 969532 | 351759 351759 | 420 | 8 | 0.625 |
| 969534 | 969534 | 351760 351760 | 420 | 8 | 0.625 |
| 969536 | 969536 | 351761 351761 | 420 | 8 | 0.625 |
| 969538 | 969538 | 351762 351762 | 420 | 8 | 0.625 |
| 969540 | 969540 | 351763 351763 | 420 | 8 | 0.625 |
| 969542 | 969542 | 351764 351764 | 420 | 8 | 0.625 |
| 969544 | 969544 | 351765 351765 | 420 | 8 | 0.625 |
| 969546 | 969546 | 351766 351766 | 420 | 8 | 0.625 |
| 969548 | 969548 | 351767 351767 | 420 | 8 | 0.625 |
| 969550 | 969550 | 351768 351768 | 420 | 8 | 0.625 |
| 969552 | 969552 | 351769 351769 | 420 | 8 | 0.625 |
| 969554 | 969554 | 351770 351770 | 420 | 8 | 0.625 |
| 969556 | 969556 | 351771 351771 | 420 | 8 | 0.625 |
| 969558 | 969558 | 351772 351772 | 420 | 8 | 0.625 |
| 969560 | 969560 | 351773 351773 | 420 | 8 | 0.625 |
| 969562 | 969562 | 351774 351774 | 420 | 8 | 0.625 |
| 969564 | 969564 | 351775 351775 | 420 | 8 | 0.625 |
| 969566 | 969566 | 351776 351776 | 420 | 8 | 0.625 |
| 969568 | 969568 | 351777 351777 | 420 | 8 | 0.625 |
| 969570 | 969570 | 351778 351778 | 420 | 8 | 0.625 |
| 969572 | 969572 | 351779 351779 | 420 | 8 | 0.625 |
| 969574 | 969574 | 351780 351780 | 420 | 8 | 0.625 |
| 969576 | 969576 | 351781 351781 | 420 | 8 | 0.625 |
| 969578 | 969578 | 351782 351782 | 420 | 8 | 0.625 |
| 969580 | 969580 | 351783 351783 | 420 | 8 | 0.625 |
| 969582 | 969582 | 351784 351784 | 420 | 8 | 0.625 |
| 969584 | 969584 | 351785 351785 | 420 | 8 | 0.625 |
| 969586 | 969586 | 351786 351786 | 420 | 8 | 0.625 |
| 969588 | 969588 | 351787 351787 | 420 | 8 | 0.625 |
| 969590 | 969590 | 351788 351788 | 420 | 8 | 0.625 |
| 969592 | 969592 | 351789 351789 | 420 | 8 | 0.625 |
| 969594 | 969594 | 351790 351790 | 420 | 8 | 0.625 |
| 969596 | 969596 | 351791 351791 | 420 | 8 | 0.625 |
| 969598 | 969598 | 351792 351792 | 420 | 8 | 0.625 |
| 969600 | 969600 | 351793 351793 | 420 | 8 | 0.625 |
| 969602 | 969602 | 351794 351794 | 420 | 8 | 0.625 |
| 969604 | 969604 | 351795 351795 | 420 | 8 | 0.625 |
| 1028852 | 1028852 | 365378 365378 | 420 | 2 | 0.314285714285714 |
| 1179970 | 1179970 | 395771 395771 | 420 | 8 | 0.625 |
| 1179972 | 1179972 | 395772 395772 | 420 | 8 | 0.625 |
| 1179974 | 1179974 | 395773 395773 | 420 | 8 | 0.625 |
| 1179976 | 1179976 | 395774 395774 | 420 | 8 | 0.625 |
| 1179978 | 1179978 | 395775 395775 | 420 | 8 | 0.625 |
| 1179980 | 1179980 | 395776 395776 | 420 | 8 | 0.625 |
| 1179982 | 1179982 | 395777 395777 | 420 | 8 | 0.625 |
| 1179984 | 1179984 | 395778 395778 | 420 | 8 | 0.625 |
| 1179986 | 1179986 | 395779 395779 | 420 | 8 | 0.625 |
| 1179988 | 1179988 | 395780 395780 | 420 | 8 | 0.625 |
| 1179990 | 1179990 | 395781 395781 | 420 | 8 | 0.625 |
| 1179992 | 1179992 | 395782 395782 | 420 | 8 | 0.625 |
| 1179994 | 1179994 | 395783 395783 | 420 | 8 | 0.625 |
| 1179996 | 1179996 | 395784 395784 | 420 | 8 | 0.625 |
| 1179998 | 1179998 | 395785 395785 | 420 | 8 | 0.625 |
| 1180000 | 1180000 | 395786 395786 | 420 | 8 | 0.625 |
| 1180002 | 1180002 | 395787 395787 | 420 | 8 | 0.625 |
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)
);