Custom search : type in part of the SQL query
SELECT COUNT (*)
choose from the following fields
Primary ID
Alternative Name
Chromosome
Start
End
Length
Type
CAI
Mips Class
Frame
Transposons
SAGE Tags
Expression
Overlap Genes
Inside Genes

FROM features WHERE
Display     on each page

Examples:
  • CAI>0.1 AND length BETWEEN 30 AND 100
  • type1='gene' AND (overlap_gene!='' OR inside_gene!='' OR CAI<0.1)
  • (type2='whorf' OR type3='torf') AND (transposons!=0 OR tags!=0)

  • The choices still do not fit your criteria? -- type in entire SQL statement

    Examples:

  • SELECT DISTINCT inside_gene FROM features
  • SELECT chromosome, max(expr_level) FROM features GROUP BY chromosome

  • List of fields as they are named in the database table
    name1 -- Primary ID, e.g. YAL003W or chri__1234
    name2 -- secondary name
    name3 -- name for alternate feature annotation
    chromosome -- Uppercase Roman numerals used (I - XVI)
    start -- Integer, where the orf starts, counting from first nucleotide of the chromosome
    end -- Integer, where the orf ends
    sense -- plus (+) or minus (-)
    frame -- 0, 1, or 2, counting from first nucleotide of the chromosome
    * type1 -- 'gene', only where applicable
    * type2 -- 'whorf'
    * type3 -- 'torf'
    * CAI -- Codon Adaptation Index (floating point)
    * expr_level -- Young expression level
    * transposons -- number of transposon insertions
    * tags -- SAGE tags in feature region and strand
    * mips -- MIPS class for genes, from 1 to 6 (or 'u' if undefined)
    overlap_gene -- Integer, MIPS class of overlapped gene where applicable, or Paul H.'s comments
    inside_gene -- Integer, MIPS class of overlapped gene where applicable, or Paul H.'s comments
    cebrat -- annotation by Cebrat et al.
    zhang -- simply 'BAD' if included in Zhang et al.'s list of false genes
    NT -- raw nucleotide sequence- YOU DO NOT WANT TO VIEW THIS IN A BROWSER!
    AA -- translation (excluding start and stop codons)- YOU DO NOT WANT TO VIEW THIS IN A BROWSER!
     
    * Fields considered highly informative to determine whether it is a gene