contig_metadata
7 rows where analysis = "blastn", 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 |
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);;