RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA448207" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA448207 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
27676540 27676540 PRJNA448207_P_NODE_27004_length_249_cov_0.875000_g26841_i0 PRJNA448207 27004 249 0.875 2.17875 Corynebacterium urealyticum 43771 Bacteria Bacteria 91.3 1.18e-21   NR WP_012359291.1 43771 g26841 i0 54.7 1.80722891566265 75 34 90.4 0 248 24 30 104 WP_012359291.1 transglycosylase family protein [Corynebacterium urealyticum] diamond 450 91.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium urealyticum
27897193 27897193 PRJNA448207_P_NODE_24145_length_259_cov_1.086022_g23982_i0 PRJNA448207 24145 259 1.086022 2.81279698 Streptomyces hesseae 3075519 Bacteria Bacteria 42.7 0.0453   NR WP_311615994.1 3075519 g23982 i0 38.9 0.625482625482625 54 30 59.1 1 43 195 216 269 WP_311615994.1 hypothetical protein [Streptomyces hesseae] diamond 162 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces hesseae
28150047 28150047 PRJNA448207_P_NODE_22965_length_267_cov_1.484536_g22802_i0 PRJNA448207 22965 267 1.484536 3.96371112 Streptomyces sp. NBC_ 1931 Bacteria Bacteria 41.6 0.0482   NR WUD79158.1 2903659 g22802 i0 46.5 0.48314606741573 43 22 48.3 1 150 22 13 54 WUD79158.1 transposase [Streptomyces sp. NBC_00503] diamond 129 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NBC_00503
29223605 29223605 PRJNA448207_P_NODE_25949_length_250_cov_1.372881_g25786_i0 PRJNA448207 25949 250 1.372881 3.4322025 Nocardioides sp. 35761 Bacteria Bacteria 43.1 0.0285   NR MEI2715088.1 35761 g25786 i0 37.9 0.696 58 30 69.6 2 3 176 168 219 MEI2715088.1 glycosyltransferase 87 family protein [Nocardioides sp.] diamond 174 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides sp.
29760006 29760006 PRJNA448207_P_NODE_27091_length_249_cov_0.875000_g26928_i0 PRJNA448207 27091 249 0.875 2.17875 Streptomyces kaniharaensis 212423 Bacteria Bacteria 72.4 1.41e-12   NR WP_230211146.1 212423 g26928 i0 48.1 1.89156626506024 81 40 97.6 2 246 4 363 441 WP_230211146.1 flavin monoamine oxidase family protein [Streptomyces kaniharaensis] diamond 471 72.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces kaniharaensis
30897682 30897682 PRJNA448207_P_NODE_11614_length_366_cov_0.798635_g11452_i0 PRJNA448207 11614 366 0.798635 2.9230041 Streptosporangiaceae bacterium 2339230 Bacteria Bacteria 43.5 0.0389   NR HEY1918912.1 2339230 g11452 i0 34.2 0.622950819672131 76 47 62.3 1 90 317 44 116 HEY1918912.1 SSI family serine proteinase inhibitor [Streptosporangiaceae bacterium] diamond 228 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae   Streptosporangiaceae bacterium
31656118 31656118 PRJNA448207_P_NODE_33657_length_233_cov_5.231250_g33494_i0 PRJNA448207 33657 233 5.23125 12.1888125 Kitasatospora sp. NPDC 1871188 Bacteria Bacteria 43.1 0.0239   NR WP_355669325.1 3154555 g33494 i0 44.4 0.695278969957081 54 24 64.4 2 230 81 96 147 WP_355669325.1 asparagine synthase-related protein [Kitasatospora sp. NPDC004669] diamond 162 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Kitasatospora Kitasatospora sp. NPDC004669
31972631 31972631 PRJNA448207_P_NODE_9118_length_408_cov_0.904478_g8956_i0 PRJNA448207 9118 408 0.904478 3.69027024 Streptomyces typhae 2681492 Bacteria Bacteria 44.7 0.041   NR WP_157168098.1 2681492 g8956 i0 42.3 0.382352941176471 52 29 37.5 1 57 209 307 358 WP_157168098.1 phosphatase PAP2 family protein [Streptomyces typhae] diamond 156 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces typhae
32383967 32383967 PRJNA448207_P_NODE_6499_length_474_cov_1.728180_g6337_i0 PRJNA448207 6499 474 1.72818 8.1915732 Saccharopolyspora flava 95161 Bacteria Bacteria 50.4 6.98e-4   NR WP_093418561.1 95161 g6337 i0 44.3 0.5 79 41 48.7 2 390 160 20 97 WP_093418561.1 LLM class flavin-dependent oxidoreductase [Saccharopolyspora flava] diamond 237 50.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Saccharopolyspora Saccharopolyspora flava

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