api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
11 rows where inchi_id = 118204
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 267650 | 267650 | 364014 364014 | PubChem (compound) 1 | 118204 118204 | 1 |
| 267651 | 267651 | 364013 364013 | PubChem (compound) 1 | 118204 118204 | 1 |
| 267652 | 267652 | 392118 392118 | PubChem (compound) 1 | 118204 118204 | 1 |
| 656742 | 656742 | 100414 100414 | PubChem (substance) 2 | 118204 118204 | 3 |
| 656743 | 656743 | 116153 116153 | PubChem (substance) 2 | 118204 118204 | 3 |
| 656744 | 656744 | 364013 364013 | PubChem (substance) 2 | 118204 118204 | 1 |
| 656745 | 656745 | 364014 364014 | PubChem (substance) 2 | 118204 118204 | 1 |
| 656746 | 656746 | 392118 392118 | PubChem (substance) 2 | 118204 118204 | 1 |
| 915918 | 915918 | 364013 364013 | PubChem (substance) 2 | 118204 118204 | 2 |
| 915919 | 915919 | 392118 392118 | PubChem (substance) 2 | 118204 118204 | 2 |
| 1328777 | 1328777 | 364013 364013 | Computational Toxicology and Exposure Data 4 | 118204 118204 | 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)
);