I have a file with tab-separated fields in the following format:
2-micron 251 1523 R0010W . + SGD gene . ID=R0010W;Name=R0010W;gene=FLP1;Alias=FLP1;Ontology_term=GO:0003690,GO:0003697,GO:0005575,GO:0008301,GO:0009009,GO:0042150;Note=Site-specific%20recombinase%20encoded%20on%20the%202-micron%20plasmid%2C%20required%20for%202-micron%20plasmid%20propagation%20as%20part%20of%20a%20plasmid%20amplification%20system%20that%20compensates%20for%20any%20copy%20number%20decreases%20caused%20by%20missegregation%20events;dbxref=SGD:S000029654;orf_classification=Verified 0
I need to extract 2 columns (4th and last), which I have successfully done. But I also need to extract specific information from a column with more details. For example, I need to extract
gene=foo from the 10th column.
So, in results I want the 4th column, gene information from 10th column and the last column, a total of 3 columns. How do I do that ?