RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1204310" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Heunggongvirae · 5 ✖

bioproject 1

  • PRJNA1204310 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
5432925 5432925 PRJNA1204310_P_NODE_59985_length_244_cov_2.818713_g59688_i0 PRJNA1204310 59985 244 2.818713 6.87765972 Rhadinovirus saimiriinegamma2 3050350 Viruses Viruses 97.1 1e-15   NTclustered gi|30348412|emb|AJ410478.1| 10381 g59688 i0 84.158 16.6967213114754 101 14 41 2 11 110 262 163 Saimiriine herpesvirus 2 stpC and tip genes, strain C5952 blastn 4074 97.1 1 Viruses   Heunggongvirae Peploviricota Herviviricetes Herpesvirales Orthoherpesviridae Rhadinovirus Rhadinovirus saimiriinegamma2
6707230 6707230 PRJNA1204310_P_NODE_46106_length_271_cov_1.545455_g45809_i0 PRJNA1204310 46106 271 1.545455 4.18818305 Synechococcus phage S-CRES3 3038222 Viruses Viruses 296 1.04e-75   NTclustered gi|2496382469|gb|OQ587941.1| 3038222 g45809 i0 88 0.922509225092251 250 30 92 0 22 271 52012 52261 Synechococcus phage S-CRES3, complete genome blastn 250 296 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Synechococcus phage S-CRES3
6707552 6707552 PRJNA1204310_P_NODE_60746_length_244_cov_0.912281_g60449_i0 PRJNA1204310 60746 244 0.912281 2.22596564 Cyanophage S-RIM4 2530169 Viruses Viruses 231 2.63e-56   NTclustered gi|1603723705|gb|MK493321.1| 2530169 g60449 i0 86.385 57.3032786885246 213 27 87 2 10 221 142679 142468 Cyanophage S-RIM4 isolate RW_11_0999, complete genome blastn 13982 231 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Kyanoviridae Shandvirus Cyanophage S-RIM4
16347573 16347573 PRJNA1204310_P_NODE_58873_length_246_cov_0.901734_g58576_i0 PRJNA1204310 58873 246 0.901734 2.21826564 Aurunvirus 2733093 Viruses Viruses 196 9.7e-46   NTclustered gi|2275413904|ref|NC_019516.2| 1137745 g58576 i0 81.275 3.0609756097561 251 40 100 5 1 246 153209 152961 Cyanophage S-TIM5, complete genome blastn 753 196 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Aurunvirus Aurunvirus STIM5
18180905 18180905 PRJNA1204310_P_NODE_40675_length_290_cov_2.023041_g40378_i0 PRJNA1204310 40675 290 2.023041 5.8668189 Drulisvirus K72PH164C2 3428371 Viruses Viruses 60.2 1.6e-4   NTclustered gi|2617470222|emb|OY757088.1| 3071646 g40378 i0 100 0.110344827586207 32 0 11 0 242 273 3968 3999 Klebsiella phage vB_Kpl_K72PH164C2 genome assembly, chromosome: K72PH164C2_assembly blastn 32 60.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autoscriptoviridae Drulisvirus Drulisvirus K72PH164C2

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