api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
13 rows where query_id = 104712
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 124648 | 124648 | 104712 104712 | PubChem (compound) 1 | 48080 48080 | 1 |
| 471547 | 471547 | 104712 104712 | PubChem (substance) 2 | 48080 48080 | 1 |
| 771505 | 771505 | 104712 104712 | PubChem (substance) 2 | 161708 161708 | 2 |
| 771506 | 771506 | 104712 104712 | PubChem (substance) 2 | 261294 261294 | 3 |
| 771508 | 771508 | 104712 104712 | PubChem (substance) 2 | 192263 192263 | 5 |
| 771511 | 771511 | 104712 104712 | PubChem (substance) 2 | 264335 264335 | 8 |
| 771512 | 771512 | 104712 104712 | PubChem (substance) 2 | 243339 243339 | 7 |
| 771516 | 771516 | 104712 104712 | PubChem (substance) 2 | 308544 308544 | 9 |
| 771517 | 771517 | 104712 104712 | PubChem (substance) 2 | 192438 192438 | 4 |
| 771518 | 771518 | 104712 104712 | PubChem (substance) 2 | 200051 200051 | 6 |
| 771519 | 771519 | 104712 104712 | PubChem (substance) 2 | 231412 231412 | 10 |
| 1028489 | 1028489 | 104712 104712 | CAS Common Chemistry 3 | 48080 48080 | 1 |
| 1231294 | 1231294 | 104712 104712 | Computational Toxicology and Exposure Data 4 | 48080 48080 | 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)
);