RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA450343" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 15 ✖

bioproject 1

  • PRJNA450343 · 15 ✖

analysis 1

  • diamond · 15 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
26696102 26696102 PRJNA450343_P_NODE_11081_length_166_cov_1.735043_g11013_i0 PRJNA450343 11081 166 1.735043 2.88017138 unclassified Actinoplanes 2626549 Bacteria Bacteria 40.8 0.0375   NR WP_364659926.1 2626549 g11013 i0 48.7 0.704819277108434 39 15 70.5 1 11 127 57 90 WP_364659926.1 MULTISPECIES: hypothetical protein [unclassified Actinoplanes] diamond 117 40.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Actinoplanes  
26902670 26902670 PRJNA450343_P_NODE_6381_length_212_cov_0.871166_g6313_i0 PRJNA450343 6381 212 0.871166 1.84687192 Bacillota 1239 Bacteria Bacteria 45.8 0.00148   NR WP_207635140.1 73919 g6313 i0 46.8 2.25 47 21 66.5 1 3 143 39 81 WP_207635140.1 DoxX family protein [Thermaerobacter marianensis] diamond 477 46.2 0.991341991341991 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiales Family XVII. Incertae Sedis Thermaerobacter Thermaerobacter marianensis
27076066 27076066 PRJNA450343_P_NODE_12362_length_164_cov_0.886957_g12294_i0 PRJNA450343 12362 164 0.886957 1.45460948 Clostridiales bacterium 1898207 Bacteria Bacteria 40.4 0.0418   NR MBE7082886.1 1898207 g12294 i0 47.4 0.695121951219512 38 19 67.7 1 147 37 47 84 MBE7082886.1 DUF4363 family protein [Clostridiales bacterium] diamond 114 40.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
27202314 27202314 PRJNA450343_P_NODE_9322_length_179_cov_0.969231_g9254_i0 PRJNA450343 9322 179 0.969231 1.73492349 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 43.1 0.0116   NR MBP3519882.1 2485925 g9254 i0 33.3 0.905027932960894 54 30 85.5 2 9 161 296 346 MBP3519882.1 hypothetical protein [Oscillospiraceae bacterium] diamond 162 43.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
27549906 27549906 PRJNA450343_P_NODE_11024_length_167_cov_0.864407_g10956_i0 PRJNA450343 11024 167 0.864407 1.44355969 Cellulomonas sp. 40001 Bacteria Bacteria 40 0.0282   NR MCG2801832.1 40001 g10956 i0 45.5 0.592814371257485 33 18 59.3 0 40 138 45 77 MCG2801832.1 hypothetical protein [Cellulomonas sp.] diamond 99 40 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Cellulomonadaceae Cellulomonas Cellulomonas sp.
27976686 27976686 PRJNA450343_P_NODE_11145_length_166_cov_1.230769_g11077_i0 PRJNA450343 11145 166 1.230769 2.04307654 root 1 Root_unresolved Root_unresolved 96.7 8.28e-22   NR WP_147358145.1 29363 g11077 i0 92.5 15.289156626506 53 4 95.8 0 164 6 299 351 WP_147358145.1 hypothetical protein, partial [Clostridium paraputrificum] diamond 2538 97.1 0.995880535530381 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium paraputrificum
28844372 28844372 PRJNA450343_P_NODE_6248_length_214_cov_0.927273_g6180_i0 PRJNA450343 6248 214 0.927273 1.98436422 Gaiellaceae bacterium 2838783 Bacteria Bacteria 43.1 0.0142   NR HET7567241.1 2838783 g6180 i0 36.9 0.911214953271028 65 41 91.1 0 200 6 107 171 HET7567241.1 guanylate kinase [Gaiellaceae bacterium] diamond 195 43.1 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales Gaiellaceae   Gaiellaceae bacterium
29160560 29160560 PRJNA450343_P_NODE_12629_length_163_cov_1.438596_g12561_i0 PRJNA450343 12629 163 1.438596 2.34491148 Catenulispora sp. 13_1_2 1962977 Bacteria Bacteria 42.7 0.00672   NR OLE22768.1 1805055 g12561 i0 42.6 2.61349693251534 47 25 82.8 1 1 135 11 57 OLE22768.1 MAG: hypothetical protein AUG49_18025 [Catenulispora sp. 13_1_20CM_3_70_7] diamond 426 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Catenulisporales Catenulisporaceae Catenulispora Catenulispora sp. 13_1_20CM_3_70_7
29633492 29633492 PRJNA450343_P_NODE_7470_length_197_cov_2.425676_g7402_i0 PRJNA450343 7470 197 2.425676 4.77858172 Parageobacillus thermoglucosidasius 1426 Bacteria Bacteria 106 3.44e-28   NR WP_338206249.1 1426 g7402 i0 95 17.3604060913706 60 3 91.4 0 196 17 2 61 WP_338206249.1 cytochrome c oxidase subunit II transmembrane domain-containing protein, partial [Parageobacillus thermoglucosidasius] diamond 3420 107 0.990654205607477 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Parageobacillus Parageobacillus thermoglucosidasius
30581372 30581372 PRJNA450343_P_NODE_6713_length_207_cov_0.968354_g6645_i0 PRJNA450343 6713 207 0.968354 2.00449278 Clostridia bacterium 2044939 Bacteria Bacteria 48.1 3.05e-4   NR MBQ4339359.1 2044939 g6645 i0 40.4 0.753623188405797 52 31 75.4 0 177 22 110 161 MBQ4339359.1 InlB B-repeat-containing protein [Clostridia bacterium] diamond 156 48.1 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
30929181 30929181 PRJNA450343_P_NODE_13974_length_161_cov_0.910714_g13906_i0 PRJNA450343 13974 161 0.910714 1.46624954 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 62 6.85e-11   NR WP_406812968.1 1590 g13906 i0 51.9 0.968944099378882 52 25 96.9 0 4 159 6 57 WP_406812968.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 156 62 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
31055860 31055860 PRJNA450343_P_NODE_3935_length_268_cov_1.232877_g3867_i0 PRJNA450343 3935 268 1.232877 3.30411036 Clostridium sp. 1xD42-85 2320084 Bacteria Bacteria 127 2.59e-36   NR RKI73319.1 2320084 g3867 i0 96.7 0.682835820895522 61 2 68.3 0 185 3 1 61 RKI73319.1 hypothetical protein D7V87_20275, partial [Clostridium sp. 1xD42-85] diamond 183 127 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. 1xD42-85
32194227 32194227 PRJNA450343_P_NODE_9918_length_173_cov_1.120968_g9850_i0 PRJNA450343 9918 173 1.120968 1.93927464 Hathewaya massiliensis 1964382 Bacteria Bacteria 41.6 0.0371   NR WP_142414270.1 1964382 g9850 i0 43.2 0.763005780346821 44 25 76.3 0 35 166 193 236 WP_142414270.1 calcium/proton exchanger [Hathewaya massiliensis] diamond 132 41.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Hathewaya Hathewaya massiliensis
32793964 32793964 PRJNA450343_P_NODE_8720_length_184_cov_1.503704_g8652_i0 PRJNA450343 8720 184 1.503704 2.76681536 Kocuria palustris 71999 Bacteria Bacteria 116 5.57e-29   NR WP_314302375.1 71999 g8652 i0 100 1.98913043478261 61 0 99.5 0 183 1 31 91 WP_314302375.1 hypothetical protein [Kocuria palustris] diamond 366 116 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Kocuria Kocuria palustris
32904777 32904777 PRJNA450343_P_NODE_11200_length_166_cov_0.871795_g11132_i0 PRJNA450343 11200 166 0.871795 1.4471797 Actinomyces 1654 Bacteria Bacteria 42 0.014   NR MBF0944221.1 29317 g11132 i0 41.9 1.55421686746988 43 25 77.7 0 133 5 42 84 MBF0944221.1 MFS transporter [Actinomyces sp.] diamond 258 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Actinomyces Actinomyces sp.

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;