RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA667863" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA667863 · 20 ✖
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
7012645 7012645 PRJNA667863_P_NODE_9686_length_259_cov_3.069892_g9652_i0 PRJNA667863 9686 259 3.069892 7.95102028 Pirellula sp. SH-Sr6A 1632865 Bacteria Bacteria 344 3.48e-90   NTclustered gi|1015448679|gb|CP011272.1| 1632865 g9652 i0 91.304 149.984555984556 253 20 97 2 8 259 3096900 3097151 Pirellula sp. SH-Sr6A, complete genome blastn 38846 344 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp. SH-Sr6A
22311396 22311396 PRJNA667863_P_NODE_7798_length_272_cov_1.417085_g7764_i0 PRJNA667863 7798 272 1.417085 3.8544712 Symmachiella dynata 2527995 Bacteria Bacteria 56.5 0.002   NTclustered gi|1712609668|gb|CP036276.1| 2527995 g7764 i0 100 0.227941176470588 30 0 11 0 186 215 3237577 3237606 Symmachiella dynata strain Mal52 chromosome, complete genome blastn 62 56.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Symmachiella Symmachiella dynata
23586634 23586634 PRJNA667863_P_NODE_12359_length_249_cov_0.875000_g12325_i0 PRJNA667863 12359 249 0.875 2.17875 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 416 6.939999999999999e-112   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g12325 i0 96.8 46.6987951807229 250 6 100 2 1 249 1599923 1600171 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 11628 416 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
24115461 24115461 PRJNA667863_P_NODE_7039_length_278_cov_1.497561_g7005_i0 PRJNA667863 7039 278 1.497561 4.16321958 Gemmata 113 Bacteria Bacteria 268 2.3299999999999994e-67   NTclustered gi|1727537522|gb|CP042911.1| 114 g7005 i0 87.826 3.3884892086330902 230 26 82 2 1 229 2494268 2494496 Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome blastn 942 268 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
26701571 26701571 PRJNA667863_P_NODE_12561_length_249_cov_0.875000_g12527_i0 PRJNA667863 12561 249 0.875 2.17875 Phycisphaerales bacterium 2052180 Bacteria Bacteria 150 1.12e-42   NR MBY0313100.1 2052180 g12527 i0 93.9 0.987951807228916 82 5 98.8 0 247 2 87 168 MBY0313100.1 ParA family protein [Phycisphaerales bacterium] diamond 246 150 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
27460968 27460968 PRJNA667863_P_NODE_5563_length_293_cov_1.372727_g5529_i0 PRJNA667863 5563 293 1.372727 4.02209011 Planctomycetota bacterium 2026780 Bacteria Bacteria 67.8 7.72e-11   NR MEM7754480.1 2026780 g5529 i0 45 7.59726962457338 80 39 76.8 1 6 230 213 292 MEM7754480.1 fasciclin domain-containing protein [Planctomycetota bacterium] diamond 2226 67.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27965944 27965944 PRJNA667863_P_NODE_7925_length_271_cov_1.464646_g7891_i0 PRJNA667863 7925 271 1.464646 3.96919066 Planctomycetota bacterium 2026780 Bacteria Bacteria 108 6.08e-26   NR MDE0905108.1 2026780 g7891 i0 59.3 2.01476014760148 91 34 98.5 2 3 269 84 173 MDE0905108.1 bifunctional diaminohydroxyphosphoribosylaminopyrimidine deaminase/5-amino-6-(5-phosphoribosylamino)uracil reductase RibD [Planctomycetota bacterium] diamond 546 108 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28344869 28344869 PRJNA667863_P_NODE_6326_length_285_cov_1.273585_g6292_i0 PRJNA667863 6326 285 1.273585 3.62971725 Gemmata massiliana 1210884 Bacteria Bacteria 113 6.89e-27   NR WP_162666449.1 1210884 g6292 i0 61.8 2.93684210526316 89 33 93.7 1 3 269 278 365 WP_162666449.1 OB-fold protein [Gemmata massiliana] diamond 837 113 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata massiliana
28451801 28451801 PRJNA667863_P_NODE_8166_length_269_cov_2.107143_g8132_i0 PRJNA667863 8166 269 2.107143 5.66821467 root 1 Root_unresolved Root_unresolved 44.7 0.0108   NR MFO0981485.1 2026780 g8132 i0 46.2 2.2639405204461 52 22 51.3 1 268 131 524 575 MFO0981485.1 hypothetical protein [Planctomycetota bacterium] diamond 609 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29229185 29229185 PRJNA667863_P_NODE_789_length_553_cov_4.056250_g757_i0 PRJNA667863 789 553 4.05625 22.4310625 Phycisphaerales bacterium 2052180 Bacteria Bacteria 70.9 1.45e-10   NR MSR40902.1 2052180 g757 i0 38.8 0.726943942133816 134 60 62.9 7 549 202 590 719 MSR40902.1 hypothetical protein [Phycisphaerales bacterium] diamond 402 70.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29449747 29449747 PRJNA667863_P_NODE_9230_length_262_cov_1.941799_g9196_i0 PRJNA667863 9230 262 1.941799 5.08751338 Gemmata obscuriglobus 114 Bacteria Bacteria 151 3.4199999999999993e-40   NR WP_010038014.1 114 g9196 i0 84.9 0.984732824427481 86 13 98.5 0 3 260 968 1053 WP_010038014.1 serine/threonine-protein kinase [Gemmata obscuriglobus] diamond 258 151 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
30081424 30081424 PRJNA667863_P_NODE_15212_length_244_cov_0.900585_g15178_i0 PRJNA667863 15212 244 0.900585 2.1974274 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 42.7 0.0358   NR HRK32644.1 2876886 g15178 i0 50 0.442622950819672 36 18 44.3 0 132 239 63 98 HRK32644.1 serine/threonine-protein kinase [Tepidisphaeraceae bacterium] diamond 108 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
30523911 30523911 PRJNA667863_P_NODE_413_length_723_cov_2.950769_g384_i0 PRJNA667863 413 723 2.950769 21.33405987 Planctomycetota bacterium 2026780 Bacteria Bacteria 97.1 6.76e-19   NR MBM4052851.1 2026780 g384 i0 36.8 0.767634854771784 185 81 76.3 10 126 677 783 932 MBM4052851.1 hypothetical protein [Planctomycetota bacterium] diamond 555 97.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30650097 30650097 PRJNA667863_P_NODE_16033_length_242_cov_3.668639_g15999_i0 PRJNA667863 16033 242 3.668639 8.87810638 Gemmata sp. 1914242 Bacteria Bacteria 56.2 1.67e-7   NR HEY1191034.1 1914242 g15999 i0 60.4 0.65702479338843 53 20 65.7 1 19 177 108 159 HEY1191034.1 hypothetical protein [Gemmata sp.] diamond 159 56.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata sp.
30757152 30757152 PRJNA667863_P_NODE_14414_length_245_cov_1.686047_g14380_i0 PRJNA667863 14414 245 1.686047 4.13081515 Planctomycetia 203683 Bacteria Bacteria 67.4 8.05e-11   NR MDF1841105.1 1973111 g14380 i0 42.1 4.29795918367347 76 44 93.1 0 231 4 1184 1259 MDF1841105.1 hypothetical protein [Rubripirellula sp.] diamond 1053 67.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rubripirellula Rubripirellula sp.
31408889 31408889 PRJNA667863_P_NODE_15736_length_243_cov_0.905882_g15702_i0 PRJNA667863 15736 243 0.905882 2.20129326 Neorhodopirellula lusitana 445327 Bacteria Bacteria 78.2 7.12e-16   NR WP_283433369.1 445327 g15702 i0 89.7 0.962962962962963 39 4 48.1 0 2 118 137 175 WP_283433369.1 hypothetical protein [Neorhodopirellula lusitana] diamond 234 78.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Neorhodopirellula Neorhodopirellula lusitana
31440352 31440352 PRJNA667863_P_NODE_4716_length_308_cov_1.391489_g4682_i0 PRJNA667863 4716 308 1.391489 4.28578612 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.5 0.0428   NR MFM1805237.1 2026780 g4682 i0 37.2 0.75974025974026 78 40 72.1 3 60 281 251 323 MFM1805237.1 hypothetical protein [Planctomycetota bacterium] diamond 234 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31693456 31693456 PRJNA667863_P_NODE_4217_length_318_cov_0.971429_g4183_i0 PRJNA667863 4217 318 0.971429 3.08914422 Gemmataceae bacterium 2052164 Bacteria Bacteria 72 3.26e-12   NR VIP09135.1 2052164 g4183 i0 42.4 1.82075471698113 99 55 93.4 2 6 302 7 103 VIP09135.1 acetylserotonin o-methyltransferase : Acetylserotonin O-methyltransferase OS=Rhodopirellula baltica SH28 GN=RBSH_02618 PE=4 SV=1: Methyltransf_2 [Gemmataceae bacterium] diamond 579 72 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32243733 32243733 PRJNA667863_P_NODE_8978_length_264_cov_1.240838_g8944_i0 PRJNA667863 8978 264 1.240838 3.27581232 Planctomycetota 203682 Bacteria Bacteria 42.7 0.0489   NR WP_229759373.1 2596890 g8944 i0 38.7 1.35227272727273 62 34 70.5 1 203 18 768 825 WP_229759373.1 DUF4062 domain-containing protein [Candidatus Uabimicrobium amorphum] diamond 357 43.1 0.990719257540603 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Uabimicrobiia Candidatus Uabimicrobiales Candidatus Uabimicrobiaceae Candidatus Uabimicrobium Candidatus Uabimicrobium amorphum
32862672 32862672 PRJNA667863_P_NODE_720_length_573_cov_1.600000_g688_i0 PRJNA667863 720 573 1.6 9.168 Planctomycetota bacterium 2026780 Bacteria Bacteria 59.3 1.43e-6   NR MEI6637303.1 2026780 g688 i0 30.8 0.696335078534031 133 78 67 4 149 532 200 323 MEI6637303.1 discoidin domain-containing protein [Planctomycetota bacterium] diamond 399 59.3 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);;