Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Partially match and rank question

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Partially match and rank question
# 1  
Old 09-25-2014
Partially match and rank question
Hi I am processing some files but have difficulty to deal with this one, hope someone can help me,Thank you in advance.
I have a file 1 like this
file 1:
Code:
aa|M30369.1| mfe: -15.1 kc
b|BX930090.1| mfe: -10.2 kc
GOOD mfe: -20.3 kc
BAD3.2 mfe: -25.4 kc

I also have a file 2 like this
file2:
Code:
GOOD
BAD3
BX930090

In file 1, each line has a value after "mfe:" and each line of file 2 is part of a line in file 1. I want to add the corresponding mfe value on file 2 and rank the lines of file 2 by ascending order based on the mfe value in file 1. So the output file 3 should be like this
file 3:
Code:
BAD3 (-25.4)
GOOD (-20.3)
BX930090 (-10.2)

So how can I achieve this and get file 3?
# 2  
Old 09-25-2014
Try (untested):
Code:
awk 'NR==FNR{T[$1];next}{for (i in T) if ($0 ~ i) T[i]+=$(NF-1)} END {for (i in T) print i, T[i]}' file2 file1| sort -k2n

If you absolutely need the parentheses in the output, add them in the print statement, and give sort a non-default field separator.
This User Gave Thanks to RudiC For This Post:
yuejian
# 3  
Old 09-25-2014
NOt very structured data, but what the hey! Middle file could be reworked into a shell case statement as a dynamic psart of a parent script. Using shell 'while read a b c' command, the three fields can be loaded into three variables, the first applied to the dynamic case statement that prints the desired output with the third.
Code:
#!/bin/bash
 
zcase="case \$a in
$( while read x
do
 echo "(*$x*)
  echo $x \$c
  ;;"
done <$1 )
esac"
 
while read a b c
do
 $zcase
done

Assumes file1 on stdin, file 2 on command line and file 3 output is stdout.
This User Gave Thanks to DGPickett For This Post:
yuejian
# 4  
Old 09-25-2014
I STRONGLY suggest that you choose filenames that do not contain spaces; it will make your life much easier.

This is similar to RudiC's suggestion, but assumes the contents of "file 2" are expected to be fixed strings instead of extended regular expressions, assumes that you only want to search for those strings in the 1st field in "file 1", and includes the requested parentheses:
Code:
awk '
FNR == NR {
        key[$1]
        next
}
{       for(k in key)
                if(index($1, k)) 
                        key[k] += $(NF - 1)
}
END {   for(k in key)
                printf("%s (%.1f)\n", k, key[k])
}' "file 2" "file 1" | sort -t'(' -k2,2n > "file 3"

If you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk, /usr/xpg6/bin/awk, or nawk.

For future reference, please always tell us what OS and shell you're using so we can limit our suggestions to things that will work in your environment.
# 5  
Old 09-25-2014
Hi RudiC, I tried with my own file1 and file2, and the output file3 doesn't follow the mfe value order. Here is my own files.
file1:
Code:
target: gi|45383869|ref|NM_204120.1| mfe: -30.0 kcal/mol p-value: 0.001811
target: gi|570932798|gb|KF680103.1| mfe: -24.4 kcal/mol p-value: 0.008454
target: gi|570932796|gb|KF680102.1| mfe: -24.4 kcal/mol p-value: 0.008454
target: gi|590121592|dbj|AB697062.1| mfe: -30.0 kcal/mol p-value: 0.000548
target: gi|590121590|dbj|AB697061.1| mfe: -30.0 kcal/mol p-value: 0.000548
target: gi|590121588|dbj|AB697060.1| mfe: -30.0 kcal/mol p-value: 0.000548
target: gi|590121586|dbj|AB697059.1| mfe: -30.0 kcal/mol p-value: 0.000548
target: gi|402745170|ref|NM_205109.2| mfe: -26.0 kcal/mol p-value: 0.004788
target: gi|402744747|ref|NM_205183.2| mfe: -28.7 kcal/mol p-value: 0.004291
target: gi|402693060|ref|NM_204203.2| mfe: -24.4 kcal/mol p-value: 0.008390
target: gi|402692104|ref|NM_204845.2| mfe: -26.4 kcal/mol p-value: 0.005345
target: gi|291084675|ref|NM_001173529.1| mfe: -26.8 kcal/mol p-value: 0.007815
target: gi|291084668|ref|NM_205437.2| mfe: -26.8 kcal/mol p-value: 0.009239
target: gi|71895138|ref|NM_001030827.1| mfe: -25.5 kcal/mol p-value: 0.008902
target: gi|57525241|ref|NM_001006203.1| mfe: -26.9 kcal/mol p-value: 0.003875
target: gi|46048872|ref|NM_204849.1| mfe: -26.7 kcal/mol p-value: 0.002828
target: gi|148762955|ref|NM_205345.2| mfe: -28.6 kcal/mol p-value: 0.005229
target: gi|71896528|ref|NM_001030951.1| mfe: -26.4 kcal/mol p-value: 0.009078
target: gi|46048893|ref|NM_204743.1| mfe: -28.5 kcal/mol p-value: 0.001510
target: gi|45384515|ref|NM_204994.1| mfe: -28.1 kcal/mol p-value: 0.004339
target: gi|45384445|ref|NM_205337.1| mfe: -23.9 kcal/mol p-value: 0.009195
target: gi|45382732|ref|NM_205483.1| mfe: -25.6 kcal/mol p-value: 0.004427
target: gi|557643588|gb|KF469210.1| mfe: -25.1 kcal/mol p-value: 0.008243
target: gi|557643586|gb|KF469209.1| mfe: -25.1 kcal/mol p-value: 0.009291
target: gi|557643584|gb|KF469208.1| mfe: -25.1 kcal/mol p-value: 0.004148
target: gi|480540337|ref|NM_001277787.1| mfe: -24.9 kcal/mol p-value: 0.009106
target: gi|190360720|ref|NM_001128496.1| mfe: -24.4 kcal/mol p-value: 0.008454
target: gi|485050385|ref|NM_001277933.1| mfe: -25.6 kcal/mol p-value: 0.008370
target: gi|483968056|ref|NM_001277902.1| mfe: -24.8 kcal/mol p-value: 0.008909
target: gi|478694652|ref|NM_001277705.1| mfe: -27.0 kcal/mol p-value: 0.000652
target: gi|478621158|ref|NM_001277631.1| mfe: -28.0 kcal/mol p-value: 0.001994
target: gi|478621156|ref|NM_001277630.1| mfe: -28.0 kcal/mol p-value: 0.002504
target: gi|478621067|ref|NM_001277647.1| mfe: -28.4 kcal/mol p-value: 0.001164
target: gi|478431098|ref|NM_001277611.1| mfe: -26.2 kcal/mol p-value: 0.004310
target: gi|460838683|ref|NM_001277148.1| mfe: -24.4 kcal/mol p-value: 0.006406
target: gi|460838679|ref|NM_001277146.1| mfe: -24.4 kcal/mol p-value: 0.007060
target: gi|402746516|ref|NM_001012607.2| mfe: -27.8 kcal/mol p-value: 0.008246
target: gi|402692237|ref|NM_204113.2| mfe: -29.0 kcal/mol p-value: 0.002658
target: gi|160333802|ref|NM_001110438.1| mfe: -28.9 kcal/mol p-value: 0.001219
target: gi|121583179|ref|NM_001080107.1| mfe: -27.4 kcal/mol p-value: 0.009051
target: gi|113206121|ref|NM_001044666.1| mfe: -24.6 kcal/mol p-value: 0.005646
target: gi|71897086|ref|NM_001030709.1| mfe: -27.8 kcal/mol p-value: 0.005547
target: gi|71895606|ref|NM_001030560.1| mfe: -29.1 kcal/mol p-value: 0.004913
target: gi|61098345|ref|NM_001012905.1| mfe: -28.7 kcal/mol p-value: 0.008370
target: gi|57530480|ref|NM_001006318.1| mfe: -26.5 kcal/mol p-value: 0.009197
target: gi|52138710|ref|NM_001004407.1| mfe: -25.5 kcal/mol p-value: 0.008791
target: gi|46048755|ref|NM_205182.1| mfe: -27.2 kcal/mol p-value: 0.004099
target: gi|45382776|ref|NM_204669.1| mfe: -31.5 kcal/mol p-value: 0.002260
target: gi|45382428|ref|NM_204885.1| mfe: -29.6 kcal/mol p-value: 0.003266
target: gi|480306419|ref|NM_001277752.1| mfe: -27.2 kcal/mol p-value: 0.004295
target: gi|513241404|ref|XM_429054.3| mfe: -24.7 kcal/mol p-value: 0.009680
target: gi|513240645|ref|XM_004950971.1| mfe: -29.3 kcal/mol p-value: 0.000514
target: gi|513239873|ref|XM_003643841.2| mfe: -25.2 kcal/mol p-value: 0.003898
target: gi|513239730|ref|XM_004950788.1| mfe: -26.7 kcal/mol p-value: 0.003352
target: gi|513239081|ref|XM_004950688.1| mfe: -27.2 kcal/mol p-value: 0.006431
target: gi|513238788|ref|XM_003643687.2| mfe: -26.1 kcal/mol p-value: 0.000941
target: gi|513238786|ref|XM_423494.4| mfe: -26.1 kcal/mol p-value: 0.000787
target: gi|513238755|ref|XM_004950639.1| mfe: -26.1 kcal/mol p-value: 0.004756
target: gi|513238752|ref|XM_003643680.2| mfe: -26.1 kcal/mol p-value: 0.002188
target: gi|513238522|ref|XM_424249.2| mfe: -25.7 kcal/mol p-value: 0.008905
target: gi|513238519|ref|XM_004950606.1| mfe: -25.7 kcal/mol p-value: 0.007986
target: gi|513238515|ref|XM_004950605.1| mfe: -25.7 kcal/mol p-value: 0.008123
target: gi|513238489|ref|XM_003643647.2| mfe: -26.1 kcal/mol p-value: 0.004640
target: gi|513238487|ref|XM_003643646.2| mfe: -26.1 kcal/mol p-value: 0.000610
target: gi|513238471|ref|XM_004950598.1| mfe: -22.8 kcal/mol p-value: 0.005856
target: gi|513238226|ref|XM_003643614.2| mfe: -23.1 kcal/mol p-value: 0.008745
target: gi|513238114|ref|XM_004950540.1| mfe: -25.4 kcal/mol p-value: 0.006513
target: gi|513237494|ref|XM_001232980.3| mfe: -25.7 kcal/mol p-value: 0.007410
target: gi|513237393|ref|XM_004950389.1| mfe: -24.5 kcal/mol p-value: 0.004742
target: gi|513237341|ref|XM_003643521.2| mfe: -22.8 kcal/mol p-value: 0.005192
target: gi|513237072|ref|XM_003643490.2| mfe: -25.4 kcal/mol p-value: 0.004627
target: gi|513236997|ref|XM_427278.3| mfe: -24.7 kcal/mol p-value: 0.009262
target: gi|513236991|ref|XM_003643480.2| mfe: -25.7 kcal/mol p-value: 0.005437
target: gi|513236675|ref|XM_003643440.2| mfe: -26.1 kcal/mol p-value: 0.000760
target: gi|513236082|ref|XM_427246.4| mfe: -23.5 kcal/mol p-value: 0.009797
target: gi|513236043|ref|XM_003643367.2| mfe: -27.9 kcal/mol p-value: 0.003545
target: gi|513235610|ref|XM_003643306.2| mfe: -25.4 kcal/mol p-value: 0.004524
target: gi|513235497|ref|XM_004950062.1| mfe: -25.3 kcal/mol p-value: 0.002353
target: gi|513234949|ref|XM_003643227.2| mfe: -28.0 kcal/mol p-value: 0.004163
target: gi|513234424|ref|XM_004949870.1| mfe: -30.0 kcal/mol p-value: 0.000659
target: gi|513234421|ref|XM_004949869.1| mfe: -30.0 kcal/mol p-value: 0.000558
target: gi|513234418|ref|XM_004949868.1| mfe: -30.0 kcal/mol p-value: 0.000666
target: gi|513234414|ref|XM_004949867.1| mfe: -30.0 kcal/mol p-value: 0.000641
target: gi|513234411|ref|XM_003643166.2| mfe: -30.0 kcal/mol p-value: 0.000592
target: gi|513234351|ref|XM_004949852.1| mfe: -24.2 kcal/mol p-value: 0.004549
target: gi|513234215|ref|XM_423964.4| mfe: -25.0 kcal/mol p-value: 0.005110
target: gi|513234212|ref|XM_004949823.1| mfe: -25.0 kcal/mol p-value: 0.005902
target: gi|513234209|ref|XM_004949822.1| mfe: -25.0 kcal/mol p-value: 0.007141
target: gi|513233722|ref|XM_003643128.2| mfe: -25.3 kcal/mol p-value: 0.007766
target: gi|513233562|ref|XM_424273.4| mfe: -26.5 kcal/mol p-value: 0.007322
target: gi|513232936|ref|XM_003643097.2| mfe: -25.0 kcal/mol p-value: 0.007292
target: gi|513232284|ref|XM_004949486.1| mfe: -28.1 kcal/mol p-value: 0.006954
target: gi|513232275|ref|XM_004949483.1| mfe: -28.1 kcal/mol p-value: 0.008525
target: gi|513232263|ref|XM_004949479.1| mfe: -28.1 kcal/mol p-value: 0.005807
target: gi|513230813|ref|XM_004949176.1| mfe: -28.3 kcal/mol p-value: 0.009203
target: gi|513229161|ref|XM_004937237.1| mfe: -29.4 kcal/mol p-value: 0.003383
target: gi|513229158|ref|XM_423833.4| mfe: -29.4 kcal/mol p-value: 0.003354
target: gi|513227499|ref|XM_003642878.2| mfe: -28.9 kcal/mol p-value: 0.003247
target: gi|513227496|ref|XM_004948884.1| mfe: -28.9 kcal/mol p-value: 0.003606
target: gi|513227493|ref|XM_004948883.1| mfe: -28.9 kcal/mol p-value: 0.003735
target: gi|513227490|ref|XM_004948882.1| mfe: -28.9 kcal/mol p-value: 0.004229
target: gi|513227487|ref|XM_004948881.1| mfe: -28.9 kcal/mol p-value: 0.004328
target: gi|513227484|ref|XM_004948880.1| mfe: -28.9 kcal/mol p-value: 0.004359
target: gi|513226778|ref|XM_001234814.3| mfe: -26.3 kcal/mol p-value: 0.006223
target: gi|513226724|ref|XM_004948715.1| mfe: -23.0 kcal/mol p-value: 0.009730
target: gi|513226376|ref|XM_004948639.1| mfe: -29.8 kcal/mol p-value: 0.009746
target: gi|513226373|ref|XM_004948638.1| mfe: -29.8 kcal/mol p-value: 0.009996
target: gi|513226071|ref|XM_004948579.1| mfe: -27.9 kcal/mol p-value: 0.008319
target: gi|513224912|ref|XM_417996.4| mfe: -28.3 kcal/mol p-value: 0.009502
target: gi|513223580|ref|XM_004948315.1| mfe: -25.0 kcal/mol p-value: 0.005544
target: gi|513223573|ref|XM_004948313.1| mfe: -25.0 kcal/mol p-value: 0.008329
target: gi|513223570|ref|XM_004948312.1| mfe: -25.0 kcal/mol p-value: 0.009627
target: gi|513223245|ref|XM_004948233.1| mfe: -27.5 kcal/mol p-value: 0.000845
target: gi|513223226|ref|XM_428214.4| mfe: -25.1 kcal/mol p-value: 0.002669
target: gi|513223223|ref|XM_004948230.1| mfe: -25.6 kcal/mol p-value: 0.006173
target: gi|513223221|ref|XM_003642635.2| mfe: -24.4 kcal/mol p-value: 0.005525
target: gi|513223219|ref|XM_003642634.2| mfe: -25.6 kcal/mol p-value: 0.001659
target: gi|513223217|ref|XM_428211.4| mfe: -25.6 kcal/mol p-value: 0.001875
target: gi|513223210|ref|XM_004948229.1| mfe: -25.6 kcal/mol p-value: 0.001697
target: gi|513222624|ref|XM_423721.4| mfe: -27.1 kcal/mol p-value: 0.009449
target: gi|513222252|ref|XM_001233176.2| mfe: -28.3 kcal/mol p-value: 0.004261
target: gi|513222250|ref|XM_004948041.1| mfe: -28.3 kcal/mol p-value: 0.002623
target: gi|513222233|ref|XM_001232466.3| mfe: -26.9 kcal/mol p-value: 0.006700
target: gi|513222212|ref|XM_004948028.1| mfe: -29.2 kcal/mol p-value: 0.004139
target: gi|513222210|ref|XM_004948027.1| mfe: -29.2 kcal/mol p-value: 0.003578
target: gi|513222209|ref|XM_417891.2| mfe: -29.2 kcal/mol p-value: 0.003738
target: gi|513222207|ref|XM_004948026.1| mfe: -29.2 kcal/mol p-value: 0.003801
target: gi|513222205|ref|XM_004948025.1| mfe: -29.2 kcal/mol p-value: 0.003561
target: gi|513222203|ref|XM_004948024.1| mfe: -29.2 kcal/mol p-value: 0.003620
target: gi|513221564|ref|XM_001233528.3| mfe: -27.5 kcal/mol p-value: 0.002621
target: gi|513219036|ref|XM_004947275.1| mfe: -24.3 kcal/mol p-value: 0.000199
target: gi|513218783|ref|XM_004947224.1| mfe: -28.4 kcal/mol p-value: 0.003841
target: gi|513218778|ref|XM_001232075.3| mfe: -28.4 kcal/mol p-value: 0.009681
target: gi|513218520|ref|XM_004947174.1| mfe: -29.4 kcal/mol p-value: 0.008220
target: gi|513218517|ref|XM_417455.4| mfe: -29.4 kcal/mol p-value: 0.009115
target: gi|513217790|ref|XM_425698.4| mfe: -28.3 kcal/mol p-value: 0.009706
target: gi|513215186|ref|XM_415724.4| mfe: -28.0 kcal/mol p-value: 0.003286
target: gi|513214415|ref|XM_004946350.1| mfe: -26.4 kcal/mol p-value: 0.006608
target: gi|513214409|ref|XM_004946348.1| mfe: -26.4 kcal/mol p-value: 0.008076
target: gi|513214406|ref|XM_004946347.1| mfe: -26.4 kcal/mol p-value: 0.008119
target: gi|513214400|ref|XM_004946345.1| mfe: -26.4 kcal/mol p-value: 0.009812
target: gi|513214376|ref|XM_004946338.1| mfe: -28.3 kcal/mol p-value: 0.005530
target: gi|513213414|ref|XM_004946111.1| mfe: -26.9 kcal/mol p-value: 0.007970
target: gi|513213413|ref|XM_003642337.2| mfe: -26.9 kcal/mol p-value: 0.009219
target: gi|513212199|ref|XM_423028.4| mfe: -28.1 kcal/mol p-value: 0.003122
target: gi|513212053|ref|XM_415532.4| mfe: -30.0 kcal/mol p-value: 0.002493
target: gi|513212050|ref|XM_004945789.1| mfe: -30.0 kcal/mol p-value: 0.002489
target: gi|513210150|ref|XM_004945574.1| mfe: -28.6 kcal/mol p-value: 0.008828
target: gi|513210147|ref|XM_004945573.1| mfe: -28.6 kcal/mol p-value: 0.009959
target: gi|513207477|ref|XM_425217.3| mfe: -29.8 kcal/mol p-value: 0.008913
target: gi|513207240|ref|XM_004944985.1| mfe: -26.1 kcal/mol p-value: 0.006846
target: gi|513202479|ref|XM_004944014.1| mfe: -29.8 kcal/mol p-value: 0.004335
target: gi|513202477|ref|XM_003641881.2| mfe: -29.8 kcal/mol p-value: 0.004445
target: gi|513202474|ref|XM_004944013.1| mfe: -29.8 kcal/mol p-value: 0.005455
target: gi|513202471|ref|XM_001231664.3| mfe: -29.8 kcal/mol p-value: 0.005574
target: gi|513202436|ref|XM_003641836.2| mfe: -29.7 kcal/mol p-value: 0.003966
target: gi|513198656|ref|XM_430177.4| mfe: -31.7 kcal/mol p-value: 0.003070
target: gi|513197907|ref|XM_004936766.1| mfe: -28.3 kcal/mol p-value: 0.008805
target: gi|513197904|ref|XM_004936765.1| mfe: -28.3 kcal/mol p-value: 0.008514
target: gi|513196660|ref|XM_001234669.3| mfe: -31.2 kcal/mol p-value: 0.001467
target: gi|513196654|ref|XM_004943270.1| mfe: -31.2 kcal/mol p-value: 0.001559
target: gi|513196570|ref|XM_004943256.1| mfe: -28.5 kcal/mol p-value: 0.001079
target: gi|513196568|ref|XM_422273.4| mfe: -28.5 kcal/mol p-value: 0.001604
target: gi|513194455|ref|XM_422027.4| mfe: -28.3 kcal/mol p-value: 0.002179
target: gi|513194016|ref|XM_428765.4| mfe: -29.0 kcal/mol p-value: 0.007855
target: gi|513192417|ref|XM_004942361.1| mfe: -29.8 kcal/mol p-value: 0.006758
target: gi|513190043|ref|XM_004936512.1| mfe: -26.8 kcal/mol p-value: 0.006106
target: gi|513189002|ref|XM_426443.4| mfe: -30.0 kcal/mol p-value: 0.003137
target: gi|513188144|ref|XM_004941764.1| mfe: -26.2 kcal/mol p-value: 0.003459
target: gi|513186337|ref|XM_004941391.1| mfe: -28.8 kcal/mol p-value: 0.008303
target: gi|513185810|ref|XM_001232606.3| mfe: -30.4 kcal/mol p-value: 0.005535
target: gi|513185329|ref|XM_001235044.3| mfe: -26.3 kcal/mol p-value: 0.004423
target: gi|513185311|ref|XM_004936255.1| mfe: -26.3 kcal/mol p-value: 0.004004
target: gi|513185308|ref|XM_004936254.1| mfe: -26.3 kcal/mol p-value: 0.008873
target: gi|513185297|ref|XM_003641231.2| mfe: -26.3 kcal/mol p-value: 0.003949
target: gi|513185275|ref|XM_420863.4| mfe: -26.3 kcal/mol p-value: 0.006932
target: gi|513183547|ref|XM_004941228.1| mfe: -28.8 kcal/mol p-value: 0.006088
target: gi|513183544|ref|XM_004941227.1| mfe: -28.8 kcal/mol p-value: 0.007645
target: gi|513183541|ref|XM_004941226.1| mfe: -28.8 kcal/mol p-value: 0.005523
target: gi|513183538|ref|XM_420627.4| mfe: -28.8 kcal/mol p-value: 0.005679
target: gi|513183535|ref|XM_004941225.1| mfe: -28.8 kcal/mol p-value: 0.005945
target: gi|513183189|ref|XM_001233306.3| mfe: -25.9 kcal/mol p-value: 0.005052
target: gi|513183186|ref|XM_004941154.1| mfe: -25.9 kcal/mol p-value: 0.005467
target: gi|513182610|ref|XM_420496.4| mfe: -29.4 kcal/mol p-value: 0.000568
target: gi|513181510|ref|XM_001234387.3| mfe: -25.1 kcal/mol p-value: 0.008682
target: gi|513179695|ref|XM_004935916.1| mfe: -29.3 kcal/mol p-value: 0.002958
target: gi|513179690|ref|XM_420052.4| mfe: -29.3 kcal/mol p-value: 0.002963
target: gi|513178837|ref|XM_004940516.1| mfe: -26.4 kcal/mol p-value: 0.003437
target: gi|513178834|ref|XM_004940515.1| mfe: -26.4 kcal/mol p-value: 0.005854
target: gi|513178832|ref|XM_001234708.3| mfe: -26.4 kcal/mol p-value: 0.003281
target: gi|513178830|ref|XM_419936.3| mfe: -26.4 kcal/mol p-value: 0.007530
target: gi|513178826|ref|XM_004940514.1| mfe: -26.4 kcal/mol p-value: 0.005529
target: gi|513178757|ref|XM_004940496.1| mfe: -27.3 kcal/mol p-value: 0.005913
target: gi|513178181|ref|XM_004940406.1| mfe: -26.8 kcal/mol p-value: 0.001945
target: gi|513178178|ref|XM_004940405.1| mfe: -26.8 kcal/mol p-value: 0.006868
target: gi|513178175|ref|XM_004940404.1| mfe: -26.8 kcal/mol p-value: 0.007645
target: gi|513178173|ref|XM_419857.4| mfe: -26.8 kcal/mol p-value: 0.007694
target: gi|513177628|ref|XM_004940301.1| mfe: -28.1 kcal/mol p-value: 0.009185
target: gi|513177626|ref|XM_419782.3| mfe: -28.1 kcal/mol p-value: 0.008968
target: gi|513177541|ref|XM_004940291.1| mfe: -29.3 kcal/mol p-value: 0.004630
target: gi|513176384|ref|XM_004935605.1| mfe: -30.2 kcal/mol p-value: 0.004069
target: gi|513176382|ref|XM_419661.4| mfe: -30.2 kcal/mol p-value: 0.004374
target: gi|513176379|ref|XM_004935604.1| mfe: -30.2 kcal/mol p-value: 0.005623
target: gi|513176376|ref|XM_004935603.1| mfe: -30.2 kcal/mol p-value: 0.007338
target: gi|513176373|ref|XM_004935602.1| mfe: -30.2 kcal/mol p-value: 0.008925
target: gi|513175404|ref|XM_419506.4| mfe: -30.2 kcal/mol p-value: 0.008634
target: gi|513175401|ref|XM_004935406.1| mfe: -30.2 kcal/mol p-value: 0.006311
target: gi|513175398|ref|XM_004935405.1| mfe: -30.2 kcal/mol p-value: 0.006351
target: gi|513175395|ref|XM_004935404.1| mfe: -30.2 kcal/mol p-value: 0.006650
target: gi|513175392|ref|XM_004935403.1| mfe: -30.2 kcal/mol p-value: 0.008946
target: gi|513175194|ref|XM_003640976.2| mfe: -27.1 kcal/mol p-value: 0.005718
target: gi|513175186|ref|XM_003640975.2| mfe: -27.1 kcal/mol p-value: 0.006910
target: gi|513173857|ref|XM_004940095.1| mfe: -26.1 kcal/mol p-value: 0.001732
target: gi|513172787|ref|XM_004939970.1| mfe: -26.0 kcal/mol p-value: 0.005276
target: gi|513169726|ref|XM_004939540.1| mfe: -29.5 kcal/mol p-value: 0.004568
target: gi|513169723|ref|XM_004939539.1| mfe: -29.5 kcal/mol p-value: 0.004307
target: gi|513169720|ref|XM_418843.4| mfe: -29.5 kcal/mol p-value: 0.004615
target: gi|513169625|ref|XM_004939521.1| mfe: -25.7 kcal/mol p-value: 0.009465
target: gi|513169222|ref|XM_418776.4| mfe: -29.3 kcal/mol p-value: 0.002158
target: gi|513166540|ref|XM_003640572.2| mfe: -29.0 kcal/mol p-value: 0.006142
target: gi|513166105|ref|XM_003640566.2| mfe: -29.5 kcal/mol p-value: 0.008974
target: gi|513166038|ref|XM_004938830.1| mfe: -32.8 kcal/mol p-value: 0.000413
target: gi|513166035|ref|XM_004938829.1| mfe: -32.8 kcal/mol p-value: 0.000504
target: gi|513165413|ref|XM_004938712.1| mfe: -27.4 kcal/mol p-value: 0.009734
target: gi|513165281|ref|XM_004938689.1| mfe: -30.5 kcal/mol p-value: 0.002038
target: gi|513165275|ref|XM_004938687.1| mfe: -30.5 kcal/mol p-value: 0.001775
target: gi|513165272|ref|XM_425626.4| mfe: -30.5 kcal/mol p-value: 0.002039
target: gi|513165269|ref|XM_004938686.1| mfe: -30.5 kcal/mol p-value: 0.002218
target: gi|513164015|ref|XM_004938455.1| mfe: -28.5 kcal/mol p-value: 0.002443
target: gi|513164013|ref|XM_425578.4| mfe: -28.5 kcal/mol p-value: 0.006620
target: gi|513164009|ref|XM_004938454.1| mfe: -28.5 kcal/mol p-value: 0.009690
target: gi|513162203|ref|XM_416655.4| mfe: -30.3 kcal/mol p-value: 0.007745
target: gi|513162194|ref|XM_004938318.1| mfe: -30.3 kcal/mol p-value: 0.006264
target: gi|513161854|ref|XM_416608.4| mfe: -29.0 kcal/mol p-value: 0.002566
target: gi|513161184|ref|XM_425520.4| mfe: -27.8 kcal/mol p-value: 0.004038
target: gi|513160956|ref|XM_004938085.1| mfe: -26.1 kcal/mol p-value: 0.004089
target: gi|513160668|ref|XM_004938036.1| mfe: -25.0 kcal/mol p-value: 0.009120
target: gi|513160662|ref|XM_004938034.1| mfe: -25.0 kcal/mol p-value: 0.009457
target: gi|513159234|ref|XM_004937739.1| mfe: -21.9 kcal/mol p-value: 0.009285
target: gi|363746676|ref|XM_003643709.1| mfe: -27.4 kcal/mol p-value: 0.003012
target: gi|363742720|ref|XM_428210.2| mfe: -24.4 kcal/mol p-value: 0.004002
target: gi|363742712|ref|XM_003642632.1| mfe: -25.6 kcal/mol p-value: 0.001413
target: gi|118105441|ref|XM_423880.2| mfe: -25.6 kcal/mol p-value: 0.001413
target: gi|485050393|ref|NM_001277935.1| mfe: -25.6 kcal/mol p-value: 0.006614
target: gi|480354938|ref|NM_001277763.1| mfe: -26.1 kcal/mol p-value: 0.001274
target: gi|480354930|ref|NM_001277759.1| mfe: -26.1 kcal/mol p-value: 0.002380
target: gi|480354932|ref|NM_001277760.1| mfe: -26.1 kcal/mol p-value: 0.000355
target: gi|478621069|ref|NM_001277650.1| mfe: -28.4 kcal/mol p-value: 0.000959
target: gi|221325661|ref|NM_001144848.1| mfe: -28.9 kcal/mol p-value: 0.001551
target: gi|422035858|gb|JX843734.1| mfe: -25.7 kcal/mol p-value: 0.005552
target: gi|459352826|gb|KC249966.1| mfe: -25.0 kcal/mol p-value: 0.005971
target: gi|413966203|gb|JX673910.1| mfe: -27.4 kcal/mol p-value: 0.002490
target: gi|305379595|gb|HM590226.1| mfe: -24.9 kcal/mol p-value: 0.002661
target: gi|381140387|gb|JQ280467.1| mfe: -22.1 kcal/mol p-value: 0.007203
target: gi|2970114|gb|U62254.1|GGU62254 mfe: -18.5 kcal/mol p-value: 0.003543
target: gi|1389970|gb|U59709.1|GGU59709 mfe: -27.5 kcal/mol p-value: 0.003186
target: gi|531174|gb|M23405.1|CHKEATPA mfe: -20.9 kcal/mol p-value: 0.006735
target: gi|304414|gb|L20627.1|CHKPROKINF mfe: -23.0 kcal/mol p-value: 0.002519
target: gi|212487|gb|M10639.1|CHKOM3ENA mfe: -21.8 kcal/mol p-value: 0.008784
target: gi|212233|gb|M25641.1|CHKKERSK9 mfe: -25.7 kcal/mol p-value: 0.000289
target: gi|211874|gb|M10380.1|CHKHBB mfe: -21.8 kcal/mol p-value: 0.000077
target: gi|211764|gb|L08402.1|CHKFAKZ mfe: -25.9 kcal/mol p-value: 0.000187
target: gi|211617|gb|M29397.1|CHKCOLAIX mfe: -24.4 kcal/mol p-value: 0.007811
target: gi|211287|gb|K01482.1|CHKC1A15E mfe: -23.1 kcal/mol p-value: 0.002016
target: gi|357196822|emb|HE608818.1| mfe: -24.5 kcal/mol p-value: 0.000437
target: gi|309756390|gb|HQ269806.1| mfe: -27.4 kcal/mol p-value: 0.003675
target: gi|325505051|dbj|AB188299.2| mfe: -26.6 kcal/mol p-value: 0.006772
target: gi|312165965|gb|HQ340611.1| mfe: -28.7 kcal/mol p-value: 0.003049
target: gi|565063|gb|U07826.1|GGU07826 mfe: -26.8 kcal/mol p-value: 0.004396
target: gi|223951346|gb|FJ655786.1| mfe: -21.3 kcal/mol p-value: 0.007822
target: gi|184186387|gb|EU399904.1| mfe: -24.4 kcal/mol p-value: 0.008454
target: gi|301071037|gb|HM475269.1| mfe: -21.8 kcal/mol p-value: 0.008570
target: gi|44994970|gb|AY525165.1| mfe: -22.4 kcal/mol p-value: 0.002922
target: gi|44994883|gb|AY525164.1| mfe: -22.4 kcal/mol p-value: 0.009961
target: gi|38146380|gb|AY355452.1| mfe: -23.7 kcal/mol p-value: 0.008826
target: gi|38146376|gb|AY355450.1| mfe: -26.0 kcal/mol p-value: 0.000945
target: gi|1246109|gb|S80617.1| mfe: -26.6 kcal/mol p-value: 0.001020
target: gi|1110573|gb|S79409.1| mfe: -21.9 kcal/mol p-value: 0.005383
target: gi|619294|gb|S72435.1| mfe: -19.9 kcal/mol p-value: 0.006191
target: gi|545838|gb|S69508.1| mfe: -26.1 kcal/mol p-value: 0.005923
target: gi|410608|gb|S65219.1| mfe: -25.0 kcal/mol p-value: 0.009064
target: gi|264403|gb|S53719.1| mfe: -22.5 kcal/mol p-value: 0.003612
target: gi|212901|gb|J04959.1|CHKZACT mfe: -26.8 kcal/mol p-value: 0.005179
target: gi|212255|gb|M25774.1|CHKLII mfe: -25.6 kcal/mol p-value: 0.004427
target: gi|211125|gb|M12153.1|CHKAKM mfe: -26.0 kcal/mol p-value: 0.004829
target: gi|10441614|gb|AF190051.1| mfe: -24.4 kcal/mol p-value: 0.008459
target: gi|22087250|gb|AF492497.1| mfe: -29.0 kcal/mol p-value: 0.002661
target: gi|21667328|gb|AF472617.1| mfe: -30.0 kcal/mol p-value: 0.001811
target: gi|18034666|gb|AF456453.1| mfe: -29.0 kcal/mol p-value: 0.000600
target: gi|14701796|gb|AF335427.1| mfe: -27.3 kcal/mol p-value: 0.007297
target: gi|157165815|gb|EU124684.1| mfe: -28.9 kcal/mol p-value: 0.001219
target: gi|4836811|gb|AF090083.1| mfe: -25.2 kcal/mol p-value: 0.001064
target: gi|4761592|gb|AF131224.1| mfe: -26.7 kcal/mol p-value: 0.002828
target: gi|4262326|gb|AF075441.1| mfe: -26.5 kcal/mol p-value: 0.004884
target: gi|4104728|gb|AF041801.1| mfe: -23.0 kcal/mol p-value: 0.002519
target: gi|4104726|gb|AF041800.1| mfe: -24.0 kcal/mol p-value: 0.000923
target: gi|2935460|gb|AF049135.1| mfe: -24.8 kcal/mol p-value: 0.004078
target: gi|2736144|gb|AF022226.1| mfe: -25.1 kcal/mol p-value: 0.008015
target: gi|284181766|gb|GU370775.1| mfe: -22.7 kcal/mol p-value: 0.005660
target: gi|283488659|gb|GU230781.1| mfe: -22.0 kcal/mol p-value: 0.000572
target: gi|156567604|gb|EF587763.1| mfe: -24.4 kcal/mol p-value: 0.008454
target: gi|86277777|gb|DQ358722.1| mfe: -24.6 kcal/mol p-value: 0.005646
target: gi|37928717|gb|AY234184.1| mfe: -25.5 kcal/mol p-value: 0.008791
target: gi|11320876|gb|AF152358.1| mfe: -31.5 kcal/mol p-value: 0.002284
target: gi|3513523|gb|AF050131.1| mfe: -28.1 kcal/mol p-value: 0.004339
target: gi|237874618|gb|FJ423550.1| mfe: -25.9 kcal/mol p-value: 0.007105
target: gi|222542883|gb|FJ605357.1| mfe: -22.7 kcal/mol p-value: 0.003901
target: gi|219944578|gb|FJ544313.1| mfe: -28.9 kcal/mol p-value: 0.001551
target: gi|219924500|emb|FM200371.1| mfe: -24.4 kcal/mol p-value: 0.008115
target: gi|219924428|emb|FM200335.1| mfe: -24.4 kcal/mol p-value: 0.008115
target: gi|151427597|tpd|BR000289.1| mfe: -25.6 kcal/mol p-value: 0.008267
target: gi|156628037|gb|EF554699.1| mfe: -25.5 kcal/mol p-value: 0.007384
target: gi|53134421|emb|AJ720671.1| mfe: -27.1 kcal/mol p-value: 0.001169
target: gi|48841989|emb|CR523327.1| mfe: -26.2 kcal/mol p-value: 0.004358
target: gi|48841645|emb|CR523078.1| mfe: -26.2 kcal/mol p-value: 0.005825
target: gi|46238419|emb|CR385660.1| mfe: -25.9 kcal/mol p-value: 0.007818
target: gi|46017616|emb|BX932892.2| mfe: -26.2 kcal/mol p-value: 0.003611
target: gi|194326346|emb|AM773754.1| mfe: -24.4 kcal/mol p-value: 0.008454
target: gi|118772246|gb|EF118300.1| mfe: -27.4 kcal/mol p-value: 0.009051
target: gi|164429964|gb|EU334507.1| mfe: -24.1 kcal/mol p-value: 0.007569
target: gi|118424544|gb|EF068232.1| mfe: -26.1 kcal/mol p-value: 0.008444
target: gi|4456141|emb|AJ236856.1| mfe: -28.9 kcal/mol p-value: 0.000872
target: gi|110293354|gb|DQ673442.1| mfe: -20.6 kcal/mol p-value: 0.006341
target: gi|89000564|dbj|AB233002.1| mfe: -23.5 kcal/mol p-value: 0.009797
target: gi|54114951|tpg|BK001567.1| mfe: -26.8 kcal/mol p-value: 0.004182
target: gi|84616740|emb|AM179858.1| mfe: -29.0 kcal/mol p-value: 0.005214
target: gi|63094466|emb|AJ879987.1| mfe: -22.0 kcal/mol p-value: 0.009620
target: gi|63094398|emb|AJ879952.1| mfe: -22.5 kcal/mol p-value: 0.005918
target: gi|61104944|gb|AY874079.1| mfe: -26.1 kcal/mol p-value: 0.006862
target: gi|63272|emb|X67327.1| mfe: -23.9 kcal/mol p-value: 0.009732
target: gi|1869741|emb|Y11472.1| mfe: -24.3 kcal/mol p-value: 0.007171
target: gi|63378|emb|X03805.1| mfe: -28.7 kcal/mol p-value: 0.004309
target: gi|63224|emb|X52748.1| mfe: -25.1 kcal/mol p-value: 0.000414
target: gi|62896|emb|X54944.1| mfe: -28.6 kcal/mol p-value: 0.005229
target: gi|60099242|emb|AJ851818.1| mfe: -28.3 kcal/mol p-value: 0.005631
target: gi|60099106|emb|AJ851750.1| mfe: -29.1 kcal/mol p-value: 0.004913
target: gi|60098594|emb|AJ851494.1| mfe: -27.8 kcal/mol p-value: 0.008254
target: gi|53130198|emb|AJ719791.1| mfe: -26.5 kcal/mol p-value: 0.009197
target: gi|53130168|emb|AJ719788.1| mfe: -26.4 kcal/mol p-value: 0.009078
target: gi|53127479|emb|AJ719464.1| mfe: -26.9 kcal/mol p-value: 0.003875
target: gi|5823899|emb|AJ249219.1| mfe: -27.7 kcal/mol p-value: 0.001656
target: gi|53127305|emb|AJ719377.1| mfe: -25.5 kcal/mol p-value: 0.008902
target: gi|53126498|emb|AJ719302.1| mfe: -30.4 kcal/mol p-value: 0.003916
target: gi|53136507|emb|AJ720924.1| mfe: -29.3 kcal/mol p-value: 0.005122
target: gi|53133938|emb|AJ720629.1| mfe: -28.7 kcal/mol p-value: 0.008370
target: gi|53130725|emb|AJ720033.1| mfe: -27.2 kcal/mol p-value: 0.001745
target: gi|53127769|emb|AJ719555.1| mfe: -27.8 kcal/mol p-value: 0.005547
target: gi|53127705|emb|AJ719523.1| mfe: -26.8 kcal/mol p-value: 0.004529
target: gi|53127489|emb|AJ719469.1| mfe: -25.1 kcal/mol p-value: 0.008839
target: gi|48843165|emb|CR524440.1| mfe: -28.3 kcal/mol p-value: 0.000803
target: gi|48843153|emb|CR524428.1| mfe: -29.6 kcal/mol p-value: 0.000226
target: gi|48843103|emb|CR524378.1| mfe: -24.6 kcal/mol p-value: 0.005803
target: gi|48843013|emb|CR524288.1| mfe: -28.2 kcal/mol p-value: 0.000747
target: gi|48842871|emb|CR524209.1| mfe: -28.8 kcal/mol p-value: 0.000807
target: gi|48842726|emb|CR524064.1| mfe: -27.9 kcal/mol p-value: 0.001280
target: gi|48842685|emb|CR524023.1| mfe: -25.8 kcal/mol p-value: 0.006263
target: gi|48842647|emb|CR523985.1| mfe: -25.7 kcal/mol p-value: 0.006964
target: gi|48842619|emb|CR523957.1| mfe: -28.0 kcal/mol p-value: 0.001106
target: gi|48842506|emb|CR523844.1| mfe: -26.6 kcal/mol p-value: 0.004453
target: gi|48842287|emb|CR523625.1| mfe: -27.5 kcal/mol p-value: 0.002438
target: gi|48842079|emb|CR523417.1| mfe: -27.9 kcal/mol p-value: 0.007540
target: gi|48842077|emb|CR523415.1| mfe: -28.8 kcal/mol p-value: 0.003141
target: gi|48841983|emb|CR523321.1| mfe: -31.7 kcal/mol p-value: 0.000066
target: gi|48841978|emb|CR523316.1| mfe: -27.9 kcal/mol p-value: 0.000931
target: gi|48841962|emb|CR523300.1| mfe: -26.9 kcal/mol p-value: 0.004585
target: gi|48841945|emb|CR523283.1| mfe: -25.6 kcal/mol p-value: 0.005607
target: gi|48841929|emb|CR523267.1| mfe: -25.1 kcal/mol p-value: 0.005324
target: gi|48841766|emb|CR523199.1| mfe: -30.2 kcal/mol p-value: 0.000132
target: gi|48841765|emb|CR523198.1| mfe: -26.9 kcal/mol p-value: 0.002066
target: gi|48841705|emb|CR523138.1| mfe: -24.9 kcal/mol p-value: 0.008904
target: gi|48841704|emb|CR523137.1| mfe: -24.1 kcal/mol p-value: 0.004252
target: gi|48841661|emb|CR523094.1| mfe: -25.5 kcal/mol p-value: 0.008813
target: gi|48841656|emb|CR523089.1| mfe: -27.0 kcal/mol p-value: 0.002168
target: gi|48841604|emb|CR523037.1| mfe: -28.5 kcal/mol p-value: 0.000615
target: gi|48841596|emb|CR523029.1| mfe: -26.5 kcal/mol p-value: 0.005202
target: gi|48841588|emb|CR523021.1| mfe: -27.0 kcal/mol p-value: 0.002015
target: gi|48841546|emb|CR522979.1| mfe: -26.3 kcal/mol p-value: 0.002884
target: gi|47022951|emb|CR407417.1| mfe: -27.9 kcal/mol p-value: 0.001747
target: gi|47022856|emb|CR407322.1| mfe: -25.8 kcal/mol p-value: 0.008690
target: gi|47022749|emb|CR407215.1| mfe: -31.5 kcal/mol p-value: 0.000050
target: gi|47022695|emb|CR407161.1| mfe: -29.1 kcal/mol p-value: 0.000374
target: gi|47022674|emb|CR407140.1| mfe: -26.0 kcal/mol p-value: 0.005319
target: gi|47022563|emb|CR407029.1| mfe: -26.3 kcal/mol p-value: 0.005889
target: gi|47022506|emb|CR406972.1| mfe: -26.5 kcal/mol p-value: 0.006197
target: gi|47022479|emb|CR406945.1| mfe: -26.5 kcal/mol p-value: 0.007188
target: gi|47022427|emb|CR406893.1| mfe: -27.6 kcal/mol p-value: 0.001952
target: gi|47022268|emb|CR406734.1| mfe: -28.4 kcal/mol p-value: 0.002500
target: gi|47022218|emb|CR406684.1| mfe: -26.1 kcal/mol p-value: 0.007410
target: gi|47022208|emb|CR406674.1| mfe: -25.1 kcal/mol p-value: 0.009237
target: gi|47022119|emb|CR406585.1| mfe: -26.3 kcal/mol p-value: 0.009080
target: gi|47021985|emb|CR406451.1| mfe: -27.3 kcal/mol p-value: 0.004069
target: gi|47021933|emb|CR406399.1| mfe: -26.5 kcal/mol p-value: 0.005133
target: gi|47021854|emb|CR406320.1| mfe: -26.2 kcal/mol p-value: 0.008705
target: gi|47021843|emb|CR406309.1| mfe: -27.7 kcal/mol p-value: 0.003230
target: gi|47021784|emb|CR406250.1| mfe: -25.6 kcal/mol p-value: 0.007185
target: gi|47021731|emb|CR406197.1| mfe: -25.6 kcal/mol p-value: 0.008041
target: gi|47021647|emb|CR406113.1| mfe: -26.5 kcal/mol p-value: 0.006755
target: gi|47021616|emb|CR406082.1| mfe: -26.7 kcal/mol p-value: 0.002733
target: gi|47021539|emb|CR406005.1| mfe: -25.5 kcal/mol p-value: 0.003530
target: gi|47021535|emb|CR406001.1| mfe: -26.1 kcal/mol p-value: 0.004461
target: gi|47021451|emb|CR405933.1| mfe: -26.4 kcal/mol p-value: 0.001752
target: gi|47021318|emb|CR405800.1| mfe: -22.9 kcal/mol p-value: 0.009810
target: gi|47021315|emb|CR405797.1| mfe: -26.8 kcal/mol p-value: 0.004118
target: gi|47021300|emb|CR405782.1| mfe: -26.8 kcal/mol p-value: 0.001734
target: gi|47021267|emb|CR405749.1| mfe: -27.0 kcal/mol p-value: 0.002476
target: gi|47021239|emb|CR405721.1| mfe: -25.9 kcal/mol p-value: 0.004624
target: gi|46430411|emb|CR391758.1| mfe: -26.2 kcal/mol p-value: 0.001883
target: gi|46430406|emb|CR391753.1| mfe: -25.2 kcal/mol p-value: 0.006521
target: gi|46430385|emb|CR391732.1| mfe: -27.4 kcal/mol p-value: 0.001820
target: gi|46430382|emb|CR391729.1| mfe: -25.4 kcal/mol p-value: 0.005979
target: gi|46430377|emb|CR391724.1| mfe: -25.8 kcal/mol p-value: 0.003203
target: gi|46430313|emb|CR391668.1| mfe: -24.9 kcal/mol p-value: 0.005285
target: gi|46430309|emb|CR391664.1| mfe: -25.5 kcal/mol p-value: 0.007466
target: gi|46430239|emb|CR391594.1| mfe: -25.9 kcal/mol p-value: 0.007960
target: gi|46430235|emb|CR391590.1| mfe: -25.1 kcal/mol p-value: 0.009726
target: gi|46430144|emb|CR391499.1| mfe: -26.9 kcal/mol p-value: 0.004836
target: gi|46430117|emb|CR391472.1| mfe: -27.5 kcal/mol p-value: 0.004021
target: gi|46430093|emb|CR391448.1| mfe: -29.2 kcal/mol p-value: 0.000423
target: gi|46430032|emb|CR391387.1| mfe: -26.3 kcal/mol p-value: 0.004082
target: gi|46429944|emb|CR391299.1| mfe: -28.7 kcal/mol p-value: 0.000812
target: gi|46429921|emb|CR391276.1| mfe: -26.9 kcal/mol p-value: 0.004447
target: gi|46429913|emb|CR391268.1| mfe: -25.7 kcal/mol p-value: 0.006531
target: gi|46429890|emb|CR391245.1| mfe: -25.3 kcal/mol p-value: 0.006308
target: gi|46429871|emb|CR391226.1| mfe: -27.3 kcal/mol p-value: 0.003628
target: gi|46429842|emb|CR391197.1| mfe: -25.4 kcal/mol p-value: 0.007215
target: gi|46429836|emb|CR391191.1| mfe: -26.6 kcal/mol p-value: 0.005695
target: gi|46429825|emb|CR391180.1| mfe: -24.9 kcal/mol p-value: 0.007681
target: gi|46429824|emb|CR391179.1| mfe: -25.9 kcal/mol p-value: 0.009995
target: gi|46429723|emb|CR391078.1| mfe: -25.0 kcal/mol p-value: 0.005789
target: gi|46429684|emb|CR391039.1| mfe: -25.1 kcal/mol p-value: 0.005492
target: gi|46429449|emb|CR390804.1| mfe: -25.5 kcal/mol p-value: 0.006801
target: gi|46429389|emb|CR390744.1| mfe: -26.0 kcal/mol p-value: 0.003566
target: gi|46429380|emb|CR390735.1| mfe: -26.3 kcal/mol p-value: 0.001998
target: gi|46429276|emb|CR390631.1| mfe: -25.7 kcal/mol p-value: 0.005099
target: gi|46429243|emb|CR390598.1| mfe: -24.3 kcal/mol p-value: 0.003825
target: gi|46429165|emb|CR390520.1| mfe: -24.9 kcal/mol p-value: 0.007788
target: gi|46429101|emb|CR390456.1| mfe: -26.9 kcal/mol p-value: 0.001618
target: gi|46429097|emb|CR390452.1| mfe: -25.3 kcal/mol p-value: 0.006713
target: gi|46429071|emb|CR390426.1| mfe: -21.9 kcal/mol p-value: 0.009075
target: gi|46428993|emb|CR390348.1| mfe: -25.5 kcal/mol p-value: 0.007757
target: gi|46428982|emb|CR390337.1| mfe: -28.8 kcal/mol p-value: 0.004863
target: gi|46428966|emb|CR390321.1| mfe: -25.2 kcal/mol p-value: 0.006543
target: gi|46428914|emb|CR390269.1| mfe: -25.1 kcal/mol p-value: 0.006321
target: gi|46428854|emb|CR390209.1| mfe: -25.4 kcal/mol p-value: 0.009780
target: gi|46428798|emb|CR390153.1| mfe: -26.5 kcal/mol p-value: 0.006562
target: gi|46428756|emb|CR390111.1| mfe: -25.0 kcal/mol p-value: 0.001827
target: gi|46428725|emb|CR390080.1| mfe: -25.2 kcal/mol p-value: 0.007731
target: gi|46428633|emb|CR389988.1| mfe: -26.6 kcal/mol p-value: 0.009494
target: gi|46428604|emb|CR389959.1| mfe: -23.2 kcal/mol p-value: 0.009156
target: gi|46428566|emb|CR389921.1| mfe: -26.3 kcal/mol p-value: 0.005783
target: gi|46428527|emb|CR389882.1| mfe: -26.6 kcal/mol p-value: 0.001766
target: gi|46428523|emb|CR389878.1| mfe: -24.9 kcal/mol p-value: 0.007283
target: gi|46428376|emb|CR389731.1| mfe: -27.4 kcal/mol p-value: 0.000847
target: gi|46428355|emb|CR389710.1| mfe: -24.7 kcal/mol p-value: 0.001279
target: gi|46428348|emb|CR389703.1| mfe: -24.9 kcal/mol p-value: 0.005791
target: gi|46428229|emb|CR389584.1| mfe: -26.6 kcal/mol p-value: 0.006909
target: gi|46428187|emb|CR389542.1| mfe: -23.6 kcal/mol p-value: 0.002580
target: gi|46428139|emb|CR389494.1| mfe: -25.7 kcal/mol p-value: 0.003656
target: gi|46428130|emb|CR389485.1| mfe: -26.1 kcal/mol p-value: 0.008974
target: gi|46427832|emb|CR389187.1| mfe: -27.0 kcal/mol p-value: 0.003896
target: gi|46427722|emb|CR389077.1| mfe: -28.1 kcal/mol p-value: 0.000504
target: gi|46427668|emb|CR389023.1| mfe: -27.9 kcal/mol p-value: 0.000478
target: gi|46427617|emb|CR388972.1| mfe: -28.5 kcal/mol p-value: 0.000496
target: gi|46427581|emb|CR388936.1| mfe: -25.7 kcal/mol p-value: 0.006548
target: gi|46427579|emb|CR388934.1| mfe: -26.4 kcal/mol p-value: 0.004639
target: gi|46427529|emb|CR388884.1| mfe: -27.3 kcal/mol p-value: 0.002899
target: gi|46427520|emb|CR388875.1| mfe: -25.4 kcal/mol p-value: 0.009891
target: gi|46427463|emb|CR388818.1| mfe: -27.6 kcal/mol p-value: 0.005242
target: gi|46427341|emb|CR338788.2| mfe: -27.2 kcal/mol p-value: 0.001374
target: gi|46427300|emb|CR388685.1| mfe: -27.8 kcal/mol p-value: 0.003148
target: gi|46427128|emb|CR388513.1| mfe: -25.0 kcal/mol p-value: 0.008598
target: gi|46426323|emb|BX950838.2| mfe: -28.3 kcal/mol p-value: 0.003747
target: gi|46426186|emb|BX936212.2| mfe: -25.4 kcal/mol p-value: 0.009852
target: gi|46425747|emb|BX933762.2| mfe: -28.4 kcal/mol p-value: 0.001099
target: gi|46425559|emb|BX930126.2| mfe: -25.6 kcal/mol p-value: 0.006429
target: gi|46425517|emb|BX929789.2| mfe: -26.0 kcal/mol p-value: 0.004105
target: gi|46425481|emb|BX929712.2| mfe: -29.0 kcal/mol p-value: 0.000373
target: gi|46425469|emb|BX929693.2| mfe: -25.2 kcal/mol p-value: 0.009086
target: gi|46425467|emb|BX929685.2| mfe: -27.4 kcal/mol p-value: 0.003682
target: gi|46240671|emb|CR387912.1| mfe: -25.2 kcal/mol p-value: 0.009600
target: gi|46240596|emb|CR387837.1| mfe: -26.8 kcal/mol p-value: 0.008171
target: gi|46240536|emb|CR387777.1| mfe: -26.3 kcal/mol p-value: 0.006608
target: gi|46240418|emb|CR387659.1| mfe: -26.7 kcal/mol p-value: 0.005822
target: gi|46240124|emb|CR387365.1| mfe: -25.0 kcal/mol p-value: 0.009485
target: gi|46240110|emb|CR387351.1| mfe: -25.4 kcal/mol p-value: 0.007257
target: gi|46239974|emb|CR387215.1| mfe: -25.1 kcal/mol p-value: 0.004543
target: gi|46239892|emb|CR387133.1| mfe: -27.0 kcal/mol p-value: 0.008364
target: gi|46239876|emb|CR387117.1| mfe: -24.7 kcal/mol p-value: 0.009009
target: gi|46239828|emb|CR387069.1| mfe: -25.8 kcal/mol p-value: 0.008287
target: gi|46239770|emb|CR387011.1| mfe: -27.0 kcal/mol p-value: 0.009173
target: gi|46239704|emb|CR386945.1| mfe: -27.7 kcal/mol p-value: 0.006450
target: gi|46239635|emb|CR386876.1| mfe: -27.4 kcal/mol p-value: 0.004172
target: gi|46239538|emb|CR386779.1| mfe: -25.2 kcal/mol p-value: 0.007472
target: gi|46239345|emb|CR386586.1| mfe: -29.1 kcal/mol p-value: 0.000762
target: gi|46239267|emb|CR386508.1| mfe: -28.3 kcal/mol p-value: 0.000684
target: gi|46239212|emb|CR386453.1| mfe: -26.7 kcal/mol p-value: 0.004899
target: gi|46239205|emb|CR386446.1| mfe: -25.3 kcal/mol p-value: 0.006102
target: gi|46239202|emb|CR386443.1| mfe: -25.8 kcal/mol p-value: 0.004709
target: gi|46239110|emb|CR386351.1| mfe: -29.0 kcal/mol p-value: 0.000594
target: gi|46239100|emb|CR386341.1| mfe: -27.5 kcal/mol p-value: 0.002562
target: gi|46238848|emb|CR386089.1| mfe: -28.1 kcal/mol p-value: 0.000634
target: gi|46238840|emb|CR386081.1| mfe: -25.2 kcal/mol p-value: 0.009734
target: gi|46238833|emb|CR386074.1| mfe: -24.9 kcal/mol p-value: 0.007520
target: gi|46238794|emb|CR386035.1| mfe: -24.9 kcal/mol p-value: 0.009875
target: gi|46238778|emb|CR386019.1| mfe: -25.5 kcal/mol p-value: 0.008181
target: gi|46238731|emb|CR385972.1| mfe: -25.2 kcal/mol p-value: 0.006675
target: gi|46238696|emb|CR385937.1| mfe: -24.9 kcal/mol p-value: 0.007361
target: gi|46238577|emb|CR385818.1| mfe: -28.7 kcal/mol p-value: 0.004855
target: gi|46238507|emb|CR385748.1| mfe: -27.4 kcal/mol p-value: 0.003245
target: gi|46238459|emb|CR385700.1| mfe: -26.5 kcal/mol p-value: 0.001451
target: gi|46238325|emb|CR385566.1| mfe: -27.3 kcal/mol p-value: 0.004966
target: gi|46238285|emb|CR385526.1| mfe: -25.2 kcal/mol p-value: 0.009137
target: gi|46238278|emb|CR385519.1| mfe: -25.9 kcal/mol p-value: 0.001674
target: gi|46238257|emb|CR385498.1| mfe: -28.2 kcal/mol p-value: 0.000734
target: gi|46238098|emb|CR385419.1| mfe: -23.4 kcal/mol p-value: 0.005796
target: gi|46238090|emb|CR385411.1| mfe: -25.5 kcal/mol p-value: 0.003690
target: gi|46238071|emb|CR385392.1| mfe: -26.9 kcal/mol p-value: 0.005801
target: gi|46237888|emb|CR385223.1| mfe: -25.5 kcal/mol p-value: 0.009398
target: gi|46237837|emb|CR385172.1| mfe: -25.3 kcal/mol p-value: 0.008487
target: gi|46019356|emb|CR338777.2| mfe: -25.6 kcal/mol p-value: 0.003901
target: gi|46019294|emb|BX950699.2| mfe: -28.4 kcal/mol p-value: 0.001196
target: gi|46018872|emb|BX936033.2| mfe: -26.9 kcal/mol p-value: 0.008278
target: gi|46018789|emb|BX935848.2| mfe: -26.9 kcal/mol p-value: 0.001428
target: gi|46018753|emb|BX935766.2| mfe: -27.0 kcal/mol p-value: 0.002410
target: gi|46018735|emb|BX935710.2| mfe: -25.4 kcal/mol p-value: 0.008352
target: gi|46018663|emb|BX935541.2| mfe: -25.6 kcal/mol p-value: 0.006633
target: gi|46018596|emb|BX935390.2| mfe: -26.1 kcal/mol p-value: 0.007586
target: gi|46018432|emb|BX935034.2| mfe: -27.1 kcal/mol p-value: 0.006972
target: gi|46018323|emb|BX934727.2| mfe: -27.9 kcal/mol p-value: 0.002036
target: gi|46018189|emb|BX934421.2| mfe: -27.2 kcal/mol p-value: 0.001953
target: gi|46018162|emb|BX934196.2| mfe: -22.9 kcal/mol p-value: 0.009880
target: gi|46018141|emb|BX934152.2| mfe: -28.0 kcal/mol p-value: 0.002490
target: gi|46018000|emb|BX933692.2| mfe: -26.5 kcal/mol p-value: 0.004007
target: gi|46017900|emb|BX933503.2| mfe: -24.7 kcal/mol p-value: 0.007909
target: gi|46017789|emb|BX933280.2| mfe: -27.9 kcal/mol p-value: 0.000673
target: gi|46017746|emb|BX933178.2| mfe: -26.0 kcal/mol p-value: 0.006233
target: gi|46017695|emb|BX933081.2| mfe: -26.9 kcal/mol p-value: 0.007343
target: gi|46017604|emb|BX932863.2| mfe: -26.0 kcal/mol p-value: 0.007608
target: gi|46017547|emb|BX932749.2| mfe: -25.1 kcal/mol p-value: 0.008091
target: gi|46017540|emb|BX932723.2| mfe: -26.1 kcal/mol p-value: 0.002758
target: gi|46017436|emb|BX932443.2| mfe: -25.4 kcal/mol p-value: 0.007687
target: gi|46017363|emb|BX932282.2| mfe: -25.5 kcal/mol p-value: 0.007820
target: gi|46017315|emb|BX932153.2| mfe: -26.9 kcal/mol p-value: 0.001552
target: gi|46017300|emb|BX932110.2| mfe: -25.9 kcal/mol p-value: 0.004393
target: gi|46017195|emb|BX931630.2| mfe: -25.6 kcal/mol p-value: 0.007518
target: gi|46017193|emb|BX931623.2| mfe: -28.7 kcal/mol p-value: 0.000299
target: gi|46017168|emb|BX931576.2| mfe: -25.6 kcal/mol p-value: 0.008558
target: gi|46017146|emb|BX931526.2| mfe: -25.6 kcal/mol p-value: 0.009591
target: gi|46017131|emb|BX931491.2| mfe: -25.3 kcal/mol p-value: 0.009812
target: gi|46017117|emb|BX931469.2| mfe: -26.9 kcal/mol p-value: 0.001492
target: gi|46017079|emb|BX931407.2| mfe: -28.7 kcal/mol p-value: 0.001741
target: gi|46017076|emb|BX931399.2| mfe: -26.2 kcal/mol p-value: 0.003405
target: gi|46017026|emb|BX931295.2| mfe: -26.5 kcal/mol p-value: 0.005541
target: gi|46016957|emb|BX931107.2| mfe: -25.5 kcal/mol p-value: 0.004760
target: gi|46016833|emb|BX930864.2| mfe: -26.2 kcal/mol p-value: 0.003513
target: gi|46016798|emb|BX930800.2| mfe: -25.7 kcal/mol p-value: 0.007811
target: gi|46016790|emb|BX930786.2| mfe: -26.8 kcal/mol p-value: 0.004889
target: gi|46016766|emb|BX930732.2| mfe: -23.2 kcal/mol p-value: 0.006780
target: gi|46016750|emb|BX930703.2| mfe: -26.3 kcal/mol p-value: 0.004171
target: gi|46016729|emb|BX930661.2| mfe: -23.5 kcal/mol p-value: 0.009472
target: gi|46016701|emb|BX930601.2| mfe: -25.8 kcal/mol p-value: 0.005159
target: gi|46016686|emb|BX930577.2| mfe: -25.9 kcal/mol p-value: 0.004807
target: gi|46016654|emb|BX930493.2| mfe: -25.4 kcal/mol p-value: 0.004592
target: gi|46016611|emb|BX930385.2| mfe: -23.5 kcal/mol p-value: 0.009852
target: gi|46016455|emb|BX929977.2| mfe: -28.0 kcal/mol p-value: 0.002030
target: gi|45426653|emb|CR354335.1| mfe: -26.0 kcal/mol p-value: 0.006456
target: gi|45426581|emb|CR354303.1| mfe: -27.6 kcal/mol p-value: 0.003203
target: gi|45426514|emb|CR354270.1| mfe: -26.0 kcal/mol p-value: 0.008276
target: gi|45426385|emb|CR354229.1| mfe: -25.7 kcal/mol p-value: 0.007448
target: gi|45426051|emb|CR354071.1| mfe: -23.6 kcal/mol p-value: 0.005653
target: gi|45426006|emb|CR354050.1| mfe: -27.3 kcal/mol p-value: 0.002071
target: gi|45425916|emb|CR354008.1| mfe: -24.9 kcal/mol p-value: 0.006467
target: gi|45425833|emb|CR353970.1| mfe: -26.4 kcal/mol p-value: 0.005765
target: gi|45425831|emb|CR353969.1| mfe: -25.6 kcal/mol p-value: 0.007919
target: gi|45425792|emb|CR353952.1| mfe: -26.4 kcal/mol p-value: 0.006568
target: gi|45425612|emb|CR353868.1| mfe: -26.5 kcal/mol p-value: 0.001664
target: gi|45425328|emb|CR353746.1| mfe: -24.9 kcal/mol p-value: 0.004157
target: gi|45425324|emb|CR353744.1| mfe: -27.3 kcal/mol p-value: 0.001468
target: gi|45425236|emb|CR353703.1| mfe: -25.4 kcal/mol p-value: 0.005210
target: gi|45424995|emb|CR353592.1| mfe: -26.3 kcal/mol p-value: 0.005809
target: gi|45424834|emb|CR353522.1| mfe: -25.4 kcal/mol p-value: 0.008625
target: gi|45424729|emb|CR353476.1| mfe: -27.5 kcal/mol p-value: 0.004925
target: gi|45424560|emb|CR353395.1| mfe: -25.5 kcal/mol p-value: 0.008031
target: gi|45424457|emb|CR353349.1| mfe: -25.2 kcal/mol p-value: 0.005816
target: gi|45424386|emb|CR353315.1| mfe: -25.1 kcal/mol p-value: 0.006686
target: gi|45424240|emb|CR353261.1| mfe: -29.2 kcal/mol p-value: 0.000679
target: gi|45424189|emb|CR353236.1| mfe: -27.9 kcal/mol p-value: 0.001296
target: gi|45424152|emb|CR353219.1| mfe: -24.8 kcal/mol p-value: 0.002777
target: gi|45424047|emb|CR353171.1| mfe: -26.2 kcal/mol p-value: 0.002688
target: gi|45423991|emb|CR353146.1| mfe: -26.0 kcal/mol p-value: 0.003954
target: gi|45423875|emb|CR353092.1| mfe: -24.9 kcal/mol p-value: 0.004097
target: gi|45423834|emb|CR353072.1| mfe: -27.2 kcal/mol p-value: 0.005493
target: gi|45423480|emb|CR352905.1| mfe: -26.7 kcal/mol p-value: 0.006665
target: gi|45423430|emb|CR352882.1| mfe: -27.8 kcal/mol p-value: 0.002542
target: gi|45423397|emb|CR352867.1| mfe: -25.9 kcal/mol p-value: 0.005317
target: gi|45423184|emb|CR352766.1| mfe: -25.7 kcal/mol p-value: 0.006336
target: gi|45422649|emb|CR352756.1| mfe: -27.8 kcal/mol p-value: 0.005750
target: gi|45422609|emb|CR352737.1| mfe: -26.8 kcal/mol p-value: 0.003751
target: gi|45422607|emb|CR352736.1| mfe: -25.3 kcal/mol p-value: 0.008463
target: gi|45422449|emb|CR352659.1| mfe: -27.4 kcal/mol p-value: 0.008099
target: gi|45422277|emb|CR352575.1| mfe: -27.4 kcal/mol p-value: 0.000754
target: gi|45422029|emb|CR352456.1| mfe: -28.2 kcal/mol p-value: 0.002619
target: gi|45421989|emb|CR352435.1| mfe: -26.2 kcal/mol p-value: 0.008590
target: gi|44885160|emb|CR339016.1| mfe: -21.5 kcal/mol p-value: 0.006387
target: gi|44885013|emb|CR338869.1| mfe: -25.2 kcal/mol p-value: 0.006543
target: gi|44884979|emb|CR338835.1| mfe: -26.0 kcal/mol p-value: 0.009686
target: gi|44884878|emb|CR338734.1| mfe: -25.1 kcal/mol p-value: 0.005429
target: gi|42600259|emb|BX950574.1| mfe: -24.7 kcal/mol p-value: 0.009811
target: gi|42600166|emb|BX950512.1| mfe: -26.0 kcal/mol p-value: 0.003483
target: gi|42599936|emb|BX950282.1| mfe: -27.0 kcal/mol p-value: 0.009353
target: gi|42599898|emb|BX950244.1| mfe: -24.7 kcal/mol p-value: 0.008821
target: gi|41636764|emb|BX936236.1| mfe: -26.5 kcal/mol p-value: 0.004007
target: gi|41636715|emb|BX936187.1| mfe: -27.4 kcal/mol p-value: 0.001539
target: gi|41636656|emb|BX936128.1| mfe: -26.8 kcal/mol p-value: 0.004491
target: gi|41636195|emb|BX935667.1| mfe: -28.2 kcal/mol p-value: 0.001365
target: gi|41636184|emb|BX935656.1| mfe: -24.9 kcal/mol p-value: 0.006418
target: gi|41636142|emb|BX935614.1| mfe: -30.3 kcal/mol p-value: 0.000067
target: gi|41635927|emb|BX935399.1| mfe: -26.4 kcal/mol p-value: 0.005587
target: gi|41635855|emb|BX935327.1| mfe: -27.7 kcal/mol p-value: 0.002733
target: gi|41635826|emb|BX935298.1| mfe: -27.7 kcal/mol p-value: 0.002733
target: gi|41635813|emb|BX935285.1| mfe: -27.7 kcal/mol p-value: 0.002733
target: gi|41635725|emb|BX935197.1| mfe: -28.4 kcal/mol p-value: 0.000664
target: gi|41635644|emb|BX935116.1| mfe: -26.0 kcal/mol p-value: 0.005741
target: gi|41635493|emb|BX934965.1| mfe: -26.2 kcal/mol p-value: 0.002688
target: gi|41635321|emb|BX934793.1| mfe: -25.1 kcal/mol p-value: 0.009699
target: gi|41635227|emb|BX934699.1| mfe: -27.2 kcal/mol p-value: 0.004295
target: gi|41635056|emb|BX934528.1| mfe: -25.4 kcal/mol p-value: 0.006757
target: gi|41635026|emb|BX934498.1| mfe: -25.2 kcal/mol p-value: 0.005467
target: gi|41634999|emb|BX934471.1| mfe: -24.4 kcal/mol p-value: 0.006997
target: gi|41634959|emb|BX934431.1| mfe: -25.5 kcal/mol p-value: 0.008791
target: gi|41634769|emb|BX934241.1| mfe: -22.9 kcal/mol p-value: 0.008979
target: gi|41634727|emb|BX934199.1| mfe: -22.9 kcal/mol p-value: 0.009880
target: gi|41634698|emb|BX934170.1| mfe: -24.4 kcal/mol p-value: 0.006345
target: gi|41634689|emb|BX934161.1| mfe: -23.5 kcal/mol p-value: 0.009258
target: gi|41634623|emb|BX934095.1| mfe: -27.9 kcal/mol p-value: 0.000865
target: gi|41634621|emb|BX934093.1| mfe: -26.5 kcal/mol p-value: 0.008229
target: gi|41634609|emb|BX934081.1| mfe: -28.9 kcal/mol p-value: 0.002908
target: gi|41634385|emb|BX933857.1| mfe: -24.4 kcal/mol p-value: 0.006498
target: gi|41634272|emb|BX933744.1| mfe: -25.6 kcal/mol p-value: 0.006065
target: gi|41634243|emb|BX933715.1| mfe: -25.6 kcal/mol p-value: 0.008412
target: gi|41634229|emb|BX933701.1| mfe: -24.9 kcal/mol p-value: 0.009695
target: gi|41634011|emb|BX933483.1| mfe: -25.8 kcal/mol p-value: 0.009522
target: gi|41633878|emb|BX933350.1| mfe: -25.9 kcal/mol p-value: 0.002096
target: gi|41633813|emb|BX933285.1| mfe: -28.7 kcal/mol p-value: 0.001840
target: gi|41633791|emb|BX933263.1| mfe: -26.0 kcal/mol p-value: 0.008189
target: gi|41633745|emb|BX933217.1| mfe: -27.0 kcal/mol p-value: 0.002443
target: gi|41633671|emb|BX933143.1| mfe: -29.0 kcal/mol p-value: 0.000299
target: gi|41633471|emb|BX932943.1| mfe: -26.9 kcal/mol p-value: 0.001880
target: gi|41633413|emb|BX932885.1| mfe: -27.4 kcal/mol p-value: 0.001810
target: gi|41633304|emb|BX932776.1| mfe: -25.9 kcal/mol p-value: 0.003646
target: gi|41633281|emb|BX932753.1| mfe: -25.4 kcal/mol p-value: 0.007774
target: gi|41633150|emb|BX932622.1| mfe: -26.1 kcal/mol p-value: 0.005318
target: gi|41633052|emb|BX932524.1| mfe: -28.5 kcal/mol p-value: 0.001089
target: gi|41632937|emb|BX932409.1| mfe: -25.5 kcal/mol p-value: 0.004209
target: gi|41632854|emb|BX932326.1| mfe: -28.9 kcal/mol p-value: 0.000883
target: gi|41632817|emb|BX932289.1| mfe: -25.7 kcal/mol p-value: 0.006075
target: gi|41632300|emb|BX931772.1| mfe: -27.1 kcal/mol p-value: 0.003407
target: gi|41632230|emb|BX931702.1| mfe: -25.6 kcal/mol p-value: 0.009503
target: gi|41632167|emb|BX931639.1| mfe: -26.2 kcal/mol p-value: 0.002882
target: gi|41632065|emb|BX931537.1| mfe: -26.6 kcal/mol p-value: 0.002742
target: gi|41631873|emb|BX931345.1| mfe: -26.5 kcal/mol p-value: 0.007949
target: gi|41631719|emb|BX931191.1| mfe: -25.4 kcal/mol p-value: 0.007215
target: gi|41631619|emb|BX931091.1| mfe: -28.0 kcal/mol p-value: 0.000547
target: gi|41631375|emb|BX930847.1| mfe: -25.4 kcal/mol p-value: 0.008809
target: gi|41631360|emb|BX930832.1| mfe: -25.7 kcal/mol p-value: 0.007811
target: gi|41631268|emb|BX930740.1| mfe: -27.4 kcal/mol p-value: 0.000096
target: gi|41631173|emb|BX930645.1| mfe: -26.6 kcal/mol p-value: 0.003298
target: gi|41630976|emb|BX930448.1| mfe: -24.9 kcal/mol p-value: 0.006895
target: gi|41630946|emb|BX930418.1| mfe: -29.0 kcal/mol p-value: 0.000057
target: gi|41630939|emb|BX930411.1| mfe: -24.4 kcal/mol p-value: 0.009567
target: gi|41630910|emb|BX930382.1| mfe: -27.9 kcal/mol p-value: 0.000656
target: gi|41630841|emb|BX930313.1| mfe: -25.8 kcal/mol p-value: 0.005189
target: gi|41630418|emb|BX929890.1| mfe: -29.3 kcal/mol p-value: 0.001174
target: gi|41630259|emb|BX929731.1| mfe: -26.3 kcal/mol p-value: 0.003785
target: gi|41630243|emb|BX929715.1| mfe: -26.5 kcal/mol p-value: 0.007963
target: gi|41630087|emb|BX929620.1| mfe: -25.4 kcal/mol p-value: 0.009828
target: gi|41630025|emb|BX929558.1| mfe: -26.8 kcal/mol p-value: 0.002740
target: gi|41629866|emb|BX929399.1| mfe: -27.2 kcal/mol p-value: 0.003795
target: gi|41629839|emb|BX929372.1| mfe: -28.0 kcal/mol p-value: 0.002259
target: gi|40549106|gb|AY458225.1| mfe: -21.3 kcal/mol p-value: 0.005024
target: gi|37496539|emb|AJ539549.1| mfe: -25.9 kcal/mol p-value: 0.001526
target: gi|17384694|emb|AJ301881.1| mfe: -22.2 kcal/mol p-value: 0.007498
target: gi|17384693|emb|AJ301880.1| mfe: -22.2 kcal/mol p-value: 0.002932
target: gi|12082648|gb|AF218800.1|AF218800 mfe: -20.3 kcal/mol p-value: 0.008107
target: gi|3218466|emb|AJ006529.1| mfe: -26.4 kcal/mol p-value: 0.005394
target: gi|4514719|dbj|AB019790.1| mfe: -29.6 kcal/mol p-value: 0.003266
target: gi|2648029|emb|Y13977.1| mfe: -18.6 kcal/mol p-value: 0.007145
target: gi|2245238|emb|Z97258.1| mfe: -21.0 kcal/mol p-value: 0.006976
target: gi|2245223|emb|Z97243.1| mfe: -21.7 kcal/mol p-value: 0.009341
target: gi|2245222|emb|Z97242.1| mfe: -22.7 kcal/mol p-value: 0.004398
target: gi|2245219|emb|Z97239.1| mfe: -21.7 kcal/mol p-value: 0.009341
target: gi|2463045|emb|Y14827.1| mfe: -22.6 kcal/mol p-value: 0.006106
target: gi|1869739|emb|Y11473.1| mfe: -24.3 kcal/mol p-value: 0.007171
target: gi|1177399|emb|X92867.1| mfe: -27.2 kcal/mol p-value: 0.004053
target: gi|1177397|emb|X92866.1| mfe: -27.2 kcal/mol p-value: 0.004099
target: gi|63891|emb|V00449.1| mfe: -25.6 kcal/mol p-value: 0.003989
target: gi|62980|emb|X56852.1| mfe: -23.9 kcal/mol p-value: 0.009195
target: gi|557504|gb|M30368.1|CHKIGHABC mfe: -19.9 kcal/mol p-value: 0.002883
target: gi|212284|gb|M25446.1|CHKLYSX mfe: -20.5 kcal/mol p-value: 0.005630
target: GALGA_6AKI_KRT42 mfe: -23.5 kcal/mol p-value: 0.002960
target: GALGA25_FK1 mfe: -23.5 kcal/mol p-value: 0.004068
target: GALGA_UnR_FK5 mfe: -26.1 kcal/mol p-value: 0.000355
target: GALGA_UnR_FK4 mfe: -26.1 kcal/mol p-value: 0.000355
target: GALGA_UnR_FK8 mfe: -26.1 kcal/mol p-value: 0.000355
target: GALGA25_CL3 mfe: -24.4 kcal/mol p-value: 0.004002
target: GALGA25_CL7 mfe: -25.1 kcal/mol p-value: 0.001881
target: GALGA25_CL2 mfe: -25.6 kcal/mol p-value: 0.001336
target: GALGA25_CL4 mfe: -25.6 kcal/mol p-value: 0.001413
target: GALGA25_CL5 mfe: -24.4 kcal/mol p-value: 0.004002
target: GALGA_UnR_CL1 mfe: -25.6 kcal/mol p-value: 0.001413
target: GALGA25_CL8 mfe: -26.3 kcal/mol p-value: 0.000704
target: GALGA2_FK1 mfe: -26.1 kcal/mol p-value: 0.000355
target: GALGA2_FK3 mfe: -26.1 kcal/mol p-value: 0.000355
target: GALGA2_FK2 mfe: -26.1 kcal/mol p-value: 0.000355
target: GALGA_UnR_FK6 mfe: -26.1 kcal/mol p-value: 0.000355
target: GALGA_UnR_FK11 mfe: -26.1 kcal/mol p-value: 0.000355
target: GALGA2_FK4 mfe: -26.1 kcal/mol p-value: 0.000355
target: GALGA2_FK5 mfe: -26.1 kcal/mol p-value: 0.000355

file2:
Code:
NM_204120
NM_204845
NM_204849
NM_205345
NM_204743
NM_205483
NM_001277933
NM_001277902
NM_001277647
NM_001110438
NM_001030560
NM_001004407
NM_205182
NM_204885
XM_427278
XM_003642878
XM_428214
XM_003642634
XM_001233176
XM_417891
XM_001232075
XM_415532
XM_004944013
XM_001231664
XM_004938454
XM_004938318
NM_001277935
NM_001277759
NM_001277760
JX843734
M25641
K01482
AJ720924
CR524064
CR523957
CR523417
CR523321
CR523267
CR523094
CR523021
CR407417
CR407029
CR406684
CR406674
CR406113
CR405933
CR391753
CR391668
CR391448
CR391226
CR390452
CR390426
CR390321
CR388884
BX929685
CR387777
CR387365
CR386508
CR386081
CR386019
CR385700
CR385172
BX935710
BX933081
BX932749
BX932723
BX931526
BX931491
BX930601
BX930577
CR353476
CR353261
CR353219
CR338835
BX936128
BX935614
BX933350
BX932885
BX932776
BX932326
BX931191
BX929890
GALGA_6AKI_KRT42 
GALGA25_FK1 
GALGA_UnR_FK5 
GALGA_UnR_FK4 
GALGA_UnR_FK8 
GALGA25_CL3 
GALGA25_CL7 
GALGA25_CL2 
GALGA25_CL4 
GALGA_UnR_CL1 
GALGA25_CL8 
GALGA2_FK1

file3
Code:
AJ720924 0
BX929685 0
BX929890 0
BX930577 0
BX930601 0
BX931191 0
BX931491 0
BX931526 0
BX932326 0
BX932723 0
BX932749 0
BX932776 0
BX932885 0
BX933081 0
BX933350 0
BX935614 0
BX935710 0
BX936128 0
CR338835 0
CR353219 0
CR353261 0
CR353476 0
CR385172 0
CR385700 0
CR386019 0
CR386081 0
CR386508 0
CR387365 0
CR387777 0
CR388884 0
CR390321 0
CR390426 0
CR390452 0
CR391226 0
CR391448 0
CR391668 0
CR391753 0
CR405933 0
CR406113 0
CR406674 0
CR406684 0
CR407029 0
CR407417 0
CR523021 0
CR523094 0
CR523267 0
CR523321 0
CR523417 0
CR523957 0
CR524064 0
GALGA25_CL2 0
GALGA25_CL3 0
GALGA25_CL4 0
GALGA25_CL7 0
GALGA25_CL8 0
GALGA25_FK1 0
GALGA2_FK1 0
GALGA_6AKI_KRT42 0
GALGA_UnR_CL1 0
GALGA_UnR_FK4 0
GALGA_UnR_FK5 0
GALGA_UnR_FK8 0
JX843734 0
K01482 0
M25641 0
NM_001004407 0
NM_001030560 0
NM_001110438 0
NM_001277647 0
NM_001277759 0
NM_001277760 0
NM_001277902 0
NM_001277933 0
NM_001277935 0
NM_204120 0
NM_204743 0
NM_204845 0
NM_204849 0
NM_204885 0
NM_205182 0
NM_205345 0
NM_205483 0
XM_001231664 0
XM_001232075 0
XM_001233176 0
XM_003642634 0
XM_003642878 0
XM_004938318 0
XM_004938454 0
XM_004944013 0
XM_415532 0
XM_417891 0
XM_427278 0
XM_428214 0

---------- Post updated at 05:16 PM ---------- Previous update was at 05:02 PM ----------

Quote:
Originally Posted by Don Cragun
I STRONGLY suggest that you choose filenames that do not contain spaces; it will make your life much easier.

This is similar to RudiC's suggestion, but assumes the contents of "file 2" are expected to be fixed strings instead of extended regular expressions, assumes that you only want to search for those strings in the 1st field in "file 1", and includes the requested parentheses:
Code:
awk '
FNR == NR {
        key[$1]
        next
}
{       for(k in key)
                if(index($1, k)) 
                        key[k] += $(NF - 1)
}
END {   for(k in key)
                printf("%s (%.1f)\n", k, key[k])
}' "file 2" "file 1" | sort -t'(' -k2,2n > "file 3"

If you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk, /usr/xpg6/bin/awk, or nawk.

For future reference, please always tell us what OS and shell you're using so we can limit our suggestions to things that will work in your environment.
Hi Don, thank you for your reply, I used your method and your result is basically the same as RudiC's output file.(see my reply below to RudiC). IT doesn't follow the mfe value order. Sorry to bother you guys, but I am really a rookie for this kind of work.
# 6  
Old 09-25-2014
This is a result of what is known in the trade as GIGO (garbage in, garbage out). You told us what your input files looked like and you told us what you wanted your output to look like based on those input formats. We provided you code that performed the requested transformations and gave the exact output you said you wanted based on those input file formats.

Now you show us an input file format that is completely different from your sample input file format for file1 and tell us that our suggestions didn't work. Our software isn't smart enough to magically realize that the input format for file1 was totally wrong and transform itself into new code that can handle your new input file format.

Next time please give us representative sample data instead of wasting the time of all of the volunteers who were trying to help you. Smilie

I have other things to do this afternoon, but I may be able to try to put something together later to work with your new input input file format.
Last edited by Don Cragun; 09-26-2014 at 03:06 AM.. Reason: Fix typo know -> known
These 2 Users Gave Thanks to Don Cragun For This Post:
rbatte1 RudiC
# 7  
Old 09-25-2014
With your new input file format, the following seems to work:
Code:
awk '
FNR == NR {
        key[$1]
        next
}
{       for(k in key)
                if(index($2, k)) 
                        key[k] += $4
}
END {   for(k in key)
                printf("%s (%.1f)\n", k, key[k]) 
}' file2 file1 | sort -t'(' -k2,2n

This User Gave Thanks to Don Cragun For This Post:
yuejian
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Match and rank question

I actually posted a similar question before but my expression probably lead the helper here frustrated. I also tried to figure it out by myself but failed. So I rephrase my question again and hopefully it is clearer to understand. I really appreciate your help. Here is the file1target:... (2 Replies)
Discussion started by: yuejian
2 Replies

2. UNIX for Dummies Questions & Answers

Exact match question

Hi guys, I am using Centos 6.3. Actually I posted similar question but I still have some minor problem need be fixed. I have two files, file1:target: gi|57529786|ref|NM_001006513.1| mfe: -31.4 kcal/mol p-value: 0.006985 target: gi|403048743|ref|NM_001271159.1| mfe: -29.6 kcal/mol p-value:... (11 Replies)
Discussion started by: yuejian
11 Replies

3. UNIX for Dummies Questions & Answers

Script partially executes??

Hi All, I am calling a shell script from another shell script, however, it only executes part of it (the echo commands only). What could be some causes for that? For example: ShellScriptA.sh: ... ... ... . ShellScriptB.sh ShellScriptB.sh contents: echo date echo... (7 Replies)
Discussion started by: DBnixUser
7 Replies

4. Shell Programming and Scripting

How to output the partially equals

Hello i have 2 files: a.out 10.1.1.1 james.franco 10.1.1.3 google.gol 10.1.1.14 yahoo.bol b.out 10.1.1.1 10.1.1.3 10.1.1.45 I need to see an output just with: 10.1.1.1 james.franco 10.1.1.3 google.gol Thankz in advance!! (2 Replies)
Discussion started by: danielldf
2 Replies

5. Web Development

Fix For Google Page Rank: Wordpress List Rank Dashboard Widget

Here is the fix for the recent Google changes to their pagerank API. For example, in the List Rank Dashboard Widget Wordpress Plugin (Version 1.7), in this plugin file: list-rank-dashboard-widget/wp-list-rank-class.php in this function: function getGooglePR($url) Change this line: ... (0 Replies)
Discussion started by: Neo
0 Replies

6. Shell Programming and Scripting

Is it possible to partially clear the terminal?

The clear command specifically says it can only clear the entire terminal display. There are no arguments. So I'm wondering if there are any work arounds. Carriage return does not work for this as it only moves the cursor to the beginning of the line we're on. And obviously NL only goes down. If... (1 Reply)
Discussion started by: FunkyLich
1 Replies

7. Shell Programming and Scripting

Exact match question

Hi, I have a file like follows . . . White.Jack.is.going.home Black.Jack.is.going.home Red.Jack.is.going.home Jack.is.going.home . . . when I make: cat <file> | grep -w "Jack.is.going.home" it gives: White.Jack.is.going.home Black.Jack.is.going.home Red.Jack.is.going.home... (4 Replies)
Discussion started by: salih81
4 Replies

8. Shell Programming and Scripting

pattern match question

I have a pattern match problem I could use your help with I have a file in the following format (names.txt) jae,doe john,doe jay,doe I need to loop through the file using FOR and check the names in names.txt against another file (information.txt). information.txt is in the following... (2 Replies)
Discussion started by: chaos40
2 Replies

9. Shell Programming and Scripting

How to partially replace variable value?

I have variable $2 whose value is expdp_SDW_MSTR_VMDB.par I want to replace three characters from right (par) with (log) Input --> expdp_SDW_MSTR_VMDB.par Output --> expdp_SDW_MSTR_VMDB.log Thanks Deep (2 Replies)
Discussion started by: deep.singh
2 Replies

10. UNIX for Dummies Questions & Answers

grep question - match a url

I'm trying to find files which have urls such as "services/amf/fri/home.html" and "services/amj/fri/air.html" - so the pattern I want to match with grep, logically, is one that has 1. "services/" 2. stuff in between including slashes, numbers, underscores etc 3. ending in "html" Can... (5 Replies)
Discussion started by: pauljohn
5 Replies
Login or Register to Ask a Question