Hi!
The file MayoRNAseq_RNAseq_TCX_geneCounts.tsv (syn4650257) has different samples than the ones found in the metadata file provided (syn3817650). Where can I find the metadata for the samples on the gene counts file?
Thanks!
Created by paulacauhy Thanks a lot, @jgockley !! Problem solved!
Hi @paulacauhy
If you're using R sometimes the column names in the expression file load in with leading X's:
```
#Download files
> synapser::synLogin()
> counts <- read.table( synapser::synGet('syn4650257')$path, header=T, sep='\t' )
> Meta <- read.csv( synapser::synGet('syn3817650')$path, header=T )
> head(counts[,1:4])
ensembl_id X11344_TCX X11316_TCX X11431_TCX
1 ENSG00000000003 428 498 652
2 ENSG00000000005 5 2 5
3 ENSG00000000419 921 574 844
4 ENSG00000000457 435 237 437
5 ENSG00000000460 275 212 273
6 ENSG00000000938 279 337 249
#Remove Leading X from column names
> colnames(counts) <- gsub('X','', colnames(counts))
> colnames(counts) <- gsub('_TC','_TCX', colnames(counts))
> table(colnames(counts)[ colnames(counts) != 'ensembl_id' ] %in% Meta$SampleID)
TRUE
276
```
Drop files to upload
Mayo RNASeq metadata doesn't match samples on gene counts file page is loading…