Too many columns for dplyr::select?

[sr320]

I am trying to trim down a 39k column table to about 500 columns.

This works great (~90 columns)

select.treat <- select(fpkm, Treatment, TreatmentN, Sex, gene.LOC111128233, gene.LOC111105393, gene.LOC111116464, gene.LOC111135088, gene.LOC111130500, gene.LOC111127278, gene.LOC111113969, gene.LOC111132481, gene.LOC111105938, gene.LOC111138283, gene.LOC111131835, gene.LOC111129832, gene.LOC111130487, gene.LOC111127862, gene.LOC111110254, gene.LOC111124688, gene.LOC111125297, gene.LOC111116779, gene.LOC111119607, gene.LOC111123744, gene.LOC111124204, gene.LOC111113829, gene.LOC111110051, gene.LOC111104660, gene.LOC111101623, gene.LOC111134693, gene.LOC111132149, gene.LOC111130074, gene.LOC111120371, gene.LOC111109428, gene.LOC111103964, gene.LOC111137116, gene.Trnar.ucu.6, gene.LOC111107907, gene.LOC111132919, gene.LOC111125308, gene.LOC111119991, gene.LOC111104989, gene.LOC111105010, gene.LOC111131011, gene.LOC111121753, gene.LOC111129483, gene.LOC111108381, gene.LOC111117476, gene.LOC111106432, gene.LOC111111499, gene.LOC111119263, gene.LOC111117731, gene.LOC111124459, gene.LOC111112454, gene.LOC111104633, gene.LOC111127078, gene.LOC111102379, gene.LOC111122828, gene.LOC111110666, gene.LOC111110881, gene.LOC111136751, gene.LOC111115668, gene.LOC111127096, gene.LOC111126101, gene.LOC111132698, gene.LOC111126632, gene.LOC111137392, gene.Trnaa.cgc.10, gene.LOC111128233, gene.LOC111105393, gene.LOC111116464, gene.LOC111135088, gene.LOC111130500, gene.LOC111127278, gene.LOC111113969, gene.LOC111132481, gene.LOC111105938, gene.LOC111138283, gene.LOC111131835, gene.LOC111129832, gene.LOC111130487, gene.LOC111127862, gene.LOC111110254, gene.LOC111124688, gene.LOC111125297, gene.LOC111116779, gene.LOC111119607, gene.LOC111123744, gene.LOC111124204, gene.LOC111113829, gene.LOC111110051, gene.LOC111104660, gene.LOC111101623, gene.LOC111134693, gene.LOC111132149, gene.LOC111130074, gene.LOC111120371, gene.LOC111109428, gene.LOC111103964, gene.LOC111137116, gene.Trnar.ucu.6)

but when I try all 500 columns ...

select.treat <- select(fpkm, Treatment, TreatmentN, Sex, gene.LOC111128233, gene.LOC111105393, gene.LOC111116464, gene.LOC111135088, gene.LOC111130500, gene.LOC111127278, gene.LOC111113969, gene.LOC111132481, gene.LOC111105938, gene.LOC111138283, gene.LOC111131835, gene.LOC111129832, gene.LOC111130487, gene.LOC111127862, gene.LOC111110254, gene.LOC111124688, gene.LOC111125297, gene.LOC111116779, gene.LOC111119607, gene.LOC111123744, gene.LOC111124204, gene.LOC111113829, gene.LOC111110051, gene.LOC111104660, gene.LOC111101623, gene.LOC111134693, gene.LOC111132149, gene.LOC111130074, gene.LOC111120371, gene.LOC111109428, gene.LOC111103964, gene.LOC111137116, gene.Trnar.ucu.6, gene.LOC111107907, gene.LOC111132919, gene.LOC111125308, gene.LOC111119991, gene.LOC111104989, gene.LOC111105010, gene.LOC111131011, gene.LOC111121753, gene.LOC111129483, gene.LOC111108381, gene.LOC111117476, gene.LOC111106432, gene.LOC111111499, gene.LOC111119263, gene.LOC111117731, gene.LOC111124459, gene.LOC111112454, gene.LOC111104633, gene.LOC111127078, gene.LOC111102379, gene.LOC111122828, gene.LOC111110666, gene.LOC111110881, gene.LOC111136751, gene.LOC111115668, gene.LOC111127096, gene.LOC111126101, gene.LOC111132698, gene.LOC111126632, gene.LOC111137392, gene.Trnaa.cgc.10, gene.LOC111116747, gene.LOC111119683, gene.LOC111114329, gene.LOC111103661, gene.LOC111103366, gene.LOC111125715, gene.LOC111116113, gene.LOC111133423, gene.LOC111128077, gene.LOC111137605, gene.LOC111131581, gene.LOC111129153, gene.LOC111137394, gene.LOC111112011, gene.LOC111109454, gene.LOC111137041, gene.LOC111116960, gene.LOC111100864, gene.LOC111106300, gene.LOC111137433, gene.LOC111133945, gene.LOC111105466, gene.LOC111114537, gene.LOC111103655, gene.LOC111123442, gene.LOC111114881, gene.LOC111114514, gene.LOC111116017, gene.LOC111122971, gene.LOC111101930, gene.LOC111122452, gene.LOC111122497, gene.LOC111122842, gene.LOC111135076, gene.LOC111115118, gene.LOC111134325, gene.LOC111136338, gene.LOC111125156, gene.LOC111121248, gene.LOC111113085, gene.LOC111136798, gene.LOC111106667, gene.LOC111136831, gene.LOC111113176, gene.LOC111109404, gene.LOC111113797, gene.LOC111133762, gene.LOC111116334, gene.LOC111104618, gene.LOC111116388, gene.LOC111104745, gene.LOC111100813, gene.LOC111137068, gene.LOC111118724, gene.LOC111127314, gene.LOC111120101, gene.LOC111128497, gene.LOC111100317, gene.LOC111120228, gene.LOC111137700, gene.LOC111130672, gene.LOC111130648, gene.LOC111130568, gene.LOC111119060, gene.LOC111118035, gene.LOC111127657, gene.LOC111138494, gene.LOC111109863, gene.LOC111127766, gene.LOC111138428, gene.LOC111099887, gene.LOC111108781, gene.LOC111128481, gene.LOC111129979, gene.LOC111120328, gene.LOC111127436, gene.LOC111099124, gene.LOC111131054, gene.LOC111107256, gene.LOC111131372, gene.LOC111100595, gene.LOC111102018, gene.LOC111112249, gene.LOC111133094, gene.LOC111109278, gene.LOC111130400, gene.LOC111128636, gene.LOC111102020, gene.LOC111126100, gene.LOC111105179, gene.LOC111121268, gene.LOC111130907, gene.LOC111104082, gene.LOC111100083, gene.LOC111136434, gene.LOC111119791, gene.LOC111113841, gene.LOC111102016, gene.LOC111119800, gene.LOC111108680, gene.LOC111110534, gene.LOC111116200, gene.LOC111106705, gene.LOC111104173, gene.LOC111127764, gene.LOC111136526, gene.LOC111108919, gene.LOC111108848, gene.LOC111100644, gene.LOC111116938, gene.LOC111128289, gene.LOC111135133, gene.LOC111102649, gene.LOC111121053, gene.LOC111132372, gene.LOC111128300, gene.LOC111108256, gene.LOC111122514, gene.LOC111130785, gene.LOC111129160, gene.LOC111109707, gene.LOC111105929, gene.LOC111112571, gene.LOC111103288, gene.LOC111118662, gene.LOC111123201, gene.LOC111121150, gene.LOC111105511, gene.LOC111121104, gene.LOC111108257, gene.Trnal.uag.2, gene.LOC111135867, gene.LOC111112717, gene.LOC111102452, gene.LOC111125305, gene.LOC111127131, gene.LOC111127137, gene.LOC111099903, gene.LOC111114936, gene.LOC111106409, gene.LOC111137458, gene.LOC111105513, gene.LOC111107726, gene.LOC111105891, gene.LOC111133402, gene.LOC111100968, gene.Trnag.gcc.9, gene.LOC111103844, gene.LOC111118156, gene.LOC111116810, gene.LOC111101305, gene.LOC111120256, gene.LOC111100453, gene.LOC111109336, gene.LOC111128813, gene.LOC111100672, gene.LOC111121926, gene.LOC111136029, gene.LOC111099842, gene.LOC111118407, gene.LOC111102501, gene.LOC111122220, gene.LOC111118341, gene.LOC111122351, gene.LOC111135498, gene.LOC111119436, gene.LOC111120954, gene.LOC111137708, gene.LOC111117650, gene.LOC111118498, gene.LOC111118493, gene.LOC111120549, gene.LOC111137163, gene.LOC111122331, gene.LOC111137130, gene.LOC111102595, gene.LOC111121922, gene.LOC111136106, gene.LOC111120844, gene.LOC111119785, gene.LOC111119790, gene.LOC111121510, gene.LOC111100136, gene.LOC111118047, gene.LOC111116385, gene.LOC111121625, gene.LOC111121439, gene.LOC111116324, gene.LOC111117575, gene.LOC111116322, gene.LOC111136398, gene.LOC111119888, gene.LOC111101998, gene.LOC111136591, gene.LOC111121901, gene.LOC111120806, gene.LOC111116038, gene.LOC111120235, gene.LOC111121232, gene.LOC111138174, gene.LOC111116090, gene.LOC111100401, gene.LOC111136597, gene.LOC111116643, gene.LOC111116603, gene.LOC111120684, gene.LOC111100963, gene.LOC111119735, gene.LOC111121590, gene.LOC111108701, gene.LOC111102787, gene.LOC111111648, gene.LOC111130938, gene.LOC111111318, gene.LOC111126617, gene.LOC111126588, gene.LOC111126412, gene.LOC111107257, gene.LOC111130803, gene.LOC111130794, gene.LOC111130739, gene.LOC111107454, gene.LOC111130747, gene.LOC111111035, gene.LOC111130758, gene.LOC111131386, gene.LOC111131510, gene.LOC111112426, gene.LOC111111805, gene.LOC111132082, gene.LOC111112202, gene.LOC111112225, gene.LOC111106053, gene.LOC111105904, gene.LOC111112128, gene.LOC111106214, gene.LOC111106238, gene.LOC111131716, gene.LOC111131682, gene.LOC111126046, gene.LOC111131865, gene.LOC111129206, gene.LOC111110841, gene.LOC111130546, gene.LOC111109512, gene.LOC111127285, gene.LOC111128457, gene.LOC111108293, gene.LOC111108247, gene.LOC111127879, gene.LOC111127827, gene.LOC111129760, gene.LOC111129718, gene.LOC111128067, gene.LOC111128284, gene.LOC111109758, gene.LOC111128454, gene.LOC111129639, gene.LOC111109889, gene.LOC111109576, gene.LOC111110264, gene.LOC111108053, gene.LOC111107724, gene.LOC111110598, gene.LOC111130363, gene.LOC111130205, gene.LOC111127313, gene.LOC111130325, gene.LOC111107881, gene.LOC111127737, gene.LOC111107992, gene.LOC111127669, gene.LOC111127637, gene.LOC111110438, gene.LOC111127636, gene.LOC111112418, gene.LOC111105854, gene.LOC111135401, gene.LOC111134773, gene.LOC111134571, gene.LOC111134636, gene.LOC111134675, gene.LOC111114684, gene.LOC111114713, gene.LOC111134558, gene.LOC111103876, gene.LOC111114313, gene.LOC111134049, gene.LOC111114036, gene.LOC111123901, gene.LOC111123701, gene.LOC111104106, gene.LOC111123237, gene.LOC111134811, gene.LOC111132496, gene.LOC111103409, gene.LOC111122797, gene.LOC111103011, gene.LOC111102955, gene.LOC111115242, gene.LOC111102946, gene.LOC111122802, gene.LOC111129102, gene.LOC111135083, gene.LOC111123056, gene.LOC111114901, gene.LOC111103203, gene.LOC111135078, gene.LOC111122950, gene.LOC111113946, gene.LOC111113894, gene.LOC111113889, gene.LOC111133854, gene.LOC111125112, gene.LOC111112913, gene.LOC111133024, gene.LOC111113081, gene.LOC111133074, gene.LOC111105419, gene.LOC111105505, gene.LOC111112746, gene.LOC111132580, gene.LOC111125437, gene.LOC111112676, gene.LOC111112737, gene.LOC111112685, gene.LOC111124839, gene.LOC111124833, gene.LOC111108926, gene.LOC111133789, gene.LOC111129142, gene.LOC111113799, gene.LOC111124495, gene.LOC111129139, gene.LOC111133497, gene.LOC111104757, gene.LOC111113297, gene.LOC111113346, gene.LOC111124682, gene.LOC111124598, gene.LOC111113471, gene.LOC111124563, gene.LOC111118584, gene.LOC111134059, gene.LOC111119281, gene.LOC111119256, gene.LOC111099487, gene.LOC111099555, gene.LOC111119089, gene.LOC111110302, gene.LOC111119474, gene.LOC111105254, gene.LOC111101392, gene.LOC111099499, gene.LOC111117644, gene.LOC111101452, gene.LOC111105985, gene.LOC111107201, gene.Trnat.ugu.10, gene.LOC111125066, gene.LOC111100182, gene.LOC111108879, gene.LOC111106739, gene.LOC111123596, gene.LOC111106152, gene.LOC111104339, gene.LOC111099541, gene.LOC111119936, gene.LOC111115467, gene.LOC111126426, gene.LOC111122818, gene.LOC111129655, gene.LOC111112837, gene.LOC111112832, gene.LOC111105825, gene.LOC111109963, gene.LOC111115420, gene.LOC111114009, gene.LOC111112834, gene.LOC111116588, gene.LOC111116952, gene.LOC111125235, gene.LOC111105386, gene.LOC111105781, gene.LOC111121272, gene.Trnaa.agc.15, gene.LOC111129039, gene.LOC111104187, gene.LOC111100960, gene.LOC111135012, gene.LOC111106057, gene.LOC111105612, gene.LOC111128555, gene.LOC111119241, gene.LOC111128275, gene.LOC111100519, gene.LOC111102310, gene.LOC111104998, gene.LOC111099516, gene.LOC111117685, gene.LOC111105057, gene.LOC111103179, gene.LOC111126446, gene.LOC111105578, gene.LOC111101126, gene.LOC111126504, gene.LOC111122681, gene.LOC111103219, gene.LOC111112739, gene.LOC111115214, gene.LOC111103928, gene.LOC111116380, gene.Trnaw.cca.2, gene.LOC111106962, gene.LOC111132283, gene.Trnal.aag.8, gene.LOC111109021, gene.Trnag.gcc.3, gene.Trnay.gua.2, gene.LOC111100961, gene.LOC111102100, gene.LOC111103111, gene.LOC111132693, gene.LOC111104807, gene.LOC111112591, gene.LOC111116288, gene.LOC111101755, gene.LOC111133626, gene.LOC111108000, gene.LOC111121636, gene.LOC111115793, gene.LOC111118828, gene.LOC111136168, gene.LOC111105456, gene.LOC111106058)

I get the following error

Error: Incomplete expression: select.treat <- select(fpkm, Treatment, TreatmentN, Sex, gene.LOC111128233, gene.LOC111105393, gene.LOC111116464, gene.LOC111135088, gene.LOC111130500, gene.LOC111127278, gene.LOC111113969, gene.LOC111132481, gene.LOC111105938, gene.LOC111138283, gene.LOC111131835, gene.LOC111129832, gene.LOC111130487, gene.LOC111127862, gene.LOC111110254, gene.LOC111124688, gene.LOC111125297, gene.LOC111116779, gene.LOC111119607, gene.LOC111123744, gene.LOC111124204, gene.LOC111113829, gene.LOC111110051, gene.LOC111104660, gene.LOC111101623, gene.LOC111134693, gene.LOC111132149, gene.LOC111130074, gene.LOC111120371, gene.LOC111109428, gene.LOC111103964, gene.LOC111137116, gene.Trnar.ucu.6, gene.LOC111107907, gene.LOC111132919, gene.LOC111125308, gene.LOC111119991, gene.LOC111104989, gene.LOC111105010, gene.LOC111131011, gene.LOC111121753, gene.LOC111129483, gene.LOC111108381, gene.LOC111117476, gene.LOC111106432, gene.LOC111111499, gene.LOC111119263, gene.LOC111117731, gen

Any suggestions, work arounds or ideas?

Full R nb
https://github.com/epigeneticstoocean/2018_L18-adult-methylation/blob/main/code/09-weka.Rmd

[kubu4]

Well, the only thing I've figured out so far is that it's not related to dplyr. I get the same error when trying to create a vector with that set of column names:

names.df <- c("Treatment", "TreatmentN", "Sex", "gene.LOC111128233", "gene.LOC111105393", "gene.LOC111116464", "gene.LOC111135088", "gene.LOC111130500", "gene.LOC111127278", "gene.LOC111113969", "gene.LOC111132481", "gene.LOC111105938", "gene.LOC111138283", "gene.LOC111131835", "gene.LOC111129832", "gene.LOC111130487", "gene.LOC111127862", "gene.LOC111110254", "gene.LOC111124688", "gene.LOC111125297", "gene.LOC111116779", "gene.LOC111119607", "gene.LOC111123744", "gene.LOC111124204", "gene.LOC111113829", "gene.LOC111110051", "gene.LOC111104660", "gene.LOC111101623", "gene.LOC111134693", "gene.LOC111132149", "gene.LOC111130074", "gene.LOC111120371", "gene.LOC111109428", "gene.LOC111103964", "gene.LOC111137116", "gene.Trnar.ucu.6", "gene.LOC111107907", "gene.LOC111132919", "gene.LOC111125308", "gene.LOC111119991", "gene.LOC111104989", "gene.LOC111105010", "gene.LOC111131011", "gene.LOC111121753", "gene.LOC111129483", "gene.LOC111108381", "gene.LOC111117476", "gene.LOC111106432", "gene.LOC111111499", "gene.LOC111119263", "gene.LOC111117731", "gene.LOC111124459", "gene.LOC111112454", "gene.LOC111104633", "gene.LOC111127078", "gene.LOC111102379", "gene.LOC111122828", "gene.LOC111110666", "gene.LOC111110881", "gene.LOC111136751", "gene.LOC111115668", "gene.LOC111127096", "gene.LOC111126101", "gene.LOC111132698", "gene.LOC111126632", "gene.LOC111137392", "gene.Trnaa.cgc.10", "gene.LOC111116747", "gene.LOC111119683", "gene.LOC111114329", "gene.LOC111103661", "gene.LOC111103366", "gene.LOC111125715", "gene.LOC111116113", "gene.LOC111133423", "gene.LOC111128077", "gene.LOC111137605", "gene.LOC111131581", "gene.LOC111129153", "gene.LOC111137394", "gene.LOC111112011", "gene.LOC111109454", "gene.LOC111137041", "gene.LOC111116960", "gene.LOC111100864", "gene.LOC111106300", "gene.LOC111137433", "gene.LOC111133945", "gene.LOC111105466", "gene.LOC111114537", "gene.LOC111103655", "gene.LOC111123442", "gene.LOC111114881", "gene.LOC111114514", "gene.LOC111116017", "gene.LOC111122971", "gene.LOC111101930", "gene.LOC111122452", "gene.LOC111122497", "gene.LOC111122842", "gene.LOC111135076", "gene.LOC111115118", "gene.LOC111134325", "gene.LOC111136338", "gene.LOC111125156", "gene.LOC111121248", "gene.LOC111113085", "gene.LOC111136798", "gene.LOC111106667", "gene.LOC111136831", "gene.LOC111113176", "gene.LOC111109404", "gene.LOC111113797", "gene.LOC111133762", "gene.LOC111116334", "gene.LOC111104618", "gene.LOC111116388", "gene.LOC111104745", "gene.LOC111100813", "gene.LOC111137068", "gene.LOC111118724", "gene.LOC111127314", "gene.LOC111120101", "gene.LOC111128497", "gene.LOC111100317", "gene.LOC111120228", "gene.LOC111137700", "gene.LOC111130672", "gene.LOC111130648", "gene.LOC111130568", "gene.LOC111119060", "gene.LOC111118035", "gene.LOC111127657", "gene.LOC111138494", "gene.LOC111109863", "gene.LOC111127766", "gene.LOC111138428", "gene.LOC111099887", "gene.LOC111108781", "gene.LOC111128481", "gene.LOC111129979", "gene.LOC111120328", "gene.LOC111127436", "gene.LOC111099124", "gene.LOC111131054", "gene.LOC111107256", "gene.LOC111131372", "gene.LOC111100595", "gene.LOC111102018", "gene.LOC111112249", "gene.LOC111133094", "gene.LOC111109278", "gene.LOC111130400", "gene.LOC111128636", "gene.LOC111102020", "gene.LOC111126100", "gene.LOC111105179", "gene.LOC111121268", "gene.LOC111130907", "gene.LOC111104082", "gene.LOC111100083", "gene.LOC111136434", "gene.LOC111119791", "gene.LOC111113841", "gene.LOC111102016", "gene.LOC111119800", "gene.LOC111108680", "gene.LOC111110534", "gene.LOC111116200", "gene.LOC111106705", "gene.LOC111104173", "gene.LOC111127764", "gene.LOC111136526", "gene.LOC111108919", "gene.LOC111108848", "gene.LOC111100644", "gene.LOC111116938", "gene.LOC111128289", "gene.LOC111135133", "gene.LOC111102649", "gene.LOC111121053", "gene.LOC111132372", "gene.LOC111128300", "gene.LOC111108256", "gene.LOC111122514", "gene.LOC111130785", "gene.LOC111129160", "gene.LOC111109707", "gene.LOC111105929", "gene.LOC111112571", "gene.LOC111103288", "gene.LOC111118662", "gene.LOC111123201", "gene.LOC111121150", "gene.LOC111105511", "gene.LOC111121104", "gene.LOC111108257", "gene.Trnal.uag.2", "gene.LOC111135867", "gene.LOC111112717", "gene.LOC111102452", "gene.LOC111125305", "gene.LOC111127131", "gene.LOC111127137", "gene.LOC111099903", "gene.LOC111114936", "gene.LOC111106409", "gene.LOC111137458", "gene.LOC111105513", "gene.LOC111107726", "gene.LOC111105891", "gene.LOC111133402", "gene.LOC111100968", "gene.Trnag.gcc.9", "gene.LOC111103844", "gene.LOC111118156", "gene.LOC111116810", "gene.LOC111101305", "gene.LOC111120256", "gene.LOC111100453", "gene.LOC111109336", "gene.LOC111128813", "gene.LOC111100672", "gene.LOC111121926", "gene.LOC111136029", "gene.LOC111099842", "gene.LOC111118407", "gene.LOC111102501", "gene.LOC111122220", "gene.LOC111118341", "gene.LOC111122351", "gene.LOC111135498", "gene.LOC111119436", "gene.LOC111120954", "gene.LOC111137708", "gene.LOC111117650", "gene.LOC111118498", "gene.LOC111118493", "gene.LOC111120549", "gene.LOC111137163", "gene.LOC111122331", "gene.LOC111137130", "gene.LOC111102595", "gene.LOC111121922", "gene.LOC111136106", "gene.LOC111120844", "gene.LOC111119785", "gene.LOC111119790", "gene.LOC111121510", "gene.LOC111100136", "gene.LOC111118047", "gene.LOC111116385", "gene.LOC111121625", "gene.LOC111121439", "gene.LOC111116324", "gene.LOC111117575", "gene.LOC111116322", "gene.LOC111136398", "gene.LOC111119888", "gene.LOC111101998", "gene.LOC111136591", "gene.LOC111121901", "gene.LOC111120806", "gene.LOC111116038", "gene.LOC111120235", "gene.LOC111121232", "gene.LOC111138174", "gene.LOC111116090", "gene.LOC111100401", "gene.LOC111136597", "gene.LOC111116643", "gene.LOC111116603", "gene.LOC111120684", "gene.LOC111100963", "gene.LOC111119735", "gene.LOC111121590", "gene.LOC111108701", "gene.LOC111102787", "gene.LOC111111648", "gene.LOC111130938", "gene.LOC111111318", "gene.LOC111126617", "gene.LOC111126588", "gene.LOC111126412", "gene.LOC111107257", "gene.LOC111130803", "gene.LOC111130794", "gene.LOC111130739", "gene.LOC111107454", "gene.LOC111130747", "gene.LOC111111035", "gene.LOC111130758", "gene.LOC111131386", "gene.LOC111131510", "gene.LOC111112426", "gene.LOC111111805", "gene.LOC111132082", "gene.LOC111112202", "gene.LOC111112225", "gene.LOC111106053", "gene.LOC111105904", "gene.LOC111112128", "gene.LOC111106214", "gene.LOC111106238", "gene.LOC111131716", "gene.LOC111131682", "gene.LOC111126046", "gene.LOC111131865", "gene.LOC111129206", "gene.LOC111110841", "gene.LOC111130546", "gene.LOC111109512", "gene.LOC111127285", "gene.LOC111128457", "gene.LOC111108293", "gene.LOC111108247", "gene.LOC111127879", "gene.LOC111127827", "gene.LOC111129760", "gene.LOC111129718", "gene.LOC111128067", "gene.LOC111128284", "gene.LOC111109758", "gene.LOC111128454", "gene.LOC111129639", "gene.LOC111109889", "gene.LOC111109576", "gene.LOC111110264", "gene.LOC111108053", "gene.LOC111107724", "gene.LOC111110598", "gene.LOC111130363", "gene.LOC111130205", "gene.LOC111127313", "gene.LOC111130325", "gene.LOC111107881", "gene.LOC111127737", "gene.LOC111107992", "gene.LOC111127669", "gene.LOC111127637", "gene.LOC111110438", "gene.LOC111127636", "gene.LOC111112418", "gene.LOC111105854", "gene.LOC111135401", "gene.LOC111134773", "gene.LOC111134571", "gene.LOC111134636", "gene.LOC111134675", "gene.LOC111114684", "gene.LOC111114713", "gene.LOC111134558", "gene.LOC111103876", "gene.LOC111114313", "gene.LOC111134049", "gene.LOC111114036", "gene.LOC111123901", "gene.LOC111123701", "gene.LOC111104106", "gene.LOC111123237", "gene.LOC111134811", "gene.LOC111132496", "gene.LOC111103409", "gene.LOC111122797", "gene.LOC111103011", "gene.LOC111102955", "gene.LOC111115242", "gene.LOC111102946", "gene.LOC111122802", "gene.LOC111129102", "gene.LOC111135083", "gene.LOC111123056", "gene.LOC111114901", "gene.LOC111103203", "gene.LOC111135078", "gene.LOC111122950", "gene.LOC111113946", "gene.LOC111113894", "gene.LOC111113889", "gene.LOC111133854", "gene.LOC111125112", "gene.LOC111112913", "gene.LOC111133024", "gene.LOC111113081", "gene.LOC111133074", "gene.LOC111105419", "gene.LOC111105505", "gene.LOC111112746", "gene.LOC111132580", "gene.LOC111125437", "gene.LOC111112676", "gene.LOC111112737", "gene.LOC111112685", "gene.LOC111124839", "gene.LOC111124833", "gene.LOC111108926", "gene.LOC111133789", "gene.LOC111129142", "gene.LOC111113799", "gene.LOC111124495", "gene.LOC111129139", "gene.LOC111133497", "gene.LOC111104757", "gene.LOC111113297", "gene.LOC111113346", "gene.LOC111124682", "gene.LOC111124598", "gene.LOC111113471", "gene.LOC111124563", "gene.LOC111118584", "gene.LOC111134059", "gene.LOC111119281", "gene.LOC111119256", "gene.LOC111099487", "gene.LOC111099555", "gene.LOC111119089", "gene.LOC111110302", "gene.LOC111119474", "gene.LOC111105254", "gene.LOC111101392", "gene.LOC111099499", "gene.LOC111117644", "gene.LOC111101452", "gene.LOC111105985", "gene.LOC111107201", "gene.Trnat.ugu.10", "gene.LOC111125066", "gene.LOC111100182", "gene.LOC111108879", "gene.LOC111106739", "gene.LOC111123596", "gene.LOC111106152", "gene.LOC111104339", "gene.LOC111099541", "gene.LOC111119936", "gene.LOC111115467", "gene.LOC111126426", "gene.LOC111122818", "gene.LOC111129655", "gene.LOC111112837", "gene.LOC111112832", "gene.LOC111105825", "gene.LOC111109963", "gene.LOC111115420", "gene.LOC111114009", "gene.LOC111112834", "gene.LOC111116588", "gene.LOC111116952", "gene.LOC111125235", "gene.LOC111105386", "gene.LOC111105781", "gene.LOC111121272", "gene.Trnaa.agc.15", "gene.LOC111129039", "gene.LOC111104187", "gene.LOC111100960", "gene.LOC111135012", "gene.LOC111106057", "gene.LOC111105612", "gene.LOC111128555", "gene.LOC111119241", "gene.LOC111128275", "gene.LOC111100519", "gene.LOC111102310", "gene.LOC111104998", "gene.LOC111099516", "gene.LOC111117685", "gene.LOC111105057", "gene.LOC111103179", "gene.LOC111126446", "gene.LOC111105578", "gene.LOC111101126", "gene.LOC111126504", "gene.LOC111122681", "gene.LOC111103219", "gene.LOC111112739", "gene.LOC111115214", "gene.LOC111103928", "gene.LOC111116380", "gene.Trnaw.cca.2", "gene.LOC111106962", "gene.LOC111132283", "gene.Trnal.aag.8", "gene.LOC111109021", "gene.Trnag.gcc.3", "gene.Trnay.gua.2", "gene.LOC111100961", "gene.LOC111102100", "gene.LOC111103111", "gene.LOC111132693", "gene.LOC111104807", "gene.LOC111112591", "gene.LOC111116288", "gene.LOC111101755", "gene.LOC111133626", "gene.LOC111108000", "gene.LOC111121636", "gene.LOC111115793", "gene.LOC111118828", "gene.LOC111136168", "gene.LOC111105456", "gene.LOC111106058")

Error: Incomplete expression: names.df <- c("Treatment", "TreatmentN", "Sex", "gene.LOC111128233", "gene.LOC111105393", "gene.LOC111116464", "gene.LOC111135088", "gene.LOC111130500", "gene.LOC111127278", "gene.LOC111113969", "gene.LOC111132481", "gene.LOC111105938", "gene.LOC111138283", "gene.LOC111131835", "gene.LOC111129832", "gene.LOC111130487", "gene.LOC111127862", "gene.LOC111110254", "gene.LOC111124688", "gene.LOC111125297", "gene.LOC111116779", "gene.LOC111119607", "gene.LOC111123744", "gene.LOC111124204", "gene.LOC111113829", "gene.LOC111110051", "gene.LOC111104660", "gene.LOC111101623", "gene.LOC111134693", "gene.LOC111132149", "gene.LOC111130074", "gene.LOC111120371", "gene.LOC111109428", "gene.LOC111103964", "gene.LOC111137116", "gene.Trnar.ucu.6", "gene.LOC111107907", "gene.LOC111132919", "gene.LOC111125308", "gene.LOC111119991", "gene.LOC111104989", "gene.LOC111105010", "gene.LOC111131011", "gene.LOC111121753", "gene.LOC111129483", "gene.LOC111108381", "gene.LOC111117476",

Interestingly (and it's due to the "incomplete expression") is that when you try to run this in the Console, the Console starts the next line with a +, indicating that what the user has tried to run is incomplete and it is waiting for the user to enter more info...

[kubu4]

With some more testing, here's the longest vector I'm able to create from the set of column names. Not sure if this is useful or not.

names.df <- c("Treatment", "TreatmentN", "Sex", "gene.LOC111128233", "gene.LOC111105393", "gene.LOC111116464", "gene.LOC111135088", "gene.LOC111130500", "gene.LOC111127278", "gene.LOC111113969", "gene.LOC111132481", "gene.LOC111105938", "gene.LOC111138283", "gene.LOC111131835", "gene.LOC111129832", "gene.LOC111130487", "gene.LOC111127862", "gene.LOC111110254", "gene.LOC111124688", "gene.LOC111125297", "gene.LOC111116779", "gene.LOC111119607", "gene.LOC111123744", "gene.LOC111124204", "gene.LOC111113829", "gene.LOC111110051", "gene.LOC111104660", "gene.LOC111101623", "gene.LOC111134693", "gene.LOC111132149", "gene.LOC111130074", "gene.LOC111120371", "gene.LOC111109428", "gene.LOC111103964", "gene.LOC111137116", "gene.Trnar.ucu.6", "gene.LOC111107907", "gene.LOC111132919", "gene.LOC111125308", "gene.LOC111119991", "gene.LOC111104989", "gene.LOC111105010", "gene.LOC111131011", "gene.LOC111121753", "gene.LOC111129483", "gene.LOC111108381", "gene.LOC111117476", "gene.LOC111106432", "gene.LOC111111499", "gene.LOC111119263", "gene.LOC111117731", "gene.LOC111124459", "gene.LOC111112454", "gene.LOC111104633", "gene.LOC111127078", "gene.LOC111102379", "gene.LOC111122828", "gene.LOC111110666", "gene.LOC111110881", "gene.LOC111136751", "gene.LOC111115668", "gene.LOC111127096", "gene.LOC111126101", "gene.LOC111132698", "gene.LOC111126632", "gene.LOC111137392", "gene.Trnaa.cgc.10", "gene.LOC111116747", "gene.LOC111119683", "gene.LOC111114329", "gene.LOC111103661", "gene.LOC111103366", "gene.LOC111125715", "gene.LOC111116113", "gene.LOC111133423", "gene.LOC111128077", "gene.LOC111137605", "gene.LOC111131581", "gene.LOC111129153", "gene.LOC111137394", "gene.LOC111112011", "gene.LOC111109454", "gene.LOC111137041", "gene.LOC111116960", "gene.LOC111100864", "gene.LOC111106300", "gene.LOC111137433", "gene.LOC111133945", "gene.LOC111105466", "gene.LOC111114537", "gene.LOC111103655", "gene.LOC111123442", "gene.LOC111114881", "gene.LOC111114514", "gene.LOC111116017", "gene.LOC111122971", "gene.LOC111101930", "gene.LOC111122452", "gene.LOC111122497", "gene.LOC111122842", "gene.LOC111135076", "gene.LOC111115118", "gene.LOC111134325", "gene.LOC111136338", "gene.LOC111125156", "gene.LOC111121248", "gene.LOC111113085", "gene.LOC111136798", "gene.LOC111106667", "gene.LOC111136831", "gene.LOC111113176", "gene.LOC111109404", "gene.LOC111113797", "gene.LOC111133762", "gene.LOC111116334", "gene.LOC111104618", "gene.LOC111116388", "gene.LOC111104745", "gene.LOC111100813", "gene.LOC111137068", "gene.LOC111118724", "gene.LOC111127314", "gene.LOC111120101", "gene.LOC111128497", "gene.LOC111100317", "gene.LOC111120228", "gene.LOC111137700", "gene.LOC111130672", "gene.LOC111130648", "gene.LOC111130568", "gene.LOC111119060", "gene.LOC111118035", "gene.LOC111127657", "gene.LOC111138494", "gene.LOC111109863", "gene.LOC111127766", "gene.LOC111138428", "gene.LOC111099887", "gene.LOC111108781", "gene.LOC111128481", "gene.LOC111129979", "gene.LOC111120328", "gene.LOC111127436", "gene.LOC111099124", "gene.LOC111131054", "gene.LOC111107256", "gene.LOC111131372", "gene.LOC111100595", "gene.LOC111102018", "gene.LOC111112249", "gene.LOC111133094", "gene.LOC111109278", "gene.LOC111130400", "gene.LOC111128636", "gene.LOC111102020", "gene.LOC111126100", "gene.LOC111105179", "gene.LOC111121268", "gene.LOC111130907", "gene.LOC111104082", "gene.LOC111100083", "gene.LOC111136434", "gene.LOC111119791", "gene.LOC111113841", "gene.LOC111102016", "gene.LOC111119800", "gene.LOC111108680", "gene.LOC111110534", "gene.LOC111116200", "gene.LOC111106705", "gene.LOC111104173", "gene.LOC111127764", "gene.LOC111136526", "gene.LOC111108919", "gene.LOC111108848", "gene.LOC111100644", "gene.LOC111116938", "gene.LOC111128289", "gene.LOC111135133", "gene.LOC111102649", "gene.LOC111121053", "gene.LOC111132372", "gene.LOC111128300", "gene.LOC111108256", "gene.LOC111122514", "gene.LOC111130785", "gene.LOC111129160", "gene.LOC111109707", "gene.LOC111105929", "gene.LOC111112571", "gene.LOC111103288", "gene.LOC111118662", "gene.LOC111123201", "gene.LOC111121150", "gene.LOC111105511")

Also, with some testing, it appears to me that we might be hitting a maximum number of characters limit or something. I think this because I'm actually able to add an additional short word as another element in the vector (e.g. "pizza"), but cannot add any subsequent short words after that one additional element.

[kubu4]

Current progress: three vectors, each containing a subset of the columns you want. Can use these to select desired columns (e.g. fpkm %>% select(all_of(names.df1))). Then, somehow append all three together to get your final data frame.

names.df1 <- c("Treatment", "TreatmentN", "Sex", "gene.LOC111128233", "gene.LOC111105393", "gene.LOC111116464", "gene.LOC111135088", "gene.LOC111130500", "gene.LOC111127278", "gene.LOC111113969", "gene.LOC111132481", "gene.LOC111105938", "gene.LOC111138283", "gene.LOC111131835", "gene.LOC111129832", "gene.LOC111130487", "gene.LOC111127862", "gene.LOC111110254", "gene.LOC111124688", "gene.LOC111125297", "gene.LOC111116779", "gene.LOC111119607", "gene.LOC111123744", "gene.LOC111124204", "gene.LOC111113829", "gene.LOC111110051", "gene.LOC111104660", "gene.LOC111101623", "gene.LOC111134693", "gene.LOC111132149", "gene.LOC111130074", "gene.LOC111120371", "gene.LOC111109428", "gene.LOC111103964", "gene.LOC111137116", "gene.Trnar.ucu.6", "gene.LOC111107907", "gene.LOC111132919", "gene.LOC111125308", "gene.LOC111119991", "gene.LOC111104989", "gene.LOC111105010", "gene.LOC111131011", "gene.LOC111121753", "gene.LOC111129483", "gene.LOC111108381", "gene.LOC111117476", "gene.LOC111106432", "gene.LOC111111499", "gene.LOC111119263", "gene.LOC111117731", "gene.LOC111124459", "gene.LOC111112454", "gene.LOC111104633", "gene.LOC111127078", "gene.LOC111102379", "gene.LOC111122828", "gene.LOC111110666", "gene.LOC111110881", "gene.LOC111136751", "gene.LOC111115668", "gene.LOC111127096", "gene.LOC111126101", "gene.LOC111132698", "gene.LOC111126632", "gene.LOC111137392", "gene.Trnaa.cgc.10", "gene.LOC111116747", "gene.LOC111119683", "gene.LOC111114329", "gene.LOC111103661", "gene.LOC111103366", "gene.LOC111125715", "gene.LOC111116113", "gene.LOC111133423", "gene.LOC111128077", "gene.LOC111137605", "gene.LOC111131581", "gene.LOC111129153", "gene.LOC111137394", "gene.LOC111112011", "gene.LOC111109454", "gene.LOC111137041", "gene.LOC111116960", "gene.LOC111100864", "gene.LOC111106300", "gene.LOC111137433", "gene.LOC111133945", "gene.LOC111105466", "gene.LOC111114537", "gene.LOC111103655", "gene.LOC111123442", "gene.LOC111114881", "gene.LOC111114514", "gene.LOC111116017", "gene.LOC111122971", "gene.LOC111101930", "gene.LOC111122452", "gene.LOC111122497", "gene.LOC111122842", "gene.LOC111135076", "gene.LOC111115118", "gene.LOC111134325", "gene.LOC111136338", "gene.LOC111125156", "gene.LOC111121248", "gene.LOC111113085", "gene.LOC111136798", "gene.LOC111106667", "gene.LOC111136831", "gene.LOC111113176", "gene.LOC111109404", "gene.LOC111113797", "gene.LOC111133762", "gene.LOC111116334", "gene.LOC111104618", "gene.LOC111116388", "gene.LOC111104745", "gene.LOC111100813", "gene.LOC111137068", "gene.LOC111118724", "gene.LOC111127314", "gene.LOC111120101", "gene.LOC111128497", "gene.LOC111100317", "gene.LOC111120228", "gene.LOC111137700", "gene.LOC111130672", "gene.LOC111130648", "gene.LOC111130568", "gene.LOC111119060", "gene.LOC111118035", "gene.LOC111127657", "gene.LOC111138494", "gene.LOC111109863", "gene.LOC111127766", "gene.LOC111138428", "gene.LOC111099887", "gene.LOC111108781", "gene.LOC111128481", "gene.LOC111129979", "gene.LOC111120328", "gene.LOC111127436", "gene.LOC111099124", "gene.LOC111131054", "gene.LOC111107256", "gene.LOC111131372", "gene.LOC111100595", "gene.LOC111102018", "gene.LOC111112249", "gene.LOC111133094", "gene.LOC111109278", "gene.LOC111130400", "gene.LOC111128636", "gene.LOC111102020", "gene.LOC111126100", "gene.LOC111105179", "gene.LOC111121268", "gene.LOC111130907", "gene.LOC111104082", "gene.LOC111100083", "gene.LOC111136434", "gene.LOC111119791", "gene.LOC111113841", "gene.LOC111102016", "gene.LOC111119800", "gene.LOC111108680", "gene.LOC111110534", "gene.LOC111116200", "gene.LOC111106705", "gene.LOC111104173", "gene.LOC111127764", "gene.LOC111136526", "gene.LOC111108919", "gene.LOC111108848", "gene.LOC111100644", "gene.LOC111116938", "gene.LOC111128289", "gene.LOC111135133", "gene.LOC111102649", "gene.LOC111121053", "gene.LOC111132372", "gene.LOC111128300", "gene.LOC111108256", "gene.LOC111122514", "gene.LOC111130785", "gene.LOC111129160", "gene.LOC111109707", "gene.LOC111105929", "gene.LOC111112571", "gene.LOC111103288", "gene.LOC111118662", "gene.LOC111123201", "gene.LOC111121150", "gene.LOC111105511")

names.df2 <- c("gene.LOC111121104", "gene.LOC111108257", "gene.Trnal.uag.2", "gene.LOC111135867", "gene.LOC111112717", "gene.LOC111102452", "gene.LOC111125305", "gene.LOC111127131", "gene.LOC111127137", "gene.LOC111099903", "gene.LOC111114936", "gene.LOC111106409", "gene.LOC111137458", "gene.LOC111105513", "gene.LOC111107726", "gene.LOC111105891", "gene.LOC111133402", "gene.LOC111100968", "gene.Trnag.gcc.9", "gene.LOC111103844", "gene.LOC111118156", "gene.LOC111116810", "gene.LOC111101305", "gene.LOC111120256", "gene.LOC111100453", "gene.LOC111109336", "gene.LOC111128813", "gene.LOC111100672", "gene.LOC111121926", "gene.LOC111136029", "gene.LOC111099842", "gene.LOC111118407", "gene.LOC111102501", "gene.LOC111122220", "gene.LOC111118341", "gene.LOC111122351", "gene.LOC111135498", "gene.LOC111119436", "gene.LOC111120954", "gene.LOC111137708", "gene.LOC111117650", "gene.LOC111118498", "gene.LOC111118493", "gene.LOC111120549", "gene.LOC111137163", "gene.LOC111122331", "gene.LOC111137130", "gene.LOC111102595", "gene.LOC111121922", "gene.LOC111136106", "gene.LOC111120844", "gene.LOC111119785", "gene.LOC111119790", "gene.LOC111121510", "gene.LOC111100136", "gene.LOC111118047", "gene.LOC111116385", "gene.LOC111121625", "gene.LOC111121439", "gene.LOC111116324", "gene.LOC111117575", "gene.LOC111116322", "gene.LOC111136398", "gene.LOC111119888", "gene.LOC111101998", "gene.LOC111136591", "gene.LOC111121901", "gene.LOC111120806", "gene.LOC111116038", "gene.LOC111120235", "gene.LOC111121232", "gene.LOC111138174", "gene.LOC111116090", "gene.LOC111100401", "gene.LOC111136597", "gene.LOC111116643", "gene.LOC111116603", "gene.LOC111120684", "gene.LOC111100963", "gene.LOC111119735", "gene.LOC111121590", "gene.LOC111108701", "gene.LOC111102787", "gene.LOC111111648", "gene.LOC111130938", "gene.LOC111111318", "gene.LOC111126617", "gene.LOC111126588", "gene.LOC111126412", "gene.LOC111107257", "gene.LOC111130803", "gene.LOC111130794", "gene.LOC111130739", "gene.LOC111107454", "gene.LOC111130747", "gene.LOC111111035", "gene.LOC111130758", "gene.LOC111131386", "gene.LOC111131510", "gene.LOC111112426", "gene.LOC111111805", "gene.LOC111132082", "gene.LOC111112202", "gene.LOC111112225", "gene.LOC111106053", "gene.LOC111105904", "gene.LOC111112128", "gene.LOC111106214", "gene.LOC111106238", "gene.LOC111131716", "gene.LOC111131682", "gene.LOC111126046", "gene.LOC111131865", "gene.LOC111129206", "gene.LOC111110841", "gene.LOC111130546", "gene.LOC111109512", "gene.LOC111127285", "gene.LOC111128457", "gene.LOC111108293", "gene.LOC111108247", "gene.LOC111127879", "gene.LOC111127827", "gene.LOC111129760", "gene.LOC111129718", "gene.LOC111128067", "gene.LOC111128284", "gene.LOC111109758", "gene.LOC111128454", "gene.LOC111129639", "gene.LOC111109889", "gene.LOC111109576", "gene.LOC111110264", "gene.LOC111108053", "gene.LOC111107724", "gene.LOC111110598", "gene.LOC111130363", "gene.LOC111130205", "gene.LOC111127313", "gene.LOC111130325", "gene.LOC111107881", "gene.LOC111127737", "gene.LOC111107992", "gene.LOC111127669", "gene.LOC111127637", "gene.LOC111110438", "gene.LOC111127636", "gene.LOC111112418", "gene.LOC111105854", "gene.LOC111135401", "gene.LOC111134773", "gene.LOC111134571", "gene.LOC111134636", "gene.LOC111134675", "gene.LOC111114684", "gene.LOC111114713", "gene.LOC111134558", "gene.LOC111103876", "gene.LOC111114313", "gene.LOC111134049", "gene.LOC111114036", "gene.LOC111123901", "gene.LOC111123701", "gene.LOC111104106", "gene.LOC111123237", "gene.LOC111134811", "gene.LOC111132496", "gene.LOC111103409", "gene.LOC111122797", "gene.LOC111103011", "gene.LOC111102955", "gene.LOC111115242", "gene.LOC111102946", "gene.LOC111122802", "gene.LOC111129102", "gene.LOC111135083", "gene.LOC111123056", "gene.LOC111114901", "gene.LOC111103203", "gene.LOC111135078", "gene.LOC111122950", "gene.LOC111113946", "gene.LOC111113894", "gene.LOC111113889", "gene.LOC111133854", "gene.LOC111125112", "gene.LOC111112913", "gene.LOC111133024", "gene.LOC111113081", "gene.LOC111133074")

names.df3 <- c("gene.LOC111105419", "gene.LOC111105505", "gene.LOC111112746", "gene.LOC111132580", "gene.LOC111125437", "gene.LOC111112676", "gene.LOC111112737", "gene.LOC111112685", "gene.LOC111124839", "gene.LOC111124833", "gene.LOC111108926", "gene.LOC111133789", "gene.LOC111129142", "gene.LOC111113799", "gene.LOC111124495", "gene.LOC111129139", "gene.LOC111133497", "gene.LOC111104757", "gene.LOC111113297", "gene.LOC111113346", "gene.LOC111124682", "gene.LOC111124598", "gene.LOC111113471", "gene.LOC111124563", "gene.LOC111118584", "gene.LOC111134059", "gene.LOC111119281", "gene.LOC111119256", "gene.LOC111099487", "gene.LOC111099555", "gene.LOC111119089", "gene.LOC111110302", "gene.LOC111119474", "gene.LOC111105254", "gene.LOC111101392", "gene.LOC111099499", "gene.LOC111117644", "gene.LOC111101452", "gene.LOC111105985", "gene.LOC111107201", "gene.Trnat.ugu.10", "gene.LOC111125066", "gene.LOC111100182", "gene.LOC111108879", "gene.LOC111106739", "gene.LOC111123596", "gene.LOC111106152", "gene.LOC111104339", "gene.LOC111099541", "gene.LOC111119936", "gene.LOC111115467", "gene.LOC111126426", "gene.LOC111122818", "gene.LOC111129655", "gene.LOC111112837", "gene.LOC111112832", "gene.LOC111105825", "gene.LOC111109963", "gene.LOC111115420", "gene.LOC111114009", "gene.LOC111112834", "gene.LOC111116588", "gene.LOC111116952", "gene.LOC111125235", "gene.LOC111105386", "gene.LOC111105781", "gene.LOC111121272", "gene.Trnaa.agc.15", "gene.LOC111129039", "gene.LOC111104187", "gene.LOC111100960", "gene.LOC111135012", "gene.LOC111106057", "gene.LOC111105612", "gene.LOC111128555", "gene.LOC111119241", "gene.LOC111128275", "gene.LOC111100519", "gene.LOC111102310", "gene.LOC111104998", "gene.LOC111099516", "gene.LOC111117685", "gene.LOC111105057", "gene.LOC111103179", "gene.LOC111126446", "gene.LOC111105578", "gene.LOC111101126", "gene.LOC111126504", "gene.LOC111122681", "gene.LOC111103219", "gene.LOC111112739", "gene.LOC111115214", "gene.LOC111103928", "gene.LOC111116380", "gene.Trnaw.cca.2", "gene.LOC111106962", "gene.LOC111132283", "gene.Trnal.aag.8", "gene.LOC111109021", "gene.Trnag.gcc.3", "gene.Trnay.gua.2", "gene.LOC111100961", "gene.LOC111102100", "gene.LOC111103111", "gene.LOC111132693", "gene.LOC111104807", "gene.LOC111112591", "gene.LOC111116288", "gene.LOC111101755", "gene.LOC111133626", "gene.LOC111108000", "gene.LOC111121636", "gene.LOC111115793", "gene.LOC111118828", "gene.LOC111136168", "gene.LOC111105456", "gene.LOC111106058")

[sr320]

Thanks - glad to see I am not missing something obvious.

I will probably just do work around / work cleaner by using dpylr::inner_join, after a pivot_longer.

[kubu4]

Heads up, I think you might need to add an argument with pivot_longer to handle column names containing dots. Not at computer ATM, so can't check. But, I noticed something earlier today when reading the help for ,select().

[kubu4]

Came up with a better solution!

The trick is to create a newline-delimited text file with your list of columns. Then, read the text file into a vector using readlines().

## Read in newline-delimited list of gene names
gene.selection <- readLines("~/Downloads/genes_of_interest.txt")

## Select genes of interest from fpkm data frame
select.treat <- fpkm %>% select(all_of(gene.selection))