api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
7 rows where inchi_id = 170640
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 713551 | 713551 | 15746 15746 | PubChem (substance) 2 | 170640 170640 | 5 |
| 713552 | 713552 | 15747 15747 | PubChem (substance) 2 | 170640 170640 | 2 |
| 713553 | 713553 | 271149 271149 | PubChem (substance) 2 | 170640 170640 | 2 |
| 713554 | 713554 | 271150 271150 | PubChem (substance) 2 | 170640 170640 | 2 |
| 713555 | 713555 | 109391 109391 | PubChem (substance) 2 | 170640 170640 | 3 |
| 713556 | 713556 | 330376 330376 | PubChem (substance) 2 | 170640 170640 | 4 |
| 713557 | 713557 | 350691 350691 | PubChem (substance) 2 | 170640 170640 | 3 |
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)
);