dadd1fb9e595faeff35a1c5f4a8f9f89ece397c8
max
  Thu Sep 28 11:46:16 2023 -0700
table browser should point to bigBed file for knownGene track, refs #32295

diff --git src/hg/hgTables/schema.c src/hg/hgTables/schema.c
index dd8324a..f0710df 100644
--- src/hg/hgTables/schema.c
+++ src/hg/hgTables/schema.c
@@ -397,30 +397,34 @@
     hPrintf(" (%s)", splitTable);
 hPrintf("&nbsp;&nbsp;&nbsp;&nbsp;<B>Row Count: </B>  ");
 printLongWithCommas(stdout, sqlTableSize(conn, splitTable));
 char *date = firstWordInLine(sqlTableUpdate(conn, splitTable));
 if (date != NULL)
     printf("&nbsp&nbsp<B> Data last updated:&nbsp;</B>%s<BR>\n", date);
 if (asObj != NULL)
     hPrintf("<B>Format description:</B> %s<BR>", asObj->comment);
 
 if (cartTrackDbIsNoGenome(db, table))
     hPrintf(" Note: genome-wide queries are not available for this table.");
 else
     {
     hPrintf("<B>On download server: </B>");
     hPrintf("<A HREF='https://hgdownload.soe.ucsc.edu/goldenPath/%s/database/'>MariaDB table dump directory</A><BR>", db);
+    char *bigDataUrl = trackDbSetting(tdb, "bigDataUrl");
+    if (sameString(table, "knownGene") && bigDataUrl!=NULL)
+        hPrintf("This track is available both in ASCII MariaDB table dump format and bigGenePred (bigBed) format.<br>");
+        printDownloadLink("bigBed", bigDataUrl);
     }
 
 describeFields(db, splitTable, asObj, conn);
 
 if (tdbForConn && sameString(tdbForConn->track, table))
     {
     struct trackDb *childTdb = tdbForTrack(db, table, NULL);
     addNotesForBbiTables(childTdb, conn);
     }
 
 jpList = joinerRelate(joiner, db, table, NULL);
 
 /* sort and unique list */
 slUniqify(&jpList, joinerPairCmpOnAandB, joinerPairFree);