Table 1 Some of the programs that populate the database tables
Program name | Table | Behavior |
|---|---|---|
dbvor createdb | all tables defined | create a database, create auser and load schemadefinitions |
dbvor newmarker | markers | define new markers |
dbvor missingmarkerinfo | markers, marker_info | list markers without map info for the named build |
dbvor allelemap | allele_map | store genotype remapping for a marker/experiment |
dbvor marker_info | marker_info | store genetic and physical position data for a specific map build |
dbvor markeralias | marker_aliases | store alternate names for markers |
dbvor gmimarker | marker_info | store marker mapinformation presented inGenetic Map Interpolator(GMI) format [8] |
dbvor gmimarkeralias | marker_aliases | store marker aliasing data presented in GMI format |
dbvor sample | samples | store sample data andassociate it with thecorresponding members |
dbvor trait | traits, traitmeta | store trait values formembers |
dbvor member | members | store pedigree information |
dbvor memberalias | member_aliases | store alternate names for members |
dbvor create_experiment | experiments | create entry in experiment table associating ID with experiment string |
dbvor set_experiment_date | experiments | set date field ofspecified experiment inthe experiment table |
dbvor delete_experiment | experiments | delete all genotype data for the specified experiment |
dbvor set_active | genotypes | set the active flag, to turn on/off specific data |