RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA448207" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 19 ✖

bioproject 1

  • PRJNA448207 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
9366568 9366568 PRJNA448207_P_NODE_20268_length_286_cov_0.859155_g20105_i0 PRJNA448207 20268 286 0.859155 2.4571833 Staphylococcus warneri 1292 Bacteria Bacteria 126 2.3e-33   NR MDU6254963.1 1292 g20105 i0 85.5 1.59440559440559 76 11 79.7 0 228 1 147 222 MDU6254963.1 tyrosine-type recombinase/integrase [Staphylococcus warneri] diamond 456 126 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
14467500 14467500 PRJNA448207_P_NODE_32092_length_242_cov_1.366864_g31929_i0 PRJNA448207 32092 242 1.366864 3.30781088 Bacillati 1783272 Bacteria Bacteria 132 1.48e-33   NR MDQ2886929.1 2026724 g31929 i0 80 49.8595041322314 80 16 99.2 0 2 241 222 301 MDQ2886929.1 carbamoyl-phosphate synthase (glutamine-hydrolyzing) large subunit [Chloroflexota bacterium] diamond 12066 132 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
27186966 27186966 PRJNA448207_S_NODE_3222_length_257_cov_1.451087_g3211_i0 PRJNA448207 3222 257 1.451087 3.72929359 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 45.8 0.00347   NR PZO14380.1 47253 g3211 i0 69 1.33073929961089 29 9 33.9 0 16 102 345 373 PZO14380.1 MAG: 4-hydroxyphenylpyruvate dioxygenase [Leptolyngbya foveolarum] diamond 342 45.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya foveolarum
27676540 27676540 PRJNA448207_P_NODE_27004_length_249_cov_0.875000_g26841_i0 PRJNA448207 27004 249 0.875 2.17875 Corynebacterium urealyticum 43771 Bacteria Bacteria 91.3 1.18e-21   NR WP_012359291.1 43771 g26841 i0 54.7 1.80722891566265 75 34 90.4 0 248 24 30 104 WP_012359291.1 transglycosylase family protein [Corynebacterium urealyticum] diamond 450 91.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium urealyticum
27897193 27897193 PRJNA448207_P_NODE_24145_length_259_cov_1.086022_g23982_i0 PRJNA448207 24145 259 1.086022 2.81279698 Streptomyces hesseae 3075519 Bacteria Bacteria 42.7 0.0453   NR WP_311615994.1 3075519 g23982 i0 38.9 0.625482625482625 54 30 59.1 1 43 195 216 269 WP_311615994.1 hypothetical protein [Streptomyces hesseae] diamond 162 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces hesseae
28150047 28150047 PRJNA448207_P_NODE_22965_length_267_cov_1.484536_g22802_i0 PRJNA448207 22965 267 1.484536 3.96371112 Streptomyces sp. NBC_ 1931 Bacteria Bacteria 41.6 0.0482   NR WUD79158.1 2903659 g22802 i0 46.5 0.48314606741573 43 22 48.3 1 150 22 13 54 WUD79158.1 transposase [Streptomyces sp. NBC_00503] diamond 129 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NBC_00503
29065676 29065676 PRJNA448207_S_NODE_1648_length_340_cov_2.722846_g1637_i0 PRJNA448207 1648 340 2.722846 9.2576764 Anabaena azotica 197653 Bacteria Bacteria 47 0.00338   NR WP_413172610.1 197653 g1637 i0 37.9 0.838235294117647 95 57 82.1 1 32 310 71 165 WP_413172610.1 glycosyltransferase family 1 protein [Anabaena azotica] diamond 285 47 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Anabaena Anabaena azotica
29223605 29223605 PRJNA448207_P_NODE_25949_length_250_cov_1.372881_g25786_i0 PRJNA448207 25949 250 1.372881 3.4322025 Nocardioides sp. 35761 Bacteria Bacteria 43.1 0.0285   NR MEI2715088.1 35761 g25786 i0 37.9 0.696 58 30 69.6 2 3 176 168 219 MEI2715088.1 glycosyltransferase 87 family protein [Nocardioides sp.] diamond 174 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides sp.
29254736 29254736 PRJNA448207_P_NODE_26569_length_250_cov_0.870056_g26406_i0 PRJNA448207 26569 250 0.870056 2.17514 Cyanobacteria bacterium J06632_3 3023193 Bacteria Bacteria 42.7 0.0392   NR MEO1622368.1 3023193 g26406 i0 47.5 0.48 40 17 43.2 2 16 123 117 156 MEO1622368.1 apolipoprotein N-acyltransferase [Cyanobacteria bacterium J06632_3] diamond 120 42.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06632_3
29760006 29760006 PRJNA448207_P_NODE_27091_length_249_cov_0.875000_g26928_i0 PRJNA448207 27091 249 0.875 2.17875 Streptomyces kaniharaensis 212423 Bacteria Bacteria 72.4 1.41e-12   NR WP_230211146.1 212423 g26928 i0 48.1 1.89156626506024 81 40 97.6 2 246 4 363 441 WP_230211146.1 flavin monoamine oxidase family protein [Streptomyces kaniharaensis] diamond 471 72.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces kaniharaensis
30013000 30013000 PRJNA448207_P_NODE_25211_length_251_cov_1.544944_g25048_i0 PRJNA448207 25211 251 1.544944 3.87780944 Veillonella sp. 1926307 Bacteria Bacteria 135 4.59e-39   NR WP_366512514.1 1926307 g25048 i0 73.2 1.9601593625498 82 22 98 0 251 6 16 97 WP_366512514.1 hypothetical protein [Veillonella sp.] diamond 492 135 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella sp.
30897682 30897682 PRJNA448207_P_NODE_11614_length_366_cov_0.798635_g11452_i0 PRJNA448207 11614 366 0.798635 2.9230041 Streptosporangiaceae bacterium 2339230 Bacteria Bacteria 43.5 0.0389   NR HEY1918912.1 2339230 g11452 i0 34.2 0.622950819672131 76 47 62.3 1 90 317 44 116 HEY1918912.1 SSI family serine proteinase inhibitor [Streptosporangiaceae bacterium] diamond 228 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae   Streptosporangiaceae bacterium
31498338 31498338 PRJNA448207_S_NODE_2936_length_269_cov_0.994898_g2925_i0 PRJNA448207 2936 269 0.994898 2.67627562 Candidatus Limnocylindrales bacterium 2952938 Bacteria Bacteria 43.1 0.0285   NR HEY8868810.1 2952938 g2925 i0 40.7 0.602230483271376 54 32 60.2 0 245 84 64 117 HEY8868810.1 hypothetical protein [Candidatus Limnocylindrales bacterium] diamond 162 43.1 1 Bacteria   Bacillati Chloroflexota Candidatus Limnocylindria Candidatus Limnocylindrales     Candidatus Limnocylindrales bacterium
31656118 31656118 PRJNA448207_P_NODE_33657_length_233_cov_5.231250_g33494_i0 PRJNA448207 33657 233 5.23125 12.1888125 Kitasatospora sp. NPDC 1871188 Bacteria Bacteria 43.1 0.0239   NR WP_355669325.1 3154555 g33494 i0 44.4 0.695278969957081 54 24 64.4 2 230 81 96 147 WP_355669325.1 asparagine synthase-related protein [Kitasatospora sp. NPDC004669] diamond 162 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Kitasatospora Kitasatospora sp. NPDC004669
31972631 31972631 PRJNA448207_P_NODE_9118_length_408_cov_0.904478_g8956_i0 PRJNA448207 9118 408 0.904478 3.69027024 Streptomyces typhae 2681492 Bacteria Bacteria 44.7 0.041   NR WP_157168098.1 2681492 g8956 i0 42.3 0.382352941176471 52 29 37.5 1 57 209 307 358 WP_157168098.1 phosphatase PAP2 family protein [Streptomyces typhae] diamond 156 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces typhae
32383967 32383967 PRJNA448207_P_NODE_6499_length_474_cov_1.728180_g6337_i0 PRJNA448207 6499 474 1.72818 8.1915732 Saccharopolyspora flava 95161 Bacteria Bacteria 50.4 6.98e-4   NR WP_093418561.1 95161 g6337 i0 44.3 0.5 79 41 48.7 2 390 160 20 97 WP_093418561.1 LLM class flavin-dependent oxidoreductase [Saccharopolyspora flava] diamond 237 50.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Saccharopolyspora Saccharopolyspora flava
32668156 32668156 PRJNA448207_S_NODE_2860_length_272_cov_1.216080_g2849_i0 PRJNA448207 2860 272 1.21608 3.3077376 Armatimonadota bacterium 2033014 Bacteria Bacteria 46.2 0.00132   NR HCA47543.1 2033014 g2849 i0 39.6 0.529411764705882 48 29 52.9 0 58 201 83 130 HCA47543.1 hypothetical protein [Armatimonadota bacterium] diamond 144 46.2 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
32699619 32699619 PRJNA448207_P_NODE_5260_length_525_cov_1.356195_g5101_i0 PRJNA448207 5260 525 1.356195 7.12002375 Coleofasciculus sp. 3100458 Bacteria Bacteria 43.1 0.0473   NR MFP5273888.1 3100458 g5101 i0 33 0.52 91 54 52 1 411 139 5 88 MFP5273888.1 hypothetical protein [Coleofasciculus sp.] diamond 273 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Coleofasciculus Coleofasciculus sp.
32762662 32762662 PRJNA448207_P_NODE_30440_length_245_cov_0.889535_g30277_i0 PRJNA448207 30440 245 0.889535 2.17936075 Clostridium thermobutyricum 29372 Bacteria Bacteria 61.6 5.97e-10   NR ENZ01799.1 29372 g30277 i0 47.5 0.746938775510204 61 32 74.7 0 190 8 18 78 ENZ01799.1 30S ribosomal protein S15 [Clostridium thermobutyricum] diamond 183 61.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium thermobutyricum

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);;