RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJEB28062 · 20 ✖

analysis 1

  • blastn · 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
24846 24846 PRJEB28062_P_NODE_47181_length_522_cov_25.033408_g44836_i0 PRJEB28062 47181 522 25.033408 130.67438976 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.014   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g44836 i0 100 0.0555555555555556 29 0 6 0 1 29 15 43 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
25843 25843 PRJEB28062_P_NODE_97181_length_323_cov_5.548000_g94819_i0 PRJEB28062 97181 323 5.548 17.92004 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.03   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g94819 i0 100 0.086687306501548 28 0 9 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
2574301 2574301 PRJEB28062_P_NODE_25303_length_739_cov_9.969970_g23077_i0 PRJEB28062 25303 739 9.96997 73.6780783 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 56.5 0.006   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g23077 i0 100 0.040595399188092 30 0 4 0 710 739 87 58 Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds blastn 30 56.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Dolerus tritici iflavirus 1
5125962 5125962 PRJEB28062_P_NODE_105545_length_298_cov_11.391111_g103182_i0 PRJEB28062 105545 298 11.391111 33.94551078 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.028   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g103182 i0 100 0.0939597315436242 28 0 9 0 271 298 42 15 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
5126197 5126197 PRJEB28062_P_NODE_118105_length_265_cov_2.437500_g115742_i0 PRJEB28062 118105 265 2.4375 6.459375 Betacoronavirus pandemicum 3418604 Viruses Viruses 62.1 4.02e-5   NTclustered gi|2557408572|emb|OY646141.1| 2697049 g115742 i0 100 12.9018867924528 33 0 12 0 1 33 14037 14005 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 3419 62.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
6401903 6401903 PRJEB28062_P_NODE_118626_length_264_cov_1.471204_g116263_i0 PRJEB28062 118626 264 1.471204 3.88397856 Betacoronavirus pandemicum 3418604 Viruses Viruses 56.5 0.002   NTclustered gi|2557408572|emb|OY646141.1| 2697049 g116263 i0 100 1.28409090909091 30 0 11 0 1 30 14034 14005 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 339 56.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
7676785 7676785 PRJEB28062_P_NODE_32587_length_643_cov_128.689474_g30282_i0 PRJEB28062 32587 643 128.689474 827.47331782 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 56.5 0.005   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g30282 i0 100 0.0917573872472784 30 0 5 0 9 38 56 85 Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds blastn 59 56.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Dolerus tritici iflavirus 1
9915031 9915031 PRJEB28062_P_NODE_101448_length_310_cov_26.451477_g99085_i0 PRJEB28062 101448 310 26.451477 81.9995787 Dicistroviridae 232795 Viruses Viruses 525 1.42e-144   NTclustered gi|686029033|gb|KJ802403.1| 1541211 g99085 i0 99.652 6.25161290322581 287 1 93 0 1 287 9128 8842 Cripavirus NB-1/2011/HUN, complete genome blastn 1938 525 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus NB-1/2011/HUN
10226306 10226306 PRJEB28062_P_NODE_105769_length_298_cov_1.782222_g103406_i0 PRJEB28062 105769 298 1.782222 5.31102156 Zebrafish picornavirus 1 2304617 Viruses Viruses 444 3.91e-120   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g103406 i0 95.668 2.78859060402685 277 10 93 1 4 280 966 1240 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 831 444 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
10226652 10226652 PRJEB28062_P_NODE_124529_length_250_cov_5.915254_g122165_i0 PRJEB28062 124529 250 5.915254 14.788135 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 52.8 0.023   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g122165 i0 100 0.112 28 0 11 0 223 250 86 59 Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Dolerus tritici iflavirus 1
10227657 10227657 PRJEB28062_P_NODE_48709_length_513_cov_1.345455_g46362_i0 PRJEB28062 48709 513 1.345455 6.90218415 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 326 2.68e-84   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g46362 i0 95.146 0.401559454191033 206 10 40 0 4 209 3908 3703 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 206 326 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
11503417 11503417 PRJEB28062_P_NODE_71630_length_405_cov_21.810241_g69269_i0 PRJEB28062 71630 405 21.810241 88.33147605 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 56.5 0.003   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g69269 i0 100 0.0740740740740741 30 0 7 0 1 30 58 87 Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds blastn 30 56.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Dolerus tritici iflavirus 1
12778973 12778973 PRJEB28062_P_NODE_7471_length_1444_cov_14.619256_g6088_i0 PRJEB28062 7471 1444 14.619256 211.10205664 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1989 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g6088 i0 91.913 0.984764542936288 1422 111 98 4 24 1443 5689 7108 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 1422 1989 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
15327342 15327342 PRJEB28062_P_NODE_61613_length_445_cov_2.478495_g59253_i0 PRJEB28062 61613 445 2.478495 11.02930275 Betacoronavirus pandemicum 3418604 Viruses Viruses 58.4 0.001   NTclustered gi|2557408572|emb|OY646141.1| 2697049 g59253 i0 100 1.97078651685393 31 0 7 0 1 31 14035 14005 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 877 58.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
15327420 15327420 PRJEB28062_P_NODE_65053_length_430_cov_8.546218_g62692_i0 PRJEB28062 65053 430 8.546218 36.7487374 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.041   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g62692 i0 100 0.0651162790697674 28 0 7 0 1 28 16 43 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
17875201 17875201 PRJEB28062_P_NODE_106855_length_295_cov_1.738739_g104492_i0 PRJEB28062 106855 295 1.738739 5.12928005 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.027   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g104492 i0 100 0.0949152542372881 28 0 9 0 268 295 42 15 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
17875926 17875926 PRJEB28062_P_NODE_21575_length_806_cov_2.219645_g19444_i0 PRJEB28062 21575 806 2.219645 17.8903387 Betacoronavirus pandemicum 3418604 Viruses Viruses 62.1 1.35e-4   NTclustered gi|2557408572|emb|OY646141.1| 2697049 g19444 i0 100 3.78660049627792 33 0 4 0 774 806 14005 14037 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 3052 62.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
19150812 19150812 PRJEB28062_P_NODE_67516_length_421_cov_0.991379_g65155_i0 PRJEB28062 67516 421 0.991379 4.17370559 Betacoronavirus pandemicum 3418604 Viruses Viruses 62.1 6.74e-5   NTclustered gi|2557408572|emb|OY646141.1| 2697049 g65155 i0 100 8.12114014251781 33 0 8 0 389 421 14005 14037 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 3419 62.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
22977497 22977497 PRJEB28062_P_NODE_78639_length_381_cov_12.058442_g76277_i0 PRJEB28062 78639 381 12.058442 45.94266402 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.036   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g76277 i0 100 0.073490813648294 28 0 7 0 354 381 42 15 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
24250432 24250432 PRJEB28062_P_NODE_34600_length_624_cov_1.920145_g32284_i0 PRJEB28062 34600 624 1.920145 11.9817048 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 374 1.16e-98   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g32284 i0 90.714 0.621794871794872 280 26 62 0 27 306 5194 4915 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 388 374 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2

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