api_results

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

12 rows where query_id = 108590

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102550 102550 108590 108590 PubChem (compound) 1 4491 4491 1
127842 127842 108590 108590 PubChem (compound) 1 317245 317245 2
440825 440825 108590 108590 PubChem (substance) 2 4491 4491 1
440827 440827 108590 108590 PubChem (substance) 2 4491 4491 2
440829 440829 108590 108590 PubChem (substance) 2 4491 4491 3
475956 475956 108590 108590 PubChem (substance) 2 317245 317245 7
752611 752611 108590 108590 PubChem (substance) 2 317974 317974 5
752613 752613 108590 108590 PubChem (substance) 2 317974 317974 8
752615 752615 108590 108590 PubChem (substance) 2 313930 313930 4
752618 752618 108590 108590 PubChem (substance) 2 313930 313930 9
775311 775311 108590 108590 PubChem (substance) 2 247424 247424 6
1013655 1013655 108590 108590 CAS Common Chemistry 3 4491 4491 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)
);