api_results

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

14 rows where query_id = 250865

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
148514 148514 250865 250865 PubChem (compound) 1 26163 26163 2
245867 245867 250865 250865 PubChem (compound) 1 139462 139462 1
245868 245868 250865 250865 PubChem (compound) 1 186291 186291 3
245869 245869 250865 250865 PubChem (compound) 1 192668 192668 4
503296 503296 250865 250865 PubChem (substance) 2 26163 26163 2
628440 628440 250865 250865 PubChem (substance) 2 139462 139462 1
628444 628444 250865 250865 PubChem (substance) 2 186291 186291 3
628448 628448 250865 250865 PubChem (substance) 2 192668 192668 5
655867 655867 250865 250865 PubChem (substance) 2 189037 189037 4
712464 712464 250865 250865 PubChem (substance) 2 17650 17650 10
842920 842920 250865 250865 PubChem (substance) 2 216869 216869 6
842922 842922 250865 250865 PubChem (substance) 2 260436 260436 7
842923 842923 250865 250865 PubChem (substance) 2 288071 288071 8
842924 842924 250865 250865 PubChem (substance) 2 329485 329485 9 
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)
);