api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
11 rows where inchi_id = 136365
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 281703 | 281703 | 398639 398639 | PubChem (compound) 1 | 136365 136365 | 2 |
| 674482 | 674482 | 115088 115088 | PubChem (substance) 2 | 136365 136365 | 6 |
| 674483 | 674483 | 67516 67516 | PubChem (substance) 2 | 136365 136365 | 2 |
| 674484 | 674484 | 87920 87920 | PubChem (substance) 2 | 136365 136365 | 10 |
| 674485 | 674485 | 154190 154190 | PubChem (substance) 2 | 136365 136365 | 5 |
| 674486 | 674486 | 67517 67517 | PubChem (substance) 2 | 136365 136365 | 2 |
| 674487 | 674487 | 154189 154189 | PubChem (substance) 2 | 136365 136365 | 3 |
| 674488 | 674488 | 87921 87921 | PubChem (substance) 2 | 136365 136365 | 8 |
| 674489 | 674489 | 398639 398639 | PubChem (substance) 2 | 136365 136365 | 3 |
| 674490 | 674490 | 408190 408190 | PubChem (substance) 2 | 136365 136365 | 9 |
| 674491 | 674491 | 437834 437834 | PubChem (substance) 2 | 136365 136365 | 2 |
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)
);