RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA1237888" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 23 ✖

bioproject 1

  • PRJNA1237888 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
1049756 1049756 PRJNA1237888_S_NODE_7281_length_163_cov_0.912281_g7231_i0 PRJNA1237888 7281 163 0.912281 1.48701803 Brachybacterium epidermidis 2781983 Bacteria Bacteria 104 1.3399999999999999e-25   NR WP_412019672.1 2781983 g7231 i0 92.6 0.993865030674847 54 4 99.4 0 1 162 19 72 WP_412019672.1 bifunctional hydroxymethylpyrimidine kinase/phosphomethylpyrimidine kinase [Brachybacterium epidermidis] diamond 162 104 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermabacteraceae Brachybacterium Brachybacterium epidermidis
1621300 1621300 PRJNA1237888_S_NODE_6082_length_169_cov_0.866667_g6032_i0 PRJNA1237888 6082 169 0.866667 1.46466723 Leifsonia sp. fls2-241-R2A-4 1870902 Bacteria Bacteria 113 2.63e-29   NR WP_285115130.1 3040290 g6032 i0 98.2 0.994082840236686 56 1 99.4 0 168 1 140 195 WP_285115130.1 hydrogen peroxide-dependent heme synthase [Leifsonia sp. fls2-241-R2A-40a] diamond 168 113 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leifsonia Leifsonia sp. fls2-241-R2A-40a
11253108 11253108 PRJNA1237888_S_NODE_6789_length_165_cov_0.896552_g6739_i0 PRJNA1237888 6789 165 0.896552 1.4793108 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 57.8 6.24e-8   NR MET0146444.1 2497619 g6739 i0 59.3 0.981818181818182 54 22 98.2 0 2 163 338 391 MET0146444.1 hypothetical protein [Ilumatobacteraceae bacterium] diamond 162 57.8 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
15649660 15649660 PRJNA1237888_S_NODE_6853_length_165_cov_0.896552_g6803_i0 PRJNA1237888 6853 165 0.896552 1.4793108 Actinomyces sp. HMSC 29317 Bacteria Bacteria 105 3.98e-27   NR WP_286131160.1 1739406 g6803 i0 92.7 2 55 4 100 0 1 165 35 89 WP_286131160.1 hypothetical protein [Actinomyces sp. HMSC035G02] diamond 330 105 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Actinomyces Actinomyces sp. HMSC035G02
26775337 26775337 PRJNA1237888_S_NODE_2621_length_251_cov_5.311881_g2571_i0 PRJNA1237888 2621 251 5.311881 13.33282131 root 1 Root_unresolved Root_unresolved 169 2.46e-52   NR MDK0657390.1 1502 g2571 i0 98.8 80.3426294820717 83 1 99.2 0 249 1 31 113 MDK0657390.1 30S ribosomal protein S8 [Clostridium perfringens] diamond 20166 170 0.994117647058824 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium perfringens
27660483 27660483 PRJNA1237888_S_NODE_7564_length_159_cov_14.790909_g7514_i0 PRJNA1237888 7564 159 14.790909 23.51754531 root 1 Root_unresolved Root_unresolved 63.9 3.95e-10   NR QHG77622.1 1280 g7514 i0 90.6 24 53 5 100 0 1 159 27 79 QHG77622.1 30S ribosomal protein S5 [Staphylococcus aureus] diamond 3816 64.3 0.993779160186625 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
27912692 27912692 PRJNA1237888_S_NODE_6405_length_167_cov_0.881356_g6355_i0 PRJNA1237888 6405 167 0.881356 1.47186452 Mycobacteroides 670516 Bacteria Bacteria 101 3.1499999999999995e-23   NR CPW90708.1 36809 g6355 i0 96.4 7.90419161676647 55 2 98.8 0 167 3 449 503 CPW90708.1 Hypothetical protein ERS075547_08931 [Mycobacteroides abscessus] diamond 1320 101 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacteroides Mycobacteroides abscessus
28273436 28273436 PRJNA1237888_S_NODE_7226_length_163_cov_0.912281_g7176_i0 PRJNA1237888 7226 163 0.912281 1.48701803 Bifidobacterium bombi 471511 Bacteria Bacteria 42.7 0.0126   NR WP_044088114.1 471511 g7176 i0 42.2 6.6441717791411 45 25 82.8 1 147 13 249 292 WP_044088114.1 AbaSI family restriction endonuclease [Bifidobacterium bombi] diamond 1083 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Bifidobacterium Bifidobacterium bombi
28639319 28639319 PRJNA1237888_S_NODE_7147_length_163_cov_1.807018_g7097_i0 PRJNA1237888 7147 163 1.807018 2.94543934 root 1 Root_unresolved Root_unresolved 63.5 8.6e-12   NR WP_369599335.1 1590 g7097 i0 100 112.306748466258 27 0 49.7 0 163 83 33 59 WP_369599335.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 18306 63.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
29126351 29126351 PRJNA1237888_S_NODE_6669_length_166_cov_0.888889_g6619_i0 PRJNA1237888 6669 166 0.888889 1.47555574 Lawsonella 1847725 Bacteria Bacteria 105 1.28e-25   NR WP_290599322.1 1847725 g6619 i0 100 0.993975903614458 55 0 99.4 0 1 165 6 60 WP_290599322.1 MULTISPECIES: hypothetical protein [Lawsonella] diamond 165 105 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
29694055 29694055 PRJNA1237888_S_NODE_5310_length_179_cov_1.584615_g5260_i0 PRJNA1237888 5310 179 1.584615 2.83646085 Staphylococcus warneri 1292 Bacteria Bacteria 129 1.12e-33   NR MDU6255230.1 1292 g5260 i0 100 0.988826815642458 59 0 98.9 0 1 177 17 75 MDU6255230.1 hypothetical protein [Staphylococcus warneri] diamond 177 129 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
29788976 29788976 PRJNA1237888_S_NODE_7471_length_162_cov_0.920354_g7421_i0 PRJNA1237888 7471 162 0.920354 1.49097348 Rothia kristinae 37923 Bacteria Bacteria 60.5 6.13e-10   NR WP_224799608.1 37923 g7421 i0 50 0.962962962962963 52 26 96.3 0 2 157 61 112 WP_224799608.1 hypothetical protein [Rothia kristinae] diamond 156 60.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Rothia Rothia kristinae
30104943 30104943 PRJNA1237888_S_NODE_6592_length_166_cov_0.888889_g6542_i0 PRJNA1237888 6592 166 0.888889 1.47555574 Microlunatus lacustris 88568 Bacteria Bacteria 94 3.51e-21   NR GAA1432589.1 88568 g6542 i0 92.6 0.975903614457831 54 4 97.6 0 3 164 220 273 GAA1432589.1 LCP family protein [Microlunatus lacustris] diamond 162 94 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Microlunatus Microlunatus lacustris
30389821 30389821 PRJNA1237888_S_NODE_2353_length_265_cov_2.041667_g2303_i0 PRJNA1237888 2353 265 2.041667 5.41041755 Chthonomonadales bacterium 2282151 Bacteria Bacteria 46.6 0.00213   NR NUQ70362.1 2282151 g2303 i0 33.8 0.871698113207547 77 36 70.2 2 25 210 109 185 NUQ70362.1 apolipoprotein N-acyltransferase [Chthonomonadales bacterium] diamond 231 46.6 1 Bacteria   Bacillati Armatimonadota Chthonomonadia Chthonomonadales     Chthonomonadales bacterium
30484257 30484257 PRJNA1237888_S_NODE_4913_length_186_cov_1.138686_g4863_i0 PRJNA1237888 4913 186 1.138686 2.11795596 Staphylococcus warneri 1292 Bacteria Bacteria 124 3.36e-31   NR MDU6255006.1 1292 g4863 i0 98.4 0.983870967741935 61 1 98.4 0 184 2 202 262 MDU6255006.1 ATP-dependent helicase [Staphylococcus warneri] diamond 183 124 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
30484259 30484259 PRJNA1237888_S_NODE_6773_length_165_cov_1.060345_g6723_i0 PRJNA1237888 6773 165 1.060345 1.74956925 Staphylococcus epidermidis 1282 Bacteria Bacteria 54.7 7.7300000000000005e-07   NR MBM6202820.1 1282 g6723 i0 52.7 2.98181818181818 55 22 98.2 2 2 163 38 89 MBM6202820.1 hypothetical protein [Staphylococcus epidermidis] diamond 492 54.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
30691881 30691881 PRJNA1237888_S_NODE_7193_length_163_cov_0.912281_g7143_i0 PRJNA1237888 7193 163 0.912281 1.48701803 Gordonia 2053 Bacteria Bacteria 48.1 1.49e-4   NR HCS59105.1 84595 g7143 i0 82.6 1.69325153374233 23 4 42.3 0 6 74 307 329 HCS59105.1 forkhead-associated protein [Gordonia polyisoprenivorans] diamond 276 48.5 0.991752577319588 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Gordoniaceae Gordonia Gordonia polyisoprenivorans
30831670 30831670 PRJNA1237888_S_NODE_6394_length_167_cov_1.169492_g6344_i0 PRJNA1237888 6394 167 1.169492 1.95305164 Umezawaea tangerina 84725 Bacteria Bacteria 42.4 0.0183   NR WP_106187718.1 84725 g6344 i0 50 0.610778443113772 34 17 61.1 0 55 156 342 375 WP_106187718.1 DUF5685 family protein [Umezawaea tangerina] diamond 102 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Umezawaea Umezawaea tangerina
31147270 31147270 PRJNA1237888_S_NODE_6115_length_169_cov_0.866667_g6065_i0 PRJNA1237888 6115 169 0.866667 1.46466723 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 45.8 0.00113   NR HLB22205.1 2586742 g6065 i0 75 0.568047337278107 32 7 56.8 1 74 169 63 93 HLB22205.1 sulfite exporter TauE/SafE family protein [Solirubrobacteraceae bacterium] diamond 96 45.8 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
31197092 31197092 PRJNA1237888_S_NODE_6555_length_166_cov_1.333333_g6505_i0 PRJNA1237888 6555 166 1.333333 2.21333278 root 1 Root_unresolved Root_unresolved 85.5 4.06e-18   NR HJG39255.1 29385 g6505 i0 74.1 2.92771084337349 54 14 97.6 0 3 164 24 77 HJG39255.1 transposase [Staphylococcus saprophyticus] diamond 486 85.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus saprophyticus
31716931 31716931 PRJNA1237888_S_NODE_6857_length_165_cov_0.896552_g6807_i0 PRJNA1237888 6857 165 0.896552 1.4793108 Veillonella sp. VA142 741834 Bacteria Bacteria 112 5.9899999999999985e-28   NR WP_126939084.1 741834 g6807 i0 100 0.981818181818182 54 0 98.2 0 3 164 225 278 WP_126939084.1 tRNA 2-thiouridine(34) synthase MnmA [Veillonella sp. VA142] diamond 162 112 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella sp. VA142
32128419 32128419 PRJNA1237888_S_NODE_7178_length_163_cov_1.254386_g7128_i0 PRJNA1237888 7178 163 1.254386 2.04464918 Staphylococcus warneri 1292 Bacteria Bacteria 103 2.45e-26   NR MDU6255014.1 1292 g7128 i0 94.3 0.975460122699387 53 3 97.5 0 161 3 66 118 MDU6255014.1 hypothetical protein [Staphylococcus warneri] diamond 159 103 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
32399719 32399719 PRJNA1237888_S_NODE_6999_length_164_cov_0.904348_g6949_i0 PRJNA1237888 6999 164 0.904348 1.48313072 Mycobacteroides 670516 Bacteria Bacteria 108 4.97e-27   NR WP_070917080.1 1774 g6949 i0 94.4 6.91463414634146 54 3 98.8 0 1 162 176 229 WP_070917080.1 mycofactocin-coupled SDR family oxidoreductase [Mycobacteroides chelonae] diamond 1134 109 0.990825688073395 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacteroides Mycobacteroides chelonae

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