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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124388 124388 318597 318597 PubChem (compound) 1 206036 206036 2
124397 124397 318597 318597 PubChem (compound) 1 205828 205828 1
260588 260588 318597 318597 PubChem (compound) 1 204458 204458 5
260589 260589 318597 318597 PubChem (compound) 1 254040 254040 3
260590 260590 318597 318597 PubChem (compound) 1 201341 201341 4
260591 260591 318597 318597 PubChem (compound) 1 240944 240944 6
260592 260592 318597 318597 PubChem (compound) 1 281480 281480 7
471136 471136 318597 318597 PubChem (substance) 2 206036 206036 2
471144 471144 318597 318597 PubChem (substance) 2 206036 206036 11
471148 471148 318597 318597 PubChem (substance) 2 205828 205828 1
645646 645646 318597 318597 PubChem (substance) 2 204458 204458 5
645648 645648 318597 318597 PubChem (substance) 2 254040 254040 3
645650 645650 318597 318597 PubChem (substance) 2 201341 201341 4
645651 645651 318597 318597 PubChem (substance) 2 240944 240944 9
645652 645652 318597 318597 PubChem (substance) 2 281480 281480 10
848308 848308 318597 318597 PubChem (substance) 2 249896 249896 8
848310 848310 318597 318597 PubChem (substance) 2 266437 266437 14
848313 848313 318597 318597 PubChem (substance) 2 193600 193600 6
848314 848314 318597 318597 PubChem (substance) 2 246944 246944 7
848315 848315 318597 318597 PubChem (substance) 2 292162 292162 12
848316 848316 318597 318597 PubChem (substance) 2 284709 284709 13
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 435.059ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website