RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA1010662" 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 · 24 ✖

bioproject 1

  • PRJNA1010662 · 24 ✖

analysis 1

  • diamond · 24 ✖
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
5257831 5257831 PRJNA1010662_P_NODE_5085_length_238_cov_1.354497_g5026_i0 PRJNA1010662 5085 238 1.354497 3.22370286 Annamia dubia NIES-4383 2759045 Bacteria Bacteria 117 1.39e-28   NR BDG64460.1 2759045 g5026 i0 70.4 7.1218487394958 81 22 99.6 1 237 1 536 616 BDG64460.1 hypothetical protein Anndu_18350 [Annamia dubia NIES-4383] diamond 1695 117 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Annamia Annamia dubia
6533097 6533097 PRJNA1010662_P_NODE_3846_length_267_cov_1.655963_g3787_i0 PRJNA1010662 3846 267 1.655963 4.42142121 Alkalinema sp. FACHB-956 2692768 Bacteria Bacteria 119 3.57e-30   NR WP_190577143.1 2692768 g3787 i0 63.5 8.53932584269663 85 31 95.5 0 267 13 271 355 WP_190577143.1 alkene reductase [Alkalinema sp. FACHB-956] diamond 2280 119 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Alkalinema Alkalinema sp. FACHB-956
23107168 23107168 PRJNA1010662_P_NODE_15019_length_165_cov_0.870690_g14960_i0 PRJNA1010662 15019 165 0.87069 1.4366385 Candidatus Melainabacteria bacterium GWF2_37_15 1801606 Bacteria Bacteria 82.8 2.4e-18   NR OGI04911.1 1801606 g14960 i0 59.3 2.92727272727273 54 22 98.2 0 2 163 68 121 OGI04911.1 MAG: tRNA-specific adenosine deaminase [Candidatus Melainabacteria bacterium GWF2_37_15] diamond 483 82.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium GWF2_37_15
26844884 26844884 PRJNA1010662_P_NODE_16221_length_163_cov_0.894737_g16162_i0 PRJNA1010662 16221 163 0.894737 1.45842131 Coleofasciculaceae cyanobacterium 3081323 Bacteria Bacteria 65.1 1.66e-10   NR HEY9739203.1 3081323 g16162 i0 60.8 3.73619631901841 51 20 93.9 0 154 2 427 477 HEY9739203.1 protein kinase [Coleofasciculaceae cyanobacterium] diamond 609 65.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae   Coleofasciculaceae cyanobacterium
27121528 27121528 PRJNA1010662_P_NODE_8522_length_196_cov_1.047619_g8463_i0 PRJNA1010662 8522 196 1.047619 2.05333324 Okeania 1458928 Bacteria Bacteria 60.1 3.51e-9   NR WP_287286674.1 2607782 g8463 i0 47.3 2.49489795918367 55 29 84.2 0 165 1 2 56 WP_287286674.1 cupin domain-containing protein [Okeania sp. SIO2B9] diamond 489 60.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Okeania Okeania sp. SIO2B9
27160653 27160653 PRJNA1010662_P_NODE_11402_length_175_cov_1.523810_g11343_i0 PRJNA1010662 11402 175 1.52381 2.6666675 unclassified Leptolyngbya 2650499 Bacteria Bacteria 98.2 4.46e-22   NR WP_190770423.1 2650499 g11343 i0 84.5 0.994285714285714 58 9 99.4 0 1 174 1102 1159 WP_190770423.1 MULTISPECIES: PAS domain S-box protein [unclassified Leptolyngbya] diamond 174 98.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya  
27192409 27192409 PRJNA1010662_P_NODE_14882_length_165_cov_0.887931_g14823_i0 PRJNA1010662 14882 165 0.887931 1.46508615 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 42 0.0244   NR HEY9813596.1 2762020 g14823 i0 40 0.818181818181818 45 27 81.8 0 161 27 388 432 HEY9813596.1 amino acid adenylation domain-containing protein [Candidatus Sericytochromatia bacterium] diamond 135 42 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
27255740 27255740 PRJNA1010662_P_NODE_9683_length_187_cov_1.065217_g9624_i0 PRJNA1010662 9683 187 1.065217 1.99195579 Cyanobacteria bacterium P01_C01_bin.147 3023260 Bacteria Bacteria 41.2 0.0413   NR MEM6715647.1 3023260 g9624 i0 41.4 0.93048128342246 58 29 86.6 2 11 172 35 91 MEM6715647.1 pentapeptide repeat-containing protein [Cyanobacteria bacterium P01_C01_bin.147] diamond 174 41.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_C01_bin.147
27508674 27508674 PRJNA1010662_P_NODE_13283_length_167_cov_1.737288_g13224_i0 PRJNA1010662 13283 167 1.737288 2.90127096 Oculatella sp. LEGE 3100279 Bacteria Bacteria 43.9 0.0053   NR WP_193877314.1 1828648 g13224 i0 43.6 0.988023952095808 55 31 98.8 0 167 3 1281 1335 WP_193877314.1 non-ribosomal peptide synthetase [Oculatella sp. LEGE 06141] diamond 165 43.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae Oculatella Oculatella sp. LEGE 06141
27508677 27508677 PRJNA1010662_P_NODE_14583_length_165_cov_1.327586_g14524_i0 PRJNA1010662 14583 165 1.327586 2.1905169 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 54.7 8.04e-7   NR HEY9759944.1 3088181 g14524 i0 52.8 1.94545454545455 53 25 96.4 0 4 162 376 428 HEY9759944.1 S9 family peptidase [Oculatellaceae cyanobacterium] diamond 321 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
27761422 27761422 PRJNA1010662_S_NODE_5524_length_150_cov_1.345794_g5479_i0 PRJNA1010662 5524 150 1.345794 2.018691 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 90.5 1.42e-19   NR HIA54341.1 2052166 g5479 i0 79.6 10.66 49 10 98 0 2 148 353 401 HIA54341.1 ATP-binding protein [Candidatus Melainabacteria bacterium] diamond 1599 90.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
28392564 28392564 PRJNA1010662_P_NODE_14146_length_166_cov_0.888889_g14087_i0 PRJNA1010662 14146 166 0.888889 1.47555574 Cyanobacteria bacterium P01_G01_bin.38 3023303 Bacteria Bacteria 55.8 2.96e-8   NR MEM8805331.1 3023303 g14087 i0 54.7 6.72289156626506 53 18 95.8 2 4 162 51 97 MEM8805331.1 glutathione S-transferase N-terminal domain-containing protein [Cyanobacteria bacterium P01_G01_bin.38] diamond 1116 55.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_G01_bin.38
28550683 28550683 PRJNA1010662_P_NODE_8967_length_192_cov_1.244755_g8908_i0 PRJNA1010662 8967 192 1.244755 2.3899296 Candidatus Margulisiibacteriota bacterium 2053573 Bacteria Bacteria 93.6 2.32e-20   NR MFA5878985.1 2053573 g8908 i0 74.6 2.953125 63 16 98.4 0 2 190 763 825 MFA5878985.1 pyruvate, phosphate dikinase [Candidatus Margulisiibacteriota bacterium] diamond 567 93.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Margulisiibacteriota         Candidatus Margulisiibacteriota bacterium
28771420 28771420 PRJNA1010662_P_NODE_13407_length_167_cov_1.067797_g13348_i0 PRJNA1010662 13407 167 1.067797 1.78322099 Trichodesmium sp. MAG_R01 2917417 Bacteria Bacteria 42 0.0253   NR MCL2927900.1 2917417 g13348 i0 45.7 0.826347305389222 46 24 80.8 1 11 145 350 395 MCL2927900.1 Cys-every-fifth RiPP peptide CefA [Trichodesmium sp. MAG_R01] diamond 138 42 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Trichodesmium Trichodesmium sp. MAG_R01
28858584 28858584 PRJNA1010662_P_NODE_15408_length_164_cov_0.904348_g15349_i0 PRJNA1010662 15408 164 0.904348 1.48313072 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 44.3 0.00368   NR WP_017291471.1 47251 g15349 i0 43.9 3.89634146341463 57 29 98.8 1 1 162 589 645 WP_017291471.1 MULTISPECIES: ATP-binding protein [Leptolyngbya] diamond 639 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya  
29308151 29308151 PRJNA1010662_P_NODE_5349_length_233_cov_2.994565_g5290_i0 PRJNA1010662 5349 233 2.994565 6.97733645 Hormoscilla sp. GM7CHS1pb 2653677 Bacteria Bacteria 94 3.06e-20   NR MBC6481119.1 2653677 g5290 i0 58.4 0.991416309012876 77 30 99.1 1 232 2 482 556 MBC6481119.1 putative Ig domain-containing protein [Hormoscilla sp. GM7CHS1pb] diamond 231 94 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Gomontiellaceae Hormoscilla Hormoscilla sp. GM7CHS1pb
29718425 29718425 PRJNA1010662_P_NODE_11690_length_173_cov_1.669355_g11631_i0 PRJNA1010662 11690 173 1.669355 2.88798415 [Phormidium] sp. LEGE 767427 Bacteria Bacteria 65.5 1.38e-10   NR WP_228061793.1 767427 g11631 i0 57.9 0.988439306358382 57 18 98.8 2 173 3 86 136 WP_228061793.1 colicin uptake protein [[Phormidium] sp. LEGE 05292] diamond 171 65.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Aerosakkonematales Aerosakkonemataceae Floridanema [Phormidium] sp. LEGE 05292
30121663 30121663 PRJNA1010662_P_NODE_4892_length_241_cov_2.348958_g4833_i0 PRJNA1010662 4892 241 2.348958 5.66098878 Cyanophyceae 3028117 Bacteria Bacteria 89.7 3.98e-19   NR MDJ0658161.1 2729996 g4833 i0 58.5 2.95020746887967 82 32 99.6 2 1 240 215 296 MDJ0658161.1 FG-GAP-like repeat-containing protein [Crocosphaera sp.] diamond 711 90.5 0.991160220994475 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Crocosphaera Crocosphaera sp.
30571422 30571422 PRJNA1010662_P_NODE_5973_length_224_cov_0.977143_g5914_i0 PRJNA1010662 5973 224 0.977143 2.18880032 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 72 7.5e-13   NR MBA4075325.1 2067979 g5914 i0 70.2 6.16071428571429 47 14 62.9 0 211 71 49 95 MBA4075325.1 pirin family protein [Cyanobacteria bacterium PR.023] diamond 1380 72 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
30761332 30761332 PRJNA1010662_P_NODE_8654_length_194_cov_2.055172_g8595_i0 PRJNA1010662 8654 194 2.055172 3.98703368 Calothrix sp. HK- 1187 Bacteria Bacteria 54.7 1.16e-6   NR OKH54609.1 1137096 g8595 i0 47.6 2.92268041237113 63 26 95.9 2 193 8 110 166 OKH54609.1 hypothetical protein NIES2101_07325 [Calothrix sp. HK-06] diamond 567 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. HK-06
30887596 30887596 PRJNA1010662_P_NODE_11234_length_176_cov_1.582677_g11175_i0 PRJNA1010662 11234 176 1.582677 2.78551152 Gloeothece citriformis 2546356 Bacteria Bacteria 93.6 5.34e-21   NR WP_015957142.1 2546356 g11175 i0 71.9 6.80113636363636 57 16 97.2 0 174 4 37 93 WP_015957142.1 NADPH-dependent aldehyde reductase Ahr [Gloeothece citriformis] diamond 1197 93.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Gloeothece Gloeothece citriformis
31077343 31077343 PRJNA1010662_P_NODE_6475_length_217_cov_1.232143_g6416_i0 PRJNA1010662 6475 217 1.232143 2.67375031 candidate division WOR-1 bacterium DG_54_3 1703775 Bacteria Bacteria 43.9 0.0103   NR KPJ65960.1 1703775 g6416 i0 41.2 0.705069124423963 51 30 70.5 0 15 167 680 730 KPJ65960.1 MAG: hypothetical protein AMJ44_09185 [candidate division WOR-1 bacterium DG_54_3] diamond 153 43.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati           candidate division WOR-1 bacterium DG_54_3
31677922 31677922 PRJNA1010662_P_NODE_9917_length_185_cov_1.507353_g9858_i0 PRJNA1010662 9917 185 1.507353 2.78860305 Pseudanabaenaceae cyanobacterium 3078745 Bacteria Bacteria 58.9 1.24e-8   NR MFN3927180.1 3078745 g9858 i0 49.2 0.956756756756757 59 28 95.7 2 181 5 68 124 MFN3927180.1 VWA domain-containing protein [Pseudanabaenaceae cyanobacterium] diamond 177 58.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae   Pseudanabaenaceae cyanobacterium
32437604 32437604 PRJNA1010662_P_NODE_8799_length_193_cov_1.430556_g8740_i0 PRJNA1010662 8799 193 1.430556 2.76097308 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 115 7.719999999999999e-31   NR MBX9724270.1 2364082 g8740 i0 90.6 0.994818652849741 64 6 99.5 0 1 192 16 79 MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] diamond 192 115 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales 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);;