Dataframe by hand

Here are some vector

prefix <-  c("NC_","NG_",
             "NM_","NR_",
             "NP_",
             "NT_ / NW_", "XM_","XR_","XP_")
type <- c(rep("known",6), rep("model",3))
description <- c("Complete genomic molecule (Reference assembly)",
                 "Incomplete genomic region",
                 "mRNA","Non-coding RNA",
                 "Protein",
                 "Genomic contig or scaffold",
                 "mRNA (Predicted model)",
                 "Non-coding RNA (Predicted model)",
                 "Protein (Predicted model)")

We can make a dataframe from them with data.frame

df <- data.frame(prefix,
                 type,
                 description)

df
##      prefix  type                                    description
## 1       NC_ known Complete genomic molecule (Reference assembly)
## 2       NG_ known                      Incomplete genomic region
## 3       NM_ known                                           mRNA
## 4       NR_ known                                 Non-coding RNA
## 5       NP_ known                                        Protein
## 6 NT_ / NW_ known                     Genomic contig or scaffold
## 7       XM_ model                         mRNA (Predicted model)
## 8       XR_ model               Non-coding RNA (Predicted model)
## 9       XP_ model                      Protein (Predicted model)

We can modify the names we want to use for the columns like this

df <- data.frame(RefSeq_prefix = prefix,
                 known_or_pred  = type,
                 Notes = description)

df
##   RefSeq_prefix known_or_pred                                          Notes
## 1           NC_         known Complete genomic molecule (Reference assembly)
## 2           NG_         known                      Incomplete genomic region
## 3           NM_         known                                           mRNA
## 4           NR_         known                                 Non-coding RNA
## 5           NP_         known                                        Protein
## 6     NT_ / NW_         known                     Genomic contig or scaffold
## 7           XM_         model                         mRNA (Predicted model)
## 8           XR_         model               Non-coding RNA (Predicted model)
## 9           XP_         model                      Protein (Predicted model)