contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA565778" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 558423 | 558423 | PRJNA565778_S_NODE_3781_length_520_cov_265.521739_g3577_i0 | PRJNA565778 | 3781 | 520 | 265.521739 | 1380.7130428 | Potexvirus pepini | 3433856 | Viruses | Viruses | 876 | 0 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g3577 | i0 | 99.38 | 87.7403846153846 | 484 | 2 | 93 | 1 | 38 | 520 | 5898 | 6381 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 45625 | 876 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 3108972 | 3108972 | PRJNA565778_S_NODE_13183_length_302_cov_441.962264_g12887_i0 | PRJNA565778 | 13183 | 302 | 441.962264 | 1334.72603728 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 473 | 5.059999999999999e-129 | NTclustered | gi|2813525801|dbj|LC846392.1| | 12242 | g12887 | i0 | 98.868 | 87.7748344370861 | 265 | 3 | 88 | 0 | 1 | 265 | 2571 | 2307 | Tobacco mosaic virus TMV-Du-CNU1 genomic RNA, complete genome | blastn | 26508 | 473 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 3108988 | 3108988 | PRJNA565778_S_NODE_1403_length_751_cov_11.747899_g1303_i0 | PRJNA565778 | 1403 | 751 | 11.747899 | 88.22672149 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 1306 | 0 | NTclustered | gi|2813525801|dbj|LC846392.1| | 12242 | g1303 | i0 | 99.444 | 95.7470039946738 | 719 | 4 | 96 | 0 | 1 | 719 | 5614 | 4896 | Tobacco mosaic virus TMV-Du-CNU1 genomic RNA, complete genome | blastn | 71906 | 1306 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 4385857 | 4385857 | PRJNA565778_S_NODE_33844_length_187_cov_194.833333_g33548_i0 | PRJNA565778 | 33844 | 187 | 194.833333 | 364.33833271 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 268 | 1.46e-67 | NTclustered | gi|2813525801|dbj|LC846392.1| | 12242 | g33548 | i0 | 99.329 | 79.6844919786096 | 149 | 0 | 79 | 1 | 38 | 185 | 3672 | 3820 | Tobacco mosaic virus TMV-Du-CNU1 genomic RNA, complete genome | blastn | 14901 | 268 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 6936357 | 6936357 | PRJNA565778_S_NODE_25066_length_220_cov_162.054645_g24770_i0 | PRJNA565778 | 25066 | 220 | 162.054645 | 356.520219 | Unuamitovirus alar1 | 2956583 | Viruses | Viruses | 333 | 6.209999999999999e-87 | NTclustered | gi|1050767093|dbj|LC145036.1| | 1826822 | g24770 | i0 | 99.454 | 5.98636363636364 | 183 | 1 | 83 | 0 | 38 | 220 | 1 | 183 | Alternaria arborescens mitovirus 1 genomic RNA, complete genome | blastn | 1317 | 333 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Unuamitovirus | Unuamitovirus alar1 | ||
| 6936540 | 6936540 | PRJNA565778_S_NODE_4186_length_498_cov_78.646421_g3971_i0 | PRJNA565778 | 4186 | 498 | 78.646421 | 391.65917658 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 381 | 5.459999999999999e-101 | NTclustered | gi|2320142628|gb|ON585088.1| | 2808997 | g3971 | i0 | 82.112 | 0.931726907630522 | 464 | 66 | 91 | 16 | 6 | 460 | 2541 | 2086 | MAG: Botourmiaviridae sp. isolate PMS2_Contig239 RNA-dependent RNA polymerase gene, complete cds | blastn | 464 | 381 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 9486900 | 9486900 | PRJNA565778_S_NODE_788_length_915_cov_5.216401_g722_i0 | PRJNA565778 | 788 | 915 | 5.216401 | 47.73006915 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 1561 | 0 | NTclustered | gi|2320142606|gb|ON585076.1| | 2808997 | g722 | i0 | 98.747 | 2.24262295081967 | 878 | 11 | 96 | 0 | 33 | 910 | 1477 | 2354 | MAG: Botourmiaviridae sp. isolate PMS1_DN1240 RNA-dependent RNA polymerase gene, complete cds | blastn | 2052 | 1561 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 10762603 | 10762603 | PRJNA565778_S_NODE_27789_length_209_cov_22.401163_g27493_i0 | PRJNA565778 | 27789 | 209 | 22.401163 | 46.81843067 | Rotavirus alphagastroenteritidis | 3432193 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2314496612|gb|ON791960.1| | 28875 | g27493 | i0 | 100 | 14.0382775119617 | 30 | 0 | 14 | 0 | 143 | 172 | 1010 | 1039 | Rotavirus A strain RVA/Human-wt/MWI/CHX11U/2019/G3P[8] NSP3 gene, complete cds | blastn | 2934 | 56.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Rotavirus | Rotavirus alphagastroenteritidis | ||
| 10762756 | 10762756 | PRJNA565778_S_NODE_4089_length_503_cov_73.881974_g3875_i0 | PRJNA565778 | 4089 | 503 | 73.881974 | 371.62632922 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 846 | 0 | NTclustered | gi|2813525801|dbj|LC846392.1| | 12242 | g3875 | i0 | 99.57 | 92.4453280318091 | 465 | 1 | 92 | 1 | 3 | 466 | 3820 | 3356 | Tobacco mosaic virus TMV-Du-CNU1 genomic RNA, complete genome | blastn | 46500 | 846 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 12037131 | 12037131 | PRJNA565778_S_NODE_11550_length_321_cov_258.095070_g11254_i0 | PRJNA565778 | 11550 | 321 | 258.09507 | 828.4851747 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 512 | 1.1499999999999998e-140 | NTclustered | gi|2813525801|dbj|LC846392.1| | 12242 | g11254 | i0 | 99.643 | 86.8847352024922 | 280 | 1 | 87 | 0 | 5 | 284 | 5967 | 5688 | Tobacco mosaic virus TMV-Du-CNU1 genomic RNA, complete genome | blastn | 27890 | 512 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 13312201 | 13312201 | PRJNA565778_S_NODE_22551_length_233_cov_6.224490_g22255_i0 | PRJNA565778 | 22551 | 233 | 6.22449 | 14.5030617 | Potexvirus pepini | 3433856 | Viruses | Viruses | 431 | 2.2899999999999996e-116 | NTclustered | gi|57282636|emb|AJ606361.1| | 112229 | g22255 | i0 | 100 | 81.4892703862661 | 233 | 0 | 100 | 0 | 1 | 233 | 6185 | 6417 | Pepino mosaic virus complete genome, isolate LP-2001 | blastn | 18987 | 431 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 17136152 | 17136152 | PRJNA565778_S_NODE_6814_length_407_cov_88.662162_g722_i1 | PRJNA565778 | 6814 | 407 | 88.662162 | 360.85499934 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 649 | 0 | NTclustered | gi|2320142606|gb|ON585076.1| | 2808997 | g722 | i1 | 98.634 | 2.03439803439803 | 366 | 5 | 90 | 0 | 6 | 371 | 2354 | 1989 | MAG: Botourmiaviridae sp. isolate PMS1_DN1240 RNA-dependent RNA polymerase gene, complete cds | blastn | 828 | 649 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 17136184 | 17136184 | PRJNA565778_S_NODE_8674_length_366_cov_4.601824_g8378_i0 | PRJNA565778 | 8674 | 366 | 4.601824 | 16.84267584 | Potexvirus pepini | 3433856 | Viruses | Viruses | 625 | 1.6299999999999995e-174 | NTclustered | gi|251821320|emb|FN429033.1| | 112229 | g8378 | i0 | 100 | 92.3415300546448 | 338 | 0 | 92 | 0 | 29 | 366 | 239 | 576 | Pepino mosaic virus partial CP gene for coat protein, strain PV-0554, genomic RNA | blastn | 33797 | 625 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 18987067 | 18987067 | PRJNA565778_S_NODE_17375_length_265_cov_4.644737_g17079_i0 | PRJNA565778 | 17375 | 265 | 4.644737 | 12.30855305 | Botourmiaviridae | 2560063 | Viruses | Viruses | 84.2 | 8.59e-12 | NTclustered | gi|2500381378|ref|NC_076801.1| | 2686545 | g17079 | i0 | 100 | 4.93584905660377 | 45 | 0 | 17 | 0 | 4 | 48 | 2330 | 2286 | Plasmopara viticola lesion associated ourmia-like virus 72 isolate DMG-F_43929 RNA dependent RNA polymerase (QKR77_gp1) gene, complete cds | blastn | 1308 | 84.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Scleroulivirus | Scleroulivirus lambdaplasmoparae | ||
| 19684700 | 19684700 | PRJNA565778_S_NODE_24636_length_222_cov_73.935135_g24340_i0 | PRJNA565778 | 24636 | 222 | 73.935135 | 164.1359997 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 167 | 6.739999999999999e-37 | NTclustered | gi|1935607033|gb|MT747992.1| | 2789443 | g24340 | i0 | 85.535 | 0.716216216216216 | 159 | 23 | 72 | 0 | 37 | 195 | 3131 | 3289 | Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds | blastn | 159 | 167 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 20960248 | 20960248 | PRJNA565778_S_NODE_12697_length_308_cov_45.535055_g12401_i0 | PRJNA565778 | 12697 | 308 | 45.535055 | 140.2479694 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 472 | 1.86e-128 | NTclustered | gi|2217162015|gb|OL584366.1| | 12242 | g12401 | i0 | 98.864 | 85.7077922077922 | 264 | 3 | 86 | 0 | 37 | 300 | 1440 | 1703 | Tobacco mosaic virus isolate DSMZ PV-1199 genomic sequence | blastn | 26398 | 472 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 20960291 | 20960291 | PRJNA565778_S_NODE_16097_length_275_cov_103.189076_g15801_i0 | PRJNA565778 | 16097 | 275 | 103.189076 | 283.769959 | Nepovirus avii | 3047741 | Viruses | Viruses | 403 | 6.06e-108 | NTclustered | gi|498716|emb|Z34265.1| | 12615 | g15801 | i0 | 98.268 | 80.2472727272727 | 231 | 3 | 84 | 1 | 9 | 238 | 1588 | 1358 | Cherry leaf roll virus (walnut) genomic RNA (1588bp) | blastn | 22068 | 403 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 20960394 | 20960394 | PRJNA565778_S_NODE_23477_length_228_cov_7.607330_g23181_i0 | PRJNA565778 | 23477 | 228 | 7.60733 | 17.3447124 | Bromovirus BMV | 3427622 | Viruses | Viruses | 344 | 2.99e-90 | NTclustered | gi|2214792991|gb|MW581063.1| | 12302 | g23181 | i0 | 98.469 | 28.3684210526316 | 196 | 2 | 86 | 1 | 1 | 195 | 1189 | 994 | Brome mosaic virus isolate BMV-R movement protein and coat protein genes, complete cds | blastn | 6468 | 344 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Bromovirus | Bromovirus BMV |
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);;