api_results

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

15 rows where query_id = 387880

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
276800 276800 387880 387880 PubChem (compound) 1 28261 28261 1
668269 668269 387880 387880 PubChem (substance) 2 28261 28261 1
918741 918741 387880 387880 PubChem (substance) 2 163939 163939 2
925915 925915 387880 387880 PubChem (substance) 2 240509 240509 3
925916 925916 387880 387880 PubChem (substance) 2 217325 217325 4
925917 925917 387880 387880 PubChem (substance) 2 239636 239636 5
925918 925918 387880 387880 PubChem (substance) 2 247744 247744 6
925919 925919 387880 387880 PubChem (substance) 2 234271 234271 7
925920 925920 387880 387880 PubChem (substance) 2 200161 200161 8
925921 925921 387880 387880 PubChem (substance) 2 257720 257720 9
925922 925922 387880 387880 PubChem (substance) 2 284798 284798 10
925923 925923 387880 387880 PubChem (substance) 2 215612 215612 11
925924 925924 387880 387880 PubChem (substance) 2 309972 309972 12
1121763 1121763 387880 387880 CAS Common Chemistry 3 28261 28261 1
1235892 1235892 387880 387880 Computational Toxicology and Exposure Data 4 28261 28261 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)
);