Dear all
For each bam file in my history I can download the associated bai (bam index) file.
I assume these files are stored somewhere under /mount/galaxy/database/files/_metadata_files. Correct? Is there an easy way to find the bam index file for a bam file, given only the internal file name of the bam (e.g. /mont/galaxy/database/files/089/dataset_89231.dat)?
I am asking because I would like to use the files_to_ftp tool to automatically download bams together with their associated indices.
Thanks Ulf
************************************************************************** The information contained in the EMail and any attachments is confidential and intended solely and for the attention and use of the named addressee(s). It may not be disclosed to any other person without the express authority of Public Health England, or the intended recipient, or both. If you are not the intended recipient, you must not disclose, copy, distribute or retain this message or any part of it. This footnote also confirms that this EMail has been swept for computer viruses by Symantec.Cloud, but please re-sweep any attachments before opening or saving. http://www.gov.uk/PHE **************************************************************************
Hi Ulf,
Unfortunately, metadata files are assigned an id that is unrelated to the dataset id. To link the files you'll need to use the database. The numerical id you see in the filename is the id of the dataset in the `dataset` table. From this you can go backward to the history_dataset_association (hda) table, where hda.dataset_id = dataset.id. Finally, from there, hda.id can be used to find the metadata_file via metadata_file.hda_id.
More succinctly:
dataset.id = history_dataset_association.dataset_id history_dataset_association.id = metadata_file.hda_id
--nate
On Mon, Sep 15, 2014 at 6:34 AM, Ulf Schaefer Ulf.Schaefer@phe.gov.uk wrote:
Dear all
For each bam file in my history I can download the associated bai (bam index) file.
I assume these files are stored somewhere under /mount/galaxy/database/files/_metadata_files. Correct? Is there an easy way to find the bam index file for a bam file, given only the internal file name of the bam (e.g. /mont/galaxy/database/files/089/dataset_89231.dat)?
I am asking because I would like to use the files_to_ftp tool to automatically download bams together with their associated indices.
Thanks Ulf
The information contained in the EMail and any attachments is confidential and intended solely and for the attention and use of the named addressee(s). It may not be disclosed to any other person without the express authority of Public Health England, or the intended recipient, or both. If you are not the intended recipient, you must not disclose, copy, distribute or retain this message or any part of it. This footnote also confirms that this EMail has been swept for computer viruses by Symantec.Cloud, but please re-sweep any attachments before opening or saving. http://www.gov.uk/PHE
Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
galaxy-dev@lists.galaxyproject.org
-
Nate Coraor -
Ulf Schaefer