Is there a way to use metadata in a header row of a tab-delimited format for column names? Alternatively, is there a way to manually edit column names to something other than "1", "2", "3", etc.?
Background: I grabbed RefGene data for the entire human genome from the UCSC Genome Browser's Table Browser by sending the data to Galaxy. The output format of the query was "all fields from selected query". The Tabular data comes through just fine, but the first line is the header row:
"#bin name chrom strand ... exonFrames"
I would like to (1) use this information for the actual column names in the data, replacing the default enumeration. Ideally, it would look something like the column naming protocol for BED files "1. chrom 2. chromStart 3. chromEnd ..." and (2) after this information is included as column names, remove that header row. The latter is easy (I think), but I cannot find a means of accomplishing the former. There is an old discussion thread related to this (http://dev.list.galaxyproject.org/Tabular-file-metadata-columns-names-td4138590.html), but it does not appear to resolve the current issue. Any suggestions?