Dear All
I was wondering if someone of you know how to resolve an issue that I met.
In particular I have a file like this:
What I would like to obtain is a file like this, in which for each replicates ID (column 1), I would like to report only those with the biggest lenght(and the relative coordinates)
I hope that my explanation was clear.
Hi, it is not clear to me what you are looking for and also, how do you get from the input file that you specified to for example ENSMUSG00000000003 and chrX ?
Hi
I am so sorry!!! I was in a hurry before and I did not check my message.
So my input file is like that:
And my desired output should be like that:
What I am looking for is for each ID (first column) calculate the difference between the column 3 and 4 and keep only the lane in which the difference is bigger.
Thank you again and if you have further question do not hesitate to post a reply!
Giuliano
---------- Post updated at 03:06 PM ---------- Previous update was at 03:03 PM ----------
Hi
I am so sorry!!! I was in a hurry before and I did not check my message.
So my input file is like that:
And my desired output should be like that:
What I am looking for is for each ID (first column) calculate the difference between the column 3 and 4 and keep only the lane in which the difference is bigger.
Thank you again and if you have further question do not hesitate to post a reply!
Giuliano
Last edited by Scrutinizer; 07-02-2014 at 01:23 PM..
Reason: CODE tags
If field 4 is always going to be greater than field 3 then you can shorten it a bit by not bothering to calculate the absolute value. Also, it's not guaranteed to preserve the ordering of the records in the file.
Dear All,
I was wondering if you may help me with an issue.
I would like to merge row based on column 1.
input file:
b1 ggg b2 fff NA NA hhh NA NA NA NA NA
a1 xxx a2 yyy NA NA zzz NA NA NA NA NA
a1 xxx NA NA a3 ttt NA ggg NA NA NA NA
output file:
b1 ggg b2 fff NA NA hhh NA NA NA NA NA... (5 Replies)
Hi All
I need to find the smallest values between replicates id (column1)
Input file:
a name1 1200
a name2 800
b name1 100
b name2 150
b name3 4output:
a name2 800
b name3 4
Do you have any suggestion?
Thank you! (9 Replies)
Hi All
I hope that someone could help me!
I have an input file like this, with 4 colum(ID, feature1, start, end):
a x 1 5
b x 3 10
b x 4 9
b x 5 16
c x 5 9
c x 4 8
And my output file should be like this:
a x 1 5
b x 3 16
c x 4 9
What I would like to do is to output for each ID... (2 Replies)
Hi,
I wanna find the biggest number inside of a file
this is kind of example of file:
9
11
55
then i just wanna print out the biggest number
i had try sed filenale | sort -k1,1n | paste -s -d',' -
but i had no success ... (7 Replies)
Hi,
I need help to find values between two different fields based on $6 (NUM) AND $1 (CD), within the same ID. The result should show the values between the NUMs which will be extracted from within $3 and $2 in data.txt file below.
data.txt
ex 139 142 Sc_1000004 ID 4
CD ... (2 Replies)
Hi All,
Please help me out
1) Command to find the disk usage in GB. I know that du -k will give in kilobites.
2) How to find the Biggest file/folder in a given set of files/folders.
Thanks in advance
Regards,
Manas (8 Replies)