api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
7 rows where inchi_id = 157224
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 770275 | 770275 | 109273 109273 | PubChem (substance) 2 | 157224 157224 | 6 |
| 770276 | 770276 | 103008 103008 | PubChem (substance) 2 | 157224 157224 | 4 |
| 770277 | 770277 | 406646 406646 | PubChem (substance) 2 | 157224 157224 | 3 |
| 770278 | 770278 | 121691 121691 | PubChem (substance) 2 | 157224 157224 | 2 |
| 770279 | 770279 | 103011 103011 | PubChem (substance) 2 | 157224 157224 | 6 |
| 770280 | 770280 | 137877 137877 | PubChem (substance) 2 | 157224 157224 | 3 |
| 770281 | 770281 | 114854 114854 | PubChem (substance) 2 | 157224 157224 | 3 |
CREATE TABLE [api_results] (
[query_id] integer,
[api_id] integer,
[inchi_id] integer,
[rank] integer,
FOREIGN KEY (query_id) REFERENCES api_ready_query(query_id),
FOREIGN KEY (api_id) REFERENCES api_services(api_id),
FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);