RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA289590" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 12 ✖

bioproject 1

  • PRJNA289590 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
20773898 20773898 PRJNA289590_P_NODE_16317_length_223_cov_1.195402_g16093_i0 PRJNA289590 16317 223 1.195402 2.66574646 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 104 1.74e-24   NR WP_006530517.1 102232 g16093 i0 66.2 3.98206278026906 74 25 99.6 0 2 223 338 411 WP_006530517.1 glycerate kinase type-2 family protein [Gloeocapsa sp. PCC 73106] diamond 888 105 0.990476190476191 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Gloeocapsa Gloeocapsa sp. PCC 73106
26807020 26807020 PRJNA289590_P_NODE_16861_length_219_cov_1.223529_g16637_i0 PRJNA289590 16861 219 1.223529 2.67952851 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 107 4.51e-25   NR WP_011365475.1 110662 g16637 i0 77.8 8.75342465753425 72 16 98.6 0 3 218 601 672 WP_011365475.1 NAD-dependent DNA ligase LigA [Synechococcus sp. CC9605] diamond 1917 108 0.990740740740741 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. CC9605
26821187 26821187 PRJNA289590_P_NODE_31341_length_162_cov_0.920354_g31117_i0 PRJNA289590 31341 162 0.920354 1.49097348 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 66.2 5.17e-11   NR MBX9694561.1 2847862 g31117 i0 56.6 2.98148148148148 53 23 98.1 0 1 159 33 85 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 483 66.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
27376580 27376580 PRJNA289590_P_NODE_28843_length_165_cov_0.896552_g28619_i0 PRJNA289590 28843 165 0.896552 1.4793108 Bacteria 2 Bacteria Bacteria 41.6 0.0344   NR OJJ26353.1 1925591 g28619 i0 32.7 3.01818181818182 55 37 100 0 165 1 237 291 OJJ26353.1 hypothetical protein BI308_07005 [Roseofilum reptotaenium AO1-A] diamond 498 42 0.990476190476191 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Desertifilales Desertifilaceae Roseofilum Roseofilum reptotaenium
27579616 27579616 PRJNA289590_P_NODE_19824_length_200_cov_2.000000_g19600_i0 PRJNA289590 19824 200 2 4 Pseudanabaenaceae cyanobacterium bins.68 2971806 Bacteria Bacteria 52 1.06e-5   NR MDX1976129.1 2971806 g19600 i0 63.6 2.37 44 16 66 0 161 30 254 297 MDX1976129.1 N-acetylmuramic acid 6-phosphate etherase [Pseudanabaenaceae cyanobacterium bins.68] diamond 474 52 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae   Pseudanabaenaceae cyanobacterium bins.68
28148164 28148164 PRJNA289590_P_NODE_26125_length_169_cov_0.866667_g25901_i0 PRJNA289590 26125 169 0.866667 1.46466723 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 43.1 0.0101   NR MBX9692038.1 2847862 g25901 i0 70.4 0.479289940828402 27 8 47.9 0 2 82 175 201 MBX9692038.1 hypothetical protein [Cyanobacteriota bacterium] diamond 81 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
29537241 29537241 PRJNA289590_P_NODE_31090_length_162_cov_0.920354_g30866_i0 PRJNA289590 31090 162 0.920354 1.49097348 Cylindrospermopsis raciborskii 77022 Bacteria Bacteria 87 1.05e-19   NR WP_061547402.1 77022 g30866 i0 65.4 0.962962962962963 52 18 96.3 0 3 158 133 184 WP_061547402.1 hypothetical protein, partial [Cylindrospermopsis raciborskii] diamond 156 87 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Cylindrospermopsis Cylindrospermopsis raciborskii
29663206 29663206 PRJNA289590_P_NODE_16530_length_221_cov_2.686047_g16306_i0 PRJNA289590 16530 221 2.686047 5.93616387 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 60.1 4.96e-9   NR MBX9719843.1 2364082 g16306 i0 56.9 0.692307692307692 51 22 69.2 0 9 161 121 171 MBX9719843.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 153 60.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
29839020 29839020 PRJNA289590_P_NODE_26971_length_168_cov_0.873950_g26747_i0 PRJNA289590 26971 168 0.87395 1.468236 Bacteria 2 Bacteria Bacteria 105 6.38e-25   NR MCA0313891.1 2052166 g26747 i0 100 1.96428571428571 55 0 98.2 0 2 166 216 270 MCA0313891.1 methylmalonyl-CoA mutase family protein [Candidatus Melainabacteria bacterium] diamond 330 105 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
30359019 30359019 PRJNA289590_P_NODE_13072_length_252_cov_1.793103_g12848_i0 PRJNA289590 13072 252 1.793103 4.51861956 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 49.3 1.74e-4   NR MDX2271190.1 2847862 g12848 i0 68.8 0.380952380952381 32 10 38.1 0 251 156 240 271 MDX2271190.1 hypothetical protein [Cyanobacteriota bacterium] diamond 96 49.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
31071395 31071395 PRJNA289590_P_NODE_30535_length_163_cov_0.912281_g30311_i0 PRJNA289590 30535 163 0.912281 1.48701803 Bacteria 2 Bacteria Bacteria 90.9 1.34e-19   NR WP_127082095.1 32056 g30311 i0 74.1 14.9079754601227 54 14 99.4 0 1 162 213 266 WP_127082095.1 SWIM zinc finger family protein [Dulcicalothrix desertica] diamond 2430 91.7 0.991275899672846 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Dulcicalothrix Dulcicalothrix desertica
32526637 32526637 PRJNA289590_P_NODE_20699_length_195_cov_1.602740_g20475_i0 PRJNA289590 20699 195 1.60274 3.125343 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 105 3.41e-25   NR MEB3162447.1 54309 g20475 i0 69.8 7.69230769230769 63 19 96.9 0 194 6 195 257 MEB3162447.1 DNA (cytosine-5-)-methyltransferase [Prochlorothrix sp.] diamond 1500 105 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Prochlorotrichales Prochlorotrichaceae Prochlorothrix Prochlorothrix sp.

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