contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA715462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27399751 | 27399751 | PRJNA715462_P_NODE_52463_length_250_cov_0.870056_g51667_i0 | PRJNA715462 | 52463 | 250 | 0.870056 | 2.17514 | Freshwater phage uvFW-CGR-AMD-COM-C449 | 1838155 | Viruses | Viruses | 127 | 2.92e-33 | NR | ANH49431.1 | 1838155 | g51667 | i0 | 69.9 | 0.996 | 83 | 24 | 99.6 | 1 | 2 | 250 | 106 | 187 | ANH49431.1 putative glycosyltransferase [Freshwater phage uvFW-CGR-AMD-COM-C449] | diamond | 249 | 127 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Freshwater phage uvFW-CGR-AMD-COM-C449 | |||||
| 27431467 | 27431467 | PRJNA715462_P_NODE_69583_length_241_cov_0.916667_g68787_i0 | PRJNA715462 | 69583 | 241 | 0.916667 | 2.20916747 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 47.8 | 6.25e-4 | NR | CAB5221460.1 | 2100421 | g68787 | i0 | 41.1 | 0.908713692946058 | 73 | 43 | 90.9 | 0 | 221 | 3 | 1975 | 2047 | CAB5221460.1 Baseplate protein J-like [uncultured Caudovirales phage] | diamond | 219 | 47.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27873198 | 27873198 | PRJNA715462_P_NODE_69965_length_236_cov_2.282209_g69169_i0 | PRJNA715462 | 69965 | 236 | 2.282209 | 5.38601324 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 61.6 | 5.46e-9 | NR | DAS17539.1 | 2832643 | g69169 | i0 | 43.2 | 0.940677966101695 | 74 | 40 | 94.1 | 1 | 230 | 9 | 29 | 100 | DAS17539.1 MAG TPA: polynucleotide kinase [Caudoviricetes sp.] | diamond | 222 | 61.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27967900 | 27967900 | PRJNA715462_P_NODE_47525_length_259_cov_1.268817_g46729_i0 | PRJNA715462 | 47525 | 259 | 1.268817 | 3.28623603 | Erythrobacter phage vB_EliS-L | 2909139 | Viruses | Viruses | 85.1 | 4.24e-19 | NR | UIS25213.1 | 2909139 | g46729 | i0 | 72.5 | 0.590733590733591 | 51 | 14 | 59.1 | 0 | 154 | 2 | 1 | 51 | UIS25213.1 hypothetical protein [Erythrobacter phage vB_EliS-L02] | diamond | 153 | 85.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Erythrobacter phage vB_EliS-L02 | |||||
| 27967920 | 27967920 | PRJNA715462_P_NODE_69725_length_241_cov_0.857143_g68929_i0 | PRJNA715462 | 69725 | 241 | 0.857143 | 2.06571463 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 145 | 6.33e-40 | NR | CAB5194664.1 | 2100421 | g68929 | i0 | 91.1 | 2.95020746887967 | 79 | 7 | 98.3 | 0 | 3 | 239 | 12 | 90 | CAB5194664.1 Terminase-like family [uncultured Caudovirales phage] | diamond | 711 | 145 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28346805 | 28346805 | PRJNA715462_P_NODE_65846_length_243_cov_0.905882_g65050_i0 | PRJNA715462 | 65846 | 243 | 0.905882 | 2.20129326 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 116 | 4.55e-29 | NR | CAB4173433.1 | 2100421 | g65050 | i0 | 64.6 | 0.975308641975309 | 79 | 28 | 97.5 | 0 | 6 | 242 | 170 | 248 | CAB4173433.1 hypothetical protein UFOVP943_15 [uncultured Caudovirales phage] | diamond | 237 | 116 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28504680 | 28504680 | PRJNA715462_P_NODE_31507_length_317_cov_1.262295_g30711_i0 | PRJNA715462 | 31507 | 317 | 1.262295 | 4.00147515 | Achromobacter phage vB_AchrS_AchV4 | 2796514 | Viruses | Viruses | 52.4 | 1.41e-6 | NR | YP_009997583.1 | 2796514 | g30711 | i0 | 47.3 | 1.06940063091483 | 55 | 28 | 52.1 | 1 | 311 | 147 | 5 | 58 | YP_009997583.1 hypothetical protein JT316_gp50 [Achromobacter phage vB_AchrS_AchV4] | diamond | 339 | 52.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Casjensviridae | Gediminasvirus | Gediminasvirus AchV4 | |||
| 28536489 | 28536489 | PRJNA715462_P_NODE_42847_length_272_cov_1.547739_g42051_i0 | PRJNA715462 | 42847 | 272 | 1.547739 | 4.20985008 | Microbacterium phage Triscuit | 2126721 | Viruses | Viruses | 123 | 8.04e-31 | NR | AVR56907.1 | 2126721 | g42051 | i0 | 69.8 | 0.948529411764706 | 86 | 25 | 94.9 | 1 | 3 | 260 | 249 | 333 | AVR56907.1 terminase [Microbacterium phage Triscuit] | diamond | 258 | 123 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Microbacterium phage Triscuit | |||||
| 29041679 | 29041679 | PRJNA715462_P_NODE_63828_length_244_cov_0.900585_g63032_i0 | PRJNA715462 | 63828 | 244 | 0.900585 | 2.1974274 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 51.6 | 2.79e-5 | NR | CAB4138238.1 | 2100421 | g63032 | i0 | 62.9 | 0.430327868852459 | 35 | 13 | 43 | 0 | 243 | 139 | 434 | 468 | CAB4138238.1 hypothetical protein UFOVP328_431 [uncultured Caudovirales phage] | diamond | 105 | 51.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29325514 | 29325514 | PRJNA715462_P_NODE_52309_length_250_cov_0.870056_g51513_i0 | PRJNA715462 | 52309 | 250 | 0.870056 | 2.17514 | uncultured Mediterranean phage uvMED | 1407671 | Viruses | Viruses | 116 | 8.069999999999998e-32 | NR | BAR31737.1 | 1407671 | g51513 | i0 | 77.2 | 0.948 | 79 | 17 | 94.8 | 1 | 3 | 239 | 7 | 84 | BAR31737.1 putative high light inducible protein [uncultured Mediterranean phage uvMED] | diamond | 237 | 116 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | uncultured Mediterranean phage uvMED | |||||
| 29483257 | 29483257 | PRJNA715462_P_NODE_58270_length_247_cov_0.885057_g57474_i0 | PRJNA715462 | 58270 | 247 | 0.885057 | 2.18609079 | Pseudomonas phage vB_PsaM_M1 | 2995601 | Viruses | Viruses | 74.7 | 4.74e-14 | NR | UZS00918.1 | 2995601 | g57474 | i0 | 44.9 | 0.947368421052632 | 78 | 39 | 89.9 | 1 | 247 | 26 | 19 | 96 | UZS00918.1 intron-associated endonuclease [Pseudomonas phage vB_PsaM_M1] | diamond | 234 | 74.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Andersonviridae | Pseudomonas phage vB_PaeM_M1 | ||||
| 29640968 | 29640968 | PRJNA715462_P_NODE_20610_length_407_cov_0.898204_g19814_i0 | PRJNA715462 | 20610 | 407 | 0.898204 | 3.65569028 | Synechococcus phage S-SRM | 3060697 | Viruses | Viruses | 176 | 4.52e-48 | NR | YP_010670171.1 | 2781608 | g19814 | i0 | 64.7 | 0.98034398034398 | 133 | 47 | 98 | 0 | 405 | 7 | 1444 | 1576 | YP_010670171.1 virulence-associated VriC protein [Synechococcus phage S-SRM01] | diamond | 399 | 176 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Kyanoviridae | Serangoonvirus | Serangoonvirus essarone | ||
| 30209662 | 30209662 | PRJNA715462_P_NODE_51552_length_251_cov_0.865169_g50756_i0 | PRJNA715462 | 51552 | 251 | 0.865169 | 2.17157419 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 42.7 | 0.0369 | NR | CAB4220910.1 | 2100421 | g50756 | i0 | 39.3 | 0.729083665338645 | 61 | 34 | 71.7 | 2 | 182 | 3 | 78 | 136 | CAB4220910.1 NAT_SF domain containing protein [uncultured Caudovirales phage] | diamond | 183 | 42.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30368355 | 30368355 | PRJNA715462_P_NODE_67712_length_242_cov_0.911243_g66916_i0 | PRJNA715462 | 67712 | 242 | 0.911243 | 2.20520806 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 84.7 | 3e-18 | NR | CAB4122196.1 | 2100421 | g66916 | i0 | 52.5 | 0.991735537190083 | 80 | 37 | 97.9 | 1 | 6 | 242 | 97 | 176 | CAB4122196.1 hypothetical protein UFOVP27_98 [uncultured Caudovirales phage] | diamond | 240 | 84.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30399960 | 30399960 | PRJNA715462_P_NODE_55833_length_248_cov_0.880000_g55037_i0 | PRJNA715462 | 55833 | 248 | 0.88 | 2.1824 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 58.9 | 7.83e-8 | NR | CAB4129659.1 | 2100421 | g55037 | i0 | 40.7 | 0.979838709677419 | 81 | 47 | 98 | 1 | 243 | 1 | 430 | 509 | CAB4129659.1 SprB repeat [uncultured Caudovirales phage] | diamond | 243 | 58.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30525814 | 30525814 | PRJNA715462_P_NODE_67833_length_242_cov_0.881657_g67037_i0 | PRJNA715462 | 67833 | 242 | 0.881657 | 2.13360994 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 77.8 | 1.69e-14 | NR | CAB4137799.1 | 2100421 | g67037 | i0 | 46.9 | 1.00413223140496 | 81 | 41 | 99.2 | 2 | 240 | 1 | 879 | 958 | CAB4137799.1 Putative amidoligase enzyme [uncultured Caudovirales phage] | diamond | 243 | 77.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30873424 | 30873424 | PRJNA715462_P_NODE_51694_length_251_cov_0.865169_g50898_i0 | PRJNA715462 | 51694 | 251 | 0.865169 | 2.17157419 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 50.1 | 6.08e-6 | NR | XOS42970.1 | 2832643 | g50898 | i0 | 52.6 | 0.454183266932271 | 38 | 18 | 45.4 | 0 | 134 | 247 | 9 | 46 | XOS42970.1 MAG: hypothetical protein MSP0968_13 [Caudoviricetes sp.] | diamond | 114 | 50.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31063231 | 31063231 | PRJNA715462_P_NODE_65215_length_243_cov_0.905882_g64419_i0 | PRJNA715462 | 65215 | 243 | 0.905882 | 2.20129326 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 66.6 | 1.4e-10 | NR | UOF77105.1 | 2832643 | g64419 | i0 | 75 | 0.54320987654321 | 44 | 11 | 54.3 | 0 | 134 | 3 | 1 | 44 | UOF77105.1 hyaluronidasE [Caudoviricetes sp.] | diamond | 132 | 66.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31189026 | 31189026 | PRJNA715462_P_NODE_42375_length_274_cov_1.079602_g41579_i0 | PRJNA715462 | 42375 | 274 | 1.079602 | 2.95810948 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 130 | 3.51e-33 | NR | XOR97276.1 | 2832643 | g41579 | i0 | 67.5 | 0.908759124087591 | 83 | 27 | 90.9 | 0 | 26 | 274 | 142 | 224 | XOR97276.1 MAG: hypothetical protein MSP1354_74 [Caudoviricetes sp.] | diamond | 249 | 130 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31315880 | 31315880 | PRJNA715462_P_NODE_64235_length_244_cov_0.900585_g63439_i0 | PRJNA715462 | 64235 | 244 | 0.900585 | 2.1974274 | Yersinia phage JC221 | 2654973 | Viruses | Viruses | 131 | 5.41e-35 | NR | QFR55910.1 | 2654973 | g63439 | i0 | 72.8 | 0.995901639344262 | 81 | 22 | 99.6 | 0 | 1 | 243 | 165 | 245 | QFR55910.1 clamp-loader subunit [Yersinia phage JC221] | diamond | 243 | 131 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Yersinia phage JC221 | |||
| 31347635 | 31347635 | PRJNA715462_P_NODE_52776_length_250_cov_0.870056_g51980_i0 | PRJNA715462 | 52776 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 105 | 2.77e-24 | NR | XOS49248.1 | 2832643 | g51980 | i0 | 63.5 | 0.888 | 74 | 27 | 88.8 | 0 | 3 | 224 | 192 | 265 | XOS49248.1 MAG: terminase large subunit [Caudoviricetes sp.] | diamond | 222 | 105 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31410843 | 31410843 | PRJNA715462_P_NODE_50656_length_251_cov_0.865169_g49860_i0 | PRJNA715462 | 50656 | 251 | 0.865169 | 2.17157419 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 70.9 | 5.37e-13 | NR | CAB4146677.1 | 2100421 | g49860 | i0 | 66.7 | 0.609561752988048 | 51 | 17 | 61 | 0 | 2 | 154 | 124 | 174 | CAB4146677.1 hypothetical protein UFOVP497_55 [uncultured Caudovirales phage] | diamond | 153 | 70.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31442395 | 31442395 | PRJNA715462_P_NODE_60136_length_246_cov_0.890173_g59340_i0 | PRJNA715462 | 60136 | 246 | 0.890173 | 2.18982558 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 142 | 6.189999999999999e-38 | NR | CAB5223685.1 | 2100421 | g59340 | i0 | 75.6 | 1 | 82 | 20 | 100 | 0 | 246 | 1 | 135 | 216 | CAB5223685.1 Portal protein [uncultured Caudovirales phage] | diamond | 246 | 142 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32833142 | 32833142 | PRJNA715462_P_NODE_56240_length_248_cov_0.880000_g55444_i0 | PRJNA715462 | 56240 | 248 | 0.88 | 2.1824 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 51.6 | 1.66e-5 | NR | CAB5194489.1 | 2100421 | g55444 | i0 | 57.1 | 0.508064516129032 | 42 | 18 | 50.8 | 0 | 133 | 8 | 1 | 42 | CAB5194489.1 Conserved hypothetical protein CHP02466 [uncultured Caudovirales phage] | diamond | 126 | 51.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch |
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);;