RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1004255" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 5 ✖

bioproject 1

  • PRJNA1004255 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
153281 153281 PRJNA1004255_S_NODE_401_length_642_cov_14.053422_g225_i0 PRJNA1004255 401 642 14.053422 90.22296924 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.018   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g225 i0 100 0.0451713395638629 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
153311 153311 PRJNA1004255_S_NODE_9241_length_208_cov_1.709091_g9033_i0 PRJNA1004255 9241 208 1.709091 3.55490928 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.005   NTclustered gi|1995060321|gb|MN450069.1| 12164 g9033 i0 100 0.677884615384615 29 0 14 0 1 29 13 41 Carnation latent virus isolate KL, complete genome blastn 141 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
5256204 5256204 PRJNA1004255_S_NODE_8725_length_213_cov_2.211765_g8517_i0 PRJNA1004255 8725 213 2.211765 4.71105945 Erysiphe necator associated deltaflexivirus 4 2743097 Viruses Viruses 394 2.7e-105   NTclustered gi|2288523299|gb|ON811606.1| 2743097 g8517 i0 100 4.92488262910798 213 0 100 0 1 213 7030 6818 MAG: Erysiphe necator associated deltaflexivirus 4 isolate TIGMIC_2, complete genome blastn 1049 394 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Deltaflexiviridae Deltaflexivirus Erysiphe necator associated deltaflexivirus 4
19278849 19278849 PRJNA1004255_S_NODE_6856_length_234_cov_2.345550_g6648_i0 PRJNA1004255 6856 234 2.34555 5.488587 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g6648 i0 100 0.243589743589744 29 0 12 0 206 234 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
23105538 23105538 PRJNA1004255_S_NODE_9379_length_206_cov_10.000000_g9171_i0 PRJNA1004255 9379 206 10 20.6 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g9171 i0 100 0.276699029126214 29 0 14 0 178 206 41 13 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);;