**retrospective_breast_CNA_median_sort_common_gene_16884.txt** Gene_ID --> A1BG, A1CF, A2M......ZZEF1, ZZZ3 **retrospective_breast_proteome_all_gene.txt** Gene_ID --> A1BG, A2M.....ZZEF1, ZZZ3 **retrospective_breast_rna_seq_sort_common_gene_15115.txt** Gene_ID --> A1BG, A2M.....ZZEF1, ZZZ3 Is **not matching** to **Gene_ID's** in **retrospective_breast_phospho_all_gene.txt** Gene_ID --> NP_000005.2:s710, NP_000007.1:t51........XP_005275701.1:t1022,XP_005275701.1:t828 Is there any **mapping strategy** for extracting common rows between **retrospective_breast_phospho_all_gene.txt** towards other **3 (proteome,cna,rna_seq)** files...?

Created by vijay kumar narsapuram narsapvi
What you need is a mapping between gene names (_e.g._, A1BG) and RefSeq identifiers (_e.g._, NP_000005). One possibility is to get this mapping is via Ensembl, through [BioMart](http://www.ensembl.org/biomart/martview). Another possibility might be via [UCSC](https://www.genome.ucsc.edu/cgi-bin/hgTables). Yet another one is to use the NCBI FTP to get the data from [EntrezGene](https://www.ncbi.nlm.nih.gov/gene) (all species altogether). Best,

Row header(Gene_ID) mismatch in sub_challenge 3 page is loading…