RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA493827", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 10 ✖

tax_phylum 1

  • Pisuviricota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493827 · 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
1748464 1748464 PRJNA493827_P_NODE_65642_length_431_cov_1.075419_g63445_i0 PRJNA493827 65642 431 1.075419 4.63505589 Zebrafish picornavirus 1 2304617 Viruses Viruses 758 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g63445 i0 98.376 3 431 7 100 0 1 431 6467 6037 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1293 758 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
6847361 6847361 PRJNA493827_P_NODE_114906_length_319_cov_1.130081_g112708_i0 PRJNA493827 114906 319 1.130081 3.60495839 Dicistroviridae sp. 1955144 Viruses Viruses 331 3.43e-86   NTclustered gi|2196304114|gb|MZ679072.1| 1955144 g112708 i0 86.622 0.93730407523511 299 40 94 0 19 317 304 6 MAG: Dicistroviridae sp. isolate 249-k141_184573 nonstructural protein and structural protein genes, complete cds blastn 299 331 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
8126962 8126962 PRJNA493827_P_NODE_78307_length_389_cov_17.645570_g76109_i0 PRJNA493827 78307 389 17.64557 68.6412673 Betacoronavirus pandemicum 3418604 Viruses Viruses 73.1 2.85e-8   NTclustered gi|2165836885|emb|OV197189.1| 2697049 g76109 i0 97.619 11.3881748071979 42 1 11 0 121 162 74 115 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 4430 73.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
9398076 9398076 PRJNA493827_P_NODE_124268_length_307_cov_0.863248_g122070_i0 PRJNA493827 124268 307 0.863248 2.65017136 Zebrafish picornavirus 1 2304617 Viruses Viruses 453 6.72e-123   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g122070 i0 93.443 2.98371335504886 305 20 99 0 3 307 2737 2433 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 916 453 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
9400116 9400116 PRJNA493827_P_NODE_221048_length_243_cov_1.523529_g218850_i0 PRJNA493827 221048 243 1.523529 3.70217547 Locarnavirus 2560169 Viruses Viruses 142 9.32e-38   NR XCM68368.1 1955153 g218850 i0 80 3.95061728395062 80 16 98.8 0 3 242 406 485 XCM68368.1 MAG: RNA-dependent RNA polymerase, partial [Picornavirales sp.] diamond 960 142 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
11951120 11951120 PRJNA493827_P_NODE_236750_length_235_cov_2.376543_g234551_i0 PRJNA493827 236750 235 2.376543 5.58487605 Betapartitivirus pleuroti 3427255 Viruses Viruses 390 3.93e-104   NTclustered gi|260516646|gb|GQ505290.1| 674983 g234551 i0 96.61 3.14468085106383 236 7 100 1 1 235 408 643 Pleurotus ostreatus virus 1 RNA-dependent RNA polymerase gene, partial cds blastn 739 390 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Betapartitivirus Betapartitivirus pleuroti
23424149 23424149 PRJNA493827_P_NODE_203839_length_247_cov_0.885057_g201641_i0 PRJNA493827 203839 247 0.885057 2.18609079 Cripavirus drosophilae 3047809 Viruses Viruses 440 4.079999999999999e-119   NTclustered gi|1388193546|gb|MG570143.1| 64279 g201641 i0 98.79 13.6842105263158 248 2 100 1 1 247 369 122 Drosophila C virus isolate B6A, complete genome blastn 3380 440 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
28371624 28371624 PRJNA493827_P_NODE_210226_length_246_cov_0.890173_g208028_i0 PRJNA493827 210226 246 0.890173 2.18982558 Qianjiang dicistro-like virus 113 3347367 Viruses Viruses 76.6 4.71e-14   NR XHA87929.1 3347367 g208028 i0 50 0.926829268292683 76 38 92.7 0 231 4 2072 2147 XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113] diamond 228 76.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 113
28971592 28971592 PRJNA493827_P_NODE_130848_length_299_cov_1.053097_g128650_i0 PRJNA493827 130848 299 1.053097 3.14876003 Qianjiang dicistro-like virus 113 3347367 Viruses Viruses 79.7 7.7e-15   NR XHA87929.1 3347367 g128650 i0 55.7 0.792642140468227 79 31 78.3 3 65 298 2396 2471 XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113] diamond 237 79.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 113
31182277 31182277 PRJNA493827_P_NODE_132555_length_297_cov_1.017857_g130357_i0 PRJNA493827 132555 297 1.017857 3.02303529 Qianjiang dicistro-like virus 113 3347367 Viruses Viruses 82.4 8.37e-16   NR XHA87929.1 3347367 g130357 i0 46.9 0.96969696969697 96 50 96 1 8 292 1893 1988 XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113] diamond 288 82.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 113

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