RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJNA1011833" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1011833 · 18 ✖

analysis 1

  • blastn · 18 ✖

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
155373 155373 PRJNA1011833_S_NODE_24261_length_242_cov_1.849246_g23841_i0 PRJNA1011833 24261 242 1.849246 4.47517532 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 414 2.41e-111   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g23841 i0 97.521 1 242 6 100 0 1 242 5510 5751 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 242 414 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
155534 155534 PRJNA1011833_S_NODE_5321_length_458_cov_2.515663_g4910_i0 PRJNA1011833 5321 458 2.515663 11.52173654 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 745 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g4910 i0 97.477 0.951965065502183 436 11 95 0 23 458 4195 4630 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 436 745 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
2705533 2705533 PRJNA1011833_S_NODE_12423_length_339_cov_3.648649_g12003_i0 PRJNA1011833 12423 339 3.648649 12.36892011 Betahypovirus sinensis 2955462 Viruses Viruses 555 1.9999999999999993e-153   NTclustered gi|1567442288|gb|MH347277.1| 2219105 g12003 i0 96.165 6 339 13 100 0 1 339 10130 9792 Botrytis cinerea hypovirus 1 strain BcHv1.HBstr-470, complete genome blastn 2034 555 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Hypoviridae Betahypovirus Betahypovirus sinensis
3982003 3982003 PRJNA1011833_S_NODE_6964_length_420_cov_11.673740_g6548_i0 PRJNA1011833 6964 420 11.67374 49.029708 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 60.2 2.42e-4   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g6548 i0 100 0.278571428571429 32 0 8 0 1 32 56 87 Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds blastn 117 60.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Dolerus tritici iflavirus 1
5258202 5258202 PRJNA1011833_S_NODE_13945_length_322_cov_3.440860_g13525_i0 PRJNA1011833 13945 322 3.44086 11.0795692 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.008   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g13525 i0 100 0.177018633540373 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
7807917 7807917 PRJNA1011833_S_NODE_23967_length_244_cov_1.338308_g23547_i0 PRJNA1011833 23967 244 1.338308 3.26547152 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 396 8.829999999999997e-106   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g23547 i0 95.902 1 244 10 100 0 1 244 6250 6493 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 244 396 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
10358435 10358435 PRJNA1011833_S_NODE_19269_length_275_cov_2.896552_g18849_i0 PRJNA1011833 19269 275 2.896552 7.965518 Enterovirus geswini 3428509 Viruses Viruses 442 1.2799999999999994e-119   NTclustered gi|2513212778|gb|ON964506.1| 106966 g18849 i0 95.636 98.8690909090909 275 12 100 0 1 275 7926 7652 Enterovirus G isolate CH/HLJ-141/G1PLCP, complete genome blastn 27189 442 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Enterovirus Enterovirus geswini
11634055 11634055 PRJNA1011833_S_NODE_430_length_1301_cov_23.370429_g318_i0 PRJNA1011833 430 1301 23.370429 304.04928129 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 56.5 0.01   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g318 i0 100 0.0453497309761722 30 0 2 0 1 30 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
11634164 11634164 PRJNA1011833_S_NODE_8310_length_396_cov_1.929178_g7893_i0 PRJNA1011833 8310 396 1.929178 7.63954488 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 243 2.1e-59   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g7893 i0 93.827 0.409090909090909 162 8 41 2 236 396 5329 5489 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 162 243 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
12909224 12909224 PRJNA1011833_S_NODE_6531_length_429_cov_12.015544_g6115_i0 PRJNA1011833 6531 429 12.015544 51.54668376 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.012   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g6115 i0 100 0.132867132867133 29 0 7 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
14184057 14184057 PRJNA1011833_S_NODE_39192_length_186_cov_1.342657_g38772_i0 PRJNA1011833 39192 186 1.342657 2.49734202 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.016   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g38772 i0 100 0.150537634408602 28 0 15 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
15458140 15458140 PRJNA1011833_S_NODE_55533_length_154_cov_2.675676_g55113_i0 PRJNA1011833 55533 154 2.675676 4.12054104 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 248 1.5e-61   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g55113 i0 96.053 0.987012987012987 152 6 99 0 3 154 6124 6275 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 152 248 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
16732350 16732350 PRJNA1011833_S_NODE_36674_length_193_cov_0.960000_g36254_i0 PRJNA1011833 36674 193 0.96 1.8528 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.017   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g36254 i0 100 0.145077720207254 28 0 15 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
19280850 19280850 PRJNA1011833_S_NODE_2096_length_620_cov_125.000000_g1744_i0 PRJNA1011833 2096 620 125 775 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1002 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1744 i0 95.942 0.993548387096774 616 24 99 1 1 616 6494 7108 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 616 1002 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
20556614 20556614 PRJNA1011833_S_NODE_3937_length_503_cov_2.080435_g3537_i0 PRJNA1011833 3937 503 2.080435 10.46458805 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 494 6.8e-135   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g3537 i0 95.752 0.821073558648111 306 13 82 0 1 306 2405 2100 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 413 494 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
21832373 21832373 PRJNA1011833_S_NODE_9398_length_379_cov_2.032738_g8980_i0 PRJNA1011833 9398 379 2.032738 7.70407702 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 226 2.0099999999999998e-54   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g8980 i0 95.714 0.369393139841689 140 6 37 0 1 140 2409 2548 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 140 226 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
23107724 23107724 PRJNA1011833_S_NODE_3379_length_528_cov_2.529897_g2988_i0 PRJNA1011833 3379 528 2.529897 13.35785616 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 915 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g2988 i0 97.917 1 528 11 100 0 1 528 537 10 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 528 915 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
24381454 24381454 PRJNA1011833_S_NODE_35060_length_197_cov_2.902597_g34640_i0 PRJNA1011833 35060 197 2.902597 5.71811609 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g34640 i0 100 0.289340101522843 29 0 15 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

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