search

lorainelab / TableView

This repo contains source code for TableView, originally developed by Jim Johnson and colleagues at the University of Minnesota. To view the original paper on TableView, click the wiki link. Developers in the Loraine lab are in the process of updating the code, posting documentation, and supporting TableView so that many more people can use it.
http://transvar.org/TableView.html
1 stars 2 forks source link

test database access using UCSC MySQL #6

Open lorainelab opened 11 years ago

lorainelab commented 11 years ago

See: http://genome.ucsc.edu/FAQ/FAQdownloads.html#download29

Test database access and make sure that the tableview works

Try:

Database: hg19 Primary Table: phyloP46wayPrimates

See: http://genome.ucsc.edu/cgi-bin/hgTables

Clade: Mammal Genome: Human assembly: Feb 2009 Group: comparative genomics track: conservation table: Primate cons (phyloP46wayPrimates)

click describe table scheme to create SQL query

example:

select chrom, chromstart, chromend,sumData from phyloP46wayPrimates where chrom="chr22"

AnujPuram commented 11 years ago

Tested with all the databases Tableview works fine