[ensembl-dev] slice_adapter as MySQL procedure?

[Reece Hart]

Hi-

I'd like to be able to extract genomic sequences within MySQL itself,
something like (roll dream music):

CREATE VIEW variant_context AS
SELECT chr, start, stop, seq,
  fetch_by_region('chromosome',chr,start-25,start-1) AS left_flank,
  fetch_by_region('chromosome',chr,end+1,end+25) AS right_flank
FROM variants;

Anyone ever tried to write the analog of the slice_adapter as a MySQL
procedure?

Thanks,
Reece
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20120116/04e9a501/attachment.html>