RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA1105232" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 8 ✖

bioproject 1

  • PRJNA1105232 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
11691298 11691298 PRJNA1105232_S_NODE_5890_length_248_cov_3.969849_g5674_i0 PRJNA1105232 5890 248 3.969849 9.84522552 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g5674 i0 100 0.229838709677419 29 0 12 0 220 248 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
12966404 12966404 PRJNA1105232_S_NODE_12651_length_183_cov_1.014925_g12435_i0 PRJNA1105232 12651 183 1.014925 1.85731275 Zebrafish picornavirus 1 2304617 Viruses Viruses 250 5.15e-62   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g12435 i0 98.582 3.0655737704918 141 2 100 0 43 183 5635 5495 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 561 250 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
12966436 12966436 PRJNA1105232_S_NODE_2331_length_355_cov_89.588235_g2115_i0 PRJNA1105232 2331 355 89.588235 318.03823425 Betaentomopoxvirus amoorei 28321 Viruses Viruses 52.8 0.034   NTclustered gi|9964314|ref|NC_002520.1| 28321 g2115 i0 94.286 0.0985915492957746 35 1 10 1 107 140 153475 153509 Amsacta moorei entomopoxvirus 'L', complete genome blastn 35 52.8 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae Betaentomopoxvirus Betaentomopoxvirus amoorei
14241403 14241403 PRJNA1105232_S_NODE_18732_length_152_cov_3.145631_g18516_i0 PRJNA1105232 18732 152 3.145631 4.78135912 Erythrocytic necrosis virus 1543320 Viruses Viruses 121 3.36e-23   NTclustered gi|1624806695|gb|MK638714.1| 1543320 g18516 i0 92.857 46.0986842105263 84 4 54 1 2 83 242 325 Erythrocytic necrosis virus isolate SEQ_9 putative RNA-dependent DNA polymerase mRNA, complete cds blastn 7007 121 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Iridoviridae   Erythrocytic necrosis virus
18064233 18064233 PRJNA1105232_S_NODE_11655_length_189_cov_1.857143_g11439_i0 PRJNA1105232 11655 189 1.857143 3.51000027 Pestivirus bovis 3052619 Viruses Viruses 331 1.86e-86   NTclustered gi|2858850717|gb|PQ613792.1| 11099 g11439 i0 98.404 99.9259259259259 188 3 99 0 1 188 8781 8594 Bovine viral diarrhea virus 1 isolate USMARC/PI-91-21/MDBK polyprotein gene, complete cds blastn 18886 331 1 Viruses   Orthornavirae Kitrinoviricota Flasuviricetes Amarillovirales Flaviviridae Pestivirus Pestivirus bovis
19338412 19338412 PRJNA1105232_S_NODE_1576_length_410_cov_48.667590_g1361_i0 PRJNA1105232 1576 410 48.66759 199.537119 Zebrafish picornavirus 1 2304617 Viruses Viruses 712 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g1361 i0 98.049 4.26341463414634 410 7 100 1 1 410 8221 7813 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1748 712 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
24438473 24438473 PRJNA1105232_S_NODE_10260_length_199_cov_25.033333_g10044_i0 PRJNA1105232 10260 199 25.033333 49.81633267 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.005   NTclustered gi|1995060321|gb|MN450069.1| 12164 g10044 i0 100 0.728643216080402 29 0 15 0 171 199 41 13 Carnation latent virus isolate KL, complete genome blastn 145 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
24438479 24438479 PRJNA1105232_S_NODE_12320_length_185_cov_0.860294_g12104_i0 PRJNA1105232 12320 185 0.860294 1.5915439 Jujube closterovirus 1 3043313 Viruses Viruses 56.5 0.001   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g12104 i0 100 0.313513513513514 30 0 16 0 1 30 6 35 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 58 56.5 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 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);;