api_results

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

8 rows where query_id = 295939

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
136147 136147 295939 295939 PubChem (compound) 1 57228 57228 1
474887 474887 295939 295939 PubChem (substance) 2 91292 91292 3
487043 487043 295939 295939 PubChem (substance) 2 57228 57228 1
845333 845333 295939 295939 PubChem (substance) 2 222000 222000 2
845334 845334 295939 295939 PubChem (substance) 2 204721 204721 4
845335 845335 295939 295939 PubChem (substance) 2 322675 322675 5
1037197 1037197 295939 295939 CAS Common Chemistry 3 57228 57228 1
1240174 1240174 295939 295939 Computational Toxicology and Exposure Data 4 57228 57228 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)
);