RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA1169999" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 18 ✖

bioproject 1

  • PRJNA1169999 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
10518871 10518871 PRJNA1169999_P_NODE_4209_length_241_cov_0.916667_g4173_i0 PRJNA1169999 4209 241 0.916667 2.20916747 Corynebacterium incognita 2754725 Bacteria Bacteria 155 2.3199999999999998e-42   NR WP_185176693.1 2754725 g4173 i0 90 0.995850622406639 80 8 99.6 0 241 2 347 426 WP_185176693.1 alpha/beta hydrolase-fold protein [Corynebacterium incognita] diamond 240 155 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium incognita
16342771 16342771 PRJNA1169999_P_NODE_2913_length_250_cov_0.870056_g2877_i0 PRJNA1169999 2913 250 0.870056 2.17514 Microbacterium nymphoidis 2898586 Bacteria Bacteria 172 1.4e-50   NR WP_231091469.1 2898586 g2877 i0 100 0.996 83 0 99.6 0 1 249 39 121 WP_231091469.1 zinc-binding dehydrogenase [Microbacterium nymphoidis] diamond 249 172 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium nymphoidis
23267425 23267425 PRJNA1169999_P_NODE_819_length_405_cov_0.783133_g783_i0 PRJNA1169999 819 405 0.783133 3.17168865 root 1 Root_unresolved Root_unresolved 202 8.31e-62   NR WP_193450526.1 1922 g783 i0 70.9 6.94814814814815 134 39 99.3 0 2 403 20 153 WP_193450526.1 RNase H-like domain-containing protein, partial [Streptomyces plicatus] diamond 2814 203 0.995073891625616 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces plicatus
26723458 26723458 PRJNA1169999_P_NODE_2541_length_255_cov_1.598901_g2505_i0 PRJNA1169999 2541 255 1.598901 4.07719755 Nocardia caishijiensis 184756 Bacteria Bacteria 152 7.12e-44   NR WP_067985417.1 184756 g2505 i0 84.7 1 85 13 100 0 255 1 172 256 WP_067985417.1 alpha/beta fold hydrolase [Nocardia caishijiensis] diamond 255 152 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Nocardia Nocardia caishijiensis
27293360 27293360 PRJNA1169999_P_NODE_1303_length_322_cov_1.036145_g1267_i0 PRJNA1169999 1303 322 1.036145 3.3363869 Microbacterium sp. ZXX196 2609291 Bacteria Bacteria 52.8 2.04e-6   NR WP_230379627.1 2609291 g1267 i0 58.3 0.335403726708075 36 12 33.5 1 231 124 49 81 WP_230379627.1 hypothetical protein, partial [Microbacterium sp. ZXX196] diamond 108 52.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. ZXX196
27640957 27640957 PRJNA1169999_P_NODE_2584_length_253_cov_1.405556_g2548_i0 PRJNA1169999 2584 253 1.405556 3.55605668 Nocardia halotolerans 1755878 Bacteria Bacteria 155 3.49e-44   NR WP_378555433.1 1755878 g2548 i0 95.2 0.984189723320158 83 4 98.4 0 2 250 204 286 WP_378555433.1 MlaD family protein [Nocardia halotolerans] diamond 249 155 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Nocardia Nocardia halotolerans
28208940 28208940 PRJNA1169999_P_NODE_1806_length_283_cov_1.419048_g1770_i0 PRJNA1169999 1806 283 1.419048 4.01590584 Ornithinimicrobium flavum 1288636 Bacteria Bacteria 44.3 0.0163   NR WP_238695269.1 1288636 g1770 i0 31.2 1.34628975265018 77 37 64.7 2 225 43 223 299 WP_238695269.1 exodeoxyribonuclease III [Ornithinimicrobium flavum] diamond 381 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Ornithinimicrobiaceae Ornithinimicrobium Ornithinimicrobium flavum
28335392 28335392 PRJNA1169999_P_NODE_1266_length_326_cov_1.403162_g1230_i0 PRJNA1169999 1266 326 1.403162 4.57430812 Couchioplanes caeruleus 56438 Bacteria Bacteria 43.9 0.0197   NR WP_229799511.1 56438 g1230 i0 42 1.26993865030675 69 37 63.5 2 98 304 95 160 WP_229799511.1 hypothetical protein, partial [Couchioplanes caeruleus] diamond 414 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Couchioplanes Couchioplanes caeruleus
28493355 28493355 PRJNA1169999_P_NODE_3167_length_248_cov_0.880000_g3131_i0 PRJNA1169999 3167 248 0.88 2.1824 Microbacterium sp. BLY 2823280 Bacteria Bacteria 139 3.19e-36   NR WP_210677223.1 2823280 g3131 i0 98.5 0.82258064516129 68 1 82.3 0 246 43 855 922 WP_210677223.1 FtsK/SpoIIIE domain-containing protein [Microbacterium sp. BLY] diamond 204 139 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. BLY
29819176 29819176 PRJNA1169999_P_NODE_3931_length_243_cov_0.905882_g3895_i0 PRJNA1169999 3931 243 0.905882 2.20129326 Leifsonia sp. 1870902 Bacteria Bacteria 121 7.98e-31   NR MBN9240807.1 1870902 g3895 i0 72.5 2.96296296296296 80 22 98.8 0 240 1 136 215 MBN9240807.1 alkaline phosphatase family protein [Leifsonia sp.] diamond 720 121 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leifsonia Leifsonia sp.
31083194 31083194 PRJNA1169999_P_NODE_2395_length_260_cov_1.620321_g2359_i0 PRJNA1169999 2395 260 1.620321 4.2128346 Ilumatobacter sp. 1967498 Bacteria Bacteria 43.1 0.0321   NR MFK7917399.1 1967498 g2359 i0 32.5 0.957692307692308 83 48 86.5 2 237 13 67 149 MFK7917399.1 acyl-CoA dehydrogenase family protein [Ilumatobacter sp.] diamond 249 43.1 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae Ilumatobacter Ilumatobacter sp.
31145907 31145907 PRJNA1169999_P_NODE_2455_length_258_cov_1.664865_g2419_i0 PRJNA1169999 2455 258 1.664865 4.2953517 Roseiflexaceae bacterium 2762507 Bacteria Bacteria 146 2.86e-41   NR MEO7910388.1 2762507 g2419 i0 78.8 4.91860465116279 85 18 98.8 0 257 3 94 178 MEO7910388.1 transglutaminase-like domain-containing protein [Roseiflexaceae bacterium] diamond 1269 146 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae   Roseiflexaceae bacterium
31241041 31241041 PRJNA1169999_P_NODE_3995_length_243_cov_0.905882_g3959_i0 PRJNA1169999 3995 243 0.905882 2.20129326 Glutamicibacter uratoxydans 43667 Bacteria Bacteria 147 1.58e-40   NR WP_141367319.1 43667 g3959 i0 87.5 0.987654320987654 80 10 98.8 0 2 241 97 176 WP_141367319.1 hypothetical protein [Glutamicibacter uratoxydans] diamond 240 147 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Glutamicibacter Glutamicibacter uratoxydans
31715627 31715627 PRJNA1169999_P_NODE_3637_length_245_cov_0.895349_g3601_i0 PRJNA1169999 3637 245 0.895349 2.19360505 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 43.1 0.0268   NR MCC7229018.1 2682144 g3601 i0 80.8 0.318367346938775 26 5 31.8 0 79 2 1 26 MCC7229018.1 quinolinate synthase NadA [Fimbriimonadaceae bacterium] diamond 78 43.1 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
32475126 32475126 PRJNA1169999_P_NODE_3159_length_248_cov_0.880000_g3123_i0 PRJNA1169999 3159 248 0.88 2.1824 Nocardia halotolerans 1755878 Bacteria Bacteria 100 1.21e-22   NR WP_378568691.1 1755878 g3123 i0 83.9 0.75 62 10 75 0 63 248 1 62 WP_378568691.1 PucR family transcriptional regulator [Nocardia halotolerans] diamond 186 100 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Nocardia Nocardia halotolerans
32570142 32570142 PRJNA1169999_P_NODE_3979_length_243_cov_0.905882_g3943_i0 PRJNA1169999 3979 243 0.905882 2.20129326 Spirulina sp. CCY15215 2767591 Bacteria Bacteria 42.7 0.0357   NR WP_204102997.1 2767591 g3943 i0 28 0.925925925925926 75 48 85.2 2 32 238 19 93 WP_204102997.1 amino acid ABC transporter permease [Spirulina sp. CCY15215] diamond 225 42.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Spirulinales Spirulinaceae Spirulina Spirulina sp. CCY15215
32664152 32664152 PRJNA1169999_P_NODE_1280_length_325_cov_0.785714_g1244_i0 PRJNA1169999 1280 325 0.785714 2.5535705 Microbacterium sp. ZXX196 2609291 Bacteria Bacteria 51.6 5.93e-6   NR WP_230379627.1 2609291 g1244 i0 56.8 0.341538461538462 37 13 34.2 1 79 189 49 82 WP_230379627.1 hypothetical protein, partial [Microbacterium sp. ZXX196] diamond 111 51.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. ZXX196
32821734 32821734 PRJNA1169999_P_NODE_3620_length_245_cov_0.895349_g3584_i0 PRJNA1169999 3620 245 0.895349 2.19360505 Actinomycetota bacterium 2900548 Bacteria Bacteria 55.8 1.75e-7   NR MSW52383.1 2900548 g3584 i0 83.9 0.379591836734694 31 5 38 0 153 245 40 70 MSW52383.1 hypothetical protein [Actinomycetota bacterium] diamond 93 55.8 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium

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