contig_metadata
12 rows where bioproject = "PRJNA1240804", tax_phylum = "Duplornaviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6725710 | 6725710 | PRJNA1240804_P_NODE_26_length_2913_cov_130.686453_g15_i0 | PRJNA1240804 | 26 | 2913 | 130.686453 | 3806.89637589 | Alphachrysovirus perseae | 2955248 | Viruses | Viruses | 5265 | 0 | NTclustered | gi|1694999061|ref|NC_043507.1| | 1587509 | g15 | i0 | 99.93 | 0.980775832475112 | 2857 | 2 | 98 | 0 | 19 | 2875 | 2857 | 1 | Persea americana chrysovirus segment RNA3, complete sequence | blastn | 2857 | 5265 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus perseae | ||
| 8001852 | 8001852 | PRJNA1240804_P_NODE_55747_length_211_cov_0.876543_g55381_i0 | PRJNA1240804 | 55747 | 211 | 0.876543 | 1.84950573 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 379 | 7.489999999999999e-101 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g55381 | i0 | 99.052 | 1 | 211 | 2 | 100 | 0 | 1 | 211 | 4041 | 4251 | Malassezia restricta virus MrV40L, complete genome | blastn | 211 | 379 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 9277040 | 9277040 | PRJNA1240804_P_NODE_68_length_2172_cov_93.222327_g42_i0 | PRJNA1240804 | 68 | 2172 | 93.222327 | 2024.78894244 | Alphachrysovirus perseae | 2955248 | Viruses | Viruses | 3936 | 0 | NTclustered | gi|1694999067|ref|NC_043508.1| | 1587509 | g42 | i0 | 99.629 | 0.992173112338858 | 2155 | 8 | 99 | 0 | 4 | 2158 | 2155 | 1 | Persea americana chrysovirus segment RNA2, complete sequence | blastn | 2155 | 3936 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus perseae | ||
| 15651431 | 15651431 | PRJNA1240804_P_NODE_513_length_1240_cov_54.565071_g333_i0 | PRJNA1240804 | 513 | 1240 | 54.565071 | 676.6068804 | Alphachrysovirus perseae | 2955248 | Viruses | Viruses | 2161 | 0 | NTclustered | gi|1694999067|ref|NC_043508.1| | 1587509 | g333 | i0 | 99.496 | 0.993548387096774 | 1190 | 3 | 99 | 1 | 37 | 1226 | 3335 | 2149 | Persea americana chrysovirus segment RNA2, complete sequence | blastn | 1232 | 2161 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus perseae | ||
| 16924671 | 16924671 | PRJNA1240804_P_NODE_143394_length_163_cov_0.912281_g143028_i0 | PRJNA1240804 | 143394 | 163 | 0.912281 | 1.48701803 | Totivirus sp. | 2776824 | Viruses | Viruses | 209 | 7.62e-50 | NTclustered | gi|1918615616|gb|MT949667.1| | 2776824 | g143028 | i0 | 91.946 | 1.80368098159509 | 149 | 12 | 91 | 0 | 1 | 149 | 1920 | 1772 | Totivirus sp. isolate sequence_5835 genomic sequence | blastn | 294 | 209 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 20749220 | 20749220 | PRJNA1240804_P_NODE_17_length_3455_cov_70.189372_g8_i0 | PRJNA1240804 | 17 | 3455 | 70.189372 | 2425.0428026 | Alphachrysovirus perseae | 2955248 | Viruses | Viruses | 6307 | 0 | NTclustered | gi|1694999054|ref|NC_043506.1| | 1587509 | g8 | i0 | 99.942 | 0.990159189580318 | 3421 | 2 | 99 | 0 | 15 | 3435 | 1 | 3421 | Persea americana chrysovirus segment RNA1, complete sequence | blastn | 3421 | 6307 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus perseae | ||
| 22025756 | 22025756 | PRJNA1240804_P_NODE_78018_length_188_cov_1.179856_g77652_i0 | PRJNA1240804 | 78018 | 188 | 1.179856 | 2.21812928 | Erysiphe necator associated totivirus 3 | 2737093 | Viruses | Viruses | 316 | 5.17e-82 | NTclustered | gi|1843473442|gb|MN617024.1| | 2737093 | g77652 | i0 | 99.425 | 1.85106382978723 | 174 | 1 | 93 | 0 | 15 | 188 | 1168 | 995 | Erysiphe necator associated totivirus 3 isolate PMS12_DN29560, complete genome | blastn | 348 | 316 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Erysiphe necator associated totivirus 3 | ||
| 26978616 | 26978616 | PRJNA1240804_P_NODE_99302_length_174_cov_1.136000_g98936_i0 | PRJNA1240804 | 99302 | 174 | 1.136 | 1.97664 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 127 | 3.0299999999999996e-32 | NR | CAI9858973.1 | 3048756 | g98936 | i0 | 98.2 | 0.982758620689655 | 57 | 1 | 98.3 | 0 | 3 | 173 | 343 | 399 | CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1] | diamond | 171 | 127 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 28368218 | 28368218 | PRJNA1240804_P_NODE_121486_length_167_cov_0.881356_g121120_i0 | PRJNA1240804 | 121486 | 167 | 0.881356 | 1.47186452 | Malassezia restricta virus MrV4 | 76775 | Viruses | Viruses | 77.4 | 7.93e-15 | NR | QJA42330.1 | 2727863 | g121120 | i0 | 76.6 | 1.68862275449102 | 47 | 11 | 84.4 | 0 | 9 | 149 | 1 | 47 | QJA42330.1 capsid protein [Malassezia restricta virus MrV40L] | diamond | 282 | 77.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 29031642 | 29031642 | PRJNA1240804_P_NODE_144128_length_163_cov_0.912281_g143762_i0 | PRJNA1240804 | 144128 | 163 | 0.912281 | 1.48701803 | Totivirus sp. | 2776824 | Viruses | Viruses | 67 | 1.23e-11 | NR | QOQ37359.1 | 2776824 | g143762 | i0 | 75 | 2.42944785276074 | 44 | 11 | 81 | 0 | 32 | 163 | 21 | 64 | QOQ37359.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] | diamond | 396 | 67 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 31400881 | 31400881 | PRJNA1240804_P_NODE_141096_length_163_cov_1.403509_g140730_i0 | PRJNA1240804 | 141096 | 163 | 1.403509 | 2.28771967 | Erysiphe necator associated totivirus 4 | 2737094 | Viruses | Viruses | 57.8 | 6.3e-8 | NR | QJW70332.1 | 2737094 | g140730 | i0 | 100 | 0.552147239263804 | 30 | 0 | 55.2 | 0 | 114 | 25 | 89 | 118 | QJW70332.1 coat protein [Erysiphe necator associated totivirus 4] | diamond | 90 | 57.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Erysiphe necator associated totivirus 4 | ||
| 32064987 | 32064987 | PRJNA1240804_P_NODE_91438_length_179_cov_1.176923_g91072_i0 | PRJNA1240804 | 91438 | 179 | 1.176923 | 2.10669217 | Aspergillus terreus chrysovirus 1 | 3064026 | Viruses | Viruses | 68.2 | 1.7e-11 | NR | WKU83718.1 | 3064026 | g91072 | i0 | 94.3 | 0.58659217877095 | 35 | 2 | 58.7 | 0 | 109 | 5 | 427 | 461 | WKU83718.1 RNA-dependent RNA polymerase [Aspergillus terreus chrysovirus 1] | diamond | 105 | 68.2 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Aspergillus terreus chrysovirus 1 |
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);;