api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
13 rows where inchi_id = 75072
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 42112 | 42112 | 305568 305568 | PubChem (compound) 1 | 75072 75072 | 1 |
| 42113 | 42113 | 18943 18943 | PubChem (compound) 1 | 75072 75072 | 1 |
| 42114 | 42114 | 118653 118653 | PubChem (compound) 1 | 75072 75072 | 1 |
| 42115 | 42115 | 18944 18944 | PubChem (compound) 1 | 75072 75072 | 1 |
| 355608 | 355608 | 18944 18944 | PubChem (substance) 2 | 75072 75072 | 1 |
| 355609 | 355609 | 375370 375370 | PubChem (substance) 2 | 75072 75072 | 2 |
| 355610 | 355610 | 18943 18943 | PubChem (substance) 2 | 75072 75072 | 1 |
| 355611 | 355611 | 118653 118653 | PubChem (substance) 2 | 75072 75072 | 1 |
| 355612 | 355612 | 305568 305568 | PubChem (substance) 2 | 75072 75072 | 1 |
| 968964 | 968964 | 305568 305568 | CAS Common Chemistry 3 | 75072 75072 | 1 |
| 968965 | 968965 | 18943 18943 | CAS Common Chemistry 3 | 75072 75072 | 1 |
| 968966 | 968966 | 118653 118653 | CAS Common Chemistry 3 | 75072 75072 | 1 |
| 968967 | 968967 | 18944 18944 | CAS Common Chemistry 3 | 75072 75072 | 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)
);