RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA826497", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 12 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 12 ✖

bioproject 1

  • PRJNA826497 · 12 ✖
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
4648987 4648987 PRJNA826497_S_NODE_12724_length_174_cov_3.340426_g12684_i0 PRJNA826497 12724 174 3.340426 5.81234124 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 152 1.4e-32   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g12684 i0 89.831 17.4080459770115 118 12 68 0 57 174 7051489 7051606 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 3029 152 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
12299822 12299822 PRJNA826497_S_NODE_15090_length_165_cov_1.924242_g15050_i0 PRJNA826497 15090 165 1.924242 3.1749993 Humisphaera borealis 2807512 Bacteria Bacteria 71.3 3.81e-8   NTclustered gi|1927742986|gb|CP063458.1| 2807512 g15050 i0 97.561 1.12727272727273 41 1 25 0 3 43 5064068 5064108 Humisphaera borealis strain M1803 chromosome, complete genome blastn 186 71.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
24179850 24179850 PRJNA826497_S_NODE_12279_length_176_cov_2.993007_g12239_i0 PRJNA826497 12279 176 2.993007 5.26769232 Planctomycetota 203682 Bacteria Bacteria 89.8 1.13e-13   NTclustered gi|12583969|gb|AF245373.1|AF245373 79870 g12239 i0 82.692 33.3920454545455 104 15 59 2 4 106 1658 1557 Planctomycete str. 449 23S ribosomal RNA gene, partial sequence blastn 5877 89.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   planctomycete str. 449
26927912 26927912 PRJNA826497_S_NODE_11842_length_178_cov_2.765517_g11802_i0 PRJNA826497 11842 178 2.765517 4.92262026 Lacipirellulaceae bacterium 2691534 Bacteria Bacteria 53.9 1.8e-6   NR HVT27655.1 2691534 g11802 i0 52 0.842696629213483 50 23 84.3 1 151 2 364 412 HVT27655.1 hypothetical protein [Lacipirellulaceae bacterium] diamond 150 53.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae   Lacipirellulaceae bacterium
27939005 27939005 PRJNA826497_S_NODE_9605_length_189_cov_9.012821_g9565_i0 PRJNA826497 9605 189 9.012821 17.03423169 Maioricimonas sp. JB049 3342842 Bacteria Bacteria 49.7 6.22e-5   NR MFG0334810.1 3342842 g9565 i0 72.2 1.0952380952381 36 10 57.1 0 188 81 239 274 MFG0334810.1 Ty1/Copia family ribonuclease HI [Maioricimonas sp. JB049] diamond 207 49.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Maioricimonas Maioricimonas sp. JB049
28665205 28665205 PRJNA826497_S_NODE_16567_length_160_cov_2.582677_g16527_i0 PRJNA826497 16567 160 2.582677 4.1322832 Lacipirellulaceae bacterium 2691534 Bacteria Bacteria 72.4 4.14e-15   NR HVT27668.1 2691534 g16527 i0 77.1 0.9 48 10 90 1 17 160 1 47 HVT27668.1 hypothetical protein [Lacipirellulaceae bacterium] diamond 144 72.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae   Lacipirellulaceae bacterium
30496930 30496930 PRJNA826497_S_NODE_11653_length_179_cov_2.212329_g11613_i0 PRJNA826497 11653 179 2.212329 3.96006891 Lacipirellulaceae bacterium 2691534 Bacteria Bacteria 91.7 9.18e-20   NR HVT27657.1 2691534 g11613 i0 81 0.972067039106145 58 11 97.2 0 5 178 36 93 HVT27657.1 hypothetical protein [Lacipirellulaceae bacterium] diamond 174 91.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae   Lacipirellulaceae bacterium
30591547 30591547 PRJNA826497_S_NODE_14693_length_166_cov_3.669173_g14653_i0 PRJNA826497 14693 166 3.669173 6.09082718 Lacipirellulaceae bacterium 2691534 Bacteria Bacteria 57.8 6.32e-8   NR HVT27655.1 2691534 g14653 i0 60 0.993975903614458 55 21 97.6 1 164 3 419 473 HVT27655.1 hypothetical protein [Lacipirellulaceae bacterium] diamond 165 57.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae   Lacipirellulaceae bacterium
31286638 31286638 PRJNA826497_S_NODE_13035_length_173_cov_1.835714_g12995_i0 PRJNA826497 13035 173 1.835714 3.17578522 Lacipirellulaceae bacterium 2691534 Bacteria Bacteria 42 0.00401   NR HVT27675.1 2691534 g12995 i0 42 0.867052023121387 50 27 83.2 1 172 29 19 68 HVT27675.1 hypothetical protein [Lacipirellulaceae bacterium] diamond 150 42 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae   Lacipirellulaceae bacterium
31381801 31381801 PRJNA826497_S_NODE_1296_length_317_cov_5.123239_g1256_i0 PRJNA826497 1296 317 5.123239 16.24066763 Lacipirellulaceae bacterium 2691534 Bacteria Bacteria 95.1 3.62e-20   NR HVT27660.1 2691534 g1256 i0 82.4 0.482649842271293 51 9 48.3 0 154 2 1 51 HVT27660.1 hypothetical protein [Lacipirellulaceae bacterium] diamond 153 95.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae   Lacipirellulaceae bacterium
32552508 32552508 PRJNA826497_S_NODE_17879_length_156_cov_3.243902_g17839_i0 PRJNA826497 17879 156 3.243902 5.06048712 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.1 0.0018   NR HHI79518.1 2026780 g17839 i0 42.3 1 52 30 100 0 156 1 702 753 HHI79518.1 hypothetical protein [Planctomycetota bacterium] diamond 156 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32646371 32646371 PRJNA826497_S_NODE_4860_length_229_cov_2.045918_g4820_i0 PRJNA826497 4860 229 2.045918 4.68515222 Lacipirellulaceae bacterium 2691534 Bacteria Bacteria 129 3.41e-35   NR HVT27661.1 2691534 g4820 i0 82.7 0.982532751091703 75 13 98.3 0 227 3 18 92 HVT27661.1 hypothetical protein [Lacipirellulaceae bacterium] diamond 225 129 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae   Lacipirellulaceae 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);;