RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "blastn", bioproject = "PRJNA1093008" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1093008 · 32 ✖

analysis 1

  • blastn · 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
198397 198397 PRJNA1093008_S_NODE_14701_length_402_cov_22.510638_g14375_i0 PRJNA1093008 14701 402 22.510638 90.49276476 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 56.5 0.003   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g14375 i0 100 0.286069651741294 30 0 7 0 1 30 56 85 Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds blastn 115 56.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Dolerus tritici iflavirus 1
4025229 4025229 PRJNA1093008_S_NODE_46304_length_300_cov_3.392070_g45977_i0 PRJNA1093008 46304 300 3.39207 10.17621 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.002   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g45977 i0 100 0.193333333333333 30 0 10 0 271 300 42 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 58 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
4025248 4025248 PRJNA1093008_S_NODE_4884_length_548_cov_2.235789_g4571_i0 PRJNA1093008 4884 548 2.235789 12.25212372 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 534 4.389999999999999e-147   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g4571 i0 95.252 0.614963503649635 337 16 61 0 1 337 303 639 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 337 534 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
4025312 4025312 PRJNA1093008_S_NODE_57284_length_282_cov_1.842105_g56957_i0 PRJNA1093008 57284 282 1.842105 5.1947361 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.007   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g56957 i0 100 0.202127659574468 29 0 10 0 254 282 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
4025564 4025564 PRJNA1093008_S_NODE_86164_length_248_cov_0.880000_g85837_i0 PRJNA1093008 86164 248 0.88 2.1824 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.022   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g85837 i0 100 0.112903225806452 28 0 11 0 1 28 15 42 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
4025574 4025574 PRJNA1093008_S_NODE_87144_length_247_cov_1.287356_g86817_i0 PRJNA1093008 87144 247 1.287356 3.17976932 Porcine bastrovirus 2588662 Viruses Viruses 58.4 4.8e-4   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g86817 i0 100 0.238866396761134 31 0 13 0 217 247 43 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 59 58.4 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
5301495 5301495 PRJNA1093008_S_NODE_52545_length_289_cov_3.564815_g52218_i0 PRJNA1093008 52545 289 3.564815 10.30231535 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 409 1.38e-109   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g52218 i0 92.908 0.975778546712803 282 18 97 2 3 283 5857 6137 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 282 409 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
5301843 5301843 PRJNA1093008_S_NODE_9485_length_450_cov_2.580902_g9160_i0 PRJNA1093008 9485 450 2.580902 11.614059 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.012   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g9160 i0 100 0.126666666666667 29 0 6 0 422 450 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
6576571 6576571 PRJNA1093008_S_NODE_56586_length_283_cov_2.076190_g56259_i0 PRJNA1093008 56586 283 2.07619 5.8756177 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.007   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g56259 i0 100 0.201413427561837 29 0 10 0 255 283 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
7851193 7851193 PRJNA1093008_S_NODE_33267_length_329_cov_1.714844_g32940_i0 PRJNA1093008 33267 329 1.714844 5.64183676 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 514 3.29e-141   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g32940 i0 94.833 1 329 17 100 0 1 329 2488 2160 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 329 514 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
7851239 7851239 PRJNA1093008_S_NODE_38327_length_317_cov_1.577869_g38000_i0 PRJNA1093008 38327 317 1.577869 5.00184473 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.008   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g38000 i0 100 0.17981072555205 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
7851388 7851388 PRJNA1093008_S_NODE_55887_length_284_cov_2.222749_g55560_i0 PRJNA1093008 55887 284 2.222749 6.31260716 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 475 1.3099999999999999e-129   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g55560 i0 96.831 1 284 9 100 0 1 284 29 312 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 284 475 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
9126704 9126704 PRJNA1093008_S_NODE_99588_length_230_cov_2.216561_g99261_i0 PRJNA1093008 99588 230 2.216561 5.0980903 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g99261 i0 100 0.247826086956522 29 0 13 0 202 230 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
10401773 10401773 PRJNA1093008_S_NODE_26109_length_350_cov_1.667870_g25782_i0 PRJNA1093008 26109 350 1.66787 5.837545 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.009   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g25782 i0 100 0.162857142857143 29 0 8 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
11222446 11222446 PRJNA1093008_S_NODE_43689_length_305_cov_3.512931_g43362_i0 PRJNA1093008 43689 305 3.512931 10.71443955 Potyvirus 12195 Viruses Viruses 501 2.35e-137   NTclustered gi|2694382369|gb|PP255820.1| 12216 g43362 i0 98.929 92.1245901639344 280 3 92 0 1 280 9067 8788 MAG: Potato virus Y isolate N-Wi_2021-A138, partial genome blastn 28098 501 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus yituberosi
12952120 12952120 PRJNA1093008_S_NODE_10411_length_439_cov_2.590164_g10085_i0 PRJNA1093008 10411 439 2.590164 11.37081996 Betacoronavirus pandemicum 3418604 Viruses Viruses 73.1 3.26e-8   NTclustered gi|2560263575|emb|OY712376.1| 2697049 g10085 i0 95.652 9.87927107061503 46 0 10 2 10 54 5956 5912 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 4337 73.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
14227605 14227605 PRJNA1093008_S_NODE_84472_length_249_cov_1.125000_g84145_i0 PRJNA1093008 84472 249 1.125 2.80125 Betacoronavirus pandemicum 3418604 Viruses Viruses 108 4.74e-19   NTclustered gi|2165835433|emb|OV196499.1| 2697049 g84145 i0 94.366 23.136546184739 71 2 29 2 178 248 30085 30153 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 5761 108 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
15501111 15501111 PRJNA1093008_S_NODE_25193_length_353_cov_1.925000_g24866_i0 PRJNA1093008 25193 353 1.925 6.79525 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.009   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g24866 i0 100 0.161473087818697 29 0 8 0 325 353 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
15501129 15501129 PRJNA1093008_S_NODE_27593_length_345_cov_1.746324_g27266_i0 PRJNA1093008 27593 345 1.746324 6.0248178 Potyvirus yituberosi 3240642 Viruses Viruses 592 1.5599999999999996e-164   NTclustered gi|1180423536|gb|KY847971.1| 12216 g27266 i0 100 92.7536231884058 320 0 93 0 1 320 8583 8264 Potato virus Y isolate ME110032, complete genome blastn 32000 592 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus yituberosi
15501297 15501297 PRJNA1093008_S_NODE_51473_length_291_cov_2.472477_g51146_i0 PRJNA1093008 51473 291 2.472477 7.19490807 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 346 1.1e-90   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g51146 i0 91.304 0.869415807560137 253 22 87 0 37 289 5194 4942 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 253 346 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
16775441 16775441 PRJNA1093008_S_NODE_101154_length_217_cov_4.125000_g100827_i0 PRJNA1093008 101154 217 4.125 8.95125 Betacoronavirus pandemicum 3418604 Viruses Viruses 75 4.09e-9   NTclustered gi|2560515794|emb|OY700800.1| 2697049 g100827 i0 97.674 19.3271889400922 43 1 20 0 163 205 16396 16438 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 4194 75 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
16776075 16776075 PRJNA1093008_S_NODE_94934_length_241_cov_3.392857_g94607_i0 PRJNA1093008 94934 241 3.392857 8.17678537 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g94607 i0 100 0.236514522821577 29 0 12 0 213 241 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
18050559 18050559 PRJNA1093008_S_NODE_80115_length_252_cov_2.379888_g79788_i0 PRJNA1093008 80115 252 2.379888 5.99731776 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.002   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g79788 i0 100 0.23015873015873 30 0 12 0 1 30 13 42 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 58 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
19324120 19324120 PRJNA1093008_S_NODE_1516_length_814_cov_101.110661_g1287_i0 PRJNA1093008 1516 814 101.110661 823.04078054 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1146 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1287 i0 92.394 0.985257985257985 802 59 99 1 1 802 6308 7107 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 802 1146 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
19324236 19324236 PRJNA1093008_S_NODE_31096_length_335_cov_1.175573_g30769_i0 PRJNA1093008 31096 335 1.175573 3.93816955 Porcine bastrovirus 2588662 Viruses Viruses 58.4 6.79e-4   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g30769 i0 100 0.176119402985075 31 0 9 0 305 335 43 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 59 58.4 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
19324448 19324448 PRJNA1093008_S_NODE_59916_length_278_cov_2.092683_g59589_i0 PRJNA1093008 59916 278 2.092683 5.81765874 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.007   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g59589 i0 100 0.205035971223022 29 0 10 0 250 278 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
21875323 21875323 PRJNA1093008_S_NODE_31338_length_334_cov_1.873563_g31011_i0 PRJNA1093008 31338 334 1.873563 6.25770042 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.002   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g31011 i0 97.059 0.18562874251497 34 0 10 1 301 334 45 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 62 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
21875699 21875699 PRJNA1093008_S_NODE_79138_length_253_cov_3.100000_g78811_i0 PRJNA1093008 79138 253 3.1 7.843 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g78811 i0 100 0.225296442687747 29 0 11 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
24424333 24424333 PRJNA1093008_S_NODE_2080_length_728_cov_2.442748_g1820_i0 PRJNA1093008 2080 728 2.442748 17.78320544 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 575 3.499999999999999e-159   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1820 i0 93.947 0.521978021978022 380 23 52 0 1 380 3766 4145 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 380 575 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
24424663 24424663 PRJNA1093008_S_NODE_65940_length_270_cov_1.395939_g65613_i0 PRJNA1093008 65940 270 1.395939 3.7690353 Betacoronavirus pandemicum 3418604 Viruses Viruses 78.7 4.08e-10   NTclustered gi|2165836382|emb|OV196890.1| 2697049 g65613 i0 94.231 16.0222222222222 52 1 19 2 1 52 29963 29914 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 4326 78.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
24424694 24424694 PRJNA1093008_S_NODE_70060_length_264_cov_3.225131_g69733_i0 PRJNA1093008 70060 264 3.225131 8.51434584 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 54.7 0.007   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g69733 i0 96.97 0.549242424242424 33 0 13 1 232 264 87 56 Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds blastn 145 54.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Dolerus tritici iflavirus 1
24424813 24424813 PRJNA1093008_S_NODE_82800_length_250_cov_1.305085_g82473_i0 PRJNA1093008 82800 250 1.305085 3.2627125 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g82473 i0 100 0.228 29 0 12 0 222 250 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus

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