Extract the high value column from a big file

[archana87]

Hi,

As I am new in this field. I am trying to get the best score with larger start length from below file. Here, the file header is like Chromosome location, score, and start length. I want top start length w.r.t its score and other details.

chr9:136028339-136029648-|NM_021996|GBGT1 5.629998 1303 TGCTCAAGTACACTCATTTCA
chr9:136028339-136029648-|NM_021996|GBGT1 5.629998 1304 GCTCAAGTACACTCATTTCAT
chr9:136028339-136029648-|NM_021996|GBGT1 13.2 1301 TGTGCTCAAGTACACTCATTT
chr9:136028339-136029648-|NM_021996|GBGT1 10.8 1302 GTGCTCAAGTACACTCATTTC
chr12:54735989-54739299+|NM_016057|COPZ1 5.629998 216 GAGCCAGATGCTGAGTACTAT
chr12:54735989-54739299+|NM_016057|COPZ1 10.8 217 AGCCAGATGCTGAGTACTATG
chr16:21868579-21893272-|None|None 6.0 473 TTTAATGAGTATTCTGGATTG
chr16:21868579-21893272-|None|None 6.0 5880 TTGATCCTCCCTTAACCTATC
chr16:21868579-21893272-|None|None 6.0 5923 CTTCCTATTCCTCCAGCATAC
chr16:21868579-21893272-|None|None 6.0 6463 TGAAGTCATCTATCTGGTTTG

I want the output like this
chr9:136028339-136029648-|NM_021996|GBGT1 13.2 1301 TGTGCTCAAGTACACTCATTT
chr9:136028339-136029648-|NM_021996|GBGT1 10.8 1302 GTGCTCAAGTACACTCATTTC
chr12:54735989-54739299+|NM_016057|COPZ1 5.629998 216 GAGCCAGATGCTGAGTACTAT
chr12:54735989-54739299+|NM_016057|COPZ1 10.8 217
chr16:21868579-21893272-|None|None 6.0 5923 CTTCCTATTCCTCCAGCATAC
chr16:21868579-21893272-|None|None 6.0 6463 TGAAGTCATCTATCTGGTTTG


Any help is much appreciated.


Thanks

[archana87]

Got it

Yahoo, I figure it out..... Anyway, any other way if we can do it then also fine...

My Answer is sort -k1,1 -k3,3nr -k2,2n infile.txt | sort -u -k1,2 --merge