Print row if value in column 1 is the first occurence Post: 302175998

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to print column based on row number

Hi, I want to print column value based on row number say multiple of 8. Input file: line 1 67 34 line 2 45 57 . . . . . . line 8 12 46 . . . . . . line 16 24 90 . . . . . . line 24 49 67 Output 46 90 67

2. Shell Programming and Scripting

AWK Script - Print a column - within a Row Range

Hi, Please read the whole thread. I have been working on this script below. It works fine, feel free to copy and test with the INPUT File below as well. example: PACKET DATA PROTOCOL CONTEXT DATA APNID PDPADD EQOSID VPAA PDPCH PDPTY PDPID 10 ...

3. Shell Programming and Scripting

Print the row element till the next row element appear in a column

Hi all I have file with columns F3 pathway CPS F2 H2 H4 H5 H6 no pathway CMP H7 H8 H9 H10 My expected output is F3 pathway CPS F2 pathway CPS

4. Shell Programming and Scripting

Print unique names in each row of a specific column using awk

Is it possible to remove redundant names in the 4th column? input cqWE 100 200 singapore;singapore AZO 300 400 brazil;america;germany;ireland;germany .... .... output cqWE 100 200 singapore AZO 300 400 brazil;america;germany;ireland

5. UNIX for Dummies Questions & Answers

awk to print first row with forth column and last row with fifth column in each file

file with this content awk 'NR==1 {print $4} && NR==2 {print $5}' file The error is shown with syntax error; what can be done

6. Shell Programming and Scripting

Print every 5 4th column values as separate row with different first column

Hi, I have the following file, chr1 100 200 20 chr1 201 300 22 chr1 220 345 23 chr1 230 456 33.5 chr1 243 567 90 chr1 345 600 20 chr1 430 619 21.78 chr1 870 910 112.3 chr1 914 920 12 chr1 930 999 13 My output would be peak1 20 22 23 33.5 90 peak2 20 21.78 112.3 12 13 Here the...

7. Shell Programming and Scripting

Print row on 4th column to all row

Dear All, I have input : SEG901 5173 9005 5740 SEG902 5227 5284 SEG903 5284 5346 SEG904 5346 9010 SEG905 5400 5456 SEG906 5456 5511 SEG907 5511 9011 SEG908 5572 9015 SEG909 5622 9020 SEG910 5678 5739 SEG911 5739 5796 SEG912 5796 9025 ...

8. Shell Programming and Scripting

Print first row of column a, last row of column b if column a has the same value

I have a table with this structure: cola colb colc 1 19 lemon 20 31 lemon 32 100 lemon 159 205 cherries 210 500 cherries and need to parse it into this format: cola colb colc 1 100 lemon 159 500 cherries So I need the first row of cola and the last row of colb if colc has the...

9. Shell Programming and Scripting

Print every alternate column in row in a text file

Hi, I have a comma separated file. I would like to print every alternate columns into a new row. Example input file: Name : John, Age : 30, DOB : 30-Oct-2018 Example output: Name,Age,DOB John,30,30-Oct-2018

10. UNIX for Beginners Questions & Answers

Print a row with the max number in a column

Hello, I have this table: chr1_16857_17742 - chr1 17369 17436 "ENST00000619216.1"; "MIR6859-1"; - 67 chr1_16857_17742 - chr1 14404 29570 "ENST00000488147.1"; "WASH7P"; - 885 chr1_16857_18061 - chr1 ...

LEARN ABOUT DEBIAN

vcf-annotate

VCF-ANNOTATE(1) 						   User Commands						   VCF-ANNOTATE(1)

NAME

       vcf-annotate - annotate VCF file, add filters or custom annotations

SYNOPSIS

       cat in.vcf | vcf-annotate [OPTIONS] > out.vcf

DESCRIPTION

       About: Annotates VCF file, adding filters or custom annotations. Requires tabix indexed file with annotations.

	      Currently annotates only the INFO column, but it will be extended on demand.

OPTIONS

       -a, --annotations <file.gz>
	      The tabix indexed file with the annotations: CHR	FROM[	TO][	VALUE]+.

       -c, --columns <list>
	      The list of columns in the annotation file, e.g. CHROM,FROM,TO,-,INFO/STR,INFO/GN. The dash in this example indicates that the third
	      column should be ignored. If TO is not present, it is assumed that TO equals to FROM.

       -d, --description <file|string>
	      Header annotation, e.g. key=INFO,ID=HM2,Number=0,Type=Flag,Description='HapMap2 membership'.  The descriptions can be  read  from  a
	      file, one annotation per line.

       -f, --filter <list>
	      Apply filters, list is in the format flt1=value/flt2/flt3=value/etc.

       -h, -?, --help
	      This help message.

   Filters:
       +      Apply all filters with default values (can be overridden, see the example below).

       -X     Exclude the filter X

       1, StrandBias
	      FLOAT		       Min P-value for strand bias (given PV4) [0.0001]

       2, BaseQualBias
	      FLOAT		     Min P-value for baseQ bias [1e-100]

       3, MapQualBias
	      FLOAT		      Min P-value for mapQ bias [0]

       4, EndDistBias
	      FLOAT		      Min P-value for end distance bias [0.0001]

       a, MinAB
	      INT			    Minimum number of alternate bases [2]

       c, SnpCluster
	      INT1,INT2 	       Filters clusters of 'INT1' or more SNPs within a run of 'INT2' bases []

       D, MaxDP
	      INT			    Maximum read depth [10000000]

       d, MinDP
	      INT			    Minimum read depth [2]

       q, MinMQ
	      INT			    Minimum RMS mapping quality for SNPs [10]

       Q, Qual
	      INT			     Minimum value of the QUAL field [10]

       r, RefN
	      Reference base is N []

       W, GapWin
	      INT			   Window size for filtering adjacent gaps [10]

       w, SnpGap
	      INT			   SNP within INT bp around a gap to be filtered [10]

   Example:
	      zcat  in.vcf.gz  |  vcf-annotate	-a  annotations.gz  -d	descriptions.txt  |  bgzip -c >out.vcf.gz zcat in.vcf.gz | vcf-annotate -f
	      +/-a/c=3,10/q=3/d=5/-D -a annotations.gz -d descriptions.txt | bgzip -c >out.vcf.gz

   Where descriptions.txt contains:
	      key=INFO,ID=GN,Number=1,Type=String,Description='Gene Name' key=INFO,ID=STR,Number=1,Type=Integer,Description='Strand'

vcf-annotate 0.1.5						     July 2011							   VCF-ANNOTATE(1)