RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1111448" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1111448 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
15050624 15050624 PRJNA1111448_S_NODE_82012_length_293_cov_1.604545_g81189_i0 PRJNA1111448 82012 293 1.604545 4.70131685 Rubrobacter 42255 Bacteria Bacteria 145 3.3e-40   NR MBV9455261.1 2036010 g81189 i0 71.1 2.97952218430034 97 28 99.3 0 291 1 170 266 MBV9455261.1 AAA family ATPase [Rubrobacter sp.] diamond 873 145 1 Bacteria   Bacillati Actinomycetota Rubrobacteria Rubrobacterales Rubrobacteraceae Rubrobacter Rubrobacter sp.
26814784 26814784 PRJNA1111448_S_NODE_97041_length_275_cov_1.143564_g96218_i0 PRJNA1111448 97041 275 1.143564 3.144801 Aurantimicrobium sp. 1930784 Bacteria Bacteria 52 1.62e-5   NR WP_332627486.1 1930784 g96218 i0 33.3 1.70181818181818 72 48 78.5 0 260 45 84 155 WP_332627486.1 DUF7194 family protein [Aurantimicrobium sp.] diamond 468 52 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aurantimicrobium Aurantimicrobium sp.
28195904 28195904 PRJNA1111448_S_NODE_119126_length_252_cov_1.374302_g118303_i0 PRJNA1111448 119126 252 1.374302 3.46324104 Streptomycetaceae 2062 Bacteria Bacteria 42 0.0115   NR WP_376412958.1 2593676 g118303 i0 43.5 1.23809523809524 62 30 67.9 2 205 35 5 66 WP_376412958.1 MULTISPECIES: hypothetical protein [unclassified Streptomyces] diamond 312 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces  
28646989 28646989 PRJNA1111448_S_NODE_116187_length_255_cov_1.269231_g115364_i0 PRJNA1111448 116187 255 1.269231 3.23653905 Mycobacterium kansasii 1768 Bacteria Bacteria 56.6 1e-7   NR ARG71276.1 1768 g115364 i0 57.6 81.8352941176471 85 27 92.9 3 240 4 58 139 ARG71276.1 hypothetical protein B1T47_22185 [Mycobacterium kansasii] diamond 20868 56.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium kansasii
29026078 29026078 PRJNA1111448_S_NODE_79408_length_297_cov_0.959821_g78585_i0 PRJNA1111448 79408 297 0.959821 2.85066837 Streptosporangiaceae bacterium 2339230 Bacteria Bacteria 43.5 0.0181   NR HEY5355128.1 2339230 g78585 i0 42.5 0.404040404040404 40 23 40.4 0 129 248 46 85 HEY5355128.1 hypothetical protein [Streptosporangiaceae bacterium] diamond 120 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae   Streptosporangiaceae bacterium
29057439 29057439 PRJNA1111448_S_NODE_122428_length_250_cov_0.870056_g121605_i0 PRJNA1111448 122428 250 0.870056 2.17514 Streptomyces monashensis 1678012 Bacteria Bacteria 44.7 0.00824   NR WP_071385715.1 1678012 g121605 i0 41.9 0.744 62 34 73.2 2 222 40 63 123 WP_071385715.1 transposase [Streptomyces monashensis] diamond 186 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces monashensis
30857619 30857619 PRJNA1111448_S_NODE_114174_length_257_cov_1.222826_g113351_i0 PRJNA1111448 114174 257 1.222826 3.14266282 Micromonosporaceae bacterium 1873464 Bacteria Bacteria 41.6 0.017   NR HEX6968938.1 1873464 g113351 i0 39.7 0.67704280155642 58 28 67.7 2 33 206 12 62 HEX6968938.1 hypothetical protein [Micromonosporaceae bacterium] diamond 174 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae   Micromonosporaceae bacterium
31047578 31047578 PRJNA1111448_S_NODE_120495_length_251_cov_1.134831_g119672_i0 PRJNA1111448 120495 251 1.134831 2.84842581 Crossiella sp. CA-258 1911417 Bacteria Bacteria 43.1 0.029   NR WP_283662022.1 2981138 g119672 i0 40.6 0.764940239043825 64 38 76.5 0 193 2 1 64 WP_283662022.1 hypothetical protein [Crossiella sp. CA-258035] diamond 192 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Crossiella Crossiella sp. CA-258035
31322907 31322907 PRJNA1111448_S_NODE_128335_length_247_cov_0.885057_g127512_i0 PRJNA1111448 128335 247 0.885057 2.18609079 root 1 Root_unresolved Root_unresolved 60.1 2.33e-9   NR MES9256757.1 1747 g127512 i0 56.3 1.74898785425101 48 21 58.3 0 155 12 2 49 MES9256757.1 DUF1725 domain-containing protein [Cutibacterium acnes] diamond 432 60.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
32344372 32344372 PRJNA1111448_S_NODE_142939_length_228_cov_2.083871_g142116_i0 PRJNA1111448 142939 228 2.083871 4.75122588 Ilumatobacter sp. 1967498 Bacteria Bacteria 54.3 2.57e-6   NR MFK8026408.1 1967498 g142116 i0 39 1.07894736842105 82 41 96.1 3 227 9 294 375 MFK8026408.1 gamma-glutamyltransferase [Ilumatobacter sp.] diamond 246 54.3 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae Ilumatobacter Ilumatobacter sp.
32848930 32848930 PRJNA1111448_S_NODE_136940_length_242_cov_0.976331_g136117_i0 PRJNA1111448 136940 242 0.976331 2.36272102 Tsukamurella strandjordii 147577 Bacteria Bacteria 42.4 0.0484   NR WP_343929858.1 147577 g136117 i0 40.4 0.644628099173554 52 28 60.7 1 25 171 237 288 WP_343929858.1 ABC transporter permease [Tsukamurella strandjordii] diamond 156 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Tsukamurellaceae Tsukamurella Tsukamurella strandjordii

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