Unconfigured Ad

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • semna
    Member
    • Apr 2010
    • 55
    #1

    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
    Tags: None
    • semna
      Member
      • Apr 2010
      • 55
      #2
      Maybe it is not clear in my post .This table contains 3 columns.Thanks

        Comment

        • semna
          Member
          • Apr 2010
          • 55
          #3
          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|-

            Comment

            • severin
              Genome Informatics Facility
              • Sep 2009
              • 105
              #4
              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

                Comment

                • semna
                  Member
                  • Apr 2010
                  • 55
                  #5
                  Hi Severin,
                  Thanks for your help. it works.

                    Comment

                    • Bruins
                      Member
                      • Feb 2010
                      • 78
                      #6
                      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|-

                        Comment

                        • severin
                          Genome Informatics Facility
                          • Sep 2009
                          • 105
                          #7
                          cool, How does one use block code?

                            Comment

                            • Bruins
                              Member
                              • Feb 2010
                              • 78
                              #8
                              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!

                                Comment

                                Previous template Next

                                Latest Articles

                                Collapse
                                • kinpict.com
                                  Reply to 16S/ITS Profiling vs. Shotgun Metagenomics: What Changes in Your Workflow?
                                  by kinpict.com
                                  The part about this topic feels surprisingly grounded, and the details on the page is the bit that made me slow down. I’d keep <a href="https://kinpict.com/">ai family photo generator</a> bookmarked for later.
                                  Today, 06:37 PM
                                • SEQadmin2
                                  16S/ITS Profiling vs. Shotgun Metagenomics: What Changes in Your Workflow?
                                  by SEQadmin2





                                  NGS has revolutionized clinical microbiology by offering new ways to identify and surveil pathogens without prior knowledge of the target. One popular approach is 16S rRNA and ITS amplicon sequencing, which targets specific microbial markers. But studies are increasingly incorporating shotgun metagenomics, a technique that sequences all DNA from a sample without targeting specific microbial markers. This approach allows more detailed taxonomic classification,...
                                  10-30-2026, 06:46 AM
                                View All

                                ad_right_rmr

                                Collapse

                                News

                                Collapse
                                Topics Statistics Last Post
                                Gene Copies Once Dismissed as Junk DNA Shape Animal Adaptation and Human Disease by SEQadmin2
                                Started by SEQadmin2, 11-12-2026, 07:59 AM
                                0 responses
                                27 views
                                0 reactions
                                		 Last Post SEQadmin2
                                by SEQadmin2
                                11-12-2026, 07:59 AM  
                                WashU Medicine Study Verifies Methods for Tracking Genetic Mosaicism by SEQadmin2
                                Started by SEQadmin2, 11-05-2026, 09:25 AM
                                0 responses
                                35 views
                                0 reactions
                                		 Last Post SEQadmin2
                                by SEQadmin2
                                11-05-2026, 09:25 AM  
                                HuBMAP Portal Offers Free Access to Single-Cell Data from Healthy Human Tissues by SEQadmin2
                                Started by SEQadmin2, 11-03-2026, 11:54 AM
                                2 responses
                                56 views
                                0 reactions
                                		 Last Post kinpict.com
                                by kinpict.com
                                Today, 06:49 PM  
                                Genome Sequencing Reveals Large, Repeat-Rich DNA in Trapdoor Spider Named for Stephen Colbert by SEQadmin2
                                Started by SEQadmin2, 10-28-2026, 09:57 AM
                                0 responses
                                175 views
                                0 reactions
                                		 Last Post SEQadmin2
                                by SEQadmin2
                                10-28-2026, 09:57 AM  
                                View All
                                Working...