contig_metadata
25 rows where bioproject = "PRJNA541476", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6886810 | 6886810 | PRJNA541476_P_NODE_3946_length_579_cov_2.683794_g3751_i0 | PRJNA541476 | 3946 | 579 | 2.683794 | 15.53916726 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 286 | 1.41e-93 | NR | RYD65414.1 | 2026800 | g3751 | i0 | 71.5 | 1.99481865284974 | 193 | 52 | 99.5 | 2 | 577 | 2 | 138 | 328 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 1155 | 286 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 11321594 | 11321594 | PRJNA541476_P_NODE_23269_length_269_cov_1.469388_g23063_i0 | PRJNA541476 | 23269 | 269 | 1.469388 | 3.95265372 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 167 | 1.33e-50 | NR | MEC7288422.1 | 2026799 | g23063 | i0 | 92.1 | 1.98513011152416 | 89 | 7 | 99.3 | 0 | 3 | 269 | 87 | 175 | MEC7288422.1 B12-binding domain-containing protein [Verrucomicrobiota bacterium] | diamond | 534 | 167 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 11321625 | 11321625 | PRJNA541476_P_NODE_669_length_1375_cov_12.410138_g573_i0 | PRJNA541476 | 669 | 1375 | 12.410138 | 170.6393975 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 434 | 1.6399999999999995e-147 | NR | RYD65414.1 | 2026800 | g573 | i0 | 76.3 | 0.617454545454545 | 283 | 65 | 61.7 | 1 | 1041 | 193 | 56 | 336 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 849 | 434 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 14538050 | 14538050 | PRJNA541476_P_NODE_6332_length_449_cov_2.010638_g6129_i0 | PRJNA541476 | 6332 | 449 | 2.010638 | 9.02776462 | Bacteria | 2 | Bacteria | Bacteria | 178 | 4.98e-53 | NR | PYL92878.1 | 2026799 | g6129 | i0 | 60.5 | 11.7928730512249 | 147 | 58 | 98.2 | 0 | 6 | 446 | 48 | 194 | PYL92878.1 MAG: short chain dehydrogenase [Verrucomicrobiota bacterium] | diamond | 5295 | 178 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 17696480 | 17696480 | PRJNA541476_P_NODE_2214_length_796_cov_1.449516_g2038_i0 | PRJNA541476 | 2214 | 796 | 1.449516 | 11.53814736 | Opitutaceae | 134623 | Bacteria | Bacteria | 95.3 | 1.31e-14 | NTclustered | gi|573471959|gb|CP007053.1| | 794903 | g2038 | i0 | 76.087 | 19.0263819095477 | 184 | 42 | 23 | 2 | 465 | 647 | 2149300 | 2149118 | Opitutaceae bacterium TAV5, complete genome | blastn | 15145 | 95.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium TAV5 | ||
| 19635354 | 19635354 | PRJNA541476_P_NODE_4736_length_523_cov_5.204444_g4536_i0 | PRJNA541476 | 4736 | 523 | 5.204444 | 27.21924212 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 142 | 1.24e-37 | NR | RYD71398.1 | 2026800 | g4536 | i0 | 42 | 0.998087954110899 | 174 | 100 | 99.8 | 1 | 2 | 523 | 29 | 201 | RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] | diamond | 522 | 142 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 26776452 | 26776452 | PRJNA541476_P_NODE_22221_length_273_cov_1.290000_g22015_i0 | PRJNA541476 | 22221 | 273 | 1.29 | 3.5217 | Bacteria | 2 | Bacteria | Bacteria | 125 | 4.519999999999999e-31 | NR | MBI4662865.1 | 2026799 | g22015 | i0 | 62.5 | 5.23076923076923 | 80 | 30 | 87.9 | 0 | 268 | 29 | 3410 | 3489 | MBI4662865.1 amino acid adenylation domain-containing protein [Verrucomicrobiota bacterium] | diamond | 1428 | 125 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 26824870 | 26824870 | PRJNA541476_P_NODE_31061_length_250_cov_0.875706_g30855_i0 | PRJNA541476 | 31061 | 250 | 0.875706 | 2.189265 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 49.7 | 1.42e-4 | NR | HNQ91087.1 | 2026799 | g30855 | i0 | 67.9 | 0.336 | 28 | 9 | 33.6 | 0 | 224 | 141 | 185 | 212 | HNQ91087.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 84 | 49.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 26839857 | 26839857 | PRJNA541476_P_NODE_34641_length_246_cov_1.734104_g34435_i0 | PRJNA541476 | 34641 | 246 | 1.734104 | 4.26589584 | Bacteria | 2 | Bacteria | Bacteria | 46.2 | 0.00225 | NR | MEX2381968.1 | 2026772 | g34435 | i0 | 57.6 | 2.09756097560976 | 33 | 14 | 40.2 | 0 | 211 | 113 | 464 | 496 | MEX2381968.1 sulfatase-like hydrolase/transferase [Opitutales bacterium] | diamond | 516 | 46.6 | 0.991416309012876 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 27014532 | 27014532 | PRJNA541476_P_NODE_25682_length_261_cov_0.968085_g25476_i0 | PRJNA541476 | 25682 | 261 | 0.968085 | 2.52670185 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 119 | 3.68e-30 | NR | RYD84284.1 | 2026800 | g25476 | i0 | 70.6 | 0.977011494252874 | 85 | 25 | 97.7 | 0 | 259 | 5 | 137 | 221 | RYD84284.1 MAG: hypothetical protein EOP84_05935 [Verrucomicrobiaceae bacterium] | diamond | 255 | 119 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 27172488 | 27172488 | PRJNA541476_P_NODE_25542_length_261_cov_1.505319_g25336_i0 | PRJNA541476 | 25542 | 261 | 1.505319 | 3.92888259 | Cerasicoccus arenae | 424488 | Bacteria | Bacteria | 43.5 | 0.0244 | NR | WP_189512271.1 | 424488 | g25336 | i0 | 45.8 | 0.551724137931034 | 48 | 23 | 55.2 | 1 | 222 | 79 | 212 | 256 | WP_189512271.1 glycosyltransferase [Cerasicoccus arenae] | diamond | 144 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Cerasicoccaceae | Cerasicoccus | Cerasicoccus arenae | |
| 27741597 | 27741597 | PRJNA541476_P_NODE_40144_length_242_cov_0.917160_g39938_i0 | PRJNA541476 | 40144 | 242 | 0.91716 | 2.2195272 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 48.5 | 3.41e-4 | NR | MEZ5329470.1 | 2026801 | g39938 | i0 | 38.6 | 1.73553719008264 | 57 | 35 | 70.7 | 0 | 187 | 17 | 401 | 457 | MEZ5329470.1 tetratricopeptide repeat protein [Verrucomicrobiales bacterium] | diamond | 420 | 48.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 28120144 | 28120144 | PRJNA541476_P_NODE_725_length_1323_cov_4.904800_g488_i1 | PRJNA541476 | 725 | 1323 | 4.9048 | 64.890504 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 290 | 4.81e-91 | NR | RYD71398.1 | 2026800 | g488 | i1 | 45.1 | 0.804988662131519 | 355 | 182 | 79.1 | 6 | 106 | 1152 | 14 | 361 | RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] | diamond | 1065 | 290 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 28593843 | 28593843 | PRJNA541476_P_NODE_10687_length_351_cov_1.561151_g10481_i0 | PRJNA541476 | 10687 | 351 | 1.561151 | 5.47964001 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 177 | 8.670000000000002e-51 | NR | RYD76251.1 | 2026800 | g10481 | i0 | 73 | 0.982905982905983 | 115 | 31 | 98.3 | 0 | 349 | 5 | 80 | 194 | RYD76251.1 MAG: hypothetical protein EOP84_17160, partial [Verrucomicrobiaceae bacterium] | diamond | 345 | 177 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 28640391 | 28640391 | PRJNA541476_P_NODE_1707_length_907_cov_6.743405_g1550_i0 | PRJNA541476 | 1707 | 907 | 6.743405 | 61.16268335 | Bacteria | 2 | Bacteria | Bacteria | 258 | 5.25e-82 | NR | MEY4488007.1 | 2026799 | g1550 | i0 | 56.6 | 11.606394707828 | 249 | 103 | 81.7 | 2 | 821 | 81 | 11 | 256 | MEY4488007.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 10527 | 260 | 0.992307692307692 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28688698 | 28688698 | PRJNA541476_P_NODE_2027_length_828_cov_4.720530_g1857_i0 | PRJNA541476 | 2027 | 828 | 4.72053 | 39.0859884 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 265 | 5.540000000000001e-85 | NR | MEY4488007.1 | 2026799 | g1857 | i0 | 57.7 | 5.38768115942029 | 246 | 103 | 88.8 | 1 | 742 | 8 | 11 | 256 | MEY4488007.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 4461 | 265 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28877810 | 28877810 | PRJNA541476_P_NODE_16248_length_301_cov_2.289474_g16042_i0 | PRJNA541476 | 16248 | 301 | 2.289474 | 6.89131674 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 106 | 5.78e-25 | NR | RYD84284.1 | 2026800 | g16042 | i0 | 73 | 0.737541528239203 | 74 | 19 | 73.8 | 1 | 224 | 3 | 62 | 134 | RYD84284.1 MAG: hypothetical protein EOP84_05935 [Verrucomicrobiaceae bacterium] | diamond | 222 | 106 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 29130685 | 29130685 | PRJNA541476_P_NODE_4829_length_518_cov_4.177528_g4629_i0 | PRJNA541476 | 4829 | 518 | 4.177528 | 21.63959504 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 185 | 2.7099999999999992e-55 | NR | MEY4488007.1 | 2026799 | g4629 | i0 | 58.8 | 0.984555984555985 | 170 | 70 | 98.5 | 0 | 516 | 7 | 84 | 253 | MEY4488007.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 510 | 185 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29871673 | 29871673 | PRJNA541476_P_NODE_10571_length_352_cov_4.286738_g10365_i0 | PRJNA541476 | 10571 | 352 | 4.286738 | 15.08931776 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 117 | 2.07e-29 | NR | MCS7091105.1 | 2838792 | g10365 | i0 | 67.5 | 4.58522727272727 | 83 | 26 | 70.7 | 1 | 104 | 352 | 104 | 185 | MCS7091105.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Limisphaera sp.] | diamond | 1614 | 117 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Limisphaeraceae | Limisphaera | Limisphaera sp. | |
| 30551657 | 30551657 | PRJNA541476_P_NODE_22573_length_271_cov_5.005051_g22367_i0 | PRJNA541476 | 22573 | 271 | 5.005051 | 13.56368821 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 81.3 | 6.64e-17 | NR | RYD70704.1 | 2026800 | g22367 | i0 | 56.6 | 0.841328413284133 | 76 | 33 | 84.1 | 0 | 44 | 271 | 6 | 81 | RYD70704.1 MAG: hypothetical protein EOP84_26230 [Verrucomicrobiaceae bacterium] | diamond | 228 | 81.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 30836143 | 30836143 | PRJNA541476_P_NODE_14254_length_315_cov_1.334711_g14048_i0 | PRJNA541476 | 14254 | 315 | 1.334711 | 4.20433965 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 48.5 | 7.88e-4 | NR | MEY5011675.1 | 2026799 | g14048 | i0 | 47.2 | 0.504761904761905 | 53 | 27 | 49.5 | 1 | 20 | 175 | 412 | 464 | MEY5011675.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 159 | 48.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31120217 | 31120217 | PRJNA541476_P_NODE_575_length_1462_cov_3.844492_g488_i0 | PRJNA541476 | 575 | 1462 | 3.844492 | 56.20647304 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 287 | 3.16e-89 | NR | RYD71398.1 | 2026800 | g488 | i0 | 44.8 | 0.728454172366621 | 355 | 183 | 71.6 | 6 | 1357 | 311 | 14 | 361 | RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] | diamond | 1065 | 287 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31183439 | 31183439 | PRJNA541476_P_NODE_22755_length_271_cov_1.272727_g22549_i0 | PRJNA541476 | 22755 | 271 | 1.272727 | 3.44909017 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 107 | 1.28e-26 | NR | RYD36583.1 | 2026800 | g22549 | i0 | 52.2 | 0.996309963099631 | 90 | 43 | 99.6 | 0 | 270 | 1 | 70 | 159 | RYD36583.1 MAG: Mpv17/PMP22 family protein [Verrucomicrobiaceae bacterium] | diamond | 270 | 107 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 32322857 | 32322857 | PRJNA541476_P_NODE_3039_length_670_cov_2.093802_g2848_i0 | PRJNA541476 | 3039 | 670 | 2.093802 | 14.0284734 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 194 | 5.69e-58 | NR | MEY4488007.1 | 2026799 | g2848 | i0 | 54.1 | 4.07014925373134 | 181 | 82 | 80.6 | 1 | 665 | 126 | 76 | 256 | MEY4488007.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 2727 | 194 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32480902 | 32480902 | PRJNA541476_P_NODE_4379_length_547_cov_6.736287_g4183_i0 | PRJNA541476 | 4379 | 547 | 6.736287 | 36.84748989 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 211 | 2.6200000000000002e-65 | NR | HEY2344067.1 | 2811408 | g4183 | i0 | 60.9 | 17.6654478976234 | 179 | 70 | 98.2 | 0 | 5 | 541 | 17 | 195 | HEY2344067.1 glucose 1-dehydrogenase [Chthoniobacteraceae bacterium] | diamond | 9663 | 211 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;