api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
6 rows where inchi_id = 204846
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 726493 | 726493 | 27066 27066 | PubChem (substance) 2 | 204846 204846 | 3 |
| 726494 | 726494 | 27067 27067 | PubChem (substance) 2 | 204846 204846 | 7 |
| 726495 | 726495 | 306168 306168 | PubChem (substance) 2 | 204846 204846 | 6 |
| 726496 | 726496 | 369513 369513 | PubChem (substance) 2 | 204846 204846 | 6 |
| 726497 | 726497 | 91154 91154 | PubChem (substance) 2 | 204846 204846 | 6 |
| 726498 | 726498 | 110211 110211 | PubChem (substance) 2 | 204846 204846 | 6 |
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)
);