api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
11 rows where inchi_id = 55044
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 748281 | 748281 | 366141 366141 | PubChem (substance) 2 | 55044 55044 | 3 |
| 748282 | 748282 | 57880 57880 | PubChem (substance) 2 | 55044 55044 | 4 |
| 748283 | 748283 | 110890 110890 | PubChem (substance) 2 | 55044 55044 | 4 |
| 748284 | 748284 | 105028 105028 | PubChem (substance) 2 | 55044 55044 | 2 |
| 748285 | 748285 | 105158 105158 | PubChem (substance) 2 | 55044 55044 | 3 |
| 748286 | 748286 | 80669 80669 | PubChem (substance) 2 | 55044 55044 | 1 |
| 748287 | 748287 | 105029 105029 | PubChem (substance) 2 | 55044 55044 | 2 |
| 748288 | 748288 | 104635 104635 | PubChem (substance) 2 | 55044 55044 | 2 |
| 1020126 | 1020126 | 105029 105029 | CAS Common Chemistry 3 | 55044 55044 | 1 |
| 1020127 | 1020127 | 105028 105028 | CAS Common Chemistry 3 | 55044 55044 | 1 |
| 1020128 | 1020128 | 80669 80669 | CAS Common Chemistry 3 | 55044 55044 | 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)
);