contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA825466" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3371313 | 3371313 | PRJNA825466_P_NODE_8143_length_306_cov_0.991416_g8042_i0 | PRJNA825466 | 8143 | 306 | 0.991416 | 3.03373296 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 566 | 8.239999999999998e-157 | NTclustered | gi|1386447295|gb|MG298834.1| | 10376 | g8042 | i0 | 100 | 100.356209150327 | 306 | 0 | 100 | 0 | 1 | 306 | 4780 | 5085 | Human gammaherpesvirus 4 isolate GK_BL42, partial genome | blastn | 30709 | 566 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 3780074 | 3780074 | PRJNA825466_P_NODE_24443_length_244_cov_2.239766_g24342_i0 | PRJNA825466 | 24443 | 244 | 2.239766 | 5.46502904 | Lymphocryptovirus | 10375 | Viruses | Viruses | 446 | 8.639999999999999e-121 | NTclustered | gi|1540305393|gb|MH590479.1| | 10376 | g24342 | i0 | 99.59 | 100 | 244 | 1 | 100 | 0 | 1 | 244 | 49524 | 49767 | Human gammaherpesvirus 4 isolate HKHD110, partial genome | blastn | 24400 | 446 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 5056171 | 5056171 | PRJNA825466_P_NODE_15684_length_254_cov_1.276243_g15583_i0 | PRJNA825466 | 15684 | 254 | 1.276243 | 3.24165722 | Lymphocryptovirus | 10375 | Viruses | Viruses | 464 | 2.4999999999999994e-126 | NTclustered | gi|1862857967|emb|LR812925.1| | 10376 | g15583 | i0 | 99.606 | 100 | 254 | 1 | 100 | 0 | 1 | 254 | 28320 | 28067 | Human gammaherpesvirus 4 isolate eBL_CL-01 genome assembly, chromosome: EBV | blastn | 25400 | 464 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 5923701 | 5923701 | PRJNA825466_P_NODE_7345_length_314_cov_1.701245_g7244_i0 | PRJNA825466 | 7345 | 314 | 1.701245 | 5.3419093 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 580 | 3.0299999999999992e-161 | NTclustered | gi|747017592|dbj|AB850660.1| | 10376 | g7244 | i0 | 100 | 278.46178343949 | 314 | 0 | 100 | 0 | 1 | 314 | 169437 | 169124 | Human herpesvirus 4 DNA, complete genome, strain: HN18 | blastn | 87437 | 580 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 8473316 | 8473316 | PRJNA825466_P_NODE_16407_length_251_cov_0.865169_g16306_i0 | PRJNA825466 | 16407 | 251 | 0.865169 | 2.17157419 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 464 | 2.47e-126 | NTclustered | gi|747017440|dbj|AB850654.1| | 10376 | g16306 | i0 | 100 | 100.517928286853 | 251 | 0 | 100 | 0 | 1 | 251 | 118549 | 118799 | Human herpesvirus 4 DNA, complete genome, strain: HN15 | blastn | 25230 | 464 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 8881193 | 8881193 | PRJNA825466_P_NODE_14667_length_260_cov_1.176471_g14566_i0 | PRJNA825466 | 14667 | 260 | 1.176471 | 3.0588246 | Lymphocryptovirus | 10375 | Viruses | Viruses | 481 | 2.55e-131 | NTclustered | gi|1862917033|emb|LR812981.1| | 10376 | g14566 | i0 | 100 | 100.992307692308 | 260 | 0 | 100 | 0 | 1 | 260 | 113682 | 113941 | Human gammaherpesvirus 4 isolate HC-0002 genome assembly, chromosome: EBV | blastn | 26258 | 481 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 8881219 | 8881219 | PRJNA825466_P_NODE_4807_length_358_cov_1.010526_g4706_i0 | PRJNA825466 | 4807 | 358 | 1.010526 | 3.61768308 | Lymphocryptovirus | 10375 | Viruses | Viruses | 662 | 0 | NTclustered | gi|1519305892|dbj|AP019128.1| | 10376 | g4706 | i0 | 100 | 100 | 358 | 0 | 100 | 0 | 1 | 358 | 54227 | 54584 | Human gammaherpesvirus 4 UPN326_PBMC DNA, nearly complete genome | blastn | 35800 | 662 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 11024166 | 11024166 | PRJNA825466_P_NODE_29209_length_241_cov_0.904762_g29108_i0 | PRJNA825466 | 29209 | 241 | 0.904762 | 2.18047642 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 446 | 8.519999999999999e-121 | NTclustered | gi|747017592|dbj|AB850660.1| | 10376 | g29108 | i0 | 100 | 101.701244813278 | 241 | 0 | 100 | 0 | 1 | 241 | 36234 | 36474 | Human herpesvirus 4 DNA, complete genome, strain: HN18 | blastn | 24510 | 446 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 11431930 | 11431930 | PRJNA825466_P_NODE_28149_length_241_cov_1.375000_g28048_i0 | PRJNA825466 | 28149 | 241 | 1.375 | 3.31375 | Lymphocryptovirus | 10375 | Viruses | Viruses | 446 | 8.519999999999999e-121 | NTclustered | gi|1862917033|emb|LR812981.1| | 10376 | g28048 | i0 | 100 | 100 | 241 | 0 | 100 | 0 | 1 | 241 | 23586 | 23346 | Human gammaherpesvirus 4 isolate HC-0002 genome assembly, chromosome: EBV | blastn | 24100 | 446 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 13981950 | 13981950 | PRJNA825466_P_NODE_18351_length_250_cov_0.870056_g18250_i0 | PRJNA825466 | 18351 | 250 | 0.870056 | 2.17514 | Lymphocryptovirus | 10375 | Viruses | Viruses | 462 | 8.83e-126 | NTclustered | gi|1862917033|emb|LR812981.1| | 10376 | g18250 | i0 | 100 | 101 | 250 | 0 | 100 | 0 | 1 | 250 | 112819 | 113068 | Human gammaherpesvirus 4 isolate HC-0002 genome assembly, chromosome: EBV | blastn | 25250 | 462 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 15256161 | 15256161 | PRJNA825466_P_NODE_20592_length_248_cov_0.880000_g20491_i0 | PRJNA825466 | 20592 | 248 | 0.88 | 2.1824 | Lymphocryptovirus | 10375 | Viruses | Viruses | 459 | 1.13e-124 | NTclustered | gi|1862917033|emb|LR812981.1| | 10376 | g20491 | i0 | 100 | 100 | 248 | 0 | 100 | 0 | 1 | 248 | 114431 | 114184 | Human gammaherpesvirus 4 isolate HC-0002 genome assembly, chromosome: EBV | blastn | 24800 | 459 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 21630125 | 21630125 | PRJNA825466_P_NODE_10797_length_283_cov_1.028571_g10696_i0 | PRJNA825466 | 10797 | 283 | 1.028571 | 2.91085593 | Lymphocryptovirus | 10375 | Viruses | Viruses | 512 | 9.97e-141 | NTclustered | gi|1519305892|dbj|AP019128.1| | 10376 | g10696 | i0 | 99.293 | 101 | 283 | 2 | 100 | 0 | 1 | 283 | 151862 | 151580 | Human gammaherpesvirus 4 UPN326_PBMC DNA, nearly complete genome | blastn | 28583 | 512 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 24179791 | 24179791 | PRJNA825466_P_NODE_4979_length_354_cov_1.064057_g4878_i0 | PRJNA825466 | 4979 | 354 | 1.064057 | 3.76676178 | Lymphocryptovirus | 10375 | Viruses | Viruses | 641 | 1.5599999999999998e-179 | NTclustered | gi|2086089088|gb|MT648653.1| | 10376 | g4878 | i0 | 100 | 98.0254237288136 | 347 | 0 | 98 | 0 | 8 | 354 | 48655 | 49001 | Human gammaherpesvirus 4 isolate Necker-12, partial genome | blastn | 34701 | 641 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 25454732 | 25454732 | PRJNA825466_P_NODE_12060_length_275_cov_1.084158_g11959_i0 | PRJNA825466 | 12060 | 275 | 1.084158 | 2.9814345 | Lymphocryptovirus | 10375 | Viruses | Viruses | 508 | 1.2499999999999999e-139 | NTclustered | gi|1862917033|emb|LR812981.1| | 10376 | g11959 | i0 | 100 | 100 | 275 | 0 | 100 | 0 | 1 | 275 | 31223 | 30949 | Human gammaherpesvirus 4 isolate HC-0002 genome assembly, chromosome: EBV | blastn | 27500 | 508 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 |
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);;