RDP MIMARKS GoogleSheet -- manage your metadata
RDP supports the Genomic Standards Consortium's Minimum Information about a MARKer gene Sequence (MIMARKS) Project -- "a consensus on an ideal and minimum set of contextual data that should be reported for marker genes." [Yilmaz P., R. Kottman, D. Field, R. Knight, J. R. Cole, L. Amaral-Zettler et al. (2011). The “Minimum Information about a MARKer gene Sequence” (MIMARKS) checklist: Capturing contextual data about marker gene sequences and introducing MIxS, a unified standard for sequence checklist development including environmental data. Nat Biotechnol.; accepted 18 February 2011.]
More information can be found on the MIMARKS homepage where you can also find other projects promoting the MIMARKS standards like Terragenome (International Soil Metagenome Sequencing Consortium).
RDP Support for Metadata Standards
RDP developed the MIMARKS GoogleSheet to
help you manage the metatdata for your samples!
Why a Google spreadsheet?
- Preloaded with MIMARKS-compliant attributes
- Easy to use, no computer IT infrastructure required
- Access from anywhere using any web device
- Manage data over time / monitor revision history
- Share with your collaborators
- Works with submission tools (Sequin and WebIN)
RDP welcomes any feedback on this project --
email email@example.com with your comments or suggestions.
INSTRUCTIONS FOR USING OUR MIMARKS GoogleSheet:
- FOLLOW THIS LINK to load the RDP_MIMARKS Google spreadsheet
You will need to "Sign in" to your Google account (upper right hand corner) in order to activate the menus. Use "File, Make a Copy" to get your own spreadsheet. DO NOT download or copy into an Excel spreadsheet as you will lose all embedded definition comments and validations. THIS COPY WILL NOW BE YOUR OWN Google Spreadsheet to edit and share/protect as you see fit.
- CHOOSE THE ENVIRONMENTAL PACKAGE FOR YOUR SAMPLES FROM THE TABS AT THE BOTTOM OF YOUR COPIED GOOGLE SPREADSHEET
Miscellaneous Natural or
All 14 preconfigured MIMARKS environmental packages are included as worksheets.
Choose the environmental package relevant to your research. Copy the user input Columns (C and D) for each of your samples (embedded validation will also copy within the sheet). You can choose to delete any of the worksheets not relevant to your research with the drop down menu that appears when you click on the tab. (Be sure to examine the other menu options here also.)
- ENTER YOUR METADATA
There should be a User Input Template and Units Template column for each sample you would like to manage. Do not enter data into any cells other than those in the "User Input" or "Units" column. You may change the column heading of the copied User Input columns to contain your sample names. All rows containing mandatory attributes and cells requiring a unit entry are highlighted in orange.
- You can ADD ROWS for non-MIMARKS metadata you would like to collect
(CAUTION: duplicate structured_comment_names and item names are not allowed in the submission packages).
- STORE / SHARE with your collaborators
Share your google spreadsheet with your research colleagues to view or view and edit according to your needs.
- EXPORT your MIMARKS-compliant data
After you collect your metadata, you can export your MIMARKS-compliant data by selecting the menu item "MIMARKS Export". Choose your desired output: WebIN or Sequin in RDP_MIMARKS v. 0.1. Use our added MIMARKS Export tab and select your desired format. You may need to give permission to run the script. A new window will open with your results as text to be copied and pasted into a text file for your submisssion.
Col. A = Structured Comment Name: name of a checklist item as it will appear in GenBank structured comments.
Col. B = Item (attribute): full name of item as it appears in the publication. Note: definitions (a description of the item, including links to ontologies and other resources that can be used to fill in values for the item) appear in the embedded comments of this column.
Col. C = User Input Template: Validated input column for user data. It is set up to help you by validating (verifying) your input according to MIMARKS requirements. Once copied for your samples, you can replace "User Input Template" with your sample name as the header.
Col. D = Units Template: Lists the MIMARKS standard units for each entry. (Required user input is designated by orange boxes.)