RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where bioproject = "PRJNA270367", 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 · 27 ✖

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 27 ✖

bioproject 1

  • PRJNA270367 · 27 ✖
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
6160849 6160849 PRJNA270367_P_NODE_29665_length_205_cov_1.333333_g29460_i0 PRJNA270367 29665 205 1.333333 2.73333265 Leptolyngbyaceae cyanobacterium 3088178 Bacteria Bacteria 90.5 2.91e-19   NR HEY9877209.1 3088178 g29460 i0 64.7 24.6439024390244 68 21 99.5 1 204 1 212 276 HEY9877209.1 ammonium transporter [Leptolyngbyaceae cyanobacterium] diamond 5052 90.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium
15085191 15085191 PRJNA270367_P_NODE_13792_length_349_cov_3.363333_g13587_i0 PRJNA270367 13792 349 3.363333 11.73803217 Cyanophyceae 3028117 Bacteria Bacteria 156 1.8e-45   NR WP_017304681.1 54311 g13587 i0 76.9 22.6848137535817 91 21 78.2 0 1 273 121 211 WP_017304681.1 peroxiredoxin [Spirulina subsalsa] diamond 7917 156 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Spirulinales Spirulinaceae Spirulina Spirulina subsalsa
16947588 16947588 PRJNA270367_P_NODE_5694_length_572_cov_3.502868_g5502_i0 PRJNA270367 5694 572 3.502868 20.03640496 Leptolyngbya sp. FACHB-261 2692806 Bacteria Bacteria 225 2.01e-72   NR WP_190801501.1 2692806 g5502 i0 67.8 1.57342657342657 149 48 78.1 0 28 474 1 149 WP_190801501.1 nucleoside-diphosphate kinase [Leptolyngbya sp. FACHB-261] diamond 900 225 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. FACHB-261
18221870 18221870 PRJNA270367_P_NODE_44715_length_164_cov_0.904348_g44510_i0 PRJNA270367 44715 164 0.904348 1.48313072 Dolichospermum sp. DL01 2717871 Bacteria Bacteria 52.8 0.014   NTclustered gi|2004368895|gb|CP050884.1| 2717871 g44510 i0 100 0.170731707317073 28 0 17 0 77 104 641367 641394 MAG: Dolichospermum sp. DL01 chromosome, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Dolichospermum Dolichospermum sp. DL01
18909887 18909887 PRJNA270367_P_NODE_7495_length_493_cov_5.941441_g7297_i0 PRJNA270367 7495 493 5.941441 29.29130413 Cyanophyceae 3028117 Bacteria Bacteria 224 1.4799999999999998e-72   NR WP_166278818.1 207921 g7297 i0 71.6 14.421906693712 148 42 90.1 0 472 29 2 149 WP_166278818.1 nucleoside-diphosphate kinase [Lyngbya confervoides] diamond 7110 226 0.991150442477876 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Lyngbya Lyngbya confervoides
22046578 22046578 PRJNA270367_P_NODE_30178_length_203_cov_1.012987_g29973_i0 PRJNA270367 30178 203 1.012987 2.05636361 Synechococcus sp. A15-28 1050638 Bacteria Bacteria 60.2 1.06e-4   NTclustered gi|1895742380|gb|CP047931.1| 1050638 g29973 i0 97.143 0.172413793103448 35 1 17 0 110 144 1646324 1646358 Synechococcus sp. A15-28 chromosome, complete genome blastn 35 60.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. A15-28
27154561 27154561 PRJNA270367_P_NODE_16122_length_314_cov_1.569811_g15917_i0 PRJNA270367 16122 314 1.569811 4.92920654 Bacteria 2 Bacteria Bacteria 48.1 0.00115   NR BAU12161.1 1752064 g15917 i0 31.5 2.78025477707006 89 50 74.5 1 237 4 908 996 BAU12161.1 hypothetical protein LEP3755_26900 [Leptolyngbya sp. NIES-3755] diamond 873 48.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. NIES-3755
27706236 27706236 PRJNA270367_P_NODE_14224_length_342_cov_0.887372_g14019_i0 PRJNA270367 14224 342 0.887372 3.03481224 Nostoc sp. 1 1052551 Bacteria Bacteria 48.5 0.00102   NR WP_086757060.1 1932667 g14019 i0 43.3 1.29824561403509 60 33 52.6 1 200 21 251 309 WP_086757060.1 tetratricopeptide repeat protein, partial [Nostoc sp. 106C] diamond 444 48.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. 106C
27912815 27912815 PRJNA270367_P_NODE_28825_length_209_cov_1.206250_g28620_i0 PRJNA270367 28825 209 1.20625 2.5210625 Bacteria 2 Bacteria Bacteria 142 2.09e-37   NR TRU80153.1 2486268 g28620 i0 98.6 2.97129186602871 69 1 99 0 2 208 494 562 TRU80153.1 MAG: TonB-dependent receptor [Microcystis viridis Mv_BB_P_19951000_S69D] diamond 621 142 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis viridis
28039409 28039409 PRJNA270367_P_NODE_45465_length_163_cov_0.912281_g45260_i0 PRJNA270367 45465 163 0.912281 1.48701803 Bacteria 2 Bacteria Bacteria 80.9 3.54e-16   NR MBU6451446.1 2800110 g45260 i0 66 1.93251533742331 53 18 97.5 0 3 161 105 157 MBU6451446.1 cytochrome-c peroxidase [Cyanobacteria bacterium REEB67] diamond 315 81.6 0.991421568627451 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium REEB67
28116215 28116215 PRJNA270367_P_NODE_33785_length_188_cov_1.489209_g33580_i0 PRJNA270367 33785 188 1.489209 2.79971292 Gloeobacterales cyanobacterium ES-bin-313 2812629 Bacteria Bacteria 68.6 1.39e-11   NR MBC7882842.1 2812629 g33580 i0 58.1 1.97872340425532 62 25 98.9 1 2 187 134 194 MBC7882842.1 ammonium transporter [Gloeobacterales cyanobacterium ES-bin-313] diamond 372 68.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gloeobacterales     Gloeobacterales cyanobacterium ES-bin-313
28242443 28242443 PRJNA270367_P_NODE_34946_length_184_cov_1.155556_g34741_i0 PRJNA270367 34946 184 1.155556 2.12622304 Geitlerinema sp. PCC 9228 111611 Bacteria Bacteria 41.6 0.0416   NR WP_071518833.1 111611 g34741 i0 43.6 0.635869565217391 39 22 63.6 0 51 167 54 92 WP_071518833.1 gamma-carotene 1'-hydroxylase CruF [Geitlerinema sp. PCC 9228] diamond 117 41.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Geitlerinematales Geitlerinemataceae Geitlerinema Geitlerinema sp. PCC 9228
28274070 28274070 PRJNA270367_P_NODE_37226_length_176_cov_1.188976_g37021_i0 PRJNA270367 37226 176 1.188976 2.09259776 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 50.1 1.77e-5   NR MBA4078250.1 2067979 g37021 i0 90.9 0.375 22 2 37.5 0 176 111 148 169 MBA4078250.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 66 50.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
28495369 28495369 PRJNA270367_P_NODE_7967_length_477_cov_2.700935_g7769_i0 PRJNA270367 7967 477 2.700935 12.88345995 Oscillatoriales cyanobacterium RM2_1_1 2720435 Bacteria Bacteria 48.9 0.00295   NR NJO46494.1 2720435 g7769 i0 34.4 0.566037735849057 90 46 50.9 4 369 127 376 461 NJO46494.1 tandem-95 repeat protein [Oscillatoriales cyanobacterium RM2_1_1] diamond 270 48.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales     Oscillatoriales cyanobacterium RM2_1_1
29032210 29032210 PRJNA270367_P_NODE_5968_length_558_cov_41.371316_g5775_i0 PRJNA270367 5968 558 41.371316 230.85194328 Nostoc sp. UIC 1 1180 Bacteria Bacteria 97.4 5.85e-22   NR WP_163931015.1 2100146 g5775 i0 32.3 1.72043010752688 158 104 84.4 2 541 71 5 160 WP_163931015.1 TerB family tellurite resistance protein [Nostoc sp. UIC 10630] diamond 960 97.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. UIC 10630
29221606 29221606 PRJNA270367_P_NODE_28629_length_210_cov_1.291925_g28424_i0 PRJNA270367 28629 210 1.291925 2.7130425 Tildeniella nuda 2303521 Bacteria Bacteria 65.1 7.92e-11   NR MBW4582717.1 2136405 g28424 i0 61.8 1.75714285714286 55 20 78.6 1 167 3 112 165 MBW4582717.1 glutathione S-transferase family protein [Tildeniella nuda ZEHNDER 1965/U140] diamond 369 65.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae Tildeniella Tildeniella nuda
29252723 29252723 PRJNA270367_P_NODE_30629_length_201_cov_1.039474_g30424_i0 PRJNA270367 30629 201 1.039474 2.08934274 Phormidium willei BDU 13 399100 Bacteria Bacteria 43.1 0.016   NR OAB60180.1 399101 g30424 i0 40.3 1.80597014925373 62 35 89.6 2 193 14 3609 3670 OAB60180.1 hypothetical protein AY600_11355 [Phormidium willei BDU 130791] diamond 363 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Phormidium Phormidium willei
29379296 29379296 PRJNA270367_P_NODE_37269_length_176_cov_0.834646_g37064_i0 PRJNA270367 37269 176 0.834646 1.46897696 Cyanobacteria bacterium P01_H01_bin.58 3023321 Bacteria Bacteria 70.5 2.49e-12   NR MEM0979335.1 3023321 g37064 i0 54.5 5.60795454545455 55 25 93.8 0 12 176 250 304 MEM0979335.1 colicin uptake protein [Cyanobacteria bacterium P01_H01_bin.58] diamond 987 70.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_H01_bin.58
30042425 30042425 PRJNA270367_P_NODE_44131_length_164_cov_1.373913_g43926_i0 PRJNA270367 44131 164 1.373913 2.25321732 Cyanobacterium stanieri PCC 72 102235 Bacteria Bacteria 42 0.0241   NR AFZ48470.1 292563 g43926 i0 42.1 0.695121951219512 38 22 69.5 0 12 125 252 289 AFZ48470.1 serine/threonine protein kinase [Cyanobacterium stanieri PCC 7202] diamond 114 42 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Cyanobacterium Cyanobacterium stanieri
30200216 30200216 PRJNA270367_P_NODE_39492_length_169_cov_0.866667_g39287_i0 PRJNA270367 39492 169 0.866667 1.46466723 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 49.3 6.69e-5   NR HEY9759356.1 3088181 g39287 i0 56.8 1.45562130177515 44 19 78.1 0 168 37 55 98 HEY9759356.1 hypothetical protein [Oculatellaceae cyanobacterium] diamond 246 49.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
30358901 30358901 PRJNA270367_P_NODE_30392_length_202_cov_1.156863_g30187_i0 PRJNA270367 30392 202 1.156863 2.33686326 Nostoc sp. EkiNYC01 3075407 Bacteria Bacteria 60.8 5.26e-9   NR MFN6536685.1 3075407 g30187 i0 48.5 1.9009900990099 66 34 98 0 4 201 123 188 MFN6536685.1 hypothetical protein [Nostoc sp. EkiNYC01] diamond 384 60.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. EkiNYC01
30674252 30674252 PRJNA270367_P_NODE_37833_length_174_cov_1.008000_g37628_i0 PRJNA270367 37833 174 1.008 1.75392 Limnospira platensis 118562 Bacteria Bacteria 91.3 5.14e-22   NR MDV7395947.1 3080829 g37628 i0 81.3 0.827586206896552 48 9 82.8 0 173 30 59 106 MDV7395947.1 citrate/2-methylcitrate synthase [Arthrospira platensis SPKY1] diamond 144 91.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira Limnospira platensis
31464747 31464747 PRJNA270367_P_NODE_39936_length_169_cov_0.866667_g39731_i0 PRJNA270367 39936 169 0.866667 1.46466723 Anthocerotibacter panamensis 2857077 Bacteria Bacteria 47.4 3.28e-4   NR WP_218080279.1 2857077 g39731 i0 51.1 0.798816568047337 45 22 79.9 0 136 2 413 457 WP_218080279.1 non-ribosomal peptide synthetase [Anthocerotibacter panamensis] diamond 135 47.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gloeobacterales Anthocerotibacteraceae Anthocerotibacter Anthocerotibacter panamensis
31735137 31735137 PRJNA270367_P_NODE_46297_length_162_cov_0.920354_g46092_i0 PRJNA270367 46297 162 0.920354 1.49097348 Bacteria 2 Bacteria Bacteria 63.9 2.77e-10   NR MBU6455161.1 2800110 g46092 i0 87.5 2.35185185185185 32 4 59.3 0 67 162 1 32 MBU6455161.1 acetoacetate decarboxylase [Cyanobacteria bacterium REEB67] diamond 381 63.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium REEB67
31780660 31780660 PRJNA270367_P_NODE_20277_length_267_cov_1.000000_g20072_i0 PRJNA270367 20277 267 1 2.67 Nostoc sp. 1180 Bacteria Bacteria 60.8 1.34e-8   NR WP_335201451.1 1180 g20072 i0 66.7 0.471910112359551 42 14 47.2 0 6 131 1 42 WP_335201451.1 WD40 repeat domain-containing protein, partial [Nostoc sp.] diamond 126 60.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp.
32540417 32540417 PRJNA270367_P_NODE_5119_length_604_cov_1.893694_g4928_i0 PRJNA270367 5119 604 1.893694 11.43791176 Calothrix sp. MO_167.B42 3036782 Bacteria Bacteria 50.1 7.92e-4   NR MDJ0677868.1 3036782 g4928 i0 28.3 0.526490066225166 106 61 49.2 3 602 306 7 104 MDJ0677868.1 glycosyltransferase [Calothrix sp. MO_167.B42] diamond 318 50.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. MO_167.B42
32666156 32666156 PRJNA270367_P_NODE_21000_length_260_cov_1.407583_g20795_i0 PRJNA270367 21000 260 1.407583 3.6597158 Microcystis sp. LE19-84.1B 3016438 Bacteria Bacteria 65.1 4.87e-10   NR WP_288141249.1 3016438 g20795 i0 44.6 3.45 74 41 85.4 0 6 227 247 320 WP_288141249.1 hypothetical protein [Microcystis sp. LE19-84.1B] diamond 897 65.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis sp. LE19-84.1B

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