contig_metadata
6 rows where bioproject = "PRJNA816047" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25602109 | 25602109 | PRJNA816047d_S_NODE_153737_length_213_cov_11858.462500_g151902_i0 | PRJNA816047 | 153737 | 213 | 11858.4625 | 25258.525125 | Gallid alphaherpesvirus 1 | 10386 | Viruses | Viruses | 75 | 4e-9 | NTclustered | gi|2451391033|gb|OQ354889.1| | 10386 | g151902 | i0 | 100 | 199.389671361502 | 40 | 0 | 19 | 0 | 22 | 61 | 139632 | 139593 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CUD_1/6th_UL12, complete genome | blastn | 42470 | 75 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 25737937 | 25737937 | PRJNA816047d_S_NODE_135266_length_226_cov_364.763006_g133431_i0 | PRJNA816047 | 135266 | 226 | 364.763006 | 824.36439356 | Gallid alphaherpesvirus 1 | 10386 | Viruses | Viruses | 73.1 | 1.54e-8 | NTclustered | gi|2451390879|gb|OQ354887.1| | 10386 | g133431 | i0 | 95.556 | 193.575221238938 | 45 | 2 | 20 | 0 | 171 | 215 | 372 | 328 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CPBDh_UL12, complete genome | blastn | 43748 | 73.1 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 25874726 | 25874726 | PRJNA816047d_S_NODE_199907_length_199_cov_8784.424658_g198072_i0 | PRJNA816047 | 199907 | 199 | 8784.424658 | 17481.00506942 | Gallid alphaherpesvirus 1 | 10386 | Viruses | Viruses | 80.5 | 7.92e-11 | NTclustered | gi|2451391033|gb|OQ354889.1| | 10386 | g198072 | i0 | 97.826 | 216.562814070352 | 46 | 1 | 23 | 0 | 138 | 183 | 139591 | 139636 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CUD_1/6th_UL12, complete genome | blastn | 43096 | 80.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 26009727 | 26009727 | PRJNA816047d_S_NODE_126284_length_234_cov_68521.734807_g124449_i0 | PRJNA816047 | 126284 | 234 | 68521.734807 | 160340.85944838 | Gallid alphaherpesvirus 1 | 10386 | Viruses | Viruses | 76.8 | 1.24e-9 | NTclustered | gi|2451390879|gb|OQ354887.1| | 10386 | g124449 | i0 | 97.727 | 179.717948717949 | 44 | 1 | 19 | 0 | 170 | 213 | 139663 | 139706 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CPBDh_UL12, complete genome | blastn | 42054 | 76.8 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 26009866 | 26009866 | PRJNA816047d_S_NODE_130084_length_230_cov_107884.531073_g128249_i0 | PRJNA816047 | 130084 | 230 | 107884.531073 | 248134.4214679 | Gallid alphaherpesvirus 1 | 10386 | Viruses | Viruses | 73.1 | 1.58e-8 | NTclustered | gi|2451390879|gb|OQ354887.1| | 10386 | g128249 | i0 | 97.619 | 183.560869565217 | 42 | 1 | 18 | 0 | 18 | 59 | 334 | 375 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CPBDh_UL12, complete genome | blastn | 42219 | 73.1 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 26146780 | 26146780 | PRJNA816047d_S_NODE_170005_length_207_cov_7480.461039_g168170_i0 | PRJNA816047 | 170005 | 207 | 7480.461039 | 15484.55435073 | Gallid alphaherpesvirus 1 | 10386 | Viruses | Viruses | 73.1 | 1.39e-8 | NTclustered | gi|2451390879|gb|OQ354887.1| | 10386 | g168170 | i0 | 100 | 192.096618357488 | 39 | 0 | 19 | 0 | 21 | 59 | 139707 | 139669 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CPBDh_UL12, complete genome | blastn | 39764 | 73.1 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 |
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);;