Input your SELECT query here.

TassDB Database Model: can be found here

Example SQL queries:

Count the number of confirmed GYNGYNs for mouse:

SELECT count(distinct SS2Tr2SED.SpliceSiteID)
FROM Gene G, Transcript T, SS2Transcript2SED SS2Tr2SED, SpliceSite SS, SpliceEventData SED
WHERE G.ID = T.GeneID  AND  T.ID = SS2Tr2SED.TranscriptID  AND  SS2Tr2SED.SpliceSiteID = SS.ID  AND  SS2Tr2SED.SpliceEventDataID = SED.ID
        AND SS.Type = 'donor'
        AND SED.NumEESTs >= 1 AND SED.NumIESTs >= 1
        AND G.species = 'Mus musculus';


Show all human CAGCAGs that are confirmed according to the exon-intron structure of one transcript but not confirmed according to another transcript:

SELECT distinct G.Symbol, SS.pattern, SS2Tr2SED.SpliceSiteID, SED.NumEEsts as SED_E_EST,  SED.NumIEsts  as SED_I_EST,  SED1.NumEEsts  as SED1_E_EST, SED1.NumIEsts  as SED1_I_EST
FROM Gene G, Transcript T, SS2Transcript2SED SS2Tr2SED, SS2Transcript2SED SS2Tr2SED1, SpliceSite SS, SpliceEventData SED, SpliceEventData SED1
WHERE  G.ID = T.GeneID  AND  T.ID = SS2Tr2SED.TranscriptID  AND  SS2Tr2SED.SpliceSiteID = SS.ID  AND  SS2Tr2SED1.SpliceSiteID = SS.ID 
            AND  SS2Tr2SED.SpliceEventDataID = SED.ID AND SS2Tr2SED1.SpliceEventDataID = SED1.ID
        AND  SS.Type = 'acceptor' 
        AND SED.NumEESTs >= 1  AND  SED.NumIESTs >= 1
        AND ((SED1.NumEESTs >= 1  AND  SED1.NumIESTs = 0 ) OR (SED1.NumEESTs = 0  AND  SED1.NumIESTs >= 1))
        AND SS.pattern = 'CAGCAG'
        AND G.Species = 'Homo sapiens';

Show all confirmed human CAGCAGs that are in the UTR according to the annotation of one transcript and in the CDS in another transcript:

SELECT distinct G.Symbol, SS.pattern, SS2Tr2SED.SpliceSiteID, SED.phaseutr as SED_PhaseUTR, SED.proteinimpact as SED_ProteinImpact, SED1.phaseutr as SED1_PhaseUTR,  SED1.proteinimpact as SED1_ProteinImpact
FROM Gene G, Transcript T, SS2Transcript2SED SS2Tr2SED, SS2Transcript2SED SS2Tr2SED1, SpliceSite SS, SpliceEventData SED, SpliceEventData SED1
WHERE  G.ID = T.GeneID  AND  T.ID = SS2Tr2SED.TranscriptID  AND  SS2Tr2SED.SpliceSiteID = SS.ID  AND  SS2Tr2SED1.SpliceSiteID = SS.ID 
            AND  SS2Tr2SED.SpliceEventDataID = SED.ID AND SS2Tr2SED1.SpliceEventDataID = SED1.ID
        AND SS.Type = 'acceptor'  AND  SED.phaseUTR like '%phase%' AND SED1.phaseUTR like '%UTR%'
        AND SED.NumEESTs >= 1  AND  SED.NumIESTs >= 1
        AND SED1.NumEESTs >= 1  AND  SED1.NumIESTs >= 1
        AND G.Species = 'Homo sapiens';