RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA857143", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 21 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 21 ✖

bioproject 1

  • PRJNA857143 · 21 ✖
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
2119628 2119628 PRJNA857143_S_NODE_57562_length_378_cov_3.983607_g56469_i0 PRJNA857143 57562 378 3.983607 15.05803446 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 138 5.950000000000001e-36   NR MFM1943047.1 2026799 g56469 i0 75.9 7.25396825396825 83 20 65.9 0 378 130 369 451 MFM1943047.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 2742 138 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
16537881 16537881 PRJNA857143_S_NODE_140733_length_274_cov_1.164179_g139640_i0 PRJNA857143 140733 274 1.164179 3.18985046 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 63.5 9.68e-11   NR MBU4211685.1 2026799 g139640 i0 88.6 4.29197080291971 35 4 38.3 0 169 273 3 37 MBU4211685.1 type I glyceraldehyde-3-phosphate dehydrogenase [Verrucomicrobiota bacterium] diamond 1176 63.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
18694769 18694769 PRJNA857143_S_NODE_15995_length_573_cov_3.306000_g14935_i0 PRJNA857143 15995 573 3.306 18.94338 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 760 0   NTclustered gi|2874254096|emb|OY970179.1| 412056 g14935 i0 90.592 115.401396160558 574 52 100 2 1 573 1727355 1727927 MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1 blastn 66125 760 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
19086865 19086865 PRJNA857143_S_NODE_67955_length_358_cov_2.189474_g66862_i0 PRJNA857143 67955 358 2.189474 7.83831692 Opitutus 178440 Bacteria Bacteria 590 5.8099999999999986e-164   NTclustered gi|470483113|ref|NR_076574.1| 107709 g66862 i0 96.389 98.108938547486 360 9 100 4 1 358 1028 671 Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence blastn 35123 595 0.991596638655462 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus terrae
21245977 21245977 PRJNA857143_S_NODE_2097_length_1157_cov_4.687269_g249_i1 PRJNA857143 2097 1157 4.687269 54.23170233 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 1482 0   NTclustered gi|2874253690|emb|OY969416.1| 412056 g249 i1 90.297 253.509075194468 1144 93 98 17 25 1157 1314920 1316056 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 293310 1482 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
21246090 21246090 PRJNA857143_S_NODE_337_length_1898_cov_3.467945_g249_i0 PRJNA857143 337 1898 3.467945 65.8215961 Pedosphaera parvula 1032527 Bacteria Bacteria 2248 0   NTclustered gi|183579829|emb|AM905426.1| 320771 g249 i0 88.49 259.27133825079 1894 173 99 43 29 1898 1 1873 Bacterium Ellin514 23S rRNA gene, isolate Ellin514 blastn 492097 2248 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Pedosphaerae Pedosphaerales Pedosphaeraceae Pedosphaera Pedosphaera parvula
23795084 23795084 PRJNA857143_S_NODE_110299_length_302_cov_1.362445_g109206_i0 PRJNA857143 110299 302 1.362445 4.1145839 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 411 4.0299999999999996e-110   NTclustered gi|2874253690|emb|OY969416.1| 412056 g109206 i0 93.214 106.08940397351 280 18 93 1 23 302 1314920 1315198 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 32039 411 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
25069891 25069891 PRJNA857143_S_NODE_196940_length_238_cov_2.266667_g195847_i0 PRJNA857143 196940 238 2.266667 5.39466746 Bacteria 2 Bacteria Bacteria 117 2.7e-30   NR WP_185693524.1 388746 g195847 i0 70.1 15.3403361344538 77 23 97.1 0 238 8 173 249 WP_185693524.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Puniceicoccus vermicola] diamond 3651 117 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Puniceicoccaceae Puniceicoccus Puniceicoccus vermicola
25070194 25070194 PRJNA857143_S_NODE_45540_length_408_cov_1.417910_g44447_i0 PRJNA857143 45540 408 1.41791 5.7850728 Fontisphaera persica 2974023 Bacteria Bacteria 412 1.5599999999999998e-110   NTclustered gi|2439237958|gb|CP116615.1| 2974023 g44447 i0 85.024 60.5882352941176 414 52 100 7 1 408 3862473 3862882 Fontisphaera persica strain B-154 chromosome, complete genome blastn 24720 412 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Limisphaerales Fontisphaeraceae Fontisphaera Fontisphaera persica
27402828 27402828 PRJNA857143_S_NODE_171803_length_252_cov_0.871508_g170710_i0 PRJNA857143 171803 252 0.871508 2.19620016 Akkermansia sp. 1872421 Bacteria Bacteria 52.8 7.01e-6   NR MBQ4636859.1 1872421 g170710 i0 34.4 2.94047619047619 93 49 96.4 1 5 247 88 180 MBQ4636859.1 ankyrin repeat domain-containing protein [Akkermansia sp.] diamond 741 52.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia sp.
27560409 27560409 PRJNA857143_S_NODE_157464_length_261_cov_1.244681_g156371_i0 PRJNA857143 157464 261 1.244681 3.24861741 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 79 8.32e-15   NR MDE3046018.1 2026799 g156371 i0 51.2 0.96551724137931 84 31 96.6 2 3 254 590 663 MDE3046018.1 endopeptidase La [Verrucomicrobiota bacterium] diamond 252 79 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27592353 27592353 PRJNA857143_S_NODE_54244_length_386_cov_1.214058_g53151_i0 PRJNA857143 54244 386 1.214058 4.68626388 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 60.5 3.98e-8   NR MEN9285850.1 2026799 g53151 i0 31.9 1.09585492227979 141 53 88.6 6 353 12 81 205 MEN9285850.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 423 60.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28665818 28665818 PRJNA857143_S_NODE_82507_length_335_cov_2.022901_g81414_i0 PRJNA857143 82507 335 2.022901 6.77671835 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 84 1.42e-16   NR MDA1276059.1 2026799 g81414 i0 56.5 1.85373134328358 69 30 61.8 0 332 126 251 319 MDA1276059.1 phosphonoacetaldehyde hydrolase [Verrucomicrobiota bacterium] diamond 621 84 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28823283 28823283 PRJNA857143_S_NODE_169988_length_253_cov_0.866667_g168895_i0 PRJNA857143 169988 253 0.866667 2.19266751 Opitutus sp. 1913982 Bacteria Bacteria 89.4 1.11e-19   NR MSU65157.1 1913982 g168895 i0 57.7 0.924901185770751 78 33 92.5 0 236 3 85 162 MSU65157.1 hypothetical protein [Opitutus sp.] diamond 234 89.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus sp.
29400031 29400031 PRJNA857143_S_NODE_113949_length_298_cov_1.928889_g112856_i0 PRJNA857143 113949 298 1.928889 5.74808922 PVC group 1783257 Bacteria Bacteria 43.1 0.0232   NR MDB4693755.1 2562705 g112856 i0 85 1.40939597315436 20 3 20.1 0 296 237 129 148 MDB4693755.1 adenosylhomocysteinase [Akkermansiaceae bacterium] diamond 420 43.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae bacterium
30118138 30118138 PRJNA857143_S_NODE_18512_length_545_cov_3.533898_g17440_i0 PRJNA857143 18512 545 3.533898 19.2597441 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 59.3 1.01e-7   NR MEI8342374.1 2026799 g17440 i0 34.7 2.03119266055046 95 59 51.7 2 530 249 35 127 MEI8342374.1 cystatin domain-containing protein [Verrucomicrobiota bacterium] diamond 1107 59.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30403065 30403065 PRJNA857143_S_NODE_180353_length_248_cov_1.337143_g179260_i0 PRJNA857143 180353 248 1.337143 3.31611464 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 94.4 2.64e-20   NR MBU6383609.1 2026799 g179260 i0 50 3 82 41 99.2 0 247 2 493 574 MBU6383609.1 arginine--tRNA ligase [Verrucomicrobiota bacterium] diamond 744 94.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31223916 31223916 PRJNA857143_S_NODE_110175_length_302_cov_1.641921_g109082_i0 PRJNA857143 110175 302 1.641921 4.95860142 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 158 1.2e-42   NR HOX55722.1 2026799 g109082 i0 71 2.98013245033113 100 29 99.3 0 3 302 498 597 HOX55722.1 glycoside hydrolase [Verrucomicrobiota bacterium] diamond 900 158 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31382393 31382393 PRJNA857143_S_NODE_89136_length_326_cov_2.458498_g88043_i0 PRJNA857143 89136 326 2.458498 8.01470348 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 45.1 0.0151   NR MBS0655012.1 2026799 g88043 i0 54.5 0.303680981595092 33 15 30.4 0 2 100 816 848 MBS0655012.1 endopeptidase La [Verrucomicrobiota bacterium] diamond 99 45.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31580358 31580358 PRJNA857143_S_NODE_142056_length_273_cov_1.170000_g140963_i0 PRJNA857143 142056 273 1.17 3.1941 Bacteria 2 Bacteria Bacteria 125 6.73e-34   NR MEI6075775.1 2026799 g140963 i0 71.4 3.97802197802198 91 26 100 0 1 273 18 108 MEI6075775.1 trimeric intracellular cation channel family protein [Verrucomicrobiota bacterium] diamond 1086 125 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32741972 32741972 PRJNA857143_S_NODE_32600_length_453_cov_2.576316_g31508_i0 PRJNA857143 32600 453 2.576316 11.67071148 Terrimicrobiaceae bacterium 2832348 Bacteria Bacteria 107 5.41e-24   NR MEX1117692.1 2832348 g31508 i0 63.2 3.0794701986755 76 28 50.3 0 2 229 365 440 MEX1117692.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Terrimicrobiaceae bacterium] diamond 1395 107 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Terrimicrobiia Terrimicrobiales Terrimicrobiaceae   Terrimicrobiaceae 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);;