Tag: mydb
BLAST reference genome indexing
BLAST reference genome indexing 1 For some softwares I have had to index a reference genome prior to using blastn. Here is an example command: makeblastdb –in mydb.fsa –dbtype nucl –parse_seqids Whenever I do this I retain the original fasta file plus a bunch of extra files made by the…
Installation and set up of R6 rocker object
Installation of current released version from CRAN install.packages(“rocker”) Installation of current development version from GitHub install.packages(“devtools”) devtools::install_github(“nikolaus77/rocker”) Create new rocker database handling object Option 1 db <- rocker::newDB() # New database handling object #> dctr | New object Option 2 db <- rocker::rocker$new() # New database handling object #> dctr…
R connection to sqlite – Stackify
SQLite is a file level database, hence to reference it requires a full directory path. No where do you specify the working directory or a full path in the file name. By default, R will use the current working directory contained in getwd(). If database is not contained in this…
r – RSQlite – Find values with most occurences in group
I’m using RSQlite to import Datasets from an SQlite-Database. There are multiple millions of observations within the Database. Therefor I’d like to do as much as possible of Data selection and aggregation within the Database. At some point I need to aggregate a character variable. I want to get the…