contig_metadata
14 rows where bioproject = "PRJNA630877", tax_kingdom = "Orthornavirae" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10807294 | 10807294 | PRJNA630877_S_NODE_110049_length_206_cov_1.515152_g90912_i0 | PRJNA630877 | 110049 | 206 | 1.515152 | 3.12121312 | Ripodos virus | 3130450 | Viruses | Viruses | 67.6 | 6.43e-7 | NTclustered | gi|2717319779|gb|PP172752.1| | 3130450 | g90912 | i0 | 93.478 | 1.0631067961165 | 46 | 2 | 22 | 1 | 1 | 45 | 2349 | 2304 | MAG: Ripodos virus isolate KCAP1_k141_482780 genomic sequence | blastn | 219 | 67.6 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Ripodos virus | |||
| 26891276 | 26891276 | PRJNA630877_S_NODE_148501_length_159_cov_1.949153_g129364_i0 | PRJNA630877 | 148501 | 159 | 1.949153 | 3.09915327 | Pistacia-associated flexivirus 1 | 2597175 | Viruses | Viruses | 50.4 | 2.23e-5 | NR | YP_010799909.1 | 2597175 | g129364 | i0 | 62.5 | 0.60377358490566 | 32 | 12 | 60.4 | 0 | 2 | 97 | 1659 | 1690 | YP_010799909.1 replicase [Pistacia-associated flexivirus 1] | diamond | 96 | 50.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Gammaflexiviridae | Gammaflexivirus | Gammaflexivirus unipistaciae | ||
| 27523186 | 27523186 | PRJNA630877_S_NODE_80803_length_291_cov_1.632000_g61666_i0 | PRJNA630877 | 80803 | 291 | 1.632 | 4.74912 | Pistacia-associated flexivirus 1 | 2597175 | Viruses | Viruses | 93.6 | 9.26e-20 | NR | YP_010799909.1 | 2597175 | g61666 | i0 | 44.8 | 0.989690721649485 | 96 | 53 | 99 | 0 | 2 | 289 | 1041 | 1136 | YP_010799909.1 replicase [Pistacia-associated flexivirus 1] | diamond | 288 | 93.6 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Gammaflexiviridae | Gammaflexivirus | Gammaflexivirus unipistaciae | ||
| 27586439 | 27586439 | PRJNA630877_S_NODE_149584_length_158_cov_2.256410_g130447_i0 | PRJNA630877 | 149584 | 158 | 2.25641 | 3.5651278 | Entoleuca gammaflexivirus 1 | 2086641 | Viruses | Viruses | 41.2 | 0.042 | NR | YP_010799287.1 | 2086641 | g130447 | i0 | 39.2 | 0.968354430379747 | 51 | 31 | 96.8 | 0 | 153 | 1 | 1863 | 1913 | YP_010799287.1 replicase [Entoleuca gammaflexivirus 1] | diamond | 153 | 41.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Gammaflexiviridae | Gammaflexivirus | Gammaflexivirus unientoleucae | ||
| 28786015 | 28786015 | PRJNA630877_S_NODE_101807_length_223_cov_1.445055_g82670_i0 | PRJNA630877 | 101807 | 223 | 1.445055 | 3.22247265 | Dothistroma septosporum gammaflexivirus 1 | 3104549 | Viruses | Viruses | 58.2 | 1.05e-7 | NR | WPV70693.1 | 3104549 | g82670 | i0 | 40 | 0.874439461883408 | 65 | 39 | 87.4 | 0 | 218 | 24 | 1209 | 1273 | WPV70693.1 MAG: replicase [Dothistroma septosporum gammaflexivirus 1] | diamond | 195 | 58.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Gammaflexiviridae | Gammaflexivirus | Dothistroma septosporum gammaflexivirus 1 | ||
| 28912212 | 28912212 | PRJNA630877_S_NODE_128488_length_179_cov_1.673913_g109351_i0 | PRJNA630877 | 128488 | 179 | 1.673913 | 2.99630427 | Dothistroma septosporum gammaflexivirus 1 | 3104549 | Viruses | Viruses | 64.3 | 3.88e-10 | NR | WPV70693.1 | 3104549 | g109351 | i0 | 51.7 | 0.972067039106145 | 58 | 28 | 97.2 | 0 | 174 | 1 | 1124 | 1181 | WPV70693.1 MAG: replicase [Dothistroma septosporum gammaflexivirus 1] | diamond | 174 | 64.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Gammaflexiviridae | Gammaflexivirus | Dothistroma septosporum gammaflexivirus 1 | ||
| 29259591 | 29259591 | PRJNA630877_S_NODE_85789_length_270_cov_1.537118_g66652_i0 | PRJNA630877 | 85789 | 270 | 1.537118 | 4.1502186 | Pistacia-associated flexivirus 1 | 2597175 | Viruses | Viruses | 48.5 | 5.06e-4 | NR | YP_010799909.1 | 2597175 | g66652 | i0 | 32.2 | 0.966666666666667 | 87 | 47 | 95.6 | 4 | 4 | 261 | 1334 | 1409 | YP_010799909.1 replicase [Pistacia-associated flexivirus 1] | diamond | 261 | 48.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Gammaflexiviridae | Gammaflexivirus | Gammaflexivirus unipistaciae | ||
| 29587803 | 29587803 | PRJNA630877_S_NODE_129190_length_178_cov_2.248175_g110053_i0 | PRJNA630877 | 129190 | 178 | 2.248175 | 4.0017515 | Gammaflexivirus | 2948717 | Viruses | Viruses | 57 | 1.48e-7 | NR | YP_010799909.1 | 2597175 | g110053 | i0 | 44.8 | 2.86516853932584 | 58 | 32 | 97.8 | 0 | 5 | 178 | 1466 | 1523 | YP_010799909.1 replicase [Pistacia-associated flexivirus 1] | diamond | 510 | 57.4 | 0.993031358885017 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Gammaflexiviridae | Gammaflexivirus | Gammaflexivirus unipistaciae | ||
| 29796408 | 29796408 | PRJNA630877_S_NODE_109151_length_208_cov_1.053892_g90014_i0 | PRJNA630877 | 109151 | 208 | 1.053892 | 2.19209536 | Entoleuca gammaflexivirus 1 | 2086641 | Viruses | Viruses | 50.1 | 5.97e-5 | NR | YP_010799288.1 | 2086641 | g90014 | i0 | 36.4 | 0.951923076923077 | 66 | 42 | 95.2 | 0 | 206 | 9 | 593 | 658 | YP_010799288.1 movement protein [Entoleuca gammaflexivirus 1] | diamond | 198 | 50.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Gammaflexiviridae | Gammaflexivirus | Gammaflexivirus unientoleucae | ||
| 30112363 | 30112363 | PRJNA630877_S_NODE_118632_length_192_cov_1.496689_g99495_i0 | PRJNA630877 | 118632 | 192 | 1.496689 | 2.87364288 | Entoleuca gammaflexivirus 1 | 2086641 | Viruses | Viruses | 78.6 | 4.57e-15 | NR | YP_010799288.1 | 2086641 | g99495 | i0 | 58.3 | 0.9375 | 60 | 25 | 93.8 | 0 | 183 | 4 | 94 | 153 | YP_010799288.1 movement protein [Entoleuca gammaflexivirus 1] | diamond | 180 | 78.6 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Gammaflexiviridae | Gammaflexivirus | Gammaflexivirus unientoleucae | ||
| 32167489 | 32167489 | PRJNA630877_S_NODE_45958_length_641_cov_1.796667_g27960_i0 | PRJNA630877 | 45958 | 641 | 1.796667 | 11.51663547 | Pistacia-associated flexivirus 1 | 2597175 | Viruses | Viruses | 128 | 4.98e-30 | NR | YP_010799909.1 | 2597175 | g27960 | i0 | 36.7 | 1.95163806552262 | 207 | 130 | 96.9 | 1 | 6 | 626 | 77 | 282 | YP_010799909.1 replicase [Pistacia-associated flexivirus 1] | diamond | 1251 | 128 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Gammaflexiviridae | Gammaflexivirus | Gammaflexivirus unipistaciae | ||
| 32528181 | 32528181 | PRJNA630877_S_NODE_93859_length_243_cov_2.371287_g74722_i0 | PRJNA630877 | 93859 | 243 | 2.371287 | 5.76222741 | Gammaflexivirus | 2948717 | Viruses | Viruses | 112 | 8.77e-27 | NR | YP_010799287.1 | 2086641 | g74722 | i0 | 68.8 | 2.85185185185185 | 77 | 24 | 95.1 | 0 | 13 | 243 | 1596 | 1672 | YP_010799287.1 replicase [Entoleuca gammaflexivirus 1] | diamond | 693 | 112 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Gammaflexiviridae | Gammaflexivirus | Gammaflexivirus unientoleucae | ||
| 32641286 | 32641286 | PRJNA630877_S_NODE_48280_length_599_cov_1.700717_g29917_i0 | PRJNA630877 | 48280 | 599 | 1.700717 | 10.18729483 | Entoleuca gammaflexivirus 1 | 2086641 | Viruses | Viruses | 207 | 1.42e-62 | NR | YP_010799289.1 | 2086641 | g29917 | i0 | 51 | 0.971619365609349 | 194 | 95 | 97.2 | 0 | 591 | 10 | 57 | 250 | YP_010799289.1 hypothetical protein QKP88_gp3 [Entoleuca gammaflexivirus 1] | diamond | 582 | 207 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Gammaflexiviridae | Gammaflexivirus | Gammaflexivirus unientoleucae | ||
| 32798776 | 32798776 | PRJNA630877_S_NODE_109420_length_207_cov_1.831325_g90283_i0 | PRJNA630877 | 109420 | 207 | 1.831325 | 3.79084275 | Pistacia-associated flexivirus 1 | 2597175 | Viruses | Viruses | 87.4 | 4.23e-18 | NR | YP_010799909.1 | 2597175 | g90283 | i0 | 63.6 | 0.956521739130435 | 66 | 24 | 95.7 | 0 | 9 | 206 | 18 | 83 | YP_010799909.1 replicase [Pistacia-associated flexivirus 1] | diamond | 198 | 87.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Gammaflexiviridae | Gammaflexivirus | Gammaflexivirus unipistaciae |
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);;