api_results

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

15 rows where query_id = 12152

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
23888 23888 12152 12152 PubChem (compound) 1 78292 78292 1
329911 329911 12152 12152 PubChem (substance) 2 78292 78292 1
329916 329916 12152 12152 PubChem (substance) 2 106269 106269 2
709427 709427 12152 12152 PubChem (substance) 2 239235 239235 3
709428 709428 12152 12152 PubChem (substance) 2 173372 173372 4
709429 709429 12152 12152 PubChem (substance) 2 206945 206945 5
709430 709430 12152 12152 PubChem (substance) 2 197331 197331 6
709431 709431 12152 12152 PubChem (substance) 2 260140 260140 7
709433 709433 12152 12152 PubChem (substance) 2 169084 169084 8
709435 709435 12152 12152 PubChem (substance) 2 308102 308102 9
709437 709437 12152 12152 PubChem (substance) 2 320921 320921 10
709438 709438 12152 12152 PubChem (substance) 2 324634 324634 11
709440 709440 12152 12152 PubChem (substance) 2 326415 326415 12
955754 955754 12152 12152 CAS Common Chemistry 3 78292 78292 1
1155734 1155734 12152 12152 Computational Toxicology and Exposure Data 4 78292 78292 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)
);