RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA975724" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 27 ✖

tax_kingdom 1

bioproject 1

  • PRJNA975724 · 27 ✖

analysis 1

  • diamond · 27 ✖

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
13699940 13699940 PRJNA975724_S_NODE_46571_length_304_cov_2.653680_g46390_i0 PRJNA975724 46571 304 2.65368 8.0671872 Streptacidiphilus 228398 Bacteria Bacteria 130 5.19e-33   NR WP_084717828.1 105422 g46390 i0 63.2 4.30263157894737 87 31 85.9 1 303 43 427 512 WP_084717828.1 cellulase family glycosylhydrolase [Streptacidiphilus carbonis] diamond 1308 130 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptacidiphilus Streptacidiphilus carbonis
20393066 20393066 PRJNA975724_S_NODE_19556_length_388_cov_13.863492_g19375_i0 PRJNA975724 19556 388 13.863492 53.79034896 Bacillati 1783272 Bacteria Bacteria 79.7 1.38e-14   NR WP_327733449.1 66374 g19375 i0 45.5 3.04639175257732 88 47 67.3 1 383 123 282 369 WP_327733449.1 glycine amidinotransferase [Streptomyces nojiriensis] diamond 1182 80.1 0.995006242197254 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces nojiriensis
26962564 26962564 PRJNA975724_S_NODE_60222_length_278_cov_1.970732_g60041_i0 PRJNA975724 60222 278 1.970732 5.47863496 Gaiellaceae bacterium 2838783 Bacteria Bacteria 77 5.22e-14   NR HEY8705686.1 2838783 g60041 i0 61.9 0.679856115107914 63 24 68 0 275 87 1003 1065 HEY8705686.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Gaiellaceae bacterium] diamond 189 77 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales Gaiellaceae   Gaiellaceae bacterium
27126607 27126607 PRJNA975724_S_NODE_3822_length_557_cov_3.783058_g3645_i0 PRJNA975724 3822 557 3.783058 21.07163306 Actinomycetes 1760 Bacteria Bacteria 117 8.52e-30   NR WP_384354995.1 2593676 g3645 i0 51.6 2.62836624775583 122 59 65.7 0 2 367 47 168 WP_384354995.1 MULTISPECIES: hemerythrin domain-containing protein [unclassified Streptomyces] diamond 1464 117 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces  
27594837 27594837 PRJNA975724_S_NODE_5264_length_516_cov_8.871332_g5085_i0 PRJNA975724 5264 516 8.871332 45.77607312 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 144 5.25e-37   NR MDO9355796.1 2586742 g5085 i0 51.3 1.86627906976744 156 64 83.7 1 445 14 414 569 MDO9355796.1 hypothetical protein [Solirubrobacteraceae bacterium] diamond 963 144 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
27752767 27752767 PRJNA975724_S_NODE_21944_length_377_cov_11.019737_g21763_i0 PRJNA975724 21944 377 11.019737 41.54440849 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 65.5 1.32e-10   NR MDH5423019.1 2080302 g21763 i0 53.7 0.429708222811671 54 25 43 0 370 209 81 134 MDH5423019.1 Hsp20/alpha crystallin family protein [Acidimicrobiia bacterium] diamond 162 65.5 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
28320866 28320866 PRJNA975724_S_NODE_49506_length_298_cov_2.040000_g49325_i0 PRJNA975724 49506 298 2.04 6.0792 Bifidobacteriaceae bacterium 2291324 Bacteria Bacteria 62.4 9.24e-9   NR MDR1392846.1 2291324 g49325 i0 39 2.31543624161074 82 50 82.6 0 17 262 197 278 MDR1392846.1 FG-GAP-like repeat-containing protein [Bifidobacteriaceae bacterium] diamond 690 62.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae   Bifidobacteriaceae bacterium
28352451 28352451 PRJNA975724_S_NODE_92326_length_237_cov_2.573171_g92145_i0 PRJNA975724 92326 237 2.573171 6.09841527 unclassified Streptomyces 2593676 Bacteria Bacteria 47.8 5.91e-4   NR WP_388823461.1 2593676 g92145 i0 33.7 1.08860759493671 86 48 98.7 3 2 235 943 1027 WP_388823461.1 MULTISPECIES: amino acid adenylation domain-containing protein [unclassified Streptomyces] diamond 258 47.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces  
28674558 28674558 PRJNA975724_S_NODE_967_length_811_cov_8.239837_g828_i0 PRJNA975724 967 811 8.239837 66.82507807 Bacillati 1783272 Bacteria Bacteria 48.5 0.00216   NR MEA2136664.1 2586742 g828 i0 52.3 0.643649815043157 44 21 16.3 0 50 181 44 87 MEA2136664.1 hypothetical protein [Solirubrobacteraceae bacterium] diamond 522 48.5 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
28825854 28825854 PRJNA975724_S_NODE_42168_length_314_cov_4.668050_g41987_i0 PRJNA975724 42168 314 4.66805 14.657677 Naumannella halotolerans 993414 Bacteria Bacteria 80.1 3.04e-15   NR WP_208292789.1 993414 g41987 i0 42.2 0.974522292993631 102 51 89.8 1 26 307 221 322 WP_208292789.1 queuosine salvage family protein [Naumannella halotolerans] diamond 306 80.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Naumannella Naumannella halotolerans
28895367 28895367 PRJNA975724_S_NODE_60388_length_278_cov_1.492683_g60207_i0 PRJNA975724 60388 278 1.492683 4.14965874 Bacteria 2 Bacteria Bacteria 80.1 1.14e-16   NR MFO7299503.1 1883427 g60207 i0 60.3 3.39928057553957 63 25 68 0 213 25 88 150 MFO7299503.1 MaoC family dehydratase [Actinomycetes bacterium] diamond 945 80.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
29110382 29110382 PRJNA975724_S_NODE_5888_length_505_cov_2.032407_g5709_i0 PRJNA975724 5888 505 2.032407 10.26365535 Streptomyces sp. Isolate_219 2950110 Bacteria Bacteria 51.2 5.8e-4   NR WP_262037361.1 2950110 g5709 i0 32.2 0.534653465346535 90 57 53.5 1 278 9 770 855 WP_262037361.1 BREX-2 system adenine-specific DNA-methyltransferase PglX [Streptomyces sp. Isolate_219] diamond 270 51.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. Isolate_219
29205163 29205163 PRJNA975724_S_NODE_61289_length_276_cov_2.586207_g61108_i0 PRJNA975724 61289 276 2.586207 7.13793132 Frigoribacterium faeni 145483 Bacteria Bacteria 43.9 0.0202   NR WP_166760358.1 145483 g61108 i0 53.7 0.815217391304348 41 19 44.6 0 235 113 63 103 WP_166760358.1 ubiquitin-like protein [Frigoribacterium faeni] diamond 225 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Frigoribacterium Frigoribacterium faeni
29331256 29331256 PRJNA975724_S_NODE_11629_length_436_cov_4.019284_g11448_i0 PRJNA975724 11629 436 4.019284 17.52407824 Microlunatus parietis 682979 Bacteria Bacteria 121 4.54e-30   NR WP_179758069.1 682979 g11448 i0 66.7 0.598623853211009 87 29 59.9 0 2 262 239 325 WP_179758069.1 aldo/keto reductase [Microlunatus parietis] diamond 261 121 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Microlunatus Microlunatus parietis
29495384 29495384 PRJNA975724_S_NODE_67210_length_267_cov_1.190722_g67029_i0 PRJNA975724 67210 267 1.190722 3.17922774 root 1 Root_unresolved Root_unresolved 46.6 1.51e-4   NR MDX6540197.1 2093372 g67029 i0 45.5 1.9438202247191 55 22 61.8 2 81 245 1 47 MDX6540197.1 large subunit ribosomal protein [Gaiellales bacterium] diamond 519 46.6 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales     Gaiellales bacterium
29741484 29741484 PRJNA975724_S_NODE_54190_length_289_cov_1.782407_g54009_i0 PRJNA975724 54190 289 1.782407 5.15115623 Mycolicibacterium komossense 1779 Bacteria Bacteria 57.4 3.5e-7   NR WP_264068932.1 1779 g54009 i0 45.9 1.96193771626298 61 21 63.3 1 287 105 227 275 WP_264068932.1 endonuclease/exonuclease/phosphatase family protein [Mycolicibacterium komossense] diamond 567 57.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycolicibacterium Mycolicibacterium komossense
29741488 29741488 PRJNA975724_S_NODE_82790_length_247_cov_3.425287_g82609_i0 PRJNA975724 82790 247 3.425287 8.46045889 Gaiellales bacterium 2093372 Bacteria Bacteria 94.7 8.95e-22   NR MDX6533480.1 2093372 g82609 i0 56.2 0.88663967611336 73 32 88.7 0 247 29 146 218 MDX6533480.1 hypothetical protein [Gaiellales bacterium] diamond 219 94.7 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales     Gaiellales bacterium
29842698 29842698 PRJNA975724_S_NODE_13671_length_421_cov_3.336207_g13490_i0 PRJNA975724 13671 421 3.336207 14.04543147 Bacteria 2 Bacteria Bacteria 47.8 7.65e-4   NR WP_155359033.1 150177 g13490 i0 61.4 1.20427553444181 44 17 31.4 0 1 132 72 115 WP_155359033.1 DUF1304 domain-containing protein [Acrocarpospora macrocephala] diamond 507 47.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Acrocarpospora Acrocarpospora macrocephala
30183964 30183964 PRJNA975724_S_NODE_15072_length_412_cov_5.648968_g14891_i0 PRJNA975724 15072 412 5.648968 23.27374816 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 91.3 2.02e-19   NR MDJ0792343.1 2080302 g14891 i0 45.9 2.13349514563107 98 53 71.4 0 10 303 144 241 MDJ0792343.1 VIT1/CCC1 transporter family protein [Acidimicrobiia bacterium] diamond 879 91.3 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
30531443 30531443 PRJNA975724_S_NODE_66373_length_268_cov_1.579487_g66192_i0 PRJNA975724 66373 268 1.579487 4.23302516 Thermoleophilaceae bacterium 2732252 Bacteria Bacteria 49.7 1.69e-4   NR HEX6714025.1 2732252 g66192 i0 34.1 0.951492537313433 85 54 94 2 17 268 229 312 HEX6714025.1 DUF5995 family protein [Thermoleophilaceae bacterium] diamond 255 49.7 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Thermoleophilales Thermoleophilaceae   Thermoleophilaceae bacterium
31037390 31037390 PRJNA975724_S_NODE_93415_length_230_cov_2.942675_g93234_i0 PRJNA975724 93415 230 2.942675 6.7681525 Actinophytocola sp. 1872138 Bacteria Bacteria 42.4 0.0451   NR WP_327564348.1 1872138 g93234 i0 42.2 0.834782608695652 64 34 83.5 2 215 24 2452 2512 WP_327564348.1 hypothetical protein [Actinophytocola sp.] diamond 192 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Actinophytocola Actinophytocola sp.
31131562 31131562 PRJNA975724_S_NODE_12595_length_429_cov_2.595506_g12414_i0 PRJNA975724 12595 429 2.595506 11.13472074 Actinomycetes bacterium 1883427 Bacteria Bacteria 55.8 5.39e-6   NR MCW2963999.1 1883427 g12414 i0 64.1 0.272727272727273 39 14 27.3 0 10 126 247 285 MCW2963999.1 hypothetical protein [Actinomycetes bacterium] diamond 117 55.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
31517701 31517701 PRJNA975724_S_NODE_84936_length_246_cov_0.890173_g84755_i0 PRJNA975724 84936 246 0.890173 2.18982558 FCB group 1783270 Bacteria Bacteria 42.7 0.0353   NR WP_208035167.1 80860 g84755 i0 34 1.39024390243902 53 35 64.6 0 161 3 165 217 WP_208035167.1 (2Fe-2S)-binding protein [Streptomyces cyanogenus] diamond 342 43.1 0.990719257540603 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces cyanogenus
32144033 32144033 PRJNA975724_S_NODE_40978_length_317_cov_2.331967_g40797_i0 PRJNA975724 40978 317 2.331967 7.39233539 Streptomyces sp. NPDC 1931 Bacteria Bacteria 67.4 1.87e-10   NR WP_365687245.1 3155054 g40797 i0 58.2 0.520504731861199 55 23 52.1 0 314 150 432 486 WP_365687245.1 carotenoid oxygenase family protein [Streptomyces sp. NPDC052299] diamond 165 67.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC052299
32302578 32302578 PRJNA975724_S_NODE_80399_length_249_cov_2.056818_g80218_i0 PRJNA975724 80399 249 2.056818 5.12147682 Trebonia sp. 2767075 Bacteria Bacteria 68.2 8.99e-12   NR HTU74941.1 2767075 g80218 i0 60.3 0.698795180722892 58 20 69.9 1 3 176 142 196 HTU74941.1 histidine phosphatase family protein [Trebonia sp.] diamond 174 68.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Treboniaceae Trebonia Trebonia sp.
32561889 32561889 PRJNA975724_S_NODE_87559_length_244_cov_0.900585_g87378_i0 PRJNA975724 87559 244 0.900585 2.1974274 FCB group 1783270 Bacteria Bacteria 77.8 1.24e-14   NR WP_327557516.1 1872138 g87378 i0 51.9 7.6844262295082 77 31 94.7 1 232 2 137 207 WP_327557516.1 hypothetical protein, partial [Actinophytocola sp.] diamond 1875 77.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Actinophytocola Actinophytocola sp.
32870234 32870234 PRJNA975724_S_NODE_5240_length_517_cov_2.452703_g5061_i0 PRJNA975724 5240 517 2.452703 12.68047451 Umezawaea sp. Da 62-37 3075927 Bacteria Bacteria 88.2 4.75e-17   NR WP_315927298.1 3075927 g5061 i0 52.7 1.67117988394584 74 35 42.9 0 479 258 301 374 WP_315927298.1 glycine amidinotransferase [Umezawaea sp. Da 62-37] diamond 864 88.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Umezawaea Umezawaea sp. Da 62-37

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