RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA1069776" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 31 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1069776 · 31 ✖

analysis 1

  • diamond · 31 ✖

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
184487 184487 PRJNA1069776_S_NODE_11901_length_289_cov_4.170732_g11587_i0 PRJNA1069776 11901 289 4.170732 12.05341548 root 1 Root_unresolved Root_unresolved 70.5 1.13e-13   NR MES8301118.1 1747 g11587 i0 55.4 1.8477508650519 65 28 67.5 1 258 64 3 66 MES8301118.1 hypothetical protein [Cutibacterium acnes] diamond 534 70.9 0.994358251057828 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
20585542 20585542 PRJNA1069776_S_NODE_11197_length_295_cov_10.067460_g10883_i0 PRJNA1069776 11197 295 10.06746 29.699007 Leucobacter ruminantium 1289170 Bacteria Bacteria 121 2.18e-32   NR WP_208045410.1 1289170 g10883 i0 68.8 0.976271186440678 96 30 97.6 0 3 290 38 133 WP_208045410.1 TetR/AcrR family transcriptional regulator [Leucobacter ruminantium] diamond 288 121 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leucobacter Leucobacter ruminantium
26782712 26782712 PRJNA1069776_S_NODE_42481_length_168_cov_3.840000_g42167_i0 PRJNA1069776 42481 168 3.84 6.4512 Cutibacterium acnes 1747 Bacteria Bacteria 55.1 1.83e-7   NR MES6300509.1 1747 g42167 i0 55.8 2.89285714285714 52 23 92.9 0 11 166 87 138 MES6300509.1 reverse transcriptase domain-containing protein [Cutibacterium acnes] diamond 486 55.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
26940706 26940706 PRJNA1069776_S_NODE_55402_length_150_cov_2.242991_g55088_i0 PRJNA1069776 55402 150 2.242991 3.3644865 Sphaerisporangium rhizosphaerae 2269375 Bacteria Bacteria 42.7 0.0104   NR WP_380825375.1 2269375 g55088 i0 44.1 1.56 34 17 68 1 35 136 341 372 WP_380825375.1 type I-C CRISPR-associated protein Cas8c/Csd1 [Sphaerisporangium rhizosphaerae] diamond 234 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Sphaerisporangium Sphaerisporangium rhizosphaerae
27193667 27193667 PRJNA1069776_S_NODE_4502_length_384_cov_10.445748_g4188_i0 PRJNA1069776 4502 384 10.445748 40.11167232 Streptosporangiaceae bacterium 2339230 Bacteria Bacteria 46.2 0.0104   NR HEY2507448.1 2339230 g4188 i0 37.1 0.546875 70 32 45.3 1 302 129 362 431 HEY2507448.1 elongation factor G-like protein EF-G2 [Streptosporangiaceae bacterium] diamond 210 46.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae   Streptosporangiaceae bacterium
27248561 27248561 PRJNA1069776_S_NODE_33343_length_188_cov_2.917241_g33029_i0 PRJNA1069776 33343 188 2.917241 5.48441308 root 1 Root_unresolved Root_unresolved 44.7 0.00108   NR MES6355488.1 1747 g33029 i0 85.7 1.34042553191489 21 3 33.5 0 65 3 20 40 MES6355488.1 hypothetical protein [Cutibacterium acnes] diamond 252 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
27636153 27636153 PRJNA1069776_S_NODE_24544_length_215_cov_3.627907_g24230_i0 PRJNA1069776 24544 215 3.627907 7.80000005 Corynebacterium pyruviciproducens 598660 Bacteria Bacteria 40 0.0427   NR WP_284842837.1 598660 g24230 i0 65.4 0.362790697674419 26 7 36.3 1 15 92 23 46 WP_284842837.1 hypothetical protein, partial [Corynebacterium pyruviciproducens] diamond 78 40 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium pyruviciproducens
28015071 28015071 PRJNA1069776_S_NODE_29445_length_198_cov_5.232258_g29131_i0 PRJNA1069776 29445 198 5.232258 10.35987084 Nocardia salmonicida 53431 Bacteria Bacteria 41.6 0.0133   NR WP_357376259.1 53431 g29131 i0 40.7 0.893939393939394 59 35 89.4 0 183 7 1 59 WP_357376259.1 AAA family ATPase, partial [Nocardia salmonicida] diamond 177 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Nocardia Nocardia salmonicida
28069601 28069601 PRJNA1069776_S_NODE_11125_length_296_cov_5.383399_g10811_i0 PRJNA1069776 11125 296 5.383399 15.93486104 root 1 Root_unresolved Root_unresolved 92.4 1.28e-20   NR MES8455852.1 1747 g10811 i0 72.7 4.6722972972973 66 18 66.9 0 1 198 11 76 MES8455852.1 endonuclease/exonuclease/phosphatase family protein [Cutibacterium acnes] diamond 1383 92.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
28606323 28606323 PRJNA1069776_S_NODE_28827_length_200_cov_4.420382_g28513_i0 PRJNA1069776 28827 200 4.420382 8.840764 Streptomyces 1883 Bacteria Bacteria 43.9 0.00376   NR WP_245877577.1 1907 g28513 i0 38.8 5.025 67 37 97.5 2 199 5 59 123 WP_245877577.1 flavin monoamine oxidase family protein, partial [Streptomyces glaucescens] diamond 1005 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces glaucescens
28835792 28835792 PRJNA1069776_S_NODE_37248_length_179_cov_1.470588_g36934_i0 PRJNA1069776 37248 179 1.470588 2.63235252 Streptomyces ferrugineus 1413221 Bacteria Bacteria 42.7 0.0162   NR WP_194040695.1 1413221 g36934 i0 36.4 0.921787709497207 55 35 92.2 0 178 14 1201 1255 WP_194040695.1 non-ribosomal peptide synthetase [Streptomyces ferrugineus] diamond 165 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces ferrugineus
28930617 28930617 PRJNA1069776_S_NODE_26108_length_209_cov_4.090361_g25794_i0 PRJNA1069776 26108 209 4.090361 8.54885449 Cutibacterium acnes 1747 Bacteria Bacteria 67 3.13e-12   NR MES6459333.1 1747 g25794 i0 60.3 0.832535885167464 58 23 83.3 0 179 6 13 70 MES6459333.1 hypothetical protein [Cutibacterium acnes] diamond 174 67 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
29183328 29183328 PRJNA1069776_S_NODE_18669_length_242_cov_3.778894_g18355_i0 PRJNA1069776 18669 242 3.778894 9.14492348 Streptomyces sp. 1931 Bacteria Bacteria 42.4 0.048   NR WP_415940400.1 2789263 g18355 i0 40 0.681818181818182 55 33 68.2 0 240 76 204 258 WP_415940400.1 endonuclease/exonuclease/phosphatase family protein, partial [Streptomyces sp. 039-1] diamond 165 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. 039-1
29277713 29277713 PRJNA1069776_S_NODE_25329_length_212_cov_3.059172_g25015_i0 PRJNA1069776 25329 212 3.059172 6.48544464 Microbacterium esteraromaticum 57043 Bacteria Bacteria 87.4 9.03e-21   NR PYC99562.1 57043 g25015 i0 82.5 0.806603773584906 57 10 80.7 0 210 40 3 59 PYC99562.1 NgoFVII family restriction endonuclease [Microbacterium esteraromaticum] diamond 171 87.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum
29301053 29301053 PRJNA1069776_S_NODE_32269_length_191_cov_2.222973_g31955_i0 PRJNA1069776 32269 191 2.222973 4.24587843 root 1 Root_unresolved Root_unresolved 55.8 2.68e-7   NR MES8455852.1 1747 g31955 i0 68.4 4.77486910994764 38 12 59.7 0 117 4 33 70 MES8455852.1 endonuclease/exonuclease/phosphatase family protein [Cutibacterium acnes] diamond 912 55.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
30004247 30004247 PRJNA1069776_S_NODE_12931_length_280_cov_5.215190_g12617_i0 PRJNA1069776 12931 280 5.21519 14.602532 Winkia sp. UMB31 2692120 Bacteria Bacteria 44.7 0.00137   NR WP_285444845.1 3046332 g12617 i0 73.1 0.6 26 7 27.9 0 262 185 45 70 WP_285444845.1 hypothetical protein, partial [Winkia sp. UMB3105] diamond 168 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Winkia Winkia sp. UMB3105
30067285 30067285 PRJNA1069776_S_NODE_27412_length_205_cov_2.901235_g27098_i0 PRJNA1069776 27412 205 2.901235 5.94753175 Cutibacterium acnes 1747 Bacteria Bacteria 48.1 1.43e-4   NR MES6385480.1 1747 g27098 i0 61 1.25853658536585 41 15 60 1 21 143 40 79 MES6385480.1 hypothetical protein [Cutibacterium acnes] diamond 258 48.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
30730830 30730830 PRJNA1069776_S_NODE_26214_length_209_cov_2.602410_g25900_i0 PRJNA1069776 26214 209 2.60241 5.4390369 Leucobacter aridicollis 283878 Bacteria Bacteria 112 2.6600000000000003e-27   NR WP_259126169.1 283878 g25900 i0 100 0.875598086124402 61 0 87.6 0 25 207 280 340 WP_259126169.1 FtsX-like permease family protein [Leucobacter aridicollis] diamond 183 112 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leucobacter Leucobacter aridicollis
30762538 30762538 PRJNA1069776_S_NODE_12574_length_283_cov_3.600000_g12260_i0 PRJNA1069776 12574 283 3.6 10.188 Streptomyces sp. LN785 3112983 Bacteria Bacteria 43.1 0.0465   NR WP_392667944.1 3112983 g12260 i0 41.9 0.657243816254417 62 36 65.7 0 202 17 790 851 WP_392667944.1 amino acid adenylation domain-containing protein [Streptomyces sp. LN785] diamond 186 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. LN785
31204338 31204338 PRJNA1069776_S_NODE_28995_length_200_cov_2.140127_g28681_i0 PRJNA1069776 28995 200 2.140127 4.280254 Corynebacterium pyruviciproducens 598660 Bacteria Bacteria 43.1 0.0022   NR WP_284842837.1 598660 g28681 i0 52.9 1.2 34 15 49.5 1 99 1 11 44 WP_284842837.1 hypothetical protein, partial [Corynebacterium pyruviciproducens] diamond 240 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium pyruviciproducens
31299638 31299638 PRJNA1069776_S_NODE_35075_length_184_cov_1.666667_g34761_i0 PRJNA1069776 35075 184 1.666667 3.06666728 Actinomycetota bacterium 2900548 Bacteria Bacteria 41.2 0.0449   NR MFP5297803.1 2900548 g34761 i0 55.6 0.440217391304348 27 12 44 0 98 18 121 147 MFP5297803.1 hypothetical protein [Actinomycetota bacterium] diamond 81 41.2 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31417721 31417721 PRJNA1069776_S_NODE_44056_length_165_cov_18.877049_g43742_i0 PRJNA1069776 44056 165 18.877049 31.14713085 root 1 Root_unresolved Root_unresolved 41.2 0.0314   NR WP_034712284.1 1386088 g43742 i0 50 1.98181818181818 36 16 65.5 1 35 142 133 166 WP_034712284.1 Cys-tRNA(Pro) deacylase [Intrasporangium chromatireducens] diamond 327 41.6 0.990384615384615 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Intrasporangiaceae Intrasporangium Intrasporangium chromatireducens
31797089 31797089 PRJNA1069776_S_NODE_25197_length_212_cov_8.130178_g24883_i0 PRJNA1069776 25197 212 8.130178 17.23597736 Dactylosporangium 35753 Bacteria Bacteria 43.1 0.0186   NR WP_261964882.1 53360 g24883 i0 41.2 1.44339622641509 51 29 70.8 1 162 13 575 625 WP_261964882.1 glutaminase domain-containing protein [Dactylosporangium matsuzakiense] diamond 306 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Dactylosporangium Dactylosporangium matsuzakiense
31963846 31963846 PRJNA1069776_S_NODE_48838_length_157_cov_7.166667_g48524_i0 PRJNA1069776 48838 157 7.166667 11.25166719 Nocardiopsis sp. NPDC 310350 Bacteria Bacteria 102 4.13e-26   NR WP_355014022.1 3154472 g48524 i0 84.6 0.993630573248408 52 8 99.4 0 156 1 22 73 WP_355014022.1 hypothetical protein [Nocardiopsis sp. NPDC006198] diamond 156 102 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Nocardiopsidaceae Nocardiopsis Nocardiopsis sp. NPDC006198
32058803 32058803 PRJNA1069776_S_NODE_27958_length_203_cov_3.500000_g27644_i0 PRJNA1069776 27958 203 3.5 7.105 Catenulispora sp. 1962977 Bacteria Bacteria 42.4 0.0311   NR MFL6113812.1 1962977 g27644 i0 50 0.620689655172414 42 20 60.6 1 39 161 1046 1087 MFL6113812.1 SDR family NAD(P)-dependent oxidoreductase [Catenulispora sp.] diamond 126 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Catenulisporales Catenulisporaceae Catenulispora Catenulispora sp.
32280560 32280560 PRJNA1069776_S_NODE_41499_length_170_cov_2.960630_g41185_i0 PRJNA1069776 41499 170 2.96063 5.033071 Phytohabitans flavus 1076124 Bacteria Bacteria 42.7 0.0117   NR WP_345075239.1 1076124 g41185 i0 73.1 0.458823529411765 26 7 45.9 0 170 93 148 173 WP_345075239.1 hypothetical protein, partial [Phytohabitans flavus] diamond 78 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Phytohabitans Phytohabitans flavus
32502068 32502068 PRJNA1069776_S_NODE_42179_length_169_cov_2.238095_g41865_i0 PRJNA1069776 42179 169 2.238095 3.78238055 Cutibacterium acnes 1747 Bacteria Bacteria 40.4 0.0271   NR MES6071873.1 1747 g41865 i0 81 1.11834319526627 21 4 37.3 0 61 123 25 45 MES6071873.1 hypothetical protein [Cutibacterium acnes] diamond 189 40.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
32659307 32659307 PRJNA1069776_S_NODE_33940_length_186_cov_6.321678_g33626_i0 PRJNA1069776 33940 186 6.321678 11.75832108 Cutibacterium acnes 1747 Bacteria Bacteria 43.9 7.47e-4   NR MES9157533.1 1747 g33626 i0 62.2 0.596774193548387 37 13 59.7 1 179 69 7 42 MES9157533.1 hypothetical protein [Cutibacterium acnes] diamond 111 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
32785387 32785387 PRJNA1069776_S_NODE_29820_length_197_cov_4.428571_g29506_i0 PRJNA1069776 29820 197 4.428571 8.72428487 Streptomyces sp. CB 1931 Bacteria Bacteria 42 0.0378   NR WP_100607808.1 2020330 g29506 i0 59.4 0.487309644670051 32 13 48.7 0 47 142 384 415 WP_100607808.1 hypothetical protein [Streptomyces sp. CB02959] diamond 96 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. CB02959
32816974 32816974 PRJNA1069776_S_NODE_26160_length_209_cov_3.180723_g25846_i0 PRJNA1069776 26160 209 3.180723 6.64771107 Cutibacterium acnes 1747 Bacteria Bacteria 51.6 1.75e-5   NR MES8380878.1 1747 g25846 i0 62.5 5.84210526315789 32 12 45.9 0 100 5 103 134 MES8380878.1 hypothetical protein [Cutibacterium acnes] diamond 1221 51.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
32816977 32816977 PRJNA1069776_S_NODE_53500_length_152_cov_0.880734_g53186_i0 PRJNA1069776 53500 152 0.880734 1.33871568 Corynebacterium pyruviciproducens 598660 Bacteria Bacteria 40 0.0193   NR WP_284842837.1 598660 g53186 i0 57.1 0.552631578947368 28 12 55.3 0 24 107 23 50 WP_284842837.1 hypothetical protein, partial [Corynebacterium pyruviciproducens] diamond 84 40 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium pyruviciproducens

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