consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inchi_id = 42423
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 39262 | 39262 | 11853 11853 | 42423 | 1 | 0.246969117080855 |
| 117674 | 117674 | 41083 41083 | 42423 | 1 | 0.246969117080855 |
| 129359 | 129359 | 46120 46120 | 42423 | 1 | 0.246969117080855 |
| 278146 | 278146 | 94322 94322 | 42423 | 2 | 0.248309435989833 |
| 560182 | 560182 | 220339 220339 | 42423 | 2 | 0.224222795323113 |
| 703579 | 703579 | 250546 250546 | 42423 | 1 | 0.246969117080855 |
| 800423 | 800423 | 279226 279226 | 42423 | 1 | 0.254389501710232 |
| 800431 | 800431 | 279227 279227 | 42423 | 1 | 0.246969117080855 |
| 944548 | 944548 | 338279 338279 | 42423 | 1 | 0.254389501710232 |
| 1055760 | 1055760 | 373229 373229 | 42423 | 2 | 0.247259905464389 |
| 1055768 | 1055768 | 373230 373230 | 42423 | 2 | 0.247259905464389 |
| 1278965 | 1278965 | 420743 420743 | 42423 | 2 | 0.247259905464389 |
| 1278973 | 1278973 | 420744 420744 | 42423 | 2 | 0.247259905464389 |
| 1278981 | 1278981 | 420745 420745 | 42423 | 2 | 0.247259905464389 |
| 1278989 | 1278989 | 420746 420746 | 42423 | 2 | 0.247259905464389 |
| 1496098 | 1496098 | 462933 462933 | 42423 | 2 | 0.247259905464389 |
| 1496106 | 1496106 | 462934 462934 | 42423 | 2 | 0.247259905464389 |
| 1599602 | 1599602 | 483200 483200 | 42423 | 2 | 0.247259905464389 |
| 1644658 | 1644658 | 497843 497843 | 42423 | 2 | 0.247259905464389 |
| 1735666 | 1735666 | 531695 531695 | 42423 | 1 | 0.246969117080855 |
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)
);