api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
12 rows where inchi_id = 49817
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 158389 | 158389 | 411943 411943 | PubChem (compound) 1 | 49817 49817 | 1 |
| 158390 | 158390 | 138214 138214 | PubChem (compound) 1 | 49817 49817 | 1 |
| 158391 | 158391 | 138213 138213 | PubChem (compound) 1 | 49817 49817 | 1 |
| 516145 | 516145 | 138213 138213 | PubChem (substance) 2 | 49817 49817 | 1 |
| 516146 | 516146 | 17688 17688 | PubChem (substance) 2 | 49817 49817 | 3 |
| 516147 | 516147 | 138214 138214 | PubChem (substance) 2 | 49817 49817 | 1 |
| 516148 | 516148 | 411943 411943 | PubChem (substance) 2 | 49817 49817 | 1 |
| 516149 | 516149 | 437991 437991 | PubChem (substance) 2 | 49817 49817 | 3 |
| 1054033 | 1054033 | 138213 138213 | CAS Common Chemistry 3 | 49817 49817 | 1 |
| 1054034 | 1054034 | 411943 411943 | CAS Common Chemistry 3 | 49817 49817 | 1 |
| 1256764 | 1256764 | 138213 138213 | Computational Toxicology and Exposure Data 4 | 49817 49817 | 1 |
| 1256765 | 1256765 | 411943 411943 | Computational Toxicology and Exposure Data 4 | 49817 49817 | 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)
);