[ensembl-dev] loading VEP output into db

[Will McLaren]

Hi Nikolas,

As I mentioned in reply to your previous question, you can use --tab with
VEP 84 or later, or in earlier versions use --fields to have all output
written to separate tab-separated columns.

The limitation of using --fields is that you must specify them manually,
but you could do this once and save it to a configuration file [1] or as an
ENV variable. You then have the benefit of knowing which columns you would
need to create in your DB.

Another option would be to use VCF output and a simple shell script to
create one line per transcript.

Regards

Will

[1] :
http://www.ensembl.org/info/docs/tools/vep/script/vep_options.html#opt_config



On 27 July 2016 at 12:24, Nikolas Pontikos <n.pontikos at ucl.ac.uk> wrote:

> I'm looking for an easy way (with minimal reformatting) of loading the
> output of VEP into a database.
>
> So far I have tried loading the JSON output straight into mongo but
> was wondering if there was a simpler tab separated format with one
> transcript per line.
>
> Maybe I should resort to only retrieving the most severe transcript
> consequence per variant.
>
> I'd be happy to hear your suggestion.
>
> Many Thanks,
>
> Nikolas.
>
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> Posting guidelines and subscribe/unsubscribe info:
> http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20160727/8c29919c/attachment.html>