[Genome] quetion regarding the table browser

[Kayla Smith]

Asaf,

To get just the lines of hg18.affyHumanExon that you are interested in, 
you could copy all of the names from the affyHumanExon.name column that 
you are interested in and then use those names to limit your search of 
affyHumanExon table.

For example, if you were interested in the following affyHumanExon.names:

2315101
2390547
2315102
2315103
2390549

You could use the Table Browser with the following options:

clade: Vertebrate
genome: Human
assembly: Mar. 2006
group: Expression and Regulation
track: Affy All Exon
table: affyHumanExon
region: genome
identifiers: paste list.  --Here paste in

2315101
2390547
2315102
2315103
2390549

or which ever items you are interested in.

output format: all fields from selected table.

By saying "all fields from selected table" you'll pick up the expScores 
column.

I hope this helps you to get the data you're looking for.  Please don't 
hesitate to contact us again if you require further assistance.

Kayla Smith
UCSC Genome Bioinformatics Group


asaf levy wrote:
> Hi,
> 
> I'd like to get the expScores column from hg18 affyHumanExon table of ~1000
> rows that I am interested in, from which made a custom track.
> 
> I understand that I can create some intersection between my table and the
> affyHumanExon table, but the problem is that I can get the result only in
> BED file or in my custom track format and both don't contain the expScores
> column. 
> 
> Do you have any idea how can I download this data?
> 
>  
> 
> Regards,
> 
> Asaf Levy
> 
> Tel Aviv University
> 
> _______________________________________________
> Genome maillist  -  Genome at soe.ucsc.edu
> http://www.soe.ucsc.edu/mailman/listinfo/genome