RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where bioproject = "PRJNA1108009" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1108009 · 24 ✖

tax_clade 0

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
212750 212750 PRJNA1108009_P_NODE_14161_length_351_cov_1.003597_g13843_i0 PRJNA1108009 14161 351 1.003597 3.52262547 Waikavirus betacamelliae 3433715 Viruses Viruses 429 1.31e-115   NTclustered gi|2579104662|tpg|BK062984.1| 3027336 g13843 i0 88.825 0.994301994301994 349 39 99 0 1 349 10945 11293 TPA_asm: Camellia virus B polyprotein and ORFX protein genes, complete cds blastn 349 429 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Waikavirus Waikavirus betacamelliae
1487833 1487833 PRJNA1108009_P_NODE_2_length_7155_cov_11.235527_g1_i0 PRJNA1108009 2 7155 11.235527 803.90195685 Potyvirus nicotianavenaobscurum 3240570 Viruses Viruses 12853 0   NTclustered gi|2419393318|gb|ON924220.1| 33765 g1 i0 99.092 40.0711390635919 7155 65 100 0 1 7155 9554 2400 Tobacco vein banding mosaic virus isolate PV-0721, complete genome blastn 286709 12853 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus nicotianavenaobscurum
2763625 2763625 PRJNA1108009_P_NODE_2023_length_950_cov_2.185861_g1782_i0 PRJNA1108009 2023 950 2.185861 20.7656795 Potyvirus nicotianavenaobscurum 3240570 Viruses Viruses 1700 0   NTclustered gi|2419393318|gb|ON924220.1| 33765 g1782 i0 98.947 70.1568421052632 950 10 100 0 1 950 2396 1447 Tobacco vein banding mosaic virus isolate PV-0721, complete genome blastn 66649 1700 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus nicotianavenaobscurum
2763945 2763945 PRJNA1108009_P_NODE_3_length_7144_cov_33.077358_g2_i0 PRJNA1108009 3 7144 33.077358 2363.04645552 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2474 0   NR WKU61618.1 3063761 g2 i0 63.4 0.933090705487122 2222 787 92.3 4 510 7103 1 2220 WKU61618.1 polyprotein [Zebrafish picornavirus 2] diamond 6666 2474 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
3571073 3571073 PRJNA1108009_P_NODE_323_length_1877_cov_20.194013_g228_i0 PRJNA1108009 323 1877 20.194013 379.04162401 Alphapartitivirus 1511808 Viruses Viruses 3467 0   NTclustered gi|2183385481|gb|OL521638.1| 2043550 g228 i0 100 48.8289824187533 1877 0 100 0 1 1877 3 1879 MAG: Medicago sativa alphapartitivirus 1 isolate G9_GS3 segment RNA1, complete sequence blastn 91652 3467 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Alphapartitivirus Medicago sativa alphapartitivirus 1
6591415 6591415 PRJNA1108009_P_NODE_6986_length_523_cov_2.515556_g6672_i0 PRJNA1108009 6986 523 2.515556 13.15635788 Alphapartitivirus betae 3426225 Viruses Viruses 953 0   NTclustered gi|212681415|ref|NC_011557.1| 509923 g6672 i0 99.618 2 523 1 100 1 1 523 1160 1681 Beet cryptic virus 1 RNA 2, complete genome blastn 1046 953 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Alphapartitivirus Alphapartitivirus betae
7865579 7865579 PRJNA1108009_P_NODE_16467_length_323_cov_0.996000_g16149_i0 PRJNA1108009 16467 323 0.996 3.21708 Fabavirus betaviciae 3047702 Viruses Viruses 329 1.25e-85   NTclustered gi|2450645137|gb|ON759448.1| 76875 g16149 i0 85.231 23.0216718266254 325 42 99 6 1 321 3432 3110 Broad bean wilt virus 2 isolate P05-2 segment RNA2, complete sequence blastn 7436 329 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
7865674 7865674 PRJNA1108009_P_NODE_19887_length_288_cov_1.972093_g19569_i0 PRJNA1108009 19887 288 1.972093 5.67962784 Potyvirus nicotianavenaobscurum 3240570 Viruses Viruses 508 1.32e-139   NTclustered gi|2419393318|gb|ON924220.1| 33765 g19569 i0 98.606 24.9097222222222 287 4 99 0 2 288 618 332 Tobacco vein banding mosaic virus isolate PV-0721, complete genome blastn 7174 508 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus nicotianavenaobscurum
7865753 7865753 PRJNA1108009_P_NODE_22747_length_266_cov_0.787565_g22429_i0 PRJNA1108009 22747 266 0.787565 2.0949229 Fabavirus betaviciae 3047702 Viruses Viruses 459 1.2299999999999998e-124   NTclustered gi|2470334476|gb|OP146156.1| 76875 g22429 i0 97.744 44.8796992481203 266 6 100 0 1 266 821 556 Broad bean wilt virus 2 isolate Rg2020-21 polyprotein gene, partial cds blastn 11938 459 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
9140307 9140307 PRJNA1108009_P_NODE_11888_length_388_cov_0.958730_g11570_i0 PRJNA1108009 11888 388 0.95873 3.7198724 Alphapartitivirus betae 3426225 Viruses Viruses 695 0   NTclustered gi|212681415|ref|NC_011557.1| 509923 g11570 i0 98.969 2 388 4 100 0 1 388 939 552 Beet cryptic virus 1 RNA 2, complete genome blastn 776 695 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Alphapartitivirus Alphapartitivirus betae
10416089 10416089 PRJNA1108009_P_NODE_10409_length_417_cov_6.898256_g10091_i0 PRJNA1108009 10409 417 6.898256 28.76572752 Medicago sativa alphapartitivirus 1 2043550 Viruses Viruses 771 0   NTclustered gi|2751573383|gb|PP333046.1| 2043550 g10091 i0 100 27.7074340527578 417 0 100 0 1 417 1369 1785 Medicago sativa alphapartitivirus 1 isolate H48 segment RNA2, complete sequence blastn 11554 771 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Alphapartitivirus Medicago sativa alphapartitivirus 1
10416515 10416515 PRJNA1108009_P_NODE_26669_length_248_cov_1.182857_g26351_i0 PRJNA1108009 26669 248 1.182857 2.93348536 Fabavirus betaviciae 3047702 Viruses Viruses 298 2.61e-76   NTclustered gi|4704325|dbj|AB018698.1| 76875 g26351 i0 88.306 3.98790322580645 248 29 100 0 1 248 1084 1331 Broad bean wilt virus 2 gene for precursor polyprotein, complete cds, isolate: IP blastn 989 298 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
11691914 11691914 PRJNA1108009_P_NODE_390_length_1771_cov_4.045936_g282_i0 PRJNA1108009 390 1771 4.045936 71.65352656 Cheravirus ribis 3047783 Viruses Viruses 1517 0   NTclustered gi|2571475827|gb|OR096292.1| 1476584 g282 i0 82.244 1.58102766798419 1774 299 99 15 3 1768 4911 6676 Currant latent virus isolate YWDi segment 1 polyprotein gene, complete cds blastn 2800 1517 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus ribis
11692057 11692057 PRJNA1108009_P_NODE_9090_length_452_cov_1.609499_g8772_i0 PRJNA1108009 9090 452 1.609499 7.27493548 Medicago sativa alphapartitivirus 1 2043550 Viruses Viruses 835 0   NTclustered gi|2183385503|gb|OL521649.1| 2043550 g8772 i0 100 28.8606194690265 452 0 100 0 1 452 468 17 MAG: Medicago sativa alphapartitivirus 1 isolate XH1_XJ1 segment RNA2, complete sequence blastn 13045 835 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Alphapartitivirus Medicago sativa alphapartitivirus 1
12967058 12967058 PRJNA1108009_P_NODE_31731_length_241_cov_0.916667_g31413_i0 PRJNA1108009 31731 241 0.916667 2.20916747 Deltapartitivirus duobetae 3428206 Viruses Viruses 446 8.519999999999999e-121   NTclustered gi|2754350668|gb|PP987728.1| 912029 g31413 i0 100 8 241 0 100 0 1 241 526 766 Beet cryptic virus 2 isolate Kz2-01C segment dsRNA2b, partial sequence blastn 1928 446 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Deltapartitivirus Deltapartitivirus duobetae
16790002 16790002 PRJNA1108009_P_NODE_18294_length_304_cov_0.865801_g17976_i0 PRJNA1108009 18294 304 0.865801 2.63203504 Medicago sativa alphapartitivirus 2 2518124 Viruses Viruses 551 2.289999999999999e-152   NTclustered gi|2183432119|gb|OL521685.1| 2518124 g17976 i0 99.344 49.1513157894737 305 0 100 2 1 304 899 1202 MAG: Medicago sativa alphapartitivirus 2 isolate XH1_XJ1 segment RNA2 coat protein gene, complete cds blastn 14942 551 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Alphapartitivirus Medicago sativa alphapartitivirus 2
16790141 16790141 PRJNA1108009_P_NODE_234_length_2088_cov_4.511663_g159_i0 PRJNA1108009 234 2088 4.511663 94.20352344 Cheravirus ribis 3047783 Viruses Viruses 1844 0   NTclustered gi|2571475829|gb|OR096293.1| 1476584 g159 i0 82.675 2.68773946360153 2101 343 100 17 1 2088 3060 968 Currant latent virus isolate YWDi segment 2 polyprotein gene, complete cds blastn 5612 1844 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus ribis
16790363 16790363 PRJNA1108009_P_NODE_3774_length_720_cov_1.559505_g3475_i0 PRJNA1108009 3774 720 1.559505 11.228436 Cheravirus ribis 3047783 Viruses Viruses 747 0   NTclustered gi|2571475827|gb|OR096292.1| 1476584 g3475 i0 85.495 1.27777777777778 717 102 99 2 5 720 4300 3585 Currant latent virus isolate YWDi segment 1 polyprotein gene, complete cds blastn 920 747 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus ribis
19338870 19338870 PRJNA1108009_P_NODE_23556_length_259_cov_1.241935_g23238_i0 PRJNA1108009 23556 259 1.241935 3.21661165 Medicago sativa amalgavirus 1 2069326 Viruses Viruses 473 4.25e-129   NTclustered gi|1571836661|ref|NC_040591.1| 2069326 g23238 i0 99.614 29.3281853281853 259 1 100 0 1 259 2015 2273 Medicago sativa amalgavirus 1 strain MsAV1-Maverick genomic sequence blastn 7596 473 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Amalgaviridae   Medicago sativa amalgavirus 1
19339140 19339140 PRJNA1108009_P_NODE_5796_length_579_cov_2.288538_g5484_i0 PRJNA1108009 5796 579 2.288538 13.25063502 Cheravirus ribis 3047783 Viruses Viruses 409 2.9499999999999996e-109   NTclustered gi|2571475827|gb|OR096292.1| 1476584 g5484 i0 79.588 1.00690846286701 583 109 99 9 1 578 4369 4946 Currant latent virus isolate YWDi segment 1 polyprotein gene, complete cds blastn 583 409 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus ribis
23972816 23972816 PRJNA1108009_P_NODE_22319_length_269_cov_1.178571_g22001_i0 PRJNA1108009 22319 269 1.178571 3.17035599 Alphapartitivirus 1511808 Viruses Viruses 496 9.47e-136   NTclustered gi|2183385503|gb|OL521649.1| 2043550 g22001 i0 100 30.8810408921933 268 0 99 0 2 269 1379 1112 MAG: Medicago sativa alphapartitivirus 1 isolate XH1_XJ1 segment RNA2, complete sequence blastn 8307 496 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Alphapartitivirus Medicago sativa alphapartitivirus 1
25246888 25246888 PRJNA1108009_P_NODE_27720_length_247_cov_0.885057_g27402_i0 PRJNA1108009 27720 247 0.885057 2.18609079 Alphapartitivirus 1511808 Viruses Viruses 451 1.88e-122   NTclustered gi|2057220571|gb|MN872274.1| 2043550 g27402 i0 99.595 48.7085020242915 247 1 100 0 1 247 539 293 Medicago sativa alphapartitivirus 1 strain BJAc1 coat protein gene, complete cds blastn 12031 451 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Alphapartitivirus Medicago sativa alphapartitivirus 1
27447189 27447189 PRJNA1108009_P_NODE_8943_length_457_cov_1.002604_g8626_i0 PRJNA1108009 8943 457 1.002604 4.58190028 Currant latent virus 1476584 Viruses Viruses 216 2.65e-62   NR WMN13751.1 1476584 g8626 i0 81.6 0.99781181619256 152 24 97.8 3 6 452 1 151 WMN13751.1 polyprotein [Currant latent virus] diamond 456 216 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus ribis
32407335 32407335 PRJNA1108009_P_NODE_18859_length_298_cov_1.026667_g18541_i0 PRJNA1108009 18859 298 1.026667 3.05946766 Currant latent virus 1476584 Viruses Viruses 191 5.7e-54   NR WMN13750.1 1476584 g18541 i0 97 0.996644295302013 99 3 99.7 0 297 1 1009 1107 WMN13750.1 polyprotein [Currant latent virus] diamond 297 191 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus ribis

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;