contig_metadata
11 rows where bioproject = "PRJNA498309" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1755118 | 1755118 | PRJNA498309_P_NODE_108842_length_175_cov_1.659420_g106693_i0 | PRJNA498309 | 108842 | 175 | 1.65942 | 2.903985 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 313 | 6.13e-81 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g106693 | i0 | 98.857 | 1 | 175 | 2 | 100 | 0 | 1 | 175 | 1070 | 1244 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 175 | 313 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 13234713 | 13234713 | PRJNA498309_P_NODE_50151_length_375_cov_10.130178_g48006_i0 | PRJNA498309 | 50151 | 375 | 10.130178 | 37.9881675 | Malassezia restricta associated totivirus 2 | 3048758 | Viruses | Viruses | 599 | 1.0199999999999998e-166 | NTclustered | gi|2512878154|emb|OX637980.1| | 3048758 | g48006 | i0 | 99.694 | 0.872 | 327 | 1 | 87 | 0 | 22 | 348 | 144 | 470 | Malassezia restricta associated totivirus 2 CP gene for capsid protein | blastn | 327 | 599 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 2 | ||
| 17058035 | 17058035 | PRJNA498309_P_NODE_36914_length_460_cov_2.680851_g34851_i0 | PRJNA498309 | 36914 | 460 | 2.680851 | 12.3319146 | Totiviridae sp. | 1955172 | Viruses | Viruses | 231 | 5.3399999999999985e-56 | NTclustered | gi|2396038768|gb|ON812661.1| | 1955172 | g34851 | i0 | 79.63 | 2.34565217391304 | 324 | 64 | 70 | 2 | 91 | 413 | 4524 | 4202 | MAG: Totiviridae sp. isolate TIGMIC_4, complete genome | blastn | 1079 | 231 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 19608364 | 19608364 | PRJNA498309_S_NODE_40596_length_209_cov_3.557471_g38428_i0 | PRJNA498309 | 40596 | 209 | 3.557471 | 7.43511439 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 340 | 3.49e-89 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g38428 | i0 | 99.465 | 1.26794258373206 | 187 | 1 | 89 | 0 | 1 | 187 | 387 | 201 | Malassezia restricta virus MrV40L, complete genome | blastn | 265 | 340 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 22158731 | 22158731 | PRJNA498309_S_NODE_25238_length_365_cov_2.821212_g23070_i0 | PRJNA498309 | 25238 | 365 | 2.821212 | 10.2974238 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 606 | 5.9e-169 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g23070 | i0 | 98.542 | 1.18630136986301 | 343 | 5 | 94 | 0 | 23 | 365 | 919 | 577 | Malassezia restricta virus MrV40L, complete genome | blastn | 433 | 606 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 23433574 | 23433574 | PRJNA498309_P_NODE_63779_length_311_cov_1.218978_g61631_i0 | PRJNA498309 | 63779 | 311 | 1.218978 | 3.79102158 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 520 | 6.629999999999998e-143 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g61631 | i0 | 96.785 | 1.66881028938907 | 311 | 10 | 100 | 0 | 1 | 311 | 459 | 769 | Malassezia restricta virus MrV40L, complete genome | blastn | 519 | 520 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 28103076 | 28103076 | PRJNA498309_S_NODE_18125_length_500_cov_51.705376_g16062_i0 | PRJNA498309 | 18125 | 500 | 51.705376 | 258.52688 | Ghabrivirales | 2732540 | Viruses | Viruses | 121 | 1.59e-28 | NR | WAK77569.1 | 1955172 | g16062 | i0 | 44.4 | 1.584 | 135 | 75 | 81 | 0 | 56 | 460 | 54 | 188 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 792 | 121 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 28877036 | 28877036 | PRJNA498309_P_NODE_6548_length_1243_cov_12.398839_g5346_i0 | PRJNA498309 | 6548 | 1243 | 12.398839 | 154.11756877 | Nanning Totiv tick virus 3 | 2972354 | Viruses | Viruses | 186 | 1.3099999999999998e-47 | NR | UYL95666.1 | 2972354 | g5346 | i0 | 35.1 | 0.818181818181818 | 339 | 214 | 81.1 | 5 | 1009 | 2 | 65 | 400 | UYL95666.1 MAG: RNA-dependent RNA polymerase [Nanning Totiv tick virus 3] | diamond | 1017 | 186 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Nanning Totiv tick virus 3 | |||
| 30898685 | 30898685 | PRJNA498309_S_NODE_5474_length_1238_cov_23.297589_g4077_i0 | PRJNA498309 | 5474 | 1238 | 23.297589 | 288.42415182 | Nanning Totiv tick virus 3 | 2972354 | Viruses | Viruses | 184 | 3.1399999999999997e-47 | NR | UYL95666.1 | 2972354 | g4077 | i0 | 35.1 | 0.81421647819063 | 336 | 212 | 80.7 | 5 | 236 | 1234 | 65 | 397 | UYL95666.1 MAG: RNA-dependent RNA polymerase [Nanning Totiv tick virus 3] | diamond | 1008 | 184 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Nanning Totiv tick virus 3 | |||
| 31293179 | 31293179 | PRJNA498309_P_NODE_56675_length_343_cov_1.885621_g54527_i0 | PRJNA498309 | 56675 | 343 | 1.885621 | 6.46768003 | Ghabrivirales | 2732540 | Viruses | Viruses | 112 | 6.210000000000001e-26 | NR | QJA42332.1 | 2727863 | g54527 | i0 | 56.7 | 2.78134110787172 | 104 | 45 | 91 | 0 | 319 | 8 | 879 | 982 | QJA42332.1 polyprotein [Malassezia restricta virus MrV40L] | diamond | 954 | 112 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 32826708 | 32826708 | PRJNA498309_P_NODE_56820_length_342_cov_2.918033_g54672_i0 | PRJNA498309 | 56820 | 342 | 2.918033 | 9.97967286 | Erysiphe necator associated totivirus 7 | 2737097 | Viruses | Viruses | 68.9 | 7.54e-11 | NR | QJW70337.1 | 2737097 | g54672 | i0 | 41.4 | 0.868421052631579 | 99 | 56 | 85.1 | 1 | 293 | 3 | 2 | 100 | QJW70337.1 RNA-dependent RNA polymerase [Erysiphe necator associated totivirus 7] | diamond | 297 | 68.9 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Erysiphe necator associated totivirus 7 |
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);;