RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA635874" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA635874 · 12 ✖

analysis 1

  • blastn · 12 ✖
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
607517 607517 PRJNA635874_P_NODE_41081_length_266_cov_0.963731_g40934_i0 PRJNA635874 41081 266 0.963731 2.56352446 Gemmataceae bacterium 2052164 Bacteria Bacteria 357 4.6e-94   NTclustered gi|2063814025|emb|LR586051.1| 2052164 g40934 i0 90.977 10.3045112781955 266 22 99 2 1 265 4327435 4327171 Gemmata bacterium CJuql4 whole genome assembly and annotation blastn 2741 357 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
607702 607702 PRJNA635874_P_NODE_47741_length_251_cov_0.865169_g47594_i0 PRJNA635874 47741 251 0.865169 2.17157419 Planctomycetes bacterium MalM25 2527998 Bacteria Bacteria 99 2.88e-16   NTclustered gi|1712524857|gb|CP036424.1| 2527998 g47594 i0 87.952 12.9721115537849 83 10 33 0 162 244 498470 498552 Planctomycetes bacterium MalM25 chromosome blastn 3256 99 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetes bacterium MalM25
1884435 1884435 PRJNA635874_P_NODE_70202_length_242_cov_0.911243_g70055_i0 PRJNA635874 70202 242 0.911243 2.20520806 Gemmataceae bacterium 2052164 Bacteria Bacteria 156 1.6200000000000002e-33   NTclustered gi|2063814025|emb|LR586051.1| 2052164 g70055 i0 90.598 0.483471074380165 117 11 48 0 1 117 6604499 6604615 Gemmata bacterium CJuql4 whole genome assembly and annotation blastn 117 156 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
3158908 3158908 PRJNA635874_P_NODE_60643_length_246_cov_0.890173_g60496_i0 PRJNA635874 60643 246 0.890173 2.18982558 Gemmataceae bacterium 2052164 Bacteria Bacteria 350 7.04e-92   NTclustered gi|2063814025|emb|LR586051.1| 2052164 g60496 i0 92.276 1 246 19 100 0 1 246 4302093 4301848 Gemmata bacterium CJuql4 whole genome assembly and annotation blastn 246 350 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
3159214 3159214 PRJNA635874_P_NODE_72443_length_241_cov_0.916667_g72296_i0 PRJNA635874 72443 241 0.916667 2.20916747 Planctomyces sp. SH-PL14 1632864 Bacteria Bacteria 407 4.0199999999999995e-109   NTclustered gi|1015434452|gb|CP011270.1| 1632864 g72296 i0 97.095 1 241 7 100 0 1 241 5778811 5778571 Planctomyces sp. SH-PL14, complete genome blastn 241 407 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL14
10812348 10812348 PRJNA635874_P_NODE_65449_length_244_cov_0.900585_g65302_i0 PRJNA635874 65449 244 0.900585 2.1974274 uncultured Planctomycetota bacterium 120965 Bacteria Bacteria 451 1.86e-122   NTclustered gi|391225846|gb|JQ861342.1| 120965 g65302 i0 100 95.5450819672131 244 0 100 0 1 244 1510 1267 Uncultured planctomycete clone JZ44 16S ribosomal RNA gene, partial sequence blastn 23313 451 1 Bacteria PVC group Pseudomonadati Planctomycetota         uncultured Planctomycetota bacterium
17185614 17185614 PRJNA635874_P_NODE_44674_length_255_cov_1.373626_g44527_i0 PRJNA635874 44674 255 1.373626 3.5027463 Gemmataceae bacterium 2052164 Bacteria Bacteria 196 1.01e-45   NTclustered gi|2063814025|emb|LR586051.1| 2052164 g44527 i0 95.161 1.29019607843137 124 6 49 0 2 125 1491265 1491388 Gemmata bacterium CJuql4 whole genome assembly and annotation blastn 329 196 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
17185743 17185743 PRJNA635874_P_NODE_50634_length_250_cov_0.864407_g50487_i0 PRJNA635874 50634 250 0.864407 2.1610175 Gemmataceae bacterium 2052164 Bacteria Bacteria 163 1e-35   NTclustered gi|2063814025|emb|LR586051.1| 2052164 g50487 i0 89.922 1.284 129 9 52 4 118 246 6021263 6021387 Gemmata bacterium CJuql4 whole genome assembly and annotation blastn 321 163 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
17185830 17185830 PRJNA635874_P_NODE_54494_length_248_cov_0.880000_g54347_i0 PRJNA635874 54494 248 0.88 2.1824 Candidatus Uabimicrobium helgolandensis 3095367 Bacteria Bacteria 54.7 0.006   NTclustered gi|2793194503|gb|CP165719.1| 3095367 g54347 i0 94.444 0.145161290322581 36 1 15 1 189 224 4440646 4440612 Candidatus Uabimicrobium helgolandensis strain HlEnr_7 chromosome blastn 36 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Uabimicrobiia Candidatus Uabimicrobiales Candidatus Uabimicrobiaceae Candidatus Uabimicrobium Candidatus Uabimicrobium helgolandensis
19734726 19734726 PRJNA635874_P_NODE_60876_length_245_cov_2.325581_g60729_i0 PRJNA635874 60876 245 2.325581 5.69767345 Gemmataceae bacterium 2052164 Bacteria Bacteria 206 1.6e-48   NTclustered gi|2063814025|emb|LR586051.1| 2052164 g60729 i0 96.748 27.7836734693878 123 4 50 0 123 245 6413481 6413603 Gemmata bacterium CJuql4 whole genome assembly and annotation blastn 6807 206 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
22285150 22285150 PRJNA635874_P_NODE_63178_length_245_cov_0.895349_g63031_i0 PRJNA635874 63178 245 0.895349 2.19360505 Kolteria novifilia 2527975 Bacteria Bacteria 93.5 1.3e-14   NTclustered gi|1712629967|gb|CP036279.1| 2527975 g63031 i0 88.312 24.9714285714286 77 9 31 0 135 211 6301152 6301228 Planctomycetes bacterium Pan216 chromosome, complete genome blastn 6118 93.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Kolteriales Kolteriaceae Kolteria Kolteria novifilia
23560836 23560836 PRJNA635874_P_NODE_69639_length_242_cov_0.911243_g69492_i0 PRJNA635874 69639 242 0.911243 2.20520806 Gemmataceae bacterium 2052164 Bacteria Bacteria 233 7.25e-57   NTclustered gi|2063814025|emb|LR586051.1| 2052164 g69492 i0 96.454 26.797520661157 141 5 58 0 102 242 7586521 7586661 Gemmata bacterium CJuql4 whole genome assembly and annotation blastn 6485 233 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae 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);;