home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 89778

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
10298 10298 89778 89778 PubChem (compound) 1 55047 55047 1
305597 305597 89778 89778 PubChem (substance) 2 74054 74054 9
308075 308075 89778 89778 PubChem (substance) 2 75990 75990 7
309845 309845 89778 89778 PubChem (substance) 2 73282 73282 5
310182 310182 89778 89778 PubChem (substance) 2 55047 55047 1
369622 369622 89778 89778 PubChem (substance) 2 41152 41152 2
764925 764925 89778 89778 PubChem (substance) 2 169582 169582 3
764926 764926 89778 89778 PubChem (substance) 2 169700 169700 4
764927 764927 89778 89778 PubChem (substance) 2 313956 313956 6
764928 764928 89778 89778 PubChem (substance) 2 169619 169619 8
764929 764929 89778 89778 PubChem (substance) 2 169611 169611 10
764930 764930 89778 89778 PubChem (substance) 2 218431 218431 11
764931 764931 89778 89778 PubChem (substance) 2 221536 221536 12
764932 764932 89778 89778 PubChem (substance) 2 190182 190182 13
764933 764933 89778 89778 PubChem (substance) 2 220124 220124 14
764934 764934 89778 89778 PubChem (substance) 2 226502 226502 15
764935 764935 89778 89778 PubChem (substance) 2 234519 234519 16
764936 764936 89778 89778 PubChem (substance) 2 258817 258817 17
764937 764937 89778 89778 PubChem (substance) 2 169715 169715 18
764938 764938 89778 89778 PubChem (substance) 2 258818 258818 19
945783 945783 89778 89778 CAS Common Chemistry 3 55047 55047 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)
);
Powered by Datasette · Queries took 1496.629ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website