RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "blastn", bioproject = "PRJNA758087" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA758087 · 21 ✖

analysis 1

  • blastn · 21 ✖

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
4561991 4561991 PRJNA758087_P_NODE_32964_length_364_cov_10.103093_g31644_i0 PRJNA758087 32964 364 10.103093 36.77525852 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.01   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g31644 i0 100 0.244505494505494 29 0 8 0 1 29 13 41 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 89 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
7111830 7111830 PRJNA758087_P_NODE_16466_length_716_cov_79.189736_g15206_i0 PRJNA758087 16466 716 79.189736 566.99850976 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g15206 i0 100 0.0418994413407821 30 0 4 0 1 30 13 42 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 30 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
8386426 8386426 PRJNA758087_P_NODE_16767_length_706_cov_16.759874_g15504_i0 PRJNA758087 16767 706 16.759874 118.32471044 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g15504 i0 96.97 0.0878186968838527 33 1 5 0 674 706 45 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 62 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
8386819 8386819 PRJNA758087_P_NODE_30947_length_396_cov_2.879257_g29627_i0 PRJNA758087 30947 396 2.879257 11.40185772 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.038   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g29627 i0 100 0.0707070707070707 28 0 7 0 1 28 14 41 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
8386821 8386821 PRJNA758087_P_NODE_3107_length_1863_cov_92.191061_g2602_i0 PRJNA758087 3107 1863 92.191061 1717.51946643 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.015   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g2602 i0 100 0.0161030595813204 30 0 2 0 1834 1863 42 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 30 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
9661460 9661460 PRJNA758087_P_NODE_13548_length_824_cov_31.069241_g12352_i0 PRJNA758087 13548 824 31.069241 256.01054584 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.023   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g12352 i0 100 0.0351941747572816 29 0 4 0 796 824 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
9661683 9661683 PRJNA758087_P_NODE_21588_length_575_cov_15.888446_g20274_i0 PRJNA758087 21588 575 15.888446 91.3585645 Porcine bastrovirus 2588662 Viruses Viruses 58.4 0.001   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g20274 i0 100 0.0539130434782609 31 0 5 0 545 575 43 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 31 58.4 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
9661707 9661707 PRJNA758087_P_NODE_22408_length_557_cov_33.144628_g21094_i0 PRJNA758087 22408 557 33.144628 184.61557796 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.015   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g21094 i0 100 0.052064631956912 29 0 5 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
10937079 10937079 PRJNA758087_P_NODE_13469_length_827_cov_12.761273_g12275_i0 PRJNA758087 13469 827 12.761273 105.53572771 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 56.5 0.006   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g12275 i0 100 0.141475211608222 30 0 4 0 798 827 85 56 Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds blastn 117 56.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Dolerus tritici iflavirus 1
13487112 13487112 PRJNA758087_P_NODE_23871_length_525_cov_13.112832_g22552_i0 PRJNA758087 23871 525 13.112832 68.842368 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.014   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g22552 i0 100 0.0552380952380952 29 0 6 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
14762139 14762139 PRJNA758087_P_NODE_19132_length_635_cov_18.725979_g17834_i0 PRJNA758087 19132 635 18.725979 118.90996665 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.018   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g17834 i0 100 0.0456692913385827 29 0 5 0 607 635 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
17311249 17311249 PRJNA758087_P_NODE_17454_length_685_cov_11.647059_g16177_i0 PRJNA758087 17454 685 11.647059 79.78235415 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g16177 i0 100 0.0437956204379562 30 0 4 0 656 685 42 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 30 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
18584863 18584863 PRJNA758087_P_NODE_13955_length_807_cov_16.877384_g12748_i0 PRJNA758087 13955 807 16.877384 136.20048888 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.023   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g12748 i0 100 0.0359355638166047 29 0 4 0 779 807 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
18585595 18585595 PRJNA758087_P_NODE_40895_length_260_cov_4.101604_g39575_i0 PRJNA758087 40895 260 4.101604 10.6641704 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.007   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g39575 i0 100 0.219230769230769 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
19860689 19860689 PRJNA758087_P_NODE_37776_length_299_cov_2.703540_g36456_i0 PRJNA758087 37776 299 2.70354 8.0835846 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.008   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g36456 i0 96.875 0.107023411371237 32 1 11 0 1 32 14 45 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 32 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
21136090 21136090 PRJNA758087_P_NODE_32497_length_371_cov_4.580537_g31177_i0 PRJNA758087 32497 371 4.580537 16.99379227 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.01   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g31177 i0 100 0.153638814016173 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
21136258 21136258 PRJNA758087_P_NODE_39117_length_283_cov_1.952381_g37797_i0 PRJNA758087 39117 283 1.952381 5.52523823 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.007   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g37797 i0 100 0.102473498233216 29 0 10 0 255 283 42 14 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
22410580 22410580 PRJNA758087_P_NODE_20898_length_592_cov_3.728324_g19587_i0 PRJNA758087 20898 592 3.728324 22.07167808 Porcine bastrovirus 2588662 Viruses Viruses 58.4 0.001   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g19587 i0 97.143 0.116554054054054 35 0 6 1 1 35 8 41 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 69 58.4 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
22410646 22410646 PRJNA758087_P_NODE_23098_length_542_cov_10.110874_g21781_i0 PRJNA758087 23098 542 10.110874 54.80093708 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.015   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g21781 i0 100 0.0535055350553506 29 0 5 0 514 542 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
24959564 24959564 PRJNA758087_P_NODE_13640_length_820_cov_12.665328_g12442_i0 PRJNA758087 13640 820 12.665328 103.8556896 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.023   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g12442 i0 100 0.0353658536585366 29 0 4 0 792 820 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
24960304 24960304 PRJNA758087_P_NODE_41940_length_249_cov_4.312500_g40620_i0 PRJNA758087 41940 249 4.3125 10.738125 Porcine bastrovirus 2588662 Viruses Viruses 58.4 4.84e-4   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g40620 i0 100 0.124497991967871 31 0 12 0 219 249 44 14 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 31 58.4 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);;