RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1016321 · 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
11638602 11638602 PRJNA1016321_P_NODE_56270_length_241_cov_0.916667_g56039_i0 PRJNA1016321 56270 241 0.916667 2.20916747 Pleurocapsa 44474 Bacteria Bacteria 131 9.97e-34   NR WP_106241728.1 2107688 g56039 i0 83.5 10.804979253112 79 13 98.3 0 2 238 53 131 WP_106241728.1 ABC transporter ATP-binding protein [Pleurocapsa sp. CCALA 161] diamond 2604 132 0.992424242424242 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. CCALA 161
26749573 26749573 PRJNA1016321_P_NODE_33961_length_308_cov_2.953191_g33730_i0 PRJNA1016321 33961 308 2.953191 9.09582828 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 173 1.05e-51   NR MBN9395106.1 2052166 g33730 i0 96.7 0.886363636363636 91 3 88.6 0 28 300 1 91 MBN9395106.1 response regulator transcription factor [Candidatus Melainabacteria bacterium] diamond 273 173 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
26845244 26845244 PRJNA1016321_P_NODE_56761_length_237_cov_3.463415_g56530_i0 PRJNA1016321 56761 237 3.463415 8.20829355 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 124 9.33e-31   NR MBX9674316.1 2364082 g56530 i0 98.4 0.784810126582278 62 1 78.5 0 3 188 1010 1071 MBX9674316.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 186 124 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
26971465 26971465 PRJNA1016321_P_NODE_53742_length_244_cov_0.900585_g53511_i0 PRJNA1016321 53742 244 0.900585 2.1974274 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 164 2.48e-46   NR HEY9757364.1 3088181 g53511 i0 100 0.983606557377049 80 0 98.4 0 3 242 191 270 HEY9757364.1 PLP-dependent transferase [Oculatellaceae cyanobacterium] diamond 240 164 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
27256090 27256090 PRJNA1016321_P_NODE_44303_length_263_cov_1.621053_g44072_i0 PRJNA1016321 44303 263 1.621053 4.26336939 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 181 2.8599999999999996e-56   NR MBN9396101.1 2052166 g44072 i0 100 0.992395437262357 87 0 99.2 0 2 262 54 140 MBN9396101.1 hypothetical protein [Candidatus Melainabacteria bacterium] diamond 261 181 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
27666899 27666899 PRJNA1016321_P_NODE_52924_length_245_cov_0.895349_g52693_i0 PRJNA1016321 52924 245 0.895349 2.19360505 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 93.6 4.33e-20   NR MBX9672592.1 2364082 g52693 i0 97.9 0.575510204081633 47 1 57.6 0 162 22 179 225 MBX9672592.1 HAMP domain-containing histidine kinase [Candidatus Obscuribacterales bacterium] diamond 141 93.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
27761729 27761729 PRJNA1016321_P_NODE_56644_length_239_cov_2.783133_g56413_i0 PRJNA1016321 56644 239 2.783133 6.65168787 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 95.9 1.26e-23   NR WP_106367560.1 2107693 g56413 i0 86.5 0.652719665271967 52 7 65.3 0 157 2 1 52 WP_106367560.1 hypothetical protein [Chlorogloea sp. CCALA 695] diamond 156 95.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
28424633 28424633 PRJNA1016321_P_NODE_54206_length_243_cov_1.382353_g53975_i0 PRJNA1016321 54206 243 1.382353 3.35911779 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 104 6.240000000000001e-26   NR MBN9394593.1 2052166 g53975 i0 98.1 0.641975308641975 52 1 64.2 0 174 19 1 52 MBN9394593.1 GTP cyclohydrolase I FolE [Candidatus Melainabacteria bacterium] diamond 156 104 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
28740272 28740272 PRJNA1016321_P_NODE_52807_length_245_cov_0.895349_g52576_i0 PRJNA1016321 52807 245 0.895349 2.19360505 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 73.6 5.22e-13   NR HEY9791152.1 2364082 g52576 i0 53.2 0.759183673469388 62 29 75.9 0 226 41 331 392 HEY9791152.1 DDE-type integrase/transposase/recombinase [Candidatus Obscuribacterales bacterium] diamond 186 73.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
29087721 29087721 PRJNA1016321_P_NODE_42168_length_271_cov_1.555556_g41937_i0 PRJNA1016321 42168 271 1.555556 4.21555676 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 173 3.19e-49   NR MBN9393660.1 2052166 g41937 i0 97.8 0.996309963099631 90 2 99.6 0 270 1 317 406 MBN9393660.1 hypothetical protein [Candidatus Melainabacteria bacterium] diamond 270 173 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
29687145 29687145 PRJNA1016321_P_NODE_55150_length_242_cov_0.911243_g54919_i0 PRJNA1016321 55150 242 0.911243 2.20520806 Pleurocapsa sp. MO_226.B13 3036786 Bacteria Bacteria 125 1.1299999999999998e-31   NR MDJ0595363.1 3036786 g54919 i0 90 0.991735537190083 80 8 99.2 0 2 241 241 320 MDJ0595363.1 alanine/glycine:cation symporter family protein [Pleurocapsa sp. MO_226.B13] diamond 240 125 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. MO_226.B13
31298756 31298756 PRJNA1016321_P_NODE_44195_length_263_cov_3.000000_g43964_i0 PRJNA1016321 44195 263 3 7.89 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 122 1.39e-34   NR HEY9760802.1 3088181 g43964 i0 100 0.695817490494297 61 0 69.6 0 185 3 1 61 HEY9760802.1 hypothetical protein [Oculatellaceae cyanobacterium] diamond 183 122 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
32057946 32057946 PRJNA1016321_P_NODE_40198_length_279_cov_2.087379_g39967_i0 PRJNA1016321 40198 279 2.087379 5.82378741 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 45.8 0.00475   NR MBN9394940.1 2052166 g39967 i0 100 0.193548387096774 18 0 19.4 0 56 3 1 18 MBN9394940.1 type IV secretory system conjugative DNA transfer family protein [Candidatus Melainabacteria bacterium] diamond 54 45.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
32437929 32437929 PRJNA1016321_P_NODE_49819_length_249_cov_0.875000_g49588_i0 PRJNA1016321 49819 249 0.875 2.17875 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 164 4.399999999999998e-47   NR HEY9760500.1 3088181 g49588 i0 100 0.987951807228916 82 0 98.8 0 248 3 280 361 HEY9760500.1 hydroxymethylglutaryl-CoA reductase [Oculatellaceae cyanobacterium] diamond 246 164 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
32713868 32713868 PRJNA1016321_P_NODE_54480_length_243_cov_0.905882_g54249_i0 PRJNA1016321 54480 243 0.905882 2.20129326 Bacteria 2 Bacteria Bacteria 137 1.3e-35   NR HAX79343.1 2055768 g54249 i0 83.5 4.91358024691358 79 13 97.5 0 238 2 194 272 HAX79343.1 hypothetical protein [Cyanobacteria bacterium UBA11372] diamond 1194 137 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11372

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