RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1249042" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1249042 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
26693724 26693724 PRJNA1249042_S_NODE_61621_length_196_cov_2.437908_g61407_i0 PRJNA1249042 61621 196 2.437908 4.77829968 Candidatus Brocadia sp. 2172549 Bacteria Bacteria 43.5 0.0109   NR MCC7211201.1 2172549 g61407 i0 34 0.719387755102041 47 31 71.9 0 40 180 128 174 MCC7211201.1 ammonium transporter [Candidatus Brocadia sp.] diamond 141 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Brocadiaceae Candidatus Brocadia Candidatus Brocadia sp.
28021377 28021377 PRJNA1249042_S_NODE_64245_length_193_cov_2.833333_g64031_i0 PRJNA1249042 64245 193 2.833333 5.46833269 Planctomycetota bacterium 2026780 Bacteria Bacteria 41.6 0.0474   NR MBI4554536.1 2026780 g64031 i0 42.2 0.699481865284974 45 25 69.9 1 21 155 261 304 MBI4554536.1 DUF362 domain-containing protein [Planctomycetota bacterium] diamond 135 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29347402 29347402 PRJNA1249042_S_NODE_104909_length_158_cov_1.226087_g104695_i0 PRJNA1249042 104909 158 1.226087 1.93721746 Phycisphaerae bacterium 2026778 Bacteria Bacteria 41.2 0.0417   NR MDM8009316.1 2026778 g104695 i0 40.9 0.835443037974684 44 26 83.5 0 147 16 307 350 MDM8009316.1 hypothetical protein [Phycisphaerae bacterium] diamond 132 41.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
31260779 31260779 PRJNA1249042_S_NODE_50495_length_209_cov_2.638554_g50281_i0 PRJNA1249042 50495 209 2.638554 5.51457786 Bacteria 2 Bacteria Bacteria 42.7 0.0227   NR MFP6763499.1 2026779 g50281 i0 56.3 1.39234449760766 32 14 45.9 0 197 102 140 171 MFP6763499.1 enoyl-CoA hydratase-related protein [Planctomycetaceae bacterium] diamond 291 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
32001876 32001876 PRJNA1249042_S_NODE_72738_length_185_cov_0.992958_g72524_i0 PRJNA1249042 72738 185 0.992958 1.8369723 Planctomycetota bacterium 2026780 Bacteria Bacteria 41.2 0.0305   NR NQU50444.1 2026780 g72524 i0 45.5 0.535135135135135 33 17 53.5 1 5 103 79 110 NQU50444.1 hydrogenase maturation nickel metallochaperone HypA [Planctomycetota bacterium] diamond 99 41.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32508362 32508362 PRJNA1249042_S_NODE_13739_length_287_cov_2.336066_g13525_i0 PRJNA1249042 13739 287 2.336066 6.70450942 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 130 1.71e-33   NR MEX2670747.1 2026777 g13525 i0 64.5 0.97212543554007 93 32 96.2 1 7 282 81 173 MEX2670747.1 alkaline phosphatase family protein [Phycisphaeraceae bacterium] diamond 279 130 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
32540010 32540010 PRJNA1249042_S_NODE_96339_length_164_cov_1.818182_g96125_i0 PRJNA1249042 96339 164 1.818182 2.98181848 Planctomycetota bacterium 2026780 Bacteria Bacteria 40 0.0433   NR MBM4009035.1 2026780 g96125 i0 51.5 0.603658536585366 33 16 60.4 0 64 162 75 107 MBM4009035.1 glycosyltransferase [Planctomycetota bacterium] diamond 99 40 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);;