api_results
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
16 rows where inchi_id = 440
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | query_id | api_id | inchi_id | rank |
|---|---|---|---|---|---|
| 285490 | 285490 | 413701 413701 | PubChem (compound) 1 | 440 440 | 1 |
| 679609 | 679609 | 29090 29090 | PubChem (substance) 2 | 440 440 | 2 |
| 679610 | 679610 | 413701 413701 | PubChem (substance) 2 | 440 440 | 1 |
| 983110 | 983110 | 28646 28646 | CAS Common Chemistry 3 | 440 440 | 1 |
| 983111 | 983111 | 28647 28647 | CAS Common Chemistry 3 | 440 440 | 1 |
| 983112 | 983112 | 302146 302146 | CAS Common Chemistry 3 | 440 440 | 1 |
| 983113 | 983113 | 97798 97798 | CAS Common Chemistry 3 | 440 440 | 1 |
| 983114 | 983114 | 146429 146429 | CAS Common Chemistry 3 | 440 440 | 1 |
| 983115 | 983115 | 346561 346561 | CAS Common Chemistry 3 | 440 440 | 1 |
| 983116 | 983116 | 97797 97797 | CAS Common Chemistry 3 | 440 440 | 1 |
| 983117 | 983117 | 413488 413488 | CAS Common Chemistry 3 | 440 440 | 1 |
| 983872 | 983872 | 29090 29090 | CAS Common Chemistry 3 | 440 440 | 1 |
| 983873 | 983873 | 413701 413701 | CAS Common Chemistry 3 | 440 440 | 1 |
| 983874 | 983874 | 29091 29091 | CAS Common Chemistry 3 | 440 440 | 1 |
| 983875 | 983875 | 97878 97878 | CAS Common Chemistry 3 | 440 440 | 1 |
| 983876 | 983876 | 97879 97879 | CAS Common Chemistry 3 | 440 440 | 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)
);