home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 61927

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102148 102148 61927 61927 PubChem (compound) 1 189149 189149 1
102149 102149 61927 61927 PubChem (compound) 1 241343 241343 2
102150 102150 61927 61927 PubChem (compound) 1 307821 307821 3
102151 102151 61927 61927 PubChem (compound) 1 320718 320718 4
102152 102152 61927 61927 PubChem (compound) 1 340495 340495 5
102153 102153 61927 61927 PubChem (compound) 1 343793 343793 6
440283 440283 61927 61927 PubChem (substance) 2 189149 189149 1
440291 440291 61927 61927 PubChem (substance) 2 241343 241343 2
440297 440297 61927 61927 PubChem (substance) 2 307821 307821 8
440298 440298 61927 61927 PubChem (substance) 2 320718 320718 9
440299 440299 61927 61927 PubChem (substance) 2 340495 340495 11
440300 440300 61927 61927 PubChem (substance) 2 343793 343793 12
496216 496216 61927 61927 PubChem (substance) 2 137366 137366 6
496224 496224 61927 61927 PubChem (substance) 2 241344 241344 5
752031 752031 61927 61927 PubChem (substance) 2 181644 181644 3
752034 752034 61927 61927 PubChem (substance) 2 239071 239071 4
752035 752035 61927 61927 PubChem (substance) 2 261961 261961 7
752039 752039 61927 61927 PubChem (substance) 2 174223 174223 10
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 1263.13ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website