home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 123191

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
496314 496314 123191 123191 PubChem (substance) 2 181645 181645 1
787526 787526 123191 123191 PubChem (substance) 2 253719 253719 2
787528 787528 123191 123191 PubChem (substance) 2 267560 267560 3
787530 787530 123191 123191 PubChem (substance) 2 298071 298071 4
787532 787532 123191 123191 PubChem (substance) 2 295288 295288 5
787534 787534 123191 123191 PubChem (substance) 2 216811 216811 6
787536 787536 123191 123191 PubChem (substance) 2 266061 266061 7
787537 787537 123191 123191 PubChem (substance) 2 234941 234941 8
787538 787538 123191 123191 PubChem (substance) 2 224772 224772 9
787539 787539 123191 123191 PubChem (substance) 2 288207 288207 10
787541 787541 123191 123191 PubChem (substance) 2 292785 292785 11
787542 787542 123191 123191 PubChem (substance) 2 270858 270858 12
787544 787544 123191 123191 PubChem (substance) 2 296206 296206 13
787546 787546 123191 123191 PubChem (substance) 2 297691 297691 14
787548 787548 123191 123191 PubChem (substance) 2 297699 297699 15
787550 787550 123191 123191 PubChem (substance) 2 307946 307946 16
787553 787553 123191 123191 PubChem (substance) 2 308671 308671 17
787554 787554 123191 123191 PubChem (substance) 2 215564 215564 18
787555 787555 123191 123191 PubChem (substance) 2 343703 343703 19
787556 787556 123191 123191 PubChem (substance) 2 330464 330464 20
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 474.575ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website