api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
13 rows where inchi_id = 116875
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 238584 | 238584 | 235258 235258 | PubChem (compound) 1 | 116875 116875 | 2 |
| 238585 | 238585 | 233132 233132 | PubChem (compound) 1 | 116875 116875 | 1 |
| 238586 | 238586 | 233133 233133 | PubChem (compound) 1 | 116875 116875 | 1 |
| 238587 | 238587 | 304924 304924 | PubChem (compound) 1 | 116875 116875 | 1 |
| 619035 | 619035 | 92389 92389 | PubChem (substance) 2 | 116875 116875 | 42 |
| 619036 | 619036 | 233133 233133 | PubChem (substance) 2 | 116875 116875 | 1 |
| 619037 | 619037 | 349009 349009 | PubChem (substance) 2 | 116875 116875 | 42 |
| 619038 | 619038 | 93313 93313 | PubChem (substance) 2 | 116875 116875 | 3 |
| 619039 | 619039 | 233132 233132 | PubChem (substance) 2 | 116875 116875 | 1 |
| 619040 | 619040 | 235258 235258 | PubChem (substance) 2 | 116875 116875 | 3 |
| 619041 | 619041 | 304924 304924 | PubChem (substance) 2 | 116875 116875 | 1 |
| 1310917 | 1310917 | 233132 233132 | Computational Toxicology and Exposure Data 4 | 116875 116875 | 1 |
| 1310918 | 1310918 | 304924 304924 | Computational Toxicology and Exposure Data 4 | 116875 116875 | 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)
);