Here there are four tab-separated columns. The first column is the used algorithm for prediction, and there are 4 of them A-D. The second column are the predicted targets (which actually are genes), x and y. The third and fourth column indicate the start and the end of the predicted site in the sequence of the genes.
I'd need to unique the entries in column 2, based on the common range in the columns 3 and 4, something like this:
Here, for example, at the first line we have algorithms A, B and C which predict the gene x, and the predicted positions all fall into the same site, i.e. the position 70-80 for algorithm B and 75-85 for algorithm C are both located inside the same predicted position by algorithm A, which is 65-85; and the last column indicates how many algorithms predicted this position. On the contrary, the predicted site by algorithm D for the entry x does not coincide with the others, so is presented in a separate line. The results for the entry y are explained in the same way.
Hope this is clear.
Thank you in advanced
Last edited by flyfisherman; 01-25-2014 at 02:42 PM..
I'd need to uniq the entries in column 2 based on the number range in columns 3 and 4, plus indicating how many and which algorithms resulted the prediction, something like this:
Thank you in advanced
Your description is not clear to me. Please explain how do you expect above blue color highlighted result. Please explain your algorithm.
Thank you Yoda for your time. Actually I edited my first post, since it was said not to be clear. In the input file I have four columns, with four headers, and in the output there is one more column, so five columns, and all are tab-delimited. Could you please modify your script based on this? Thanks
Thank you Yoda for your time. Actually I edited my first post, since it was said not to be clear. In the input file I have four columns, with four headers, and in the output there is one more column, so five columns, and all are tab-delimited. Could you please modify your script based on this? Thanks
Add your headers in BEGIN block edit print statement, try to learn ... after providing 99.99% of code.. if you can't edit small header information means, what I can tell. Please don't expect others to complete your task.. put little effort.
This User Gave Thanks to Akshay Hegde For This Post:
I have some files named file1, file2, fille3......etc. These files are in a folder f1. The content of files are shown below. I would like to count the unique pairs of third column in each file. some files have no data. It should be printed as zero. Your help would be appreciated.
file1
ARG... (1 Reply)
Hi all,
I wanted to save the values of a file that contains unique entries based on a specific column (column 4). my sample file looks like the following:
input file: 200006-07file.txt
145 35 10 3
147 35 12 4
146 36 11 3
145 34 12 5
143 31 15 4
146 30 14 5
desired output files:... (5 Replies)
I want to create entries based on the series as in examples below:
Input:
2dat3 grht-5&&-15
3dat3 grht-16&&-30
4dat3 ftht-4&&-12
5sat3 ftht-16&&-20
Output:
2dat3 grht-5
2dat3 grht-6
2dat3 grht-7
2dat3 grht-8 (7 Replies)
I am trying to extract specific information from a large *.sam file (it's originally 28Gb).
I want to extract all lines that are on chr3 somewhere in the range of 112,937,439-113,437,438.
Here is a sample line from my file so you can get a feel for what each line looks like:
seq.4 0 ... (8 Replies)
Hi, I have a small piece of awk code (see below) that generates random numbers.
gawk -F"," 'BEGIN { srand(); for (i = 1; i <= 30; i++) printf("%s AM329_%04d\n",$0,int(36 * rand())+1) }' OFS=, AM329_hole_names.csv
The code works fine and generates alphanumeric numbers like AM329_0001,... (2 Replies)
Hi,
I am going to fetch a list of numbers that starts with "0032" from a file with a format like the given below:
"
0032459999 0032458888 0032457777
0032451111 0032452222 0032453333
0032459999 0032458888 0032457777
0032451111 0032452222 0032453333
"
I want to get a unique... (6 Replies)
Howdy experts,
We have some ranges of number which belongs to particual group as below.
GroupNo StartRange EndRange
Group0125 935300 935399
Group2006 935400 935476
937430 937459
Group0324 935477 935549
... (6 Replies)