RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA937226" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA937226 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
16214917 16214917 PRJNA937226_S_NODE_23573_length_173_cov_3.774194_g23446_i0 PRJNA937226 23573 173 3.774194 6.52935562 Bacteria 2 Bacteria Bacteria 89 2.57e-19   NR WP_043487956.1 1883 g23446 i0 69.1 15.2601156069364 55 17 95.4 0 167 3 261 315 WP_043487956.1 MULTISPECIES: magnesium/cobalt transporter CorA [Streptomyces] diamond 2640 89 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces  
27253167 27253167 PRJNA937226_S_NODE_11463_length_231_cov_3.335165_g11336_i0 PRJNA937226 11463 231 3.335165 7.70423115 Mycobacteriales 85007 Bacteria Bacteria 112 2.58e-30   NR WP_195167339.1 36809 g11336 i0 64.4 1.93506493506494 73 26 94.8 0 221 3 8 80 WP_195167339.1 hypothetical protein [Mycobacteroides abscessus] diamond 447 112 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacteroides Mycobacteroides abscessus
27309650 27309650 PRJNA937226_S_NODE_23283_length_174_cov_3.328000_g23156_i0 PRJNA937226 23283 174 3.328 5.79072 Dietzia cinnamea 321318 Bacteria Bacteria 112 2.29e-27   NR WP_259825439.1 321318 g23156 i0 96.6 1 58 2 100 0 1 174 198 255 WP_259825439.1 amidohydrolase family protein [Dietzia cinnamea] diamond 174 112 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Dietziaceae Dietzia Dietzia cinnamea
27404383 27404383 PRJNA937226_S_NODE_22983_length_175_cov_2.611111_g22856_i0 PRJNA937226 22983 175 2.611111 4.56944425 Streptomyces sp. NPDC 1931 Bacteria Bacteria 42 0.0278   NR WP_385592309.1 3346973 g22856 i0 64.3 0.48 28 10 48 0 38 121 77 104 WP_385592309.1 hypothetical protein [Streptomyces sp. NPDC059853] diamond 84 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC059853
28004395 28004395 PRJNA937226_S_NODE_13605_length_216_cov_3.161677_g13478_i0 PRJNA937226 13605 216 3.161677 6.82922232 Micromonospora sp. NPDC 1876 Bacteria Bacteria 44.3 0.0073   NR WP_350894533.1 3154246 g13478 i0 33.8 1.02777777777778 74 43 94.4 2 211 8 205 278 WP_350894533.1 TrkH family potassium uptake protein [Micromonospora sp. NPDC000207] diamond 222 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Micromonospora Micromonospora sp. NPDC000207
28098790 28098790 PRJNA937226_S_NODE_27345_length_164_cov_2.260870_g27218_i0 PRJNA937226 27345 164 2.26087 3.7078268 Actinomycetota bacterium 2900548 Bacteria Bacteria 41.2 0.0454   NR MDQ3725345.1 2900548 g27218 i0 43.1 0.932926829268293 51 27 89.6 1 7 153 318 368 MDQ3725345.1 delta-60 repeat domain-containing protein [Actinomycetota bacterium] diamond 153 41.2 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28761807 28761807 PRJNA937226_S_NODE_17287_length_197_cov_2.108108_g17160_i0 PRJNA937226 17287 197 2.108108 4.15297276 Thermomonospora umbrina 111806 Bacteria Bacteria 45.8 0.00167   NR WP_116023266.1 111806 g17160 i0 33.9 0.898477157360406 59 38 89.8 1 12 188 150 207 WP_116023266.1 fibronectin type III domain-containing protein [Thermomonospora umbrina] diamond 177 45.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Thermomonospora Thermomonospora umbrina
30088089 30088089 PRJNA937226_S_NODE_25652_length_168_cov_1.033613_g25525_i0 PRJNA937226 25652 168 1.033613 1.73646984 Gryllotalpicola sp. 1932787 Bacteria Bacteria 41.6 0.0366   NR HEY0249092.1 1932787 g25525 i0 41.5 0.732142857142857 41 24 73.2 0 132 10 1606 1646 HEY0249092.1 InlB B-repeat-containing protein [Gryllotalpicola sp.] diamond 123 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Gryllotalpicola Gryllotalpicola sp.
30126582 30126582 PRJNA937226_S_NODE_12732_length_222_cov_1.202312_g12605_i0 PRJNA937226 12732 222 1.202312 2.66913264 Streptomycetaceae 2062 Bacteria Bacteria 43.9 0.00995   NR WP_093713755.1 380248 g12605 i0 38.9 1.48648648648649 54 33 73 0 20 181 34 87 WP_093713755.1 VOC family protein [Actinacidiphila alni] diamond 330 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Actinacidiphila Actinacidiphila alni
30783273 30783273 PRJNA937226_S_NODE_15374_length_206_cov_3.541401_g15247_i0 PRJNA937226 15374 206 3.541401 7.29528606 Streptomyces rimosus 1927 Bacteria Bacteria 44.3 0.00564   NR WP_063738564.1 1927 g15247 i0 37.3 0.859223300970874 59 33 80.1 2 167 3 86 144 WP_063738564.1 contact-dependent growth inhibition system immunity protein [Streptomyces rimosus] diamond 177 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces rimosus
31731575 31731575 PRJNA937226_S_NODE_9957_length_243_cov_4.804124_g9830_i0 PRJNA937226 9957 243 4.804124 11.67402132 Actinocorallia sp. B1 1872132 Bacteria Bacteria 45.8 0.003   NR WP_347677843.1 3153558 g9830 i0 39.3 0.753086419753086 61 36 74.1 1 1 180 62 122 WP_347677843.1 DUF6745 domain-containing protein [Actinocorallia sp. B10E7] diamond 183 45.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Actinocorallia Actinocorallia sp. B10E7
32269742 32269742 PRJNA937226_S_NODE_16218_length_202_cov_2.392157_g16091_i0 PRJNA937226 16218 202 2.392157 4.83215714 Piscicoccus intestinalis 746033 Bacteria Bacteria 43.5 0.011   NR WP_068430052.1 746033 g16091 i0 46.3 0.608910891089109 41 22 60.9 0 140 18 205 245 WP_068430052.1 universal stress protein [Piscicoccus intestinalis] diamond 123 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermatophilaceae Piscicoccus Piscicoccus intestinalis

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