api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
11 rows where inchi_id = 56205
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 135646 | 135646 | 116153 116153 | PubChem (compound) 1 | 56205 56205 | 1 |
| 135647 | 135647 | 116154 116154 | PubChem (compound) 1 | 56205 56205 | 1 |
| 135648 | 135648 | 340906 340906 | PubChem (compound) 1 | 56205 56205 | 1 |
| 135649 | 135649 | 364885 364885 | PubChem (compound) 1 | 56205 56205 | 1 |
| 486408 | 486408 | 116153 116153 | PubChem (substance) 2 | 56205 56205 | 1 |
| 486409 | 486409 | 340906 340906 | PubChem (substance) 2 | 56205 56205 | 1 |
| 486410 | 486410 | 364885 364885 | PubChem (substance) 2 | 56205 56205 | 1 |
| 486411 | 486411 | 116154 116154 | PubChem (substance) 2 | 56205 56205 | 1 |
| 1036764 | 1036764 | 116153 116153 | CAS Common Chemistry 3 | 56205 56205 | 1 |
| 1036765 | 1036765 | 340906 340906 | CAS Common Chemistry 3 | 56205 56205 | 1 |
| 1036766 | 1036766 | 116154 116154 | CAS Common Chemistry 3 | 56205 56205 | 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)
);