RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA643700" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 6 ✖

bioproject 1

  • PRJNA643700 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
6262351 6262351 PRJNA643700_P_NODE_289525_length_215_cov_2.192771_g287969_i0 PRJNA643700 289525 215 2.192771 4.71445765 Waddlia 71666 Bacteria Bacteria 52.8 0.019   NTclustered gi|297375547|gb|CP001928.1| 716544 g287969 i0 100 0.26046511627907 28 0 13 0 15 42 522886 522859 Waddlia chondrophila WSU 86-1044, complete genome blastn 56 52.8 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Waddliaceae Waddlia Waddlia chondrophila
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

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