RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA896973" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA896973 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
7251153 7251153 PRJNA896973_P_NODE_13926_length_301_cov_1.013158_g13832_i0 PRJNA896973 13926 301 1.013158 3.04960558 Caudoviricetes sp. 2832643 Viruses Viruses 451 2.36e-122   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g13832 i0 94.539 465.730897009967 293 14 97 2 1 292 18130 18421 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 140185 451 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
8526007 8526007 PRJNA896973_P_NODE_23767_length_248_cov_0.880000_g23673_i0 PRJNA896973 23767 248 0.88 2.1824 Caudoviricetes sp. 2832643 Viruses Viruses 420 5.34e-113   NTclustered gi|2914806051|gb|OR221530.1| 2832643 g23673 i0 97.177 1 248 7 100 0 1 248 5186 4939 MAG: Caudoviricetes sp. isolate MSP1551 genomic sequence blastn 248 420 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
13997922 13997922 PRJNA896973_P_NODE_21891_length_251_cov_0.865169_g21797_i0 PRJNA896973 21891 251 0.865169 2.17157419 Unaquatrovirus 2169622 Viruses Viruses 320 5.65e-83   NTclustered gi|937533119|ref|NC_027987.1| 745088 g21797 i0 89.641 4.97211155378486 251 26 100 0 1 251 14947 14697 Leuconostoc phage 1-A4, complete genome blastn 1248 320 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Unaquatrovirus Unaquatrovirus uv1A4

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