RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA782235" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 10 ✖

bioproject 1

  • PRJNA782235 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
5867019 5867019 PRJNA782235_P_NODE_9865_length_290_cov_1.419355_g9676_i0 PRJNA782235 9865 290 1.419355 4.1161295 Tobamovirus tabaci 3432891 Viruses Viruses 481 2.89e-131   NTclustered gi|1590853296|gb|MH595920.1| 12242 g9676 i0 96.552 99.9827586206897 290 10 100 0 1 290 3001 2712 Tobacco mosaic virus isolate Harbin-2, complete genome blastn 28995 481 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tabaci
9691874 9691874 PRJNA782235_P_NODE_2868_length_546_cov_1.435518_g2683_i0 PRJNA782235 2868 546 1.435518 7.83792828 Zebrafish picornavirus 1 2304617 Viruses Viruses 920 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g2683 i0 97.07 3 546 16 100 0 1 546 7491 8036 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 1638 920 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
13517143 13517143 PRJNA782235_P_NODE_20971_length_247_cov_0.885057_g20782_i0 PRJNA782235 20971 247 0.885057 2.18609079 Zebrafish picornavirus 1 2304617 Viruses Viruses 368 1.95e-97   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g20782 i0 93.522 3 247 16 100 0 1 247 2849 2603 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 741 368 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
13517289 13517289 PRJNA782235_P_NODE_6291_length_353_cov_0.696429_g6102_i0 PRJNA782235 6291 353 0.696429 2.45839437 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 254 8.52e-63   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g6102 i0 95.031 0.456090651558074 161 8 46 0 1 161 5034 5194 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 161 254 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
14791866 14791866 PRJNA782235_P_NODE_15592_length_254_cov_1.701657_g15403_i0 PRJNA782235 15592 254 1.701657 4.32220878 Betascleroulivirus lambdaplasmoparae 2955486 Viruses Viruses 425 1.18e-114   NTclustered gi|2500381338|ref|NC_076781.1| 2686522 g15403 i0 96.85 3.99212598425197 254 8 100 0 1 254 601 348 Plasmopara viticola lesion associated ourmia-like virus 51 isolate DMG-A_34547 RNA dependent RNA polymerase (QKR56_gp1) gene, complete cds blastn 1014 425 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Betascleroulivirus Betascleroulivirus lambdaplasmoparae
18614952 18614952 PRJNA782235_P_NODE_19995_length_248_cov_0.880000_g19806_i0 PRJNA782235 19995 248 0.88 2.1824 Dicistroviridae sp. 1955144 Viruses Viruses 374 4.2099999999999995e-99   NTclustered gi|2756423066|gb|PP745340.1| 1955144 g19806 i0 93.927 26.6854838709677 247 15 99 0 2 248 2228 1982 MAG: Dicistroviridae sp. isolate 235_32398 genomic sequence blastn 6618 374 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
18615083 18615083 PRJNA782235_P_NODE_4415_length_418_cov_2.063768_g4226_i0 PRJNA782235 4415 418 2.063768 8.62655024 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 684 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g4226 i0 96.154 0.995215311004785 416 16 99 0 3 418 6556 6971 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 416 684 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
21166038 21166038 PRJNA782235_P_NODE_28777_length_230_cov_2.452229_g28588_i0 PRJNA782235 28777 230 2.452229 5.6401267 Dicistroviridae sp. 1955144 Viruses Viruses 239 1.47e-58   NTclustered gi|2756423063|gb|PP745339.1| 1955144 g28588 i0 88.177 8.21739130434783 203 20 87 2 29 229 8136 7936 MAG: Dicistroviridae sp. isolate 203_34685 genomic sequence blastn 1890 239 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
23715983 23715983 PRJNA782235_P_NODE_10359_length_287_cov_1.322430_g10170_i0 PRJNA782235 10359 287 1.32243 3.7953741 Skokie tombus-like virus 2789423 Viruses Viruses 89.8 2.02e-13   NTclustered gi|1933757594|gb|MW177751.1| 2789423 g10170 i0 92.063 0.219512195121951 63 5 22 0 225 287 1269 1207 Skokie tombus-like virus strain USAdp coat protein gene, partial cds blastn 63 89.8 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae   Skokie tombus-like virus
25439095 25439095 PRJNA782235_P_NODE_12280_length_275_cov_0.826733_g12091_i0 PRJNA782235 12280 275 0.826733 2.27351575 Viruses 10239 Viruses Viruses 353 6.19e-93   NTclustered gi|1935607036|gb|MT747993.1| 2789423 g12091 i0 89.818 2 275 28 100 0 1 275 1205 1479 Skokie tombus-like virus strain USAdp-1 RNA-dependent RNA polymerase gene, complete cds blastn 550 353 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae   Skokie tombus-like virus

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