contig_metadata
7 rows where bioproject = "PRJNA1148190" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2841603 | 2841603 | PRJNA1148190_P_NODE_123063_length_475_cov_4.967662_g111900_i0 | PRJNA1148190 | 123063 | 475 | 4.967662 | 23.5963945 | Cytomegalovirus cercopithecinebeta5 | 3050258 | Viruses | Viruses | 878 | 0 | NTclustered | gi|6561411|gb|AF191072.1|AF191072 | 36452 | g111900 | i0 | 100 | 5 | 475 | 0 | 100 | 0 | 1 | 475 | 1512 | 1986 | Stealth virus 1 clone 3B41, genomic sequence | blastn | 2375 | 878 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus cercopithecinebeta5 | ||
| 2851765 | 2851765 | PRJNA1148190_P_NODE_99823_length_535_cov_1.872294_g88668_i0 | PRJNA1148190 | 99823 | 535 | 1.872294 | 10.0167729 | Simplexvirus humanalpha1 | 3050292 | Viruses | Viruses | 63.9 | 2.43e-5 | NTclustered | gi|1394356506|gb|MH160367.1| | 10298 | g88668 | i0 | 95.122 | 0.766355140186916 | 41 | 1 | 7 | 1 | 145 | 184 | 75188 | 75148 | Human alphaherpesvirus 1 strain HSV1-ORIGINAL-H1, partial genome | blastn | 410 | 63.9 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha1 | ||
| 7412286 | 7412286 | PRJNA1148190_P_NODE_23306_length_1606_cov_4.445532_g14645_i0 | PRJNA1148190 | 23306 | 1606 | 4.445532 | 71.39524392 | root | 1 | Root_unresolved | Root_unresolved | 1018 | 0 | NTclustered | gi|6180217|gb|AF065660.2|AF065660 | 36452 | g14645 | i0 | 87.486 | 15.8125778331258 | 887 | 106 | 96 | 5 | 1 | 884 | 586 | 1470 | Stealth virus 1 clone C1616 T3 | blastn | 25395 | 1024 | 0.994140625 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus cercopithecinebeta5 | ||
| 11238522 | 11238522 | PRJNA1148190_P_NODE_434589_length_279_cov_1.791262_g423416_i0 | PRJNA1148190 | 434589 | 279 | 1.791262 | 4.99762098 | Roseolovirus | 40272 | Viruses | Viruses | 52.8 | 0.026 | NTclustered | gi|1147809524|ref|NC_033620.1| | 1940555 | g423416 | i0 | 100 | 0.200716845878136 | 28 | 0 | 10 | 0 | 30 | 57 | 133677 | 133704 | Murine roseolovirus isolate YOK1, complete genome | blastn | 56 | 52.8 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Roseolovirus | Murine roseolovirus | ||
| 15064146 | 15064146 | PRJNA1148190_P_NODE_84352_length_591_cov_4.372587_g73220_i0 | PRJNA1148190 | 84352 | 591 | 4.372587 | 25.84198917 | root | 1 | Root_unresolved | Root_unresolved | 793 | 0 | NTclustered | gi|6180217|gb|AF065660.2|AF065660 | 36452 | g73220 | i0 | 90.863 | 2 | 591 | 54 | 100 | 0 | 1 | 591 | 2837 | 3427 | Stealth virus 1 clone C1616 T3 | blastn | 1182 | 793 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus cercopithecinebeta5 | ||
| 15599897 | 15599897 | PRJNA1148190_P_NODE_533173_length_260_cov_1.550802_g522000_i0 | PRJNA1148190 | 533173 | 260 | 1.550802 | 4.0320852 | Cytomegalovirus humanbeta5 | 3050295 | Viruses | Viruses | 52.8 | 0.024 | NTclustered | gi|2213887936|gb|OK000911.1| | 10359 | g522000 | i0 | 100 | 0.107692307692308 | 28 | 0 | 11 | 0 | 73 | 100 | 193267 | 193294 | Human betaherpesvirus 5 strain DABE, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus humanbeta5 | ||
| 30071664 | 30071664 | PRJNA1148190_P_NODE_780072_length_241_cov_0.916667_g768899_i0 | PRJNA1148190 | 780072 | 241 | 0.916667 | 2.20916747 | Suid alphaherpesvirus 1 | 10345 | Viruses | Viruses | 42.4 | 0.0492 | NR | AMR55904.1 | 10345 | g768899 | i0 | 56.1 | 0.510373443983402 | 41 | 11 | 48.5 | 3 | 123 | 239 | 814 | 849 | AMR55904.1 helicase-primase primase subunit [Suid alphaherpesvirus 1] | diamond | 123 | 42.4 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Varicellovirus | Varicellovirus suidalpha1 |
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);;