contig_metadata
20 rows where bioproject = "PRJNA489308", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1724915 | 1724915 | PRJNA489308_P_NODE_27982_length_258_cov_2.167568_g27906_i0 | PRJNA489308 | 27982 | 258 | 2.167568 | 5.59232544 | Verrucomicrobiales | 48461 | Bacteria | Bacteria | 87.4 | 4.38e-18 | NR | WP_379711123.1 | 1048331 | g27906 | i0 | 65.6 | 4.6046511627907 | 64 | 22 | 74.4 | 0 | 2 | 193 | 88 | 151 | WP_379711123.1 HAD-IB family phosphatase [Haloferula chungangensis] | diamond | 1188 | 88.2 | 0.99092970521542 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Haloferula | Haloferula chungangensis | |
| 9377915 | 9377915 | PRJNA489308_P_NODE_16248_length_306_cov_0.991416_g16172_i0 | PRJNA489308 | 16248 | 306 | 0.991416 | 3.03373296 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 566 | 8.239999999999998e-157 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g16172 | i0 | 100 | 277.408496732026 | 306 | 0 | 100 | 0 | 1 | 306 | 2335 | 2030 | Luteolibacter sp. SL250 chromosome | blastn | 84887 | 566 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 11928989 | 11928989 | PRJNA489308_P_NODE_5810_length_440_cov_3.114441_g5734_i0 | PRJNA489308 | 5810 | 440 | 3.114441 | 13.7035404 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 212 | 1.6200000000000003e-64 | NR | MEP6698099.1 | 2026799 | g5734 | i0 | 72.6 | 36.825 | 146 | 40 | 99.5 | 0 | 2 | 439 | 225 | 370 | MEP6698099.1 ADP-forming succinate--CoA ligase subunit beta [Verrucomicrobiota bacterium] | diamond | 16203 | 212 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 20851787 | 20851787 | PRJNA489308_P_NODE_20317_length_285_cov_2.905660_g20241_i0 | PRJNA489308 | 20317 | 285 | 2.90566 | 8.281131 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 136 | 5.96e-36 | NR | MBV9878042.1 | 2026799 | g20241 | i0 | 73.6 | 0.957894736842105 | 91 | 24 | 95.8 | 0 | 6 | 278 | 314 | 404 | MBV9878042.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Verrucomicrobiota bacterium] | diamond | 273 | 136 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 22126799 | 22126799 | PRJNA489308_P_NODE_7918_length_389_cov_1.357595_g7842_i0 | PRJNA489308 | 7918 | 389 | 1.357595 | 5.28104455 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 691 | 0 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g7842 | i0 | 98.715 | 287.030848329049 | 389 | 5 | 100 | 0 | 1 | 389 | 1023 | 635 | Luteolibacter sp. SL250 chromosome | blastn | 111655 | 691 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 23402432 | 23402432 | PRJNA489308_P_NODE_21359_length_281_cov_2.403846_g21283_i0 | PRJNA489308 | 21359 | 281 | 2.403846 | 6.75480726 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 497 | 2.77e-136 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g21283 | i0 | 98.577 | 275.693950177936 | 281 | 4 | 100 | 0 | 1 | 281 | 4716431 | 4716711 | Luteolibacter sp. SL250 chromosome | blastn | 77470 | 497 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 26727761 | 26727761 | PRJNA489308_P_NODE_40941_length_226_cov_2.013072_g40865_i0 | PRJNA489308 | 40941 | 226 | 2.013072 | 4.54954272 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 121 | 3.53e-31 | NR | RYD81270.1 | 2026800 | g40865 | i0 | 72.6 | 0.969026548672566 | 73 | 20 | 96.9 | 0 | 3 | 221 | 220 | 292 | RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium] | diamond | 219 | 121 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 27076345 | 27076345 | PRJNA489308_P_NODE_25902_length_265_cov_1.203125_g25826_i0 | PRJNA489308 | 25902 | 265 | 1.203125 | 3.18828125 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 93.2 | 6.27e-20 | NR | HEX4644544.1 | 2499141 | g25826 | i0 | 54.5 | 2.98867924528302 | 88 | 37 | 99.6 | 1 | 264 | 1 | 137 | 221 | HEX4644544.1 PhoPQ-activated protein PqaA family protein [Verrucomicrobiia bacterium] | diamond | 792 | 93.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 27471724 | 27471724 | PRJNA489308_P_NODE_10523_length_350_cov_2.194946_g10447_i0 | PRJNA489308 | 10523 | 350 | 2.194946 | 7.682311 | Termitidicoccus | 3126963 | Bacteria | Bacteria | 73.2 | 2.75e-12 | NR | WP_334319245.1 | 1184151 | g10447 | i0 | 73.9 | 4.68857142857143 | 46 | 12 | 39.4 | 0 | 346 | 209 | 779 | 824 | WP_334319245.1 FAD-dependent oxidoreductase [Termitidicoccus mucosus] | diamond | 1641 | 73.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Termitidicoccus | Termitidicoccus mucosus | |
| 27550199 | 27550199 | PRJNA489308_P_NODE_8424_length_379_cov_1.542484_g8348_i0 | PRJNA489308 | 8424 | 379 | 1.542484 | 5.84601436 | Verrucomicrobiota bacterium JB025 | 3064554 | Bacteria | Bacteria | 76.6 | 1.21e-13 | NR | MDP0505279.1 | 3064554 | g8348 | i0 | 58.1 | 0.490765171503958 | 62 | 24 | 49.1 | 1 | 379 | 194 | 261 | 320 | MDP0505279.1 aldo/keto reductase [Verrucomicrobiota bacterium JB025] | diamond | 186 | 76.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium JB025 | |||||
| 28466095 | 28466095 | PRJNA489308_P_NODE_11906_length_337_cov_1.090909_g11830_i0 | PRJNA489308 | 11906 | 337 | 1.090909 | 3.67636333 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 51.2 | 1.21e-4 | NR | MCI0537439.1 | 2026801 | g11830 | i0 | 32.1 | 0.970326409495549 | 109 | 59 | 97 | 4 | 1 | 327 | 896 | 989 | MCI0537439.1 protein kinase [Verrucomicrobiales bacterium] | diamond | 327 | 51.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 29444527 | 29444527 | PRJNA489308_P_NODE_6190_length_429_cov_1.730337_g6114_i0 | PRJNA489308 | 6190 | 429 | 1.730337 | 7.42314573 | Chthoniobacter sp. | 2510640 | Bacteria | Bacteria | 53.1 | 6.46e-5 | NR | MDR3401413.1 | 2510640 | g6114 | i0 | 42.3 | 0.496503496503497 | 71 | 27 | 49.7 | 2 | 212 | 424 | 676 | 732 | MDR3401413.1 RNase H-like domain-containing protein [Chthoniobacter sp.] | diamond | 213 | 53.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 29570913 | 29570913 | PRJNA489308_P_NODE_19250_length_290_cov_1.852535_g19174_i0 | PRJNA489308 | 19250 | 290 | 1.852535 | 5.3723515 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 105 | 8.05e-24 | NR | MBS0645922.1 | 2026799 | g19174 | i0 | 57.8 | 1.90344827586207 | 90 | 38 | 93.1 | 0 | 14 | 283 | 776 | 865 | MBS0645922.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 552 | 105 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31672587 | 31672587 | PRJNA489308_P_NODE_5077_length_466_cov_1.562341_g5001_i0 | PRJNA489308 | 5077 | 466 | 1.562341 | 7.28050906 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 87.4 | 1e-16 | NR | MEM8868505.1 | 2026799 | g5001 | i0 | 38.4 | 4.78326180257511 | 125 | 74 | 79.2 | 2 | 371 | 3 | 2 | 125 | MEM8868505.1 UTP--glucose-1-phosphate uridylyltransferase [Verrucomicrobiota bacterium] | diamond | 2229 | 87.8 | 0.995444191343964 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31751379 | 31751379 | PRJNA489308_P_NODE_15097_length_313_cov_1.283333_g15021_i0 | PRJNA489308 | 15097 | 313 | 1.283333 | 4.01683229 | Chthoniobacter flavus | 191863 | Bacteria | Bacteria | 47.4 | 0.00193 | NR | WP_006980619.1 | 191863 | g15021 | i0 | 31.3 | 0.766773162939297 | 80 | 44 | 76.7 | 1 | 302 | 63 | 1 | 69 | WP_006980619.1 AAA family ATPase [Chthoniobacter flavus] | diamond | 240 | 47.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter flavus | |
| 31751403 | 31751403 | PRJNA489308_P_NODE_40337_length_230_cov_2.681529_g40261_i0 | PRJNA489308 | 40337 | 230 | 2.681529 | 6.1675167 | Luteolibacter sp. Populi | 3230487 | Bacteria | Bacteria | 53.9 | 3.25e-6 | NR | WP_367873588.1 | 3230487 | g40261 | i0 | 46.7 | 0.782608695652174 | 60 | 30 | 75.7 | 1 | 189 | 16 | 215 | 274 | WP_367873588.1 choice-of-anchor A family protein [Luteolibacter sp. Populi] | diamond | 180 | 53.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. Populi | |
| 32036227 | 32036227 | PRJNA489308_P_NODE_8998_length_369_cov_3.912162_g8922_i0 | PRJNA489308 | 8998 | 369 | 3.912162 | 14.43587778 | Chthoniobacter sp. | 2510640 | Bacteria | Bacteria | 80.1 | 1.13e-14 | NR | MDR3405335.1 | 2510640 | g8922 | i0 | 84.4 | 0.365853658536585 | 45 | 7 | 36.6 | 0 | 3 | 137 | 420 | 464 | MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.] | diamond | 135 | 80.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 32162958 | 32162958 | PRJNA489308_P_NODE_15018_length_313_cov_2.029167_g14942_i0 | PRJNA489308 | 15018 | 313 | 2.029167 | 6.35129271 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 73.2 | 1.78e-12 | NR | MBI2925201.1 | 2026799 | g14942 | i0 | 43.6 | 0.968051118210863 | 101 | 45 | 94.9 | 5 | 12 | 308 | 2149 | 2239 | MBI2925201.1 carboxypeptidase regulatory-like domain-containing protein [Verrucomicrobiota bacterium] | diamond | 303 | 73.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32368918 | 32368918 | PRJNA489308_P_NODE_259_length_1395_cov_4.189107_g227_i0 | PRJNA489308 | 259 | 1395 | 4.189107 | 58.43804265 | Bacteria | 2 | Bacteria | Bacteria | 180 | 5.81e-47 | NR | MDA1065816.1 | 2026799 | g227 | i0 | 32.1 | 3.97204301075269 | 368 | 214 | 78.5 | 12 | 1382 | 288 | 163 | 497 | MDA1065816.1 bifunctional metallophosphatase/5'-nucleotidase [Verrucomicrobiota bacterium] | diamond | 5541 | 181 | 0.994475138121547 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32463739 | 32463739 | PRJNA489308_P_NODE_12199_length_334_cov_1.685824_g12123_i0 | PRJNA489308 | 12199 | 334 | 1.685824 | 5.63065216 | Bacteria | 2 | Bacteria | Bacteria | 81.3 | 1.47e-16 | NR | HYT56663.1 | 2499141 | g12123 | i0 | 72 | 2.2185628742515 | 50 | 14 | 44.9 | 0 | 185 | 334 | 2 | 51 | HYT56663.1 ATP-dependent protease subunit HslV [Verrucomicrobiia bacterium] | diamond | 741 | 81.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia 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);;