[Gusdev-gusdev] GUS views

[Sucheta T. <su...@vb...>]

Hello All,

I need some help in understanding the GUS views:

There are several views like : DNAREGULATORY, DNASTRUCTURE etc. in dots. 
When I look at the definition, I find that many of them share the same 
strings from the IMP tables as different names.

Now my question is what data the string1 field of NAFEATURE should hold? 
WIll it be description as in view chromosomeelementfeature or citation as 
in DNASTRUCTURE for string1.

There are many more such examples. Am I missing out something?

The first few string values are used in almost all views with different 
names. SInce I am trying to optimize the usage of GUS, Any help in this 
regard will be greatly appreciated.

SOME EXAMPLES:
***********************

ALLELEFEATURE:                                  description is string20 of 
: NAFeatureIMP
ASSEMBLY:                                              tinyint1 AS 
full_length_cds,
                                   bit1 AS CONTAINS_MRNA,
                                   int1 AS nUMBER_OF_CONTAINED_SEQUENCES,
                                   string1 AS NOTES,
                                   clob1 AS GAPPED_CONSENSUS,
                                   clob2 AS QUALITY_VALUES, ON TABLE
                                   NASequenceImp
BINDINGSITEFEATURE:                       string2 AS MODEL,  int1 AS 
MODEL_ID,
float1 AS PRIMARY_SCORE,float2 
AS                                     SECONDARY_SCORE,
                                             string1 AS SYNDROME, NAFeatureIMP

CHROMOSOMEELEMENTFEATURE: string1 AS description, int1 AS
                                   length, string2 AS chromosome_end,
                                   float1 AS percent_at, NAFeatureIMP

COLLECTIONNAFEATURE:                View on NAFeatureIMP

DNAREGULATORY:                              string1 AS CITATION, string2 AS
                                  EVIDENCE, string3 AS FUNCTION,
                                  string4 AS GENE, string5 AS LABEL,
                                  string6 AS MAP, string7 AS PARTIAL,
                                  string8 AS PHENOTYPE,  string9 AS
                                  STANDARD_NAME, string10 AS USEDIN,
                                  tinyint1 AS IS_PARTIAL NAFeatureIMP
DNASTRUCTURE:                                 string1 AS CITATION, string2 AS
                                  DIRECTION,string3 AS EVIDENCE,
                                  string4 AS FUNCTION,string5 AS GENE,
                                  string6 AS LABEL,string7 AS MAP,
                                  string8 AS PARTIAL, string9 AS
                                  PCR_CONDITIONS, string10 AS
                                  STANDARD_NAME, string11 AS USEDIN,
                                  tinyint1 AS IS_PARTIAL NAFeatureIMP

Thanks

Sucheta