RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA1139127", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 11 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 11 ✖

bioproject 1

  • PRJNA1139127 · 11 ✖

analysis 1

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
9960447 9960447 PRJNA1139127_P_NODE_47768_length_244_cov_0.906433_g47275_i0 PRJNA1139127 47768 244 0.906433 2.21169652 Planctomycetota bacterium 2026780 Bacteria Bacteria 62.8 8.67e-10   NR HXX92357.1 2026780 g47275 i0 50 1.14344262295082 44 22 54.1 0 18 149 151 194 HXX92357.1 hypothetical protein [Planctomycetota bacterium] diamond 279 62.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
20158653 20158653 PRJNA1139127_P_NODE_12196_length_597_cov_2.353053_g11724_i0 PRJNA1139127 12196 597 2.353053 14.04772641 Planctomycetota bacterium 2026780 Bacteria Bacteria 298 2.1099999999999996e-99   NR HUR38556.1 2026780 g11724 i0 84.7 1.75376884422111 176 27 88.4 0 597 70 12 187 HUR38556.1 PEP/pyruvate-binding domain-containing protein [Planctomycetota bacterium] diamond 1047 298 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26849066 26849066 PRJNA1139127_P_NODE_27441_length_340_cov_1.749064_g26949_i0 PRJNA1139127 27441 340 1.749064 5.9468176 Gemmataceae bacterium 2052164 Bacteria Bacteria 152 6.419999999999998e-43   NR HWG46139.1 2052164 g26949 i0 71.4 0.864705882352941 98 28 86.5 0 5 298 157 254 HWG46139.1 ABC transporter permease subunit [Gemmataceae bacterium] diamond 294 152 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27070355 27070355 PRJNA1139127_P_NODE_49622_length_236_cov_2.098160_g49129_i0 PRJNA1139127 49622 236 2.09816 4.9516576 Planctomycetota bacterium 2026780 Bacteria Bacteria 71.6 2.2e-12   NR MBI5865398.1 2026780 g49129 i0 63.8 0.597457627118644 47 17 59.7 0 228 88 73 119 MBI5865398.1 immunoglobulin domain-containing protein [Planctomycetota bacterium] diamond 141 71.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27828531 27828531 PRJNA1139127_P_NODE_31584_length_309_cov_1.309322_g31091_i0 PRJNA1139127 31584 309 1.309322 4.04580498 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.1 0.0117   NR MBN8643811.1 2026780 g31091 i0 38.9 0.524271844660194 54 31 52.4 1 15 176 283 334 MBN8643811.1 radical SAM family heme chaperone HemW [Planctomycetota bacterium] diamond 162 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27986393 27986393 PRJNA1139127_P_NODE_42305_length_252_cov_0.871508_g41812_i0 PRJNA1139127 42305 252 0.871508 2.19620016 Fimbriiglobus ruber 1908690 Bacteria Bacteria 104 9.249999999999999e-24   NR WP_238602609.1 1908690 g41812 i0 63.4 1.10714285714286 93 25 100 2 252 1 960 1052 WP_238602609.1 PVC-type heme-binding CxxCH protein [Fimbriiglobus ruber] diamond 279 104 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Fimbriiglobus Fimbriiglobus ruber
28207211 28207211 PRJNA1139127_P_NODE_10726_length_649_cov_3.083333_g10263_i0 PRJNA1139127 10726 649 3.083333 20.01083117 Planctopirus 1649480 Bacteria Bacteria 76.6 3.52e-14   NR WP_041401598.1 1649480 g10263 i0 41.1 0.869029275808937 90 53 41.6 0 172 441 18 107 WP_041401598.1 MULTISPECIES: hypothetical protein [Planctopirus] diamond 564 76.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctopirus  
28618020 28618020 PRJNA1139127_P_NODE_25927_length_354_cov_1.106762_g25435_i0 PRJNA1139127 25927 354 1.106762 3.91793748 Gemmataceae bacterium 2052164 Bacteria Bacteria 48.9 2.07e-4   NR MDB5309919.1 2052164 g25435 i0 35.6 0.76271186440678 90 54 73.7 3 285 25 7 95 MDB5309919.1 hypothetical protein [Gemmataceae bacterium] diamond 270 48.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
31207365 31207365 PRJNA1139127_P_NODE_11375_length_625_cov_2.487319_g10908_i0 PRJNA1139127 11375 625 2.487319 15.54574375 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 46.6 0.0454   NR MFM7207677.1 2026779 g10908 i0 39.5 0.3648 76 43 36.5 2 26 253 187 259 MFM7207677.1 hypothetical protein [Planctomycetaceae bacterium] diamond 228 46.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31228315 31228315 PRJNA1139127_P_NODE_40935_length_257_cov_1.385870_g40442_i0 PRJNA1139127 40935 257 1.38587 3.5616859 PVC group 1783257 Bacteria Bacteria 55.8 1.01e-6   NR MBI3824111.1 2026780 g40442 i0 43.1 6.75875486381323 51 29 59.5 0 103 255 1 51 MBI3824111.1 AAA family ATPase [Planctomycetota bacterium] diamond 1737 56.2 0.99288256227758 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32125387 32125387 PRJNA1139127_P_NODE_42038_length_253_cov_0.866667_g41545_i0 PRJNA1139127 42038 253 0.866667 2.19266751 Phycisphaerales bacterium 2052180 Bacteria Bacteria 96.3 8.22e-22   NR MEX2218633.1 2052180 g41545 i0 59.2 1.80237154150198 76 31 90.1 0 26 253 158 233 MEX2218633.1 flagellar motor protein MotB [Phycisphaerales bacterium] diamond 456 96.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales 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);;