the datafile is in 'fasta' format, but you use notepad to view them
here is one example of the datafile viewed on notepad:
The datafiles are somewhat 'stacked' together. shown here are two of them...but there's more..like thousands!
the '>' symbol tells you that it is the beginning of each data.
the sentence after the '>' for eg :
(CONTIG2 1 members, constructed from AI676591)
and those (CGATTTAGATAGCCT.......) letters are the fields of the data. (field # 1 and 2 are separated by comma ',' whereas field # 3 are placed on the second line after the first two field.
then comes the next part, the database! to build this database, i simply just install PHPTriad into my PC. I got this program, which is free from PHPGeek.com
My PHPTriad is ver2.11 for windows. Then, i run the APACHE server which is bundled inside the triad program.(The prgrm contains MySQL, Apache server and PHP). Next, i run the winmysqladmin from C:\apache\mysql\bin and start standalone mysql server.
after that, i open a web browser and type on the address bar.The database interface will appear. Then. all i have to do is to just enter the databse name that i want to create and click on 'create' button. Basically, these program use web interface and you dont have to use the command prompt almost at all!
Just point, click and sometimes, type.
Then, what i did next is to create the tables and fields inside the tables and start inputting the data. The field names are the same in each table. i named the first table as : ID
second field : Accession #
third field : Sequences
As for now, what i did was to view the datafiles using notepad, select the fields (one by one!), copy the field,
then go to the database interface, select the table i need and paste the field into the table. (the table has a form-like interface)..
i wanted to just find out a way of how to dump all the datafiles into the database without select-copy-paste the datafiles one-by-one.... would you guys please help me..
i'll give more infos abt my databse when i knew the way of explaining it to you.:)(did i tell u i'm new in this business?)
I am a BEGINNER! Please hELpppp!!!!