Hi,
I did a search on the Genomes page using the ID uc003imv and the website took me to the browser page for that gene (http://genome.ucsc.edu/cgi-bin/hgTracks?org=Mouse <http://genome.ucsc.edu/cgi-bin/hgTracks?org=Mouse&db=hg18&position=uc003imv .1> &db=hg18&position=uc003imv.1). Then I clicked on the bar under the title "UCSC Genes Based on RefSeq, UniProt, GenBank, CCDS and Comparative Genomics" and was taken to this page http://genome.ucsc.edu/cgi-bin/hgGene?hgg_gene=uc003imv.2 <http://genome.ucsc.edu/cgi-bin/hgGene?hgg_gene=uc003imv.2&hgg_prot=&hgg_chr om=chr4&hgg_start=153676865&hgg_end=153679864&hgg_type=knownGene&db=hg18&hgs id=152071858> &hgg_prot=&hgg_chrom=chr4&hgg_start=153676865&hgg_end=153679864&hgg_type=kno wnGene&db=hg18&hgsid=152071858. I am interested in getting all the information from the Gene Model Information table on that page using SQL but I am unsure which tables I should be searching through. The information that I am talking about is put into a list on this page: http://genome.ucsc.edu/cgi-bin/hgGene?hgg_do_txInfoDescription=1 <http://genome.ucsc.edu/cgi-bin/hgGene?hgg_do_txInfoDescription=1&hgsid=1520 71858> &hgsid=152071858. Can you please let me know which tables I should be looking at? Also, is the txCDsPredict score calculated in real time or can I retrieve from a table in the database? I ran the following query, SELECT * FROM `information_schema`.`COLUMNS` WHERE COLUMN_NAME like '%predict%' to look for the txCdsPredict score column but had no luck. Thanks. Your help would be much appreciated. _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
