Access Keys:
Skip to content (Access Key - 0)

MBDT

MBDT Schema and documentation:

Introduction:

MBDT (Molecular Breeding Design Tool): MBDT is a software that uses graphical genotyping and integration of genotyping, phenotyping and QTL information for marker-assisted backcrossing. It enables users to select the parents as donor and recurrent, construct a genetic ideotype composed of desirable loci and background, visualize loci and calculate percentage of recovery of the recurrent parent at each generation.

MBDT Relationships:


Description of Database Tables:

mbdt_project: It stores details of project.

Field Name Description Data type Size
project_id Unique identifier for project. int 4
pname Name of the project. varchar 50
user_id User identification. int 4
map_id Unique identifier for map. int 4
qtl_id Unique identifier for QTL. int 4
phenodataset_id Unique identifier for phenotype dataset int 4
principal_investigator Name of the principal investigator varchar 45
email Email id varchar 45
institute Name of the institute varchar 75


mbdt_generations: It stores generations of a project.

Field Name Description Data type Size
generation_id Unique identifier for generation. int 4
gname Name of the generation. varchar 50
project_id Unique identifier for project. int 4
genotypedataset_id Unique identifier for genotype dataset int 4

  

mbdt_selected_genotypes: This table stores selected germplasm and type of germplasm (either Recurrent or Donor).

Field Name Description Data type Size
sg_id Unique identifier for selected genotypes. int 4
generation_id Unique identifier for generation. int 4
gid Germplasm identifier. int 4
sg_type Type of selected germplasm either R or D. char 2


mbdt_selected_markers: This table stores foreground markers.

Field Name Description Data type Size
sm_id Unique identifier for selected markers. int 4
generation_id Unique identifier for generation. int 4
marker_id Unique identifier for marker. int 4



Downloads:

MBDT Database Script version 1.0

Adaptavist Theme Builder (3.3.3-conf210) Powered by Atlassian Confluence 2.10.3, the Enterprise Wiki.
Free theme builder license