api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
12 rows where inchi_id = 77119
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 8613 | 8613 | 305182 305182 | PubChem (compound) 1 | 77119 77119 | 1 |
| 8614 | 8614 | 4609 4609 | PubChem (compound) 1 | 77119 77119 | 1 |
| 8615 | 8615 | 4611 4611 | PubChem (compound) 1 | 77119 77119 | 1 |
| 8616 | 8616 | 344419 344419 | PubChem (compound) 1 | 77119 77119 | 1 |
| 8617 | 8617 | 302743 302743 | PubChem (compound) 1 | 77119 77119 | 1 |
| 307423 | 307423 | 302743 302743 | PubChem (substance) 2 | 77119 77119 | 1 |
| 307424 | 307424 | 4609 4609 | PubChem (substance) 2 | 77119 77119 | 1 |
| 307425 | 307425 | 4611 4611 | PubChem (substance) 2 | 77119 77119 | 1 |
| 307426 | 307426 | 344419 344419 | PubChem (substance) 2 | 77119 77119 | 1 |
| 307427 | 307427 | 305182 305182 | PubChem (substance) 2 | 77119 77119 | 1 |
| 944540 | 944540 | 4609 4609 | CAS Common Chemistry 3 | 77119 77119 | 1 |
| 944541 | 944541 | 302743 302743 | CAS Common Chemistry 3 | 77119 77119 | 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)
);