Skip to main content
. 2003 Jan 1;31(1):106–108. doi: 10.1093/nar/gkg002

Table 1A. Model of MySQL table which is used for storing microsatellites information.

Field Type Null Key Default Extra
Motif varchar (15) YES   NULL  
Repeat int (2) YES   NULL  
Sp int (11) YES   NULL  
Ep int (11) YES   NULL  
Region char (1) YES   NULL  
Strand char (1) YES   NULL  

First field (Motif) is for storing motif sequence.

Second field (Repeat) is for repeat length.

Third field (Sp) is for starting position of repeat.

Fourth field (Ep) is for ending position of repeat.

Fifth field (Region) for coding and non-coding information.

Sixth field (Strand) for coding strand (+ or −).