RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA690592" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 6 ✖

bioproject 1

  • PRJNA690592 · 6 ✖

analysis 1

  • diamond · 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
28156551 28156551 PRJNA690592_S_NODE_207105_length_244_cov_0.900585_g206091_i0 PRJNA690592 207105 244 0.900585 2.1974274 Streptomyces phage Yaboi 2301621 Viruses Viruses 76.6 5.41e-15   NR YP_009841238.1 2301621 g206091 i0 58.8 0.836065573770492 68 28 83.6 0 234 31 102 169 YP_009841238.1 hypothetical protein HWB86_gp180 [Streptomyces phage Yaboi] diamond 204 76.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Stanwilliamsviridae Karimacvirus Karimacvirus yaboi
29513915 29513915 PRJNA690592_S_NODE_99110_length_329_cov_1.042969_g98096_i0 PRJNA690592 99110 329 1.042969 3.43136801 Roseobacter phage RDJL Phi 1 562742 Viruses Viruses 53.1 2.07e-6   NR YP_004421789.1 562742 g98096 i0 47.1 3.95744680851064 51 27 46.5 0 176 328 8 58 YP_004421789.1 hypothetical protein RDJLphi1_gp21 [Roseobacter phage RDJL Phi 1] diamond 1302 53.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Xiamenvirus Xiamenvirus RDJL1
29608318 29608318 PRJNA690592_S_NODE_145150_length_281_cov_1.110577_g144136_i0 PRJNA690592 145150 281 1.110577 3.12072137 uncultured Mediterranean phage uvMED 1407671 Viruses Viruses 44.7 0.00749   NR BAQ88411.1 1407671 g144136 i0 44.2 0.555160142348754 52 27 55.5 1 281 126 110 159 BAQ88411.1 phage morphogenesis protein [uncultured Mediterranean phage uvMED] diamond 156 44.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       uncultured Mediterranean phage uvMED
30367207 30367207 PRJNA690592_S_NODE_116572_length_308_cov_1.310638_g115558_i0 PRJNA690592 116572 308 1.310638 4.03676504 Klebsiella phage Kp_Pokalde_ 3431989 Viruses Viruses 54.3 1.06e-6   NR QKE60375.1 2736260 g115558 i0 34.4 0.876623376623377 90 46 75 2 266 36 4 93 QKE60375.1 putative DNA endonuclease VII [Klebsiella phage Kp_Pokalde_002] diamond 270 54.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autotranscriptaviridae Przondovirus Przondovirus pokalde002
30619538 30619538 PRJNA690592_S_NODE_26853_length_581_cov_2.328740_g25859_i0 PRJNA690592 26853 581 2.32874 13.5299794 Caudoviricetes sp. 2832643 Viruses Viruses 62.4 5.14e-8   NR DAG67903.1 2832643 g25859 i0 53.5 0.222030981067126 43 20 22.2 0 326 454 28 70 DAG67903.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 129 62.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31124699 31124699 PRJNA690592_S_NODE_150335_length_277_cov_1.019608_g149321_i0 PRJNA690592 150335 277 1.019608 2.82431416 Caudoviricetes sp. 2832643 Viruses Viruses 43.5 0.0147   NR DAM69420.1 2832643 g149321 i0 31.4 0.931407942238267 86 58 92.1 1 264 10 10 95 DAM69420.1 MAG TPA: DNA-packaging protein [Caudoviricetes sp.] diamond 258 43.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.

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