Biology Stack Exchange is a question and answer site for biology researchers, academics, and students. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I currently have two sets of gene expression data. The first is a dataframe of genes identified by Annotation id CG numbers (for example "CG10005") in one column and a numerical variable of interest associated with each of those genes in the other (the important part is that the genes are identified by the CG number). The second dataset is this study from multiple species where genes are identified by "GLEANR" ID's like this one: "dsim_GLEANR_10060".

I would like to extract all of the values from this study for the D.melanogaster and D.simulans data, then link that to the Annotation ID's in the first dataset (to connect my variable of interest to the sex bias in expression for each species). The trouble I am having is connecting the orthologous genes within the second study to each other, and then connecting them to the CG identifiers in the first study.

Does anyone have any suggestions on resources which can be used to get this all to link up?

share|improve this question
up vote 2 down vote accepted

This is the FlyBase page for the example gene: Dsim\GD10095. There, you have a section "orthologs", linking to OrthoDB. So my suggestion is: Find the list of synonyms for D. simulans on FlyBase (perhaps here?), download the Drosophila section of OrthoDB, and finally find the 1:1 orthologs.

share|improve this answer
Thanks, I am looking at this now - I assume each gene has a unique FBgn and their orthologs are identified by the ODB6_OG_ID (?) and the species identified by DROME, DROSI, DROSE... taking just those three variables I can create a data frame of each ODB6_OG_ID in the first column and columns for each species giving its orthologous FBgn ID for each species of interest? But how do I "Find the 1:1 orthologs"? – rg255 Mar 8 '13 at 10:30
Sometimes you have a strain-specific gene duplication, which you probably want to exclude to keep things simple. So you can check for each species if there's more than one gene associated with an ODB6_OG_ID, and remove those. – Michael Kuhn Mar 8 '13 at 11:18
I got this all working after a good ol' fashioned wrestle with R today - thanks a lot for the help! – rg255 Mar 11 '13 at 20:02

You could also use biomart for this purposes.

Click on the "ID Converter" tab in the "Tools" section (on the left).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.