Re: [GUSDEV] Preliminary 3.5 Schema

[<ju...@cs...>]

What is the rationale behind DoTS.ExternalNASequence
and DoTS.ExternalAASequence having the column:

          NAME        STRING(255)

and this column being missing from DoTS.NASequence and
DoTS.AASequence?

As I have written before, I would find it useful for query
and display purposes, to be able to refer to a sequence by a shorter
handle then something that would go into the

         DESCRIPTION   STRING(2000)

column.  Perhaps there is an intended use for DoTS.ExternalNASequence.name
that is not clear to me?

Also, we at the Preuss Lab have a need to store base quality scores
associated with many of our local sequences, and I wonder if such an
extension as the following could be added:


  DoTS::NAFragment extends DoTS.NASequence
  ----------------------------------------------------

  scores                        clob(4000)
  primer                        varchar2(255)
  plate_number                  varchar2(255)
  well_number                   varchar2(255)
  chromatogram                  varchar2(255)
  library_id                    DoTS::Library
  orientation                   number(12)
  create_date                   date(7)

the most important column being "scores clob(4000)".


Thank you.


Josef



Josef Jurek, Ph.D.

Daphne Preuss Laboratory
Molecular Genetics and Cell Biology
The University of Chicago
ju...@cs...

voice: (773) 834-3985
fax:   (773) 702-6648