api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
14 rows where inchi_id = 76365
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 98696 | 98696 | 58928 58928 | PubChem (compound) 1 | 76365 76365 | 1 |
| 98697 | 98697 | 58927 58927 | PubChem (compound) 1 | 76365 76365 | 1 |
| 98698 | 98698 | 105674 105674 | PubChem (compound) 1 | 76365 76365 | 1 |
| 98699 | 98699 | 371663 371663 | PubChem (compound) 1 | 76365 76365 | 1 |
| 435199 | 435199 | 58927 58927 | PubChem (substance) 2 | 76365 76365 | 1 |
| 435200 | 435200 | 105674 105674 | PubChem (substance) 2 | 76365 76365 | 1 |
| 435201 | 435201 | 58928 58928 | PubChem (substance) 2 | 76365 76365 | 1 |
| 435202 | 435202 | 165298 165298 | PubChem (substance) 2 | 76365 76365 | 2 |
| 435203 | 435203 | 104898 104898 | PubChem (substance) 2 | 76365 76365 | 2 |
| 435204 | 435204 | 371663 371663 | PubChem (substance) 2 | 76365 76365 | 1 |
| 1011134 | 1011134 | 58927 58927 | CAS Common Chemistry 3 | 76365 76365 | 1 |
| 1011135 | 1011135 | 105674 105674 | CAS Common Chemistry 3 | 76365 76365 | 1 |
| 1011136 | 1011136 | 371663 371663 | CAS Common Chemistry 3 | 76365 76365 | 1 |
| 1011137 | 1011137 | 58928 58928 | CAS Common Chemistry 3 | 76365 76365 | 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)
);