api_results

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

15 rows where query_id = 105174

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
125168 125168 105174 105174 PubChem (compound) 1 248709 248709 1
472366 472366 105174 105174 PubChem (substance) 2 248709 248709 1
476906 476906 105174 105174 PubChem (substance) 2 248616 248616 3
767808 767808 105174 105174 PubChem (substance) 2 326116 326116 4
772696 772696 105174 105174 PubChem (substance) 2 249086 249086 2
772697 772697 105174 105174 PubChem (substance) 2 248709 248709 5
772699 772699 105174 105174 PubChem (substance) 2 308325 308325 6
772701 772701 105174 105174 PubChem (substance) 2 284923 284923 7
772704 772704 105174 105174 PubChem (substance) 2 248958 248958 8
772705 772705 105174 105174 PubChem (substance) 2 275192 275192 9
772707 772707 105174 105174 PubChem (substance) 2 320872 320872 10
772710 772710 105174 105174 PubChem (substance) 2 264400 264400 11
772711 772711 105174 105174 PubChem (substance) 2 248709 248709 12
1028832 1028832 105174 105174 CAS Common Chemistry 3 60368 60368 1
1231668 1231668 105174 105174 Computational Toxicology and Exposure Data 4 60368 60368 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)
);