consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inchi_id = 87491
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 79817 | 79817 | 28808 28808 | 87491 | 1 | 0.3125 |
| 145464 | 145464 | 51863 51863 | 87491 | 1 | 0.045164754452151 |
| 158351 | 158351 | 57039 57039 | 87491 | 1 | 0.0447785226664876 |
| 218164 | 218164 | 75648 75648 | 87491 | 8 | 0.625 |
| 265069 | 265069 | 89811 89811 | 87491 | 1 | 0.310344827586207 |
| 750035 | 750035 | 263670 263670 | 87491 | 1 | 0.0505971019104763 |
| 754165 | 754165 | 265046 265046 | 87491 | 1 | 0.0441176470588235 |
| 790982 | 790982 | 276156 276156 | 87491 | 1 | 0.0516342088184249 |
| 793696 | 793696 | 277021 277021 | 87491 | 1 | 0.0566037735849057 |
| 800376 | 800376 | 279217 279217 | 87491 | 1 | 0.049665711556829 |
| 800384 | 800384 | 279218 279218 | 87491 | 1 | 0.049665711556829 |
| 813595 | 813595 | 282863 282863 | 87491 | 1 | 0.0464717312060888 |
| 822983 | 822983 | 285705 285705 | 87491 | 1 | 0.0686304378055441 |
| 828498 | 828498 | 287472 287472 | 87491 | 1 | 0.049665711556829 |
| 833293 | 833293 | 289209 289209 | 87491 | 1 | 0.049665711556829 |
| 833301 | 833301 | 289210 289210 | 87491 | 1 | 0.049665711556829 |
| 962342 | 962342 | 346426 346426 | 87491 | 1 | 0.3 |
| 1638408 | 1638408 | 495528 495528 | 87491 | 1 | 0.3125 |
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)
);