RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB11523", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 6 ✖

tax_phylum 1

  • Pisuviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB11523 · 6 ✖

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
13724 13724 PRJEB11523_P_NODE_2801_length_304_cov_2.423529_g2723_i0 PRJEB11523 2801 304 2.423529 7.36752816 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.028   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g2723 i0 100 0.0921052631578947 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
5116112 5116112 PRJEB11523_P_NODE_2205_length_361_cov_9.769231_g2127_i0 PRJEB11523 2205 361 9.769231 35.26692391 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 56.5 0.003   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g2127 i0 100 0.0831024930747922 30 0 8 0 332 361 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
10216518 10216518 PRJEB11523_P_NODE_4389_length_226_cov_16.361582_g4311_i0 PRJEB11523 4389 226 16.361582 36.97717532 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g4311 i0 100 0.252212389380531 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
19139240 19139240 PRJEB11523_P_NODE_3016_length_289_cov_12.129167_g2938_i0 PRJEB11523 3016 289 12.129167 35.05329263 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.007   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g2938 i0 100 0.750865051903114 29 0 10 0 1 29 13 41 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 217 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
20414348 20414348 PRJEB11523_P_NODE_2337_length_346_cov_10.545455_g2259_i0 PRJEB11523 2337 346 10.545455 36.4872743 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.009   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g2259 i0 100 0.164739884393064 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
29811509 29811509 PRJEB11523_P_NODE_11_length_2927_cov_66.628909_g10_i0 PRJEB11523 11 2927 66.628909 1950.22816643 Leptinotarsa iflavirus 1 3079816 Viruses Viruses 693 7.83e-216   NR WNV56445.1 3079816 g10 i0 46.5 0.785104202254868 766 393 77.6 9 440 2710 2291 3048 WNV56445.1 MAG: polyprotein [Leptinotarsa iflavirus 1] diamond 2298 693 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Leptinotarsa iflavirus 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);;