For what is worth, here is a step by step guide of how to do this with biomart :
1) connect to biomart
2) In list "CHOOSE DATABASE" -> select "Ensembl Genes 66"
3) In list "CHOOSE DATASET" -> select "Homo sapiens genes (GRCh37.p6)"
4) Then on the left, clik on "Filter"
5) In the main panel clink on Genes
6) Tick the checkbox "Limit to genes ... " and select in the listbox "with affymetrix microarray hg u133a 2 probeset ID(s)"
7) Then on the left, click on "Attributes"
8) In the main panel, check the radio button in front of "Sequences"
9) Just below, click on the "+" box in front of "sequences", and then select the type of sequence yo want, for example "cDNA sequences"
10) Facultative : Just below, click on the "+" box in front of "Header information". By default, you will have Ensembl Gene ID and Ensembl Transcript ID cheked, you may want to change this
11) Then in the upper panel, click on "RESULTS", you will see the begining of what you want.
12) To export all sequences in a text file, choose your file format (default is FASTA), You SHOULD tick the box in front of UNIQUE RESULTS ONLY, and then click on "GO"
What I just described can be accessed directely with this link
When you say "mapped all those ids to biomart" what exactly did you do? Use HG-U133A probeset IDs as filters and try to retrieve transcripts IDs/sequences as attributes?
Hello Yes I have used these probset IDs as filters, but I am not getting exact number of sequences of mRNAs as those of input IDs. I was expecting 22283 mRNA sequences in return, but that was not the case. Right now I am not bothering about redundant mRNAs. What I expect is one to one returns for given query. Is it possible or am I expecting something wrong ?
You're expecting something wrong. Let me work on an answer...