contig_metadata
14 rows where bioproject = "PRJNA724011" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3261836 | 3261836 | PRJNA724011_P_NODE_30543_length_499_cov_25.342723_g29525_i0 | PRJNA724011 | 30543 | 499 | 25.342723 | 126.46018777 | Acinetobacter phage YC#06 | 2945929 | Viruses | Viruses | 922 | 0 | NTclustered | gi|2248480528|gb|ON391949.1| | 2945929 | g29525 | i0 | 100 | 102 | 499 | 0 | 100 | 0 | 1 | 499 | 47845 | 47347 | Acinetobacter phage YC#06, complete genome | blastn | 50898 | 922 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vieuvirus | Acinetobacter phage YC#06 | ||||
| 5022260 | 5022260 | PRJNA724011_P_NODE_67104_length_308_cov_1.914894_g66081_i0 | PRJNA724011 | 67104 | 308 | 1.914894 | 5.89787352 | Rosebushvirus | 1982900 | Viruses | Viruses | 52.8 | 0.029 | NTclustered | gi|354997285|gb|JN699004.1| | 1089112 | g66081 | i0 | 100 | 1.18181818181818 | 28 | 0 | 9 | 0 | 243 | 270 | 43466 | 43439 | Mycobacterium phage Ares, complete genome | blastn | 364 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rosebushvirus | Rosebushvirus godines | ||||
| 9639417 | 9639417 | PRJNA724011_P_NODE_86468_length_264_cov_2.010471_g85445_i0 | PRJNA724011 | 86468 | 264 | 2.010471 | 5.30764344 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2058119099|tpg|BK033893.1| | 2832643 | g85445 | i0 | 94.444 | 0.136363636363636 | 36 | 0 | 13 | 2 | 152 | 186 | 22982 | 23016 | MAG TPA_asm: Caudoviricetes sp. isolate ctR2M13, partial genome | blastn | 36 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17288379 | 17288379 | PRJNA724011_P_NODE_101034_length_246_cov_1.699422_g100011_i0 | PRJNA724011 | 101034 | 246 | 1.699422 | 4.18057812 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 399 | 6.889999999999999e-107 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g100011 | i0 | 95.935 | 283.121951219512 | 246 | 10 | 100 | 0 | 1 | 246 | 17861 | 18106 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 69648 | 399 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17771486 | 17771486 | PRJNA724011_P_NODE_110234_length_241_cov_0.916667_g109211_i0 | PRJNA724011 | 110234 | 241 | 0.916667 | 2.20916747 | Christensenvirus | 2732061 | Viruses | Viruses | 446 | 8.519999999999999e-121 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g109211 | i0 | 100 | 6.46058091286307 | 241 | 0 | 100 | 0 | 1 | 241 | 42324 | 42084 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 1557 | 446 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 22388353 | 22388353 | PRJNA724011_P_NODE_89098_length_259_cov_1.655914_g88075_i0 | PRJNA724011 | 89098 | 259 | 1.655914 | 4.28881726 | Vibrio phage henriette 12B8 | 573174 | Viruses | Viruses | 52.8 | 0.024 | NTclustered | gi|481019622|ref|NC_021073.1| | 573174 | g88075 | i0 | 100 | 0.108108108108108 | 28 | 0 | 11 | 0 | 188 | 215 | 100300 | 100327 | Vibrio phage henriette 12B8, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage henriette 12B8 | |||||
| 23663466 | 23663466 | PRJNA724011_P_NODE_14679_length_796_cov_3.177040_g13737_i0 | PRJNA724011 | 14679 | 796 | 3.17704 | 25.2892384 | Magiavirus magia | 3060177 | Viruses | Viruses | 54.7 | 0.022 | NTclustered | gi|2438096121|ref|NC_070954.1| | 2767577 | g13737 | i0 | 100 | 0.0364321608040201 | 29 | 0 | 4 | 0 | 145 | 173 | 3353 | 3325 | Burkholderia phage Magia, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Magiavirus | Magiavirus magia | ||||
| 27368547 | 27368547 | PRJNA724011_P_NODE_28543_length_521_cov_5.700893_g27526_i0 | PRJNA724011 | 28543 | 521 | 5.700893 | 29.70165253 | uncultured phage_MedDCM-OCT-S35-C6 | 2741075 | Viruses | Viruses | 104 | 3.25e-25 | NR | YP_010761261.1 | 2741075 | g27526 | i0 | 39.7 | 0.81190019193858 | 141 | 74 | 79.5 | 2 | 23 | 436 | 7 | 139 | YP_010761261.1 baseplate hub subunit and tail lysozyme [uncultured phage_MedDCM-OCT-S35-C6] | diamond | 423 | 104 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Pelagivirus | Pelagivirus S35C6 | |||
| 27620990 | 27620990 | PRJNA724011_P_NODE_74504_length_289_cov_2.282407_g73481_i0 | PRJNA724011 | 74504 | 289 | 2.282407 | 6.59615623 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 44.3 | 0.0162 | NR | DAO28100.1 | 2832643 | g73481 | i0 | 29.3 | 0.778546712802768 | 75 | 51 | 76.8 | 2 | 253 | 32 | 20 | 93 | DAO28100.1 MAG TPA: phosphoadenosine-phosphosulfate reductase [Caudoviricetes sp.] | diamond | 225 | 44.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27936664 | 27936664 | PRJNA724011_P_NODE_31705_length_488_cov_1.626506_g30686_i0 | PRJNA724011 | 31705 | 488 | 1.626506 | 7.93734928 | Synechococcus phage S-SM2 | 444860 | Viruses | Viruses | 47.4 | 0.00865 | NR | YP_004322274.1 | 444860 | g30686 | i0 | 27.1 | 2.34836065573771 | 129 | 84 | 73.2 | 4 | 13 | 369 | 134 | 262 | YP_004322274.1 head scaffolding protein [Synechococcus phage S-SM2] | diamond | 1146 | 47.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Kyanoviridae | Nilusvirus | Nilusvirus ssm2 | ||
| 29231320 | 29231320 | PRJNA724011_P_NODE_76629_length_285_cov_1.089623_g75606_i0 | PRJNA724011 | 76629 | 285 | 1.089623 | 3.10542555 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 41.2 | 0.0189 | NR | DAU75828.1 | 2832643 | g75606 | i0 | 58.6 | 0.305263157894737 | 29 | 12 | 30.5 | 0 | 169 | 83 | 1 | 29 | DAU75828.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 87 | 41.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29704354 | 29704354 | PRJNA724011_P_NODE_83750_length_270_cov_1.065990_g82727_i0 | PRJNA724011 | 83750 | 270 | 1.06599 | 2.878173 | Human alphaherpesvirus 2 | 10310 | Viruses | Viruses | 43.1 | 0.0349 | NR | QBH85097.1 | 10310 | g82727 | i0 | 48.5 | 3.77777777777778 | 68 | 24 | 75.6 | 3 | 244 | 41 | 126 | 182 | QBH85097.1 hypothetical protein [Human alphaherpesvirus 2] | diamond | 1020 | 43.1 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha2 | ||
| 31379380 | 31379380 | PRJNA724011_P_NODE_104036_length_244_cov_1.801170_g103013_i0 | PRJNA724011 | 104036 | 244 | 1.80117 | 4.3948548 | Aeromonas phage ST4 | 3065692 | Viruses | Viruses | 116 | 2.66e-28 | NR | WNL63637.1 | 3065692 | g103013 | i0 | 75 | 0.934426229508197 | 76 | 19 | 93.4 | 0 | 242 | 15 | 29 | 104 | WNL63637.1 tail sheath protein [Aeromonas phage ST4] | diamond | 228 | 116 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aeromonas phage ST4 | |||||
| 31980279 | 31980279 | PRJNA724011_P_NODE_57278_length_338_cov_1.815094_g56255_i0 | PRJNA724011 | 57278 | 338 | 1.815094 | 6.13501772 | Vibrio phage 252E42.2 | 2859319 | Viruses | Viruses | 91.3 | 4.56e-19 | NR | QZI91326.1 | 2859319 | g56255 | i0 | 42 | 0.887573964497041 | 100 | 58 | 88.8 | 0 | 37 | 336 | 2 | 101 | QZI91326.1 putative recombination-associated protein [Vibrio phage 252E42.2] | diamond | 300 | 91.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage 252E42.2 |
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);;