This is a test version of Biostars. For the public version, visit https://www.biostars.org.
BiomaRt Many to Many Relationship filtering

Hi all! I am hoping to get a file containing 1:1:1:1:1:1 orthologs across human, mouse, chicken, rat, rabbit, possum, and macaque. I used these BiomaRt options

Screen-Shot-2020-01-13-at-2-30-08-PM

But I have a problem.

In the CSV list that BiomaRt gave me, I have these annoying many-to-many relationships. I want each gene to only occur once throughout the species columns. Some genes however, are highly repeated. I used python to filter this list and got that only 1781 out of 1901282 lines are unique. Can someone try to give me advice on how to get orthologs across these species in a way where these annoying many-to-many relationships do not occur? I don't believe that there are 1781 genes that are orthologous to each other in these 7 species. plz help, what do I do? I am a lowly grad student with a phenomenal task. Pls help #wannacry

ensembl orthology biomart orthologs
• 1,967 views • link
updated by Ram Ram • written by iislam • iislam

Have you looked at NCBI's homologene database? You can get more or less one to one orthologs from many species. Here is an example of GAPDH gene.

• 0 views • link
written by GenoMax GenoMax

1 answer

Hi iislam,

This is possible with BioMart, although it will take a few steps. You will need to get the 1:1 orthologues between human and every other species separately, then join all files and select the lines that have every species.

In each BioMart query, you will need to add the Filter: Multi species comparisons -> Homologue filters -> Orthologous Mouse Genes -> Only

Then add the 'Mouse homology type' attribute.

You can then filter your results to only contain 1:1 ortholgues.

You can then perform this query for each species against human, then join all files and select the lines that have every species.

Best wishes

Ben Ensembl Helpdesk

• 0 views • link
written by Ben Moore Ben Moore

Log in to answer this question.

More posts like this