Did I find the right examples for you? yes no      Crawl my project      Python Jobs

All Samples(22)  |  Call(22)  |  Derive(0)  |  Import(0)

src/c/g/cgat-HEAD/CGATPipelines/pipeline_docs/pipeline_peakcalling/trackers/TSS.py   cgat(Download)
        if not slice or slice == "all":
            data = self.getValues(
                """SELECT %(column)s FROM %(track)s_%(table)s AS d WHERE %(where)s""" % locals() )
        else:
            data = self.getValues( """SELECT %(column)s FROM %(track)s_%(table)s AS d, %(track)s_%(annotations)s as a 
                                      WHERE d.gene_id = a.gene_id AND a.is_%(slice)s AND %(where)s""" % locals() )
        if not slice or slice == "all":
            data = self.getValues(
                """SELECT %(column)s FROM %(track)s_%(table)s AS d WHERE %(where)s""" % locals() )
        else:
            data = self.getValues( """SELECT %(column)s FROM %(track)s_%(table)s AS d, %(track)s_%(annotations)s as a 
                                      WHERE d.gene_id = a.gene_id AND a.is_%(slice)s AND %(where)s""" % locals() )

src/c/g/cgat-HEAD/CGATPipelines/pipeline_docs/pipeline_motifs/trackers/TSS.py   cgat(Download)
        if not slice or slice == "all":
            data = self.getValues(
                """SELECT %(column)s FROM %(track)s_%(table)s AS d WHERE %(where)s""" % locals() )
        else:
            data = self.getValues( """SELECT %(column)s FROM %(track)s_%(table)s AS d, %(track)s_%(annotations)s as a 
                                      WHERE d.gene_id = a.gene_id AND a.is_%(slice)s AND %(where)s""" % locals() )
        if not slice or slice == "all":
            data = self.getValues( """SELECT %(column)s FROM %(track)s_%(table)s AS d 
                                      WHERE %(where)s""" % locals() )
        else:
            data = self.getValues( """SELECT %(column)s FROM %(track)s_%(table)s AS d, 
                                      %(track)s_%(annotations)s as a 
                                      WHERE d.gene_id = a.gene_id 
                                      AND a.is_%(slice)s AND %(where)s""" % locals() )

src/c/g/cgat-HEAD/CGATPipelines/pipeline_docs/pipeline_intervals/trackers/TSS.py   cgat(Download)
        if not slice or slice == "all":
            data = self.getValues(
                """SELECT %(column)s FROM %(track)s_%(table)s AS d WHERE %(where)s""" % locals() )
        else:
            data = self.getValues( """SELECT %(column)s FROM %(track)s_%(table)s AS d, %(track)s_%(annotations)s as a 
                                      WHERE d.gene_id = a.gene_id AND a.is_%(slice)s AND %(where)s""" % locals() )
        if not slice or slice == "all":
            data = self.getValues( """SELECT %(column)s FROM %(track)s_%(table)s AS d 
                                      WHERE %(where)s""" % locals() )
        else:
            data = self.getValues( """SELECT %(column)s FROM %(track)s_%(table)s AS d, 
                                      %(track)s_%(annotations)s as a 
                                      WHERE d.gene_id = a.gene_id 
                                      AND a.is_%(slice)s AND %(where)s""" % locals() )

src/c/g/cgat-HEAD/CGATPipelines/pipeline_docs/pipeline_chipseq/trackers/TSS.py   cgat(Download)
        if not slice or slice == "all":
            data = self.getValues(
                """SELECT %(column)s FROM %(track)s_%(table)s AS d WHERE %(where)s""" % locals() )
        else:
            data = self.getValues( """SELECT %(column)s FROM %(track)s_%(table)s AS d, %(track)s_%(annotations)s as a 
                                      WHERE d.gene_id = a.gene_id AND a.is_%(slice)s AND %(where)s""" % locals() )
        if not slice or slice == "all":
            data = self.getValues(
                """SELECT %(column)s FROM %(track)s_%(table)s AS d WHERE %(where)s""" % locals() )
        else:
            data = self.getValues( """SELECT %(column)s FROM %(track)s_%(table)s AS d, %(track)s_%(annotations)s as a 
                                      WHERE d.gene_id = a.gene_id AND a.is_%(slice)s AND %(where)s""" % locals() )

src/c/g/cgat-HEAD/CGATPipelines/pipeline_docs/pipeline_chipseq/trackers/Distances.py   cgat(Download)
        if not slice or slice == "all":
            data = self.getValues(
                """SELECT %(column)s FROM %(track)s_distances AS d WHERE %(where)s""" % locals() )
        else:
            data = self.getValues( """SELECT %(column)s FROM %(track)s_distances AS d, %(track)s_%(annotations)s as a 
                                      WHERE d.gene_id = a.gene_id AND a.is_%(slice)s AND %(where)s""" % locals() )

src/c/g/cgat-HEAD/CGATPipelines/pipeline_docs/pipeline_motifs/trackers/Nucleotide.py   cgat(Download)
        if not slice or slice == "all":
            data = self.getValues(
                """SELECT %(column)s FROM %(track)s_%(table)s AS d """ % locals() )
 
        return odict(((self.mColumn, data),))
        column = self.mColumn
        rawdata = self.getValues(
            """SELECT %(column)s FROM %(track)s_%(table)s AS d """ % locals() )
        data = [float(x) for x in rawdata if x != "None"]
        return(data)

src/c/g/cgat-HEAD/CGATPipelines/pipeline_docs/pipeline_intervals/trackers/Nucleotide.py   cgat(Download)
        if not slice or slice == "all":
            data = self.getValues(
                """SELECT %(column)s FROM %(track)s_%(table)s AS d """ % locals() )
 
        return odict(((self.mColumn, data),))
        column = self.mColumn
        rawdata = self.getValues(
            """SELECT %(column)s FROM %(track)s_%(table)s AS d """ % locals() )
        data = [float(x) for x in rawdata if x != "None"]
        return(data)