Re: [Gusdev-gusdev] GUS views

[Steve F. <sfi...@pc...>]

Sucheta-

this is covered in the GUS wiki.   its available from the gusdb site.   
since the wiki is growing, its a good idea to check there first before 
posting a question.

try to browse the wiki to find a discussion of this, or try the search. 

i am not telling you where to find it because i am curious to see if you 
can find it using the available tools.

let me know,
steve

Sucheta Tripathy wrote:

> 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