contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA896973" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 7251153 | 7251153 | PRJNA896973_P_NODE_13926_length_301_cov_1.013158_g13832_i0 | PRJNA896973 | 13926 | 301 | 1.013158 | 3.04960558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 2.36e-122 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g13832 | i0 | 94.539 | 465.730897009967 | 293 | 14 | 97 | 2 | 1 | 292 | 18130 | 18421 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 140185 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8526007 | 8526007 | PRJNA896973_P_NODE_23767_length_248_cov_0.880000_g23673_i0 | PRJNA896973 | 23767 | 248 | 0.88 | 2.1824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 420 | 5.34e-113 | NTclustered | gi|2914806051|gb|OR221530.1| | 2832643 | g23673 | i0 | 97.177 | 1 | 248 | 7 | 100 | 0 | 1 | 248 | 5186 | 4939 | MAG: Caudoviricetes sp. isolate MSP1551 genomic sequence | blastn | 248 | 420 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 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 | ||
| 13997922 | 13997922 | PRJNA896973_P_NODE_21891_length_251_cov_0.865169_g21797_i0 | PRJNA896973 | 21891 | 251 | 0.865169 | 2.17157419 | Unaquatrovirus | 2169622 | Viruses | Viruses | 320 | 5.65e-83 | NTclustered | gi|937533119|ref|NC_027987.1| | 745088 | g21797 | i0 | 89.641 | 4.97211155378486 | 251 | 26 | 100 | 0 | 1 | 251 | 14947 | 14697 | Leuconostoc phage 1-A4, complete genome | blastn | 1248 | 320 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Unaquatrovirus | Unaquatrovirus uv1A4 | ||||
| 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);;