[Gmod-schema] Fitting data to Chado schema

[Inderski, B. - A. <Blake.Inderski@ARS.USDA.GOV>]

I'd like to ask for help/feedback on my data assignments to the Chado schema, as shown in the attached PowerPoint sheet.

A summary of my data fields: unique ID, source accession, strain/isolate name, strain/isolate source, genotype, author/s, collection location (country/state), collection date (day/month/year), DNA sequence, AA sequence/s, AA sequence name (open reading frame/non-structural protein), AA location.

Categories marked as '!null' cannot be left empty. I tried to piece things together as best I could using the general schema structure (http://gmod.org/wiki/Chado_Tables). I ended up using the cvterm table as a catchall for data that lacked a distinct match, since it allows for mixed characters (flexible) and is unique to cv terms (a required field). Please let me know your thoughts and if there are any ways to improve my data categorization. Thanks!

Blake





This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.