Just recently i was requested by my friend to help convert a text document to an Excel sheet which could be understood easily. Firstly i could not directly open the file in Notepad Or Excel as it was not properly supported.
Later when i forced it open in Notepad, it was just massive strings of text with nothing to interpret. I wanted to know what the file format is. So .fa file format is
FASTA is a DNA and protein sequence alignment software package first described (as FASTP) by David J. Lipman and William R. Pearson in 1985. Its legacy is the FASTA format which is now ubiquitous in bioinformatics. Source: Wikipedia
I had never encountered such file format and was excited to know something in DNA sequencing.
Google is the best tool to get the directions to a solution, i searched google with keywords to convert .fa file to excel. However I realised there was ni ready tool or technique to convert such file. Yes, you could manually edit each of 1500 lines and spend 2-3 hours to get it done without being sure of the accuracy.
While googling I stumbled upon a youtube video shows the same intended conversion in some Orange software. Initially i was not sure what software it is, but after switching to HD mode, i realised the software was Orange Canvas an open source data visualisation software, which you can download at http://orange.biolab.si/
These people had created a special widget to be added with orange canvas, It would convert the data from a fasta file to a usable, easily understood form in tabbed format.
Installing Orange was simple and I allowed whatever addon it asked for. Finally Orange setup was completed and the software was installed.
Following is a screen shot how orange installation looks.
Later i Downloaded (Download from: https://github.com/1withforce/FileEngage) the GitHub Project and moved files as per instructions on Readme.md file which said:
File widget with universal converter compatibility (formerly OrangeFasta) =========== V 1.0 =========== Orange file widget has built-in fasta converter. Icon needs to go in ~/.../orange/OrangeWidgets/Data/icons/ converterClass needs to go in ~/.../orange/OrangeWidgets OWFileEngage needs to go in ~/.../orange/OrangeWidgets/Data
How does this software work:
The white blank area which you see below the icons is the Canvas Area, similar to that of a painting canvas. The difference is only that you dont use water color Or brushes to paint :D. Just click on the desired icon and drag-drop it in the canvas.
- First thing we need is: File
- Next we need to Load the Data file (which can be Fasta Or Other format)
- Double click on the File Icon and a Pop-up will appear where we can select the file source to load the data
At this moment, the File Engage Widget prepared by those 2 guys was not added. Once added, we get a new icon called File Engage
Thats it, you are done.