api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
13 rows where inchi_id = 43289
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 106492 | 106492 | 69564 69564 | PubChem (compound) 1 | 43289 43289 | 1 |
| 106493 | 106493 | 69563 69563 | PubChem (compound) 1 | 43289 43289 | 1 |
| 106494 | 106494 | 112369 112369 | PubChem (compound) 1 | 43289 43289 | 1 |
| 446334 | 446334 | 12985 12985 | PubChem (substance) 2 | 43289 43289 | 35 |
| 446335 | 446335 | 69564 69564 | PubChem (substance) 2 | 43289 43289 | 1 |
| 446336 | 446336 | 69563 69563 | PubChem (substance) 2 | 43289 43289 | 1 |
| 446337 | 446337 | 112369 112369 | PubChem (substance) 2 | 43289 43289 | 1 |
| 1016310 | 1016310 | 69563 69563 | CAS Common Chemistry 3 | 43289 43289 | 1 |
| 1016311 | 1016311 | 112369 112369 | CAS Common Chemistry 3 | 43289 43289 | 1 |
| 1016312 | 1016312 | 69564 69564 | CAS Common Chemistry 3 | 43289 43289 | 1 |
| 1218467 | 1218467 | 69563 69563 | Computational Toxicology and Exposure Data 4 | 43289 43289 | 1 |
| 1218468 | 1218468 | 112369 112369 | Computational Toxicology and Exposure Data 4 | 43289 43289 | 1 |
| 1218469 | 1218469 | 69564 69564 | Computational Toxicology and Exposure Data 4 | 43289 43289 | 1 |
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)
);