How to create a Fasta file using info from a Excel file

I have an excel file which looks like this:

Genex AAAAA
Geney TTTTT
Genez GGGGG

How to convert it into a fasta file like:

>Genex
AAAAA
>Geney
TTTTT
>Genez
GGGGG

rna rna-seq fasta

• 16,787 views • link

updated 6.5 years ago by Mensur Dlakic

• written 6.5 years ago by 2822462298 •

What have you tried so far? Please do not expect ready made answers.

• 0 views • link

written 6.5 years ago by lakhujanivijay

1 answer

Save your Excel file as comma-delimited, say sequences.csv.

awk -F , '{print ">"$1"\n"$2}' sequences.csv > sequences.fas

• 0 views • link

written 6.5 years ago by Mensur Dlakic

More posts like this

Reasoning - Why is it invalid to compare ratios of TPMs?
written 1.4 years ago by VTh •

Dear community, my supervisor has asked me to analyse bulk RNAseq. The samples were acquired at different times in different experiments without shared controls, so …
How to generate sequence length distribution from Fasta file
written 6.5 years ago by 2822462298 •

I got a fasta file of miRNAs with sequence length ranging from 17-32. How can I generate a table of length distribution like: length count …
Query Genes within regions
written 8.3 years ago by Emilio Marmol

Hello, I want to retrieve the genes that are present within a series of regions. Say, I have a bed file with query positions such …
Query Genes within regions
written 8.3 years ago by Emilio Marmol

Hello, I want to retrieve the genes that are present within a series of regions. Say, I have a bed file with query positions such …
genomeCoverageBed for per nucleotide coverage
written 8.4 years ago by Varun Gupta

Hello, I want to get per nucleotide coverage for my particular gene (geneX) which I added in the fasta file. There are other chromosomes present …
Convert multi-allele to bi-allele
written 9.2 years ago by kelly.wang135

Hi all, I have a vcf file and several positions have multi-allele like REF=TTT ALT=T,TT,TTTT,TTTTT To my knowledge, rare variant association tools only handle bi-allele …
About Cuffcompare output
written 10.3 years ago by R.Blues

Hello everyone, I have run Cuffcompare between a reference GTF and a predicted GTF I obtained with the Cufflinks pipeline. However, I am not sure …
Cytoscape: Export all subnetworks to excel seperately
written 12.2 years ago by ancient_learner

Dear all I have a networks of 3038 nodes and 6192 edges. I have imported it into the cytoscape and have created subnetworks using Tools->network …
Transcription Factors <--> Regulated Genes Database
written 12.9 years ago by enricoferrero

Hi, I'm looking for a publicly accessible database that stores transcription factors to regulated genes relationships. Ideally, I'm looking for something like: <pre><code>TF1 geneX TF1 …
What To Do With An Error In The Fastq Illumina Quality Scores
written 16.3 years ago by Allpowerde

I have a FASTQ* file with reads from an Illumina machine and try to do the quality control filtering with the [FASTX-Toolkit][1] but get problems …