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
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.
On 10/14/13 11:13 AM, Gabriel Calvin
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.
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: