api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
13 rows where inchi_id = 74789
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 125474 | 125474 | 405904 405904 | PubChem (compound) 1 | 74789 74789 | 1 |
| 125475 | 125475 | 105534 105534 | PubChem (compound) 1 | 74789 74789 | 1 |
| 125476 | 125476 | 105533 105533 | PubChem (compound) 1 | 74789 74789 | 1 |
| 472845 | 472845 | 13905 13905 | PubChem (substance) 2 | 74789 74789 | 2 |
| 472846 | 472846 | 105534 105534 | PubChem (substance) 2 | 74789 74789 | 1 |
| 472847 | 472847 | 105533 105533 | PubChem (substance) 2 | 74789 74789 | 1 |
| 472848 | 472848 | 436404 436404 | PubChem (substance) 2 | 74789 74789 | 2 |
| 472849 | 472849 | 405904 405904 | PubChem (substance) 2 | 74789 74789 | 1 |
| 1029041 | 1029041 | 105533 105533 | CAS Common Chemistry 3 | 74789 74789 | 1 |
| 1029042 | 1029042 | 105534 105534 | CAS Common Chemistry 3 | 74789 74789 | 1 |
| 1231890 | 1231890 | 405904 405904 | Computational Toxicology and Exposure Data 4 | 74789 74789 | 1 |
| 1231891 | 1231891 | 105533 105533 | Computational Toxicology and Exposure Data 4 | 74789 74789 | 1 |
| 1231892 | 1231892 | 105534 105534 | Computational Toxicology and Exposure Data 4 | 74789 74789 | 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)
);