api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
11 rows where inchi_id = 20860
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 179596 | 179596 | 334535 334535 | PubChem (compound) 1 | 20860 20860 | 1 |
| 179597 | 179597 | 160337 160337 | PubChem (compound) 1 | 20860 20860 | 1 |
| 544280 | 544280 | 17193 17193 | PubChem (substance) 2 | 20860 20860 | 3 |
| 544281 | 544281 | 160337 160337 | PubChem (substance) 2 | 20860 20860 | 1 |
| 544282 | 544282 | 362204 362204 | PubChem (substance) 2 | 20860 20860 | 2 |
| 544283 | 544283 | 160338 160338 | PubChem (substance) 2 | 20860 20860 | 1 |
| 544284 | 544284 | 334535 334535 | PubChem (substance) 2 | 20860 20860 | 1 |
| 1070054 | 1070054 | 160337 160337 | CAS Common Chemistry 3 | 20860 20860 | 1 |
| 1070055 | 1070055 | 334535 334535 | CAS Common Chemistry 3 | 20860 20860 | 1 |
| 1271475 | 1271475 | 160337 160337 | Computational Toxicology and Exposure Data 4 | 20860 20860 | 1 |
| 1271476 | 1271476 | 334535 334535 | Computational Toxicology and Exposure Data 4 | 20860 20860 | 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)
);