api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
14 rows where inchi_id = 19845
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 47329 | 47329 | 21362 21362 | PubChem (compound) 1 | 19845 19845 | 1 |
| 47330 | 47330 | 234834 234834 | PubChem (compound) 1 | 19845 19845 | 1 |
| 47331 | 47331 | 125705 125705 | PubChem (compound) 1 | 19845 19845 | 1 |
| 47332 | 47332 | 21363 21363 | PubChem (compound) 1 | 19845 19845 | 1 |
| 363166 | 363166 | 251553 251553 | PubChem (substance) 2 | 19845 19845 | 3 |
| 363167 | 363167 | 21362 21362 | PubChem (substance) 2 | 19845 19845 | 1 |
| 363168 | 363168 | 234834 234834 | PubChem (substance) 2 | 19845 19845 | 1 |
| 363169 | 363169 | 125705 125705 | PubChem (substance) 2 | 19845 19845 | 1 |
| 363170 | 363170 | 21363 21363 | PubChem (substance) 2 | 19845 19845 | 1 |
| 972475 | 972475 | 21362 21362 | CAS Common Chemistry 3 | 19845 19845 | 1 |
| 972476 | 972476 | 234834 234834 | CAS Common Chemistry 3 | 19845 19845 | 1 |
| 972477 | 972477 | 21363 21363 | CAS Common Chemistry 3 | 19845 19845 | 1 |
| 1175159 | 1175159 | 21363 21363 | Computational Toxicology and Exposure Data 4 | 19845 19845 | 1 |
| 1175160 | 1175160 | 21362 21362 | Computational Toxicology and Exposure Data 4 | 19845 19845 | 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)
);