Fix match result links and make source tags link to database homepage

Shaun Mahony · claude · Shaun Mahony · commit 1f7a3f307f8e · 2026-03-01T00:27:05.000-05:00
- JASPAR sync now always sets urlPattern and version on the
  ReferenceDatabase document (not just on first creation), so
  existing databases that predate the urlPattern field get backfilled
  on next sync
- Processor builds dbHomeUrl (derived from urlPattern origin) and sets
  it on each match entry alongside dbUrl
- Match name and dbId badge link to the specific motif page (dbUrl)
- Blue source tag (e.g. "JASPAR") now links to the database homepage
  (dbHomeUrl) instead of the motif page
- Add dbHomeUrl field to MatchEntry type
- Legacy two-part format also sets dbHomeUrl for JASPAR

Co-Authored-By: Claude Sonnet 4.6 &lt;noreply@anthropic.com&gt;
diff --git a/web/src/components/results/MatchTable.tsx b/web/src/components/results/MatchTable.tsx
@@ -312,9 +312,9 @@ function MatchRow({
               )
             )}
             {match.dbSource && (
-              match.dbUrl ? (
+              match.dbHomeUrl ? (
                 <a
-                  href={match.dbUrl}
+                  href={match.dbHomeUrl}
                   target="_blank"
                   rel="noopener noreferrer"
                   className="text-xs text-white bg-blue-500 px-1.5 py-0.5 rounded hover:bg-blue-600 transition-colors"
diff --git a/web/src/lib/jaspar/sync.ts b/web/src/lib/jaspar/sync.ts
@@ -143,6 +143,8 @@ export async function syncJaspar(options: SyncOptions = {}): Promise<SyncResult>
       lastSyncedAt: new Date(),
       motifCount,
       taxonGroups: storedTaxonGroups,
+      version: "2024",
+      urlPattern: "https://jaspar.elixir.no/matrix/{id}",
     }
   );
 
diff --git a/web/src/types/index.ts b/web/src/types/index.ts
@@ -69,6 +69,7 @@ export interface MatchEntry {
   dbSource?: string;      // e.g. "JASPAR"
   dbId?: string;          // e.g. "MA0139.1"
   dbUrl?: string;         // e.g. "https://jaspar.elixir.no/matrix/MA0139.1"
+  dbHomeUrl?: string;     // e.g. "https://jaspar.elixir.no"
   dbCollection?: string;  // e.g. "CORE"
 }
 
diff --git a/web/worker/processor.ts b/web/worker/processor.ts
@@ -95,14 +95,21 @@ export async function processStampJob(job: BullJob<StampJobData>): Promise<void>
       inputMotifMap.set(m.name, m.matrix);
     }
 
-    // Build URL pattern lookup from selected databases
+    // Build URL pattern and home URL lookups from selected databases
     const urlPatternMap = new Map<string, string>();
+    const dbHomeUrlMap = new Map<string, string>();
     if (matching.databases && matching.databases.length > 0) {
       const slugs = matching.databases.map((d) => d.slug);
       const refDbs = await ReferenceDatabase.find({ slug: { $in: slugs } }).lean() as Array<{ source?: string; urlPattern?: string }>;
       for (const db of refDbs) {
         if (db.source && db.urlPattern) {
-          urlPatternMap.set(db.source.toUpperCase(), db.urlPattern);
+          const key = db.source.toUpperCase();
+          urlPatternMap.set(key, db.urlPattern);
+          try {
+            dbHomeUrlMap.set(key, new URL(db.urlPattern).origin);
+          } catch {
+            // If urlPattern isn't a valid URL, skip home URL
+          }
         }
       }
     }
@@ -122,17 +129,23 @@ export async function processStampJob(job: BullJob<StampJobData>): Promise<void>
             entry.dbSource = dbSource;
             entry.dbId = matrixId;
             entry.name = displayName;
-            const pattern = urlPatternMap.get(dbSource.toUpperCase());
+            const sourceKey = dbSource.toUpperCase();
+            const pattern = urlPatternMap.get(sourceKey);
             if (pattern) {
               entry.dbUrl = pattern.replace("{id}", matrixId);
             }
+            const homeUrl = dbHomeUrlMap.get(sourceKey);
+            if (homeUrl) {
+              entry.dbHomeUrl = homeUrl;
+            }
           } else {
             // Legacy two-part format: "MA0139.1::CTCF"
             const [matrixId, ...rest] = parts;
             const displayName = rest.join("::");
             entry.dbId = matrixId;
             entry.dbSource = "JASPAR";
             entry.dbUrl = `https://jaspar.elixir.no/matrix/${matrixId}`;
+            entry.dbHomeUrl = "https://jaspar.elixir.no";
             entry.name = displayName || matrixId;
           }
         }

Original file line number	Diff line number	Diff line change
`@@ -143,6 +143,8 @@ export async function syncJaspar(options: SyncOptions = {}): Promise<SyncResult>`
`143`	`143`	`lastSyncedAt: new Date(),`
`144`	`144`	`motifCount,`
`145`	`145`	`taxonGroups: storedTaxonGroups,`
	`146`	`+ version: "2024",`
	`147`	`+ urlPattern: "https://jaspar.elixir.no/matrix/{id}",`
`146`	`148`	`}`
`147`	`149`	`);`
`148`	`150`
Original file line number	Diff line number	Diff line change
`@@ -69,6 +69,7 @@ export interface MatchEntry {`
`69`	`69`	`dbSource?: string; // e.g. "JASPAR"`
`70`	`70`	`dbId?: string; // e.g. "MA0139.1"`
`71`	`71`	`dbUrl?: string; // e.g. "https://jaspar.elixir.no/matrix/MA0139.1"`
	`72`	`+ dbHomeUrl?: string; // e.g. "https://jaspar.elixir.no"`
`72`	`73`	`dbCollection?: string; // e.g. "CORE"`
`73`	`74`	`}`
`74`	`75`