RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA643700", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 10 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 10 ✖

bioproject 1

  • PRJNA643700 · 10 ✖
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
6996716 6996716 PRJNA643700_P_NODE_292186_length_214_cov_1.260606_g290630_i0 PRJNA643700 292186 214 1.260606 2.69769684 Planctomyces sp. SH-PL62 1636152 Bacteria Bacteria 318 1.68e-82   NTclustered gi|1015454008|gb|CP011273.1| 1636152 g290630 i0 93.548 157.906542056075 217 8 100 5 1 214 1156012 1156225 Planctomyces sp. SH-PL62, complete genome blastn 33792 318 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL62
8271366 8271366 PRJNA643700_P_NODE_200547_length_278_cov_1.506550_g198991_i0 PRJNA643700 200547 278 1.50655 4.188209 Candidatus Jettenia caeni 247490 Bacteria Bacteria 54.7 0.007   NTclustered gi|2556874801|gb|CP129467.1| 247490 g198991 i0 100 0.10431654676259 29 0 10 0 55 83 2781608 2781580 MAG: Candidatus Jettenia caeni isolate YC-1 chromosome, complete genome blastn 29 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Brocadiaceae Candidatus Jettenia Candidatus Jettenia caeni
15921030 15921030 PRJNA643700_P_NODE_312153_length_203_cov_2.246753_g310597_i0 PRJNA643700 312153 203 2.246753 4.56090859 Candidatus Kuenenia stuttgartensis 174633 Bacteria Bacteria 52.8 0.018   NTclustered gi|1818975054|gb|CP049055.1| 174633 g310597 i0 100 0.551724137931034 28 0 14 0 49 76 3413704 3413677 Candidatus Kuenenia stuttgartiensis strain CSTR1 chromosome, complete genome blastn 112 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Brocadiaceae Candidatus Kuenenia Candidatus Kuenenia stuttgartensis
21020618 21020618 PRJNA643700_P_NODE_379097_length_172_cov_1.504065_g377541_i0 PRJNA643700 379097 172 1.504065 2.5869918 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 285 1.31e-72   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g377541 i0 96.532 165.831395348837 173 4 100 2 1 172 2002704 2002533 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 28523 285 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
22295222 22295222 PRJNA643700_P_NODE_269658_length_227_cov_1.168539_g268102_i0 PRJNA643700 269658 227 1.168539 2.65258353 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 54.7 0.006   NTclustered gi|2874253799|emb|OY969783.1| 2876886 g268102 i0 100 0.127753303964758 29 0 13 0 33 61 4471859 4471887 MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1 blastn 29 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
27302659 27302659 PRJNA643700_P_NODE_305003_length_207_cov_1.601266_g303447_i0 PRJNA643700 305003 207 1.601266 3.31462062 Sedimentisphaerales bacterium 2813034 Bacteria Bacteria 43.5 0.0123   NR MBN2139066.1 2813034 g303447 i0 43.5 0.666666666666667 46 26 66.7 0 47 184 421 466 MBN2139066.1 gamma-glutamylcyclotransferase [Sedimentisphaerales bacterium] diamond 138 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Sedimentisphaerales     Sedimentisphaerales bacterium
27586873 27586873 PRJNA643700_P_NODE_288744_length_216_cov_1.209581_g287188_i0 PRJNA643700 288744 216 1.209581 2.61269496 Pirellulales bacterium 2715253 Bacteria Bacteria 43.9 0.0105   NR HZZ29994.1 2715253 g287188 i0 37.7 0.736111111111111 53 30 69.4 1 7 156 39 91 HZZ29994.1 TolC family protein [Pirellulales bacterium] diamond 159 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
29165701 29165701 PRJNA643700_P_NODE_135009_length_354_cov_1.032787_g133454_i0 PRJNA643700 135009 354 1.032787 3.65606598 Phycisphaerales bacterium 2052180 Bacteria Bacteria 44.3 0.033   NR MCA9280103.1 2052180 g133454 i0 36.7 0.508474576271186 60 33 50.8 1 314 135 116 170 MCA9280103.1 UDP-glucose 4-epimerase GalE [Phycisphaerales bacterium] diamond 180 44.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29733555 29733555 PRJNA643700_P_NODE_180970_length_297_cov_1.258065_g179414_i0 PRJNA643700 180970 297 1.258065 3.73645305 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.7 0.0409   NR RMF76061.1 2026780 g179414 i0 37.7 0.535353535353535 53 22 53.5 1 29 187 12 53 RMF76061.1 MAG: hypothetical protein D6744_12685 [Planctomycetota bacterium] diamond 159 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31471933 31471933 PRJNA643700_P_NODE_274736_length_224_cov_1.188571_g273180_i0 PRJNA643700 274736 224 1.188571 2.66239904 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.7 0.0289   NR MBN1807603.1 2026780 g273180 i0 41.5 0.549107142857143 41 24 54.9 0 139 17 181 221 MBN1807603.1 MFS transporter [Planctomycetota bacterium] diamond 123 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;