RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where bioproject = "PRJNA437204", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 26 ✖

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 26 ✖

bioproject 1

  • PRJNA437204 · 26 ✖
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
2983578 2983578 PRJNA437204_P_NODE_57563_length_285_cov_1.452830_g57264_i0 PRJNA437204 57563 285 1.45283 4.1405655 Umezakia ovalisporum 75695 Bacteria Bacteria 350 8.34e-92   NTclustered gi|333109175|gb|JF768745.1| 1029747 g57264 i0 88.85 112.663157894737 287 28 100 4 1 285 3606 3322 Aphanizomenon ovalisporum ILC-164 rDNA type 2 operon, complete sequence blastn 32109 350 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nodulariaceae Umezakia Umezakia ovalisporum
2983581 2983581 PRJNA437204_P_NODE_5763_length_668_cov_1.633613_g5473_i0 PRJNA437204 5763 668 1.633613 10.91253484 Leptothermofonsia sichuanensis 2917832 Bacteria Bacteria 604 4.0699999999999984e-168   NTclustered gi|2090366103|gb|CP072600.1| 2016068 g5473 i0 83.284 152.845808383234 676 94 100 18 1 668 3761 3097 Leptothermofonsia sichuanensis E412 chromosome, complete genome blastn 102101 604 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptothermofonsia Leptothermofonsia sichuanensis
6810638 6810638 PRJNA437204_P_NODE_5666_length_673_cov_1.636667_g5376_i0 PRJNA437204 5666 673 1.636667 11.01476891 Oscillatoria sp. PCC 1 1159 Bacteria Bacteria 305 1.47e-98   NR WP_017721107.1 1173028 g5376 i0 67 14.777117384844 221 73 98.5 0 2 664 266 486 WP_017721107.1 aldehyde dehydrogenase family protein [Oscillatoria sp. PCC 10802] diamond 9945 305 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Oscillatoria Oscillatoria sp. PCC 10802
9360026 9360026 PRJNA437204_P_NODE_125388_length_241_cov_0.916667_g125089_i0 PRJNA437204 125388 241 0.916667 2.20916747 Nostoc sp. CENA543 1869241 Bacteria Bacteria 52.8 0.022   NTclustered gi|1334417636|gb|CP023278.1| 1869241 g125089 i0 100 0.116182572614108 28 0 12 0 184 211 1944295 1944322 Nostoc sp. CENA543 chromosome, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CENA543
9360153 9360153 PRJNA437204_P_NODE_14348_length_467_cov_1.362944_g14049_i0 PRJNA437204 14348 467 1.362944 6.36494848 uncultured Chroococcidiopsis sp. 259957 Bacteria Bacteria 773 0   NTclustered gi|225696188|gb|FJ805855.1| 259957 g14049 i0 96.567 115.674518201285 466 16 99 0 2 467 2632 2167 Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 54020 773 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis uncultured Chroococcidiopsis sp.
10636131 10636131 PRJNA437204_P_NODE_23629_length_387_cov_1.474522_g23330_i0 PRJNA437204 23629 387 1.474522 5.70640014 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 174 2.26e-49   NR WP_046278332.1 1118279 g23330 i0 63.6 10 129 47 100 0 387 1 255 383 WP_046278332.1 aldehyde dehydrogenase family protein [Limnoraphis robusta] diamond 3870 175 0.994285714285714 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnoraphis Limnoraphis robusta
26727310 26727310 PRJNA437204_P_NODE_88841_length_249_cov_0.875000_g88542_i0 PRJNA437204 88841 249 0.875 2.17875 Cyanobacteria bacterium J06638_38 3023211 Bacteria Bacteria 47 0.00124   NR MEO1006360.1 3023211 g88542 i0 59.5 0.44578313253012 37 15 44.6 0 242 132 378 414 MEO1006360.1 reverse transcriptase family protein [Cyanobacteria bacterium J06638_38] diamond 111 47 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06638_38
26791171 26791171 PRJNA437204_P_NODE_99881_length_247_cov_0.885057_g99582_i0 PRJNA437204 99881 247 0.885057 2.18609079 Cyanobacteria bacterium J06638_38 3023211 Bacteria Bacteria 50.4 7.39e-5   NR MEO1006360.1 3023211 g99582 i0 60 0.425101214574899 35 14 42.5 0 112 8 365 399 MEO1006360.1 reverse transcriptase family protein [Cyanobacteria bacterium J06638_38] diamond 105 50.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06638_38
27328866 27328866 PRJNA437204_P_NODE_109563_length_245_cov_0.895349_g109264_i0 PRJNA437204 109563 245 0.895349 2.19360505 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 88.2 3.76e-18   NR HEY9684700.1 3088181 g109264 i0 52.5 0.979591836734694 80 38 98 0 241 2 338 417 HEY9684700.1 hypothetical protein [Oculatellaceae cyanobacterium] diamond 240 88.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
27392076 27392076 PRJNA437204_P_NODE_102803_length_246_cov_0.890173_g102504_i0 PRJNA437204 102803 246 0.890173 2.18982558 Synechococcus elongatus 32046 Bacteria Bacteria 68.9 1.93e-11   NR WP_011243371.1 32046 g102504 i0 66 0.573170731707317 47 16 57.3 0 3 143 323 369 WP_011243371.1 S-(hydroxymethyl)glutathione dehydrogenase/class III alcohol dehydrogenase [Synechococcus elongatus] diamond 141 68.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus elongatus
27471608 27471608 PRJNA437204_P_NODE_105003_length_246_cov_0.890173_g104704_i0 PRJNA437204 105003 246 0.890173 2.18982558 Rippkaea 2546365 Bacteria Bacteria 79 3.9e-15   NR HAG81485.1 2055765 g104704 i0 53.5 5.34146341463415 71 31 86.6 1 6 218 110 178 HAG81485.1 glucokinase [Cyanobacteria bacterium UBA12227] diamond 1314 79.3 0.996216897856242 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA12227
27549697 27549697 PRJNA437204_P_NODE_11744_length_504_cov_2.916473_g11446_i0 PRJNA437204 11744 504 2.916473 14.69902392 Altericista sp. CCNU 3082949 Bacteria Bacteria 200 2.29e-62   NR WP_404787694.1 3082949 g11446 i0 77.9 3.66666666666667 122 27 72.6 0 1 366 55 176 WP_404787694.1 peroxiredoxin [Altericista sp. CCNU0014] diamond 1848 200 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales   Altericista Altericista sp. CCNU0014
27549701 27549701 PRJNA437204_P_NODE_123944_length_242_cov_0.911243_g123645_i0 PRJNA437204 123944 242 0.911243 2.20520806 Myxacorys almedinensis 2651157 Bacteria Bacteria 90.5 5.68e-19   NR WP_162421569.1 2651157 g123645 i0 53.2 2.92561983471074 77 36 95.5 0 9 239 620 696 WP_162421569.1 selenide, water dikinase SelD [Myxacorys almedinensis] diamond 708 90.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Myxacorys Myxacorys almedinensis
27644790 27644790 PRJNA437204_P_NODE_51764_length_297_cov_1.026786_g51465_i0 PRJNA437204 51764 297 1.026786 3.04955442 Moorena sp. SIOASIH 2607817 Bacteria Bacteria 108 1.43e-25   NR WP_293097278.1 2607817 g51465 i0 49 0.98989898989899 98 50 99 0 295 2 34 131 WP_293097278.1 2-deoxy-scyllo-inosose synthase [Moorena sp. SIOASIH] diamond 294 108 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Moorena Moorena sp. SIOASIH
27865415 27865415 PRJNA437204_P_NODE_44965_length_312_cov_1.209205_g44666_i0 PRJNA437204 44965 312 1.209205 3.7727196 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 135 9.75e-36   NR MEB3307387.1 2847862 g44666 i0 81.1 1.44230769230769 74 14 71.2 0 91 312 4 77 MEB3307387.1 glutathione S-transferase family protein [Cyanobacteriota bacterium] diamond 450 135 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
28054909 28054909 PRJNA437204_P_NODE_45985_length_309_cov_1.957627_g45686_i0 PRJNA437204 45985 309 1.957627 6.04906743 Dolichospermum sp. 2720786 Bacteria Bacteria 90.5 1.5e-19   NR MFN7661193.1 2720786 g45686 i0 46.5 5.61165048543689 86 45 82.5 1 308 54 33 118 MFN7661193.1 hypothetical protein [Dolichospermum sp.] diamond 1734 90.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Dolichospermum Dolichospermum sp.
28339204 28339204 PRJNA437204_P_NODE_24986_length_380_cov_1.208469_g24687_i0 PRJNA437204 24986 380 1.208469 4.5921822 Microcoleaceae cyanobacterium MO_207.B10 3036644 Bacteria Bacteria 75.9 4.5e-13   NR MDJ0554958.1 3036644 g24687 i0 44.3 0.907894736842105 115 57 90 4 379 38 73 181 MDJ0554958.1 ExeM/NucH family extracellular endonuclease [Microcoleaceae cyanobacterium MO_207.B10] diamond 345 75.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae   Microcoleaceae cyanobacterium MO_207.B10
29633288 29633288 PRJNA437204_P_NODE_112610_length_244_cov_0.900585_g112311_i0 PRJNA437204 112610 244 0.900585 2.1974274 Cyanothece sp. UBA12306 2055757 Bacteria Bacteria 43.5 0.0195   NR HAC64509.1 2055757 g112311 i0 38.9 0.663934426229508 54 32 65.2 1 18 176 40 93 HAC64509.1 asparagine synthase [Cyanothece sp. UBA12306] diamond 162 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Cyanothecaceae Cyanothece Cyanothece sp. UBA12306
30549733 30549733 PRJNA437204_P_NODE_35533_length_337_cov_1.329545_g35234_i0 PRJNA437204 35533 337 1.329545 4.48056665 Oscillatoriaceae cyanobacterium 2664179 Bacteria Bacteria 54.3 9.86e-6   NR HEY9722280.1 2664179 g35234 i0 44.8 0.516320474777448 58 29 49 1 324 160 640 697 HEY9722280.1 plasma-membrane proton-efflux P-type ATPase [Oscillatoriaceae cyanobacterium] diamond 174 54.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae   Oscillatoriaceae cyanobacterium
30597635 30597635 PRJNA437204_P_NODE_128513_length_241_cov_0.916667_g128214_i0 PRJNA437204 128513 241 0.916667 2.20916747 Cyanophyceae 3028117 Bacteria Bacteria 124 3.91e-34   NR NEQ95720.1 2607797 g128214 i0 71.3 15.9336099585062 80 23 99.6 0 240 1 33 112 NEQ95720.1 nucleoside-diphosphate kinase [Cyanothece sp. SIO2G6] diamond 3840 125 0.992 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Cyanothecaceae Cyanothece Cyanothece sp. SIO2G6
30771151 30771151 PRJNA437204_P_NODE_119714_length_243_cov_0.882353_g119415_i0 PRJNA437204 119714 243 0.882353 2.14411779 Cyanobacteria bacterium J06638_38 3023211 Bacteria Bacteria 61.2 1.08e-8   NR MEO1006360.1 3023211 g119415 i0 66.7 0.975308641975309 39 13 48.1 0 124 8 361 399 MEO1006360.1 reverse transcriptase family protein [Cyanobacteria bacterium J06638_38] diamond 237 61.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06638_38
31071887 31071887 PRJNA437204_P_NODE_82395_length_251_cov_0.865169_g82096_i0 PRJNA437204 82395 251 0.865169 2.17157419 root 1 Root_unresolved Root_unresolved 59.7 4.33e-8   NR WP_051077749.1 47251 g82096 i0 50.8 7.36254980079681 59 27 68.1 2 10 180 572 630 WP_051077749.1 MULTISPECIES: serine/threonine-protein kinase [Leptolyngbya] diamond 1848 60.1 0.993344425956739 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya  
31118277 31118277 PRJNA437204_P_NODE_18875_length_421_cov_0.885057_g18576_i0 PRJNA437204 18875 421 0.885057 3.72608997 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 94.7 2.17e-21   NR MEB3302540.1 2847862 g18576 i0 58.3 3.64845605700713 84 31 59.9 2 418 167 94 173 MEB3302540.1 peptidylprolyl isomerase [Cyanobacteriota bacterium] diamond 1536 94.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
31244903 31244903 PRJNA437204_P_NODE_38135_length_329_cov_1.804688_g37836_i0 PRJNA437204 38135 329 1.804688 5.93742352 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 73.6 1.52e-12   NR HEY9681958.1 3088181 g37836 i0 44.6 0.756838905775076 83 46 75.7 0 14 262 484 566 HEY9681958.1 hypothetical protein [Oculatellaceae cyanobacterium] diamond 249 73.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
32067261 32067261 PRJNA437204_P_NODE_1158_length_1228_cov_8.689177_g1009_i0 PRJNA437204 1158 1228 8.689177 106.70309356 Planktothrix mougeotii 54306 Bacteria Bacteria 76.3 9.11e-11   NR WP_193869806.1 54306 g1009 i0 48.8 0.195439739413681 80 37 19.3 2 382 618 643 719 WP_193869806.1 Vps62-related protein [Planktothrix mougeotii] diamond 240 76.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix mougeotii
32762499 32762499 PRJNA437204_P_NODE_4640_length_728_cov_1.131298_g4363_i0 PRJNA437204 4640 728 1.131298 8.23584944 Planktothrix mougeotii 54306 Bacteria Bacteria 66.6 1.52e-8   NR WP_193869806.1 54306 g4363 i0 47.9 0.576923076923077 73 34 29.7 2 4 219 646 715 WP_193869806.1 Vps62-related protein [Planktothrix mougeotii] diamond 420 66.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix mougeotii

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