How to extract all columns of CSQ using  split-vep plugin of bcftools?
        1
    
    
    
        
        
        
        
            
                
                
                    
                        
                    
                
                    
                        I have a vcf file containing CSQ column which has 350 parameters. How can extract all of them as table using bcftools +split-vep
                    
                
                 
                
                
                    
                    
    
        
        
            plugin
        
        
    
        
        
            samtools
        
        
    
        
        
            bcftools
        
        
    
        
        
            vcf
        
        
    
        
        
            split-vep
        
        
    
    
        • 6.0k views
    
                
                
                
                
    
    • 
link
    
    
    
    
    
    
        
    
        updated 3.1 years ago by
        
            amy__
        
        
    
        ▴
    
    250
        •
    
        written 4.6 years ago by
        
            DareDevil
        
        
    
        ★
    
    4.4k
    
 
            
            
         
     
 
     
    
        
            
                
    
    
    
    
        
        
        
        
            
                
                
                    
                        
                    
                
                    
                        bcftools +split-vep -f '%CHROM\t%POS\t%REF\t%ALT\t%CSQ\n' -d -A tab input.vcf
And if you need headers:
echo -e "CHROM\tPOS\tREF\tALT\t$(bcftools +split-vep -l input.vcf | cut -f 2 | tr '\n' '\t' | sed 's/\t$//')" > output.tsv
bcftools +split-vep -f '%CHROM\t%POS\t%REF\t%ALT\t%CSQ\n' -d -A tab input.vcf >> output.tsv
                    
                
                 
                
                
                
                
                
             
            
            
         
     
 
         
        
    
    
        
            
                Login before adding your answer.
         
    
    
         
        
is this plugin able to convert vcf to a tabular format ?
Ya it does. here