Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: restored missing images

...

  1. For local files, click Browse to browse to your file, or drag and drop the file into the file list box. If you select the wrong file, check the checkbox next to the file, then click Remove Selected File(s)
  2. For large files, load them from the files folder in your crop server environment. Create a new folder under the files folder, then copy the folder name to the Remote Path field. Give a unique folder name for each data file (avoid special characters in folder name. Underscore ( _ ) and hyphen ( - ) are allowed.

Image RemovedImage Added

Image RemovedImage Added

Image RemovedImage Added


  1. When loading many files with the exact same format, create a template at the end of the wizard process, then save it for future use. Use templates with caution; they do not key off matching field names, but do key off row and column positions. Ensure that when you use a template, your metadata fields and data are in the exact same columns as when your template was made.
  2. Select the file format from the File Format drop-down menu.
  3. Click Preview Data
  4. The top left-hand section of your file is now viewable in the preview section. Expand the columns to view the headers. 
  5. Select the header position from the Header Position drop-down menu. For all mapset, sample and marker files, the headers must be in the TOP position. 
  6. Select the Field header coordinate by clicking the row of the column headers in the file preview. The row number is returned in the Field header coordinate field. The row count starts at 0.
  7. Click Next to map data to the database fields.

...

  1. Metadata for the markers are loaded to the first two tables. The first table is called 'Marker Information' and contains key fields, but only name (Marker name) is required. The Property table can be used to store extra property fields. The user can add their own property fields in Define|Controlled Vocabulary.  Drag and drop your marker name from Data file fields to name in the Marker Information table. Drag and drop your other input file fields to the relevant fields in the marker tables. 
  2. Drag and drop fields to the third table, DS Marker Information ONLY if your file contains genotyping data and the markers will be associated with the dataset (DS). 
  3. You can parse field entries using standard separators. For example: a field entry [A/G] can be parsed out into ref using a start position of [ and end position of /, and alt using a start position of / and an end position of ]. You can also concatenate two fields together by dragging and dropping two fields from Data file fields into the Header field.
    Image Removed
    Image Added
    Image RemovedImage Added

  4. Click Next to map data to any mapset fields.
  5. Click Finish to load the file to the database.
  6. You will receive an email confirmation that says SUCCESS or FAIL ; a fail message means data has failed validation.
    Image RemovedImage Added

Loading Markers to a Mapset

...

  1. When loading markers to a mapset, the mapset and the platform that the markers belong to need to already be established. Create your Mapset in Create Mapset and the Platform in Define Platform
  2. Select Wizards | Marker Wizard.
  3. The first form in the marker wizard has several drop-down menu options for selection of entities in which to load your marker data, most of which is not used for loading markers to mapsets; you only need to select the pre-defined platform and mapset.
    Image Removed
    Image Added

  4. Select the file to load.

...

  1. Drag and drop your marker name from Data file fields to name in the Marker Information table. You do not need to complete any other fields in these tables to load a map. However, if this is the first time loading this marker list, ensure the key fields are loaded, as these cannot currently be updated. 
    Image Removed
    Image Added

  2. Click Next. The next page contains the Map Information for Linkage Group and Marker - Linkage Group, which contain fields for the position of the marker on the linkage group.
  3. For the Linkage Group table, from Data file fields, drag and drop the linkage group name to name, and the start and stop positions for the entire linkage group, if available. 
  4. For the Marker - Linkage Group table, from Data file fields, drag and drop the marker_name, linkage_group_name and the start and stop positions for the marker on the linkage group. Marker start and stop positions are the same for SNPs, since we are using on-base coordinates, however, for indels, CNVs, MNPs, and rearrangements, start and stop positions differ.
    Image Removed
    Image Added

  5. Click Finish to load the file into the database. 
  6. You are asked if you want to save a template to enable future loading of files with the same format. Note that the template uses row and column positions to load data, not field headers, so ensure files loaded with the template have exactly the same order of fields in the file.