api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
14 rows where inchi_id = 56428
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 12553 | 12553 | 6684 6684 | PubChem (compound) 1 | 56428 56428 | 1 |
| 12554 | 12554 | 6685 6685 | PubChem (compound) 1 | 56428 56428 | 1 |
| 12555 | 12555 | 18178 18178 | PubChem (compound) 1 | 56428 56428 | 1 |
| 12556 | 12556 | 67258 67258 | PubChem (compound) 1 | 56428 56428 | 1 |
| 313375 | 313375 | 27028 27028 | PubChem (substance) 2 | 56428 56428 | 9 |
| 313376 | 313376 | 6684 6684 | PubChem (substance) 2 | 56428 56428 | 1 |
| 313377 | 313377 | 6685 6685 | PubChem (substance) 2 | 56428 56428 | 1 |
| 313378 | 313378 | 18178 18178 | PubChem (substance) 2 | 56428 56428 | 1 |
| 313379 | 313379 | 67258 67258 | PubChem (substance) 2 | 56428 56428 | 1 |
| 947477 | 947477 | 6684 6684 | CAS Common Chemistry 3 | 56428 56428 | 1 |
| 947478 | 947478 | 67258 67258 | CAS Common Chemistry 3 | 56428 56428 | 1 |
| 947479 | 947479 | 6685 6685 | CAS Common Chemistry 3 | 56428 56428 | 1 |
| 1145799 | 1145799 | 6684 6684 | Computational Toxicology and Exposure Data 4 | 56428 56428 | 1 |
| 1145800 | 1145800 | 67258 67258 | Computational Toxicology and Exposure Data 4 | 56428 56428 | 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)
);