GENica
 Bioinformatics for Molecular Plant Breeding

  Home | Bioinformatics Tools | Search

ADMIN»MARKER DB IMPORT

Log in to 'GENica Marker Tools'

Contents

Description

  • Group administrators can use the ADMIN»MARKER DB IMPORT option to import SSR marker information into the MARKERS Table. This option allows providing data for every available SSR field of that table, please refer to the sections on the MARKERS Table and its VIEW options for more details.
  • Marker information that is imported with this option has to be added to an mrtmarker-type marker set. This type of marker set can be created through the [ADD MARKER SET] link on the ADMIN»MARKER DB IMPORT interface.
  • If you want to import allele size ranges only for a set of markers, and cannot provide information for the other fields in this database, please create a binner-type marker set. Please refer to the section on the MARKERS»IMPORT option for full instructions.

Back to contents


How to use this option

  1. Select an mrtmarker marker set from the "MRT Marker Set" drop-down box. If no such marker set is available, click on the [ADD SET] link to open an "Add Marker Set" interface where the new marker set's user group, name and access settings can be specified.
  2. BROWSE for the input file with the marker data and hit IMPORT to begin uploading the data.

Back to contents


The MARKER DB IMPORT input file

  • Below is an overview of the fields that can be used to import marker information into the MARKERS Table.
  • You can download a tab-delimited text file with these column headers and one line of example data (MARKER_DB_IMPORT_Input_Fields.txt) from FILES»LIST ('GENica Marker Tools' login required) to use as a template for preparing an imput file.
  • Open this downloaded template file in a spreadsheet program and enter the required information for your markers, taking guidance from the example data in the template file and the field descriptions on this page.
Marker DB Field: Data Type: Description:
Code NumberPrimary key used to identify each record in the database
Marker numberText Laboratory number of each published marker
Published marker nameTextPublished name for each marker
Marker prefixTextPrefix to identify each marker according to type
Origin of markerTextResearch group who developed the marker, or reference to the journal article in which it was published
Fwd primer sequenceTextForward primer sequence
Rvs primer sequenceTextReverse primer sequence
Type of markerTextSSR, STS, ESTSST, etc.
Chromosomal locationTextReported chromosomal location(s) of marker
Putative QTL linkagesTextReported marker/trait associations
MQTextMarker Quality score according to Stephenson et al. (1998)
MQ commentsTextAdditional comments about marker quality
OptConcNumberOptimal nanomolar primer concentration for multiplex-ready assay
ABI instrumentTextDNA fragment analyser used to characterise the marker
Dilution FactorTextFinal dilution of PCR products loaded onto the DNA fragment analyser
Desalt MethodTextMethod used to desalt the PCR products in preparation for DNA fragment analysis
SRnge1 - minNumberSize of smallest PCR fragment (in bp) for PCR fragment size range 1 - used by binning software to construct multiplex marker panels
SRnge1 - maxNumberSize of largest PCR fragment (in bp) for PCR fragment size range 1 - used by binning software to construct multiplex marker panels
SRnge2 - minNumberSize of smallest PCR fragment (in bp) for PCR fragment size range 2 - used by binning software to construct multiplex marker panels
SRnge2 - maxNumberSize of largest PCR fragment (in bp) for PCR fragment size range 2 - used by binning software to construct multiplex marker panels
SRnge3 - minNumberSize of smallest PCR fragment (in bp) for PCR fragment size range 3 - used by binning software to construct multiplex marker panels
SRnge3 - maxNumberSize of largest PCR fragment (in bp) for PCR fragment size range 3 - used by binning software to construct multiplex marker panels
SRnge4 - minNumberSize of smallest PCR fragment (in bp) for PCR fragment size range 4 - used by binning software to construct multiplex marker panels
SRnge4 - maxNumberSize of largest PCR fragment (in bp) for PCR fragment size range 4 - used by binning software to construct multiplex marker panels
Spatial VariantsText
Spatial Variants CommentsText
SRnge1 - commentText
SRnge2 - commentText
SRnge3 - commentText
SRnge4 - commentText
OpenElectHyperlinkHyperlink to JPEG image showing PCR specificity and yield for each marker

Back to contents


Links to other user manual pages

MARKERS

»SEARCH
»SETS
»IMPORT

BINNER

»MRT TAGS
»MRT UPLOAD
»SNP TAGS
»SNP UPLOAD

GEMDB

»SEARCH
»BROWSE
»CONFLICT
»IMPORT

DARTS

»SEARCH
»BROWSE
»IMPORT

SNPDB

»SEARCH
»BROWSE
»IMPORT

TAGS

»MARKERS
»GEMDB
»GEMDB SAMPLE
»DARTS
»DARTS SAMPLE
»SNPDB
»SNPDB SAMPLE

FILES

»LIST
»UPLOAD

OPTIONS ADMIN

»DASHBOARD
»SPECIES
Non-admin users:
»EDIT MY DETAILS
»MY GROUPS
Group admin users:
 »MARKER DB IMPORT
»SNP MARKER DB IMPORT
»ELECTROGRAM IMAGE UPLOAD
»USERS
»GROUPS
Selected group admin users only:
»DArT MARKER DB IMPORT

I'd rather try the tutorial...Written in August 2007


  MPBCRC logo About GENica | Wiki Login | Disclaimer