api_results

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

14 rows where query_id = 113735

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
133081 133081 113735 113735 PubChem (compound) 1 47117 47117 1
482967 482967 113735 113735 PubChem (substance) 2 47117 47117 1
643897 643897 113735 113735 PubChem (substance) 2 243290 243290 6
780259 780259 113735 113735 PubChem (substance) 2 186853 186853 2
780260 780260 113735 113735 PubChem (substance) 2 239076 239076 3
780262 780262 113735 113735 PubChem (substance) 2 289270 289270 4
780264 780264 113735 113735 PubChem (substance) 2 243371 243371 5
780265 780265 113735 113735 PubChem (substance) 2 189195 189195 7
780267 780267 113735 113735 PubChem (substance) 2 147180 147180 8
780269 780269 113735 113735 PubChem (substance) 2 200243 200243 9
780271 780271 113735 113735 PubChem (substance) 2 309954 309954 10
780273 780273 113735 113735 PubChem (substance) 2 282450 282450 11
1034804 1034804 113735 113735 CAS Common Chemistry 3 47117 47117 1
1237775 1237775 113735 113735 Computational Toxicology and Exposure Data 4 47117 47117 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)
);