AGI_Number      Symbols Computational_description                            Chromosome     Orientation Start       End            AA_Length
AT1G75120.1     RRA1    Nucleotide-diphospho-sugar transferase family protein   chr1    REVERSE 28197022        28198656        402
AT1G17600.1             Disease resistance protein (TIR-NBS-LRR class) family   chr1    REVERSE 6053026         6056572            1049
AT1G51380.1             DEA(D/H)-box RNA helicase family protein                chr1    FORWARD 19047960        19049967        392
AT1G77370.1             Glutaredoxin family protein                         chr1    FORWARD 29073916        29074642        130
AT1G44090.1     ATGA20OX5, GA20OX5      gibberellin 20-oxidase 5                chr1    REVERSE 16760677        16762486        385

DROP TABLE IF EXISTS test_agi;

CREATE TABLE if NOT EXISTS test_agi (
    Run_ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
     AGI_Number text(30),
     Symbols text(100),
     Computational_description text(1000),
     Chromosome VARCHAR(10),
     Orientation VARCHAR(20),     
     Start INT,
     End INT,
     AA_Length INT NOT NULL
     ) ;

LOAD DATA 
     LOCAL INFILE "/home/yifang/20111210-Project-At-Br-Bd-Os-Gm/Blast-Result/At-as-subject/e10/TAIR10_representative_gene_model-cleaned.csv" 
 INTO
     TABLE test_agi 
     FIELDS TERMINATED BY '\t' 
     LINES TERMINATED BY '\n';

mysql> select Run_ID, AGI_Number, Start, End, Orientation, Chromosome from test_agi limit 10;
+--------+--------------------+----------+------+-------------+------------+
| Run_ID | AGI_Number         | Start    | End  | Orientation | Chromosome |
+--------+--------------------+----------+------+-------------+------------+
|      1 |                    | 18872570 |  671 | 18870555    | FORWARD    |
|      2 |                    | 14015508 |  181 | 14014796    | FORWARD    |
|      3 |                    | 16718656 |  577 | 16716692    | REVERSE    |
|      4 |                    |  5488494 |  352 | 5486544     | REVERSE    |
|      5 |                    | 27612182 |  254 | 27611418    | FORWARD    |
|      6 | RRA1               | 28198656 |  402 | 28197022    | REVERSE    |
|      7 |                    |  6056572 | 1049 | 6053026     | REVERSE    |
|      8 |                    | 19049967 |  392 | 19047960    | FORWARD    |
|      9 |                    | 29074642 |  130 | 29073916    | FORWARD    |
|     10 | ATGA20OX5, GA20OX5 | 16762486 |  385 | 16760677    | REVERSE    |
+--------+--------------------+----------+------+-------------+------------+
10 rows in set (0.00 sec)