api_results

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

14 rows where query_id = 365280

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22011 22011 365280 365280 PubChem (compound) 1 56071 56071 1
327222 327222 365280 365280 PubChem (substance) 2 56071 56071 1
347154 347154 365280 365280 PubChem (substance) 2 34121 34121 2
355237 355237 365280 365280 PubChem (substance) 2 66787 66787 7
479145 479145 365280 365280 PubChem (substance) 2 34120 34120 6
708098 708098 365280 365280 PubChem (substance) 2 56071 56071 3
910870 910870 365280 365280 PubChem (substance) 2 206057 206057 4
910872 910872 365280 365280 PubChem (substance) 2 172506 172506 5
910874 910874 365280 365280 PubChem (substance) 2 148613 148613 8
910876 910876 365280 365280 PubChem (substance) 2 188332 188332 9
954437 954437 365280 365280 CAS Common Chemistry 3 56071 56071 2
964406 964406 365280 365280 CAS Common Chemistry 3 34121 34121 1
1154063 1154063 365280 365280 Computational Toxicology and Exposure Data 4 56071 56071 2
1166000 1166000 365280 365280 Computational Toxicology and Exposure Data 4 94314 94314 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)
);