home / zeropm-v0-0-4

api_results

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

31 rows where query_id = 104423

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124387 124387 104423 104423 PubChem (compound) 1 206036 206036 1
124393 124393 104423 104423 PubChem (compound) 1 206036 206036 2
124395 124395 104423 104423 PubChem (compound) 1 205828 205828 3
124399 124399 104423 104423 PubChem (compound) 1 243505 243505 4
124400 124400 104423 104423 PubChem (compound) 1 320281 320281 5
124401 124401 104423 104423 PubChem (compound) 1 262203 262203 6
124402 124402 104423 104423 PubChem (compound) 1 294783 294783 7
124403 124403 104423 104423 PubChem (compound) 1 326289 326289 8
124404 124404 104423 104423 PubChem (compound) 1 294783 294783 9
124405 124405 104423 104423 PubChem (compound) 1 320281 320281 10
124406 124406 104423 104423 PubChem (compound) 1 333409 333409 11
303710 303710 104423 104423 PubChem (substance) 2 55059 55059 14
471134 471134 104423 104423 PubChem (substance) 2 206036 206036 1
471142 471142 104423 104423 PubChem (substance) 2 206036 206036 2
471147 471147 104423 104423 PubChem (substance) 2 205828 205828 4
471150 471150 104423 104423 PubChem (substance) 2 243505 243505 16
471152 471152 104423 104423 PubChem (substance) 2 320281 320281 3
471153 471153 104423 104423 PubChem (substance) 2 262203 262203 10
471154 471154 104423 104423 PubChem (substance) 2 294783 294783 11
471156 471156 104423 104423 PubChem (substance) 2 326289 326289 17
471157 471157 104423 104423 PubChem (substance) 2 294783 294783 18
471158 471158 104423 104423 PubChem (substance) 2 320281 320281 19
471160 471160 104423 104423 PubChem (substance) 2 333409 333409 20
770823 770823 104423 104423 PubChem (substance) 2 260169 260169 5
770824 770824 104423 104423 PubChem (substance) 2 243505 243505 6
770825 770825 104423 104423 PubChem (substance) 2 320516 320516 7
770827 770827 104423 104423 PubChem (substance) 2 297629 297629 8
770829 770829 104423 104423 PubChem (substance) 2 274390 274390 9
770832 770832 104423 104423 PubChem (substance) 2 297916 297916 12
770833 770833 104423 104423 PubChem (substance) 2 284708 284708 13
770835 770835 104423 104423 PubChem (substance) 2 308426 308426 15
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 1812.945ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website