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 = 111352

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
97633 97633 111352 111352 PubChem (compound) 1 35626 35626 1
433682 433682 111352 111352 PubChem (substance) 2 137789 137789 3
433706 433706 111352 111352 PubChem (substance) 2 35626 35626 1
474127 474127 111352 111352 PubChem (substance) 2 84309 84309 2
501330 501330 111352 111352 PubChem (substance) 2 22737 22737 16
748376 748376 111352 111352 PubChem (substance) 2 35626 35626 4
748378 748378 111352 111352 PubChem (substance) 2 231060 231060 15
748382 748382 111352 111352 PubChem (substance) 2 196147 196147 14
771325 771325 111352 111352 PubChem (substance) 2 232094 232094 11
774346 774346 111352 111352 PubChem (substance) 2 232123 232123 12
777932 777932 111352 111352 PubChem (substance) 2 232010 232010 5
777934 777934 111352 111352 PubChem (substance) 2 232022 232022 6
777935 777935 111352 111352 PubChem (substance) 2 232053 232053 7
777937 777937 111352 111352 PubChem (substance) 2 200112 200112 8
777941 777941 111352 111352 PubChem (substance) 2 232082 232082 9
777946 777946 111352 111352 PubChem (substance) 2 232084 232084 10
777947 777947 111352 111352 PubChem (substance) 2 232162 232162 13
1010343 1010343 111352 111352 CAS Common Chemistry 3 35626 35626 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 834.649ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website