I have two files first file looks like this,
and the second one like this,
ENSG00000000460.12 24chr1 HAVANA 11869 14412 . + . + . gene_id "ENSG00000223972.4"; transcript_id "ENSG00000223972.4"; gene_type "pseudogene"; gene_status "KNOWN"; gene_name "DDX11L1"; transcript_type "pseudogene"; transcript_status "KNOWN";
As you see I nee dto comapre the first column of the file 1 to the 11th column of file2, if they are similar then I need to get the out put like this,
ENSG00000000003.10 0 gene_type protein_coding ENSG00000000005.5 0 gene_type protein_coding
I have been trying in perl but My scripts taking long hours all these files are huge so it would be great if there is any scripts with PERL HASHES
tahnk you all in advance.!!