UniProtKB A0A183 LCE6A GO:0031424 GO_REF:0000037 IEA UniProtKB-KW:KW-0417 P Late cornified envelope protein 6A LCE6A_HUMAN|C1orf44|LCE6A protein taxon:9606 20120303 UniProtKB
UniProtKB A0A5B9 TRBC2 GO:0004872 GO_REF:0000037 IEA UniProtKB-KW:KW-0675 F T-cell receptor beta-2 chain C region TRBC2_HUMAN|TRBC2|TCRBC2 protein taxon:9606 20120303 UniProtKB
UniProtKB A0A5B9 TRBC2 GO:0016020 GO_REF:0000039 IEA UniProtKB-SubCell:SL-0162 C T-cell receptor beta-2 chain C region TRBC2_HUMAN|TRBC2|TCRBC2 protein taxon:9606 20120303 UniProtKB
UniProtKB A0A5B9 TRBC2 GO:0016021 GO_REF:0000037 IEA UniProtKB-KW:KW-0812 C T-cell receptor beta-2 chain C region TRBC2_HUMAN|TRBC2|TCRBC2 protein taxon:9606 20120303 UniProtKB
UniProtKB A0AUX0 AMPD3 GO:0003876 GO_REF:0000019 IEA Ensembl:ENSRNOP00000024933 F cDNA FLJ76195, highly similar to Homo sapiens adenosine monophosphate deaminase (isoform E) (AMPD3),mRNA A0AUX0_HUMAN|AMPD3|hCG_22452 protein taxon:9606 20120303 ENSEMBL
UniProtKB A0AUX0 AMPD3 GO:0006188 GO_REF:0000002 IEA InterPro:IPR006329 P cDNA FLJ76195, highly similar to Homo sapiens adenosine monophosphate deaminase (isoform E) (AMPD3),mRNA A0AUX0_HUMAN|AMPD3|hCG_22452 proteintaxon:9606 20120303 InterPro
UniProtKB A0AV02 SLC12A8 GO:0006811 GO_REF:0000037 IEA UniProtKB-KW:KW-0406 P Solute carrier family 12 member 8 S12A8_HUMAN|SLC12A8|CCC9 protein taxon:9606 20120303 UniProtKB
UniProtKB A0AV02 SLC12A8 GO:0006813 GO_REF:0000037 IEA UniProtKB-KW:KW-0633 P Solute carrier family 12 member 8 S12A8_HUMAN|SLC12A8|CCC9 protein taxon:9606 20120303 UniProtKB
UniProtKB A0AV02 SLC12A8 GO:0015293 GO_REF:0000037 IEA UniProtKB-KW:KW-0769 F Solute carrier family 12 member 8 S12A8_HUMAN|SLC12A8|CCC9 protein taxon:9606 20120303 UniProtKB
UniProtKB A0AV02 SLC12A8 GO:0016020 GO_REF:0000039 IEA UniProtKB-SubCell:SL-0162 C Solute carrier family 12 member 8 S12A8_HUMAN|SLC12A8|CCC9 protein taxon:9606 20120303 UniProtKB
My expected output is this
Code:
LCE6A GO:0031424 Late cornified envelope protein 6A
TRBC2 GO:0004872 T-cell receptor beta-2 chain C region
..........
........
.............
...........
SLC12A8 GO:0016020 Solute carrier family 12 member 8
Basically, what am I trying to do is to grab $3"\t"$4"\t"$9
Please note the following.
My input file is tab separated between columns and space separated in 9th column.
My expected output is also the same way.
The dots in my expected output means that the records in between needs to be printed. I didn't want to type everything. Hopefully, you guys understood me.
IEA ($6) is a column and it is tab separated from other columns and is not space separated with other columns.
A hint might be....9th column can be extracted anything after
Hi all,
I have created a script which adding two columns and removing two columns for all files.
Filename: Cust_information_1200_201010.txt
Source Data:
"1","Cust information","123","106001","street","1-203 high street"
"1","Cust information","124","105001","street","1-203 high street"
... (0 Replies)
Hi,
I have a huge file with a single line.
But I want to break that line into lines of with each line having five columns.
My file is like this:
code:
"hi","there","how","are","you?","It","was","great","working","with","you.","hope","to","work","you."
I want it like this:
code:... (1 Reply)
Hi All,
i have a .Csv file in the below format
startTime, endTime, delta, gName, rName, rNumber, m2239max, m2239min, m2239avg, m100016509avg, m100019240max, metric3min, m100019240avg, propValues
11-Mar-2012 00:00:00, 11-Mar-2012 00:05:00, 300.0, vma3550a, a-1_CPU Index<1>, 200237463, 0.0,... (9 Replies)
Hi,
I have the following input file
32895901-d17f-414c-ac93-3e7e0f5ec240 AND @GDF_INPUT
73b129e1-1fa9-4c0d-b95b-4682e5389612 AUS @GDF_INPUT
40f82e88-d1ff-4ce2-9b8e-d827ddb39447 BEL @GDF_INPUT
36e9c3f1-042a-43a4-a80e-4a3bc2513d01 BGR @GDF_INPUT
I want to split column 3 into two columns:... (1 Reply)
Hi,
I have a space delimited text file with multiple columns 102 columns. I want to break it up into 100 files labelled 1.txt through 100.txt (n.txt). Each text file will contain the first two columns and in addition the nth column (that corresponds to n.txt). The third file will contain the... (1 Reply)
Hello everyone,
I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble.
I have many files each having two columns and hundreds of rows.
first column is a string (can have many words) and the second column is a number.The files are... (5 Replies)
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
How could i take an input file and split the numeric values from the alpha values (123 vs abc) to distinc columns, and if the source is blank to keep it blank (null) in both of the new columns:
So if the source file had a column like:
Value:
|1 |
|2.3|
| |
|No|
I would... (7 Replies)
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)