contig_metadata
14 rows where bioproject = "PRJNA674308" and tax_phylum = "Duplornaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1920796 | 1920796 | PRJNA674308_P_NODE_24882_length_200_cov_1.721854_g24647_i0 | PRJNA674308 | 24882 | 200 | 1.721854 | 3.443708 | Malassezia restricta associated totivirus 2 | 3048758 | Viruses | Viruses | 320 | 4.31e-83 | NTclustered | gi|2512878154|emb|OX637980.1| | 3048758 | g24647 | i0 | 95.5 | 3.91 | 200 | 9 | 100 | 0 | 1 | 200 | 272 | 471 | Malassezia restricta associated totivirus 2 CP gene for capsid protein | blastn | 782 | 320 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 2 | ||
| 1921043 | 1921043 | PRJNA674308_P_NODE_54882_length_152_cov_2.009709_g54647_i0 | PRJNA674308 | 54882 | 152 | 2.009709 | 3.05475768 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 270 | 3.15e-68 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g54647 | i0 | 98.684 | 2 | 152 | 2 | 100 | 0 | 1 | 152 | 3026 | 3177 | Malassezia restricta virus MrV40L, complete genome | blastn | 304 | 270 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 7023272 | 7023272 | PRJNA674308_P_NODE_15746_length_244_cov_1.594872_g15511_i0 | PRJNA674308 | 15746 | 244 | 1.594872 | 3.89148768 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 346 | 9.019999999999999e-91 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g15511 | i0 | 92.245 | 1.00409836065574 | 245 | 18 | 100 | 1 | 1 | 244 | 689 | 933 | Malassezia restricta virus MrV40S, complete genome | blastn | 245 | 346 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 8298067 | 8298067 | PRJNA674308_P_NODE_30407_length_183_cov_1.552239_g30172_i0 | PRJNA674308 | 30407 | 183 | 1.552239 | 2.84059737 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 307 | 3.0100000000000005e-79 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g30172 | i0 | 97.253 | 0.994535519125683 | 182 | 3 | 99 | 2 | 1 | 181 | 1782 | 1962 | Malassezia restricta virus MrV40L, complete genome | blastn | 182 | 307 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 9573474 | 9573474 | PRJNA674308_P_NODE_54308_length_159_cov_2.836364_g54073_i0 | PRJNA674308 | 54308 | 159 | 2.836364 | 4.50981876 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 187 | 3.459999999999999e-43 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g54073 | i0 | 88.387 | 0.974842767295597 | 155 | 18 | 97 | 0 | 3 | 157 | 1 | 155 | Malassezia restricta virus MrV40S, complete genome | blastn | 155 | 187 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 12123881 | 12123881 | PRJNA674308_P_NODE_12950_length_267_cov_0.885321_g12715_i0 | PRJNA674308 | 12950 | 267 | 0.885321 | 2.36380707 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 422 | 1.62e-113 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g12715 | i0 | 95.131 | 1.50187265917603 | 267 | 13 | 100 | 0 | 1 | 267 | 443 | 177 | Malassezia restricta virus MrV40L, complete genome | blastn | 401 | 422 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 19771433 | 19771433 | PRJNA674308_P_NODE_10356_length_296_cov_2.842105_g10121_i0 | PRJNA674308 | 10356 | 296 | 2.842105 | 8.4126308 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 309 | 1.48e-79 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g10121 | i0 | 96.277 | 0.635135135135135 | 188 | 7 | 64 | 0 | 1 | 188 | 916 | 1103 | Malassezia restricta virus MrV40S, complete genome | blastn | 188 | 309 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 23597464 | 23597464 | PRJNA674308_P_NODE_18759_length_226_cov_1.175141_g18524_i0 | PRJNA674308 | 18759 | 226 | 1.175141 | 2.65581866 | Chemarfal virus 258 | 3063149 | Viruses | Viruses | 412 | 8.01e-111 | NTclustered | gi|2626079799|gb|OR270470.1| | 3063149 | g18524 | i0 | 99.558 | 4.01327433628319 | 226 | 1 | 100 | 0 | 1 | 226 | 1320 | 1545 | MAG: Chemarfal virus 258 isolate ML188 genomic sequence | blastn | 907 | 412 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 258 | ||||
| 27871418 | 27871418 | PRJNA674308_P_NODE_52905_length_162_cov_0.920354_g52670_i0 | PRJNA674308 | 52905 | 162 | 0.920354 | 1.49097348 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 113 | 1.86e-27 | NR | CAI9858974.1 | 3048756 | g52670 | i0 | 94.3 | 0.981481481481482 | 53 | 3 | 98.1 | 0 | 2 | 160 | 143 | 195 | CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] | diamond | 159 | 113 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 29481432 | 29481432 | PRJNA674308_P_NODE_44410_length_166_cov_0.888889_g44175_i0 | PRJNA674308 | 44410 | 166 | 0.888889 | 1.47555574 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 100 | 8.189999999999999e-23 | NR | CAI9858974.1 | 3048756 | g44175 | i0 | 75.9 | 0.975903614457831 | 54 | 13 | 97.6 | 0 | 5 | 166 | 395 | 448 | CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] | diamond | 162 | 100 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 30441390 | 30441390 | PRJNA674308_P_NODE_36593_length_169_cov_0.866667_g36358_i0 | PRJNA674308 | 36593 | 169 | 0.866667 | 1.46466723 | Totivirus | 11007 | Viruses | Viruses | 66.2 | 7.09e-11 | NR | QJW70335.1 | 2737096 | g36358 | i0 | 51.9 | 1.84615384615385 | 52 | 25 | 92.3 | 0 | 166 | 11 | 723 | 774 | QJW70335.1 RNA-dependent RNA polymerase [Erysiphe necator associated totivirus 6] | diamond | 312 | 66.2 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Erysiphe necator associated totivirus 6 | ||
| 30492596 | 30492596 | PRJNA674308_P_NODE_28693_length_188_cov_1.496403_g28458_i0 | PRJNA674308 | 28693 | 188 | 1.496403 | 2.81323764 | Malassezia restricta virus MrV4 | 76775 | Viruses | Viruses | 102 | 2.3599999999999998e-23 | NR | QJA42332.1 | 2727863 | g28458 | i0 | 79 | 1.97872340425532 | 62 | 13 | 98.9 | 0 | 186 | 1 | 807 | 868 | QJA42332.1 polyprotein [Malassezia restricta virus MrV40L] | diamond | 372 | 102 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 31124103 | 31124103 | PRJNA674308_P_NODE_45915_length_165_cov_0.896552_g45680_i0 | PRJNA674308 | 45915 | 165 | 0.896552 | 1.4793108 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 94.4 | 8.4e-21 | NR | CAI9858976.1 | 3048757 | g45680 | i0 | 83.3 | 0.981818181818182 | 54 | 9 | 98.2 | 0 | 3 | 164 | 486 | 539 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 162 | 94.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 31598989 | 31598989 | PRJNA674308_P_NODE_44356_length_166_cov_0.888889_g44121_i0 | PRJNA674308 | 44356 | 166 | 0.888889 | 1.47555574 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 91.7 | 7.44e-20 | NR | CAI9858973.1 | 3048756 | g44121 | i0 | 74.1 | 0.975903614457831 | 54 | 14 | 97.6 | 0 | 3 | 164 | 223 | 276 | CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1] | diamond | 162 | 91.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 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);;