consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
24 rows where inventory_id = 423471
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1289231 | 1289231 | 423471 423471 | 11206 | 1 | 0.0125146388963393 |
| 1289232 | 1289232 | 423471 423471 | 27582 | 10 | 0.217892518813115 |
| 1289233 | 1289233 | 423471 423471 | 44780 | 1 | 0.0417154629877976 |
| 1289234 | 1289234 | 423471 423471 | 51571 | 1 | 0.0500585555853571 |
| 1289235 | 1289235 | 423471 423471 | 54871 | 1 | 0.0500585555853571 |
| 1289236 | 1289236 | 423471 423471 | 55090 | 1 | 0.0417154629877976 |
| 1289237 | 1289237 | 423471 423471 | 79969 | 1 | 0.017878055566199 |
| 1289238 | 1289238 | 423471 423471 | 103730 | 1 | 0.0834309259755952 |
| 1289239 | 1289239 | 423471 423471 | 106090 | 1 | 0.0357561111323979 |
| 1289240 | 1289240 | 423471 423471 | 107261 | 1 | 0.016686185195119 |
| 1289241 | 1289241 | 423471 423471 | 122318 | 1 | 0.0227538889024351 |
| 1289242 | 1289242 | 423471 423471 | 124647 | 1 | 0.0278103086585317 |
| 1289243 | 1289243 | 423471 423471 | 136317 | 1 | 0.0131733041014098 |
| 1289244 | 1289244 | 423471 423471 | 139148 | 1 | 0.0834309259755952 |
| 1289245 | 1289245 | 423471 423471 | 169484 | 1 | 0.0625731944816964 |
| 1289246 | 1289246 | 423471 423471 | 169851 | 1 | 0.0312865972408482 |
| 1289247 | 1289247 | 423471 423471 | 170929 | 1 | 0.0119187037107993 |
| 1289248 | 1289248 | 423471 423471 | 184397 | 1 | 0.0192532906097527 |
| 1289249 | 1289249 | 423471 423471 | 194422 | 1 | 0.0250292777926786 |
| 1289250 | 1289250 | 423471 423471 | 205106 | 1 | 0.0208577314938988 |
| 1289251 | 1289251 | 423471 423471 | 205254 | 1 | 0.0147231045839286 |
| 1289252 | 1289252 | 423471 423471 | 207810 | 1 | 0.0156432986204241 |
| 1289253 | 1289253 | 423471 423471 | 215818 | 1 | 0.0139051543292659 |
| 1289254 | 1289254 | 423471 423471 | 223503 | 1 | 0.0625731944816964 |
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)
);