RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJEB29441" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJEB29441 · 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
27033202 27033202 PRJEB29441_P_NODE_40682_length_166_cov_0.871795_g40241_i0 PRJEB29441 40682 166 0.871795 1.4471797 Acidobacteriota bacterium 1978231 Bacteria Bacteria 57.8 6.55e-8   NR PWT92676.1 1978231 g40241 i0 40 0.993975903614458 55 33 99.4 0 166 2 393 447 PWT92676.1 MAG: hypothetical protein C5B54_03155 [Acidobacteriota bacterium] diamond 165 57.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27152728 27152728 PRJEB29441_P_NODE_35542_length_175_cov_1.603175_g35101_i0 PRJEB29441 35542 175 1.603175 2.80555625 Bacteria 2 Bacteria Bacteria 107 1.78e-25   NR MBP6824494.1 1978231 g35101 i0 82.5 1.93714285714286 57 10 97.7 0 3 173 822 878 MBP6824494.1 sigma 54-interacting transcriptional regulator [Acidobacteriota bacterium] diamond 339 107 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27570327 27570327 PRJEB29441_P_NODE_31064_length_188_cov_1.179856_g30623_i0 PRJEB29441 31064 188 1.179856 2.21812928 Terriglobia bacterium 2081523 Bacteria Bacteria 42 0.0337   NR MBV8728524.1 2081523 g30623 i0 39.6 1.69148936170213 53 31 84.6 1 29 187 325 376 MBV8728524.1 penicillin-binding protein 2 [Terriglobia bacterium] diamond 318 42 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
27570332 27570332 PRJEB29441_P_NODE_40584_length_166_cov_0.871795_g40143_i0 PRJEB29441 40584 166 0.871795 1.4471797 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 42.4 0.0185   NR HEX6901099.1 2651171 g40143 i0 42.9 0.759036144578313 42 24 75.9 0 136 11 254 295 HEX6901099.1 ATP-binding protein [Thermoanaerobaculia bacterium] diamond 126 42.4 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
29023147 29023147 PRJEB29441_P_NODE_47408_length_161_cov_0.910714_g46967_i0 PRJEB29441 47408 161 0.910714 1.46624954 uncultured Acidobacteriales bacterium HF 710732 Bacteria Bacteria 50.1 4.49e-6   NR ADI18109.1 710732 g46967 i0 49.1 0.987577639751553 53 27 98.8 0 3 161 34 86 ADI18109.1 hypothetical protein [uncultured Acidobacteriales bacterium HF0200_23L05] diamond 159 50.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     uncultured Acidobacteriales bacterium HF0200_23L05
29811993 29811993 PRJEB29441_P_NODE_39571_length_167_cov_0.864407_g39130_i0 PRJEB29441 39571 167 0.864407 1.44355969 Chloracidobacterium sp. 2099375 Bacteria Bacteria 90.9 1.22e-19   NR MBK8467832.1 2099375 g39130 i0 78.2 0.988023952095808 55 12 98.8 0 3 167 64 118 MBK8467832.1 hypothetical protein [Chloracidobacterium sp.] diamond 165 90.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Chloracidobacterium Chloracidobacterium sp.
29970042 29970042 PRJEB29441_P_NODE_47451_length_161_cov_0.910714_g47010_i0 PRJEB29441 47451 161 0.910714 1.46624954 Acidobacteriota bacterium 1978231 Bacteria Bacteria 101 1.49e-24   NR MBA3232098.1 1978231 g47010 i0 90.6 0.987577639751553 53 5 98.8 0 160 2 115 167 MBA3232098.1 ATP-binding protein [Acidobacteriota bacterium] diamond 159 101 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30444137 30444137 PRJEB29441_P_NODE_35973_length_174_cov_1.416000_g35532_i0 PRJEB29441 35973 174 1.416 2.46384 Luteitalea sp. 2004800 Bacteria Bacteria 65.1 3.72e-11   NR WP_291982017.1 2004800 g35532 i0 48.5 1.13793103448276 66 24 100 3 174 1 31 94 WP_291982017.1 HNH endonuclease signature motif containing protein [Luteitalea sp.] diamond 198 65.1 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales Vicinamibacteraceae Luteitalea Luteitalea sp.
30601850 30601850 PRJEB29441_P_NODE_42013_length_165_cov_0.879310_g41572_i0 PRJEB29441 42013 165 0.87931 1.4508615 Bryobacterales bacterium 2026791 Bacteria Bacteria 95.1 7.86e-22   NR MCZ2077874.1 2026791 g41572 i0 74.5 2 55 14 100 0 165 1 115 169 MCZ2077874.1 site-specific DNA-methyltransferase [Bryobacterales bacterium] diamond 330 95.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
31328786 31328786 PRJEB29441_P_NODE_42956_length_164_cov_0.886957_g42515_i0 PRJEB29441 42956 164 0.886957 1.45460948 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 97.8 4.33e-22   NR MEQ1761745.1 2283092 g42515 i0 88.9 0.98780487804878 54 6 98.8 0 3 164 387 440 MEQ1761745.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 162 97.8 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31581993 31581993 PRJEB29441_P_NODE_44136_length_163_cov_0.894737_g43695_i0 PRJEB29441 44136 163 0.894737 1.45842131 Blastocatellia bacterium 2052146 Bacteria Bacteria 60.1 9.64e-9   NR MFP5263736.1 2052146 g43695 i0 54.7 0.975460122699387 53 24 97.5 0 1 159 91 143 MFP5263736.1 hypothetical protein [Blastocatellia bacterium] diamond 159 60.1 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
32246548 32246548 PRJEB29441_P_NODE_27238_length_201_cov_1.611842_g26797_i0 PRJEB29441 27238 201 1.611842 3.23980242 Terriglobales bacterium 2282142 Bacteria Bacteria 54.3 1.77e-6   NR HZQ68473.1 2282142 g26797 i0 47 2.97014925373134 66 25 98.5 2 200 3 323 378 HZQ68473.1 amino acid adenylation domain-containing protein [Terriglobales bacterium] diamond 597 54.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales 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);;