RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA886442" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA886442 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
5965267 5965267 PRJNA886442_P_NODE_8885_length_270_cov_1.583756_g8721_i0 PRJNA886442 8885 270 1.583756 4.2761412 Protaetiibacter larvae 2592654 Bacteria Bacteria 76.3 1.18e-15   NR WP_149324325.1 2592654 g8721 i0 64.4 0.811111111111111 73 22 81.1 1 51 269 1 69 WP_149324325.1 hypothetical protein [Protaetiibacter larvae] diamond 219 76.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Protaetiibacter Protaetiibacter larvae
9789772 9789772 PRJNA886442_P_NODE_11448_length_250_cov_1.344633_g11284_i0 PRJNA886442 11448 250 1.344633 3.3615825 Nocardioides abyssi 3058370 Bacteria Bacteria 72 1.27e-12   NR WP_300961377.1 3058370 g11284 i0 54.7 0.9 75 32 90 1 250 26 1 73 WP_300961377.1 sensor histidine kinase [Nocardioides abyssi] diamond 225 72 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides abyssi
13615526 13615526 PRJNA886442_P_NODE_2331_length_457_cov_2.526042_g2167_i0 PRJNA886442 2331 457 2.526042 11.54401194 Cutibacterium acnes 1747 Bacteria Bacteria 223 2.7e-72   NR MES6669707.1 1747 g2167 i0 99.2 0.859956236323851 131 1 86 0 455 63 21 151 MES6669707.1 hypothetical protein [Cutibacterium acnes] diamond 393 223 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
16164714 16164714 PRJNA886442_P_NODE_633_length_866_cov_7.132409_g482_i0 PRJNA886442 633 866 7.132409 61.76666194 Cutibacterium acnes 1747 Bacteria Bacteria 363 1.3299999999999996e-124   NR MES6669710.1 1747 g482 i0 95.1 1.39953810623557 185 9 64.1 0 8 562 1 185 MES6669710.1 glutathione S-transferase N-terminal domain-containing protein [Cutibacterium acnes] diamond 1212 363 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
22538629 22538629 PRJNA886442_P_NODE_11918_length_249_cov_0.886364_g11754_i0 PRJNA886442 11918 249 0.886364 2.20704636 Nocardioides sp. 35761 Bacteria Bacteria 124 1.09e-31   NR WP_415170806.1 35761 g11754 i0 75.9 2.04819277108434 83 20 100 0 249 1 258 340 WP_415170806.1 AAA family ATPase [Nocardioides sp.] diamond 510 124 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides sp.
26706984 26706984 PRJNA886442_P_NODE_14241_length_244_cov_0.912281_g14077_i0 PRJNA886442 14241 244 0.912281 2.22596564 Pseudonocardiales bacterium 2201155 Bacteria Bacteria 42.7 0.0359   NR MBA3574609.1 2201155 g14077 i0 35.4 0.590163934426229 48 31 59 0 50 193 79 126 MBA3574609.1 VOC family protein [Pseudonocardiales bacterium] diamond 144 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales     Pseudonocardiales bacterium
27308528 27308528 PRJNA886442_P_NODE_11483_length_250_cov_0.881356_g11319_i0 PRJNA886442 11483 250 0.881356 2.20339 Actinomadura verrucosospora 46165 Bacteria Bacteria 65.9 2.73e-10   NR WP_173093481.1 46165 g11319 i0 46.3 3.06 67 36 80.4 0 206 6 1 67 WP_173093481.1 FAD-dependent oxidoreductase [Actinomadura verrucosospora] diamond 765 65.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Actinomadura Actinomadura verrucosospora
27750682 27750682 PRJNA886442_P_NODE_10664_length_252_cov_1.128492_g10500_i0 PRJNA886442 10664 252 1.128492 2.84379984 Leucobacter soli 2812850 Bacteria Bacteria 41.2 0.018   NR WP_382332563.1 2812850 g10500 i0 54.1 0.44047619047619 37 17 44 0 82 192 24 60 WP_382332563.1 hypothetical protein [Leucobacter soli] diamond 111 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leucobacter Leucobacter soli
27876712 27876712 PRJNA886442_P_NODE_7845_length_285_cov_1.103774_g7681_i0 PRJNA886442 7845 285 1.103774 3.1457559 Cutibacterium acnes 1747 Bacteria Bacteria 124 8.53e-35   NR MES6669709.1 1747 g7681 i0 100 0.842105263157895 80 0 84.2 0 278 39 24 103 MES6669709.1 hypothetical protein [Cutibacterium acnes] diamond 240 124 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
28034755 28034755 PRJNA886442_P_NODE_7985_length_283_cov_1.114286_g7821_i0 PRJNA886442 7985 283 1.114286 3.15342938 Microbacterium resistens 156977 Bacteria Bacteria 164 1.96e-48   NR WP_219085901.1 156977 g7821 i0 97.9 0.996466431095406 94 2 99.6 0 283 2 113 206 WP_219085901.1 sugar isomerase domain-containing protein [Microbacterium resistens] diamond 282 164 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium resistens
28445222 28445222 PRJNA886442_P_NODE_13086_length_247_cov_0.896552_g12922_i0 PRJNA886442 13086 247 0.896552 2.21448344 Actinomycetota bacterium 2900548 Bacteria Bacteria 142 3.2e-38   NR MCA0253667.1 2900548 g12922 i0 76.5 4.93117408906883 81 19 98.4 0 243 1 7 87 MCA0253667.1 DUF4921 family protein [Actinomycetota bacterium] diamond 1218 142 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28768603 28768603 PRJNA886442_P_NODE_14127_length_244_cov_0.912281_g13963_i0 PRJNA886442 14127 244 0.912281 2.22596564 Bacteria 2 Bacteria Bacteria 42.7 0.0357   NR WP_083131141.1 43348 g13963 i0 42 1.19262295081967 50 27 59 1 53 196 212 261 WP_083131141.1 Rossmann-like and DUF2520 domain-containing protein [Mycobacterium branderi] diamond 291 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium branderi
28918471 28918471 PRJNA886442_P_NODE_13128_length_247_cov_0.867816_g12964_i0 PRJNA886442 13128 247 0.867816 2.14350552 Streptosporangiaceae bacterium 2339230 Bacteria Bacteria 54.3 3.25e-6   NR MCW2890380.1 2339230 g12964 i0 37.1 5.87854251012146 70 44 85 0 242 33 792 861 MCW2890380.1 uncharacterized protein [Streptosporangiaceae bacterium] diamond 1452 54.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae   Streptosporangiaceae bacterium
29265808 29265808 PRJNA886442_P_NODE_2789_length_423_cov_1.114286_g2625_i0 PRJNA886442 2789 423 1.114286 4.71342978 Streptomyces sp. CHB9.2 2841670 Bacteria Bacteria 123 1.84e-29   NR WP_252941021.1 2841670 g2625 i0 59.8 1.4113475177305 97 39 68.8 0 294 4 4 100 WP_252941021.1 hypothetical protein [Streptomyces sp. CHB9.2] diamond 597 123 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. CHB9.2
29462948 29462948 PRJNA886442_P_NODE_10390_length_253_cov_0.866667_g10226_i0 PRJNA886442 10390 253 0.866667 2.19266751 Micrococcaceae 1268 Bacteria Bacteria 44.3 0.00302   NR WP_157242143.1 2676311 g10226 i0 46.7 2.14624505928854 45 22 51 1 172 44 58 102 WP_157242143.1 hypothetical protein [Pseudarthrobacter sp. GA104] diamond 543 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Pseudarthrobacter Pseudarthrobacter sp. GA104
29707575 29707575 PRJNA886442_P_NODE_15190_length_242_cov_0.923077_g15026_i0 PRJNA886442 15190 242 0.923077 2.23384634 Nocardioides alcanivorans 2897352 Bacteria Bacteria 44.7 0.00756   NR WP_235736593.1 2897352 g15026 i0 38.6 0.706611570247934 57 25 70.7 1 2 172 440 486 WP_235736593.1 sensor histidine kinase [Nocardioides alcanivorans] diamond 171 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides alcanivorans
29739320 29739320 PRJNA886442_P_NODE_14770_length_243_cov_0.917647_g14606_i0 PRJNA886442 14770 243 0.917647 2.22988221 Actinomycetota bacterium 2900548 Bacteria Bacteria 43.1 0.0263   NR RPI04649.1 2900548 g14606 i0 36.8 0.938271604938272 76 42 86.4 2 20 229 214 289 RPI04649.1 MAG: acetate--CoA ligase, partial [Actinomycetota bacterium] diamond 228 43.1 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
29865924 29865924 PRJNA886442_P_NODE_10411_length_253_cov_0.866667_g10247_i0 PRJNA886442 10411 253 0.866667 2.19266751 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 45.8 0.00344   NR HNJ97856.1 2497619 g10247 i0 32.9 0.936758893280632 79 52 92.5 1 19 252 403 481 HNJ97856.1 PD-(D/E)XK nuclease family protein [Ilumatobacteraceae bacterium] diamond 237 45.8 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
31382771 31382771 PRJNA886442_P_NODE_12056_length_249_cov_0.886364_g11892_i0 PRJNA886442 12056 249 0.886364 2.20704636 Nonomuraea thailandensis 1188745 Bacteria Bacteria 44.7 0.00624   NR MFD0477663.1 1188745 g11892 i0 44.7 0.566265060240964 47 23 56.6 1 105 245 110 153 MFD0477663.1 hypothetical protein [Nonomuraea thailandensis] diamond 141 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea thailandensis
32466420 32466420 PRJNA886442_P_NODE_4039_length_367_cov_1.795918_g3875_i0 PRJNA886442 4039 367 1.795918 6.59101906 Bacteria 2 Bacteria Bacteria 64.3 6.51e-10   NR HET7487895.1 2201156 g3875 i0 43.1 3.03269754768392 65 37 53.1 0 42 236 49 113 HET7487895.1 single-stranded DNA-binding protein [Acidimicrobiales bacterium] diamond 1113 64.7 0.993817619783617 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales 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);;