5357f43c35e9cfb7bb2fae897eab6286954865c1 ccpowell Wed Jul 10 11:33:53 2019 -0700 Switching MySQL to MariaDB where appropriate in the documentation, refs #23597 diff --git src/hg/htdocs/goldenPath/help/hgTracksHelp.html src/hg/htdocs/goldenPath/help/hgTracksHelp.html index b3da146..2207861 100755 --- src/hg/htdocs/goldenPath/help/hgTracksHelp.html +++ src/hg/htdocs/goldenPath/help/hgTracksHelp.html @@ -213,31 +213,31 @@ the Gateway page to open up the Genome Browser with the annotation track displayed.</p> <p> The Genome Browser also provides a <a href="../customTracks/custTracks.html" target="_blank">collection of custom annotation tracks</a> contributed by the UCSC Genome Bioinformatics group and the research community.</p> <p> <strong>NOTE:</strong> If an annotation track does not display correctly when you attempt to upload it, you may need to reset the Genome Browser to its default settings, then reload the track. For information on troubleshooting display problems with custom annotation tracks, refer to the troubleshooting section in the <a href="#CustomTracks">Creating custom annotation tracks</a> section.</p> <h6>Viewing genome data as text</h6> <p> The <a href="../../cgi-bin/hgTables" target="_blank">Table Browser</a>, a portal to the underlying -open source <a href="http://www.MySQL.com" target="_blank">MySQL</a> relational database driving the +open source <a href="http://www.mariadb.org" target="_blank">MariaDB</a> relational database driving the Genome Browser, displays genomic data as columns of text rather than as graphical tracks. For more information on using the Table Browser, see the section <a href="#TableBrowser">Getting started: on the Table Browser</a>.</p> <h6>Opening the Genome Browser from external gateways</h6> <p> Several external gateways provide direct links into the Genome Browser. Examples include: <a href="https://www.ncbi.nlm.nih.gov/entrez/" target="_blank">Entrez Gene</a>, <a href="https://www.ncbi.nlm.nih.gov/IEB/Research/Acembly/index.html" target="_blank">AceView</a>, <a href="http://www.ensembl.org/" target="_blank">Ensembl</a>, <a href="http://supfam.mrc-lmb.cam.ac.uk/SUPERFAMILY/" target="_blank">SuperFamily</a>, and <a href="http://www.genecards.org/" target="_blank">GeneCards</a>. Journal articles can also link to the browser and provide custom tracks. Be sure to use the assembly date appropriate to the provided coordinates when using data from a journal source.</p> @@ -1339,33 +1339,33 @@ <li> <strong>xenoMrna.zip:</strong> All GenBank mRNAs from species other than that of the selected one.</li> </ul> <p> <em>Chromosomes</em> contains the assembled sequence for the genome in separate files for each chromosome in a zipped fasta format. The main assembly can be found in the <em>chrN.fa</em> files, where <em>N</em> is the name of the chromosome. The <em>chrN_random.fa</em> files contain clones that are not yet finished or cannot be placed with certainty at a specific place on the chromosome. In some cases, the <em>chrN_random.fa</em> files also contain haplotypes that differ from the main assembly.</p> <p> <em>Database</em> contains all of the positional and non-positional tables in the genome annotation database. Each table is represented by 2 files:</p> <ul> - <li><strong>.sql file:</strong> the MySQL commands used to create the table.</li> + <li><strong>.sql file:</strong> the SQL commands used to create the table.</li> <li> - <strong>.txt.gz file:</strong> the MySQL database table data in tab-delimited format and + <strong>.txt.gz file:</strong> the MariaDB database table data in tab-delimited format and compressed with gzip.</li> </ul> <p> Schema descriptions for all tables in the genome annotation database may be viewed by using the "describe table schema" button in the <a href="#TableBrowser">Table Browser</a>.</p> <p> <em>Cross-species alignments</em> directories, such as the <em>vsMm4</em> and <em>humorMm3Rn3</em> directories in the hg16 assembly, contain pairwise and multiple species alignments and filtered alignment files used to produce cross-species annotations. For more information, refer to the READMEs in these directories and the description of the <a href "../../FAQformat.html#format5">Multiple Alignment Format</a> (MAF).</p> <a name="CustomTracks"></a> <h2>Creating custom annotation tracks</h2> <!--#include virtual="customTrackText.html"-->