contig_metadata
26 rows where bioproject = "PRJNA846110" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 833029 | 833029 | PRJNA846110_P_NODE_17901_length_273_cov_2.280000_g17656_i0 | PRJNA846110 | 17901 | 273 | 2.28 | 6.2244 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 272 | 1.77e-68 | NTclustered | gi|2914988762|gb|OR222153.1| | 2832643 | g17656 | i0 | 84.615 | 3.01098901098901 | 273 | 42 | 100 | 0 | 1 | 273 | 37741 | 38013 | MAG: Caudoviricetes sp. isolate MSP0823 genomic sequence | blastn | 822 | 272 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1231290 | 1231290 | PRJNA846110_P_NODE_18561_length_270_cov_1.563452_g18316_i0 | PRJNA846110 | 18561 | 270 | 1.563452 | 4.2213204 | Hennigervirus | 3424959 | Viruses | Viruses | 494 | 3.4199999999999996e-135 | NTclustered | gi|1842037666|ref|NC_048200.1| | 1729933 | g18316 | i0 | 99.63 | 35.2481481481481 | 270 | 1 | 100 | 0 | 1 | 270 | 11231 | 11500 | Pseudomonas phage shl2 genome assembly, chromosome: 1 | blastn | 9517 | 494 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autotranscriptaviridae | Hennigervirus | Hennigervirus shl2 | ||
| 3783194 | 3783194 | PRJNA846110_P_NODE_23783_length_249_cov_2.232955_g23538_i0 | PRJNA846110 | 23783 | 249 | 2.232955 | 5.56005795 | Marchewkavirus | 3425052 | Viruses | Viruses | 357 | 4.2599999999999997e-94 | NTclustered | gi|2264473600|gb|ON529851.1| | 2948604 | g23538 | i0 | 93.361 | 7.93172690763052 | 241 | 16 | 97 | 0 | 9 | 249 | 47300 | 47060 | Brevundimonas phage vB_BpoS-Marchewka, complete genome | blastn | 1975 | 357 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Jeanschmidtviridae | Marchewkavirus | Marchewkavirus marchewka | |||
| 4661509 | 4661509 | PRJNA846110_P_NODE_25704_length_247_cov_0.885057_g25459_i0 | PRJNA846110 | 25704 | 247 | 0.885057 | 2.18609079 | Pseudomonas phage pPa_SNUABM_DT | 2820398 | Viruses | Viruses | 124 | 5.88e-31 | NR | QTH80393.1 | 2820398 | g25459 | i0 | 75.3 | 0.983805668016194 | 81 | 20 | 98.4 | 0 | 246 | 4 | 72 | 152 | QTH80393.1 hypothetical protein PA10_00195 [Pseudomonas phage pPa_SNUABM_DT01] | diamond | 243 | 124 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage pPa_SNUABM_DT01 | |||||
| 5936185 | 5936185 | PRJNA846110_P_NODE_19105_length_267_cov_2.577320_g18860_i0 | PRJNA846110 | 19105 | 267 | 2.57732 | 6.8814444 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 416 | 7.519999999999998e-112 | NTclustered | gi|2053083540|tpg|BK020145.1| | 2832643 | g18860 | i0 | 94.757 | 3.00374531835206 | 267 | 14 | 100 | 0 | 1 | 267 | 4164 | 3898 | MAG TPA_asm: Caudoviricetes sp. isolate ctnvU3, partial genome | blastn | 802 | 416 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8485978 | 8485978 | PRJNA846110_P_NODE_30347_length_241_cov_0.916667_g30102_i0 | PRJNA846110 | 30347 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 412 | 8.64e-111 | NTclustered | gi|2914947028|gb|OR221843.1| | 2832643 | g30102 | i0 | 97.51 | 1 | 241 | 6 | 100 | 0 | 1 | 241 | 10780 | 11020 | MAG: Caudoviricetes sp. isolate MSP1171 genomic sequence | blastn | 241 | 412 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12312215 | 12312215 | PRJNA846110_P_NODE_24650_length_248_cov_1.308571_g24405_i0 | PRJNA846110 | 24650 | 248 | 1.308571 | 3.24525608 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 394 | 3.24e-105 | NTclustered | gi|2914938176|gb|OR221695.1| | 2832643 | g24405 | i0 | 95.528 | 1.98387096774194 | 246 | 11 | 99 | 0 | 1 | 246 | 17036 | 17281 | MAG: Caudoviricetes sp. isolate MSP1344 genomic sequence | blastn | 492 | 394 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14861047 | 14861047 | PRJNA846110_P_NODE_29192_length_242_cov_0.911243_g28947_i0 | PRJNA846110 | 29192 | 242 | 0.911243 | 2.20520806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 442 | 1.1099999999999995e-119 | NTclustered | gi|2914751570|gb|OR221330.1| | 2832643 | g28947 | i0 | 99.587 | 1 | 242 | 1 | 100 | 0 | 1 | 242 | 22311 | 22070 | MAG: Caudoviricetes sp. isolate MSP1779 genomic sequence | blastn | 242 | 442 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15259282 | 15259282 | PRJNA846110_P_NODE_16432_length_280_cov_2.608696_g16187_i0 | PRJNA846110 | 16432 | 280 | 2.608696 | 7.3043488 | Pahexavirus | 1982251 | Viruses | Viruses | 409 | 1.33e-109 | NTclustered | gi|849122467|ref|NC_027401.1| | 1500814 | g16187 | i0 | 93.165 | 99.7178571428571 | 278 | 19 | 99 | 0 | 2 | 279 | 2805 | 2528 | Propionibacterium phage PHL095N00, complete genome | blastn | 27921 | 409 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL095N00 | ||||
| 16135844 | 16135844 | PRJNA846110_P_NODE_30373_length_241_cov_0.886905_g30128_i0 | PRJNA846110 | 30373 | 241 | 0.886905 | 2.13744105 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 285 | 1.96e-72 | NTclustered | gi|2058038123|tpg|BK042290.1| | 2832643 | g30128 | i0 | 87.967 | 1 | 241 | 29 | 100 | 0 | 1 | 241 | 155482 | 155242 | MAG TPA_asm: Caudoviricetes sp. isolate ctZEn3, partial genome | blastn | 241 | 285 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18684425 | 18684425 | PRJNA846110_P_NODE_30135_length_241_cov_0.916667_g29890_i0 | PRJNA846110 | 30135 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 440 | 3.959999999999999e-119 | NTclustered | gi|2053025026|tpg|BK023955.1| | 2832643 | g29890 | i0 | 99.585 | 19.0414937759336 | 241 | 1 | 100 | 0 | 1 | 241 | 15824 | 16064 | MAG TPA_asm: Caudoviricetes sp. isolate ctWEw2, partial genome | blastn | 4589 | 440 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19959456 | 19959456 | PRJNA846110_P_NODE_21716_length_254_cov_2.276243_g21471_i0 | PRJNA846110 | 21716 | 254 | 2.276243 | 5.78165722 | Serratia phage WSPA | 3384840 | Viruses | Viruses | 470 | 5.37e-128 | NTclustered | gi|2905000930|gb|PQ600363.1| | 3384840 | g21471 | i0 | 100 | 2.47637795275591 | 254 | 0 | 100 | 0 | 1 | 254 | 65451 | 65198 | Serratia phage WSPA, partial genome | blastn | 629 | 470 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Muldoonvirus | Serratia phage WSPA | ||||
| 21235080 | 21235080 | PRJNA846110_P_NODE_18617_length_270_cov_1.294416_g18372_i0 | PRJNA846110 | 18617 | 270 | 1.294416 | 3.4949232 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 499 | 7.349999999999998e-137 | NTclustered | gi|2914941530|gb|OR221752.1| | 2832643 | g18372 | i0 | 100 | 1 | 270 | 0 | 100 | 0 | 1 | 270 | 38956 | 38687 | MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence | blastn | 270 | 499 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25059168 | 25059168 | PRJNA846110_P_NODE_15540_length_285_cov_1.155660_g15295_i0 | PRJNA846110 | 15540 | 285 | 1.15566 | 3.293631 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 185 | 2.4899999999999998e-42 | NTclustered | gi|2054478271|tpg|BK031892.1| | 2832643 | g15295 | i0 | 82.096 | 0.929824561403509 | 229 | 29 | 77 | 6 | 1 | 220 | 9057 | 8832 | MAG TPA_asm: Caudoviricetes sp. isolate ctCd92, partial genome | blastn | 265 | 185 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26991226 | 26991226 | PRJNA846110_P_NODE_24202_length_249_cov_0.875000_g23957_i0 | PRJNA846110 | 24202 | 249 | 0.875 | 2.17875 | Pantoea phage Survivor | 3232176 | Viruses | Viruses | 124 | 5.54e-32 | NR | XCN28360.1 | 3232176 | g23957 | i0 | 72.3 | 2 | 83 | 23 | 100 | 0 | 249 | 1 | 5 | 87 | XCN28360.1 hypothetical protein [Pantoea phage Survivor] | diamond | 498 | 124 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantoea phage Survivor | |||||
| 27244361 | 27244361 | PRJNA846110_P_NODE_13383_length_299_cov_2.738938_g13138_i0 | PRJNA846110 | 13383 | 299 | 2.738938 | 8.18942462 | Pantoea phage Nufs112 | 2894290 | Viruses | Viruses | 67 | 1.38e-11 | NR | UJH95866.1 | 2894290 | g13138 | i0 | 63.3 | 0.491638795986622 | 49 | 18 | 49.2 | 0 | 151 | 297 | 70 | 118 | UJH95866.1 recombination endonuclease VII [Pantoea phage Nufs112] | diamond | 147 | 67 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Hapakavirus | Hapakavirus Nufs112 | |||
| 27781419 | 27781419 | PRJNA846110_P_NODE_15424_length_285_cov_1.858491_g15179_i0 | PRJNA846110 | 15424 | 285 | 1.858491 | 5.29669935 | Xanthomonas phage XbC2 | 2978503 | Viruses | Viruses | 82.4 | 7.58e-17 | NR | UYE98594.1 | 2978503 | g15179 | i0 | 64.4 | 0.621052631578947 | 59 | 20 | 61.1 | 1 | 2 | 175 | 5 | 63 | UYE98594.1 hypothetical protein XbC2_165 [Xanthomonas phage XbC2] | diamond | 177 | 82.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mimasvirus | Xanthomonas phage XbC2 | ||||
| 28191532 | 28191532 | PRJNA846110_P_NODE_26886_length_245_cov_1.343023_g26641_i0 | PRJNA846110 | 26886 | 245 | 1.343023 | 3.29040635 | Ralstonia phage RP31 | 1923890 | Viruses | Viruses | 104 | 6.049999999999999e-24 | NR | BAW19303.1 | 1923890 | g26641 | i0 | 59 | 0.955102040816327 | 78 | 32 | 95.5 | 0 | 8 | 241 | 1983 | 2060 | BAW19303.1 hypothetical protein [Ralstonia phage RP31] | diamond | 234 | 104 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Ripduovirus | Ripduovirus RP12 | |||
| 28444501 | 28444501 | PRJNA846110_P_NODE_16886_length_278_cov_1.502439_g16641_i0 | PRJNA846110 | 16886 | 278 | 1.502439 | 4.17678042 | Aeromonas phage vB_AsaP_MQM1 | 3038230 | Viruses | Viruses | 89 | 3.33e-20 | NR | WFZ78502.1 | 3038230 | g16641 | i0 | 72.9 | 0.636690647482014 | 59 | 16 | 63.7 | 0 | 3 | 179 | 86 | 144 | WFZ78502.1 hypothetical protein MQM1_019 [Aeromonas phage vB_AsaP_MQM1] | diamond | 177 | 89 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aeromonas phage vB_AsaP_MQM1 | |||||
| 29328352 | 29328352 | PRJNA846110_P_NODE_18809_length_269_cov_1.326531_g18564_i0 | PRJNA846110 | 18809 | 269 | 1.326531 | 3.56836839 | Klebsiella phage KP13-16 | 2985658 | Viruses | Viruses | 57.4 | 3.37e-7 | NR | UYL04503.1 | 2985658 | g18564 | i0 | 38.9 | 1.98513011152416 | 90 | 54 | 99.3 | 1 | 2 | 268 | 281 | 370 | UYL04503.1 hypothetical protein EPNKCIFM_00201 [Klebsiella phage KP13-16] | diamond | 534 | 57.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Klebsiella phage KP13-16 | |||||
| 29517769 | 29517769 | PRJNA846110_P_NODE_11710_length_318_cov_1.053061_g11465_i0 | PRJNA846110 | 11710 | 318 | 1.053061 | 3.34873398 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 147 | 1.5599999999999999e-38 | NR | XOR63729.1 | 2832643 | g11465 | i0 | 64.4 | 1.9622641509434 | 104 | 36 | 98.1 | 1 | 2 | 313 | 136 | 238 | XOR63729.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 624 | 147 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30339623 | 30339623 | PRJNA846110_P_NODE_8612_length_361_cov_0.986111_g8368_i0 | PRJNA846110 | 8612 | 361 | 0.986111 | 3.55986071 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 93.6 | 5.84e-20 | NR | XOR63743.1 | 2832643 | g8368 | i0 | 43.4 | 0.822714681440443 | 99 | 55 | 82.3 | 1 | 2 | 298 | 122 | 219 | XOR63743.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 297 | 93.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30402753 | 30402753 | PRJNA846110_P_NODE_26293_length_246_cov_0.890173_g26048_i0 | PRJNA846110 | 26293 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 44.3 | 0.00243 | NR | DAZ52916.1 | 2832643 | g26048 | i0 | 59 | 0.475609756097561 | 39 | 16 | 47.6 | 0 | 123 | 7 | 44 | 82 | DAZ52916.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 117 | 44.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31097282 | 31097282 | PRJNA846110_P_NODE_15215_length_286_cov_1.727700_g14970_i0 | PRJNA846110 | 15215 | 286 | 1.7277 | 4.941222 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 57.8 | 8.55e-8 | NR | XOS24387.1 | 2832643 | g14970 | i0 | 38.3 | 1.68881118881119 | 81 | 49 | 85 | 1 | 245 | 3 | 76 | 155 | XOS24387.1 MAG: putative tail fiber protein [Caudoviricetes sp.] | diamond | 483 | 57.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31382066 | 31382066 | PRJNA846110_P_NODE_16396_length_281_cov_1.105769_g16151_i0 | PRJNA846110 | 16396 | 281 | 1.105769 | 3.10721089 | Aeromonas phage vB_AsaP_MQM1 | 3038230 | Viruses | Viruses | 177 | 5.38e-50 | NR | WFZ78487.1 | 3038230 | g16151 | i0 | 91.3 | 0.98220640569395 | 92 | 8 | 98.2 | 0 | 6 | 281 | 388 | 479 | WFZ78487.1 portal protein [Aeromonas phage vB_AsaP_MQM1] | diamond | 276 | 177 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aeromonas phage vB_AsaP_MQM1 | |||||
| 32402778 | 32402778 | PRJNA846110_P_NODE_15619_length_284_cov_1.867299_g15374_i0 | PRJNA846110 | 15619 | 284 | 1.867299 | 5.30312916 | Viruses | 10239 | Viruses | Viruses | 119 | 4.58e-30 | NR | QTH80266.1 | 2820398 | g15374 | i0 | 89.3 | 1.21478873239437 | 56 | 6 | 59.2 | 0 | 274 | 107 | 291 | 346 | QTH80266.1 radical SAM protein [Pseudomonas phage pPa_SNUABM_DT01] | diamond | 345 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage pPa_SNUABM_DT01 |
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);;