RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where bioproject = "PRJNA1174234", tax_phylum = "Planctomycetota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 32 ✖

tax_phylum 1

  • Planctomycetota · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1174234 · 32 ✖
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
2867018 2867018 PRJNA1174234_P_NODE_3863_length_676_cov_3.195688_g3676_i0 PRJNA1174234 3863 676 3.195688 21.60285088 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 952 0   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g3676 i0 92.082 226.863905325444 682 45 100 9 1 676 2003117 2002439 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 153360 952 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
6143797 6143797 PRJNA1174234_P_NODE_20005_length_309_cov_0.978814_g19809_i0 PRJNA1174234 20005 309 0.978814 3.02453526 Planctomycetota bacterium 2026780 Bacteria Bacteria 179 6.739999999999999e-52   NR MEM6474261.1 2026780 g19809 i0 86.3 8.9126213592233 102 14 99 0 307 2 165 266 MEM6474261.1 F0F1 ATP synthase subunit beta [Planctomycetota bacterium] diamond 2754 179 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
6693997 6693997 PRJNA1174234_P_NODE_16326_length_342_cov_1.007435_g16130_i0 PRJNA1174234 16326 342 1.007435 3.4454277 Phycisphaerae bacterium 2026778 Bacteria Bacteria 78.2 4.44e-14   NR NUQ48965.1 2026778 g16130 i0 60.7 1.64912280701754 61 24 53.5 0 330 148 483 543 NUQ48965.1 peroxidase [Phycisphaerae bacterium] diamond 564 78.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
6694023 6694023 PRJNA1174234_P_NODE_19886_length_309_cov_4.432203_g19690_i0 PRJNA1174234 19886 309 4.432203 13.69550727 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 433 8.82e-117   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g19690 i0 91.987 158.423948220065 312 20 99 3 3 309 2004390 2004079 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 48953 433 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
6694039 6694039 PRJNA1174234_P_NODE_22526_length_291_cov_0.880734_g22330_i0 PRJNA1174234 22526 291 0.880734 2.56293594 Anatilimnocola aggregata 2528021 Bacteria Bacteria 433 8.24e-117   NTclustered gi|1712591889|gb|CP036274.1| 2528021 g22330 i0 93.471 91.3436426116838 291 19 100 0 1 291 7629522 7629812 Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome blastn 26581 433 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Anatilimnocola Anatilimnocola aggregata
7969310 7969310 PRJNA1174234_P_NODE_12147_length_395_cov_1.673913_g11951_i0 PRJNA1174234 12147 395 1.673913 6.61195635 Pirellula sp. SH-Sr6A 1632865 Bacteria Bacteria 63.9 1.75e-5   NTclustered gi|1015448679|gb|CP011272.1| 1632865 g11951 i0 100 0.0860759493670886 34 0 9 0 357 390 4544486 4544519 Pirellula sp. SH-Sr6A, complete genome blastn 34 63.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp. SH-Sr6A
8693889 8693889 PRJNA1174234_P_NODE_13707_length_372_cov_0.983278_g13511_i0 PRJNA1174234 13707 372 0.983278 3.65779416 Lacipirellula 2691417 Bacteria Bacteria 555 2.2099999999999994e-153   NTclustered gi|1712529062|gb|CP036339.1| 2528024 g13511 i0 93.566 140.959677419355 373 22 100 2 1 372 5170023 5170394 Lacipirellula limnantheis strain I41 chromosome blastn 52437 560 0.991071428571429 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Lacipirellula Lacipirellula limnantheis
11794729 11794729 PRJNA1174234_P_NODE_28110_length_256_cov_1.262295_g27914_i0 PRJNA1174234 28110 256 1.262295 3.2314752 Humisphaera borealis 2807512 Bacteria Bacteria 331 2.67e-86   NTclustered gi|1927742986|gb|CP063458.1| 2807512 g27914 i0 90.272 71.4921875 257 20 100 4 1 256 5063967 5064219 Humisphaera borealis strain M1803 chromosome, complete genome blastn 18302 331 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
13069690 13069690 PRJNA1174234_P_NODE_21451_length_298_cov_1.368889_g21255_i0 PRJNA1174234 21451 298 1.368889 4.07928922 Planctomycetia 203683 Bacteria Bacteria 110 3.3e-27   NR MFO0536479.1 37635 g21255 i0 55.6 7.98322147651007 99 43 98.7 1 5 298 54 152 MFO0536479.1 aldehyde dehydrogenase family protein [Planctomyces sp.] diamond 2379 110 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp.
13069751 13069751 PRJNA1174234_P_NODE_30691_length_249_cov_0.875000_g30495_i0 PRJNA1174234 30691 249 0.875 2.17875 Planctomycetota bacterium 2026780 Bacteria Bacteria 152 1.7199999999999999e-43   NR RIK79273.1 2026780 g30495 i0 92.7 8.89156626506024 82 6 98.8 0 247 2 191 272 RIK79273.1 MAG: dihydroorotate dehydrogenase [Planctomycetota bacterium] diamond 2214 152 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
15618818 15618818 PRJNA1174234_P_NODE_18233_length_323_cov_0.924000_g18037_i0 PRJNA1174234 18233 323 0.924 2.98452 Anatilimnocola aggregata 2528021 Bacteria Bacteria 438 1.99e-118   NTclustered gi|1712591889|gb|CP036274.1| 2528021 g18037 i0 91.331 116.786377708978 323 25 99 3 2 323 7628871 7628551 Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome blastn 37722 438 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Anatilimnocola Anatilimnocola aggregata
15618877 15618877 PRJNA1174234_P_NODE_26613_length_265_cov_1.375000_g26417_i0 PRJNA1174234 26613 265 1.375 3.64375 Humisphaera borealis 2807512 Bacteria Bacteria 398 2.7e-106   NTclustered gi|1927742986|gb|CP063458.1| 2807512 g26417 i0 93.916 19.6037735849057 263 16 99 0 3 265 5063169 5062907 Humisphaera borealis strain M1803 chromosome, complete genome blastn 5195 398 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
20717563 20717563 PRJNA1174234_P_NODE_4937_length_606_cov_1.283302_g4744_i0 PRJNA1174234 4937 606 1.283302 7.77681012 Lacipirellula limnantheis 2528024 Bacteria Bacteria 926 0   NTclustered gi|1712529062|gb|CP036339.1| 2528024 g4744 i0 94.262 121.57095709571 610 27 100 5 1 606 5171972 5171367 Lacipirellula limnantheis strain I41 chromosome blastn 73672 926 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Lacipirellula Lacipirellula limnantheis
24542043 24542043 PRJNA1174234_P_NODE_15960_length_346_cov_1.032967_g15764_i0 PRJNA1174234 15960 346 1.032967 3.57406582 uncultured Phycisphaerales bacterium 904075 Bacteria Bacteria 394 4.72e-105   NTclustered gi|2874253847|emb|OY969903.1| 904075 g15764 i0 87.32 47.6936416184971 347 40 99 4 1 345 1830975 1830631 MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 blastn 16502 394 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     uncultured Phycisphaerales bacterium
26755461 26755461 PRJNA1174234_P_NODE_33361_length_244_cov_1.795322_g33165_i0 PRJNA1174234 33361 244 1.795322 4.38058568 Planctomycetota bacterium 2026780 Bacteria Bacteria 77.4 1e-14   NR MCC6408904.1 2026780 g33165 i0 48.7 4.61065573770492 78 40 95.9 0 2 235 216 293 MCC6408904.1 ATP synthase F1 subunit gamma [Planctomycetota bacterium] diamond 1125 77.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26806573 26806573 PRJNA1174234_P_NODE_33901_length_244_cov_0.900585_g33705_i0 PRJNA1174234 33901 244 0.900585 2.1974274 PVC group 1783257 Bacteria Bacteria 48.9 2.38e-4   NR MFO0955967.1 2691532 g33705 i0 77.8 2.37295081967213 36 8 44.3 0 132 239 1 36 MFO0955967.1 cation:proton antiporter [Isosphaeraceae bacterium] diamond 579 48.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
26977183 26977183 PRJNA1174234_P_NODE_13002_length_382_cov_0.996764_g12806_i0 PRJNA1174234 13002 382 0.996764 3.80763848 Planctomycetota bacterium 2026780 Bacteria Bacteria 93.2 1.5e-19   NR MEO1129111.1 2026780 g12806 i0 52.3 1.35078534031414 86 41 67.5 0 124 381 22 107 MEO1129111.1 12-oxophytodienoate reductase [Planctomycetota bacterium] diamond 516 93.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27830227 27830227 PRJNA1174234_P_NODE_19804_length_310_cov_1.299578_g19608_i0 PRJNA1174234 19804 310 1.299578 4.0286918 Limnoglobus roseus 2598579 Bacteria Bacteria 61.6 1.96e-8   NR WP_149113609.1 2598579 g19608 i0 44.4 0.696774193548387 72 34 69.7 3 2 217 806 871 WP_149113609.1 FAD-binding protein [Limnoglobus roseus] diamond 216 61.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Limnoglobus Limnoglobus roseus
28714366 28714366 PRJNA1174234_P_NODE_12927_length_383_cov_1.145161_g12731_i0 PRJNA1174234 12927 383 1.145161 4.38596663 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 47.8 0.00266   NR MBX3358795.1 2026777 g12731 i0 34 0.783289817232376 100 34 78.3 3 2 301 129 196 MBX3358795.1 diaminopimelate epimerase [Phycisphaeraceae bacterium] diamond 300 47.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
28903559 28903559 PRJNA1174234_P_NODE_15648_length_349_cov_1.634058_g15452_i0 PRJNA1174234 15648 349 1.634058 5.70286242 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 64.3 4.56e-10   NR MCW5765313.1 2026777 g15452 i0 50.7 1.13467048710602 69 30 55.9 1 3 197 77 145 MCW5765313.1 CHRD domain-containing protein [Phycisphaeraceae bacterium] diamond 396 64.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
28922796 28922796 PRJNA1174234_P_NODE_23228_length_286_cov_1.084507_g23032_i0 PRJNA1174234 23228 286 1.084507 3.10169002 Bacteria 2 Bacteria Bacteria 81.6 1.24e-15   NR NLU20758.1 2026778 g23032 i0 43 2.81118881118881 93 53 97.6 0 3 281 118 210 NLU20758.1 DUF4139 domain-containing protein [Phycisphaerae bacterium] diamond 804 81.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
29314249 29314249 PRJNA1174234_P_NODE_20929_length_302_cov_1.008734_g20733_i0 PRJNA1174234 20929 302 1.008734 3.04637668 Phycisphaerales bacterium 2052180 Bacteria Bacteria 45.8 0.00646   NR MEN6335742.1 2052180 g20733 i0 31.5 0.913907284768212 92 52 82.5 2 261 13 1083 1172 MEN6335742.1 M56 family metallopeptidase [Phycisphaerales bacterium] diamond 276 45.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29345883 29345883 PRJNA1174234_P_NODE_15609_length_350_cov_0.935018_g15413_i0 PRJNA1174234 15609 350 0.935018 3.272563 Planctomycetota bacterium 2026780 Bacteria Bacteria 125 1.3e-30   NR MFM1871373.1 2026780 g15413 i0 58.8 0.874285714285714 102 35 87.4 2 45 350 466 560 MFM1871373.1 hypothetical protein [Planctomycetota bacterium] diamond 306 125 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30091165 30091165 PRJNA1174234_P_NODE_19492_length_312_cov_1.941423_g19296_i0 PRJNA1174234 19492 312 1.941423 6.05723976 Pseudomonadati 3379134 Bacteria Bacteria 63.2 1.64e-9   NR MCP4172490.1 1936112 g19296 i0 44.9 2.53846153846154 78 43 75 0 234 1 59 136 MCP4172490.1 30S ribosomal protein S9 [Fuerstiella sp.] diamond 792 63.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Fuerstiella Fuerstiella sp.
30439108 30439108 PRJNA1174234_P_NODE_24093_length_280_cov_1.855072_g23897_i0 PRJNA1174234 24093 280 1.855072 5.1942016 Pseudomonadati 3379134 Bacteria Bacteria 119 2.05e-32   NR MEI8196857.1 2026778 g23897 i0 62.2 10.6714285714286 90 34 96.4 0 9 278 5 94 MEI8196857.1 aldolase/citrate lyase family protein [Phycisphaerae bacterium] diamond 2988 119 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
30988557 30988557 PRJNA1174234_P_NODE_26914_length_263_cov_1.600000_g26718_i0 PRJNA1174234 26914 263 1.6 4.208 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 50.8 6.61e-6   NR MAX24119.1 2026777 g26718 i0 64.9 0.422053231939163 37 11 42.2 1 1 111 28 62 MAX24119.1 hypothetical protein [Phycisphaeraceae bacterium] diamond 111 50.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
31209140 31209140 PRJNA1174234_P_NODE_31495_length_247_cov_0.982759_g31299_i0 PRJNA1174234 31495 247 0.982759 2.42741473 Planctomycetota bacterium 2026780 Bacteria Bacteria 77 3.21e-14   NR MCY2971033.1 2026780 g31299 i0 45.9 2.02834008097166 85 39 94.7 1 242 9 157 241 MCY2971033.1 VCBS repeat-containing protein [Planctomycetota bacterium] diamond 501 77 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31545215 31545215 PRJNA1174234_P_NODE_17736_length_327_cov_1.318898_g17540_i0 PRJNA1174234 17736 327 1.318898 4.31279646 PVC group 1783257 Bacteria Bacteria 50.8 8.63e-5   NR MDH3719494.1 2026780 g17540 i0 34.6 2.58715596330275 78 46 71.6 2 321 88 141 213 MDH3719494.1 MOSC domain-containing protein [Planctomycetota bacterium] diamond 846 51.2 0.9921875 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31683855 31683855 PRJNA1174234_P_NODE_23857_length_282_cov_1.320574_g23661_i0 PRJNA1174234 23857 282 1.320574 3.72401868 Aureliella sp. 2795609 Bacteria Bacteria 66.6 2.42e-10   NR MFN3191864.1 2795609 g23661 i0 41.6 0.946808510638298 89 45 87.2 4 253 8 2003 2091 MFN3191864.1 hypothetical protein [Aureliella sp.] diamond 267 66.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Aureliella Aureliella sp.
31715655 31715655 PRJNA1174234_P_NODE_17117_length_333_cov_2.250000_g16921_i0 PRJNA1174234 17117 333 2.25 7.4925 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 50.4 2.15e-4   NR MFT3789274.1 2876886 g16921 i0 48.7 0.648648648648649 39 20 35.1 0 333 217 832 870 MFT3789274.1 ATP-dependent chaperone ClpB [Tepidisphaeraceae bacterium] diamond 216 50.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
32475193 32475193 PRJNA1174234_P_NODE_31279_length_248_cov_0.880000_g31083_i0 PRJNA1174234 31279 248 0.88 2.1824 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 94 3.77e-20   NR HWE35717.1 2691532 g31083 i0 53.9 0.919354838709677 76 35 91.9 0 1 228 69 144 HWE35717.1 HEAT repeat domain-containing protein [Isosphaeraceae bacterium] diamond 228 94 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
32790104 32790104 PRJNA1174234_P_NODE_30580_length_249_cov_0.875000_g30384_i0 PRJNA1174234 30580 249 0.875 2.17875 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 43.1 0.00888   NR HEV8604408.1 2876886 g30384 i0 36.2 0.698795180722892 58 35 68.7 2 199 29 5 61 HEV8604408.1 (2Fe-2S)-binding protein [Tepidisphaeraceae bacterium] diamond 174 43.1 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);;