Hi biostars,
Am trying to generate file that contain all miRNA host genes (Name of host genes required), so I downloaded the mirna_context table from mirbase (The first field of that table links to the first field of the mirna table) and I read in some articles that is possible to generate this file using mysql database. Can any one help me how to do that using this tool please. Thank you in advance
1 answer
Assuming that these are tab-separated text files, you can do this easily with Unix/Linux join
join -1 1 -2 1 <(sort -n -t$'\t' -k1 mirna_context.txt) <(sort -n -t$'\t' -k1 mirna.txt) > joined_file
This outputs only the lines with the same value in the first field in both files . If you also want the lines that are unique in each file, you can use the -a option.
More information about join: http://unixhelp.ed.ac.uk/CGI/man-cgi?join
Log in to answer this question.
-
mirbase gff and mature fastas for custom STAR index genome?
written by RNAseqer
-
HTseq-count error
written by sanatbhadsavle •
-
How can I remove tRNA, rRNA, snoRNA from the NGS miRNA sample using RFAM
written by khq5801 •
-
Identification of piRNA/siRNAs from small RNA-seq data
written by jkkbuddika
-
MiRbase context IDs
written by GiusiG •
-
which alignment tool and which reference I should choose for miRNA-seq data analysis ?
written by jimmy_zeng
-
ExAC variant data
written by amruta.bn •
-
Mint Dataset for Human PPI
written by beingseema03 •
-
Where can I find mirna primary transcripts and their genomic coordinates?
written by Endre Bakken Stovner
-
Is It Possible To Extract Mirna Info From Transcripts.Gtf(Cufflinks) Using Mirbase Annotation?
written by Alby •
