RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA1115053", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 14 ✖

tax_phylum 1

  • Pisuviricota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1115053 · 14 ✖

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
226883 226883 PRJNA1115053_S_NODE_295181_length_162_cov_2.571429_g293364_i0 PRJNA1115053 295181 162 2.571429 4.16571498 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 239 9.64e-59   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g293364 i0 93.21 1 162 11 100 0 1 162 4595 4434 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 162 239 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
5328659 5328659 PRJNA1115053_S_NODE_238365_length_179_cov_2.169118_g236548_i0 PRJNA1115053 238365 179 2.169118 3.88272122 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.004   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g236548 i0 100 0.318435754189944 29 0 16 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
6602457 6602457 PRJNA1115053_S_NODE_182366_length_202_cov_1.207547_g180549_i0 PRJNA1115053 182366 202 1.207547 2.43924494 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g180549 i0 100 0.282178217821782 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
6605548 6605548 PRJNA1115053_S_NODE_323226_length_155_cov_2.401786_g321409_i0 PRJNA1115053 323226 155 2.401786 3.7227683 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 231 1.53e-56   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g321409 i0 94.079 0.980645161290323 152 9 98 0 4 155 2298 2147 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 152 231 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
6607302 6607302 PRJNA1115053_S_NODE_70606_length_296_cov_10.035573_g68789_i0 PRJNA1115053 70606 296 10.035573 29.70529608 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 56.5 0.002   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g68789 i0 100 0.388513513513513 30 0 10 0 267 296 85 56 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
7877251 7877251 PRJNA1115053_S_NODE_183967_length_201_cov_1.518987_g182150_i0 PRJNA1115053 183967 201 1.518987 3.05316387 Porcine bastrovirus 2588662 Viruses Viruses 58.4 3.76e-4   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g182150 i0 94.737 0.328358208955224 38 1 18 1 1 37 13 50 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 66 58.4 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
9151517 9151517 PRJNA1115053_S_NODE_157988_length_214_cov_28.146199_g156171_i0 PRJNA1115053 157988 214 28.146199 60.23286586 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g156171 i0 100 0.266355140186916 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
12982759 12982759 PRJNA1115053_S_NODE_57211_length_320_cov_11.657040_g55394_i0 PRJNA1115053 57211 320 11.65704 37.302528 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.008   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g55394 i0 100 0.178125 29 0 9 0 292 320 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
16805912 16805912 PRJNA1115053_S_NODE_52694_length_330_cov_4.066202_g50877_i0 PRJNA1115053 52694 330 4.066202 13.4184666 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.009   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g50877 i0 100 0.172727272727273 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
19350732 19350732 PRJNA1115053_S_NODE_201416_length_193_cov_1.940000_g199599_i0 PRJNA1115053 201416 193 1.94 3.7442 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g199599 i0 100 0.440414507772021 29 0 15 0 165 193 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 85 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
21899641 21899641 PRJNA1115053_S_NODE_116358_length_244_cov_1.407960_g114541_i0 PRJNA1115053 116358 244 1.40796 3.4354224 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g114541 i0 100 0.233606557377049 29 0 12 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
23180175 23180175 PRJNA1115053_S_NODE_338679_length_153_cov_0.872727_g336862_i0 PRJNA1115053 338679 153 0.872727 1.33527231 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 255 8.900000000000001e-64   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g336862 i0 96.753 1.00653594771242 154 4 100 1 1 153 2457 2304 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 154 255 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
24450364 24450364 PRJNA1115053_S_NODE_17420_length_481_cov_60.929224_g15634_i0 PRJNA1115053 17420 481 60.929224 293.06956744 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 640 7.859999999999999e-179   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g15634 i0 90.776 0.991683991683992 477 43 99 1 1 477 6633 7108 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 477 640 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
30248879 30248879 PRJNA1115053_S_NODE_100832_length_258_cov_2.455814_g99015_i0 PRJNA1115053 100832 258 2.455814 6.33600012 Viruses 10239 Viruses Viruses 73.6 6.44e-13   NR AVM87439.1 2116200 g99015 i0 48.1 1.75581395348837 79 37 87.2 1 33 257 917 995 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 453 73.9 0.995940460081191 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Wuhan sharpbelly picornavirus 1

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