api_results

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

7 rows where query_id = 175553

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
168485 168485 175553 175553 PubChem (compound) 1 6469 6469 1
529715 529715 175553 175553 PubChem (substance) 2 6469 6469 1
563259 563259 175553 175553 PubChem (substance) 2 135884 135884 2
820898 820898 175553 175553 PubChem (substance) 2 191214 191214 3
820899 820899 175553 175553 PubChem (substance) 2 343873 343873 4
1079782 1079782 175553 175553 CAS Common Chemistry 3 6469 6469 1
1263984 1263984 175553 175553 Computational Toxicology and Exposure Data 4 6469 6469 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)
);