home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 348897

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
31371 31371 348897 348897 PubChem (compound) 1 4032 4032 1
303742 303742 348897 348897 PubChem (substance) 2 3505 3505 8
305566 305566 348897 348897 PubChem (substance) 2 2054 2054 5
305770 305770 348897 348897 PubChem (substance) 2 60355 60355 13
305891 305891 348897 348897 PubChem (substance) 2 3513 3513 9
309347 309347 348897 348897 PubChem (substance) 2 3690 3690 3
310177 310177 348897 348897 PubChem (substance) 2 2666 2666 7
310205 310205 348897 348897 PubChem (substance) 2 3721 3721 6
340037 340037 348897 348897 PubChem (substance) 2 3734 3734 4
340169 340169 348897 348897 PubChem (substance) 2 4032 4032 1
758528 758528 348897 348897 PubChem (substance) 2 154760 154760 2
758529 758529 348897 348897 PubChem (substance) 2 265173 265173 10
758532 758532 348897 348897 PubChem (substance) 2 265881 265881 11
758533 758533 348897 348897 PubChem (substance) 2 292846 292846 12
758536 758536 348897 348897 PubChem (substance) 2 274232 274232 14
758540 758540 348897 348897 PubChem (substance) 2 271544 271544 15
758543 758543 348897 348897 PubChem (substance) 2 227159 227159 16
758545 758545 348897 348897 PubChem (substance) 2 330487 330487 17
758546 758546 348897 348897 PubChem (substance) 2 250947 250947 18
758549 758549 348897 348897 PubChem (substance) 2 333241 333241 19
758551 758551 348897 348897 PubChem (substance) 2 219333 219333 20
961259 961259 348897 348897 CAS Common Chemistry 3 4032 4032 1
1162191 1162191 348897 348897 Computational Toxicology and Exposure Data 4 4032 4032 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 865.04ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website