consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
23 rows where inventory_id = 287399
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 828246 | 828246 | 287399 287399 | 58325 | 1 | 0.0105785906503019 |
| 828247 | 828247 | 287399 287399 | 60357 | 1 | 0.105785906503019 |
| 828248 | 828248 | 287399 287399 | 69414 | 4 | 0.211571813006038 |
| 828249 | 828249 | 287399 287399 | 148787 | 1 | 0.0264464766257547 |
| 828250 | 828250 | 287399 287399 | 152529 | 2 | 0.211571813006038 |
| 828251 | 828251 | 287399 287399 | 158520 | 1 | 0.0192338011823671 |
| 828252 | 828252 | 287399 287399 | 158522 | 1 | 0.0176309844171698 |
| 828253 | 828253 | 287399 287399 | 158737 | 1 | 0.0132232383128774 |
| 828254 | 828254 | 287399 287399 | 158768 | 1 | 0.0111353585792651 |
| 828255 | 828255 | 287399 287399 | 158795 | 1 | 0.0211571813006038 |
| 828256 | 828256 | 287399 287399 | 158836 | 1 | 0.012445400765061 |
| 828257 | 828257 | 287399 287399 | 160221 | 1 | 0.0117539896114465 |
| 828258 | 828258 | 287399 287399 | 160366 | 1 | 0.0141047875337358 |
| 828259 | 828259 | 287399 287399 | 160790 | 1 | 0.0151122723575741 |
| 828260 | 828260 | 287399 287399 | 160914 | 1 | 0.0302245447151482 |
| 828261 | 828261 | 287399 287399 | 167331 | 1 | 0.0235079792228931 |
| 828262 | 828262 | 287399 287399 | 169827 | 1 | 0.0705239376686792 |
| 828263 | 828263 | 287399 287399 | 169829 | 1 | 0.0528929532515094 |
| 828264 | 828264 | 287399 287399 | 172030 | 1 | 0.0162747548466183 |
| 828265 | 828265 | 287399 287399 | 221141 | 1 | 0.0423143626012075 |
| 828266 | 828266 | 287399 287399 | 237861 | 1 | 0.0100748482383827 |
| 828267 | 828267 | 287399 287399 | 240508 | 1 | 0.0352619688343396 |
| 828268 | 828268 | 287399 287399 | 335233 | 1 | 0.00961690059118353 |
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)
);