sql to vcf
Hi all I'm trying to convert sql data containing headers such as 'CHROM' 'POS' 'REF' 'ALT' 'Zygosity' to the variant call format (vcf) file. Can anybody help me? My operating system is windows 10.
database
sql
vcf
• 3,728 views
•
link
updated
by
swanthana.r •
•
written
by
fmail1221 •
0 answers
No answers yet.
Log in to answer this question.
More posts like this
-
Combine VCF files
written by Sowmya Pulapet •Hi, I have 3 vcf files and I want to merge these in the following format: #CHROM POS REF ALT-1 ALT-2 ALT-3 I used the …
-
VEP annotated VCF conversion into TSV/Text
written by Nai •VEP annotated VCF has CHROM, POS, REF, ALT , INFO, FORMAT : genotype. I would like to convert this VCF as tab delimited file where …
-
VCF deletions incorrectly formatted
written by john.michel.rouhana •Hi all, I'm working with a vcf (v4.1) that has incorrectly formatted deletions for some reason. The insertions are fine, but the deletions are annotated …
-
Merge multiple VCF files (same variants, same sample) into one VCF file
written by Eleanore •Dear all, I have a problem at hand regarding the manipulation of multiple VCF files (containing the same variants and referred to the same sample) …
-
Weird translated refs between hg19 and hg38
written by andrewl •I'm possibly doing something wrong but having problems converting from hg19 to hg38, where my reference call is changed (which changes the user call). I …
-
How to add DS genotype in vcf file.
written by ApprenticeHi. I always appreciate all your help. I have one vcf file (a.vcf). "a.vcf" >CHROM POS ID REF ALT QUAL FILTER INFO FORMAT sample1 sample2 …
-
How to seperate vcf annoation info field
written by raya.girish •Hello Friends I have created vcf file for my samples using GATK. After variant calling i used snpEff for annotation. Now my vcf annotation files …
-
Preparing a appropriate VCF in order to support my Implementation
written by gaurav.singh •I have section called Variant Call Data section, When User views the Variant Call Data section,Then those values should be extracted from the called variant …
-
HGVS to VCF conversion
written by luisantome •hi everyone, I have a very large data set of genomic variants in hgvs format and I want to convert it into vcf format. I've …
-
Question About Vcf4.1 File
written by Mathew Bunj •I have a VCF version 4.1 which has ``` CHROM POS ID REF ALT QUAL FILTER INFO FORMAT Normal Tumor 1 11049 . G . …
what is the database engine ? what is the structure of the table ? what is 'Zygosity' ? How To Ask Good Questions On Technical And Scientific Forums
Hello fmail1221 ,
and what is your problem? Have a look at the specification on how a
vcfmust look like and extract the data from your database to make a validvcf.fin swimmer
Hello finswimmer, I want a converter to convert my data from sql server to the vcf file.
Did you get the vcf file format from database. I am trying to get output vcf file from psql database.
Or Are there any tools to convert tab delimited file to vcf file. I have a file with CHROM, POS, REF and ALT, can we use any tool to convert it into vcf file. Let me know. Thank you.
bcftools query
Pierre, Thanks for quick reply.
bcftools query can extract tab delimited file from vcf/bcf format right, but I need a vcf file from tab delimited file. I found the below lines from bcftools document page.
bcftools query [OPTIONS] file.vcf.gz [file.vcf.gz […]] Extracts fields from VCF or BCF files and outputs them in user-defined format.