Nucleic Acids Research, 2004, Vol. 32, Database issue D493-D496
© 2004 Oxford University Press
The UCSC Table Browser data retrieval tool
Center for Biomolecular Science and Engineering, University of California Santa Cruz (UCSC), School of Engineering, 1156 High Street, Santa Cruz, CA 95064-1077, USA
*To whom correspondence should be addressed. Tel: +1 831 459 1544; Fax: +1 831 459 4829; Email: donnak{at}soe.ucsc.edu
The authors wish it to be known that, in their opinion, the first two authors should be regarded as joint First Authors
The University of California Santa Cruz (UCSC) Table Browser (http://genome.ucsc.edu/cgi-bin/hgText) provides text-based access to a large collection of genome assemblies and annotation data stored in the Genome Browser Database. A flexible alternative to the graphical-based Genome Browser, this tool offers an enhanced level of query support that includes restrictions based on field values, free-form SQL queries and combined queries on multiple tables. Output can be filtered to restrict the fields and lines returned, and may be organized into one of several formats, including a simple tab- delimited file that can be loaded into a spreadsheet or database as well as advanced formats that may be uploaded into the Genome Browser as custom annotation tracks. The Table Browser User’s Guide located on the UCSC website provides instructions and detailed examples for constructing queries and configuring output.
CiteULike 
Connotea 
Del.icio.us What's this?
This article has been cited by other articles:
|
|
 |
|
  Z. Li, W. Zhang, M. Wu, S. Zhu, C. Gao, L. Sun, R. Zhang, N. Qiao, H. Xue, Y. Hu, et al. Gene expression-based classification and regulatory networks of pediatric acute lymphoblastic leukemia Blood, November 12, 2009; 114(20): 4486 - 4493. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 B. Rhead, D. Karolchik, R. M. Kuhn, A. S. Hinrichs, A. S. Zweig, P. A. Fujita, M. Diekhans, K. E. Smith, K. R. Rosenbloom, B. J. Raney, et al. The UCSC genome browser database: update 2010 Nucleic Acids Res., November 11, 2009; (2009) gkp939v1. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
A. S. Syed, M. D'Antonio, and F. D. Ciccarelli Network of Cancer Genes: a web resource to analyze duplicability, orthology and network properties of cancer genes Nucleic Acids Res., November 11, 2009; (2009) gkp957v1. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
J. Su, Y. Zhang, J. Lv, H. Liu, X. Tang, F. Wang, Y. Qi, Y. Feng, and X. Li CpG_MI: a novel approach for identifying functional CpG islands in mammalian genomes Nucleic Acids Res., October 23, 2009; (2009) gkp882v1. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 E. Hazkani-Covo Mitochondrial Insertions into Primate Nuclear Genomes Suggest the Use of numts as a Tool for Phylogeny Mol. Biol. Evol., October 1, 2009; 26(10): 2175 - 2179. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 D. Fredman, P. G. Engstrom, and B. Lenhard Web-based tools and approaches to study long-range gene regulation in Metazoa Brief Funct Genomic Proteomic, July 15, 2009; (2009) elp023v1. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 D. L. Rainwater, L. A. Cox, J. Rogers, J. L. VandeBerg, and M. C. Mahaney Localization of multiple pleiotropic genes for lipoprotein metabolism in baboons J. Lipid Res., July 1, 2009; 50(7): 1420 - 1428. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
K. D. Yokoyama, U. Ohler, and G. A. Wray Measuring spatial preferences at fine-scale resolution identifies known and novel cis-regulatory element candidates and functional motif-pair relationships Nucleic Acids Res., July 1, 2009; 37(13): e92 - e92. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 C. J. Pink, S. K. Swaminathan, I. Dunham, J. Rogers, A. Ward, and L. D. Hurst Evidence That Replication-Associated Mutation Alone Does Not Explain Between-Chromosome Differences In Substitution Rates Gen Biol Evol, June 22, 2009; 2009(0): 13 - 22. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 M. V. Han, J. P. Demuth, C. L. McGrath, C. Casola, and M. W. Hahn Adaptive evolution of young gene duplicates in mammals Genome Res., May 1, 2009; 19(5): 859 - 867. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
M. I. Sigurdsson, A. V. Smith, H. T. Bjornsson, and J. J. Jonsson HapMap methylation-associated SNPs, markers of germline DNA methylation, positively correlate with regional levels of human meiotic recombination Genome Res., April 1, 2009; 19(4): 581 - 589. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
R. M. Kuhn, D. Karolchik, A. S. Zweig, T. Wang, K. E. Smith, K. R. Rosenbloom, B. Rhead, B. J. Raney, A. Pohl, M. Pheasant, et al. The UCSC Genome Browser Database: update 2009 Nucleic Acids Res., January 1, 2009; 37(suppl_1): D755 - D761. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 M. I. Lefterova, Y. Zhang, D. J. Steger, M. Schupp, J. Schug, A. Cristancho, D. Feng, D. Zhuo, C. J. Stoeckert Jr., X. S. Liu, et al. PPAR{gamma} and C/EBP factors orchestrate adipocyte biology via adjacent binding on a genome-wide scale Genes & Dev., November 1, 2008; 22(21): 2941 - 2952. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
R. Piskol and W. Stephan Analyzing the Evolution of RNA Secondary Structures in Vertebrate Introns Using Kimura's Model of Compensatory Fitness Interactions Mol. Biol. Evol., November 1, 2008; 25(11): 2483 - 2492. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
A. K. Holloway, D. J. Begun, A. Siepel, and K. S. Pollard Accelerated sequence divergence of conserved genomic elements in Drosophila melanogaster Genome Res., October 1, 2008; 18(10): 1592 - 1601. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 J. J. Forman, A. Legesse-Miller, and H. A. Coller A search for conserved sequences in coding regions reveals that the let-7 microRNA targets Dicer within its coding sequence PNAS, September 30, 2008; 105(39): 14879 - 14884. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
A. B. Prasad, M. W. Allard, NISC Comparative Sequencing Program, and E. D. Green Confirming the Phylogeny of Mammals by Use of Large Comparative Sequence Data Sets Mol. Biol. Evol., September 1, 2008; 25(9): 1795 - 1808. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 A. B. Conley, J. Piriyapongsa, and I. K. Jordan Retroviral promoters in the human genome Bioinformatics, July 15, 2008; 24(14): 1563 - 1567. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
I. Tirosh and N. Barkai Two strategies for gene regulation by promoter nucleosomes Genome Res., July 1, 2008; 18(7): 1084 - 1091. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
R. Egea, S. Casillas, and A. Barbadilla Standard and generalized McDonald-Kreitman test: a website to detect selection by comparing different classes of DNA sites Nucleic Acids Res., July 1, 2008; 36(suppl_2): W157 - W162. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
R. Andreson, T. Mols, and M. Remm Predicting failure rate of PCR in large genomes Nucleic Acids Res., June 1, 2008; 36(11): e66 - e66. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
K. Ichiyanagi and N. Okada Mobility Pathways for Vertebrate L1, L2, CR1, and RTE Clade Retrotransposons Mol. Biol. Evol., June 1, 2008; 25(6): 1148 - 1157. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 F. Ramirez-Valle, S. Braunstein, J. Zavadil, S. C. Formenti, and R. J. Schneider eIF4GI links nutrient sensing by mTOR to cell proliferation and inhibition of autophagy J. Cell Biol., April 21, 2008; 181(2): 293 - 307. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 A. S. Lee, M. Gutierrez-Arcelus, G. H. Perry, E. J. Vallender, W. E. Johnson, G. M. Miller, J. O. Korbel, and C. Lee Analysis of copy number variation in the rhesus macaque genome identifies candidate loci for evolutionary and human disease studies Hum. Mol. Genet., April 15, 2008; 17(8): 1127 - 1136. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
A. Goren, E. Kim, M. Amit, R. Bochner, G. Lev-Maor, N. Ahituv, and G. Ast Alternative approach to a heavy weight problem Genome Res., February 1, 2008; 18(2): 214 - 220. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
Z. Du, Y. Zhao, and N. Li Genome-wide analysis reveals regulatory role of G4 DNA in gene transcription Genome Res., February 1, 2008; 18(2): 233 - 241. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
A. Levy, N. Sela, and G. Ast TranspoGene and microTranspoGene: transposed elements influence on the transcriptome of seven vertebrates and invertebrates Nucleic Acids Res., January 11, 2008; 36(suppl_1): D47 - D52. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
D. Karolchik, R. M. Kuhn, R. Baertsch, G. P. Barber, H. Clawson, M. Diekhans, B. Giardine, R. A. Harte, A. S. Hinrichs, F. Hsu, et al. The UCSC Genome Browser Database: 2008 update Nucleic Acids Res., January 11, 2008; 36(suppl_1): D773 - D779. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
W. Miller, K. Rosenbloom, R. C. Hardison, M. Hou, J. Taylor, B. Raney, R. Burhans, D. C. King, R. Baertsch, D. Blankenberg, et al. 28-Way vertebrate alignment and conservation track in the UCSC Genome Browser Genome Res., December 1, 2007; 17(12): 1797 - 1808. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
J. M. Calabrese, A. C. Seila, G. W. Yeo, and P. A. Sharp RNA sequence analysis defines Dicer's role in mouse embryonic stem cells PNAS, November 13, 2007; 104(46): 18097 - 18102. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
B. E. Madsen, P. Villesen, and C. Wiuf A periodic pattern of SNPs in the human genome Genome Res., October 1, 2007; 17(10): 1414 - 1419. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 T. Derrien, C. Andre, F. Galibert, and C. Hitte Analysis of the Unassembled Part of the Dog Genome Sequence: Chromosomal Localization of 115 Genes Inferred from Multispecies Comparative Genomics J. Hered., August 3, 2007; (2007) esm027v3. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
J. Freudenberg, Y.-H. Fu, and L. J. Ptacek Human recombination rates are increased around accelerated conserved regions evidence for continued selection? Bioinformatics, June 15, 2007; 23(12): 1441 - 1443. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 J. Piriyapongsa, L. Marino-Ramirez, and I. K. Jordan Origin and Evolution of Human microRNAs From Transposable Elements Genetics, June 1, 2007; 176(2): 1323 - 1337. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
F. Parisi, P. Wirapati, and F. Naef Identifying synergistic regulation involving c-Myc and sp1 in human tissues Nucleic Acids Res., March 1, 2007; (2007) gkl1157v2. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
R. M. Kuhn, D. Karolchik, A. S. Zweig, H. Trumbower, D. J. Thomas, A. Thakkapallayil, C. W. Sugnet, M. Stanke, K. E. Smith, A. Siepel, et al. The UCSC genome browser database: update 2007 Nucleic Acids Res., January 12, 2007; 35(suppl_1): D668 - D673. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
D. J. Thomas, H. Trumbower, A. D. Kern, B. L. Rhead, R. M. Kuhn, D. Haussler, and W. J. Kent Variation resources at UC Santa Cruz Nucleic Acids Res., January 12, 2007; 35(suppl_1): D716 - D720. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
D. J. Thomas, K. R. Rosenbloom, H. Clawson, A. S. Hinrichs, H. Trumbower, B. J. Raney, D. Karolchik, G. P. Barber, R. A. Harte, J. Hillman-Jackson, et al. The ENCODE Project at UC Santa Cruz Nucleic Acids Res., January 12, 2007; 35(suppl_1): D663 - D667. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
P. L. Boutz, G. Chawla, P. Stoilov, and D. L. Black MicroRNAs regulate the expression of the alternative splicing factor nPTB during muscle development Genes & Dev., January 1, 2007; 21(1): 71 - 84. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 S M Gribble, D Kalaitzopoulos, D C Burford, E Prigmore, R R Selzer, B L Ng, N S W Matthews, K M Porter, R Curley, S J Lindsay, et al. Ultra-high resolution array painting facilitates breakpoint sequencing J. Med. Genet., January 1, 2007; 44(1): 51 - 58. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
L. Elnitski, V. X. Jin, P. J. Farnham, and S. J.M. Jones Locating mammalian transcription factor binding sites: A survey of computational and experimental techniques Genome Res., December 1, 2006; 16(12): 1455 - 1464. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 T. R. Pacheco, M. B. Coelho, J. M. P. Desterro, I. Mollet, and M. Carmo-Fonseca In Vivo Requirement of the Small Subunit of U2AF for Recognition of a Weak 3' Splice Site Mol. Cell. Biol., November 1, 2006; 26(21): 8183 - 8190. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 A. Stegmann, M. Hansen, Y. Wang, J. B. Larsen, L. R. Lund, L. Ritie, J. K. Nicholson, B. Quistorff, P. Simon-Assmann, J. T. Troelsen, et al. Metabolome, transcriptome, and bioinformatic cis-element analyses point to HNF-4 as a central regulator of gene expression during enterocyte differentiation Physiol Genomics, October 11, 2006; 27(2): 141 - 155. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 M. R. Barnes Navigating the HapMap Brief Bioinform, September 1, 2006; 7(3): 211 - 224. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
D. G. Lemay and D. H. Hwang Genome-wide identification of peroxisome proliferator response elements using integrated computational genomics J. Lipid Res., July 1, 2006; 47(7): 1583 - 1587. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
J. Chen, A. Rattner, and J. Nathans Effects of L1 retrotransposon insertion on transcript processing, localization and accumulation: lessons from the retinal degeneration 7 mouse and implications for the genomic ecology of L1 elements Hum. Mol. Genet., July 1, 2006; 15(13): 2146 - 2156. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
X. Ji, W. Li, J. Song, L. Wei, and X. S. Liu CEAS: cis-regulatory element annotation system. Nucleic Acids Res., July 1, 2006; 34(Web Server issue): W551 - W554. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
F. Hsu, W. J. Kent, H. Clawson, R. M. Kuhn, M. Diekhans, and D. Haussler The UCSC Known Genes Bioinformatics, May 1, 2006; 22(9): 1036 - 1046. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
P. D. Lee, B. Ge, C. M. T. Greenwood, D. Sinnett, Y. Fortin, S. Brunet, A. Fortin, M. Takane, E. Skamene, T. Pastinen, et al. Mapping cis-acting regulatory variation in recombinant congenic strains Physiol Genomics, April 13, 2006; 25(2): 294 - 302. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
G. Greenspan and D. Geiger Modeling Haplotype Block Variation Using Markov Chains Genetics, April 1, 2006; 172(4): 2583 - 2599. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
D. V. Babushok, E. M. Ostertag, C. E. Courtney, J. M. Choi, and H. H. Kazazian Jr. L1 integration in a transgenic mouse model Genome Res., February 1, 2006; 16(2): 240 - 250. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
G. D. Trobridge, D. G. Miller, M. A. Jacobs, J. M. Allen, H.-P. Kiem, R. Kaul, and D. W. Russell Foamy virus vector integration sites in normal human cells PNAS, January 31, 2006; 103(5): 1498 - 1503. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
T. Tran, P. Havlak, and J. Miller MicroRNA enrichment among short 'ultraconserved' sequences in insects. Nucleic Acids Res., January 1, 2006; 34(9): e65 - e65. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
K. L. Schneider, K. S. Pollard, R. Baertsch, A. Pohl, and T. M. Lowe The UCSC Archaeal Genome Browser Nucleic Acids Res., January 1, 2006; 34(suppl_1): D407 - D410. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
A. S. Hinrichs, D. Karolchik, R. Baertsch, G. P. Barber, G. Bejerano, H. Clawson, M. Diekhans, T. S. Furey, R. A. Harte, F. Hsu, et al. The UCSC Genome Browser Database: update 2006 Nucleic Acids Res., January 1, 2006; 34(suppl_1): D590 - D598. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
C. Webber and C. P. Ponting Hotspots of mutation and breakage in dog and human chromosomes Genome Res., December 1, 2005; 15(12): 1787 - 1797. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
A. V. Smith, D. J. Thomas, H. M. Munro, and G. R. Abecasis Sequence features in regions of weak and strong linkage disequilibrium Genome Res., November 1, 2005; 15(11): 1519 - 1534. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
B. Giardine, C. Riemer, R. C. Hardison, R. Burhans, L. Elnitski, P. Shah, Y. Zhang, D. Blankenberg, I. Albert, J. Taylor, et al. Galaxy: A platform for interactive large-scale genome analysis Genome Res., October 1, 2005; 15(10): 1451 - 1455. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
D. C. King, J. Taylor, L. Elnitski, F. Chiaromonte, W. Miller, and R. C. Hardison Evaluation of regulatory potential and conservation scores for detecting cis-regulatory modules in aligned mammalian genome sequences Genome Res., August 1, 2005; 15(8): 1051 - 1060. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
T. Mijalski, A. Harder, T. Halder, M. Kersten, M. Horsch, T. M. Strom, H. V. Liebscher, F. Lottspeich, M. H. de Angelis, and J. Beckers Identification of coexpressed gene clusters in a comparative analysis of transcriptome and proteome in mouse tissues PNAS, June 14, 2005; 102(24): 8621 - 8626. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
W.J. Kent, F. Hsu, D. Karolchik, R. M. Kuhn, H. Clawson, H. Trumbower, and D. Haussler Exploring relationships and mining data with the UCSC Gene Sorter Genome Res., May 1, 2005; 15(5): 737 - 741. [Abstract] [Full Text] [PDF]
|
|
|
|
 |
|
 W. C. Lathe, M. E. Mangan, D. Karolchik, W. J. Kent, and D. Haussler Integrating Genomic Information through the UCSC Genome Browser Am. Assoc. Cancer Res. Educ. Book, April 1, 2005; 2005(1): 3 - 6. [Full Text] [PDF]
|
|
|
|
|
|
Y. Chen, Y. Zhang, Y. Yin, G. Gao, S. Li, Y. Jiang, X. Gu, and J. Luo SPD--a web-based secreted protein database Nucleic Acids Res., January 1, 2005; 33(suppl_1): D169 - D173. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
F. Hsu, T. H. Pringle, R. M. Kuhn, D. Karolchik, M. Diekhans, D. Haussler, and W. J. Kent The UCSC Proteome Browser Nucleic Acids Res., January 1, 2005; 33(suppl_1): D454 - D458. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
G. Petersen, P. Johnson, L. Andersson, K. Klinga-Levan, P. M. Gomez-Fabre, and F. Stahl RatMap--rat genome tools and data Nucleic Acids Res., January 1, 2005; 33(suppl_1): D492 - D494. [Abstract] [Full Text] [PDF]
|
|
|
|
|
|
J. P. de Magalhaes, J. Costa, and O. Toussaint HAGR: the Human Ageing Genomic Resources Nucleic Acids Res., January 1, 2005; 33(suppl_1): D537 - D543. [Abstract] [Full Text] [PDF]
|
|