api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
12 rows where inchi_id = 231953
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 699160 | 699160 | 5218 5218 | PubChem (substance) 2 | 231953 231953 | 5 |
| 699161 | 699161 | 5222 5222 | PubChem (substance) 2 | 231953 231953 | 3 |
| 699162 | 699162 | 351193 351193 | PubChem (substance) 2 | 231953 231953 | 2 |
| 699163 | 699163 | 330655 330655 | PubChem (substance) 2 | 231953 231953 | 2 |
| 699164 | 699164 | 233982 233982 | PubChem (substance) 2 | 231953 231953 | 2 |
| 699165 | 699165 | 351192 351192 | PubChem (substance) 2 | 231953 231953 | 5 |
| 699166 | 699166 | 122800 122800 | PubChem (substance) 2 | 231953 231953 | 2 |
| 699167 | 699167 | 351194 351194 | PubChem (substance) 2 | 231953 231953 | 2 |
| 699168 | 699168 | 95579 95579 | PubChem (substance) 2 | 231953 231953 | 2 |
| 699169 | 699169 | 351195 351195 | PubChem (substance) 2 | 231953 231953 | 2 |
| 699170 | 699170 | 95580 95580 | PubChem (substance) 2 | 231953 231953 | 1 |
| 699171 | 699171 | 301730 301730 | PubChem (substance) 2 | 231953 231953 | 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)
);