SEQanswers

Go Back   SEQanswers > Bioinformatics > Bioinformatics



Reply
 
Thread Tools
Old 12-16-2010, 05:51 AM   #1
semna
Member
 
Location: holland

Join Date: Apr 2010
Posts: 55
Default question?

Hi
I have a file like this:

XLOC_000001 q1:CUFF.307125|CUFF.307125.1|100|21.641774|12.337630|30.945918|15.184506|- -
XLOC_000001 q1:CUFF.307127|CUFF.307127.1|100|19.024629|10.301183|27.748076|13.490323|360 q2:CUFF.582701|CUFF.582701.2|35|4.177976|0.000000|9.502142|2.742783|628
XLOC_000002 q1:CUFF.307197|CUFF.307197.1|100|34.740054|22.951915|46.528193|22.054054|531 q2:CUFF.582841|CUFF.582841.1|100|67.322530|50.912469|83.732592|44.528017|608
XLOC_000005 q1:CUFF.307391|CUFF.307391.1|100|2.815540|0.000000|6.171455|1.981276|- -
XLOC_000007 q1:CUFF.307521|CUFF.307521.1|100|14.287217|6.727530|21.846904|10.184871|5318 q2:CUFF.583501|CUFF.583501.1|100|26.687891|16.355826|37.019955|18.473767|5806
XLOC_000011 q1:CUFF.307645|CUFF.307645.1|100|18.041098|9.546136|26.536061|11.601081|- -
XLOC_000389 - q2:CUFF.609345|CUFF.609345.1|100|18.703186|10.053750|27.352622|11.284938|-
XLOC_000391 - q2:CUFF.609367|CUFF.609367.1|50|13.973619|7.097039|20.850198|9.437297|-
XLOC_000392 - q2:CUFF.609367|CUFF.609367.2|39|10.916188|4.557339|17.275037|7.372414|-
I need to save those rows that has q1 or q2.(leave out those rows that contain both q1 and q2)
Anyone can help me? Thanks in advance
semna is offline   Reply With Quote
Old 12-16-2010, 05:52 AM   #2
semna
Member
 
Location: holland

Join Date: Apr 2010
Posts: 55
Default

Maybe it is not clear in my post .This table contains 3 columns.Thanks
semna is offline   Reply With Quote
Old 12-16-2010, 06:04 AM   #3
semna
Member
 
Location: holland

Join Date: Apr 2010
Posts: 55
Default

XLOC_000001 q1:CUFF.307125|CUFF.307125.1|100|21.641774|12.337630|30.945918|15.184506|- -
XLOC_000001 q1:CUFF.307127|CUFF.307127.1|100|19.024629|10.301183|27.748076|13.490323|360 q2:CUFF.582701|CUFF.582701.2|35|4.177976|0.000000|9.502142|2.742783|628
XLOC_000002 q1:CUFF.307197|CUFF.307197.1|100|34.740054|22.951915|46.528193|22.054054|531 q2:CUFF.582841|CUFF.582841.1|100|67.322530|50.912469|83.732592|44.528017|608
XLOC_000005 q1:CUFF.307391|CUFF.307391.1|100|2.815540|0.000000|6.171455|1.981276|- -
XLOC_000007 q1:CUFF.307521|CUFF.307521.1|100|14.287217|6.727530|21.846904|10.184871|5318 q2:CUFF.583501|CUFF.583501.1|100|26.687891|16.355826|37.019955|18.473767|5806
XLOC_000011 q1:CUFF.307645|CUFF.307645.1|100|18.041098|9.546136|26.536061|11.601081|- -
XLOC_000389 - q2:CUFF.609345|CUFF.609345.1|100|18.703186|10.053750|27.352622|11.284938|-
XLOC_000391 - q2:CUFF.609367|CUFF.609367.1|50|13.973619|7.097039|20.850198|9.437297|-
XLOC_000392 - q2:CUFF.609367|CUFF.609367.2|39|10.916188|4.557339|17.275037|7.372414|-
semna is offline   Reply With Quote
Old 12-16-2010, 06:30 AM   #4
severin
Genome Informatics Facility
 
Location: Iowa @isugif

Join Date: Sep 2009
Posts: 105
Default grep -v

you can use command lines to do this. egrep -v means do not include files with this pattern.

more filename | egrep q1 | egrep -v q2
more filename | egrep q2 | egrep -v q1

to get those that contain both try this

more filename | egrep q1 | egrep q2
severin is offline   Reply With Quote
Old 12-16-2010, 11:50 PM   #5
semna
Member
 
Location: holland

Join Date: Apr 2010
Posts: 55
Default

Hi Severin,
Thanks for your help. it works.
semna is offline   Reply With Quote
Old 12-17-2010, 12:50 AM   #6
Bruins
Member
 
Location: Groningen

Join Date: Feb 2010
Posts: 78
Default

also, in a post like yours you can make the table more readable by using a code block (the tiny # sign in the message editor)

like so
Code:
XLOC_000001 q1:CUFF.307125|CUFF.307125.1|100|21.641774|12.3376 30|30.945918|15.184506|- -
XLOC_000001 q1:CUFF.307127|CUFF.307127.1|100|19.024629|10.3011 83|27.748076|13.490323|360 q2:CUFF.582701|CUFF.582701.2|35|4.177976|0.000000| 9.502142|2.742783|628
XLOC_000002 q1:CUFF.307197|CUFF.307197.1|100|34.740054|22.9519 15|46.528193|22.054054|531 q2:CUFF.582841|CUFF.582841.1|100|67.322530|50.9124 69|83.732592|44.528017|608
XLOC_000005 q1:CUFF.307391|CUFF.307391.1|100|2.815540|0.000000 |6.171455|1.981276|- -
XLOC_000007 q1:CUFF.307521|CUFF.307521.1|100|14.287217|6.72753 0|21.846904|10.184871|5318 q2:CUFF.583501|CUFF.583501.1|100|26.687891|16.3558 26|37.019955|18.473767|5806
XLOC_000011 q1:CUFF.307645|CUFF.307645.1|100|18.041098|9.54613 6|26.536061|11.601081|- -
XLOC_000389 - q2:CUFF.609345|CUFF.609345.1|100|18.703186|10.0537 50|27.352622|11.284938|-
XLOC_000391 - q2:CUFF.609367|CUFF.609367.1|50|13.973619|7.097039 |20.850198|9.437297|-
XLOC_000392 - q2:CUFF.609367|CUFF.609367.2|39|10.916188|4.557339 |17.275037|7.372414|-
Bruins is offline   Reply With Quote
Old 12-17-2010, 05:18 AM   #7
severin
Genome Informatics Facility
 
Location: Iowa @isugif

Join Date: Sep 2009
Posts: 105
Default

cool, How does one use block code?
severin is offline   Reply With Quote
Old 12-20-2010, 04:30 AM   #8
Bruins
Member
 
Location: Groningen

Join Date: Feb 2010
Posts: 78
Default

Hi,

When you click 'post reply' an editor opens in which you type your message. It should have a toolbar directly above it with some buttons to change the font, or make bold or italic or underline etc. When you hover your mouse over such a button it should give a tooltip that explains the button. Anyway, it's the '#' button on the right. It prints CODE tags. You can type between the tags, and that text will be displayed in the code block using a monospace font. You can play with it using the 'Preview post' button instead of submit.

Cheers!
Bruins is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off




All times are GMT -8. The time now is 04:28 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Single Sign On provided by vBSSO