[Genome] table browser for IMAGE clone information

[Ann Zweig]

Hello Andrew,

	Yes, you can do this using the Table Browser.  Set it up as my 
colleague, Kayla, suggests.  Then press the filter 'create' button.  On 
this page, enter your IMAGE clone number in the "Image ID =" box.  Then 
press 'submit'.

	Choose 'all fields from selected table' as the output format, then 
press "get output".  You will see a list of all rows of the table that 
match your IMAGE ID.

	For example, if you search for the IMAGE ID of 40370, the output will be:

#filter: imageClone.imageId = 40370
#imageId	acc	type	direction
40370	AF520794	mRNA	0
40370	R55267	EST	5
40370	R55268	EST	3


	I hope this is helpful to you.


Regards,

----------
Ann Zweig
UCSC Genome Bioinformatics Group
http://genome.ucsc.edu

Please feel free to search the Genome mailing list archives by visiting 
our home page, clicking on "Contact Us", then typing a word or phrase 
into the search box.  On that same page 
(http://genome.ucsc.edu/contacts.html), you can subscribe to the Genome 
mailing list.



Yee, Andrew J.,M.D. wrote:
> As a follow up, in terms of using the Table Browser, is there a way you can
> browse the table by entering the IMAGE clone number, instead of the GenBank
> accession number?
> 
> Thanks,
> Andrew 
> 
> -----Original Message-----
> From: Kayla Smith [mailto:kayla at soe.ucsc.edu] 
> Sent: Friday, July 06, 2007 1:02 AM
> To: Yee, Andrew J.,M.D.
> Cc: genome at soe.ucsc.edu
> Subject: Re: [Genome] table browser for IMAGE clone information
> 
> 
> Andrew,
> 
> We have a table for most assemblies called imageClone.  You can download the
> imageClone table for the hg18 database here:
> http://hgdownload.cse.ucsc.edu/goldenPath/hg18/database/imageClone.txt.gz
> 
> If you want more information than that table provides alone, you can go to the
> Table Browser, and select the following options:
> 
> clade: Vertebrate
> genome: Human
> assembly: Mar. 2006
> group: All Tables
> table: imageClone
> 
> You can click on the "describe table schema" button to see how this table is
> connected to others.  The LNDL link you provide has a lot of information, so I'm
> not sure exactly what you're looking for.  If you can be more specific about
> what you're looking for, I can help to direct you to the appropriate
> information.
> 
> I hope this is helpful to you.  Please don't hesitate to contact us again if you
> require further assistance.
> 
> Kayla Smith
> UCSC Genome Bioinformatics Group
> 
> On Thu, 5 Jul 2007, Yee, Andrew J.,M.D. wrote:
> 
>> Do you have any tables that incorporate I.M.A.G.E clone information (e.g.
>> http://image.llnl.gov/)?
>>
>> Thanks,
>> Andrew
>>
>> Andrew J. Yee, MD
>> Instructor in Medicine, Harvard Medical School Assistant in Medicine, 
>> Mass. General Hospital Cancer Center
>>
>>
>>
>>
>>
>>
>> The information transmitted in this electronic communication is intended only
> for the person or entity to whom it is addressed and may contain confidential
> and/or privileged material. Any review, retransmission, dissemination or other
> use of or taking of any action in reliance upon this information by persons or
> entities other than the intended recipient is prohibited. If you received this
> information in error, please contact the Compliance HelpLine at 800-856-1983 and
> properly dispose of this information.
>> _______________________________________________
>> Genome maillist  -  Genome at soe.ucsc.edu 
>> http://www.soe.ucsc.edu/mailman/listinfo/genome
>>
> 
> 
> 
> 
> 
> The information transmitted in this electronic communication is intended only for the person or entity to whom it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this information in error, please contact the Compliance HelpLine at 800-856-1983 and properly dispose of this information.
> 
> 
> _______________________________________________
> Genome maillist  -  Genome at soe.ucsc.edu
> http://www.soe.ucsc.edu/mailman/listinfo/genome