api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
13 rows where inchi_id = 70052
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 58756 | 58756 | 27002 27002 | PubChem (compound) 1 | 70052 70052 | 1 |
| 58757 | 58757 | 27003 27003 | PubChem (compound) 1 | 70052 70052 | 1 |
| 58758 | 58758 | 143684 143684 | PubChem (compound) 1 | 70052 70052 | 1 |
| 58759 | 58759 | 239950 239950 | PubChem (compound) 1 | 70052 70052 | 1 |
| 58760 | 58760 | 88325 88325 | PubChem (compound) 1 | 70052 70052 | 1 |
| 378840 | 378840 | 27003 27003 | PubChem (substance) 2 | 70052 70052 | 1 |
| 378841 | 378841 | 27002 27002 | PubChem (substance) 2 | 70052 70052 | 1 |
| 378842 | 378842 | 143684 143684 | PubChem (substance) 2 | 70052 70052 | 1 |
| 378843 | 378843 | 239950 239950 | PubChem (substance) 2 | 70052 70052 | 1 |
| 378844 | 378844 | 88325 88325 | PubChem (substance) 2 | 70052 70052 | 1 |
| 981325 | 981325 | 27002 27002 | CAS Common Chemistry 3 | 70052 70052 | 1 |
| 981326 | 981326 | 27003 27003 | CAS Common Chemistry 3 | 70052 70052 | 1 |
| 981327 | 981327 | 239950 239950 | CAS Common Chemistry 3 | 70052 70052 | 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)
);