RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where bioproject = "PRJNA870096", 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 · 25 ✖

tax_kingdom 1

  • Orthornavirae · 25 ✖

bioproject 1

  • PRJNA870096 · 25 ✖

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
2125512 2125512 PRJNA870096_S_NODE_47702_length_255_cov_4.533019_g46038_i0 PRJNA870096 47702 255 4.533019 11.55919845 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 422 1.53e-113   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g46038 i0 96.471 1 255 9 100 0 1 255 5770 5516 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 255 422 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
3400591 3400591 PRJNA870096_S_NODE_14863_length_474_cov_30.716937_g13225_i0 PRJNA870096 14863 474 30.716937 145.59828138 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.013   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g13225 i0 100 0.120253164556962 29 0 6 0 1 29 13 41 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
5953757 5953757 PRJNA870096_S_NODE_69205_length_210_cov_3.502994_g67541_i0 PRJNA870096 69205 210 3.502994 7.3562874 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g67541 i0 100 0.271428571428571 29 0 14 0 1 29 13 41 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
7228638 7228638 PRJNA870096_S_NODE_72746_length_205_cov_2.197531_g71082_i0 PRJNA870096 72746 205 2.197531 4.50493855 Porcine bastrovirus 2588662 Viruses Viruses 58.4 3.85e-4   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g71082 i0 94.737 0.458536585365854 38 0 18 2 1 37 13 49 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 94 58.4 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
9777876 9777876 PRJNA870096_S_NODE_28308_length_337_cov_3.581633_g26644_i0 PRJNA870096 28308 337 3.581633 12.07010321 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.009   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g26644 i0 100 0.169139465875371 29 0 9 0 1 29 13 41 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
11053900 11053900 PRJNA870096_S_NODE_5229_length_816_cov_171.078913_g4060_i0 PRJNA870096 5229 816 171.078913 1396.00393008 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1347 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g4060 i0 96.552 0.995098039215686 812 27 99 1 1 812 6298 7108 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 812 1347 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
12328558 12328558 PRJNA870096_S_NODE_116270_length_165_cov_1.180328_g114606_i0 PRJNA870096 116270 165 1.180328 1.9475412 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 289 9.66e-74   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g114606 i0 98.182 1 165 3 100 0 1 165 3984 3820 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 165 289 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
12329156 12329156 PRJNA870096_S_NODE_34590_length_303_cov_9.573077_g32926_i0 PRJNA870096 34590 303 9.573077 29.00642331 Porcine bastrovirus 2588662 Viruses Viruses 60.2 1.69e-4   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g32926 i0 100 0.198019801980198 32 0 11 0 272 303 44 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 60 60.2 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
12329738 12329738 PRJNA870096_S_NODE_84510_length_191_cov_1.560811_g82846_i0 PRJNA870096 84510 191 1.560811 2.98114901 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 315 1.9e-81   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g82846 i0 97.297 0.968586387434555 185 5 97 0 7 191 497 313 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 185 315 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
13603522 13603522 PRJNA870096_S_NODE_16351_length_452_cov_1.577017_g14706_i0 PRJNA870096 16351 452 1.577017 7.12811684 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 516 1.29e-141   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g14706 i0 95.912 0.787610619469027 318 13 79 0 38 355 2417 2100 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 356 516 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
14877532 14877532 PRJNA870096_S_NODE_124712_length_159_cov_3.310345_g123048_i0 PRJNA870096 124712 159 3.310345 5.26344855 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 289 9.22e-74   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g123048 i0 99.371 1 159 1 100 0 1 159 97 255 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 159 289 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
16153350 16153350 PRJNA870096_S_NODE_87873_length_187_cov_4.756944_g86209_i0 PRJNA870096 87873 187 4.756944 8.89548528 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.004   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g86209 i0 100 0.374331550802139 29 0 16 0 159 187 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 70 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
17428433 17428433 PRJNA870096_S_NODE_53254_length_241_cov_1.454545_g51590_i0 PRJNA870096 53254 241 1.454545 3.50545345 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 156 1.6100000000000002e-33   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g51590 i0 93.396 0.439834024896266 106 6 44 1 136 241 5329 5433 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 106 156 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
17428620 17428620 PRJNA870096_S_NODE_67974_length_212_cov_5.662722_g66310_i0 PRJNA870096 67974 212 5.662722 12.00497064 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g66310 i0 100 0.268867924528302 29 0 14 0 184 212 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
18701761 18701761 PRJNA870096_S_NODE_61535_length_223_cov_2.494444_g59871_i0 PRJNA870096 61535 223 2.494444 5.56261012 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 327 2.94e-85   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g59871 i0 96.465 0.887892376681614 198 7 89 0 26 223 4205 4402 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 198 327 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
19976375 19976375 PRJNA870096_S_NODE_14476_length_481_cov_5.977169_g12840_i0 PRJNA870096 14476 481 5.977169 28.75018289 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.013   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g12840 i0 100 0.118503118503119 29 0 6 0 453 481 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
19976505 19976505 PRJNA870096_S_NODE_2476_length_1169_cov_6.719361_g1779_i0 PRJNA870096 2476 1169 6.719361 78.54933009 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.033   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g1779 i0 100 0.0248075278015398 29 0 2 0 1 29 13 41 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
21251413 21251413 PRJNA870096_S_NODE_103337_length_174_cov_1.343511_g101673_i0 PRJNA870096 103337 174 1.343511 2.33770914 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 248 1.7399999999999998e-61   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g101673 i0 96.644 0.85632183908046 149 5 86 0 1 149 1560 1708 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 149 248 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
25076220 25076220 PRJNA870096_S_NODE_45520_length_262_cov_1.757991_g43856_i0 PRJNA870096 45520 262 1.757991 4.60593642 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.007   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g43856 i0 96.97 0.232824427480916 33 0 12 1 1 32 13 45 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 61 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
25076744 25076744 PRJNA870096_S_NODE_8700_length_628_cov_9.844444_g7204_i0 PRJNA870096 8700 628 9.844444 61.82310832 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g7204 i0 100 0.0477707006369427 30 0 5 0 599 628 42 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 30 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
28926431 28926431 PRJNA870096_S_NODE_91748_length_184_cov_1.021277_g90084_i0 PRJNA870096 91748 184 1.021277 1.87914968 Zebrafish jaw picornavirus RQ13 Viruses Viruses 43.5 0.00391   NR NP_859022.1 RQ13 g90084 i0 36.4 3.45652173913043 55 34 89.7 1 183 19 51 104 NP_859022.1 2A [Kobuvirus bejaponia] diamond 636 43.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Kobuvirus Zebrafish jaw picornavirus
29360484 29360484 PRJNA870096_S_NODE_137529_length_153_cov_0.872727_g135865_i0 PRJNA870096 137529 153 0.872727 1.33527231 Zebrafish jaw picornavirus RQ13 Viruses Viruses 61.2 3.33e-9   NR WAB24476.1 RQ13 g135865 i0 60 0.980392156862745 50 20 98 0 1 150 2561 2610 WAB24476.1 polyprotein [Avian megrivirus] diamond 150 61.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Megrivirus Zebrafish jaw picornavirus
29936976 29936976 PRJNA870096_S_NODE_35491_length_299_cov_3.023438_g33827_i0 PRJNA870096 35491 299 3.023438 9.04007962 Zebrafish jaw picornavirus RQ13 Viruses Viruses 74.3 6.01e-13   NR QJX58422.1 RQ13 g33827 i0 44.3 4.69565217391304 97 52 95.3 2 299 15 2256 2352 QJX58422.1 polyprotein [Salivirus A] diamond 1404 74.7 0.994645247657296 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Salivirus Zebrafish jaw picornavirus
31414069 31414069 PRJNA870096_S_NODE_64036_length_219_cov_1.363636_g62372_i0 PRJNA870096 64036 219 1.363636 2.98636284 Zebrafish jaw picornavirus RQ13 Viruses Viruses 52 1.56e-5   NR QMI57975.1 RQ13 g62372 i0 52.3 2.83561643835616 44 21 60.3 0 85 216 1029 1072 QMI57975.1 polyprotein, partial [Pacific black duck sicinivirus-like virus] diamond 621 52 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Sicinivirus Zebrafish jaw picornavirus
32300181 32300181 PRJNA870096_S_NODE_55079_length_237_cov_0.953608_g53415_i0 PRJNA870096 55079 237 0.953608 2.26005096 Zebrafish jaw picornavirus RQ13 Viruses Viruses 104 2.33e-24   NR ADI48258.1 RQ13 g53415 i0 57.1 0.974683544303797 77 32 97.5 1 2 232 121 196 ADI48258.1 3D, partial [Bat kobuvirus TM003k] diamond 231 104 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Kobuvirus Zebrafish jaw picornavirus

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