RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA597223" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA597223 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
3120067 3120067 PRJNA597223_P_NODE_37003_length_238_cov_1.970443_g35157_i0 PRJNA597223 37003 238 1.970443 4.68965434 Zebrafish picornavirus 1 2304617 Viruses Viruses 396 8.5699999999999955e-106   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g35157 i0 96.639 2.99159663865546 238 8 100 0 1 238 521 758 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 712 396 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
4396847 4396847 PRJNA597223_P_NODE_52584_length_192_cov_1.847134_g50738_i0 PRJNA597223 52584 192 1.847134 3.54649728 Apthili virus 3132807 Viruses Viruses 156 1.22e-33   NTclustered gi|2698077104|gb|PP057990.1| 3132807 g50738 i0 83.041 0.890625 171 29 89 0 5 175 3393 3563 MAG: Apthili virus genomic sequence blastn 171 156 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Apthili virus
11344095 11344095 PRJNA597223_P_NODE_53489_length_190_cov_2.870968_g51643_i0 PRJNA597223 53489 190 2.870968 5.4548392 Picornavirales 464095 Viruses Viruses 137 4.38e-28   NTclustered gi|2717314880|gb|OR224870.1| 1530251 g51643 i0 100 3.55789473684211 74 0 78 0 2 75 8096 8023 Picornaviridae sp. isolate C23N1/AU, complete genome blastn 676 137 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
23521493 23521493 PRJNA597223_P_NODE_47379_length_203_cov_29.708333_g45533_i0 PRJNA597223 47379 203 29.708333 60.30791599 Betacoronavirus pandemicum 3418604 Viruses Viruses 67.6 6.32e-7   NTclustered gi|2557654279|emb|OY684629.1| 2697049 g45533 i0 93.478 20.8177339901478 46 2 22 1 159 203 26107 26152 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 4226 67.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum

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