contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA807347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25449090 | 25449090 | PRJNA807347_P_NODE_10840_length_260_cov_1.245989_g10737_i0 | PRJNA807347 | 10840 | 260 | 1.245989 | 3.2395714 | Bordetella phage vB_BbrM_PHB | 2734129 | Viruses | Viruses | 82 | 7.05e-16 | NR | YP_009792693.1 | 2029657 | g10737 | i0 | 64.6 | 0.75 | 65 | 21 | 75 | 1 | 258 | 64 | 79 | 141 | YP_009792693.1 DNA methyltransferase [Bordetella phage vB_BbrM_PHB04] | diamond | 195 | 82 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Phabquatrovirus | Phabquatrovirus PHB04 | ||||
| 25449216 | 25449216 | PRJNA807347_P_NODE_3800_length_427_cov_1.271186_g3697_i0 | PRJNA807347 | 3800 | 427 | 1.271186 | 5.42796422 | Bordetella phage vB_BbrM_PHB | 2734129 | Viruses | Viruses | 245 | 3.4e-72 | NR | YP_009792691.1 | 2029657 | g3697 | i0 | 83.7 | 1.98126463700234 | 141 | 22 | 99.1 | 1 | 1 | 423 | 1375 | 1514 | YP_009792691.1 surperfamily II DNA or RNA helicase [Bordetella phage vB_BbrM_PHB04] | diamond | 846 | 245 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Phabquatrovirus | Phabquatrovirus PHB04 | ||||
| 26705724 | 26705724 | PRJNA807347_P_NODE_8521_length_284_cov_1.137441_g8418_i0 | PRJNA807347 | 8521 | 284 | 1.137441 | 3.23033244 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 80.1 | 1.43e-17 | NR | CAB4123352.1 | 2100421 | g8418 | i0 | 57.1 | 1.19366197183099 | 56 | 24 | 59.2 | 0 | 197 | 30 | 2 | 57 | CAB4123352.1 hypothetical protein UFOVP41_35 [uncultured Caudovirales phage] | diamond | 339 | 80.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 26968045 | 26968045 | PRJNA807347_P_NODE_14702_length_246_cov_1.364162_g14599_i0 | PRJNA807347 | 14702 | 246 | 1.364162 | 3.35583852 | Viruses | 10239 | Viruses | Viruses | 150 | 6.59e-40 | NR | XOR64200.1 | 2832643 | g14599 | i0 | 81.5 | 1.97560975609756 | 81 | 15 | 98.8 | 0 | 244 | 2 | 353 | 433 | XOR64200.1 MAG: terminase large subunit [Caudoviricetes sp.] | diamond | 486 | 151 | 0.993377483443709 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27022532 | 27022532 | PRJNA807347_P_NODE_12982_length_250_cov_0.875706_g12879_i0 | PRJNA807347 | 12982 | 250 | 0.875706 | 2.189265 | Pontimonas phage phiPsal1 | 2079347 | Viruses | Viruses | 60.5 | 1.4e-9 | NR | AUV61446.1 | 2079347 | g12879 | i0 | 53.6 | 0.672 | 56 | 26 | 67.2 | 0 | 170 | 3 | 1 | 56 | AUV61446.1 hypothetical protein phiPsal1_036 [Pontimonas phage phiPsal1] | diamond | 168 | 60.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pontimonas phage phiPsal1 | |||||
| 27085854 | 27085854 | PRJNA807347_P_NODE_16762_length_242_cov_1.733728_g16659_i0 | PRJNA807347 | 16762 | 242 | 1.733728 | 4.19562176 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 55.5 | 1.17e-6 | NR | DAJ88794.1 | 2832643 | g16659 | i0 | 40 | 0.743801652892562 | 60 | 35 | 73.1 | 1 | 234 | 58 | 125 | 184 | DAJ88794.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 180 | 55.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27180354 | 27180354 | PRJNA807347_P_NODE_7502_length_298_cov_1.764444_g7399_i0 | PRJNA807347 | 7502 | 298 | 1.764444 | 5.25804312 | Bordetella phage vB_BbrM_PHB | 2734129 | Viruses | Viruses | 63.5 | 7.86e-10 | NR | YP_009792773.1 | 2029657 | g7399 | i0 | 48.4 | 0.644295302013423 | 64 | 32 | 63.4 | 1 | 192 | 4 | 4 | 67 | YP_009792773.1 hypothetical protein HOS14_gp107 [Bordetella phage vB_BbrM_PHB04] | diamond | 192 | 63.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Phabquatrovirus | Phabquatrovirus PHB04 | ||||
| 27528081 | 27528081 | PRJNA807347_P_NODE_4563_length_387_cov_1.920382_g4460_i0 | PRJNA807347 | 4563 | 387 | 1.920382 | 7.43187834 | Acinetobacter phage vB_AbaP_Alexa | 2736223 | Viruses | Viruses | 179 | 2.2099999999999994e-54 | NR | QKN87915.1 | 2736223 | g4460 | i0 | 81.5 | 0.837209302325581 | 108 | 20 | 83.7 | 0 | 370 | 47 | 1 | 108 | QKN87915.1 putative tail fiber protein [Acinetobacter phage vB_AbaP_Alexa] | diamond | 324 | 179 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acinetobacter phage vB_AbaP_Alexa | |||||
| 27717983 | 27717983 | PRJNA807347_P_NODE_11284_length_256_cov_1.306011_g11181_i0 | PRJNA807347 | 11284 | 256 | 1.306011 | 3.34338816 | Bordetella phage vB_BbrM_PHB | 2734129 | Viruses | Viruses | 127 | 5.18e-33 | NR | YP_009792696.1 | 2029657 | g11181 | i0 | 73.6 | 1.01953125 | 87 | 21 | 99.6 | 1 | 1 | 255 | 2 | 88 | YP_009792696.1 hypothetical protein HOS14_gp030 [Bordetella phage vB_BbrM_PHB04] | diamond | 261 | 127 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Phabquatrovirus | Phabquatrovirus PHB04 | ||||
| 27843700 | 27843700 | PRJNA807347_P_NODE_12244_length_251_cov_1.752809_g12141_i0 | PRJNA807347 | 12244 | 251 | 1.752809 | 4.39955059 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 81.3 | 6.31e-17 | NR | CAB4159055.1 | 2100421 | g12141 | i0 | 50 | 2.00796812749004 | 84 | 41 | 99.2 | 1 | 2 | 250 | 66 | 149 | CAB4159055.1 hypothetical protein UFOVP699_58 [uncultured Caudovirales phage] | diamond | 504 | 81.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28190961 | 28190961 | PRJNA807347_P_NODE_10966_length_259_cov_1.241935_g10863_i0 | PRJNA807347 | 10966 | 259 | 1.241935 | 3.21661165 | Bordetella phage vB_BbrM_PHB | 2734129 | Viruses | Viruses | 115 | 1.23e-28 | NR | YP_009792671.1 | 2029657 | g10863 | i0 | 66.7 | 0.972972972972973 | 84 | 28 | 97.3 | 0 | 257 | 6 | 276 | 359 | YP_009792671.1 virion structural protein [Bordetella phage vB_BbrM_PHB04] | diamond | 252 | 115 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Phabquatrovirus | Phabquatrovirus PHB04 | ||||
| 28285701 | 28285701 | PRJNA807347_P_NODE_11886_length_252_cov_1.402235_g11783_i0 | PRJNA807347 | 11886 | 252 | 1.402235 | 3.5336322 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 143 | 5.32e-38 | NR | CAB4125722.1 | 2100421 | g11783 | i0 | 82.1 | 2 | 84 | 15 | 100 | 0 | 1 | 252 | 191 | 274 | CAB4125722.1 PncB Nicotinic acid phosphoribosyltransferase [uncultured Caudovirales phage] | diamond | 504 | 143 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28380607 | 28380607 | PRJNA807347_P_NODE_5506_length_349_cov_1.873188_g5403_i0 | PRJNA807347 | 5506 | 349 | 1.873188 | 6.53742612 | Xanthomonas phage DES1 | 2894399 | Viruses | Viruses | 63.2 | 8.73e-10 | NR | UFK09588.1 | 2894399 | g5403 | i0 | 42.2 | 0.550143266475645 | 64 | 34 | 55 | 1 | 194 | 3 | 1 | 61 | UFK09588.1 DNA-packaging protein small subunit [Xanthomonas phage DES1] | diamond | 192 | 63.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Xanthomonas phage DES1 | |||||
| 28506974 | 28506974 | PRJNA807347_P_NODE_2307_length_554_cov_1.669439_g2204_i0 | PRJNA807347 | 2307 | 554 | 1.669439 | 9.24869206 | Siphoviridae sp. ctHip2 | 2827830 | Viruses | Viruses | 162 | 1.44e-43 | NR | DAF42606.1 | 2827830 | g2204 | i0 | 46.2 | 1.0072202166065 | 186 | 96 | 99.6 | 2 | 3 | 554 | 332 | 515 | DAF42606.1 MAG TPA: DNA TRANSLOCASE FTSK [Siphoviridae sp. ctHip2] | diamond | 558 | 162 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctHip2 | |||||
| 28506977 | 28506977 | PRJNA807347_P_NODE_7307_length_302_cov_1.353712_g7204_i0 | PRJNA807347 | 7307 | 302 | 1.353712 | 4.08821024 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 110 | 8.94e-26 | NR | DAG83963.1 | 2832643 | g7204 | i0 | 53.9 | 1.97682119205298 | 102 | 42 | 98.3 | 2 | 1 | 297 | 396 | 495 | DAG83963.1 MAG TPA: homing endonuclease [Caudoviricetes sp.] | diamond | 597 | 110 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28538696 | 28538696 | PRJNA807347_P_NODE_11827_length_252_cov_2.363128_g11724_i0 | PRJNA807347 | 11827 | 252 | 2.363128 | 5.95508256 | Xanthomonas phage DES1 | 2894399 | Viruses | Viruses | 90.5 | 6.41e-19 | NR | UFK09592.1 | 2894399 | g11724 | i0 | 50 | 1.97619047619048 | 82 | 41 | 97.6 | 0 | 247 | 2 | 99 | 180 | UFK09592.1 portal protein [Xanthomonas phage DES1] | diamond | 498 | 90.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Xanthomonas phage DES1 | |||||
| 29327759 | 29327759 | PRJNA807347_P_NODE_5229_length_360_cov_1.585366_g5126_i0 | PRJNA807347 | 5229 | 360 | 1.585366 | 5.7073176 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 112 | 2.5e-26 | NR | DAW84387.1 | 2832643 | g5126 | i0 | 51.3 | 0.958333333333333 | 115 | 50 | 92.5 | 2 | 27 | 359 | 266 | 378 | DAW84387.1 MAG TPA: DNA polymerase II small subunit [Caudoviricetes sp.] | diamond | 345 | 112 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30022745 | 30022745 | PRJNA807347_P_NODE_17131_length_242_cov_0.917160_g17028_i0 | PRJNA807347 | 17131 | 242 | 0.91716 | 2.2195272 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 130 | 5.05e-33 | NR | CAB4143742.1 | 2100421 | g17028 | i0 | 75 | 0.991735537190083 | 80 | 20 | 99.2 | 0 | 242 | 3 | 754 | 833 | CAB4143742.1 PolB DNA polymerase elongation subunit (family B) [uncultured Caudovirales phage] | diamond | 240 | 130 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30148739 | 30148739 | PRJNA807347_P_NODE_10472_length_263_cov_1.752632_g10369_i0 | PRJNA807347 | 10472 | 263 | 1.752632 | 4.60942216 | Tenacibaculum phage pT24 | 1880590 | Viruses | Viruses | 62.8 | 1.08e-10 | NR | YP_009876830.1 | 1880590 | g10369 | i0 | 59.6 | 0.536121673003802 | 47 | 19 | 53.6 | 0 | 263 | 123 | 35 | 81 | YP_009876830.1 hypothetical protein HYP10_gp223 [Tenacibaculum phage pT24] | diamond | 141 | 62.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kungbxnavirus | Kungbxnavirus pT24 | ||||
| 30465260 | 30465260 | PRJNA807347_P_NODE_10253_length_265_cov_1.807292_g10150_i0 | PRJNA807347 | 10253 | 265 | 1.807292 | 4.7893238 | Stenotrophomonas phage RAS14 | 2996120 | Viruses | Viruses | 45.8 | 0.00409 | NR | WAX21630.1 | 2996120 | g10150 | i0 | 55.3 | 0.860377358490566 | 38 | 17 | 43 | 0 | 1 | 114 | 845 | 882 | WAX21630.1 hypothetical protein [Stenotrophomonas phage RAS14] | diamond | 228 | 45.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Stenotrophomonas phage RAS14 | |||||
| 31413018 | 31413018 | PRJNA807347_P_NODE_3656_length_436_cov_1.812672_g3553_i0 | PRJNA807347 | 3656 | 436 | 1.812672 | 7.90324992 | Bordetella phage vB_BbrM_PHB | 2734129 | Viruses | Viruses | 160 | 2.8699999999999998e-43 | NR | YP_009792768.1 | 2029657 | g3553 | i0 | 60.7 | 0.928899082568807 | 135 | 48 | 92.9 | 2 | 432 | 28 | 351 | 480 | YP_009792768.1 DNA helicase [Bordetella phage vB_BbrM_PHB04] | diamond | 405 | 160 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Phabquatrovirus | Phabquatrovirus PHB04 | ||||
| 31539650 | 31539650 | PRJNA807347_P_NODE_5036_length_367_cov_1.581633_g4933_i0 | PRJNA807347 | 5036 | 367 | 1.581633 | 5.80459311 | Bordetella phage vB_BbrM_PHB | 2734129 | Viruses | Viruses | 130 | 2.8899999999999996e-32 | NR | YP_009792693.1 | 2029657 | g4933 | i0 | 58.2 | 1.97820163487738 | 122 | 51 | 99.7 | 0 | 1 | 366 | 1552 | 1673 | YP_009792693.1 DNA methyltransferase [Bordetella phage vB_BbrM_PHB04] | diamond | 726 | 130 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Phabquatrovirus | Phabquatrovirus PHB04 | ||||
| 32014016 | 32014016 | PRJNA807347_P_NODE_16298_length_243_cov_0.958824_g16195_i0 | PRJNA807347 | 16298 | 243 | 0.958824 | 2.32994232 | Erwinia phage Pecta | 2851070 | Viruses | Viruses | 84.7 | 6.08e-17 | NR | QXG07554.1 | 2851070 | g16195 | i0 | 47.4 | 0.962962962962963 | 78 | 41 | 96.3 | 0 | 2 | 235 | 472 | 549 | QXG07554.1 hypothetical protein [Erwinia phage Pecta] | diamond | 234 | 84.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Citrovirus | Erwinia phage Pecta | |||
| 32583642 | 32583642 | PRJNA807347_P_NODE_16959_length_242_cov_0.923077_g16856_i0 | PRJNA807347 | 16959 | 242 | 0.923077 | 2.23384634 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 48.5 | 3.46e-4 | NR | XOE97033.1 | 2832643 | g16856 | i0 | 45.7 | 0.867768595041322 | 70 | 34 | 86.8 | 2 | 214 | 5 | 737 | 802 | XOE97033.1 MAG: virion structural protein [Caudoviricetes sp.] | diamond | 210 | 48.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. |
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);;