a30c400ad09e9ae41fbbf7636deed814a86e1edd
braney
  Thu Jul 28 17:34:22 2022 -0700
Build hub and genome stanzas for curated hubs from dbDb.   Don't show
curated assemblies as hubs on hgGateway or hgHubConnect.

diff --git src/hg/makeDb/trackDb/dbDbToHubTxt src/hg/makeDb/trackDb/dbDbToHubTxt
new file mode 100755
index 0000000..a3dde37
--- /dev/null
+++ src/hg/makeDb/trackDb/dbDbToHubTxt
@@ -0,0 +1,51 @@
+db=$1
+dir=$2
+out=$dir/hubAndGenome.txt
+rm -f $out
+
+echo "hub $db genome assembly" >> $out
+description=`hgsql hgcentraltest -Ne "select description from dbDb where name='$db'"`
+echo "shortLabel $description" >> $out
+sourceName=`hgsql hgcentraltest -Ne "select sourceName from dbDb where name='$db'"`
+echo "longLabel $sourceName" >> $out
+echo "email genome-www@soe.ucsc.edu" >> $out
+htmlPath=`hgsql hgcentraltest -Ne "select htmlPath from dbDb where name='$db'"`
+echo "descriptionUrl $htmlPath" >> $out
+echo "useOneFile on" >> $out
+echo >> $out
+
+echo "genome $db" >> $out
+taxId=`hgsql hgcentraltest -Ne "select taxId from dbDb where name='$db'"`
+echo "taxId $taxId" >> $out
+echo "groups ../groups.txt" >> $out
+echo "description $description" >> $out
+echo "twoBitPath /gbdb/$db/$db.2bit" >> $out
+echo "chromSizes ../chromSizes.txt" >> $out
+echo "chromAliasBb ../chromAlias.bb" >> $out
+organism=`hgsql hgcentraltest -Ne "select organism from dbDb where name='$db'"`
+echo "organism $organism" >> $out
+defaultPos=`hgsql hgcentraltest -Ne "select defaultPos from dbDb where name='$db'"`
+echo "defaultPos $defaultPos" >> $out
+scientificName=`hgsql hgcentraltest -Ne "select scientificName from dbDb where name='$db'"`
+echo "scientificName $scientificName" >> $out
+echo "htmlPath $htmlPath" >> $out
+blat=`hgsql hgcentraltest -Ne "select host from blatServers where db='$db' and isTrans=0"`
+blatPort=`hgsql hgcentraltest -Ne "select port from blatServers where db='$db' and isTrans=0"`
+blatDynamic=`hgsql hgcentraltest -Ne "select dynamic from blatServers where db='$db' and isTrans=0"`
+dynString=""
+if test "$blatDynamic == 0"
+then
+   dynString="dynamic $db"
+fi
+echo "blat $blat $blatPort $dynString" >> $out
+echo "isPcr $blat $blatPort $dynString" >> $out
+blat=`hgsql hgcentraltest -Ne "select host from blatServers where db='$db' and isTrans=1"`
+blatPort=`hgsql hgcentraltest -Ne "select port from blatServers where db='$db' and isTrans=1"`
+blatDynamic=`hgsql hgcentraltest -Ne "select dynamic from blatServers where db='$db' and isTrans=1"`
+dynString=""
+if test "$blatDynamic == 0"
+then
+   dynString="dynamic $db"
+fi
+echo "transBlat $blat $blatPort $dynString" >> $out
+echo >> $out