Good Morning Diego: You do not need special software interfaces to fetch data from the UCSC MySQL database. As mentioned in the FAQ:
http://genome-test.cse.ucsc.edu/FAQ/FAQdownloads.html#download29 the simple command line operation mysql: mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A -e "select count(*) from snp131;" hg19 can talk to the database and fetch whatever you want from any table. To view the description of any table's contents: mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A -e "desc snp131;" hg19 You can feed the output of these commands into any processing software, or embed the commands into your system. Yes, you will need to decide what it is you want to fetch from any particular table and how you would like to relate it to another table. The UCSC Table Browser can also perform these functions, and it can display the relationships of the tables with each other. Your experiment design will clarify what relationships you desire to highlight and extract. When you work within the table browser, you can also view your results in the genome browser. You can also use the Galaxy interface: http://galaxy.psu.edu/ to organize the workflow of your experiments. The Galaxy system cooperates with the UCSC genome browser and many other bioinformatic tools to provide an integrated experiment work-flow design procedure. --Hiram Diego F Pereira wrote: > Hello Vanessa, > Is there a way in which I can connect a MSAccess database to your MySQL > database? > Or > Should I use PHP and MySQL on my computer to pull the data I need from your > MySQL database? > I have some experience with MSAccess, but by checking PHP that seems several > times easier to work with than VBA. > I had avoided to learn MySQL for long time, but if you think this is the > best way I'll definitely learn it. > Of course if you know a better/easier approach please let me know. > Many thanks in advance, > Diego > > PS: > I believe this is going to be very interesting for all the people who is > doing in-depth analyzes of the data displayed by the UCSC browser. > Therefore, even if I'm not a computer scientist I think it worth the effort. > If this works I'll be happy of sharing it with you and all the people. _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
