api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
12 rows where inchi_id = 83627
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 116813 | 116813 | 89573 89573 | PubChem (compound) 1 | 83627 83627 | 1 |
| 116814 | 116814 | 119626 119626 | PubChem (compound) 1 | 83627 83627 | 1 |
| 116815 | 116815 | 89572 89572 | PubChem (compound) 1 | 83627 83627 | 1 |
| 460586 | 460586 | 89572 89572 | PubChem (substance) 2 | 83627 83627 | 1 |
| 460587 | 460587 | 119626 119626 | PubChem (substance) 2 | 83627 83627 | 1 |
| 460588 | 460588 | 391567 391567 | PubChem (substance) 2 | 83627 83627 | 2 |
| 460589 | 460589 | 89573 89573 | PubChem (substance) 2 | 83627 83627 | 1 |
| 1023463 | 1023463 | 89572 89572 | CAS Common Chemistry 3 | 83627 83627 | 1 |
| 1023464 | 1023464 | 119626 119626 | CAS Common Chemistry 3 | 83627 83627 | 1 |
| 1023465 | 1023465 | 89573 89573 | CAS Common Chemistry 3 | 83627 83627 | 1 |
| 1225817 | 1225817 | 89572 89572 | Computational Toxicology and Exposure Data 4 | 83627 83627 | 1 |
| 1225818 | 1225818 | 119626 119626 | Computational Toxicology and Exposure Data 4 | 83627 83627 | 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)
);