RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA493827" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493827 · 6 ✖

analysis 1

  • blastn · 6 ✖

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

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