On Tue, Sep 9, 2008 at 1:15 PM, Christopher Lee <[EMAIL PROTECTED]> wrote:

>
>
>
>
> >
> > Once again, I think the best starting point is for you to highlight
> the specific SQL expressions or Python code that you had to write to
> get your desired results, then I can figure out how to make SQLGraph
> do that for you.
>

gene->transcript:

>
> the specific SQL expressions


'select  *  from transcript where gene_id = geneID'


> or Python code


 t = self.transcriptDB.select('where gene_id = %s', (geneID))

transcript->gene:

geneID = transcript.gene_id


translation->transcript:

transcriptID = translation.transcript_id

transcript->translation:

Note:  It is possible that a transcript does not have a translation.

 def __getitem__(self, k):
        transcriptID = k.id
        t = self.translationDB.select('where transcript_id = %s',
(transcriptID))
        translations = []
        for row in t:
            translations.append(row)
        n = len(translations)
        if n == 0:
            print 'This transcript is not translateable!'
        else:
            translation = translations[0]
        return translation










>
>
> If you can give me clear examples of what you need, we can get started
> on this right away.
>
> -- Chris
>
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"pygr-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/pygr-dev?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to