contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1120771" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1551091 | 1551091 | PRJNA1120771_S_NODE_11642_length_318_cov_30.869091_g11242_i0 | PRJNA1120771 | 11642 | 318 | 30.869091 | 98.16370938 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|2914955111|gb|OR221941.1| | 2832643 | g11242 | i0 | 100 | 0.0911949685534591 | 29 | 0 | 9 | 0 | 1 | 29 | 7261 | 7233 | MAG: Caudoviricetes sp. isolate MSP0186 genomic sequence | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3579144 | 3579144 | PRJNA1120771_S_NODE_11003_length_324_cov_14531.476868_g10603_i0 | PRJNA1120771 | 11003 | 324 | 14531.476868 | 47081.98505232 | root | 1 | Root_unresolved | Root_unresolved | 111 | 4.95e-20 | NTclustered | gi|1893169343|gb|MT364888.1| | 10310 | g10603 | i0 | 94.521 | 18.4969135802469 | 73 | 2 | 23 | 1 | 1 | 73 | 10 | 80 | Human alphaherpesvirus 2, partial genome | blastn | 5993 | 111 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha2 | ||
| 4103673 | 4103673 | PRJNA1120771_S_NODE_2384_length_576_cov_16.195122_g2032_i0 | PRJNA1120771 | 2384 | 576 | 16.195122 | 93.28390272 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.016 | NTclustered | gi|2914995718|gb|OR222239.1| | 2832643 | g2032 | i0 | 100 | 0.0503472222222222 | 29 | 0 | 5 | 0 | 548 | 576 | 49 | 21 | MAG: Caudoviricetes sp. isolate MSP0730 genomic sequence | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6654496 | 6654496 | PRJNA1120771_S_NODE_26626_length_232_cov_21552.486772_g26226_i0 | PRJNA1120771 | 26626 | 232 | 21552.486772 | 50001.76931104 | Simplexvirus humanalpha2 | 3050293 | Viruses | Viruses | 113 | 9.38e-21 | NTclustered | gi|1893169343|gb|MT364888.1| | 10310 | g26226 | i0 | 94.595 | 26.0258620689655 | 74 | 2 | 32 | 1 | 1 | 74 | 10 | 81 | Human alphaherpesvirus 2, partial genome | blastn | 6038 | 113 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha2 | ||
| 13030327 | 13030327 | PRJNA1120771_S_NODE_27791_length_229_cov_1.403226_g27391_i0 | PRJNA1120771 | 27791 | 229 | 1.403226 | 3.21338754 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 390 | 3.81e-104 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g27391 | i0 | 97.391 | 261.7903930131 | 230 | 4 | 100 | 2 | 1 | 229 | 18014 | 17786 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 59950 | 390 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15579601 | 15579601 | PRJNA1120771_S_NODE_6793_length_384_cov_6787.560117_g6393_i0 | PRJNA1120771 | 6793 | 384 | 6787.560117 | 26064.23084928 | Enterococcus phage SSMH01 | 3075855 | Viruses | Viruses | 126 | 2.13e-24 | NTclustered | gi|2583824285|gb|OR360270.1| | 3075855 | g6393 | i0 | 94.048 | 18.0442708333333 | 84 | 3 | 22 | 2 | 1 | 84 | 41680 | 41599 | Enterococcus phage SSMH01, complete genome | blastn | 6929 | 126 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Efquatrovirus | Enterococcus phage SSMH01 | ||||
| 18128270 | 18128270 | PRJNA1120771_S_NODE_15255_length_289_cov_2.121951_g14855_i0 | PRJNA1120771 | 15255 | 289 | 2.121951 | 6.13243839 | Kuravirus phiEco32 | 490103 | Viruses | Viruses | 523 | 4.7199999999999987e-144 | NTclustered | gi|167583555|ref|NC_010324.1| | 2679905 | g14855 | i0 | 99.308 | 1 | 289 | 2 | 100 | 0 | 1 | 289 | 31502 | 31790 | Escherichia phage phiEco32, complete genome | blastn | 289 | 523 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mktvariviridae | Kuravirus | Kuravirus phiEco32 | |||
| 20678149 | 20678149 | PRJNA1120771_S_NODE_34717_length_208_cov_964.812121_g34317_i0 | PRJNA1120771 | 34717 | 208 | 964.812121 | 2006.80921168 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 71.3 | 5.03e-8 | NTclustered | gi|2914927983|gb|OR221514.1| | 2832643 | g34317 | i0 | 100 | 21.0961538461538 | 38 | 0 | 18 | 0 | 161 | 198 | 43743 | 43780 | MAG: Caudoviricetes sp. isolate MSP1566 genomic sequence | blastn | 4388 | 71.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20678187 | 20678187 | PRJNA1120771_S_NODE_6897_length_382_cov_412.197640_g6497_i0 | PRJNA1120771 | 6897 | 382 | 412.19764 | 1574.5949848 | Simplexvirus humanalpha2 | 3050293 | Viruses | Viruses | 71.3 | 1.01e-7 | NTclustered | gi|1893169343|gb|MT364888.1| | 10310 | g6497 | i0 | 100 | 10.3821989528796 | 38 | 0 | 10 | 0 | 11 | 48 | 47 | 84 | Human alphaherpesvirus 2, partial genome | blastn | 3966 | 71.3 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha2 |
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);;