Changeset 16268

Show
Ignore:
Timestamp:
21/07/08 15:42:27 (1 month ago)
Author:
julie
Message:

updated precomputed query. replaced datasource with dataset

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/flymine/dbmodel/resources/genomic_precompute.properties

    r15214 r16268  
    88precompute.query.4 = SELECT a1_.id AS a3_, a2_.value AS a4_, a5_.shortName as a6_ FROM org.flymine.model.genomic.BioEntity AS a1_, org.flymine.model.genomic.Synonym AS a2_, org.flymine.model.genomic.Organism AS a5_ WHERE (a1_.synonyms CONTAINS a2_ AND a2_.isPrimary = false AND a1_.organism CONTAINS a5_) 
    99 
    10 # gene/protein --> organism [used by some widgets]  
     10# gene/protein --> organism [used by some widgets] 
    1111precompute.query.5 = SELECT a1_.id as a3_, a2_.name AS a4_ FROM org.flymine.model.genomic.Gene AS a1_, org.flymine.model.genomic.Organism AS a2_ WHERE a1_.organism CONTAINS a2_ 
    1212 
    1313precompute.query.6 = SELECT a1_.id AS a3_, a2_.name AS a4_ FROM org.flymine.model.genomic.Protein AS a1_, org.flymine.model.genomic.Organism AS a2_ WHERE a1_.organism CONTAINS a2_ 
    14      
     14 
    1515# chromosome distribution widget 
    1616precompute.query.7 = SELECT a2_.id as a4_, a1_.primaryIdentifier AS a5_, a2_.primaryIdentifier AS a6_,  a3_.name as a7_ FROM org.flymine.model.genomic.Chromosome AS a1_, org.flymine.model.genomic.LocatedSequenceFeature AS a2_, org.flymine.model.genomic.Organism AS a3_ WHERE (a2_.chromosome CONTAINS a1_ AND a2_.organism CONTAINS a3_) 
    17                    
    18 precompute.query.8 = SELECT a3_.primaryIdentifier AS a1_, a4_.primaryIdentifier AS a2_, a4_.id as a6_, a5_.name as a7_ FROM org.flymine.model.genomic.Chromosome AS a3_, org.flymine.model.genomic.LocatedSequenceFeature AS a4_, org.flymine.model.genomic.Organism AS a5_ WHERE (a4_.chromosome CONTAINS a3_ AND a4_.organism CONTAINS a5_)   
    1917 
    20 precompute.query.9 = SELECT a5_.name AS a1_, a3_.primaryIdentifier AS a6_, COUNT(*) AS a2_ FROM org.flymine.model.genomic.Chromosome AS a3_, org.flymine.model.genomic.LocatedSequenceFeature AS a4_, org.flymine.model.genomic.Organism AS a5_ WHERE (a4_.chromosome CONTAINS a3_ AND a4_.organism CONTAINS a5_) GROUP BY a5_.name, a3_.primaryIdentifier  
     18precompute.query.8 = SELECT a3_.primaryIdentifier AS a1_, a4_.primaryIdentifier AS a2_, a4_.id as a6_, a5_.name as a7_ FROM org.flymine.model.genomic.Chromosome AS a3_, org.flymine.model.genomic.LocatedSequenceFeature AS a4_, org.flymine.model.genomic.Organism AS a5_ WHERE (a4_.chromosome CONTAINS a3_ AND a4_.organism CONTAINS a5_) 
     19 
     20precompute.query.9 = SELECT a5_.name AS a1_, a3_.primaryIdentifier AS a6_, COUNT(*) AS a2_ FROM org.flymine.model.genomic.Chromosome AS a3_, org.flymine.model.genomic.LocatedSequenceFeature AS a4_, org.flymine.model.genomic.Organism AS a5_ WHERE (a4_.chromosome CONTAINS a3_ AND a4_.organism CONTAINS a5_) GROUP BY a5_.name, a3_.primaryIdentifier 
    2121 
    2222# FlyAtlas widget query 
    …… 
    2424 
    2525# fly-fish & BDGP widget 
    26 precompute.query.11 = SELECT a2_.id as a4_, a3_.title as a5_, a1_.expressed AS a6_, a1_.stageRange AS a7_, a2_.primaryIdentifier AS a8_ FROM org.flymine.model.genomic.MRNAExpressionResult AS a1_, org.flymine.model.genomic.Gene AS a2_, org.flymine.model.genomic.DataSet AS a3_ WHERE a2_.mRNAExpressionResults CONTAINS a1_ AND a1_.source CONTAINS a3_ 
     26precompute.query.11 = SELECT a2_.id as a4_, a3_.title as a5_, a1_.expressed AS a6_, a1_.stageRange AS a7_, a2_.primaryIdentifier AS a8_ FROM org.flymine.model.genomic.MRNAExpressionResult AS a1_, org.flymine.model.genomic.Gene AS a2_, org.flymine.model.genomic.DataSet AS a3_ WHERE a2_.mRNAExpressionResults CONTAINS a1_ AND a1_.dataSet CONTAINS a3_ 
    2727 
    28 precompute.query.12 = SELECT a3_.id AS a6_, a1_.id AS a7_, a1_.name AS a8_, a5_.name AS a9_ FROM MRNAExpressionTerm AS a1_, MRNAExpressionResult AS a2_, Gene AS a3_, DataSet AS a4_, Organism AS a5_ WHERE a3_.organism CONTAINS a5_ AND a3_.mRNAExpressionResults CONTAINS a2_ AND a2_.expressed = true AND a2_.mRNAExpressionTerms CONTAINS a1_ AND a2_.source CONTAINS a4_ AND LOWER(a4_.title) = 'bdgp in situ data set' 
     28precompute.query.12 = SELECT a3_.id AS a6_, a1_.id AS a7_, a1_.name AS a8_, a5_.name AS a9_ FROM MRNAExpressionTerm AS a1_, MRNAExpressionResult AS a2_, Gene AS a3_, DataSet AS a4_, Organism AS a5_ WHERE a3_.organism CONTAINS a5_ AND a3_.mRNAExpressionResults CONTAINS a2_ AND a2_.expressed = true AND a2_.mRNAExpressionTerms CONTAINS a1_ AND a2_.dataSet CONTAINS a4_ AND LOWER(a4_.title) = 'bdgp in situ data set' 
    2929 
    3030# KEGG pathway widget query 
    …… 
    4343precompute.query.18 = SELECT a1_.id as a6_, a2_.pubMedId AS a4_, a2_.title AS a5_, a3_.name as a7_ FROM org.flymine.model.genomic.Gene AS a1_, org.flymine.model.genomic.Publication AS a2_, org.flymine.model.genomic.Organism AS a3_ WHERE (a1_.organism CONTAINS a3_ AND a1_.publications CONTAINS a2_) 
    4444 
    45 precompute.query.19 = SELECT a3_.name AS organismname, COUNT(*) AS a4_ FROM org.flymine.model.genomic.Gene AS a1_, org.flymine.model.genomic.Publication AS a2_, org.flymine.model.genomic.Organism AS a3_ WHERE a1_.organism CONTAINS a3_ AND a1_.publications CONTAINS a2_ GROUP BY a3_.name  
     45precompute.query.19 = SELECT a3_.name AS organismname, COUNT(*) AS a4_ FROM org.flymine.model.genomic.Gene AS a1_, org.flymine.model.genomic.Publication AS a2_, org.flymine.model.genomic.Organism AS a3_ WHERE a1_.organism CONTAINS a3_ AND a1_.publications CONTAINS a2_ GROUP BY a3_.name 
    4646 
    4747precompute.query.20 = SELECT a1_.id AS a4_, a3_.name AS a5_ FROM org.flymine.model.genomic.Gene AS a1_, org.flymine.model.genomic.Publication AS a2_, org.flymine.model.genomic.Organism AS a3_ WHERE a1_.organism CONTAINS a3_ AND a1_.publications CONTAINS a2_ 
    48          
     48 
    4949precompute.query.21 = SELECT a1_.id AS a4_, a3_.name AS a5_, a2_.pubMedId AS a6_, a2_.title AS a7_ FROM org.flymine.model.genomic.Gene AS a1_, org.flymine.model.genomic.Publication AS a2_, org.flymine.model.genomic.Organism AS a3_ WHERE a1_.organism CONTAINS a3_ AND a1_.publications CONTAINS a2_ 
    5050 
    …… 
    8787precompute.query.38 = SELECT a4_.genes AS a5_, a3_.name AS a6_ FROM Gene AS a1_, GOAnnotation AS a2_, Organism AS a3_, Protein AS a4_ WHERE a1_.allGoAnnotation CONTAINS a2_ AND a4_.organism CONTAINS a3_ AND a4_.genes CONTAINS a1_ 
    8888 
    89 # tiffin  
    90 precompute.query.39 = SELECT a1_.id AS a7_ FROM Gene AS a1_, IntergenicRegion AS a2_, TFBindingSite AS a3_, DataSet AS a4_, Motif AS a5_, Organism AS a6_ WHERE a1_.organism CONTAINS a6_ AND a1_.upstreamIntergenicRegion CONTAINS a2_ AND a2_.overlappingFeatures CONTAINS a3_ AND a3_.evidence CONTAINS a4_ AND a3_.motif CONTAINS a5_ AND a4_.title = 'Tiffin')  
     89# tiffin 
     90precompute.query.39 = SELECT a1_.id AS a7_ FROM Gene AS a1_, IntergenicRegion AS a2_, TFBindingSite AS a3_, DataSet AS a4_, Motif AS a5_, Organism AS a6_ WHERE a1_.organism CONTAINS a6_ AND a1_.upstreamIntergenicRegion CONTAINS a2_ AND a2_.overlappingFeatures CONTAINS a3_ AND a3_.evidence CONTAINS a4_ AND a3_.motif CONTAINS a5_ AND a4_.title = 'Tiffin') 
    9191 
    9292