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
|
