api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
12 rows where inchi_id = 44626
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 53506 | 53506 | 24148 24148 | PubChem (compound) 1 | 44626 44626 | 1 |
| 53507 | 53507 | 136515 136515 | PubChem (compound) 1 | 44626 44626 | 1 |
| 53508 | 53508 | 24147 24147 | PubChem (compound) 1 | 44626 44626 | 1 |
| 371435 | 371435 | 13885 13885 | PubChem (substance) 2 | 44626 44626 | 2 |
| 371436 | 371436 | 24147 24147 | PubChem (substance) 2 | 44626 44626 | 1 |
| 371437 | 371437 | 24148 24148 | PubChem (substance) 2 | 44626 44626 | 1 |
| 371438 | 371438 | 136515 136515 | PubChem (substance) 2 | 44626 44626 | 1 |
| 977260 | 977260 | 24147 24147 | CAS Common Chemistry 3 | 44626 44626 | 1 |
| 977261 | 977261 | 24148 24148 | CAS Common Chemistry 3 | 44626 44626 | 1 |
| 1180102 | 1180102 | 136515 136515 | Computational Toxicology and Exposure Data 4 | 44626 44626 | 1 |
| 1180103 | 1180103 | 24148 24148 | Computational Toxicology and Exposure Data 4 | 44626 44626 | 1 |
| 1180104 | 1180104 | 24147 24147 | Computational Toxicology and Exposure Data 4 | 44626 44626 | 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)
);