I get the data table of "GPL16110" from GEO.
There is no information about the 'symbol', and I don't know how to convert the ID to gene symbol.
The only information I can get are "ID, Chr, Position, GC Score, SNP_ID, SPOT_ID", and the column of "ID" is the same with the column of "SPOT_ID".
The head of the Data table is below:
|ID |Chr|Position |GC Score |SNP_ID|SPOT_ID | |GA008510| Y |13311305|0.5193345 | |GA008510| |GA008524| Y |21152701|0.5739997 | |GA008524| |GA008529| Y |21154004|0.4872587 | |GA008529| |GA008532| Y |28463253|0.5228286 | |GA008532| |GA026677| Y |2722814 |0.00656162| |GA026677| |GA026703| Y |13324571|0.4636189 | |GA026703| |GA026708| Y |15053296|0.02973483| |GA026708|
The description shows that
Chr: Chromosome on which the probe is located
Position: Position of the probe on chromosome
I wanna try to seek the gene symbol in the Database "hg19" from "genome-mysql.soe.ucsc.edu" by using the value of "Chr" and "Position".
So I use
select distinct name2 from refGene where chrom="chrY" and txStart>=28463253 and txEnd<=28463253;
to find the probe "GA008532"
But the result is
Empty set (0.31 sec)
How can I convert the probe into Gene symbol?
Thank you very much!