RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA312107 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
26916054 26916054 PRJNA312107_P_NODE_22702_length_165_cov_0.896552_g22536_i0 PRJNA312107 22702 165 0.896552 1.4793108 Cyanobacteria bacterium SZAS-4 2807733 Bacteria Bacteria 48.9 1.69e-5   NR MBS1956149.1 2807733 g22536 i0 75 0.509090909090909 28 7 50.9 0 86 3 26 53 MBS1956149.1 hypothetical protein [Cyanobacteria bacterium SZAS-4] diamond 84 48.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium SZAS-4
27137026 27137026 PRJNA312107_P_NODE_26302_length_162_cov_0.911504_g26136_i0 PRJNA312107 26302 162 0.911504 1.47663648 Chamaesiphon sp. OTE_75_metabat_556 2964692 Bacteria Bacteria 68.2 2.94e-12   NR WP_309732336.1 2964692 g26136 i0 94.3 0.648148148148148 35 2 64.8 0 105 1 1 35 WP_309732336.1 hypothetical protein [Chamaesiphon sp. OTE_75_metabat_556] diamond 105 68.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Chamaesiphonaceae Chamaesiphon Chamaesiphon sp. OTE_75_metabat_556
27674709 27674709 PRJNA312107_P_NODE_25164_length_163_cov_0.912281_g24998_i0 PRJNA312107 25164 163 0.912281 1.48701803 Planktothrix sp. 3088171 Bacteria Bacteria 52 5.16e-6   NR WP_408974114.1 3088171 g24998 i0 65.7 1.91411042944785 35 12 64.4 0 107 3 5 39 WP_408974114.1 NAD-dependent epimerase/dehydratase family protein, partial [Planktothrix sp.] diamond 312 52 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix sp.
28337579 28337579 PRJNA312107_P_NODE_23526_length_164_cov_0.904348_g23360_i0 PRJNA312107 23526 164 0.904348 1.48313072 Cyanobacteria bacterium SBC 2821503 Bacteria Bacteria 45.1 0.00196   NR MBP0006229.1 2821503 g23360 i0 61.8 0.621951219512195 34 13 62.2 0 163 62 98 131 MBP0006229.1 hypothetical protein [Cyanobacteria bacterium SBC] diamond 102 45.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium SBC
28481433 28481433 PRJNA312107_P_NODE_23906_length_164_cov_0.904348_g23740_i0 PRJNA312107 23906 164 0.904348 1.48313072 Nostoc 1177 Bacteria Bacteria 61.2 3.06e-9   NR WP_334709631.1 1180 g23740 i0 66.7 3.05487804878049 42 14 76.8 0 20 145 205 246 WP_334709631.1 XDD3 family exosortase-dependent surface protein [Nostoc sp.] diamond 501 61.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp.
29410958 29410958 PRJNA312107_P_NODE_18389_length_170_cov_0.950413_g18223_i0 PRJNA312107 18389 170 0.950413 1.6157021 Synechococcus sp. SB0668_bin_15 2604860 Bacteria Bacteria 41.6 0.0357   NR MXW39839.1 2604860 g18223 i0 41.5 0.935294117647059 53 25 82.9 1 15 155 294 346 MXW39839.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Synechococcus sp. SB0668_bin_15] diamond 159 41.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. SB0668_bin_15
29821269 29821269 PRJNA312107_P_NODE_17911_length_172_cov_1.495935_g17745_i0 PRJNA312107 17911 172 1.495935 2.5730082 Trichocoleus 450526 Bacteria Bacteria 72.4 4.63e-14   NR WP_190443484.1 450526 g17745 i0 53.6 1.95348837209302 56 26 97.7 0 4 171 54 109 WP_190443484.1 MULTISPECIES: DUF2199 domain-containing protein [Trichocoleus] diamond 336 72.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Trichocoleusaceae Trichocoleus  
30295844 30295844 PRJNA312107_P_NODE_21312_length_166_cov_1.726496_g21146_i0 PRJNA312107 21312 166 1.726496 2.86598336 Brunnivagina elsteri 1247191 Bacteria Bacteria 44.7 0.00269   NR WP_095720514.1 1247191 g21146 i0 55 1.51807228915663 40 18 72.3 0 27 146 263 302 WP_095720514.1 LamG domain-containing protein [Brunnivagina elsteri] diamond 252 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Brunnivagina Brunnivagina elsteri
30548146 30548146 PRJNA312107_P_NODE_19273_length_169_cov_0.866667_g19107_i0 PRJNA312107 19273 169 0.866667 1.46466723 Cyanobacteria bacterium UBA11049 2055787 Bacteria Bacteria 108 6.19e-26   NR HCF29829.1 2055787 g19107 i0 94.5 1.95266272189349 55 3 97.6 0 3 167 403 457 HCF29829.1 amidase [Cyanobacteria bacterium UBA11049] diamond 330 108 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11049
30692058 30692058 PRJNA312107_P_NODE_18813_length_169_cov_0.866667_g18647_i0 PRJNA312107 18813 169 0.866667 1.46466723 Chroococcales 1118 Bacteria Bacteria 107 5.22e-26   NR WP_002736029.1 1125 g18647 i0 85.7 7.95266272189349 56 8 99.4 0 168 1 346 401 WP_002736029.1 MULTISPECIES: DHH family phosphoesterase [Microcystis] diamond 1344 108 0.990740740740741 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis  
30769431 30769431 PRJNA312107_P_NODE_19214_length_169_cov_0.866667_g19048_i0 PRJNA312107 19214 169 0.866667 1.46466723 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 53.9 1.2e-6   NR MEY2857904.1 2847862 g19048 i0 50.9 1.88165680473373 53 26 94.1 0 167 9 101 153 MEY2857904.1 hypothetical protein [Cyanobacteriota bacterium] diamond 318 53.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
31370090 31370090 PRJNA312107_P_NODE_22776_length_165_cov_0.896552_g22610_i0 PRJNA312107 22776 165 0.896552 1.4793108 Altericista sp. CCNU 3082949 Bacteria Bacteria 95.5 7.37e-22   NR WP_404787685.1 3082949 g22610 i0 81.5 0.981818181818182 54 10 98.2 0 3 164 53 106 WP_404787685.1 carbohydrate kinase family protein [Altericista sp. CCNU0014] diamond 162 95.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales   Altericista Altericista sp. CCNU0014
31939075 31939075 PRJNA312107_P_NODE_18517_length_169_cov_1.408333_g18351_i0 PRJNA312107 18517 169 1.408333 2.38008277 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 62 2.08e-9   NR MFA6213499.1 2364082 g18351 i0 54.5 0.976331360946746 55 25 97.6 0 5 169 135 189 MFA6213499.1 DUF5309 family protein [Candidatus Obscuribacterales bacterium] diamond 165 62 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
32146664 32146664 PRJNA312107_P_NODE_20598_length_167_cov_0.881356_g20432_i0 PRJNA312107 20598 167 0.881356 1.47186452 Bacteria 2 Bacteria Bacteria 40.8 0.0499   NR MCA9818457.1 2775581 g20432 i0 51.3 1.59880239520958 39 18 70.1 1 152 36 50 87 MCA9818457.1 hypothetical protein [Cyanobacteria bacterium HKST-UBA01] diamond 267 41.2 0.990291262135922 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium HKST-UBA01
32287585 32287585 PRJNA312107_P_NODE_25419_length_162_cov_1.247788_g25253_i0 PRJNA312107 25419 162 1.247788 2.02141656 Rivularia sp. IAM M-261 448371 Bacteria Bacteria 43.5 0.00107   NR GJD20192.1 448371 g25253 i0 53.7 1.51851851851852 41 19 75.9 0 123 1 5 45 GJD20192.1 hypothetical protein RIVM261_051480 [Rivularia sp. IAM M-261] diamond 246 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Rivulariaceae Rivularia Rivularia sp. IAM M-261

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