Changes between Initial Version and Version 1 of DataWizard

2010-10-01T23:38:13+02:00 (10 years ago)



  • DataWizard

    v1 v1  
     2= Using the Data Import Wizard =
     4We provide an example data set to demonstrate how to use the data import wizard here (
     5[ download])
     6This zip file contains an example dataset with the following components:
     9 * individuals.txt
     10 * markers.txt
     11 * metabolites.txt
     12 * species.txt
     13 * strain.txt
     16 * investigation.txt
     17 * publication.txt
     18 * data.txt
     21 * data/genotypes.txt
     22 * data/metaboliteexpression.txt
     24See XgapFormatTutorial on how to create such files. Note that for the data wizard you don't need 'data.txt', 'investigation.txt' and '' because these are created for you by the wizard.
     26The following steps will result in a succesfull import:
     28== Step 1: Configure your import ==
     30You will see the following screen when you start the import wizard with empty XGAP database:
     34=== In box 1: Select constant properties ===
     36 * Create a new investigation called "!MetaMetwork". Use "New investigation:" -> "Create".
     38=== In box 2: Select subject and trait annotations for import, update or remove ===
     40Tick the following boxes:
     42 * Individuals
     43 * Markers
     44 * Metabolites
     45 * Species
     46 * Strain
     47 * Bibliographic reference
     49=== In box 3: Select data matrices for import ===
     51Use the dropdown box to select "2".
     53Since we are adding the annotations, we use the default settings of matrices that include auto detection of the dimensions of your data, that is, what is denoted by the row headers and column headers in your data matrices. Based on available annotations XGAP tries to guess a suitable 'data.txt' as described in XgapFormatTutorial for you. In this case the guessed dimensions of the matrix should be rowtype='markers' x coltype='individuals' and in case of metabolite expressions this wil be rowtype='metabolites' x coltype='individuals'.
     55Should the guessing fail (for example, your matrix contains both numbers and text data, the wizard guesses 'decimal', and it errors later on) you can always go back and set corrections manually.
     57The screen should look like this:
     61Note: if there were already investigations present, the startup screen would have looked like this. To add the data to investigation 'MetaNetwork', you would still had to create it first. Newly created investigations are directly selected in the dropdown list.
     63== Step 2: Import the data files ==
     65After configuration of you import, you will see the a screen that allows you to choose the files to be imported. For each of the provided options browse to the files as shown. Then push import.
     69== Step 3: Inspect results ==
     71When succesful you will be shown a report of the import. If any file contains errors or is inconsistent then informative errors will be shown. An example result: