api_results

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

12 rows where query_id = 218598

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
230505 230505 218598 218598 PubChem (compound) 1 216858 216858 1
230506 230506 218598 218598 PubChem (compound) 1 147118 147118 2
230508 230508 218598 218598 PubChem (compound) 1 235353 235353 3
230509 230509 218598 218598 PubChem (compound) 1 332767 332767 4
609156 609156 218598 218598 PubChem (substance) 2 216858 216858 1
609160 609160 218598 218598 PubChem (substance) 2 147118 147118 2
609161 609161 218598 218598 PubChem (substance) 2 235353 235353 4
609163 609163 218598 218598 PubChem (substance) 2 332767 332767 5
836991 836991 218598 218598 PubChem (substance) 2 234986 234986 3
836992 836992 218598 218598 PubChem (substance) 2 86902 86902 6
836993 836993 218598 218598 PubChem (substance) 2 323266 323266 7
1103685 1103685 218598 218598 CAS Common Chemistry 3 86902 86902 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)
);