RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA832865" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 17 ✖

bioproject 1

  • PRJNA832865 · 17 ✖
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
1228627 1228627 PRJNA832865_S_NODE_93241_length_252_cov_1.648045_g88155_i0 PRJNA832865 93241 252 1.648045 4.1530734 Planktothrix 54304 Bacteria Bacteria 52.8 0.023   NTclustered gi|224581510|gb|FJ184461.1| 603417 g88155 i0 100 0.333333333333333 28 0 11 0 225 252 564 537 Planktothrix mougeotii HAB3342 ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, partial cds; and RbcX (rbcX) gene, complete cds blastn 84 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix mougeotii
2099240 2099240 PRJNA832865_S_NODE_79082_length_276_cov_1.472906_g73996_i0 PRJNA832865 79082 276 1.472906 4.06522056 Cyanobacterium sp. HL-69 2054282 Bacteria Bacteria 52.8 0.025   NTclustered gi|1298149266|gb|CP024912.1| 2054282 g73996 i0 100 0.101449275362319 28 0 10 0 103 130 3042692 3042719 Cyanobacterium sp. HL-69 chromosome, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Cyanobacterium Cyanobacterium sp. HL-69
3374538 3374538 PRJNA832865_S_NODE_78963_length_276_cov_1.822660_g73877_i0 PRJNA832865 78963 276 1.82266 5.0305416 Gloeothece verrucosa 2546359 Bacteria Bacteria 54.7 0.007   NTclustered gi|306980173|gb|CP002198.1| 497965 g73877 i0 96.97 0.119565217391304 33 0 12 1 68 99 1255595 1255627 Cyanothece sp. PCC 7822, complete genome blastn 33 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Gloeothece Gloeothece verrucosa
4650479 4650479 PRJNA832865_S_NODE_103884_length_245_cov_0.895349_g98798_i0 PRJNA832865 103884 245 0.895349 2.19360505 Cyanobacterium stanieri 102235 Bacteria Bacteria 52.8 0.022   NTclustered gi|428686127|gb|CP003940.1| 292563 g98798 i0 100 0.114285714285714 28 0 11 0 146 173 1369336 1369309 Cyanobacterium stanieri PCC 7202, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Cyanobacterium Cyanobacterium stanieri
9751154 9751154 PRJNA832865_S_NODE_42408_length_402_cov_1.291793_g37322_i0 PRJNA832865 42408 402 1.291793 5.19300786 Cyanobacterium stanieri 102235 Bacteria Bacteria 52.8 0.039   NTclustered gi|428686127|gb|CP003940.1| 292563 g37322 i0 100 0.0696517412935323 28 0 7 0 110 137 1369336 1369309 Cyanobacterium stanieri PCC 7202, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Cyanobacterium Cyanobacterium stanieri
17402146 17402146 PRJNA832865_S_NODE_87354_length_261_cov_1.638298_g82268_i0 PRJNA832865 87354 261 1.638298 4.27595778 Synechocystis sp. PCC 7339 2782213 Bacteria Bacteria 52.8 0.024   NTclustered gi|2092583171|gb|CP063659.1| 2782213 g82268 i0 100 0.10727969348659 28 0 11 0 186 213 821098 821071 Synechocystis sp. PCC 7339 chromosome, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7339
28381009 28381009 PRJNA832865_S_NODE_31206_length_516_cov_1.336343_g26141_i0 PRJNA832865 31206 516 1.336343 6.89552988 Pleurocapsa sp. MO_226.B13 3036786 Bacteria Bacteria 69.3 3.54e-10   NR MDJ0596593.1 3036786 g26141 i0 53.4 1.51162790697674 58 27 33.7 0 466 293 837 894 MDJ0596593.1 reverse transcriptase family protein [Pleurocapsa sp. MO_226.B13] diamond 780 69.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. MO_226.B13
28949576 28949576 PRJNA832865_S_NODE_104248_length_245_cov_0.895349_g99162_i0 PRJNA832865 104248 245 0.895349 2.19360505 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 76.6 4.33e-14   NR MBC7474511.1 2762020 g99162 i0 57.1 0.942857142857143 77 32 93.1 1 15 242 312 388 MBC7474511.1 IS200/IS605 family element transposase accessory protein TnpB [Candidatus Sericytochromatia bacterium] diamond 231 76.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
29139073 29139073 PRJNA832865_S_NODE_100149_length_247_cov_1.327586_g95063_i0 PRJNA832865 100149 247 1.327586 3.27913742 Synechococcus sp. WH 8007 58665 Bacteria Bacteria 42.4 0.0446   NR MDM7958675.1 58665 g95063 i0 33.8 0.789473684210526 65 43 78.9 0 28 222 116 180 MDM7958675.1 hypothetical protein [Synechococcus sp. WH 8007] diamond 195 42.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. WH 8007
29643635 29643635 PRJNA832865_S_NODE_74250_length_286_cov_1.084507_g69164_i0 PRJNA832865 74250 286 1.084507 3.10169002 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 47.4 0.00141   NR MEL7522491.1 3023125 g69164 i0 38.6 0.734265734265734 70 40 72.4 2 19 225 322 389 MEL7522491.1 ribonuclease H family protein [Cyanobacteria bacterium J06553_1] diamond 210 47.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06553_1
30276066 30276066 PRJNA832865_S_NODE_83372_length_268_cov_1.579487_g78286_i0 PRJNA832865 83372 268 1.579487 4.23302516 Cyanobacteria bacterium J06582_2 3023143 Bacteria Bacteria 110 5.74e-26   NR MEL7079339.1 3023143 g78286 i0 56.3 0.973880597014925 87 38 97.4 0 8 268 105 191 MEL7079339.1 reverse transcriptase domain-containing protein [Cyanobacteria bacterium J06582_2] diamond 261 110 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06582_2
30339456 30339456 PRJNA832865_S_NODE_65732_length_305_cov_1.603448_g60646_i0 PRJNA832865 65732 305 1.603448 4.8905164 Pleurocapsa sp. MO_226.B13 3036786 Bacteria Bacteria 63.9 2.81e-9   NR MDJ0596593.1 3036786 g60646 i0 46 0.619672131147541 63 34 62 0 80 268 832 894 MDJ0596593.1 reverse transcriptase family protein [Pleurocapsa sp. MO_226.B13] diamond 189 63.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. MO_226.B13
30591663 30591663 PRJNA832865_S_NODE_66053_length_304_cov_2.441558_g60967_i0 PRJNA832865 66053 304 2.441558 7.42233632 Microcystis sp. 53602_E8 2904984 Bacteria Bacteria 64.3 2.05e-9   NR MCE2664493.1 2904984 g60967 i0 54.2 0.473684210526316 48 22 47.4 0 109 252 744 791 MCE2664493.1 hypothetical protein [Microcystis sp. 53602_E8] diamond 144 64.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis sp. 53602_E8
31065889 31065889 PRJNA832865_S_NODE_84555_length_266_cov_1.440415_g79469_i0 PRJNA832865 84555 266 1.440415 3.8315039 Microcoleus sp. herbarium14 3055439 Bacteria Bacteria 44.3 0.0135   NR WP_333365481.1 3055439 g79469 i0 25.6 0.924812030075188 82 56 86.8 1 239 9 266 347 WP_333365481.1 SDR family NAD(P)-dependent oxidoreductase [Microcoleus sp. herbarium14] diamond 246 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus sp. herbarium14
31097125 31097125 PRJNA832865_S_NODE_23955_length_658_cov_2.394872_g19040_i0 PRJNA832865 23955 658 2.394872 15.75825776 Pleurocapsa sp. MO_226.B13 3036786 Bacteria Bacteria 68.9 1.58e-9   NR MDJ0596593.1 3036786 g19040 i0 53.4 1.40881458966565 58 27 26.4 0 608 435 837 894 MDJ0596593.1 reverse transcriptase family protein [Pleurocapsa sp. MO_226.B13] diamond 927 68.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. MO_226.B13
31508470 31508470 PRJNA832865_S_NODE_61536_length_317_cov_0.946721_g56450_i0 PRJNA832865 61536 317 0.946721 3.00110557 Cyanobacteria bacterium J06614_10 3023159 Bacteria Bacteria 58.9 1.74e-7   NR MEL6606504.1 3023159 g56450 i0 40.3 1.49526813880126 67 40 63.4 0 3 203 115 181 MEL6606504.1 reverse transcriptase family protein [Cyanobacteria bacterium J06614_10] diamond 474 58.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06614_10
31666319 31666319 PRJNA832865_S_NODE_21637_length_731_cov_1.480243_g16852_i0 PRJNA832865 21637 731 1.480243 10.82057633 Cyanobacteria bacterium J06582_2 3023143 Bacteria Bacteria 48.9 0.014   NR MEL7079323.1 3023143 g16852 i0 36.2 1.0875512995896 58 37 23.8 0 317 490 1194 1251 MEL7079323.1 hypothetical protein [Cyanobacteria bacterium J06582_2] diamond 795 48.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06582_2

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