Seqanswers Leaderboard Ad

Collapse

Announcement

Collapse
No announcement yet.
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • why doesn't this linux command work for me?

    Hi every one,
    I'd like merging the following two HTSeq-count outputs using the following command--- paste UHR1_htseq-count.out UHR2_htseq-count.out brain1_htseq-
    count.out brain2_htseq-count.out | awk -F "\t" '{print
    $1"\t"$2"\t"$4"\t"$6"\t"$8 }' > All_htseqCounts.txt


    head UHR1_htseq-count.out
    A1BG 67
    A1CF 31
    A2BP 3

    head UHR2_htseq-count.out
    A1BG 67
    A1CF 39
    A2BP 1
    -----
    I got the following output.

    A1BG 67 A1BG 67
    A1CF 31 A1CF 39
    A2BP 3 A2BP 1
    ----
    In fact I want to get the folloing one.

    A1BG 67 67
    A1CF 31 39
    A2BP 3 1

    Is there any one who know what is wrong with the command?

    Thanks a lot?

    Richard

  • #2
    paste file1 file2 | awk '{print $1" "$2" "$4}'

    Comment


    • #3
      Richard,
      I still got the same output---just merged the two files with ID of each kept.

      Comment


      • #4
        Perhaps tab isn't the default delimiter for paste on your system? Maybe then

        Code:
        paste -d "\t" file1 file2 | awk '{OFS="\t"; print $1,$2,$4}'
        Alternatively, perhaps the files aren't actually tab delimited to begin with (try running "cut -f 1" on one of them).

        Comment


        • #5
          Are you using bash?
          Run this command ...

          set | grep FS

          Also, look at the actual bytes ...
          od -x UHR1_htseq-count.out | head

          to see if that's a space or a tab.

          Comment

          Latest Articles

          Collapse

          • seqadmin
            Genetic Variation in Immunogenetics and Antibody Diversity
            by seqadmin



            The field of immunogenetics explores how genetic variations influence immune responses and susceptibility to disease. In a recent SEQanswers webinar, Oscar Rodriguez, Ph.D., Postdoctoral Researcher at the University of Louisville, and Ruben Martínez Barricarte, Ph.D., Assistant Professor of Medicine at Vanderbilt University, shared recent advancements in immunogenetics. This article discusses their research on genetic variation in antibody loci, antibody production processes,...
            11-06-2024, 07:24 PM
          • seqadmin
            Choosing Between NGS and qPCR
            by seqadmin



            Next-generation sequencing (NGS) and quantitative polymerase chain reaction (qPCR) are essential techniques for investigating the genome, transcriptome, and epigenome. In many cases, choosing the appropriate technique is straightforward, but in others, it can be more challenging to determine the most effective option. A simple distinction is that smaller, more focused projects are typically better suited for qPCR, while larger, more complex datasets benefit from NGS. However,...
            10-18-2024, 07:11 AM

          ad_right_rmr

          Collapse

          News

          Collapse

          Topics Statistics Last Post
          Started by seqadmin, 11-08-2024, 11:09 AM
          0 responses
          224 views
          0 likes
          Last Post seqadmin  
          Started by seqadmin, 11-08-2024, 06:13 AM
          0 responses
          166 views
          0 likes
          Last Post seqadmin  
          Started by seqadmin, 11-01-2024, 06:09 AM
          0 responses
          80 views
          0 likes
          Last Post seqadmin  
          Started by seqadmin, 10-30-2024, 05:31 AM
          0 responses
          27 views
          0 likes
          Last Post seqadmin  
          Working...
          X