RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where bioproject = "PRJNA611476", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 32 ✖

tax_phylum 1

  • Pisuviricota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJNA611476 · 32 ✖

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
589730 589730 PRJNA611476_P_NODE_601_length_2856_cov_7.490478_g341_i0 PRJNA611476 601 2856 7.490478 213.92805168 Cheravirus mali 3047371 Viruses Viruses 2508 0   NTclustered gi|20451026|ref|NC_003788.1| 101688 g341 i0 82.653 1.89040616246499 2865 466 99 27 8 2855 3384 534 Apple latent spherical virus segment 2, complete sequence blastn 5399 2508 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali
1865011 1865011 PRJNA611476_P_NODE_13722_length_530_cov_1.439825_g12932_i0 PRJNA611476 13722 530 1.439825 7.6310725 Cheravirus avii 3047742 Viruses Viruses 372 3.52e-98   NTclustered gi|52093349|ref|NC_006271.1| 202566 g12932 i0 79.922 2.90377358490566 513 97 96 6 4 513 3093 2584 Cherry rasp leaf virus, complete genome blastn 1539 372 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus avii
3140669 3140669 PRJNA611476_P_NODE_6283_length_771_cov_3.117479_g5532_i0 PRJNA611476 6283 771 3.117479 24.03576309 Kummerowia striata picorna-like virus 2739852 Viruses Viruses 1290 0   NTclustered gi|1851269098|gb|MN832470.1| 2739852 g5532 i0 97.365 1.97665369649805 759 18 98 1 12 770 7789 7033 Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence blastn 1524 1290 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Kummerowia striata picorna-like virus
4417494 4417494 PRJNA611476_P_NODE_7504_length_708_cov_0.968504_g6735_i0 PRJNA611476 7504 708 0.968504 6.85700832 Kummerowia striata picorna-like virus 2739852 Viruses Viruses 1297 0   NTclustered gi|1851269098|gb|MN832470.1| 2739852 g6735 i0 99.718 1 708 2 100 0 1 708 4963 5670 Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence blastn 708 1297 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Kummerowia striata picorna-like virus
6967836 6967836 PRJNA611476_P_NODE_42566_length_329_cov_1.203125_g41775_i0 PRJNA611476 42566 329 1.203125 3.95828125 Cheravirus mali 3047371 Viruses Viruses 409 1.5899999999999998e-109   NTclustered gi|20451026|ref|NC_003788.1| 101688 g41775 i0 89.058 1 329 36 100 0 1 329 2566 2894 Apple latent spherical virus segment 2, complete sequence blastn 329 409 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali
6968022 6968022 PRJNA611476_P_NODE_55406_length_294_cov_1.384615_g54615_i0 PRJNA611476 55406 294 1.384615 4.0707680999999996 Kummerowia striata picorna-like virus 2739852 Viruses Viruses 492 1.36e-134   NTclustered gi|1851269098|gb|MN832470.1| 2739852 g54615 i0 96.928 0.996598639455782 293 9 99 0 2 294 3240 3532 Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence blastn 293 492 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Kummerowia striata picorna-like virus
9517267 9517267 PRJNA611476_P_NODE_110588_length_243_cov_0.905882_g109797_i0 PRJNA611476 110588 243 0.905882 2.20129326 Kummerowia striata picorna-like virus 2739852 Viruses Viruses 388 1.47e-103   NTclustered gi|1851269098|gb|MN832470.1| 2739852 g109797 i0 95.473 1 243 11 100 0 1 243 2455 2213 Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence blastn 243 388 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Kummerowia striata picorna-like virus
10793339 10793339 PRJNA611476_P_NODE_17689_length_470_cov_1.914358_g16899_i0 PRJNA611476 17689 470 1.914358 8.9974826 Picornaviridae sp. 1530251 Viruses Viruses 531 4.8099999999999985e-146   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g16899 i0 87.049 1.00212765957447 471 59 100 2 1 470 3726 3257 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 471 531 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
10793354 10793354 PRJNA611476_P_NODE_18509_length_461_cov_1.675258_g17719_i0 PRJNA611476 18509 461 1.675258 7.72293938 Kummerowia striata picorna-like virus 2739852 Viruses Viruses 802 0   NTclustered gi|1851269098|gb|MN832470.1| 2739852 g17719 i0 98.048 1 461 9 100 0 1 461 4736 4276 Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence blastn 461 802 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Kummerowia striata picorna-like virus
10793645 10793645 PRJNA611476_P_NODE_389_length_4006_cov_5.302059_g201_i0 PRJNA611476 389 4006 5.302059 212.40048354 Cheravirus mali 3047371 Viruses Viruses 3059 0   NTclustered gi|20451024|ref|NC_003787.1| 101688 g201 i0 80.51 1.48077883175237 4038 725 99 48 2 3999 2797 6812 Apple latent spherical virus segment 1, complete sequence blastn 5932 3059 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali
13343472 13343472 PRJNA611476_P_NODE_34311_length_357_cov_1.218310_g33520_i0 PRJNA611476 34311 357 1.21831 4.3493667 Kummerowia striata picorna-like virus 2739852 Viruses Viruses 627 4.4199999999999986e-175   NTclustered gi|1851269098|gb|MN832470.1| 2739852 g33520 i0 98.588 2.87675070028011 354 5 99 0 1 354 6603 6956 Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence blastn 1027 627 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Kummerowia striata picorna-like virus
14617736 14617736 PRJNA611476_P_NODE_1012_length_1980_cov_2.785527_g645_i0 PRJNA611476 1012 1980 2.785527 55.1534346 Picornaviridae sp. 1530251 Viruses Viruses 1561 0   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g645 i0 80.976 1.00353535353535 1987 362 100 15 1 1980 7739 5762 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 1987 1561 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
14618127 14618127 PRJNA611476_P_NODE_192_length_7213_cov_49.534594_g95_i0 PRJNA611476 192 7213 49.534594 3572.93026522 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2505 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g95 i0 92.036 0.651046721197837 1783 137 65 5 5426 7206 5329 7108 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 4696 2505 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
15893049 15893049 PRJNA611476_P_NODE_85713_length_249_cov_1.147727_g84922_i0 PRJNA611476 85713 249 1.147727 2.85784023 Kummerowia striata picorna-like virus 2739852 Viruses Viruses 438 1.4799999999999996e-118   NTclustered gi|1851269098|gb|MN832470.1| 2739852 g84922 i0 98.394 1 249 4 100 0 1 249 3920 4168 Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence blastn 249 438 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Kummerowia striata picorna-like virus
18441182 18441182 PRJNA611476_P_NODE_17475_length_473_cov_1.500000_g16685_i0 PRJNA611476 17475 473 1.5 7.095 Cheravirus ribis 3047783 Viruses Viruses 398 5.13e-106   NTclustered gi|2571475827|gb|OR096292.1| 1476584 g16685 i0 82.303 0.99154334038055 469 73 98 8 10 473 799 336 Currant latent virus isolate YWDi segment 1 polyprotein gene, complete cds blastn 469 398 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus ribis
18441231 18441231 PRJNA611476_P_NODE_2035_length_1381_cov_1.941131_g1522_i0 PRJNA611476 2035 1381 1.941131 26.80701911 Picornaviridae sp. 1530251 Viruses Viruses 890 1.55e-305   NR XDJ26655.1 1530251 g1522 i0 92.3 1.01882693700217 469 27 99.9 1 1380 1 1072 1540 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 1407 890 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
20991568 20991568 PRJNA611476_P_NODE_23097_length_418_cov_1.397101_g22306_i0 PRJNA611476 23097 418 1.397101 5.83988218 Apple latent spherical virus 101688 Viruses Viruses 213 6.25e-61   NR NP_620568.1 101688 g22306 i0 76.3 0.997607655502392 139 33 99.8 0 2 418 448 586 NP_620568.1 235K polyprotein [Apple latent spherical virus] diamond 417 213 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali
21549900 21549900 PRJNA611476_P_NODE_50177_length_307_cov_1.786325_g49386_i0 PRJNA611476 50177 307 1.786325 5.48401775 Cripavirus 144051 Viruses Viruses 455 1.87e-123   NTclustered gi|1847622119|gb|MN738553.1| 2739222 g49386 i0 93.464 5.8599348534202 306 20 99 0 2 307 8459 8764 Bactrocera dorsalis cripavirus, complete genome blastn 1799 457 0.99562363238512 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Bactrocera dorsalis cripavirus
23542498 23542498 PRJNA611476_P_NODE_84139_length_250_cov_0.870056_g83348_i0 PRJNA611476 84139 250 0.870056 2.17514 Potyvirus halapensis 3240535 Viruses Viruses 390 4.22e-104   NTclustered gi|2699880115|gb|PP480666.1| 31742 g83348 i0 94.821 14.016 251 12 100 1 1 250 9738 9488 Johnsongrass mosaic virus isolate Santa_Ana-2021-JgM1 polyprotein gene, complete cds blastn 3504 390 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus halapensis
24815517 24815517 PRJNA611476_P_NODE_25240_length_403_cov_1.042424_g24449_i0 PRJNA611476 25240 403 1.042424 4.20096872 Zebrafish picornavirus 1 2304617 Viruses Viruses 651 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g24449 i0 95.782 3.00496277915633 403 17 100 0 1 403 5602 5200 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1211 651 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
26649931 26649931 PRJNA611476_P_NODE_54401_length_296_cov_2.475336_g53610_i0 PRJNA611476 54401 296 2.475336 7.32699456 Zebrafish jaw picornavirus RQ13 Viruses Viruses 46.2 0.0044   NR UCS96340.1 RQ13 g53610 i0 40.8 3.31418918918919 71 40 69.9 1 13 219 1208 1278 UCS96340.1 MAG: polyprotein, partial [Picornaviridae sp.] diamond 981 46.6 0.991416309012876 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish jaw picornavirus
26668416 26668416 PRJNA611476_P_NODE_29921_length_376_cov_1.283828_g29130_i0 PRJNA611476 29921 376 1.283828 4.82719328 Currant latent virus 1476584 Viruses Viruses 71.6 1.28e-11   NR WMN13751.1 1476584 g29130 i0 42.2 0.86968085106383 109 62 87 1 329 3 17 124 WMN13751.1 polyprotein [Currant latent virus] diamond 327 71.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus ribis
27522484 27522484 PRJNA611476_P_NODE_3143_length_1110_cov_1.689489_g2537_i0 PRJNA611476 3143 1110 1.689489 18.7533279 Zebrafish jaw picornavirus RQ13 Viruses Viruses 267 3.63e-76   NR XBH24011.1 RQ13 g2537 i0 51.7 4.18648648648649 259 123 69.5 2 6 776 2127 2385 XBH24011.1 MAG: polyprotein [Coleura bat picornavirus] diamond 4647 267 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Zebrafish jaw picornavirus
27901227 27901227 PRJNA611476_P_NODE_19965_length_446_cov_1.139410_g19174_i0 PRJNA611476 19965 446 1.13941 5.0817686 Picornaviridae sp. 1530251 Viruses Viruses 276 5.57e-83   NR XDJ26655.1 1530251 g19174 i0 99.3 0.995515695067265 148 1 99.6 0 446 3 29 176 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 444 276 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28438372 28438372 PRJNA611476_P_NODE_67766_length_271_cov_1.166667_g66975_i0 PRJNA611476 67766 271 1.166667 3.16166757 Apple latent spherical virus 101688 Viruses Viruses 182 3.44e-51   NR NP_620568.1 101688 g66975 i0 95.5 1.97047970479705 89 4 98.5 0 269 3 1447 1535 NP_620568.1 235K polyprotein [Apple latent spherical virus] diamond 534 182 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali
28722495 28722495 PRJNA611476_P_NODE_54827_length_295_cov_1.734234_g54036_i0 PRJNA611476 54827 295 1.734234 5.1159903 Apple latent spherical virus 101688 Viruses Viruses 183 3.69e-51   NR NP_620568.1 101688 g54036 i0 90.8 1.99322033898305 98 9 99.7 0 1 294 1975 2072 NP_620568.1 235K polyprotein [Apple latent spherical virus] diamond 588 183 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali
29258883 29258883 PRJNA611476_P_NODE_39569_length_338_cov_1.490566_g38778_i0 PRJNA611476 39569 338 1.490566 5.03811308 Picornaviridae sp. 1530251 Viruses Viruses 209 4.56e-60   NR XDJ26655.1 1530251 g38778 i0 87.5 0.994082840236686 112 14 99.4 0 337 2 1530 1641 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 336 209 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
29985441 29985441 PRJNA611476_P_NODE_26771_length_393_cov_1.968750_g25980_i0 PRJNA611476 26771 393 1.96875 7.7371875 Apple latent spherical virus 101688 Viruses Viruses 204 4.26e-58   NR NP_620569.1 101688 g25980 i0 96 2.26717557251908 99 4 75.6 0 1 297 863 961 NP_620569.1 108K polyprotein [Apple latent spherical virus] diamond 891 204 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali
30396618 30396618 PRJNA611476_P_NODE_47573_length_314_cov_2.182573_g46782_i0 PRJNA611476 47573 314 2.182573 6.85327922 Zebrafish jaw picornavirus RQ13 Viruses Viruses 63.9 3.25e-9   NR YP_009552756.1 RQ13 g46782 i0 40.7 3.14331210191083 108 59 99.4 3 1 312 1713 1819 YP_009552756.1 polyprotein [Rhimavirus A] diamond 987 63.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish jaw picornavirus
31154061 31154061 PRJNA611476_P_NODE_41075_length_333_cov_2.026923_g40284_i0 PRJNA611476 41075 333 2.026923 6.74965359 Picornaviridae sp. 1530251 Viruses Viruses 216 1.21e-62   NR XDJ26655.1 1530251 g40284 i0 93.7 1 111 7 100 0 1 333 620 730 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 333 216 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
31280814 31280814 PRJNA611476_P_NODE_24795_length_406_cov_1.228228_g24004_i0 PRJNA611476 24795 406 1.228228 4.98660568 Picornaviridae sp. 1530251 Viruses Viruses 278 1.28e-83   NR XDJ26655.1 1530251 g24004 i0 97 0.997536945812808 135 4 99.8 0 405 1 358 492 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 405 278 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
32798086 32798086 PRJNA611476_P_NODE_51820_length_303_cov_1.339130_g51029_i0 PRJNA611476 51820 303 1.33913 4.0575639 Apple latent spherical virus 101688 Viruses Viruses 193 9.229999999999998e-55   NR NP_620568.1 101688 g51029 i0 91.9 1.96039603960396 99 8 98 0 2 298 1831 1929 NP_620568.1 235K polyprotein [Apple latent spherical virus] diamond 594 193 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali

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