contig_metadata
13 rows where bioproject = "PRJNA550047", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2395850 | 2395850 | PRJNA550047_P_NODE_20842_length_481_cov_8.460784_g18945_i0 | PRJNA550047 | 20842 | 481 | 8.460784 | 40.69637104 | Tobamovirus | 12234 | Viruses | Viruses | 887 | 0 | NTclustered | gi|937502902|gb|KR108206.1| | 12239 | g18945 | i0 | 100 | 98.3284823284823 | 480 | 0 | 99 | 0 | 1 | 480 | 4400 | 4879 | Pepper mild mottle virus isolate RP, complete genome | blastn | 47296 | 887 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 5621423 | 5621423 | PRJNA550047_P_NODE_531765_length_219_cov_22.253425_g529792_i0 | PRJNA550047 | 531765 | 219 | 22.253425 | 48.73500075 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 399 | 6.009999999999999e-107 | NTclustered | gi|2432631556|gb|OQ198319.1| | 12239 | g529792 | i0 | 99.543 | 93.2328767123288 | 219 | 1 | 100 | 0 | 1 | 219 | 4923 | 5141 | MAG: Pepper mild mottle virus isolate CTS36_2_PPMoV coat protein genes, complete cds | blastn | 20418 | 399 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 11323868 | 11323868 | PRJNA550047_P_NODE_286629_length_298_cov_11.133333_g284660_i0 | PRJNA550047 | 286629 | 298 | 11.133333 | 33.17733234 | Tobamovirus | 12234 | Viruses | Viruses | 278 | 4.2e-70 | NTclustered | gi|20177424|ref|NC_003630.1| | 12239 | g284660 | i0 | 99.346 | 96.6979865771812 | 153 | 1 | 100 | 0 | 146 | 298 | 4091 | 3939 | Pepper mild mottle virus, complete genome | blastn | 28816 | 278 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 13267889 | 13267889 | PRJNA550047_P_NODE_244091_length_300_cov_12.850220_g242122_i0 | PRJNA550047 | 244091 | 300 | 12.85022 | 38.55066 | Tobamovirus viridimaculae | 3432895 | Viruses | Viruses | 534 | 2.2699999999999998e-147 | NTclustered | gi|2184811942|gb|MW430120.1| | 12235 | g242122 | i0 | 99 | 100 | 300 | 0 | 100 | 1 | 1 | 300 | 4591 | 4887 | Cucumber green mottle mosaic virus isolate WA-3, complete genome | blastn | 30000 | 534 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus viridimaculae | ||
| 13875892 | 13875892 | PRJNA550047_P_NODE_525871_length_221_cov_22.459459_g523898_i0 | PRJNA550047 | 525871 | 221 | 22.459459 | 49.63540439 | Tobamovirus | 12234 | Viruses | Viruses | 399 | 6.069999999999998e-107 | NTclustered | gi|1052138734|gb|KU646837.1| | 12239 | g523898 | i0 | 99.543 | 98.710407239819 | 219 | 1 | 99 | 0 | 3 | 221 | 331 | 549 | Pepper mild mottle virus isolate Fengcheng, complete genome | blastn | 21815 | 399 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 17697891 | 17697891 | PRJNA550047_P_NODE_11494_length_571_cov_10.451807_g9683_i0 | PRJNA550047 | 11494 | 571 | 10.451807 | 59.67981797 | Tobamovirus | 12234 | Viruses | Viruses | 1024 | 0 | NTclustered | gi|1145800961|gb|KX399389.1| | 12239 | g9683 | i0 | 99.121 | 93.6077057793345 | 569 | 5 | 99 | 0 | 2 | 570 | 1632 | 1064 | Pepper mild mottle virus isolate J47, complete genome | blastn | 53450 | 1024 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 18971492 | 18971492 | PRJNA550047_P_NODE_128915_length_345_cov_6.125000_g126955_i0 | PRJNA550047 | 128915 | 345 | 6.125 | 21.13125 | Tobamovirus | 12234 | Viruses | Viruses | 318 | 2.92e-82 | NTclustered | gi|1950992325|gb|MW373851.1| | 12239 | g126955 | i0 | 100 | 88.6 | 172 | 0 | 94 | 0 | 174 | 345 | 1632 | 1461 | Pepper mild mottle virus isolate GMD-TA, complete genome. | blastn | 30567 | 318 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 19639898 | 19639898 | PRJNA550047_P_NODE_206936_length_323_cov_5.024000_g204968_i0 | PRJNA550047 | 206936 | 323 | 5.024 | 16.22752 | Tolivirales sp. | 2809914 | Viruses | Viruses | 597 | 3.11e-166 | NTclustered | gi|2647550456|gb|OR843944.1| | 2809914 | g204968 | i0 | 100 | 1 | 323 | 0 | 100 | 0 | 1 | 323 | 1010 | 688 | Tolivirales sp. strain MR233-17E/34903 RNA-dependent RNA polymerase gene, partial cds | blastn | 323 | 597 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 20918257 | 20918257 | PRJNA550047_P_NODE_413637_length_260_cov_2.042781_g411665_i0 | PRJNA550047 | 413637 | 260 | 2.042781 | 5.3112306 | Alphaendornavirus capsici | 3426171 | Viruses | Viruses | 473 | 4.27e-129 | NTclustered | gi|390608729|gb|JQ951943.1| | 354328 | g411665 | i0 | 99.614 | 31.8769230769231 | 259 | 1 | 99 | 0 | 2 | 260 | 11758 | 12016 | Bell pepper endornavirus strain IS RNA-dependent RNA polymerase (RdRp) gene, complete cds | blastn | 8288 | 473 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus capsici | ||
| 24073055 | 24073055 | PRJNA550047_P_NODE_338239_length_289_cov_18.805556_g336269_i0 | PRJNA550047 | 338239 | 289 | 18.805556 | 54.34805684 | Tobamovirus | 12234 | Viruses | Viruses | 520 | 6.1e-143 | NTclustered | gi|66863602|dbj|AB113116.1| | 12239 | g336269 | i0 | 98.969 | 94.4221453287197 | 291 | 1 | 100 | 1 | 1 | 289 | 3614 | 3324 | Pepper mild mottle virus gene for 126k protein, complete cds, strain: Pa18 | blastn | 27288 | 520 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 24073579 | 24073579 | PRJNA550047_P_NODE_446039_length_248_cov_10.280000_g444067_i0 | PRJNA550047 | 446039 | 248 | 10.28 | 25.4944 | Tobamovirus | 12234 | Viruses | Viruses | 457 | 4.07e-124 | NTclustered | gi|20177424|ref|NC_003630.1| | 12239 | g444067 | i0 | 100 | 93.8306451612903 | 247 | 0 | 99 | 0 | 1 | 247 | 3590 | 3836 | Pepper mild mottle virus, complete genome | blastn | 23270 | 457 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 30362863 | 30362863 | PRJNA550047_P_NODE_442212_length_249_cov_16.284091_g440240_i0 | PRJNA550047 | 442212 | 249 | 16.284091 | 40.54738659 | Virgaviridae-like virus 4 | 3076992 | Viruses | Viruses | 92 | 1.83e-19 | NR | WPR18843.1 | 3076992 | g440240 | i0 | 60 | 1.02409638554217 | 85 | 29 | 98.8 | 2 | 4 | 249 | 44 | 126 | WPR18843.1 MAG: RNA-dependent RNA polymerase [Virgaviridae-like virus 4] | diamond | 255 | 92 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Virgaviridae-like virus 4 | |||
| 31658060 | 31658060 | PRJNA550047_P_NODE_281297_length_299_cov_3.407080_g279328_i0 | PRJNA550047 | 281297 | 299 | 3.40708 | 10.1871692 | Erysiphe necator associated flexivirus 3 | 2743100 | Viruses | Viruses | 114 | 7.27e-27 | NR | QKN22675.1 | 2743100 | g279328 | i0 | 57.3 | 1.03344481605351 | 103 | 40 | 99.3 | 1 | 3 | 299 | 539 | 641 | QKN22675.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 3] | diamond | 309 | 114 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 3 |
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);;