api_results

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

12 rows where query_id = 30914

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
64829 64829 30914 30914 PubChem (compound) 1 11054 11054 1
388089 388089 30914 30914 PubChem (substance) 2 11054 11054 1
388099 388099 30914 30914 PubChem (substance) 2 170642 170642 6
468527 468527 30914 30914 PubChem (substance) 2 139177 139177 2
468533 468533 30914 30914 PubChem (substance) 2 186692 186692 5
731228 731228 30914 30914 PubChem (substance) 2 139177 139177 3
731234 731234 30914 30914 PubChem (substance) 2 332369 332369 4
731235 731235 30914 30914 PubChem (substance) 2 185154 185154 7
731241 731241 30914 30914 PubChem (substance) 2 310039 310039 8
731243 731243 30914 30914 PubChem (substance) 2 11054 11054 9
985908 985908 30914 30914 CAS Common Chemistry 3 11054 11054 1
1188852 1188852 30914 30914 Computational Toxicology and Exposure Data 4 11054 11054 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)
);