consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
19 rows where inchi_id = 218878
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 13861 | 13861 | 4257 4257 | 218878 | 2 | 0.196833582624657 |
| 46235 | 46235 | 14079 14079 | 218878 | 2 | 0.196833582624657 |
| 112649 | 112649 | 39365 39365 | 218878 | 2 | 0.196833582624657 |
| 133580 | 133580 | 47393 47393 | 218878 | 2 | 0.182926829268293 |
| 298036 | 298036 | 100721 100721 | 218878 | 2 | 0.182926829268293 |
| 460688 | 460688 | 165569 165569 | 218878 | 2 | 0.182926829268293 |
| 525874 | 525874 | 209311 209311 | 218878 | 2 | 0.182926829268293 |
| 538881 | 538881 | 213692 213692 | 218878 | 2 | 0.182926829268293 |
| 668649 | 668649 | 239554 239554 | 218878 | 3 | 0.198246125434093 |
| 842918 | 842918 | 292098 292098 | 218878 | 2 | 0.196833582624657 |
| 842922 | 842922 | 292099 292099 | 218878 | 2 | 0.206896551724138 |
| 842927 | 842927 | 292100 292100 | 218878 | 2 | 0.182926829268293 |
| 953554 | 953554 | 342287 342287 | 218878 | 1 | 0.203389830508475 |
| 1158242 | 1158242 | 389379 389379 | 218878 | 1 | 0.196338121907467 |
| 1411800 | 1411800 | 440338 440338 | 218878 | 1 | 0.196338121907467 |
| 1575165 | 1575165 | 475332 475332 | 218878 | 1 | 0.196338121907467 |
| 1605232 | 1605232 | 484917 484917 | 218878 | 1 | 0.196338121907467 |
| 1653069 | 1653069 | 500662 500662 | 218878 | 1 | 0.196338121907467 |
| 1740407 | 1740407 | 532990 532990 | 218878 | 2 | 0.206896551724138 |
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)
);