Login

Join for Free!
112360 members
table of contents table of contents

AppleBreed DataBase (DB) aims to store genotypic and phenotypic data from multiple …


Biology Articles » Agriculture » Plant Production » A new versatile database created for geneticists and breeders to link molecular and phenotypic data in perennial crops: the AppleBreed DataBase » Table 5

Table 5
- A new versatile database created for geneticists and breeders to link molecular and phenotypic data in perennial crops: the AppleBreed DataBase

Table 5. Content and definition of the MOL_LOCUS and MOL_MARKERS tables

Fields Definition Remarks

MOL_LOCUS table    
LOCUS_ID Locus identifier PK
LOCUS_NAME Locus name  
MARKER_ID Marker identifier FK to MOL_MARKERS
PUB_REF Published reference FK to REF_REFERENCE
ORIG_SET_REF_CV Original set reference cultivar  
ADD_INFO_LG Additional information on the linkage group  
NEW_ALLELE_VAL New allele value  
DATA_ENCODE_DATE Date of data input  
DATA_ENCODE_NAME Person who encoded the data  
INSTITUTION_ID Institution identifier FK to ORG_INSTITUTION
MOL_MARKERS table    
MARKER_ID Marker identifier PK
MARKER_NAME Marker name  
MARKER_TYPE Marker type  
FORWARD_PRIMER Forward primer-sequence  
REVERSE_PRIMER Reverse primer-sequence  
GEL_IMG_REF Reference to a gel image Link to image file
REQ_TEMP Temperature used  
LOCI_NUMBER Number of loci found for the marker  
UPDATE_SHEET Date of update  
LOCUS_STATUS Locus status  
RESEARCHER Researcher name  
PUB_REF Published reference FK to REF_REFERENCE
DATA_ENCODE_DATE Date of data input  
DATA_ENCODE_NAME Person who encoded the data  
ORIGIN_SEQ Original sequence  
ORIGIN_FORWARD_SEQ Original forward primer-sequence  
ORIGIN_REVERSE_SEQ Original reverse primer-sequence  
PCR_PROTOCOL PCR protocol used Link to protocol file

PK: primary key; FK: foreign key.


rating: 0.00 from 0 votes | updated on: 3 Aug 2008 | views: 9645 |

Rate article:







excellent!bad…