api_results

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

10 rows where query_id = 62290

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102660 102660 62290 62290 PubChem (compound) 1 31915 31915 1
440988 440988 62290 62290 PubChem (substance) 2 31915 31915 1
440996 440996 62290 62290 PubChem (substance) 2 44265 44265 3
646695 646695 62290 62290 PubChem (substance) 2 48121 48121 6
752784 752784 62290 62290 PubChem (substance) 2 137531 137531 2
752792 752792 62290 62290 PubChem (substance) 2 191998 191998 4
752797 752797 62290 62290 PubChem (substance) 2 191999 191999 5
752802 752802 62290 62290 PubChem (substance) 2 208868 208868 7
1013743 1013743 62290 62290 CAS Common Chemistry 3 31915 31915 1
1215903 1215903 62290 62290 Computational Toxicology and Exposure Data 4 31915 31915 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)
);