api_results

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

18 rows where query_id = 81626

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102686 102686 81626 81626 PubChem (compound) 1 119329 119329 1
441030 441030 81626 81626 PubChem (substance) 2 119329 119329 1
441048 441048 81626 81626 PubChem (substance) 2 314709 314709 2
441062 441062 81626 81626 PubChem (substance) 2 315696 315696 9
441077 441077 81626 81626 PubChem (substance) 2 315581 315581 3
441094 441094 81626 81626 PubChem (substance) 2 315701 315701 12
441107 441107 81626 81626 PubChem (substance) 2 316303 316303 5
454536 454536 81626 81626 PubChem (substance) 2 8701 8701 6
531190 531190 81626 81626 PubChem (substance) 2 315716 315716 10
752870 752870 81626 81626 PubChem (substance) 2 317023 317023 4
752884 752884 81626 81626 PubChem (substance) 2 315090 315090 7
752893 752893 81626 81626 PubChem (substance) 2 315098 315098 8
752904 752904 81626 81626 PubChem (substance) 2 317895 317895 11
752915 752915 81626 81626 PubChem (substance) 2 317838 317838 13
752930 752930 81626 81626 PubChem (substance) 2 317948 317948 14
752948 752948 81626 81626 PubChem (substance) 2 317881 317881 15
1013768 1013768 81626 81626 CAS Common Chemistry 3 8701 8701 1
1215931 1215931 81626 81626 Computational Toxicology and Exposure Data 4 119329 119329 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)
);