api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
14 rows where inchi_id = 7028
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 702247 | 702247 | 80352 80352 | PubChem (substance) 2 | 7028 7028 | 3 |
| 702248 | 702248 | 7373 7373 | PubChem (substance) 2 | 7028 7028 | 2 |
| 702249 | 702249 | 403777 403777 | PubChem (substance) 2 | 7028 7028 | 2 |
| 702250 | 702250 | 7375 7375 | PubChem (substance) 2 | 7028 7028 | 3 |
| 702251 | 702251 | 350481 350481 | PubChem (substance) 2 | 7028 7028 | 3 |
| 948459 | 948459 | 7373 7373 | CAS Common Chemistry 3 | 7028 7028 | 1 |
| 948460 | 948460 | 7374 7374 | CAS Common Chemistry 3 | 7028 7028 | 1 |
| 948461 | 948461 | 403777 403777 | CAS Common Chemistry 3 | 7028 7028 | 1 |
| 948462 | 948462 | 109256 109256 | CAS Common Chemistry 3 | 7028 7028 | 1 |
| 948463 | 948463 | 15688 15688 | CAS Common Chemistry 3 | 7028 7028 | 1 |
| 948464 | 948464 | 350481 350481 | CAS Common Chemistry 3 | 7028 7028 | 1 |
| 948465 | 948465 | 7375 7375 | CAS Common Chemistry 3 | 7028 7028 | 1 |
| 948466 | 948466 | 80352 80352 | CAS Common Chemistry 3 | 7028 7028 | 1 |
| 948467 | 948467 | 80353 80353 | CAS Common Chemistry 3 | 7028 7028 | 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)
);