contig_metadata
21 rows where bioproject = "PRJEB75227" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135616 | 135616 | PRJEB75227_P_NODE_11421_length_243_cov_0.917647_g11250_i0 | PRJEB75227 | 11421 | 243 | 0.917647 | 2.22988221 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 333 | 6.989999999999999e-87 | NTclustered | gi|2914753680|gb|OR221409.1| | 2832643 | g11250 | i0 | 91.358 | 3.03292181069959 | 243 | 21 | 100 | 0 | 1 | 243 | 36180 | 36422 | MAG: Caudoviricetes sp. isolate MSP1678 genomic sequence | blastn | 737 | 333 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 135652 | 135652 | PRJEB75227_P_NODE_6901_length_273_cov_1.660000_g6730_i0 | PRJEB75227 | 6901 | 273 | 1.66 | 4.5318 | Pseudomonas phage PS-1 | 1573458 | Viruses | Viruses | 326 | 1.34e-84 | NTclustered | gi|985757644|ref|NC_029066.1| | 1573458 | g6730 | i0 | 88.235 | 0.996336996336996 | 272 | 32 | 99 | 0 | 2 | 273 | 28496 | 28225 | Pseudomonas phage PS-1 DNA, complete sequence | blastn | 272 | 326 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage PS-1 | |||||
| 135660 | 135660 | PRJEB75227_P_NODE_8461_length_252_cov_0.871508_g8290_i0 | PRJEB75227 | 8461 | 252 | 0.871508 | 2.19620016 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 422 | 1.51e-113 | NTclustered | gi|2059825520|tpg|BK040067.1| | 2832643 | g8290 | i0 | 96.825 | 20.0396825396825 | 252 | 8 | 100 | 0 | 1 | 252 | 11099 | 11350 | MAG TPA_asm: Caudoviricetes sp. isolate ctJwv2, partial genome | blastn | 5050 | 422 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2685755 | 2685755 | PRJEB75227_P_NODE_9083_length_250_cov_0.881356_g8912_i0 | PRJEB75227 | 9083 | 250 | 0.881356 | 2.20339 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 78.7 | 3.74e-10 | NTclustered | gi|2914887418|gb|OR222536.1| | 2832643 | g8912 | i0 | 94.118 | 0.608 | 51 | 3 | 20 | 0 | 46 | 96 | 9501 | 9451 | MAG: Caudoviricetes sp. isolate MSP0404 genomic sequence | blastn | 152 | 78.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14164032 | 14164032 | PRJEB75227_P_NODE_6852_length_274_cov_1.407960_g6681_i0 | PRJEB75227 | 6852 | 274 | 1.40796 | 3.8578104 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 63.9 | 1.16e-5 | NTclustered | gi|2054560186|tpg|BK048230.1| | 2832643 | g6681 | i0 | 88.889 | 0.197080291970803 | 54 | 3 | 19 | 3 | 160 | 212 | 39598 | 39649 | MAG TPA_asm: Caudoviricetes sp. isolate ctSe04, partial genome | blastn | 54 | 63.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14164036 | 14164036 | PRJEB75227_P_NODE_7392_length_265_cov_1.625000_g7221_i0 | PRJEB75227 | 7392 | 265 | 1.625 | 4.30625 | Pormufvirus salinum | 3431827 | Viruses | Viruses | 171 | 6.41e-38 | NTclustered | gi|2231638396|ref|NC_062761.1| | 2878009 | g7221 | i0 | 80 | 0.943396226415094 | 250 | 34 | 94 | 10 | 17 | 265 | 12526 | 12292 | Halorubrum virus HRTV-28, complete genome | blastn | 250 | 171 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Suolaviridae | Pormufvirus | Pormufvirus salinum | |||
| 15023558 | 15023558 | PRJEB75227_P_NODE_11052_length_244_cov_0.912281_g10881_i0 | PRJEB75227 | 11052 | 244 | 0.912281 | 2.22596564 | Viruses | 10239 | Viruses | Viruses | 296 | 9.21e-76 | NTclustered | gi|2548228115|gb|MZ573780.2| | 2861056 | g10881 | i0 | 88.797 | 1.98770491803279 | 241 | 27 | 99 | 0 | 1 | 241 | 120320 | 120560 | Mammaliicoccus phage vB_MscM-PMS3, complete genome | blastn | 485 | 296 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Mammaliicoccus phage vB_MscM-PMS3 | ||||
| 15438129 | 15438129 | PRJEB75227_P_NODE_7993_length_255_cov_1.714286_g7822_i0 | PRJEB75227 | 7993 | 255 | 1.714286 | 4.3714293 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 472 | 1.5e-128 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g7822 | i0 | 100 | 1 | 255 | 0 | 100 | 0 | 1 | 255 | 18855 | 19109 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 255 | 472 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21812444 | 21812444 | PRJEB75227_P_NODE_6618_length_278_cov_1.258537_g6447_i0 | PRJEB75227 | 6618 | 278 | 1.258537 | 3.49873286 | Percavirus equidgamma2 | 3050281 | Viruses | Viruses | 353 | 6.26e-93 | NTclustered | gi|2271301500|gb|MW322569.1| | 12657 | g6447 | i0 | 89.606 | 14.7086330935252 | 279 | 28 | 100 | 1 | 1 | 278 | 104003 | 104281 | Equid gammaherpesvirus 2 strain 1-141/67, complete genome | blastn | 4089 | 353 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Percavirus | Percavirus equidgamma2 | ||
| 26939092 | 26939092 | PRJEB75227_P_NODE_11702_length_242_cov_0.923077_g11531_i0 | PRJEB75227 | 11702 | 242 | 0.923077 | 2.23384634 | Pseudomonas phage PaBG | 1335230 | Viruses | Viruses | 72 | 1.77e-12 | NR | YP_008433438.2 | 1335230 | g11531 | i0 | 47.9 | 0.880165289256198 | 71 | 37 | 88 | 0 | 29 | 241 | 219 | 289 | YP_008433438.2 portal protein [Pseudomonas phage PaBG] | diamond | 213 | 72 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Baikalvirus | Baikalvirus PaBG | ||||
| 27034155 | 27034155 | PRJEB75227_P_NODE_11822_length_242_cov_0.923077_g11651_i0 | PRJEB75227 | 11822 | 242 | 0.923077 | 2.23384634 | Gordonia phage Stormageddon | 2656541 | Viruses | Viruses | 108 | 3.56e-26 | NR | YP_010059507.1 | 2656541 | g11651 | i0 | 65 | 0.991735537190083 | 80 | 28 | 99.2 | 0 | 1 | 240 | 112 | 191 | YP_010059507.1 hypothetical protein KHQ86_gp031 [Gordonia phage Stormageddon] | diamond | 240 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Stormageddonvirus | Stormageddonvirus Stormageddon | ||||
| 28297437 | 28297437 | PRJEB75227_P_NODE_11186_length_244_cov_0.912281_g11015_i0 | PRJEB75227 | 11186 | 244 | 0.912281 | 2.22596564 | Acinetobacter phage vB_AbaM_ME3 | 1837876 | Viruses | Viruses | 103 | 9.9e-26 | NR | YP_009595922.1 | 1837876 | g11015 | i0 | 88.5 | 0.639344262295082 | 52 | 6 | 63.9 | 0 | 242 | 87 | 117 | 168 | YP_009595922.1 hypothetical protein FDH01_gp090 [Acinetobacter phage vB_AbaM_ME3] | diamond | 156 | 103 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Metrivirus | Metrivirus ME3 | ||||
| 28487038 | 28487038 | PRJEB75227_P_NODE_8347_length_253_cov_0.866667_g8176_i0 | PRJEB75227 | 8347 | 253 | 0.866667 | 2.19266751 | Vibrio phage VvAW1 | 1168281 | Viruses | Viruses | 129 | 2.17e-33 | NR | YP_007518352.1 | 1168281 | g8176 | i0 | 90.9 | 1.56521739130435 | 66 | 6 | 78.3 | 0 | 1 | 198 | 354 | 419 | YP_007518352.1 major head protein [Vibrio phage VvAW1] | diamond | 396 | 129 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage VvAW1 | |||||
| 29276180 | 29276180 | PRJEB75227_P_NODE_4589_length_331_cov_1.209302_g4418_i0 | PRJEB75227 | 4589 | 331 | 1.209302 | 4.00278962 | Haloarcula californiae tailed virus 1 | 1273746 | Viruses | Viruses | 49.7 | 3.8e-4 | NR | YP_008059688.1 | 1273746 | g4418 | i0 | 28.9 | 1.03323262839879 | 114 | 69 | 97 | 5 | 7 | 327 | 455 | 563 | YP_008059688.1 hypothetical protein M202_gp093 [Haloarcula californiae tailed virus 1] | diamond | 342 | 49.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thumleimavirales | Druskaviridae | Hacavirus | Hacavirus italiense | ||
| 29560340 | 29560340 | PRJEB75227_P_NODE_9190_length_250_cov_0.881356_g9019_i0 | PRJEB75227 | 9190 | 250 | 0.881356 | 2.20339 | environmental Halophage eHP-28 | 1168829 | Viruses | Viruses | 45.4 | 0.00362 | NR | AFH22500.1 | 1168829 | g9019 | i0 | 29.1 | 0.948 | 79 | 51 | 93.6 | 2 | 17 | 250 | 138 | 212 | AFH22500.1 hypothetical protein OSG_eHP28_00040 [environmental Halophage eHP-28] | diamond | 237 | 45.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kirjokansivirales | Shortaselviridae | environmental Halophage eHP-28 | |||
| 30065668 | 30065668 | PRJEB75227_P_NODE_7712_length_260_cov_1.374332_g7541_i0 | PRJEB75227 | 7712 | 260 | 1.374332 | 3.5732632 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 44.7 | 0.00931 | NR | XOR51479.1 | 2832643 | g7541 | i0 | 47.1 | 0.588461538461538 | 51 | 27 | 58.8 | 0 | 106 | 258 | 71 | 121 | XOR51479.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 153 | 44.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30319117 | 30319117 | PRJEB75227_P_NODE_7332_length_266_cov_1.616580_g7161_i0 | PRJEB75227 | 7332 | 266 | 1.61658 | 4.3001028 | Pseudomonas phage vB_PpS_SYP | 3020390 | Viruses | Viruses | 109 | 1.86e-25 | NR | WCO82078.1 | 3020390 | g7161 | i0 | 56.8 | 1.98496240601504 | 88 | 37 | 98.1 | 1 | 264 | 4 | 317 | 404 | WCO82078.1 putative DNA polymerase [Pseudomonas phage vB_PpS_SYP] | diamond | 528 | 109 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage vB_PpS_SYP | |||||
| 30476680 | 30476680 | PRJEB75227_P_NODE_11873_length_242_cov_0.857988_g11702_i0 | PRJEB75227 | 11873 | 242 | 0.857988 | 2.07633096 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 92.8 | 7.98e-20 | NR | CAB4129083.1 | 2100421 | g11702 | i0 | 63.3 | 1.95867768595041 | 79 | 29 | 97.9 | 0 | 242 | 6 | 400 | 478 | CAB4129083.1 large terminase protein [uncultured Caudovirales phage] | diamond | 474 | 92.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30950661 | 30950661 | PRJEB75227_P_NODE_8334_length_253_cov_0.866667_g8163_i0 | PRJEB75227 | 8334 | 253 | 0.866667 | 2.19266751 | Salicola phage CGphi29 | 754067 | Viruses | Viruses | 86.7 | 4.51e-18 | NR | YP_007673700.1 | 754067 | g8163 | i0 | 87.2 | 0.462450592885375 | 39 | 5 | 46.2 | 0 | 1 | 117 | 271 | 309 | YP_007673700.1 hypothetical protein SLPG_00018 [Salicola phage CGphi29] | diamond | 117 | 86.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Salicola phage CGphi29 | |||||
| 31488133 | 31488133 | PRJEB75227_P_NODE_7336_length_266_cov_1.616580_g7165_i0 | PRJEB75227 | 7336 | 266 | 1.61658 | 4.3001028 | Brevundimonas phage vB_BpoS-StAshley | 2948608 | Viruses | Viruses | 102 | 2.3e-26 | NR | UTC29989.1 | 2948608 | g7165 | i0 | 65.3 | 0.845864661654135 | 75 | 26 | 84.6 | 0 | 30 | 254 | 1 | 75 | UTC29989.1 hypothetical protein STASHLEY_00550 [Brevundimonas phage vB_BpoS-StAshley] | diamond | 225 | 102 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Brevundimonas phage vB_BpoS-StAshley | |||||
| 32783834 | 32783834 | PRJEB75227_P_NODE_11040_length_244_cov_0.912281_g10869_i0 | PRJEB75227 | 11040 | 244 | 0.912281 | 2.22596564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 68.6 | 1.11e-12 | NR | XOR29526.1 | 2832643 | g10869 | i0 | 47.6 | 0.774590163934426 | 63 | 33 | 77.5 | 0 | 51 | 239 | 8 | 70 | XOR29526.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 189 | 68.6 | 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);;