api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
11 rows where inchi_id = 99966
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 100972 | 100972 | 149547 149547 | PubChem (compound) 1 | 99966 99966 | 1 |
| 100973 | 100973 | 60991 60991 | PubChem (compound) 1 | 99966 99966 | 1 |
| 100974 | 100974 | 60990 60990 | PubChem (compound) 1 | 99966 99966 | 1 |
| 100975 | 100975 | 318526 318526 | PubChem (compound) 1 | 99966 99966 | 1 |
| 438641 | 438641 | 149547 149547 | PubChem (substance) 2 | 99966 99966 | 1 |
| 438642 | 438642 | 60990 60990 | PubChem (substance) 2 | 99966 99966 | 1 |
| 438643 | 438643 | 413897 413897 | PubChem (substance) 2 | 99966 99966 | 2 |
| 438644 | 438644 | 148141 148141 | PubChem (substance) 2 | 99966 99966 | 2 |
| 438645 | 438645 | 60991 60991 | PubChem (substance) 2 | 99966 99966 | 1 |
| 438646 | 438646 | 318526 318526 | PubChem (substance) 2 | 99966 99966 | 1 |
| 1214754 | 1214754 | 60990 60990 | Computational Toxicology and Exposure Data 4 | 99966 99966 | 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)
);