consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
265 rows where inchi_id = 47
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1534 | 1534 | 357 357 | 47 | 2 | 0.200956937799043 |
| 7664 | 7664 | 2304 2304 | 47 | 1 | 0.0836653386454183 |
| 21263 | 21263 | 6270 6270 | 47 | 8 | 0.625 |
| 21269 | 21269 | 6272 6272 | 47 | 1 | 0.259842519685039 |
| 98326 | 98326 | 34851 34851 | 47 | 1 | 0.259842519685039 |
| 124950 | 124950 | 43290 43290 | 47 | 1 | 0.226415094339623 |
| 131226 | 131226 | 46585 46585 | 47 | 1 | 0.167832167832168 |
| 154889 | 154889 | 55702 55702 | 47 | 1 | 0.0841121495327103 |
| 200524 | 200524 | 71280 71280 | 47 | 1 | 0.0836653386454183 |
| 201478 | 201478 | 71493 71493 | 47 | 2 | 0.200956937799043 |
| 219827 | 219827 | 76128 76128 | 47 | 8 | 0.625 |
| 219834 | 219834 | 76130 76130 | 47 | 2 | 0.200956937799043 |
| 222115 | 222115 | 76808 76808 | 47 | 1 | 0.0836653386454183 |
| 429006 | 429006 | 154573 154573 | 47 | 2 | 0.200956937799043 |
| 430700 | 430700 | 155062 155062 | 47 | 1 | 0.0836653386454183 |
| 516213 | 516213 | 206841 206841 | 47 | 2 | 0.200956937799043 |
| 516218 | 516218 | 206842 206842 | 47 | 2 | 0.200956937799043 |
| 516223 | 516223 | 206843 206843 | 47 | 2 | 0.200956937799043 |
| 517702 | 517702 | 207200 207200 | 47 | 1 | 0.0836653386454183 |
| 592603 | 592603 | 231038 231038 | 47 | 1 | 0.0836653386454183 |
| 596443 | 596443 | 232200 232200 | 47 | 2 | 0.200956937799043 |
| 596452 | 596452 | 232202 232202 | 47 | 8 | 0.625 |
| 596927 | 596927 | 235267 235267 | 47 | 2 | 0.200956937799043 |
| 596932 | 596932 | 235268 235268 | 47 | 2 | 0.200956937799043 |
| 598041 | 598041 | 235570 235570 | 47 | 1 | 0.0836653386454183 |
| 598047 | 598047 | 235571 235571 | 47 | 1 | 0.0836653386454183 |
| 598053 | 598053 | 235572 235572 | 47 | 2 | 0.0843373493975904 |
| 669450 | 669450 | 239785 239785 | 47 | 8 | 0.625 |
| 669462 | 669462 | 239789 239789 | 47 | 1 | 0.259842519685039 |
| 738439 | 738439 | 260279 260279 | 47 | 5 | 0.608695652173913 |
| 738441 | 738441 | 260280 260280 | 47 | 8 | 0.625 |
| 738443 | 738443 | 260281 260281 | 47 | 8 | 0.331491712707182 |
| 738455 | 738455 | 260284 260284 | 47 | 1 | 0.259842519685039 |
| 738458 | 738458 | 260285 260285 | 47 | 2 | 0.200956937799043 |
| 738463 | 738463 | 260286 260286 | 47 | 1 | 0.258620689655172 |
| 738466 | 738466 | 260287 260287 | 47 | 1 | 0.259842519685039 |
| 738469 | 738469 | 260288 260288 | 47 | 1 | 0.20625 |
| 738473 | 738473 | 260289 260289 | 47 | 1 | 0.259842519685039 |
| 738476 | 738476 | 260290 260290 | 47 | 1 | 0.25531914893617 |
| 746108 | 746108 | 262471 262471 | 47 | 1 | 0.0836653386454183 |
| 944841 | 944841 | 338394 338394 | 47 | 1 | 0.253012048192771 |
| 959449 | 959449 | 345245 345245 | 47 | 4 | 0.6 |
| 970010 | 970010 | 351922 351922 | 47 | 1 | 0.259842519685039 |
| 970013 | 970013 | 351923 351923 | 47 | 1 | 0.259842519685039 |
| 970016 | 970016 | 351924 351924 | 47 | 1 | 0.259842519685039 |
| 970019 | 970019 | 351925 351925 | 47 | 1 | 0.259842519685039 |
| 970022 | 970022 | 351926 351926 | 47 | 1 | 0.259842519685039 |
| 970025 | 970025 | 351927 351927 | 47 | 1 | 0.259842519685039 |
| 970028 | 970028 | 351928 351928 | 47 | 1 | 0.259842519685039 |
| 970031 | 970031 | 351929 351929 | 47 | 1 | 0.259842519685039 |
| 970034 | 970034 | 351930 351930 | 47 | 1 | 0.259842519685039 |
| 970037 | 970037 | 351931 351931 | 47 | 1 | 0.259842519685039 |
| 970040 | 970040 | 351932 351932 | 47 | 1 | 0.259842519685039 |
| 970043 | 970043 | 351933 351933 | 47 | 1 | 0.259842519685039 |
| 970046 | 970046 | 351934 351934 | 47 | 1 | 0.259842519685039 |
| 970049 | 970049 | 351935 351935 | 47 | 1 | 0.259842519685039 |
| 970052 | 970052 | 351936 351936 | 47 | 1 | 0.259842519685039 |
| 970055 | 970055 | 351937 351937 | 47 | 1 | 0.259842519685039 |
| 970058 | 970058 | 351938 351938 | 47 | 1 | 0.259842519685039 |
| 970061 | 970061 | 351939 351939 | 47 | 1 | 0.259842519685039 |
| 970064 | 970064 | 351940 351940 | 47 | 1 | 0.259842519685039 |
| 970067 | 970067 | 351941 351941 | 47 | 1 | 0.259842519685039 |
| 970070 | 970070 | 351942 351942 | 47 | 1 | 0.259842519685039 |
| 970073 | 970073 | 351943 351943 | 47 | 1 | 0.259842519685039 |
| 970076 | 970076 | 351944 351944 | 47 | 1 | 0.259842519685039 |
| 970079 | 970079 | 351945 351945 | 47 | 1 | 0.259842519685039 |
| 970082 | 970082 | 351946 351946 | 47 | 1 | 0.259842519685039 |
| 970085 | 970085 | 351947 351947 | 47 | 1 | 0.259842519685039 |
| 970088 | 970088 | 351948 351948 | 47 | 1 | 0.259842519685039 |
| 970091 | 970091 | 351949 351949 | 47 | 1 | 0.259842519685039 |
| 970094 | 970094 | 351950 351950 | 47 | 1 | 0.259842519685039 |
| 970097 | 970097 | 351951 351951 | 47 | 1 | 0.259842519685039 |
| 970100 | 970100 | 351952 351952 | 47 | 1 | 0.259842519685039 |
| 970103 | 970103 | 351953 351953 | 47 | 1 | 0.259842519685039 |
| 970106 | 970106 | 351954 351954 | 47 | 1 | 0.259842519685039 |
| 970109 | 970109 | 351955 351955 | 47 | 1 | 0.259842519685039 |
| 970112 | 970112 | 351956 351956 | 47 | 1 | 0.259842519685039 |
| 970115 | 970115 | 351957 351957 | 47 | 1 | 0.259842519685039 |
| 970118 | 970118 | 351958 351958 | 47 | 1 | 0.259842519685039 |
| 970121 | 970121 | 351959 351959 | 47 | 1 | 0.259842519685039 |
| 970124 | 970124 | 351960 351960 | 47 | 1 | 0.259842519685039 |
| 970127 | 970127 | 351961 351961 | 47 | 1 | 0.259842519685039 |
| 970130 | 970130 | 351962 351962 | 47 | 1 | 0.259842519685039 |
| 970133 | 970133 | 351963 351963 | 47 | 1 | 0.259842519685039 |
| 970136 | 970136 | 351964 351964 | 47 | 1 | 0.259842519685039 |
| 970139 | 970139 | 351965 351965 | 47 | 1 | 0.259842519685039 |
| 970142 | 970142 | 351966 351966 | 47 | 1 | 0.259842519685039 |
| 970145 | 970145 | 351967 351967 | 47 | 1 | 0.259842519685039 |
| 970148 | 970148 | 351968 351968 | 47 | 1 | 0.259842519685039 |
| 970151 | 970151 | 351969 351969 | 47 | 1 | 0.259842519685039 |
| 970154 | 970154 | 351970 351970 | 47 | 1 | 0.259842519685039 |
| 970157 | 970157 | 351971 351971 | 47 | 1 | 0.259842519685039 |
| 970160 | 970160 | 351972 351972 | 47 | 1 | 0.259842519685039 |
| 970163 | 970163 | 351973 351973 | 47 | 1 | 0.259842519685039 |
| 970166 | 970166 | 351974 351974 | 47 | 1 | 0.259842519685039 |
| 970169 | 970169 | 351975 351975 | 47 | 1 | 0.259842519685039 |
| 970172 | 970172 | 351976 351976 | 47 | 1 | 0.259842519685039 |
| 970175 | 970175 | 351977 351977 | 47 | 1 | 0.259842519685039 |
| 970178 | 970178 | 351978 351978 | 47 | 1 | 0.259842519685039 |
| 970181 | 970181 | 351979 351979 | 47 | 1 | 0.259842519685039 |
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)
);