RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1034994" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1034994 · 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
11646849 11646849 PRJNA1034994_P_NODE_9410_length_243_cov_0.905882_g9326_i0 PRJNA1034994 9410 243 0.905882 2.20129326 Xanthomonas phage Xoo-sp14 2769337 Viruses Viruses 427 3.11e-115   NTclustered gi|1900767118|gb|MT939492.1| 2769337 g9326 i0 98.354 1 243 4 100 0 1 243 174646 174404 Xanthomonas phage Xoo-sp14, complete genome blastn 243 427 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Xanthomonas phage Xoo-sp14
13760927 13760927 PRJNA1034994_P_NODE_3911_length_282_cov_1.124402_g3827_i0 PRJNA1034994 3911 282 1.124402 3.17081364 Viruses 10239 Viruses Viruses 516 7.67e-142   NTclustered gi|1795714992|emb|LR743529.1| 2674972 g3827 i0 99.645 16.0567375886525 282 1 100 0 1 282 13474 13193 Xanthomonas phage Sopo genome assembly, chromosome: 1 blastn 4528 516 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Xanthomonas phage Sopo
15471145 15471145 PRJNA1034994_P_NODE_9853_length_242_cov_0.911243_g9769_i0 PRJNA1034994 9853 242 0.911243 2.20520806 Pahexavirus PHL152M00 1982295 Viruses Viruses 409 1.12e-109   NTclustered gi|849255497|ref|NC_027386.1| 1500825 g9769 i0 97.119 103.301652892562 243 5 100 2 1 242 22606 22847 Propionibacterium phage PHL152M00, complete genome blastn 24999 409 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus PHL152M00
20569444 20569444 PRJNA1034994_P_NODE_9097_length_244_cov_0.900585_g9013_i0 PRJNA1034994 9097 244 0.900585 2.1974274 Caudoviricetes sp. 2832643 Viruses Viruses 451 1.86e-122   NTclustered gi|2054418461|tpg|BK035692.1| 2832643 g9013 i0 100 11.9508196721311 244 0 100 0 1 244 37316 37073 MAG TPA_asm: Caudoviricetes sp. isolate ctSD610, partial genome blastn 2916 451 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);;