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…

Continue Reading BLAST reference genome indexing

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…

Continue Reading Installation and set up of R6 rocker object

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…

Continue Reading R connection to sqlite – Stackify

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…

Continue Reading r – RSQlite – Find values with most occurences in group