contig_metadata
6 rows where bioproject = "PRJNA896973" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5072090 | 5072090 | PRJNA896973_P_NODE_23944_length_247_cov_1.770115_g23850_i0 | PRJNA896973 | 23944 | 247 | 1.770115 | 4.37218405 | Lymphocryptovirus | 10375 | Viruses | Viruses | 457 | 4.05e-124 | NTclustered | gi|747017565|dbj|AB850658.1| | 10376 | g23850 | i0 | 100 | 131.931174089069 | 247 | 0 | 100 | 0 | 1 | 247 | 40275 | 40521 | Human herpesvirus 4 DNA, complete genome, strain: HN17 | blastn | 32587 | 457 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 9801168 | 9801168 | PRJNA896973_P_NODE_2888_length_588_cov_3.320388_g2797_i0 | PRJNA896973 | 2888 | 588 | 3.320388 | 19.52388144 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 1081 | 0 | NTclustered | gi|2086089260|gb|MT648656.1| | 10376 | g2797 | i0 | 99.83 | 260.816326530612 | 588 | 1 | 100 | 0 | 1 | 588 | 38086 | 38673 | Human gammaherpesvirus 4 isolate Necker-15, partial genome | blastn | 153360 | 1081 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 18724439 | 18724439 | PRJNA896973_P_NODE_12935_length_310_cov_1.624473_g12841_i0 | PRJNA896973 | 12935 | 310 | 1.624473 | 5.0358663 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 573 | 4.999999999999998e-159 | NTclustered | gi|1465382793|emb|LS992257.1| | 10376 | g12841 | i0 | 100 | 100 | 310 | 0 | 100 | 0 | 1 | 310 | 166672 | 166363 | Human gammaherpesvirus 4 isolate Human herpesvirus 4 genome assembly, chromosome: I | blastn | 31000 | 573 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 21646212 | 21646212 | PRJNA896973_P_NODE_5697_length_440_cov_2.002725_g5603_i0 | PRJNA896973 | 5697 | 440 | 2.002725 | 8.81199 | root | 1 | Root_unresolved | Root_unresolved | 813 | 0 | NTclustered | gi|1465382793|emb|LS992257.1| | 10376 | g5603 | i0 | 100 | 104.363636363636 | 440 | 0 | 100 | 0 | 1 | 440 | 167779 | 167340 | Human gammaherpesvirus 4 isolate Human herpesvirus 4 genome assembly, chromosome: I | blastn | 45920 | 813 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 22921605 | 22921605 | PRJNA896973_P_NODE_13058_length_309_cov_1.305085_g12964_i0 | PRJNA896973 | 13058 | 309 | 1.305085 | 4.03271265 | root | 1 | Root_unresolved | Root_unresolved | 571 | 1.7899999999999995e-158 | NTclustered | gi|2294362236|gb|ON596498.1| | 10376 | g12964 | i0 | 100 | 100 | 309 | 0 | 100 | 0 | 1 | 309 | 925 | 617 | Human gammaherpesvirus 4 isolate CHLBR07 latent membrane protein LMP-1 (LMP1) gene, partial cds | blastn | 30900 | 571 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 24195561 | 24195561 | PRJNA896973_P_NODE_25499_length_245_cov_0.895349_g25405_i0 | PRJNA896973 | 25499 | 245 | 0.895349 | 2.19360505 | Lymphocryptovirus | 10375 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|1519305892|dbj|AP019128.1| | 10376 | g25405 | i0 | 100 | 186.048979591837 | 245 | 0 | 100 | 0 | 1 | 245 | 41283 | 41039 | Human gammaherpesvirus 4 UPN326_PBMC DNA, nearly complete genome | blastn | 45582 | 453 | 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);;