api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
12 rows where inchi_id = 75778
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 727419 | 727419 | 27681 27681 | PubChem (substance) 2 | 75778 75778 | 3 |
| 982345 | 982345 | 405547 405547 | CAS Common Chemistry 3 | 75778 75778 | 1 |
| 982346 | 982346 | 27681 27681 | CAS Common Chemistry 3 | 75778 75778 | 1 |
| 982347 | 982347 | 240493 240493 | CAS Common Chemistry 3 | 75778 75778 | 1 |
| 982348 | 982348 | 305442 305442 | CAS Common Chemistry 3 | 75778 75778 | 1 |
| 982349 | 982349 | 62566 62566 | CAS Common Chemistry 3 | 75778 75778 | 1 |
| 982350 | 982350 | 371095 371095 | CAS Common Chemistry 3 | 75778 75778 | 1 |
| 982351 | 982351 | 371098 371098 | CAS Common Chemistry 3 | 75778 75778 | 1 |
| 982352 | 982352 | 371096 371096 | CAS Common Chemistry 3 | 75778 75778 | 1 |
| 982353 | 982353 | 27682 27682 | CAS Common Chemistry 3 | 75778 75778 | 1 |
| 982354 | 982354 | 145360 145360 | CAS Common Chemistry 3 | 75778 75778 | 1 |
| 982355 | 982355 | 371094 371094 | CAS Common Chemistry 3 | 75778 75778 | 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)
);