api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
11 rows where inchi_id = 27381
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 112078 | 112078 | 80687 80687 | PubChem (compound) 1 | 27381 27381 | 1 |
| 112079 | 112079 | 80688 80688 | PubChem (compound) 1 | 27381 27381 | 1 |
| 112080 | 112080 | 128776 128776 | PubChem (compound) 1 | 27381 27381 | 1 |
| 112081 | 112081 | 439803 439803 | PubChem (compound) 1 | 27381 27381 | 1 |
| 453874 | 453874 | 80687 80687 | PubChem (substance) 2 | 27381 27381 | 1 |
| 453875 | 453875 | 128776 128776 | PubChem (substance) 2 | 27381 27381 | 1 |
| 453876 | 453876 | 80688 80688 | PubChem (substance) 2 | 27381 27381 | 1 |
| 453877 | 453877 | 439803 439803 | PubChem (substance) 2 | 27381 27381 | 1 |
| 1020133 | 1020133 | 439803 439803 | CAS Common Chemistry 3 | 27381 27381 | 1 |
| 1020134 | 1020134 | 80687 80687 | CAS Common Chemistry 3 | 27381 27381 | 1 |
| 1020135 | 1020135 | 80688 80688 | CAS Common Chemistry 3 | 27381 27381 | 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)
);