api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
9 rows where inchi_id = 3399
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 970725 | 970725 | 19947 19947 | CAS Common Chemistry 3 | 3399 3399 | 1 |
| 970726 | 970726 | 19948 19948 | CAS Common Chemistry 3 | 3399 3399 | 1 |
| 984401 | 984401 | 29565 29565 | CAS Common Chemistry 3 | 3399 3399 | 1 |
| 984402 | 984402 | 29566 29566 | CAS Common Chemistry 3 | 3399 3399 | 1 |
| 984403 | 984403 | 122741 122741 | CAS Common Chemistry 3 | 3399 3399 | 1 |
| 984670 | 984670 | 30099 30099 | CAS Common Chemistry 3 | 3399 3399 | 1 |
| 984671 | 984671 | 30098 30098 | CAS Common Chemistry 3 | 3399 3399 | 1 |
| 1005063 | 1005063 | 51629 51629 | CAS Common Chemistry 3 | 3399 3399 | 1 |
| 1005064 | 1005064 | 51630 51630 | CAS Common Chemistry 3 | 3399 3399 | 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)
);