api_results

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

14 rows where query_id = 110360

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
129371 129371 110360 110360 PubChem (compound) 1 12457 12457 1
477981 477981 110360 110360 PubChem (substance) 2 12457 12457 1
494091 494091 110360 110360 PubChem (substance) 2 4140 4140 9
674173 674173 110360 110360 PubChem (substance) 2 113747 113747 4
776987 776987 110360 110360 PubChem (substance) 2 136495 136495 2
776989 776989 110360 110360 PubChem (substance) 2 266776 266776 3
776990 776990 110360 110360 PubChem (substance) 2 154890 154890 5
776991 776991 110360 110360 PubChem (substance) 2 266775 266775 6
776994 776994 110360 110360 PubChem (substance) 2 226902 226902 7
776995 776995 110360 110360 PubChem (substance) 2 243132 243132 8
776996 776996 110360 110360 PubChem (substance) 2 265389 265389 10
776997 776997 110360 110360 PubChem (substance) 2 176822 176822 11
1031918 1031918 110360 110360 CAS Common Chemistry 3 12457 12457 1
1234816 1234816 110360 110360 Computational Toxicology and Exposure Data 4 12457 12457 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)
);