RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA1249042", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 13 ✖

tax_phylum 1

  • Pisuviricota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1249042 · 13 ✖

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
2905188 2905188 PRJNA1249042_S_NODE_31883_length_238_cov_1.087179_g31669_i0 PRJNA1249042 31883 238 1.087179 2.58748602 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g31669 i0 100 0.239495798319328 29 0 12 0 210 238 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
8007551 8007551 PRJNA1249042_S_NODE_10707_length_303_cov_5.111538_g10493_i0 PRJNA1249042 10707 303 5.111538 15.48796014 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.008   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g10493 i0 100 0.188118811881188 29 0 10 0 275 303 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
13108524 13108524 PRJNA1249042_S_NODE_62051_length_196_cov_1.228758_g61837_i0 PRJNA1249042 62051 196 1.228758 2.40836568 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 75.5 5.87e-14   NR AVM87439.1 3063761 g61837 i0 60.4 0.811224489795918 53 21 81.1 0 31 189 100 152 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 159 75.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
16931889 16931889 PRJNA1249042_S_NODE_60194_length_198_cov_1.516129_g59980_i0 PRJNA1249042 60194 198 1.516129 3.00193542 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.017   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g59980 i0 100 0.141414141414141 28 0 14 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
18206267 18206267 PRJNA1249042_S_NODE_46215_length_215_cov_1.982558_g46001_i0 PRJNA1249042 46215 215 1.982558 4.2624997 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g46001 i0 100 0.265116279069767 29 0 13 0 187 215 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
18206484 18206484 PRJNA1249042_S_NODE_74535_length_183_cov_1.700000_g74321_i0 PRJNA1249042 74535 183 1.7 3.111 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.001   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g74321 i0 100 0.316939890710383 30 0 16 0 154 183 42 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 58 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
20756139 20756139 PRJNA1249042_S_NODE_54237_length_205_cov_1.358025_g54023_i0 PRJNA1249042 54237 205 1.358025 2.78395125 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g54023 i0 100 0.278048780487805 29 0 14 0 177 205 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
22031183 22031183 PRJNA1249042_S_NODE_36218_length_230_cov_2.192513_g36004_i0 PRJNA1249042 36218 230 2.192513 5.0427799 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g36004 i0 100 0.247826086956522 29 0 13 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
24580643 24580643 PRJNA1249042_S_NODE_19080_length_267_cov_2.165179_g18866_i0 PRJNA1249042 19080 267 2.165179 5.78102793 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.007   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g18866 i0 100 0.213483146067416 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
24580754 24580754 PRJNA1249042_S_NODE_30760_length_240_cov_1.441624_g30546_i0 PRJNA1249042 30760 240 1.441624 3.4598976 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g30546 i0 100 0.2375 29 0 12 0 212 240 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
24580774 24580774 PRJNA1249042_S_NODE_3320_length_488_cov_11.541573_g3111_i0 PRJNA1249042 3320 488 11.541573 56.32287624 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 647 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g3111 i0 90.852 0.985655737704918 481 42 99 1 1 481 6630 7108 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 481 647 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
24581133 24581133 PRJNA1249042_S_NODE_74840_length_183_cov_1.157143_g74626_i0 PRJNA1249042 74840 183 1.157143 2.11757169 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.004   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g74626 i0 96.875 0.327868852459016 32 1 17 0 152 183 44 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 60 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
27358296 27358296 PRJNA1249042_S_NODE_102703_length_159_cov_2.525862_g102489_i0 PRJNA1249042 102703 159 2.525862 4.01612058 Trichoderma harzianum orthocurvulavirus 1 2846570 Viruses Viruses 40.8 0.0427   NR WGH72974.1 2846570 g102489 i0 40.6 0.60377358490566 32 19 60.4 0 22 117 124 155 WGH72974.1 MAG: hypothetical protein [Trichoderma harzianum orthocurvulavirus 1] diamond 96 40.8 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Curvulaviridae Orthocurvulavirus Orthocurvulavirus trichodermae

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