api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
13 rows where inchi_id = 229283
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 34551 | 34551 | 16052 16052 | PubChem (compound) 1 | 229283 229283 | 1 |
| 34552 | 34552 | 403922 403922 | PubChem (compound) 1 | 229283 229283 | 1 |
| 34553 | 34553 | 231483 231483 | PubChem (compound) 1 | 229283 229283 | 1 |
| 34554 | 34554 | 16053 16053 | PubChem (compound) 1 | 229283 229283 | 1 |
| 34555 | 34555 | 122204 122204 | PubChem (compound) 1 | 229283 229283 | 1 |
| 34556 | 34556 | 437305 437305 | PubChem (compound) 1 | 229283 229283 | 1 |
| 345005 | 345005 | 231483 231483 | PubChem (substance) 2 | 229283 229283 | 1 |
| 345006 | 345006 | 16052 16052 | PubChem (substance) 2 | 229283 229283 | 1 |
| 345007 | 345007 | 16053 16053 | PubChem (substance) 2 | 229283 229283 | 1 |
| 345008 | 345008 | 403922 403922 | PubChem (substance) 2 | 229283 229283 | 1 |
| 345009 | 345009 | 110055 110055 | PubChem (substance) 2 | 229283 229283 | 2 |
| 345010 | 345010 | 437305 437305 | PubChem (substance) 2 | 229283 229283 | 1 |
| 345011 | 345011 | 122204 122204 | PubChem (substance) 2 | 229283 229283 | 2 |
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)
);