contig_metadata
13 rows where bioproject = "PRJNA900028" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3426686 | 3426686 | PRJNA900028_P_NODE_7523_length_395_cov_1.739884_g6777_i0 | PRJNA900028 | 7523 | 395 | 1.739884 | 6.8725418 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 520 | 8.62e-143 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g6777 | i0 | 94.627 | 0.848101265822785 | 335 | 18 | 85 | 0 | 1 | 335 | 769 | 1103 | Malassezia restricta virus MrV40S, complete genome | blastn | 335 | 520 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 3796622 | 3796622 | PRJNA900028_P_NODE_123943_length_167_cov_0.864407_g123194_i0 | PRJNA900028 | 123943 | 167 | 0.864407 | 1.44355969 | Elliovirales | 3151837 | Viruses | Viruses | 52.8 | 0.014 | NTclustered | gi|765536167|ref|NC_026617.1| | 1266451 | g123194 | i0 | 96.875 | 0.383233532934132 | 32 | 0 | 19 | 1 | 108 | 139 | 130 | 160 | Mulberry vein banding virus isolate XCSY-3 segment L, complete sequence | blastn | 64 | 52.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Peribunyaviridae | Mulberry vein banding virus | |||
| 9803666 | 9803666 | PRJNA900028_P_NODE_59428_length_198_cov_0.926174_g58679_i0 | PRJNA900028 | 59428 | 198 | 0.926174 | 1.83382452 | Orthoreovirus piscis | 3431498 | Viruses | Viruses | 141 | 3.5600000000000003e-29 | NTclustered | gi|2634039171|gb|OR872661.1| | 1157337 | g58679 | i0 | 96.471 | 891.30303030303 | 85 | 3 | 43 | 0 | 85 | 169 | 2434 | 2518 | Piscine orthoreovirus isolate WADDL:2021-1143 muNS protein gene, complete cds | blastn | 176478 | 141 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Orthoreovirus | Orthoreovirus piscis | ||
| 18726502 | 18726502 | PRJNA900028_P_NODE_182455_length_162_cov_0.902655_g181706_i0 | PRJNA900028 | 182455 | 162 | 0.902655 | 1.4623011 | Tolivirales sp. | 2809914 | Viruses | Viruses | 83.2 | 2.1e-17 | NR | WRQ65174.1 | 2809914 | g181706 | i0 | 64 | 0.925925925925926 | 50 | 18 | 92.6 | 0 | 1 | 150 | 107 | 156 | WRQ65174.1 RNA-dependent RNA polymerase, partial [Tolivirales sp.] | diamond | 150 | 83.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 23828008 | 23828008 | PRJNA900028_P_NODE_63519_length_193_cov_2.576389_g62770_i0 | PRJNA900028 | 63519 | 193 | 2.576389 | 4.97243077 | Sopatuq virus | 3131685 | Viruses | Viruses | 213 | 7.21e-51 | NTclustered | gi|2717323148|gb|PP173986.1| | 3131685 | g62770 | i0 | 92.105 | 33.8497409326425 | 152 | 11 | 79 | 1 | 17 | 168 | 3239 | 3389 | MAG: Sopatuq virus isolate SP1B_k141_215904 genomic sequence | blastn | 6533 | 213 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Sopatuq virus | |||
| 28097987 | 28097987 | PRJNA900028_P_NODE_165465_length_163_cov_1.342105_g164716_i0 | PRJNA900028 | 165465 | 163 | 1.342105 | 2.18763115 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 73.9 | 1.26e-13 | NR | CAI9858973.1 | 3048756 | g164716 | i0 | 60.4 | 0.975460122699387 | 53 | 21 | 97.5 | 0 | 162 | 4 | 58 | 110 | CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1] | diamond | 159 | 73.9 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 28129758 | 28129758 | PRJNA900028_P_NODE_198905_length_156_cov_2.046729_g198156_i0 | PRJNA900028 | 198905 | 156 | 2.046729 | 3.19289724 | Malassezia restricta virus MrV4 | 76775 | Viruses | Viruses | 77.4 | 6.97e-15 | NR | QJA42332.1 | 2727863 | g198156 | i0 | 77.1 | 1.84615384615385 | 48 | 11 | 92.3 | 0 | 4 | 147 | 827 | 874 | QJA42332.1 polyprotein [Malassezia restricta virus MrV40L] | diamond | 288 | 77.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 28287300 | 28287300 | PRJNA900028_P_NODE_110506_length_171_cov_1.254098_g109757_i0 | PRJNA900028 | 110506 | 171 | 1.254098 | 2.14450758 | Totiviridae sp. | 1955172 | Viruses | Viruses | 56.6 | 1.76e-7 | NR | WAK77569.1 | 1955172 | g109757 | i0 | 42.9 | 0.982456140350877 | 56 | 32 | 98.2 | 0 | 3 | 170 | 161 | 216 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 168 | 56.6 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 29771353 | 29771353 | PRJNA900028_P_NODE_53611_length_204_cov_0.987097_g52862_i0 | PRJNA900028 | 53611 | 204 | 0.987097 | 2.01367788 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 81.3 | 5.85e-16 | NR | CAI9858976.1 | 3048757 | g52862 | i0 | 58.7 | 0.926470588235294 | 63 | 26 | 92.6 | 0 | 11 | 199 | 566 | 628 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 189 | 81.3 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 30561066 | 30561066 | PRJNA900028_P_NODE_39333_length_222_cov_1.167630_g38584_i0 | PRJNA900028 | 39333 | 222 | 1.16763 | 2.5921386 | Totiviridae sp. | 1955172 | Viruses | Viruses | 98.6 | 6.1300000000000005e-22 | NR | WAK77569.1 | 1955172 | g38584 | i0 | 63 | 0.986486486486487 | 73 | 27 | 98.6 | 0 | 220 | 2 | 82 | 154 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 219 | 98.6 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 30750971 | 30750971 | PRJNA900028_P_NODE_54254_length_203_cov_1.266234_g53505_i0 | PRJNA900028 | 54254 | 203 | 1.266234 | 2.57045502 | Ripabiq virus | 3130194 | Viruses | Viruses | 74.3 | 1.61e-13 | NR | WZH59261.1 | 3130194 | g53505 | i0 | 73.6 | 1.53694581280788 | 53 | 14 | 78.3 | 0 | 164 | 6 | 674 | 726 | WZH59261.1 MAG: RNA-dependent RNA polymerase [Ripabiq virus] | diamond | 312 | 74.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripabiq virus | |||||
| 32047315 | 32047315 | PRJNA900028_P_NODE_143478_length_165_cov_0.879310_g142729_i0 | PRJNA900028 | 143478 | 165 | 0.87931 | 1.4508615 | Malassezia restricta virus MrV4 | 76775 | Viruses | Viruses | 99 | 2.01e-22 | NR | QJA42332.1 | 2727863 | g142729 | i0 | 90.7 | 1.96363636363636 | 54 | 5 | 98.2 | 0 | 163 | 2 | 896 | 949 | QJA42332.1 polyprotein [Malassezia restricta virus MrV40L] | diamond | 324 | 99 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 32899791 | 32899791 | PRJNA900028_P_NODE_12400_length_323_cov_0.992701_g11652_i0 | PRJNA900028 | 12400 | 323 | 0.99270099999999994 | 3.20642423 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 172 | 1.9699999999999998e-47 | NR | CAI9858973.1 | 3048756 | g11652 | i0 | 75.7 | 0.993808049535604 | 107 | 26 | 99.4 | 0 | 1 | 321 | 414 | 520 | CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1] | diamond | 321 | 172 | 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);;