api_results

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

14 rows where inchi_id = 52760

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
54813 54813 24771 24771 PubChem (compound) 1 52760 52760 1
54814 54814 24772 24772 PubChem (compound) 1 52760 52760 1
54815 54815 139183 139183 PubChem (compound) 1 52760 52760 1
54816 54816 58023 58023 PubChem (compound) 1 52760 52760 1
373184 373184 21469 21469 PubChem (substance) 2 52760 52760 9
373185 373185 24771 24771 PubChem (substance) 2 52760 52760 1
373186 373186 12888 12888 PubChem (substance) 2 52760 52760 3
373187 373187 58023 58023 PubChem (substance) 2 52760 52760 1
373188 373188 24772 24772 PubChem (substance) 2 52760 52760 1
373189 373189 323901 323901 PubChem (substance) 2 52760 52760 47135
373190 373190 139183 139183 PubChem (substance) 2 52760 52760 1
373191 373191 376753 376753 PubChem (substance) 2 52760 52760 2
978248 978248 24771 24771 CAS Common Chemistry 3 52760 52760 1
978249 978249 139183 139183 CAS Common Chemistry 3 52760 52760 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)
);