api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
12 rows where inchi_id = 140182
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 704979 | 704979 | 9721 9721 | PubChem (substance) 2 | 140182 140182 | 2 |
| 704980 | 704980 | 9722 9722 | PubChem (substance) 2 | 140182 140182 | 2 |
| 704981 | 704981 | 27547 27547 | PubChem (substance) 2 | 140182 140182 | 2 |
| 704982 | 704982 | 240386 240386 | PubChem (substance) 2 | 140182 140182 | 3 |
| 704983 | 704983 | 347211 347211 | PubChem (substance) 2 | 140182 140182 | 4 |
| 704984 | 704984 | 370674 370674 | PubChem (substance) 2 | 140182 140182 | 3 |
| 704985 | 704985 | 370563 370563 | PubChem (substance) 2 | 140182 140182 | 4 |
| 704986 | 704986 | 370672 370672 | PubChem (substance) 2 | 140182 140182 | 2 |
| 704987 | 704987 | 145008 145008 | PubChem (substance) 2 | 140182 140182 | 2 |
| 704988 | 704988 | 353403 353403 | PubChem (substance) 2 | 140182 140182 | 4 |
| 704989 | 704989 | 351941 351941 | PubChem (substance) 2 | 140182 140182 | 2 |
| 704990 | 704990 | 84240 84240 | PubChem (substance) 2 | 140182 140182 | 4 |
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)
);