97b899f21a0804a3f9e025fca3e1a785db9cb6fe braney Wed Oct 19 17:18:31 2022 -0700 get the clade, org, and db dropdowns in hgTables to work with curated hubs diff --git src/hg/lib/web.c src/hg/lib/web.c index 5ca390f..a4e758a 100644 --- src/hg/lib/web.c +++ src/hg/lib/web.c @@ -595,30 +595,34 @@ webAbortExt(TRUE, title, format, args); va_end(args); } void printCladeListHtml(char *genome, char *event, char *javascript) /* Make an HTML select input listing the clades. */ { char **row = NULL; char *clades[128]; char *labels[128]; char *defaultClade = hClade(genome); char *defaultLabel = NULL; int numClades = 0; +if (hubConnectIsCurated(trackHubSkipHubName(genome))) + defaultClade = hClade(trackHubSkipHubName(genome)); +else + defaultClade = hClade(genome); struct sqlConnection *conn = hConnectCentral(); // after hClade since it access hgcentral too // get only the clades that have actual active genomes char query[4096]; sqlSafef(query, sizeof query, "SELECT DISTINCT(c.name), c.label " // mysql 5.7: SELECT list w/DISTINCT must include all fields in ORDER BY list (#18626) ", c.priority " "FROM %s c, %s g, %s d WHERE c.name=g.clade AND d.organism=g.genome AND d.active=1 " "ORDER BY c.priority", cladeTable(), genomeCladeTable(), dbDbTable()); struct sqlResult *sr = sqlGetResult(conn, query); while ((row = sqlNextRow(sr)) != NULL) { clades[numClades] = cloneString(row[0]); labels[numClades] = cloneString(row[1]); if (sameWord(defaultClade, clades[numClades]))