contig_metadata
16 rows where bioproject = "PRJNA986547", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"
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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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);;