Unconfigured Ad

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • morning latte
    Member
    • Jun 2013
    • 91
    #1

    Command for vlookup function

    Hello experts,

    I have large text files that need to be arranged using a function like excel's vlookup. I have been playing with awk command but didn't really come up with a solution. Could anyone please help me out? Below are my datasets and expected output. Any help would be greatly appreciated.

    <File 1>
    contig-100_1 5
    contig-100_30 10
    contig-100_50 20
    contig-100_40 15
    contig-100_60 25

    <File 2>
    contig-100_1 "Bacteria"
    contig-100_50 "Bacteria A"
    contig-100_60 "Bacteria A, Fungi B"

    <Expected output>
    contig-100_1 5 Bacteria
    contig-100_30 10 NA
    contig-100_50 20 Bacteria A
    contig-100_40 15 NA
    contig-100_60 25 Bacteria A, Fungi B
    Tags: None
  • lindenb
    Senior Member
    • Apr 2010
    • 143
    #2
    you're looking for the 'join' command : http://linux.die.net/man/1/join

    Comment

    Previous template Next

    Latest Articles

    Collapse
    • SEQadmin2
      Nine Things a Sample Prep Scientist Thinks About Before Sequencing
      by SEQadmin2


      I’m not a sequencing expert. I’m a purification scientist who uses NGS to evaluate workflows my group develops. With this perspective, we think about the sample first and the NGS workflow second. The sequencer is an exceptionally honest reporter, but it can only report on what you give it, so whether you get clean, interpretable data from an NGS workflow is largely determined before you begin.

      Here are nine questions we think about, in roughly the order they matter, before...
      06-18-2026, 07:11 AM
    • SEQadmin2
      From Collection to Sequencing: Why Sample Preparation and Preservation Define Sequencing Data
      by SEQadmin2


      Data variability is still an issue in sequencing technologies despite the advances in reproducibility and accuracy of these platforms. But the problem does not originate in the sequencing itself, but in the previous steps, before the sample reaches the sequencer.

      The first step is collection, followed by preservation and sample preparation for analysis. Most scientists overlook those steps, but not being careful might just be skewing the experiment’s results.
      ...
      06-02-2026, 10:05 AM
    View All

    ad_right_rmr

    Collapse

    News

    Collapse
    Topics Statistics Last Post
    New AI Model Captures Long-Range Genomic Signals to Improve RNA Splice Site Prediction by SEQadmin2
    Started by SEQadmin2, Today, 05:37 AM
    0 responses
    5 views
    0 reactions
    		 Last Post SEQadmin2
    by SEQadmin2
    Today, 05:37 AM  
    Large-Scale Protein Screen Uncovers Hidden Regulators of Alternative Polyadenylation by SEQadmin2
    Started by SEQadmin2, 06-26-2026, 11:10 AM
    0 responses
    16 views
    0 reactions
    		 Last Post SEQadmin2
    by SEQadmin2
    06-26-2026, 11:10 AM  
    Whole-Genome Sequencing Traces Faroe Islands Ancestry to a North Atlantic Founder Population by SEQadmin2
    Started by SEQadmin2, 06-17-2026, 06:09 AM
    0 responses
    49 views
    0 reactions
    		 Last Post SEQadmin2
    by SEQadmin2
    06-17-2026, 06:09 AM  
    Sequencing the Two-Toed Sloth Genome Reveals Jumping Genes Tied to Its Extreme Metabolism by SEQadmin2
    Started by SEQadmin2, 06-09-2026, 11:58 AM
    0 responses
    109 views
    0 reactions
    		 Last Post SEQadmin2
    by SEQadmin2
    06-09-2026, 11:58 AM  
    View All
    Working...