Latest
Open
RNA-Seq
ChIP-Seq
SNP
Assembly
Forum
Planet
All »
Home
Log In
Question: Error in conversion of Excel to Bed format
0
gravatar for amna29007
12 weeks ago by
amna29007 • 0
amna29007 • 0 wrote:

hy!! i have a problem regarding conversion of excel file(which contains miRNA data) into a bed file ..when i put the file and execute it will return error ..please tell me how to convert excel file into a bed file becuase in mapping i only required bed files
interval bed excel galaxy tabular • 140 views
ADD COMMENT • link •
modified 12 weeks ago by Jennifer Hillman Jackson ♦ 25k • written 12 weeks ago by amna29007 • 0
0
gravatar for Jennifer Hillman Jackson
12 weeks ago by
Jennifer Hillman Jackson ♦ 25k
United States
Jennifer Hillman Jackson ♦ 25k wrote:

Hello,

  1. Export data from Excel to a plain text (tabular) output on your own computer first.
  2. Upload that tabular data to Galaxy using autodetect for the datatype (important).
  3. After upload, change the datatype to be tabular if Galaxy guessed it incorrectly.
  4. Then use the tool Cut on the tabular dataset within Galaxy so that it is a match for bed format.
  5. Once the dataset has the proper column data/ordering, change the datatype to be bed.

For now, avoid using the "Convert" function to change between interval and bed format as there is a known bug with that function. Instead, do the column rearrangement and datatype changes directly using the methods above.

These FAQs cover the expected format/content for a bed dataset and how to reset metadata such as datatype.

https://galaxyproject.org/support/ >> https://galaxyproject.org/support/#getting-inputs-right

Thanks! Jen, Galaxy team
ADD COMMENT • link modified 12 weeks ago • written 12 weeks ago by Jennifer Hillman Jackson ♦ 25k
Please log in to add an answer.

Similar posts • Search »

Content
Help
Access
Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 169 users visited in the last hour