contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA674050" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2441608 | 2441608 | PRJNA674050_P_NODE_13302_length_282_cov_4.583732_g13099_i0 | PRJNA674050 | 13302 | 282 | 4.583732 | 12.92612424 | Tobamovirus | 12234 | Viruses | Viruses | 521 | 1.6499999999999996e-143 | NTclustered | gi|2837380181|gb|PP099897.1| | 1761477 | g13099 | i0 | 100 | 100 | 282 | 0 | 100 | 0 | 1 | 282 | 3753 | 3472 | Tomato brown rugose fruit virus isolate NPPO-NL 36648757, complete genome | blastn | 28200 | 521 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 3194915 | 3194915 | PRJNA674050_P_NODE_33103_length_245_cov_1.808140_g32900_i0 | PRJNA674050 | 33103 | 245 | 1.80814 | 4.429943 | Chrocagosk virus | 3129397 | Viruses | Viruses | 69.4 | 2.2e-7 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g32900 | i0 | 100 | 0.151020408163265 | 37 | 0 | 15 | 0 | 208 | 244 | 555 | 519 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 37 | 69.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 7023020 | 7023020 | PRJNA674050_P_NODE_41826_length_213_cov_6.828571_g41623_i0 | PRJNA674050 | 41826 | 213 | 6.828571 | 14.54485623 | Leviviridae sp. | 2027243 | Viruses | Viruses | 65.8 | 2.41e-6 | NTclustered | gi|2183423903|gb|MZ679790.1| | 2027243 | g41623 | i0 | 100 | 41.7089201877934 | 35 | 0 | 95 | 0 | 73 | 107 | 3011 | 3045 | MAG: Leviviridae sp. isolate R28-k141_67620 genomic sequence | blastn | 8884 | 65.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 7544257 | 7544257 | PRJNA674050_P_NODE_6046_length_335_cov_1.748092_g5843_i0 | PRJNA674050 | 6046 | 335 | 1.748092 | 5.8561082 | Potexvirus | 12176 | Viruses | Viruses | 619 | 6.91e-173 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g5843 | i0 | 100 | 86.044776119403 | 335 | 0 | 100 | 0 | 1 | 335 | 2627 | 2293 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 28825 | 619 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 8296532 | 8296532 | PRJNA674050_P_NODE_10467_length_297_cov_1.200893_g10264_i0 | PRJNA674050 | 10467 | 297 | 1.200893 | 3.56665221 | Suillus luteus associated bunya-like virus 5 | 3067800 | Viruses | Viruses | 255 | 1.96e-63 | NTclustered | gi|2560563003|gb|OQ862568.1| | 3067800 | g10264 | i0 | 84.496 | 3.06734006734007 | 258 | 40 | 87 | 0 | 11 | 268 | 3934 | 4191 | Suillus luteus associated bunya-like virus 5 isolate SlaBV5 RNA-dependent RNA polymerase gene, complete cds | blastn | 911 | 255 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Suillus luteus associated bunya-like virus 5 | ||||
| 9573022 | 9573022 | PRJNA674050_P_NODE_8128_length_314_cov_1.468880_g7925_i0 | PRJNA674050 | 8128 | 314 | 1.46888 | 4.6122832 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 60.2 | 1.76e-4 | NTclustered | gi|2183471584|gb|MZ680221.1| | 2583949 | g7925 | i0 | 100 | 0.101910828025478 | 32 | 0 | 10 | 0 | 110 | 141 | 56 | 87 | MAG: Narnaviridae sp. isolate 200-k141_438310 putative RNA-dependent RNA polymerase gene, complete cds | blastn | 32 | 60.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 10847522 | 10847522 | PRJNA674050_P_NODE_16829_length_269_cov_1.392857_g16626_i0 | PRJNA674050 | 16829 | 269 | 1.392857 | 3.74678533 | Shenzhen dicistro-like virus | 2789378 | Viruses | Viruses | 409 | 1.27e-109 | NTclustered | gi|1940198121|gb|MT757492.1| | 2789378 | g16626 | i0 | 94.052 | 3.00371747211896 | 269 | 16 | 100 | 0 | 1 | 269 | 3534 | 3802 | Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds | blastn | 808 | 409 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Shenzhen dicistro-like virus | |||
| 10848589 | 10848589 | PRJNA674050_P_NODE_9589_length_303_cov_1.530435_g9386_i0 | PRJNA674050 | 9589 | 303 | 1.530435 | 4.63721805 | Shenzhen reo-like virus 1 | 2789623 | Viruses | Viruses | 477 | 3.9299999999999986e-130 | NTclustered | gi|1940198125|gb|MT757494.1| | 2789623 | g9386 | i0 | 95.05 | 1 | 303 | 15 | 100 | 0 | 1 | 303 | 723 | 421 | Shenzhen reo-like virus 1 strain CHNdp-4 hypothetical protein gene, complete cds | blastn | 303 | 477 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Shenzhen reo-like virus 1 | ||||
| 11369927 | 11369927 | PRJNA674050_P_NODE_6769_length_327_cov_1.342520_g6566_i0 | PRJNA674050 | 6769 | 327 | 1.34252 | 4.3900404 | Potexvirus | 12176 | Viruses | Viruses | 599 | 8.759999999999997e-167 | NTclustered | gi|375808845|gb|JN835466.1| | 112229 | g6566 | i0 | 99.694 | 58.4709480122324 | 327 | 1 | 100 | 0 | 1 | 327 | 779 | 453 | Pepino mosaic virus strain CH2, complete genome | blastn | 19120 | 599 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 11369936 | 11369936 | PRJNA674050_P_NODE_8789_length_309_cov_1.317797_g8586_i0 | PRJNA674050 | 8789 | 309 | 1.317797 | 4.07199273 | Potexvirus | 12176 | Viruses | Viruses | 558 | 1.39e-154 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g8586 | i0 | 99.351 | 56.831715210356 | 308 | 2 | 99 | 0 | 2 | 309 | 3036 | 2729 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 17561 | 558 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 13398608 | 13398608 | PRJNA674050_P_NODE_91_length_2022_cov_3.617753_g53_i0 | PRJNA674050 | 91 | 2022 | 3.617753 | 73.15096566 | Tobamovirus fructirugosum | 3432872 | Viruses | Viruses | 3718 | 0 | NTclustered | gi|2201445642|gb|OM515246.1| | 1761477 | g53 | i0 | 99.852 | 100 | 2022 | 3 | 100 | 0 | 1 | 2022 | 3466 | 1445 | Tomato brown rugose fruit virus isolate 39986364, complete genome | blastn | 202200 | 3718 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 14673449 | 14673449 | PRJNA674050_P_NODE_552_length_957_cov_7.289593_g397_i0 | PRJNA674050 | 552 | 957 | 7.289593 | 69.76140501 | Tobamovirus fructirugosum | 3432872 | Viruses | Viruses | 1768 | 0 | NTclustered | gi|2201445642|gb|OM515246.1| | 1761477 | g397 | i0 | 100 | 100 | 957 | 0 | 100 | 0 | 1 | 957 | 4788 | 5744 | Tomato brown rugose fruit virus isolate 39986364, complete genome | blastn | 95700 | 1768 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 15947145 | 15947145 | PRJNA674050_P_NODE_793_length_780_cov_6.454031_g617_i0 | PRJNA674050 | 793 | 780 | 6.454031 | 50.3414418 | Tobamovirus fructirugosum | 3432872 | Viruses | Viruses | 1441 | 0 | NTclustered | gi|2837380407|gb|PP099942.1| | 1761477 | g617 | i0 | 100 | 100 | 780 | 0 | 100 | 0 | 1 | 780 | 4496 | 3717 | Tomato brown rugose fruit virus isolate NPPO-NL 41927291, complete genome | blastn | 78000 | 1441 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 17222180 | 17222180 | PRJNA674050_P_NODE_3494_length_387_cov_1.726115_g3291_i0 | PRJNA674050 | 3494 | 387 | 1.726115 | 6.68006505 | Shenzhen reo-like virus 1 | 2789623 | Viruses | Viruses | 593 | 4.9e-165 | NTclustered | gi|1940198125|gb|MT757494.1| | 2789623 | g3291 | i0 | 94.315 | 1 | 387 | 22 | 100 | 0 | 1 | 387 | 3582 | 3968 | Shenzhen reo-like virus 1 strain CHNdp-4 hypothetical protein gene, complete cds | blastn | 387 | 593 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Shenzhen reo-like virus 1 | ||||
| 19018048 | 19018048 | PRJNA674050_P_NODE_395_length_1160_cov_2.668813_g266_i0 | PRJNA674050 | 395 | 1160 | 2.668813 | 30.9582308 | Tobamovirus | 12234 | Viruses | Viruses | 2141 | 0 | NTclustered | gi|2837380407|gb|PP099942.1| | 1761477 | g266 | i0 | 100 | 99.9137931034483 | 1159 | 0 | 99 | 0 | 1 | 1159 | 230 | 1388 | Tomato brown rugose fruit virus isolate NPPO-NL 41927291, complete genome | blastn | 115900 | 2141 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 22321180 | 22321180 | PRJNA674050_P_NODE_28078_length_248_cov_1.920000_g27875_i0 | PRJNA674050 | 28078 | 248 | 1.92 | 4.7616 | Ripastyr virus | 3131364 | Viruses | Viruses | 442 | 1.1399999999999995e-119 | NTclustered | gi|2717322326|gb|PP173666.1| | 3131364 | g27875 | i0 | 98.79 | 796.612903225806 | 248 | 3 | 100 | 0 | 1 | 248 | 405 | 158 | MAG: Ripastyr virus isolate MP3_k141_6580 genomic sequence | blastn | 197560 | 442 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripastyr virus | |||||
| 22321659 | 22321659 | PRJNA674050_P_NODE_41038_length_232_cov_2.572327_g40835_i0 | PRJNA674050 | 41038 | 232 | 2.572327 | 5.96779864 | Shenzhen reo-like virus 1 | 2789623 | Viruses | Viruses | 335 | 1.8399999999999992e-87 | NTclustered | gi|1940198125|gb|MT757494.1| | 2789623 | g40835 | i0 | 92.735 | 1.00862068965517 | 234 | 13 | 100 | 4 | 1 | 232 | 3477 | 3246 | Shenzhen reo-like virus 1 strain CHNdp-4 hypothetical protein gene, complete cds | blastn | 234 | 335 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Shenzhen reo-like virus 1 | ||||
| 24118202 | 24118202 | PRJNA674050_P_NODE_1139_length_633_cov_6.496429_g945_i0 | PRJNA674050 | 1139 | 633 | 6.496429 | 41.12239557 | Tobamovirus | 12234 | Viruses | Viruses | 1170 | 0 | NTclustered | gi|2837380407|gb|PP099942.1| | 1761477 | g945 | i0 | 100 | 100 | 633 | 0 | 100 | 0 | 1 | 633 | 5714 | 6346 | Tomato brown rugose fruit virus isolate NPPO-NL 41927291, complete genome | blastn | 63300 | 1170 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 24870211 | 24870211 | PRJNA674050_P_NODE_32580_length_246_cov_0.895954_g32377_i0 | PRJNA674050 | 32580 | 246 | 0.895954 | 2.20404684 | Orthonoravirus melanogastri | 3060507 | Viruses | Viruses | 438 | 1.4599999999999996e-118 | NTclustered | gi|822478482|gb|KP970089.1| | 3071212 | g32377 | i0 | 98.78 | 38.7276422764228 | 246 | 3 | 100 | 0 | 1 | 246 | 4039 | 4284 | Nora virus isolate IM13 gp1 (gp1) gene, partial cds; replication polyprotein (gp2) and gp3 (gp3) genes, complete cds; and capsid protein (gp4) gene, partial cds | blastn | 9527 | 438 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Noraviridae | Orthonoravirus | Orthonoravirus melanogastri | ||
| 24870557 | 24870557 | PRJNA674050_P_NODE_42260_length_198_cov_10.832000_g42057_i0 | PRJNA674050 | 42260 | 198 | 10.832 | 21.44736 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 111 | 2.79e-20 | NTclustered | gi|2155033579|emb|OV039277.1| | 2697049 | g42057 | i0 | 100 | 25.6464646464646 | 60 | 0 | 88 | 0 | 126 | 185 | 30567 | 30508 | Severe acute respiratory syndrome coronavirus 2 isolate 165 genome assembly, chromosome: 165 | blastn | 5078 | 111 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 25392832 | 25392832 | PRJNA674050_P_NODE_7920_length_316_cov_1.275720_g7717_i0 | PRJNA674050 | 7920 | 316 | 1.27572 | 4.0312752 | Potexvirus | 12176 | Viruses | Viruses | 582 | 8.489999999999998e-162 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g7717 | i0 | 100 | 57.8101265822785 | 315 | 0 | 99 | 0 | 2 | 316 | 1689 | 1375 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 18268 | 582 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 25392835 | 25392835 | PRJNA674050_P_NODE_8640_length_310_cov_1.565401_g8437_i0 | PRJNA674050 | 8640 | 310 | 1.565401 | 4.8527431 | Potexvirus | 12176 | Viruses | Viruses | 573 | 4.999999999999998e-159 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g8437 | i0 | 100 | 100 | 310 | 0 | 100 | 0 | 1 | 310 | 5061 | 4752 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 31000 | 573 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini |
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);;