api_results

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

13 rows where query_id = 376779

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
270271 270271 376779 376779 PubChem (compound) 1 11077 11077 1
303925 303925 376779 376779 PubChem (substance) 2 7027 7027 9
660135 660135 376779 376779 PubChem (substance) 2 11077 11077 1
920344 920344 376779 376779 PubChem (substance) 2 140127 140127 2
920345 920345 376779 376779 PubChem (substance) 2 224911 224911 3
920346 920346 376779 376779 PubChem (substance) 2 185647 185647 4
920347 920347 376779 376779 PubChem (substance) 2 140128 140128 5
920348 920348 376779 376779 PubChem (substance) 2 11077 11077 6
920349 920349 376779 376779 PubChem (substance) 2 185647 185647 7
920350 920350 376779 376779 PubChem (substance) 2 266842 266842 8
920351 920351 376779 376779 PubChem (substance) 2 185952 185952 10
1118210 1118210 376779 376779 CAS Common Chemistry 3 11077 11077 1
1329961 1329961 376779 376779 Computational Toxicology and Exposure Data 4 11077 11077 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)
);