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
                                • SEQadmin2
                                  New Genomics Technologies Take Aim at Long-Standing Limits
                                  by SEQadmin2


                                  Researchers using sequencing and genomics tools often have to make trade-offs. They can choose between speed or scale, short reads or long-range information, or targeted panels or a view of the whole transcriptome. New technologies that have been released this year are built to address those tough choices.

                                  We asked six companies the same four questions to learn about their latest products. The new technologies bring a lot to the table, including rethinking sequencing                                  ...
                                  Today, 10:25 AM
                                • SEQadmin2
                                  How Immunogenomics Decodes Immunity’s Genetic Blueprint
                                  by SEQadmin2




                                  The immune system’s power comes from its genetic diversity, allowing myriad threats to be neutralized through first recognizing foreign antigens. That diversity is also what makes the immune system so difficult to study. Recent advances in sequencing technology and computational biology, however, are giving researchers new tools to understand immune responses and immune-related diseases in greater detail.

                                  This convergence of genetics, immunology, and computation...
                                  09-01-2026, 05:41 AM
                                View All

                                ad_right_rmr

                                Collapse

                                News

                                Collapse
                                Topics Statistics Last Post
                                Bat1K Consortium Combines Genomes and Fossils to Trace Bat Origins by SEQadmin2
                                Started by SEQadmin2, 09-25-2026, 09:06 AM
                                0 responses
                                27 views
                                0 reactions
                                		 Last Post SEQadmin2
                                by SEQadmin2
                                09-25-2026, 09:06 AM  
                                Microgravity Experiments Reveal Gravity’s Impact on Human Genome Organization by SEQadmin2
                                Started by SEQadmin2, 09-23-2026, 11:05 AM
                                0 responses
                                24 views
                                0 reactions
                                		 Last Post SEQadmin2
                                by SEQadmin2
                                09-23-2026, 11:05 AM  
                                Massive Genomic Analysis Maps the Cellular Pathways Driving Psoriasis by SEQadmin2
                                Started by SEQadmin2, 09-18-2026, 11:37 AM
                                1 response
                                45 views
                                0 reactions
                                		 Last Post pekgio
                                by pekgio
                                09-21-2026, 02:04 AM  
                                Stanford Team Turns Scientific Papers into Interactive AI Agents by SEQadmin2
                                Started by SEQadmin2, 09-16-2026, 10:23 AM
                                1 response
                                55 views
                                0 reactions
                                		 Last Post pekgio
                                by pekgio
                                09-21-2026, 02:12 AM  
                                View All
                                Working...