Hi Gabriel,

SAM format is just tabular data- so you could assign that as a datatype (use the pencil icon). The only concern here would be the size of the files - Excel can be easily swapped with very large files.

Converting SAM->interval is another option, if you just need the coordinates. This can also be set as "tabular" format for Excel

For both, make sure the file ends in ".tab" not ".tabular" and possibly just "txt", once downloaded, in order for Excel to recognize it (as far as I know).

Galaxy will perform many of the calculations that Excel will do (see group "Text manipulations" & others tools like "Group" or those in "Statistics", but you have likely already seen those.


Galaxy team

On 10/14/13 11:13 AM, Gabriel Calvin wrote:
Thanks for the responses It appears these programs require some background in Python or R. Is there a less code-intensive way to manipulate a sam or bam into a format viewable in Excel? Does Galaxy provide a tool for this?

If it simply is a matter of learning code, so be it.

On Fri, Oct 11, 2013 at 3:20 PM, Gabriel Calvin <gac4223@gmail.com> wrote:
The organism is fruit fly. The piRNA reference sequence was obtained from http://www.fruitfly.org/p_disrupt/TE.html as FASTA.FORMAT.v9.4.1.

I will check out those programs.


The Galaxy User list should be used for the discussion of
Galaxy analysis and other features on the public server
at usegalaxy.org.  Please keep all replies on the list by
using "reply all" in your mail client.  For discussion of
local Galaxy instances and the Galaxy source code, please
use the Galaxy Development list:


To manage your subscriptions to this and other Galaxy lists,
please use the interface at:


To search Galaxy mailing lists use the unified search at:


Jennifer Hillman-Jackson