api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
8 rows where inchi_id = 240424
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 821551 | 821551 | 177013 177013 | PubChem (substance) 2 | 240424 240424 | 14 |
| 821552 | 821552 | 177014 177014 | PubChem (substance) 2 | 240424 240424 | 11 |
| 821553 | 821553 | 442960 442960 | PubChem (substance) 2 | 240424 240424 | 11 |
| 821554 | 821554 | 338463 338463 | PubChem (substance) 2 | 240424 240424 | 11 |
| 821555 | 821555 | 442960 442960 | PubChem (substance) 2 | 240424 240424 | 10 |
| 821556 | 821556 | 177013 177013 | PubChem (substance) 2 | 240424 240424 | 15 |
| 821557 | 821557 | 177014 177014 | PubChem (substance) 2 | 240424 240424 | 10 |
| 821558 | 821558 | 338463 338463 | PubChem (substance) 2 | 240424 240424 | 10 |
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)
);