api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
11 rows where inchi_id = 20835
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 68580 | 68580 | 160312 160312 | PubChem (compound) 1 | 20835 20835 | 1 |
| 68581 | 68581 | 33015 33015 | PubChem (compound) 1 | 20835 20835 | 1 |
| 68582 | 68582 | 33016 33016 | PubChem (compound) 1 | 20835 20835 | 1 |
| 393366 | 393366 | 33015 33015 | PubChem (substance) 2 | 20835 20835 | 1 |
| 393367 | 393367 | 33016 33016 | PubChem (substance) 2 | 20835 20835 | 1 |
| 393368 | 393368 | 160312 160312 | PubChem (substance) 2 | 20835 20835 | 1 |
| 988806 | 988806 | 33015 33015 | CAS Common Chemistry 3 | 20835 20835 | 1 |
| 988807 | 988807 | 33016 33016 | CAS Common Chemistry 3 | 20835 20835 | 1 |
| 1191660 | 1191660 | 33015 33015 | Computational Toxicology and Exposure Data 4 | 20835 20835 | 1 |
| 1191661 | 1191661 | 33016 33016 | Computational Toxicology and Exposure Data 4 | 20835 20835 | 1 |
| 1191662 | 1191662 | 160312 160312 | Computational Toxicology and Exposure Data 4 | 20835 20835 | 1 |
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)
);