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
-~----------~----~----~----~------~----~------~--~---