contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4353368 | 4353368 | PRJNA556992_P_NODE_252704_length_304_cov_1.000000_g250515_i0 | PRJNA556992 | 252704 | 304 | 1 | 3.04 | Simplexvirus humanalpha1 | 3050292 | Viruses | Viruses | 551 | 2.289999999999999e-152 | NTclustered | gi|2549842301|gb|OQ724955.1| | 10298 | g250515 | i0 | 99.342 | 100 | 304 | 2 | 100 | 0 | 1 | 304 | 110899 | 111202 | Human alphaherpesvirus 1 strain CJ462, partial genome | blastn | 30400 | 551 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha1 | ||
| 4952566 | 4952566 | PRJNA556992_P_NODE_1066604_length_220_cov_10.156463_g1064413_i0 | PRJNA556992 | 1066604 | 220 | 10.156463 | 22.3442186 | root | 1 | Root_unresolved | Root_unresolved | 396 | 7.809999999999997e-106 | NTclustered | gi|2583941926|gb|OP431890.1| | 10298 | g1064413 | i0 | 99.091 | 100.004545454545 | 220 | 2 | 100 | 0 | 1 | 220 | 98583 | 98802 | Human alphaherpesvirus 1 strain HSV1-v63_d84_oral, partial genome | blastn | 22001 | 396 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha1 | ||
| 11330255 | 11330255 | PRJNA556992_P_NODE_678949_length_252_cov_4.301676_g676760_i0 | PRJNA556992 | 678949 | 252 | 4.301676 | 10.84022352 | root | 1 | Root_unresolved | Root_unresolved | 466 | 6.89e-127 | NTclustered | gi|2583942922|gb|OP431909.1| | 10298 | g676760 | i0 | 100 | 100 | 252 | 0 | 100 | 0 | 1 | 252 | 138411 | 138160 | Human alphaherpesvirus 1 strain HSV1-v62_d3_gen_les, partial genome | blastn | 25200 | 466 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha1 | ||
| 11330505 | 11330505 | PRJNA556992_P_NODE_747249_length_249_cov_0.875000_g745060_i0 | PRJNA556992 | 747249 | 249 | 0.875 | 2.17875 | root | 1 | Root_unresolved | Root_unresolved | 460 | 3.16e-125 | NTclustered | gi|1407524929|gb|MG999880.1| | 10298 | g745060 | i0 | 100 | 186.044176706827 | 249 | 0 | 100 | 0 | 1 | 249 | 118532 | 118780 | Human alphaherpesvirus 1 strain 2007-16426, partial genome | blastn | 46325 | 460 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha1 | ||
| 20254035 | 20254035 | PRJNA556992_P_NODE_803396_length_246_cov_0.890173_g801206_i0 | PRJNA556992 | 803396 | 246 | 0.890173 | 2.18982558 | root | 1 | Root_unresolved | Root_unresolved | 455 | 1.4500000000000002e-123 | NTclustered | gi|2228073964|gb|ON007148.1| | 10298 | g801206 | i0 | 100 | 100 | 246 | 0 | 100 | 0 | 1 | 246 | 103277 | 103032 | Human alphaherpesvirus 1 strain v43_d349_gen, partial genome | blastn | 24600 | 455 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha1 | ||
| 20254174 | 20254174 | PRJNA556992_P_NODE_839216_length_244_cov_0.900585_g837026_i0 | PRJNA556992 | 839216 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 451 | 1.86e-122 | NTclustered | gi|1407524929|gb|MG999880.1| | 10298 | g837026 | i0 | 100 | 100 | 244 | 0 | 100 | 0 | 1 | 244 | 61625 | 61382 | Human alphaherpesvirus 1 strain 2007-16426, partial genome | blastn | 24400 | 451 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha1 |
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);;