[Genome] affyU133 qName

[Brent Pedersen]

Hi, in order to get the gene symbol associated with an affy (affyU133)
probe for hg18/19, I'm using:

SELECT A.qName, GROUP_CONCAT(DISTINCT X.geneSymbol ORDER BY
X.geneSymbol SEPARATOR ';;;') FROM
   affyU133 A, kgXref X, knownToU133 T WHERE
 SUBSTR(A.qName, 7, LENGTH(A.qName) - 7) = T.value AND T.name = X.kgID
 GROUP BY A.qName LIMIT 20;

where the substring is because affyU133.qName is prefixed with
"U133A:" or "U133B:"

Is that the best way to do this join?

thanks,
-Brent
_______________________________________________
Genome maillist  -  Genome@soe.ucsc.edu
https://lists.soe.ucsc.edu/mailman/listinfo/genome