contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA853203" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26865467 | 26865467 | PRJNA853203_P_NODE_11401_length_285_cov_2.202830_g11252_i0 | PRJNA853203 | 11401 | 285 | 2.20283 | 6.2780655 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 76.3 | 9.93e-14 | NR | CAB4156367.1 | 2100421 | g11252 | i0 | 81.8 | 0.926315789473684 | 44 | 8 | 46.3 | 0 | 284 | 153 | 594 | 637 | CAB4156367.1 hypothetical protein UFOVP656_51 [uncultured Caudovirales phage] | diamond | 264 | 76.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27055117 | 27055117 | PRJNA853203_P_NODE_24582_length_256_cov_2.081967_g24433_i0 | PRJNA853203 | 24582 | 256 | 2.081967 | 5.32983552 | uncultured Mediterranean phage uvMED | 1407671 | Viruses | Viruses | 70.1 | 2.25e-12 | NR | BAQ92701.1 | 1407671 | g24433 | i0 | 51.7 | 0.703125 | 60 | 29 | 70.3 | 0 | 2 | 181 | 150 | 209 | BAQ92701.1 hypothetical protein [uncultured Mediterranean phage uvMED] | diamond | 180 | 70.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | uncultured Mediterranean phage uvMED | |||||
| 27434491 | 27434491 | PRJNA853203_P_NODE_42263_length_245_cov_0.906977_g42114_i0 | PRJNA853203 | 42263 | 245 | 0.906977 | 2.22209365 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 142 | 2.07e-38 | NR | CAB4149186.1 | 2100421 | g42114 | i0 | 74.7 | 0.96734693877551 | 79 | 20 | 96.7 | 0 | 243 | 7 | 152 | 230 | CAB4149186.1 HELICc domain containing protein [uncultured Caudovirales phage] | diamond | 237 | 142 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27560375 | 27560375 | PRJNA853203_P_NODE_41624_length_245_cov_0.906977_g41475_i0 | PRJNA853203 | 41624 | 245 | 0.906977 | 2.22209365 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 62.4 | 1.3e-9 | NR | XOR11138.1 | 2832643 | g41475 | i0 | 43.4 | 0.930612244897959 | 76 | 37 | 88.2 | 2 | 219 | 4 | 108 | 181 | XOR11138.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 228 | 62.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27687221 | 27687221 | PRJNA853203_P_NODE_10404_length_288_cov_1.269767_g10255_i0 | PRJNA853203 | 10404 | 288 | 1.269767 | 3.65692896 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 68.9 | 1.98e-12 | NR | CAB4158623.1 | 2100421 | g10255 | i0 | 46.2 | 1.60416666666667 | 78 | 42 | 81.3 | 0 | 288 | 55 | 53 | 130 | CAB4158623.1 hypothetical protein UFOVP711_15 [uncultured Caudovirales phage] | diamond | 462 | 68.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27970958 | 27970958 | PRJNA853203_P_NODE_11225_length_286_cov_1.323944_g11076_i0 | PRJNA853203 | 11225 | 286 | 1.323944 | 3.78647984 | Pseudomonas phage Noxifer | 2006684 | Viruses | Viruses | 126 | 4.05e-35 | NR | YP_009608948.1 | 2006684 | g11076 | i0 | 57.4 | 0.986013986013986 | 94 | 40 | 98.6 | 0 | 284 | 3 | 7 | 100 | YP_009608948.1 hypothetical protein FDI21_gp033 [Pseudomonas phage Noxifer] | diamond | 282 | 126 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Noxifervirus | Noxifervirus noxifer | |||
| 28065726 | 28065726 | PRJNA853203_P_NODE_10465_length_288_cov_1.158140_g10316_i0 | PRJNA853203 | 10465 | 288 | 1.15814 | 3.3354432 | Haloarcula californiae tailed virus 2 | 1273747 | Viruses | Viruses | 55.8 | 2.37e-7 | NR | YP_008058424.1 | 1273747 | g10316 | i0 | 44.9 | 1.73958333333333 | 78 | 35 | 77.1 | 3 | 278 | 57 | 46 | 119 | YP_008058424.1 Holliday junction resolvase [Haloarcula californiae tailed virus 2] | diamond | 501 | 55.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Saparoviridae | Samsavirus | Samsavirus crystalli | |||
| 28349884 | 28349884 | PRJNA853203_P_NODE_8286_length_294_cov_1.900452_g8137_i0 | PRJNA853203 | 8286 | 294 | 1.900452 | 5.58732888 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 45.1 | 0.0111 | NR | XOS54536.1 | 2832643 | g8137 | i0 | 50 | 1 | 46 | 23 | 46.9 | 0 | 141 | 4 | 1477 | 1522 | XOS54536.1 MAG: recombination endonuclease subunit [Caudoviricetes sp.] | diamond | 294 | 45.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29139552 | 29139552 | PRJNA853203_P_NODE_3389_length_369_cov_0.844595_g3242_i0 | PRJNA853203 | 3389 | 369 | 0.844595 | 3.11655555 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 61.2 | 4.97e-8 | NR | CAB5222705.1 | 2100421 | g3242 | i0 | 50.8 | 0.51219512195122 | 63 | 31 | 51.2 | 0 | 72 | 260 | 252 | 314 | CAB5222705.1 Protein of unknown function DUF1566 [uncultured Caudovirales phage] | diamond | 189 | 61.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29234066 | 29234066 | PRJNA853203_P_NODE_39049_length_246_cov_1.473988_g38900_i0 | PRJNA853203 | 39049 | 246 | 1.473988 | 3.62601048 | Siphoviridae sp. ctbLB3 | 2825565 | Viruses | Viruses | 123 | 7.08e-34 | NR | DAE07963.1 | 2825565 | g38900 | i0 | 90.6 | 0.780487804878049 | 64 | 6 | 78 | 0 | 2 | 193 | 94 | 157 | DAE07963.1 MAG TPA: peptidase [Siphoviridae sp. ctbLB3] | diamond | 192 | 123 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctbLB3 | |||||
| 29360344 | 29360344 | PRJNA853203_P_NODE_5429_length_328_cov_1.113725_g5280_i0 | PRJNA853203 | 5429 | 328 | 1.113725 | 3.653018 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 113 | 1.33e-26 | NR | CAB4123081.1 | 2100421 | g5280 | i0 | 53.6 | 1.00609756097561 | 110 | 48 | 98.8 | 2 | 326 | 3 | 567 | 675 | CAB4123081.1 Intein N-terminal splicing region [uncultured Caudovirales phage] | diamond | 330 | 113 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29644038 | 29644038 | PRJNA853203_P_NODE_11490_length_285_cov_1.495283_g11341_i0 | PRJNA853203 | 11490 | 285 | 1.495283 | 4.26155655 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 119 | 1.08e-29 | NR | XOS43005.1 | 2832643 | g11341 | i0 | 61.1 | 1 | 95 | 36 | 100 | 1 | 285 | 1 | 127 | 220 | XOS43005.1 MAG: gp20 protein [Caudoviricetes sp.] | diamond | 285 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29960223 | 29960223 | PRJNA853203_P_NODE_25851_length_254_cov_1.585635_g25702_i0 | PRJNA853203 | 25851 | 254 | 1.585635 | 4.0275129 | Pseudomonas phage phiKZ | 2905945 | Viruses | Viruses | 86.7 | 1.49e-17 | NR | NP_803648.1 | 2905945 | g25702 | i0 | 76.6 | 2.22047244094488 | 47 | 11 | 55.5 | 0 | 254 | 114 | 482 | 528 | NP_803648.1 DNA polymerase [Pseudomonas phage phiKZ] | diamond | 564 | 86.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Phikzvirus | Phikzvirus phiKZ | |||
| 30339915 | 30339915 | PRJNA853203_P_NODE_28532_length_252_cov_0.871508_g28383_i0 | PRJNA853203 | 28532 | 252 | 0.871508 | 2.19620016 | Rhodococcus phage Finch | 2094144 | Viruses | Viruses | 87.4 | 1.59e-18 | NR | YP_010059103.1 | 2094144 | g28383 | i0 | 54.9 | 0.976190476190476 | 82 | 36 | 96.4 | 1 | 249 | 7 | 34 | 115 | YP_010059103.1 exonuclease [Rhodococcus phage Finch] | diamond | 246 | 87.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Finchvirus | Finchvirus finch | ||||
| 30434529 | 30434529 | PRJNA853203_P_NODE_45893_length_243_cov_0.917647_g45744_i0 | PRJNA853203 | 45893 | 243 | 0.917647 | 2.22988221 | Acidovorax phage ACP17 | 2010329 | Viruses | Viruses | 81.6 | 5.88e-17 | NR | YP_009609735.1 | 2010329 | g45744 | i0 | 49.4 | 1.97530864197531 | 81 | 40 | 98.8 | 1 | 2 | 241 | 99 | 179 | YP_009609735.1 PhoH-like phosphate starvation-inducible [Acidovorax phage ACP17] | diamond | 480 | 81.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Busanvirus | Busanvirus ACP17 | ||||
| 30655242 | 30655242 | PRJNA853203_P_NODE_41793_length_245_cov_0.906977_g41644_i0 | PRJNA853203 | 41793 | 245 | 0.906977 | 2.22209365 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52 | 2.01e-5 | NR | UOF80022.1 | 2832643 | g41644 | i0 | 41.9 | 0.906122448979592 | 74 | 42 | 89.4 | 1 | 26 | 244 | 155 | 228 | UOF80022.1 putative major tail structural protein [Caudoviricetes sp.] | diamond | 222 | 52 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30844993 | 30844993 | PRJNA853203_P_NODE_30414_length_251_cov_0.876404_g30265_i0 | PRJNA853203 | 30414 | 251 | 0.876404 | 2.19977404 | Pseudomonas phage Noxifer | 2006684 | Viruses | Viruses | 112 | 9.24e-27 | NR | YP_009609037.1 | 2006684 | g30265 | i0 | 67.5 | 0.99203187250996006 | 83 | 27 | 99.2 | 0 | 250 | 2 | 322 | 404 | YP_009609037.1 major head protein [Pseudomonas phage Noxifer] | diamond | 249 | 112 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Noxifervirus | Noxifervirus noxifer | |||
| 31128944 | 31128944 | PRJNA853203_P_NODE_5275_length_330_cov_1.653696_g5126_i0 | PRJNA853203 | 5275 | 330 | 1.653696 | 5.4571968 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 162 | 7.549999999999999e-48 | NR | CAB4138154.1 | 2100421 | g5126 | i0 | 69.4 | 1.96363636363636 | 108 | 33 | 98.2 | 0 | 7 | 330 | 67 | 174 | CAB4138154.1 AraD Ribulose-5-phosphate 4-epimerase and related epimerases and aldolases [uncultured Caudovirales phage] | diamond | 648 | 162 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31603724 | 31603724 | PRJNA853203_P_NODE_42136_length_245_cov_0.906977_g41987_i0 | PRJNA853203 | 42136 | 245 | 0.906977 | 2.22209365 | Podoviridae sp. ctpVR23 | 2656714 | Viruses | Viruses | 74.7 | 2.09e-13 | NR | QGH73633.1 | 2656714 | g41987 | i0 | 45.7 | 2.95102040816327 | 81 | 44 | 99.2 | 0 | 245 | 3 | 16 | 96 | QGH73633.1 MAG: stabilization protein [Podoviridae sp. ctpVR23] | diamond | 723 | 74.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Podoviridae sp. ctpVR23 | |||||
| 31793183 | 31793183 | PRJNA853203_P_NODE_39157_length_246_cov_1.323699_g39008_i0 | PRJNA853203 | 39157 | 246 | 1.323699 | 3.25629954 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 77.4 | 2.42e-14 | NR | XOR59472.1 | 2832643 | g39008 | i0 | 53.2 | 0.963414634146341 | 79 | 36 | 95.1 | 1 | 2 | 235 | 2168 | 2246 | XOR59472.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 237 | 77.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32014872 | 32014872 | PRJNA853203_P_NODE_27838_length_252_cov_2.050279_g27689_i0 | PRJNA853203 | 27838 | 252 | 2.050279 | 5.16670308 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 66.6 | 1.62e-10 | NR | CAB4137799.1 | 2100421 | g27689 | i0 | 56.3 | 0.761904761904762 | 64 | 25 | 76.2 | 1 | 197 | 6 | 404 | 464 | CAB4137799.1 Putative amidoligase enzyme [uncultured Caudovirales phage] | diamond | 192 | 66.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32149731 | 32149731 | PRJNA853203_P_NODE_24198_length_257_cov_1.695652_g24049_i0 | PRJNA853203 | 24198 | 257 | 1.695652 | 4.35782564 | Ripduovirus | 2560215 | Viruses | Viruses | 83.2 | 9.01e-17 | NR | YP_009598723.1 | 1923889 | g24049 | i0 | 75 | 1.12062256809339 | 48 | 12 | 56 | 0 | 255 | 112 | 259 | 306 | YP_009598723.1 virion structural protein [Ralstonia phage RP12] | diamond | 288 | 83.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Ripduovirus | Ripduovirus RP12 | |||
| 32426278 | 32426278 | PRJNA853203_P_NODE_8019_length_297_cov_0.888393_g7870_i0 | PRJNA853203 | 8019 | 297 | 0.888393 | 2.63852721 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 88.2 | 2.28e-20 | NR | CAB4175576.1 | 2100421 | g7870 | i0 | 56.5 | 1.26262626262626 | 62 | 27 | 62.6 | 0 | 297 | 112 | 33 | 94 | CAB4175576.1 hypothetical protein UFOVP972_258 [uncultured Caudovirales phage] | diamond | 375 | 88.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32710197 | 32710197 | PRJNA853203_P_NODE_29620_length_251_cov_2.084270_g29471_i0 | PRJNA853203 | 29620 | 251 | 2.08427 | 5.2315177 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 89.7 | 1.21e-18 | NR | XOS31887.1 | 2832643 | g29471 | i0 | 61.4 | 1.9840637450199201 | 83 | 32 | 99.2 | 0 | 3 | 251 | 725 | 807 | XOS31887.1 MAG: recombination endonuclease subunit [Caudoviricetes sp.] | diamond | 498 | 89.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32804662 | 32804662 | PRJNA853203_P_NODE_45700_length_243_cov_0.917647_g45551_i0 | PRJNA853203 | 45700 | 243 | 0.917647 | 2.22988221 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 157 | 4.44e-44 | NR | DAI47033.1 | 2832643 | g45551 | i0 | 92.6 | 1 | 81 | 6 | 100 | 0 | 243 | 1 | 164 | 244 | DAI47033.1 MAG TPA: protein of unknown function (DUF5048) [Caudoviricetes sp.] | diamond | 243 | 157 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32812833 | 32812833 | PRJNA853203_P_NODE_11260_length_286_cov_1.258216_g11111_i0 | PRJNA853203 | 11260 | 286 | 1.258216 | 3.59849776 | Pawinskivirus | 3044787 | Viruses | Viruses | 62.4 | 2.15e-9 | NR | YP_010660900.1 | 2601632 | g11111 | i0 | 47.6 | 1.94055944055944 | 63 | 33 | 66.1 | 0 | 3 | 191 | 133 | 195 | YP_010660900.1 hypothetical protein PP933_gp160 [Pseudomonas phage vB_PaeM_PS119XW] | diamond | 555 | 62.8 | 0.993630573248408 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Pawinskivirus | Pawinskivirus PS119XW |
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);;