RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA804229" 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

  • PRJNA804229 · 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
2079776 2079776 PRJNA804229_S_NODE_36962_length_319_cov_8.101449_g36004_i0 PRJNA804229 36962 319 8.101449 25.84362231 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.008   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g36004 i0 100 0.178683385579937 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
4632489 4632489 PRJNA804229_S_NODE_38364_length_315_cov_2.029412_g37406_i0 PRJNA804229 38364 315 2.029412 6.3926478 Jujube closterovirus 1 3043313 Viruses Viruses 54.7 0.008   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g37406 i0 96.97 0.193650793650794 33 0 10 1 283 315 37 6 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 61 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
7183060 7183060 PRJNA804229_S_NODE_66906_length_248_cov_0.956098_g65948_i0 PRJNA804229 66906 248 0.956098 2.37112304 Jujube closterovirus 1 3043313 Viruses Viruses 58.4 4.82e-4   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g65948 i0 100 0.237903225806452 31 0 13 0 1 31 6 36 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 59 58.4 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
21204278 21204278 PRJNA804229_S_NODE_121497_length_185_cov_1.507042_g120539_i0 PRJNA804229 121497 185 1.507042 2.7880277 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.004   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g120539 i0 100 0.308108108108108 29 0 16 0 157 185 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
25028470 25028470 PRJNA804229_S_NODE_123200_length_184_cov_1.021277_g122242_i0 PRJNA804229 123200 184 1.021277 1.87914968 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.004   NTclustered gi|1995060321|gb|MN450069.1| 12164 g122242 i0 100 0.766304347826087 29 0 16 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

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