| Table: Category | |
| # | CatName TEXT |
| 1 | Sequence |
| 2 | Sequence - Database similarity |
| 3 | Sequence - pairwise similarity |
| Table: ComType | |
| # | Type TEXT |
| 1 | command |
| 2 | interactive |
| 3 | gui |
| 4 | _birch_ |
| 5 | birchadmin |
| 6 | bldna |
| 7 | blnalign |
| 8 | blprotein |
| 9 | blpalign |
| 10 | bldata |
| 11 | blmarker |
| 12 | blnfetch |
| 13 | blpfetch |
| 14 | blreads |
| 15 | blncbi |
| 16 | bltable |
| 17 | bltree |
| Table: File | |||
| # | Description TEXT | PathOrURL TEXT | Action TEXT |
| 1 | Manual | bachrest.txt | $DBFileViewer |
| 2 | Manual | numseq.txt | $DBFileViewer |
| 3 | Manual | blastn.txt | $DBFileViewer |
| 4 | Manual | blastx.txt | $DBFileViewer |
| 5 | Manual | ribosome.txt | $DBFileViewer |
| 6 | Manual | ssearch.txt | $DBFileViewer |
| 7 | Manual | fasta.txt | $DBFileViewer |
| Table: package | |
| # | Name TEXT |
| 1 | fasta |
| 2 | fsap |
| 3 | BLAST |
| 4 | xylem |
| Table: PkgProg | ||
| # | Package TEXT | Program TEXT |
| 1 | fsap | numseq |
| 2 | fsap | bachrest |
| 3 | fasta | ssearch3 |
| 4 | fasta | fasta |
| 5 | xylem | ribosome |
| 6 | BLAST | blastx |
| 7 | BLAST | blastn |
| Table: Platform | |
| # | Name TEXT |
| 1 | linux-x86_64 |
| 2 | linux-arm64 |
| 3 | osx-x86_64 |
| 4 | macos-arm64 |
| Table: ProgCat | ||
| # | Program TEXT | Category TEXT |
| 1 | numseq | Sequence |
| 2 | bachrest | Sequence |
| 3 | blastn | Sequence - Database similarity |
| 4 | blastx | Sequence - Database similarity |
| 5 | ribosome | Sequence |
| 6 | ssearch3 | Sequence - pairwise similarity |
| 7 | fasta | Sequence - pairwise similarity |
| Table: ProgLaunch | |||
| # | Program TEXT | Command TEXT | Params TEXT |
| 1 | numseq | bldna | DNA/RNA --> numseq |
| 2 | bachrest | bldna | DNA/RNA --> bachrest |
| 3 | numseq | interactive | numseq |
| 4 | blastn | command | blastn <params> |
| Table: ProgPlat | ||
| # | Program TEXT | Platform TEXT |
| 1 | numseq | linux-x86_64 |
| 2 | numseq | linux-arm64 |
| 3 | numseq | osx-x86_64 |
| 4 | numseq | macos-arm64 |
| 5 | bachrest | linux-x86_64 |
| 6 | bachrest | linux-arm64 |
| 7 | bachrest | osx-x86_64 |
| 8 | blastn | linux-x86_64 |
| 9 | blastn | linux-arm64 |
| 10 | blastn | osx-x86_64 |
| 11 | blastn | macos-arm64 |
| 12 | blastx | linux-x86_64 |
| 13 | blastx | linux-arm64 |
| 14 | blastx | osx-x86_64 |
| 15 | blastx | macos-arm64 |
| Table: program | |||||
| # | Name TEXT | Description TEXT | Documentation TEXT | Install TEXT | Platforms TEXT |
| 1 | numseq | print sequences | numseq.txt | BIRCH | LX,LA,OX,MA |
| 2 | bachrest | rest. site search | bachrest.txt | BIRCH | LX,LA,OX,MA |
| 3 | blastn | DNA vs. DNA database | blastn.txt | BIRCH | LX,LA,OX,MA |
| 4 | blastx | trans. DNA vs. protein | blastx.txt | BIRCH | LX,LA,OX,MA |
| 5 | ribosome | translate DNA to protein | ribosome.txt | BIRCH | LX,LA,OX,MA |
| 6 | ssearch3 | Smith Waterman alignment | ssearch.txt | BIRCH | LX,LA,OX,MA |
| 7 | fasta | DNA, protein database search | fasta.txt | local | LX,LA,OX,MA |
| Index: program.idx | ||
| For table: | program | |
| Unique: | No | |
| Column | Collating | Sort order |
| Name | ASC | |
| View: BLASTprogs |
select Name,Description from program, PkgProg where (PkgProg.Program = program.Name) AND (PkgProg.Package = "BLAST") |