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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
180246 180246 160996 160996 PubChem (compound) 1 21737 21737 1
180248 180248 160996 160996 PubChem (compound) 1 163336 163336 2
180249 180249 160996 160996 PubChem (compound) 1 195021 195021 3
180250 180250 160996 160996 PubChem (compound) 1 139330 139330 4
180251 180251 160996 160996 PubChem (compound) 1 169290 169290 5
180252 180252 160996 160996 PubChem (compound) 1 284751 284751 6
180253 180253 160996 160996 PubChem (compound) 1 309221 309221 7
180254 180254 160996 160996 PubChem (compound) 1 310273 310273 8
180255 180255 160996 160996 PubChem (compound) 1 326344 326344 9
545111 545111 160996 160996 PubChem (substance) 2 21737 21737 1
545113 545113 160996 160996 PubChem (substance) 2 163336 163336 2
545115 545115 160996 160996 PubChem (substance) 2 195021 195021 3
545118 545118 160996 160996 PubChem (substance) 2 139330 139330 5
545120 545120 160996 160996 PubChem (substance) 2 169290 169290 4
545122 545122 160996 160996 PubChem (substance) 2 284751 284751 6
545123 545123 160996 160996 PubChem (substance) 2 309221 309221 8
545124 545124 160996 160996 PubChem (substance) 2 310273 310273 7
545126 545126 160996 160996 PubChem (substance) 2 326344 326344 9
1070543 1070543 160996 160996 CAS Common Chemistry 3 21737 21737 1
1271939 1271939 160996 160996 Computational Toxicology and Exposure Data 4 21737 21737 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 419.83ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website