74bea0582059450e508b0f69a6b70c072ac1d3a2
lrnassar
  Wed Sep 9 16:29:28 2026 -0700
List the newest deprecated transcript first for a deprecated NP_ search, per CR feedback.

When a superseded protein accession maps to several deprecated transcript
versions, the search returns all of them, but they were listed in table order so
the oldest came first. Order the xrefQuery newest-first, matching the choice the
HGVS protein path already makes. Sort by length before value so .10 beats .9
rather than losing a string comparison. refs #38292

diff --git src/hg/makeDb/trackDb/human/trackDb.ra src/hg/makeDb/trackDb/human/trackDb.ra
index 058a7988256..6f540a7d178 100644
--- src/hg/makeDb/trackDb/human/trackDb.ra
+++ src/hg/makeDb/trackDb/human/trackDb.ra
@@ -5616,31 +5616,31 @@
 baseColorDefault genomicCodons
 
 searchTable ncbiRefSeqHistorical
 searchMethod exact
 searchType genePred
 semiShortCircuit 1
 termRegex [N][MR]_[0-9]{6}[0-9]*\.[0-9]+
 searchPriority 20
 
 searchName ncbiRefSeqHistoricalProtAcc
 searchTable ncbiRefSeqHistorical
 searchType genePred
 searchMethod exact
 semiShortCircuit 1
 xrefTable ncbiRefSeqLinkHistorical
-xrefQuery select id,protAcc from %s where protAcc = '%s' and protAcc not in (select protAcc from ncbiRefSeqLink)
+xrefQuery select id,protAcc from %s where protAcc = '%s' and protAcc not in (select protAcc from ncbiRefSeqLink) order by length(id) desc, id desc
 termRegex [NY]P_[0-9]{6}[0-9]*\.[0-9]+
 searchPriority 20.1
 
 
 include alphaMissense.ra
 
 include mitoMap.ra
 
 include exonprimers.ra alpha
 include colorsDbLegacy.ra alpha
 
 include g2p.ra
 include varFreqs.ra
 include phasedVars.ra