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
                                  Multiomic Liquid Biopsy: What DNA/RNA Panels Reveal That DNA Alone Can’t
                                  by SEQadmin2



                                  Tumors contain complex mixtures of cell populations that evolve in response to treatment and host-specific factors. Tissue biopsies provide only static snapshots of a tumor’s state. But what if we could follow that evolution over time using a minimally invasive technique?

                                  Liquid biopsies can detect tumor-derived material circulating in the bloodstream, providing a way to study treatment response, detect emerging resistance, and discover new biomarkers. Circulating                                  ...
                                  10-14-2026, 09:55 AM
                                • 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                                  ...
                                  09-28-2026, 10:25 AM
                                View All

                                ad_right_rmr

                                Collapse

                                News

                                Collapse
                                Topics Statistics Last Post
                                Mayo Clinic-Led Study Detects DNA Mutations Across Noncancerous Tissues by SEQadmin2
                                Started by SEQadmin2, 10-15-2026, 10:52 AM
                                0 responses
                                17 views
                                0 reactions
                                		 Last Post SEQadmin2
                                by SEQadmin2
                                10-15-2026, 10:52 AM  
                                Study Finds Chromatin Motion Holds Steady Until Cells Face Stress by SEQadmin2
                                Started by SEQadmin2, 10-14-2026, 05:39 AM
                                0 responses
                                25 views
                                0 reactions
                                		 Last Post SEQadmin2
                                by SEQadmin2
                                10-14-2026, 05:39 AM  
                                Larger Datasets Reveal Additional Switches That Control Gene Expression by SEQadmin2
                                Started by SEQadmin2, 10-13-2026, 09:56 AM
                                0 responses
                                22 views
                                0 reactions
                                		 Last Post SEQadmin2
                                by SEQadmin2
                                10-13-2026, 09:56 AM  
                                Computational Tool Captures How Chromatin Folds at Scale by SEQadmin2
                                Started by SEQadmin2, 10-09-2026, 11:14 AM
                                0 responses
                                27 views
                                0 reactions
                                		 Last Post SEQadmin2
                                by SEQadmin2
                                10-09-2026, 11:14 AM  
                                View All
                                Working...