api_results

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

10 rows where query_id = 110513

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
35626 35626 110513 110513 PubChem (compound) 1 13856 13856 1
346590 346590 110513 110513 PubChem (substance) 2 13856 13856 1
496026 496026 110513 110513 PubChem (substance) 2 231915 231915 4
496031 496031 110513 110513 PubChem (substance) 2 186060 186060 2
714689 714689 110513 110513 PubChem (substance) 2 240998 240998 6
777153 777153 110513 110513 PubChem (substance) 2 230266 230266 3
777154 777154 110513 110513 PubChem (substance) 2 230266 230266 5
777155 777155 110513 110513 PubChem (substance) 2 290385 290385 7
964116 964116 110513 110513 CAS Common Chemistry 3 13856 13856 1
1165672 1165672 110513 110513 Computational Toxicology and Exposure Data 4 13856 13856 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)
);