contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA986547" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 974242 | 974242 | PRJNA986547_P_NODE_501_length_641_cov_1.399648_g421_i0 | PRJNA986547 | 501 | 641 | 1.399648 | 8.97174368 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 976 | 0 | NTclustered | gi|393890108|gb|JN941976.1| | 53954 | g421 | i0 | 94.21 | 28.0015600624025 | 639 | 37 | 99 | 0 | 1 | 639 | 555 | 1193 | Sugarcane streak mosaic virus isolate CBS8436 HC-Pro protein gene, partial cds | blastn | 17949 | 976 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari | ||
| 2249414 | 2249414 | PRJNA986547_P_NODE_16482_length_204_cov_9.786260_g16400_i0 | PRJNA986547 | 16482 | 204 | 9.78626 | 19.9639704 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 250 | 5.88e-62 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g16400 | i0 | 88.725 | 1 | 204 | 23 | 100 | 0 | 1 | 204 | 2477 | 2274 | Malassezia restricta virus MrV40L, complete genome | blastn | 204 | 250 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 2249445 | 2249445 | PRJNA986547_P_NODE_2_length_6723_cov_17.231729_g1_i0 | PRJNA986547 | 2 | 6723 | 17.231729 | 1158.48914067 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 11989 | 0 | NTclustered | gi|350643441|gb|JF488066.1| | 53954 | g1 | i0 | 98.855 | 62.878774356686 | 6723 | 77 | 100 | 0 | 1 | 6723 | 3059 | 9781 | Sugarcane streak mosaic virus isolate ID, complete genome | blastn | 422734 | 11989 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari | ||
| 2547948 | 2547948 | PRJNA986547_P_NODE_15162_length_217_cov_4.541667_g15080_i0 | PRJNA986547 | 15162 | 217 | 4.541667 | 9.85541739 | Tobamovirus | 12234 | Viruses | Viruses | 396 | 7.689999999999997e-106 | NTclustered | gi|1782797563|gb|MK933286.1| | 12235 | g15080 | i0 | 99.541 | 100.705069124424 | 218 | 0 | 100 | 1 | 1 | 217 | 5587 | 5804 | Cucumber green mottle mosaic virus isolate GDLZ, complete genome | blastn | 21853 | 396 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus viridimaculae | ||
| 3524751 | 3524751 | PRJNA986547_P_NODE_3_length_6723_cov_17.098947_g1_i1 | PRJNA986547 | 3 | 6723 | 17.098947 | 1149.56220681 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 11917 | 0 | NTclustered | gi|350643441|gb|JF488066.1| | 53954 | g1 | i1 | 98.661 | 62.878774356686 | 6723 | 90 | 100 | 0 | 1 | 6723 | 9781 | 3059 | Sugarcane streak mosaic virus isolate ID, complete genome | blastn | 422734 | 11917 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari | ||
| 3524755 | 3524755 | PRJNA986547_P_NODE_4363_length_286_cov_4.103286_g4281_i0 | PRJNA986547 | 4363 | 286 | 4.103286 | 11.73539796 | Plasmopara viticola lesion associated narnavirus 33 | 2719518 | Viruses | Viruses | 484 | 2.2e-132 | NTclustered | gi|1826554045|gb|MN539850.1| | 2719518 | g4281 | i0 | 97.203 | 4 | 286 | 8 | 100 | 0 | 1 | 286 | 668 | 383 | Plasmopara viticola lesion associated narnavirus 33 isolate DMG-A_DN38564 RNA-dependent RNA polymerase gene, complete cds | blastn | 1144 | 484 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Plasmopara viticola lesion associated narnavirus 33 | ||
| 4802140 | 4802140 | PRJNA986547_P_NODE_4_length_3494_cov_6.276820_g1_i2 | PRJNA986547 | 4 | 3494 | 6.27682 | 219.3120908 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 6259 | 0 | NTclustered | gi|2576869639|gb|OR259188.1| | 53954 | g1 | i2 | 98.998 | 75.6182026330853 | 3494 | 35 | 100 | 0 | 1 | 3494 | 6552 | 3059 | Sugarcane streak mosaic virus isolate YN-21, complete genome | blastn | 264210 | 6259 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari | ||
| 6077501 | 6077501 | PRJNA986547_P_NODE_845_length_477_cov_1.992574_g763_i0 | PRJNA986547 | 845 | 477 | 1.992574 | 9.50457798 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 843 | 0 | NTclustered | gi|407911837|gb|JQ975096.1| | 53954 | g763 | i0 | 98.532 | 1 | 477 | 7 | 100 | 0 | 1 | 477 | 114 | 590 | Sugarcane streak mosaic virus isolate M121 polyprotein gene, partial cds | blastn | 477 | 843 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari | ||
| 7351956 | 7351956 | PRJNA986547_P_NODE_246_length_1020_cov_1.985216_g183_i0 | PRJNA986547 | 246 | 1020 | 1.985216 | 20.2492032 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 1790 | 0 | NTclustered | gi|940784937|gb|KT257208.1| | 53954 | g183 | i0 | 98.333 | 75.2127450980392 | 1020 | 17 | 100 | 0 | 1 | 1020 | 2112 | 3131 | Sugarcane streak mosaic virus isolate GN12 clone P1P3-CL10 polyprotein gene, partial cds | blastn | 76717 | 1790 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari | ||
| 7352012 | 7352012 | PRJNA986547_P_NODE_6_length_3415_cov_5.213046_g3_i0 | PRJNA986547 | 6 | 3415 | 5.213046 | 178.0255209 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 5398 | 0 | NTclustered | gi|940785099|gb|KT257289.1| | 53954 | g3 | i0 | 99.362 | 71.193850658858 | 2980 | 19 | 87 | 0 | 436 | 3415 | 1 | 2980 | Sugarcane streak mosaic virus isolate M117 clone NIACP-CL4 polyprotein gene, partial cds | blastn | 243127 | 5398 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari | ||
| 8627298 | 8627298 | PRJNA986547_P_NODE_7_length_3346_cov_6.133822_g1_i3 | PRJNA986547 | 7 | 3346 | 6.133822 | 205.23768412 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 5963 | 0 | NTclustered | gi|2576869639|gb|OR259188.1| | 53954 | g1 | i3 | 98.834 | 77.5026897788404 | 3346 | 39 | 100 | 0 | 1 | 3346 | 6123 | 2778 | Sugarcane streak mosaic virus isolate YN-21, complete genome | blastn | 259324 | 5963 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari | ||
| 9902391 | 9902391 | PRJNA986547_P_NODE_48_length_1999_cov_2.217030_g33_i0 | PRJNA986547 | 48 | 1999 | 2.21703 | 44.3184297 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 3603 | 0 | NTclustered | gi|407911837|gb|JQ975096.1| | 53954 | g33 | i0 | 99.2 | 53.8774387193597 | 1999 | 16 | 100 | 0 | 1 | 1999 | 603 | 2601 | Sugarcane streak mosaic virus isolate M121 polyprotein gene, partial cds | blastn | 107701 | 3603 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari | ||
| 11177603 | 11177603 | PRJNA986547_P_NODE_569_length_596_cov_1.250478_g489_i0 | PRJNA986547 | 569 | 596 | 1.250478 | 7.45284888 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 1090 | 0 | NTclustered | gi|1139491843|gb|KU314372.1| | 53954 | g489 | i0 | 99.664 | 95 | 596 | 2 | 100 | 0 | 1 | 596 | 289 | 884 | Sugarcane streak mosaic virus clone M86-CL4 HC-Pro gene, partial cds | blastn | 56620 | 1090 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari | ||
| 11475945 | 11475945 | PRJNA986547_P_NODE_12429_length_239_cov_3.265060_g12347_i0 | PRJNA986547 | 12429 | 239 | 3.26506 | 7.8034934 | Orthorubulavirus | 2560195 | Viruses | Viruses | 442 | 1.0899999999999994e-119 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g12347 | i0 | 100 | 69.0376569037657 | 239 | 0 | 100 | 0 | 1 | 239 | 14343 | 14581 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 16500 | 442 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 12453497 | 12453497 | PRJNA986547_P_NODE_970_length_448_cov_2.450667_g888_i0 | PRJNA986547 | 970 | 448 | 2.450667 | 10.97898816 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 828 | 0 | NTclustered | gi|669251287|gb|KJ187047.1| | 53954 | g888 | i0 | 100 | 66.9910714285714 | 448 | 0 | 100 | 0 | 1 | 448 | 877 | 430 | Sugarcane streak mosaic virus isolate YN-YZ211, complete genome | blastn | 30012 | 828 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari | ||
| 16277087 | 16277087 | PRJNA986547_P_NODE_4313_length_287_cov_1.733645_g4231_i0 | PRJNA986547 | 4313 | 287 | 1.733645 | 4.97556115 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 514 | 2.82e-141 | NTclustered | gi|940784953|gb|KT257216.1| | 53954 | g4231 | i0 | 98.955 | 24.0174216027875 | 287 | 3 | 100 | 0 | 1 | 287 | 1237 | 951 | Sugarcane streak mosaic virus isolate M117 clone P1P3-CL3 polyprotein gene, partial cds | blastn | 6893 | 514 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari | ||
| 20100683 | 20100683 | PRJNA986547_P_NODE_2036_length_334_cov_1.264368_g1954_i0 | PRJNA986547 | 2036 | 334 | 1.264368 | 4.22298912 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 617 | 2.48e-172 | NTclustered | gi|407911791|gb|JQ975073.1| | 53954 | g1954 | i0 | 100 | 12.9880239520958 | 334 | 0 | 100 | 0 | 1 | 334 | 845 | 512 | Sugarcane streak mosaic virus isolate M61 polyprotein gene, partial cds | blastn | 4338 | 617 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari | ||
| 20100687 | 20100687 | PRJNA986547_P_NODE_2276_length_321_cov_1.544355_g2194_i0 | PRJNA986547 | 2276 | 321 | 1.544355 | 4.95737955 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 588 | 1.8599999999999994e-163 | NTclustered | gi|407911791|gb|JQ975073.1| | 53954 | g2194 | i0 | 99.688 | 28.8878504672897 | 321 | 1 | 100 | 0 | 1 | 321 | 1731 | 1411 | Sugarcane streak mosaic virus isolate M61 polyprotein gene, partial cds | blastn | 9273 | 588 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari | ||
| 24223978 | 24223978 | PRJNA986547_P_NODE_9819_length_247_cov_2.505747_g9737_i0 | PRJNA986547 | 9819 | 247 | 2.505747 | 6.18919509 | Orthorubulavirus | 2560195 | Viruses | Viruses | 451 | 1.88e-122 | NTclustered | gi|1540352612|gb|MK117734.1| | 2560580 | g9737 | i0 | 99.595 | 97 | 247 | 1 | 100 | 0 | 1 | 247 | 1225 | 1471 | Mammalian orthorubulavirus 5 isolate XJ-WLMQ fusion protein mRNA, complete cds | blastn | 23959 | 451 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 25200259 | 25200259 | PRJNA986547_P_NODE_10840_length_244_cov_2.842105_g10758_i0 | PRJNA986547 | 10840 | 244 | 2.842105 | 6.9347362 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 440 | 4.019999999999999e-119 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g10758 | i0 | 99.18 | 1 | 244 | 2 | 100 | 0 | 1 | 244 | 1147 | 904 | Malassezia restricta virus MrV40L, complete genome | blastn | 244 | 440 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 25200392 | 25200392 | PRJNA986547_P_NODE_260_length_970_cov_1.830546_g196_i0 | PRJNA986547 | 260 | 970 | 1.830546 | 17.7562962 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 1336 | 0 | NTclustered | gi|940784951|gb|KT257215.1| | 53954 | g196 | i0 | 97.212 | 84.0958762886598 | 789 | 22 | 81 | 0 | 3 | 791 | 2465 | 3253 | Sugarcane streak mosaic virus isolate M117 clone P1P3-CL2 polyprotein gene, partial cds | blastn | 81573 | 1336 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari | ||
| 25200410 | 25200410 | PRJNA986547_P_NODE_420_length_715_cov_1.919003_g340_i0 | PRJNA986547 | 420 | 715 | 1.919003 | 13.72087145 | Poacevirus sacchari | 3431714 | Viruses | Viruses | 1282 | 0 | NTclustered | gi|350643441|gb|JF488066.1| | 53954 | g340 | i0 | 99.021 | 89.1734265734266 | 715 | 7 | 100 | 0 | 1 | 715 | 1787 | 1073 | Sugarcane streak mosaic virus isolate ID, complete genome | blastn | 63759 | 1282 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Poacevirus | Poacevirus sacchari |
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);;