RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA1167252", 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 · 20 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 20 ✖

bioproject 1

  • PRJNA1167252 · 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
1589263 1589263 PRJNA1167252_P_NODE_25302_length_249_cov_0.886364_g25029_i0 PRJNA1167252 25302 249 0.886364 2.20704636 Bacteria 2 Bacteria Bacteria 131 1.31e-34   NR NOS69166.1 2026799 g25029 i0 80 6.7710843373494 80 16 96.4 0 9 248 277 356 NOS69166.1 M20 family metallopeptidase [Verrucomicrobiota bacterium] diamond 1686 131 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
7417847 7417847 PRJNA1167252_P_NODE_27706_length_245_cov_0.906977_g27433_i0 PRJNA1167252 27706 245 0.906977 2.22209365 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 87 3.96e-19   NR MEI6466272.1 2026799 g27433 i0 71.2 0.722448979591837 59 15 69.8 1 244 74 135 193 MEI6466272.1 outer membrane lipoprotein-sorting protein [Verrucomicrobiota bacterium] diamond 177 87 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
21991251 21991251 PRJNA1167252_P_NODE_25638_length_248_cov_0.891429_g25365_i0 PRJNA1167252 25638 248 0.891429 2.21074392 Puniceicoccaceae bacterium 2026784 Bacteria Bacteria 95.9 8.16e-21   NR MEX0331903.1 2026784 g25365 i0 63.3 0.955645161290323 79 22 95.6 2 239 3 4683 4754 MEX0331903.1 hypothetical protein [Puniceicoccaceae bacterium] diamond 237 95.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Puniceicoccaceae   Puniceicoccaceae bacterium
23992178 23992178 PRJNA1167252_P_NODE_27439_length_245_cov_0.906977_g27166_i0 PRJNA1167252 27439 245 0.906977 2.22209365 Akkermansia 239934 Bacteria Bacteria 187 5.809999999999998e-43   NTclustered gi|1805960388|gb|CP029703.1| 239935 g27166 i0 100 41.2448979591837 101 0 41 0 145 245 2325800 2325700 Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome blastn 10105 187 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia muciniphila
27008682 27008682 PRJNA1167252_P_NODE_24762_length_250_cov_0.881356_g24489_i0 PRJNA1167252 24762 250 0.881356 2.20339 Opitutaceae bacterium 2006848 Bacteria Bacteria 65.9 2.99e-10   NR MBC7369635.1 2006848 g24489 i0 51.7 1.044 87 37 99.6 2 250 2 477 562 MBC7369635.1 immunoglobulin domain-containing protein [Opitutaceae bacterium] diamond 261 65.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
27312831 27312831 PRJNA1167252_P_NODE_24223_length_251_cov_0.876404_g23950_i0 PRJNA1167252 24223 251 0.876404 2.19977404 Pseudomonadati 3379134 Bacteria Bacteria 120 9.75e-30   NR WP_108824930.1 1796921 g23950 i0 74.7 6.89641434262948 79 20 94.4 0 239 3 343 421 WP_108824930.1 sialate O-acetylesterase [Ereboglobus luteus] diamond 1731 120 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Ereboglobus Ereboglobus luteus
27470677 27470677 PRJNA1167252_P_NODE_24123_length_251_cov_0.876404_g23850_i0 PRJNA1167252 24123 251 0.876404 2.19977404 Luteolibacter 518753 Bacteria Bacteria 129 3.22e-34   NR RYD45272.1 2026800 g23850 i0 77.1 2.97609561752988 83 19 99.2 0 250 2 178 260 RYD45272.1 MAG: tetratricopeptide repeat protein, partial [Verrucomicrobiaceae bacterium] diamond 747 130 0.992307692307692 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
27767290 27767290 PRJNA1167252_P_NODE_25324_length_249_cov_0.886364_g25051_i0 PRJNA1167252 25324 249 0.886364 2.20704636 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 85.5 2.47e-18   NR MBM3837846.1 2026799 g25051 i0 50.6 8.98795180722892 83 38 98.8 2 247 2 73 153 MBM3837846.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 2238 85.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28070421 28070421 PRJNA1167252_P_NODE_27465_length_245_cov_0.906977_g27192_i0 PRJNA1167252 27465 245 0.906977 2.22209365 PVC group 1783257 Bacteria Bacteria 98.6 1.85e-22   NR MEI6084343.1 2026799 g27192 i0 63.8 4.89795918367347 80 29 98 0 3 242 246 325 MEI6084343.1 glycosyltransferase [Verrucomicrobiota bacterium] diamond 1200 99 0.995959595959596 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28272047 28272047 PRJNA1167252_P_NODE_24166_length_251_cov_0.876404_g23893_i0 PRJNA1167252 24166 251 0.876404 2.19977404 Opitutaceae bacterium 2006848 Bacteria Bacteria 95.5 1.14e-20   NR HVU35935.1 2006848 g23893 i0 64.6 2.9402390438247 82 29 98 0 249 4 369 450 HVU35935.1 PAS domain-containing protein [Opitutaceae bacterium] diamond 738 95.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
28366838 28366838 PRJNA1167252_P_NODE_29266_length_242_cov_0.923077_g28993_i0 PRJNA1167252 29266 242 0.923077 2.23384634 Prosthecobacter sp. 1965333 Bacteria Bacteria 138 2.42e-37   NR MDZ4287378.1 1965333 g28993 i0 86.3 0.991735537190083 80 11 99.2 0 1 240 125 204 MDZ4287378.1 S41 family peptidase [Prosthecobacter sp.] diamond 240 138 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp.
29030263 29030263 PRJNA1167252_P_NODE_28668_length_243_cov_0.917647_g28395_i0 PRJNA1167252 28668 243 0.917647 2.22988221 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 61.6 1.27e-9   NR MBS0620197.1 2026799 g28395 i0 47.6 1.60493827160494 63 32 76.5 1 54 239 4 66 MBS0620197.1 DUF5399 family protein [Verrucomicrobiota bacterium] diamond 390 61.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29598022 29598022 PRJNA1167252_P_NODE_25590_length_248_cov_0.891429_g25317_i0 PRJNA1167252 25590 248 0.891429 2.21074392 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 81.6 7.1e-16   NR MEI7728034.1 2026799 g25317 i0 45.1 0.991935483870968 82 45 99.2 0 248 3 155 236 MEI7728034.1 twin-arginine translocase subunit TatC [Verrucomicrobiota bacterium] diamond 246 81.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29692750 29692750 PRJNA1167252_P_NODE_23370_length_252_cov_0.871508_g23097_i0 PRJNA1167252 23370 252 0.871508 2.19620016 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 89.7 1.78e-20   NR MDF1824832.1 2026801 g23097 i0 83.7 1.08333333333333 49 8 58.3 0 147 1 1 49 MDF1824832.1 thioredoxin domain-containing protein [Verrucomicrobiales bacterium] diamond 273 89.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
30956962 30956962 PRJNA1167252_P_NODE_28754_length_243_cov_0.917647_g28481_i0 PRJNA1167252 28754 243 0.917647 2.22988221 Puniceicoccaceae bacterium 2026784 Bacteria Bacteria 68.9 2.24e-11   NR MEX0330447.1 2026784 g28481 i0 50 0.740740740740741 60 30 74.1 0 191 12 1152 1211 MEX0330447.1 cadherin-like domain-containing protein [Puniceicoccaceae bacterium] diamond 180 68.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Puniceicoccaceae   Puniceicoccaceae bacterium
31114514 31114514 PRJNA1167252_P_NODE_23835_length_251_cov_0.876404_g23562_i0 PRJNA1167252 23835 251 0.876404 2.19977404 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 61.2 1.14e-8   NR MBI5800787.1 2026799 g23562 i0 53.5 0.51394422310757 43 20 51.4 0 3 131 316 358 MBI5800787.1 glycosyltransferase [Verrucomicrobiota bacterium] diamond 129 61.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31620684 31620684 PRJNA1167252_P_NODE_26256_length_247_cov_0.896552_g25983_i0 PRJNA1167252 26256 247 0.896552 2.21448344 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 88.6 2.56e-18   NR HEY4415696.1 2499141 g25983 i0 78.8 0.631578947368421 52 11 63.2 0 157 2 1 52 HEY4415696.1 F0F1 ATP synthase subunit beta [Verrucomicrobiia bacterium] diamond 156 88.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
32285438 32285438 PRJNA1167252_P_NODE_28219_length_244_cov_0.912281_g27946_i0 PRJNA1167252 28219 244 0.912281 2.22596564 Limisphaerales bacterium 2052186 Bacteria Bacteria 145 4e-38   NR MCI0745318.1 2052186 g27946 i0 85.2 0.995901639344262 81 12 99.6 0 244 2 914 994 MCI0745318.1 autotransporter-associated beta strand repeat-containing protein [Limisphaerales bacterium] diamond 243 145 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Limisphaerales     Limisphaerales bacterium
32506797 32506797 PRJNA1167252_P_NODE_25339_length_249_cov_0.886364_g25066_i0 PRJNA1167252 25339 249 0.886364 2.20704636 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 160 9.86e-44   NR MBI2925441.1 2026799 g25066 i0 85.4 0.987951807228916 82 12 98.8 0 3 248 282 363 MBI2925441.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 246 160 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32664142 32664142 PRJNA1167252_P_NODE_17960_length_288_cov_1.223256_g17687_i0 PRJNA1167252 17960 288 1.223256 3.52297728 Akkermansia sp. 1872421 Bacteria Bacteria 181 9.76e-53   NR MCI7698201.1 1872421 g17687 i0 93.7 0.989583333333333 95 6 99 0 287 3 346 440 MCI7698201.1 MATE family efflux transporter [Akkermansia sp.] diamond 285 181 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia sp.

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);;