contig_metadata
23 rows where analysis = "diamond" and tax_phylum = "Peploviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26908602 | 26908602 | PRJNA1035005_P_NODE_682_length_1825_cov_2.680365_g527_i0 | PRJNA1035005 | 682 | 1825 | 2.680365 | 48.91666125 | Bovine gammaherpesvirus 6 | 1504288 | Viruses | Viruses | 192 | 8.76e-51 | NR | YP_009041983.1 | 1504288 | g527 | i0 | 38.1 | 0.512876712328767 | 312 | 128 | 51.1 | 7 | 1 | 933 | 183 | 430 | YP_009041983.1 ornithine decarboxylase [Bovine gammaherpesvirus 6] | diamond | 936 | 192 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Macavirus | Macavirus bovinegamma6 | ||
| 27198770 | 27198770 | PRJNA1200128_S_NODE_47542_length_152_cov_1.724771_g47433_i0 | PRJNA1200128 | 47542 | 152 | 1.724771 | 2.62165192 | Bovine herpesvirus type 1.1 | 79889 | Viruses | Viruses | 45.1 | 0.0011 | NR | YP_010374251.1 | 79889 | g47433 | i0 | 45.8 | 0.947368421052632 | 48 | 22 | 86.8 | 1 | 12 | 143 | 67 | 114 | YP_010374251.1 product of latency-related protein [Bovine herpesvirus type 1.1] | diamond | 144 | 45.1 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Varicellovirus | Varicellovirus bovinealpha1 | ||
| 27360989 | 27360989 | PRJNA485334_P_NODE_7783_length_250_cov_0.870056_g7752_i0 | PRJNA485334 | 7783 | 250 | 0.870056 | 2.17514 | Vombatid gammaherpesvirus 1 | 2052651 | Viruses | Viruses | 42.7 | 0.0401 | NR | YP_010087438.1 | 2052651 | g7752 | i0 | 44.2 | 0.624 | 52 | 28 | 62.4 | 1 | 175 | 20 | 43 | 93 | YP_010087438.1 putative glycoprotein [Vombatid gammaherpesvirus 1] | diamond | 156 | 42.7 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Manticavirus | Manticavirus vombatidgamma1 | ||
| 27662053 | 27662053 | PRJNA604017_P_NODE_1144_length_430_cov_1.928753_g1006_i0 | PRJNA604017 | 1144 | 430 | 1.928753 | 8.2936379 | root | 1 | Root_unresolved | Root_unresolved | 172 | 1.29e-47 | NR | XNM00019.1 | 10334 | g1006 | i0 | 70.7 | 60.3906976744186 | 123 | 36 | 85.8 | 0 | 62 | 430 | 345 | 467 | XNM00019.1 thymidine kinase fused to mCherry [Felid alphaherpesvirus 1] | diamond | 25968 | 173 | 0.994219653179191 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Varicellovirus | Varicellovirus felidalpha1 | ||
| 27861672 | 27861672 | PRJNA1168532_S_NODE_128145_length_283_cov_3.020833_g125202_i0 | PRJNA1168532 | 128145 | 283 | 3.020833 | 8.54895739 | Human alphaherpesvirus 1 | 10298 | Viruses | Viruses | 55.1 | 5.09e-8 | NR | DAC85507.1 | 10298 | g125202 | i0 | 68.6 | 0.68904593639576 | 35 | 11 | 37.1 | 0 | 42 | 146 | 1 | 35 | DAC85507.1 TPA_asm: UL22 uORF 2, partial [Human alphaherpesvirus 1] | diamond | 195 | 55.1 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha1 | ||
| 28057882 | 28057882 | PRJNA557436_S_NODE_245_length_676_cov_3.099844_g212_i0 | PRJNA557436 | 245 | 676 | 3.099844 | 20.95494544 | Anatid alphaherpesvirus 2 | 3080522 | Viruses | Viruses | 43.5 | 0.042 | NR | XCO53314.1 | 3080522 | g212 | i0 | 43.1 | 0.257396449704142 | 58 | 26 | 25.7 | 2 | 434 | 607 | 9 | 59 | XCO53314.1 hypothetical protein [Anatid alphaherpesvirus 2] | diamond | 174 | 43.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Anatid alphaherpesvirus 2 | |||
| 28087717 | 28087717 | PRJNA508758_P_NODE_83625_length_244_cov_0.918129_g82577_i0 | PRJNA508758 | 83625 | 244 | 0.918129 | 2.24023476 | Human alphaherpesvirus 2 | 10310 | Viruses | Viruses | 43.9 | 0.0107 | NR | QBH85162.1 | 10310 | g82577 | i0 | 38.7 | 0.922131147540984 | 75 | 41 | 89.8 | 3 | 5 | 223 | 93 | 164 | QBH85162.1 hypothetical protein [Human alphaherpesvirus 2] | diamond | 225 | 43.9 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha2 | ||
| 28146503 | 28146503 | PRJNA1195551_S_NODE_32645_length_178_cov_1.255814_g32292_i0 | PRJNA1195551 | 32645 | 178 | 1.255814 | 2.23534892 | Murid betaherpesvirus 1 | 10366 | Viruses | Viruses | 41.6 | 0.0408 | NR | AWV68369.1 | 10366 | g32292 | i0 | 50 | 0.606741573033708 | 36 | 18 | 60.7 | 0 | 154 | 47 | 344 | 379 | AWV68369.1 m117.1 protein [Murid betaherpesvirus 1] | diamond | 108 | 41.6 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Muromegalovirus | Muromegalovirus muridbeta1 | ||
| 28192028 | 28192028 | PRJNA877763_S_NODE_7546_length_242_cov_2.479290_g7541_i0 | PRJNA877763 | 7546 | 242 | 2.47929 | 5.9998818 | Herpesvirus betta183851 | 3116689 | Viruses | Viruses | 42.4 | 0.0466 | NR | DBA46627.1 | 3116689 | g7541 | i0 | 40.8 | 0.880165289256198 | 71 | 34 | 83.1 | 3 | 22 | 222 | 39 | 105 | DBA46627.1 MAG TPA_asm: Tunf [Herpesvirus betta183851] | diamond | 213 | 42.4 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Herpesvirus betta183851 | ||||
| 28856001 | 28856001 | PRJNA911178_P_NODE_292448_length_241_cov_0.916667_g289974_i0 | PRJNA911178 | 292448 | 241 | 0.916667 | 2.20916747 | Cyprinid herpesvirus 1 | 317858 | Viruses | Viruses | 43.1 | 0.019 | NR | YP_007003701.1 | 317858 | g289974 | i0 | 31.2 | 0.95850622406639 | 77 | 48 | 95.9 | 3 | 4 | 234 | 92 | 163 | YP_007003701.1 protein ORF32 [Cyprinid herpesvirus 1] | diamond | 231 | 43.1 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Alloherpesviridae | Cyvirus | Cyprinid herpesvirus 1 | ||
| 29063425 | 29063425 | PRJNA1255065_P_NODE_104728_length_169_cov_1.325000_g102500_i0 | PRJNA1255065 | 104728 | 169 | 1.325 | 2.23925 | Human alphaherpesvirus 1 | 10298 | Viruses | Viruses | 40.8 | 0.00564 | NR | DAC85507.1 | 10298 | g102500 | i0 | 75 | 0.42603550295858 | 24 | 6 | 42.6 | 0 | 168 | 97 | 12 | 35 | DAC85507.1 TPA_asm: UL22 uORF 2, partial [Human alphaherpesvirus 1] | diamond | 72 | 40.8 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha1 | ||
| 29088860 | 29088860 | PRJNA1108009_P_NODE_25248_length_250_cov_1.542373_g24930_i0 | PRJNA1108009 | 25248 | 250 | 1.542373 | 3.8559325 | Human alphaherpesvirus 2 | 10310 | Viruses | Viruses | 43.9 | 0.0115 | NR | QBH85162.1 | 10310 | g24930 | i0 | 37.2 | 1.488 | 78 | 44 | 91.2 | 3 | 11 | 238 | 90 | 164 | QBH85162.1 hypothetical protein [Human alphaherpesvirus 2] | diamond | 372 | 43.9 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha2 | ||
| 29101239 | 29101239 | PRJNA608163_P_NODE_3508_length_260_cov_2.320856_g3468_i0 | PRJNA608163 | 3508 | 260 | 2.320856 | 6.0342256 | Human alphaherpesvirus 2 | 10310 | Viruses | Viruses | 47.4 | 6.74e-4 | NR | QBH85162.1 | 10310 | g3468 | i0 | 41.3 | 0.865384615384615 | 75 | 39 | 84.2 | 3 | 34 | 252 | 93 | 164 | QBH85162.1 hypothetical protein [Human alphaherpesvirus 2] | diamond | 225 | 47.4 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha2 | ||
| 29161200 | 29161200 | PRJNA493827_P_NODE_120189_length_311_cov_12.193277_g117991_i0 | PRJNA493827 | 120189 | 311 | 12.193277 | 37.92109147 | Lake sturgeon herpesvirus | 2922427 | Viruses | Viruses | 68.9 | 4.87e-11 | NR | UMM52724.1 | 2922427 | g117991 | i0 | 40.4 | 1.0032154340836 | 104 | 51 | 90.7 | 3 | 311 | 30 | 305 | 407 | UMM52724.1 protein ORF46 [Lake sturgeon herpesvirus] | diamond | 312 | 68.9 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Alloherpesviridae | Lake sturgeon herpesvirus | |||
| 29324009 | 29324009 | PRJNA681822_P_NODE_371749_length_254_cov_1.519337_g370260_i0 | PRJNA681822 | 371749 | 254 | 1.519337 | 3.85911598 | Human alphaherpesvirus 2 | 10310 | Viruses | Viruses | 45.4 | 0.00322 | NR | QBH85162.1 | 10310 | g370260 | i0 | 40.6 | 0.81496062992126 | 69 | 36 | 79.1 | 3 | 222 | 22 | 93 | 158 | QBH85162.1 hypothetical protein [Human alphaherpesvirus 2] | diamond | 207 | 45.4 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha2 | ||
| 29465160 | 29465160 | PRJEB66218_P_NODE_153510_length_239_cov_1.325843_g151081_i0 | PRJEB66218 | 153510 | 239 | 1.325843 | 3.16876477 | Human alphaherpesvirus 2 | 10310 | Viruses | Viruses | 42.7 | 0.0264 | NR | QBH85162.1 | 10310 | g151081 | i0 | 41.8 | 0.690376569037657 | 55 | 28 | 67.8 | 2 | 63 | 224 | 93 | 144 | QBH85162.1 hypothetical protein [Human alphaherpesvirus 2] | diamond | 165 | 42.7 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha2 | ||
| 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 | ||
| 30071664 | 30071664 | PRJNA1148190_P_NODE_780072_length_241_cov_0.916667_g768899_i0 | PRJNA1148190 | 780072 | 241 | 0.916667 | 2.20916747 | Suid alphaherpesvirus 1 | 10345 | Viruses | Viruses | 42.4 | 0.0492 | NR | AMR55904.1 | 10345 | g768899 | i0 | 56.1 | 0.510373443983402 | 41 | 11 | 48.5 | 3 | 123 | 239 | 814 | 849 | AMR55904.1 helicase-primase primase subunit [Suid alphaherpesvirus 1] | diamond | 123 | 42.4 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Varicellovirus | Varicellovirus suidalpha1 | ||
| 30469984 | 30469984 | PRJNA1112809_P_NODE_154673_length_259_cov_1.596774_g151398_i0 | PRJNA1112809 | 154673 | 259 | 1.596774 | 4.13564466 | root | 1 | Root_unresolved | Root_unresolved | 172 | 6.01e-52 | NR | AAA66528.1 | 10376 | g151398 | i0 | 100 | 7.96911196911197 | 86 | 0 | 99.6 | 0 | 259 | 2 | 154 | 239 | AAA66528.1 BRLF1, partial [human gammaherpesvirus 4] | diamond | 2064 | 172 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 31253085 | 31253085 | PRJNA734313_S_NODE_8335_length_322_cov_35.116364_g8222_i0 | PRJNA734313 | 8335 | 322 | 35.116364 | 113.07469208 | Human alphaherpesvirus 1 | 10298 | Viruses | Viruses | 52.4 | 9.13e-7 | NR | DAC85507.1 | 10298 | g8222 | i0 | 68.6 | 1.04347826086957 | 35 | 11 | 32.6 | 0 | 112 | 8 | 1 | 35 | DAC85507.1 TPA_asm: UL22 uORF 2, partial [Human alphaherpesvirus 1] | diamond | 336 | 52.4 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha1 | ||
| 31666983 | 31666983 | PRJNA874604_P_NODE_54437_length_276_cov_1.339901_g54085_i0 | PRJNA874604 | 54437 | 276 | 1.339901 | 3.69812676 | Human alphaherpesvirus 2 | 10310 | Viruses | Viruses | 46.6 | 0.00153 | NR | QBH85162.1 | 10310 | g54085 | i0 | 46.9 | 0.532608695652174 | 49 | 22 | 52.2 | 2 | 15 | 158 | 93 | 138 | QBH85162.1 hypothetical protein [Human alphaherpesvirus 2] | diamond | 147 | 46.6 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha2 | ||
| 31760978 | 31760978 | PRJNA811542_S_NODE_4617_length_297_cov_2.629464_g4507_i0 | PRJNA811542 | 4617 | 297 | 2.629464 | 7.80950808 | Herpesvirus dreissena36345 | 3116694 | Viruses | Viruses | 42.7 | 0.0226 | NR | DBA50078.1 | 3116694 | g4507 | i0 | 31.6 | 0.797979797979798 | 79 | 42 | 77.8 | 2 | 232 | 2 | 6 | 74 | DBA50078.1 MAG TPA_asm: IAP9 [Herpesvirus dreissena36345] | diamond | 237 | 42.7 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Herpesvirus dreissena36345 | ||||
| 31900630 | 31900630 | PRJNA1068830_P_NODE_46757_length_321_cov_2.092742_g46054_i0 | PRJNA1068830 | 46757 | 321 | 2.092742 | 6.71770182 | Marmot herpesvirus 1 | 2879123 | Viruses | Viruses | 72.4 | 3.3e-12 | NR | UNP64532.1 | 2879123 | g46054 | i0 | 37.5 | 0.822429906542056 | 88 | 54 | 81.3 | 1 | 49 | 309 | 175 | 262 | UNP64532.1 hypothetical protein [Marmot herpesvirus 1] | diamond | 264 | 72.4 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Marmot herpesvirus 1 |
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);;