RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA681822", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 20 ✖

tax_kingdom 1

  • Orthornavirae · 20 ✖

bioproject 1

  • PRJNA681822 · 20 ✖

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
1927823 1927823 PRJNA681822_P_NODE_127562_length_361_cov_0.913194_g126075_i0 PRJNA681822 127562 361 0.913194 3.29663034 Nilaparvata lugens C virus 1577072 Viruses Viruses 662 0   NTclustered gi|726973360|gb|KM270560.1| 1577072 g126075 i0 99.723 1 361 1 100 0 1 361 8256 7896 Nilaparvata lugens C virus, complete genome blastn 361 662 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Nilaparvata lugens C virus
1932139 1932139 PRJNA681822_P_NODE_465022_length_243_cov_0.905882_g463532_i0 PRJNA681822 465022 243 0.905882 2.20129326 Spinach deltapartitivirus 1 1985163 Viruses Viruses 388 1.47e-103   NTclustered gi|1189442711|gb|KY695010.1| 1985163 g463532 i0 99.074 0.888888888888889 216 2 89 0 28 243 202 417 Spinach deltapartitivirus 1 isolate SRP059420 segment RNA2 coat protein gene, complete cds blastn 216 388 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Deltapartitivirus Spinach deltapartitivirus 1
1933373 1933373 PRJNA681822_P_NODE_9042_length_1264_cov_2.965575_g8178_i0 PRJNA681822 9042 1264 2.965575 37.484868 Zebrafish picornavirus 1 2304617 Viruses Viruses 2106 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g8178 i0 96.97 2.99604430379747 1254 38 99 0 2 1255 6558 7811 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 3787 2106 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
3206850 3206850 PRJNA681822_P_NODE_462783_length_243_cov_0.905882_g461293_i0 PRJNA681822 462783 243 0.905882 2.20129326 Senecavirus valles 3241303 Viruses Viruses 438 1.4399999999999996e-118   NTclustered gi|1776925995|gb|MN233020.1| 390157 g461293 i0 99.177 99.0123456790123 243 2 100 0 1 243 3306 3064 Senecavirus A isolate USA/SC05-363649/2005, complete genome blastn 24060 438 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Senecavirus Senecavirus valles
4484289 4484289 PRJNA681822_P_NODE_481864_length_241_cov_0.916667_g480374_i0 PRJNA681822 481864 241 0.916667 2.20916747 Potyvirus nicotianavenaobscurum 3240570 Viruses Viruses 446 8.519999999999999e-121   NTclustered gi|397711625|gb|JN630469.1| 33765 g480374 i0 100 42.3692946058091 241 0 100 0 1 241 8432 8192 Tobacco vein banding mosaic virus isolate PY, complete genome blastn 10211 446 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus nicotianavenaobscurum
10856031 10856031 PRJNA681822_P_NODE_142269_length_348_cov_0.905455_g140781_i0 PRJNA681822 142269 348 0.905455 3.1509834 Nilaparvata lugens C virus 1577072 Viruses Viruses 643 4.279999999999998e-180   NTclustered gi|726973360|gb|KM270560.1| 1577072 g140781 i0 100 2 348 0 100 0 1 348 7255 6908 Nilaparvata lugens C virus, complete genome blastn 696 643 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Nilaparvata lugens C virus
10857312 10857312 PRJNA681822_P_NODE_23509_length_783_cov_1.778873_g22231_i0 PRJNA681822 23509 783 1.778873 13.92857559 Spinach cryptic virus 1 1937817 Viruses Viruses 1400 0   NTclustered gi|1134667074|gb|KX784757.1| 1937817 g22231 i0 98.977 4.57343550446999 782 8 99 0 2 783 786 5 Spinach cryptic virus 1 isolate SRR1766329 coat protein (CP) gene, complete cds blastn 3581 1400 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Spinach cryptic virus 1
12133519 12133519 PRJNA681822_P_NODE_30850_length_679_cov_2.430693_g29477_i0 PRJNA681822 30850 679 2.430693 16.50440547 Zebrafish picornavirus 1 2304617 Viruses Viruses 979 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g29477 i0 92.669 3.01325478645066 682 47 100 3 1 679 3232 2551 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 2046 979 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
12136933 12136933 PRJNA681822_S_NODE_1710_length_164_cov_2.444444_g1685_i0 PRJNA681822 1710 164 2.444444 4.00888816 Zebrafish picornavirus 1 2304617 Viruses Viruses 292 7.41e-75   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g1685 i0 98.78 3 164 2 100 0 1 164 7604 7767 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 492 292 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
18504664 18504664 PRJNA681822_P_NODE_173535_length_325_cov_0.976190_g172047_i0 PRJNA681822 173535 325 0.97619 3.1726175 Spinach cryptic virus 1 1937817 Viruses Viruses 590 5.2299999999999986e-164   NTclustered gi|1147809908|ref|NC_033771.1| 1937817 g172047 i0 99.385 2.13538461538462 325 2 100 0 1 325 983 1307 Spinach cryptic virus 1 isolate SRR1766311 coat protein (CP) gene, complete cds blastn 694 590 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Spinach cryptic virus 1
18505152 18505152 PRJNA681822_P_NODE_20455_length_841_cov_2.839844_g19245_i0 PRJNA681822 20455 841 2.839844 23.88308804 Zebrafish picornavirus 1 2304617 Viruses Viruses 1445 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g19245 i0 97.741 2.94649227110583 841 15 100 4 1 841 871 35 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 2478 1445 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
18505404 18505404 PRJNA681822_P_NODE_2235_length_2508_cov_3.203696_g1849_i0 PRJNA681822 2235 2508 3.203696 80.34869568 Zebrafish picornavirus 1 2304617 Viruses Viruses 4056 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g1849 i0 95.853 3.00039872408293 2508 104 100 0 1 2508 3987 6494 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 7525 4056 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
18508495 18508495 PRJNA681822_P_NODE_491315_length_229_cov_2.884615_g489825_i0 PRJNA681822 491315 229 2.884615 6.60576835 Fabavirus betaviciae 3047702 Viruses Viruses 340 3.89e-89   NTclustered gi|2235068824|gb|MW192525.1| 76875 g489825 i0 93.45 54.9563318777293 229 15 100 0 1 229 866 1094 Broad bean wilt virus 2 isolate GX2 polyprotein gene, partial cds blastn 12585 340 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus betaviciae
19782416 19782416 PRJNA681822_P_NODE_418356_length_247_cov_3.097701_g416867_i0 PRJNA681822 418356 247 3.097701 7.65132147 Zebrafish picornavirus 1 2304617 Viruses Viruses 407 4.14e-109   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g416867 i0 96.356 3 247 9 100 0 1 247 4791 4545 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 741 407 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
22328943 22328943 PRJNA681822_P_NODE_116758_length_371_cov_2.187919_g115272_i0 PRJNA681822 116758 371 2.187919 8.11717949 Zebrafish picornavirus 1 2304617 Viruses Viruses 619 7.709999999999999e-173   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g115272 i0 96.765 3 371 12 100 0 1 371 1187 817 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1113 619 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23610336 23610336 PRJNA681822_P_NODE_92939_length_402_cov_2.054711_g91457_i0 PRJNA681822 92939 402 2.054711 8.25993822 Zebrafish picornavirus 1 2304617 Viruses Viruses 699 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g91457 i0 98.01 4.06965174129353 402 8 100 0 1 402 7796 8197 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1636 699 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
24882972 24882972 PRJNA681822_P_NODE_6280_length_1508_cov_2.729617_g5579_i0 PRJNA681822 6280 1508 2.729617 41.16262436 Zebrafish picornavirus 1 2304617 Viruses Viruses 2377 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g5579 i0 95.153 2.9973474801061 1506 73 99 0 1 1506 1269 2774 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 4520 2377 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
29765951 29765951 PRJNA681822_P_NODE_130571_length_358_cov_1.210526_g129084_i0 PRJNA681822 130571 358 1.210526 4.33368308 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 80.5 8.18e-15   NR XCM68108.1 3003959 g129084 i0 43 0.720670391061452 86 49 72.1 0 260 3 60 145 XCM68108.1 MAG: structural polyprotein [Picornavirales sp.] diamond 258 80.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30998342 30998342 PRJNA681822_P_NODE_395354_length_250_cov_0.870056_g393865_i0 PRJNA681822 395354 250 0.870056 2.17514 Taiwan douglas-fir deltapartitivirus 2933092 Viruses Viruses 105 2.2799999999999998e-24   NR CAI5384001.1 2933092 g393865 i0 61.4 0.996 83 31 99.6 1 2 250 114 195 CAI5384001.1 RNA-dependent RNA polymerase [Taiwan douglas-fir deltapartitivirus] diamond 249 105 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Deltapartitivirus Taiwan douglas-fir deltapartitivirus
32389945 32389945 PRJNA681822_P_NODE_342859_length_262_cov_2.169312_g341370_i0 PRJNA681822 342859 262 2.169312 5.68359744 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 156 4.02e-42   NR XCM68434.1 3003959 g341370 i0 80 0.973282442748092 85 17 97.3 0 260 6 594 678 XCM68434.1 MAG: structural polyprotein [Picornavirales sp.] diamond 255 156 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3

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