RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 5 ✖

bioproject 1

  • PRJNA1001940 · 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
1420914 1420914 PRJNA1001940_S_NODE_143362_length_181_cov_2.434783_g142308_i0 PRJNA1001940 143362 181 2.434783 4.40695723 Caudoviricetes sp. 2832643 Viruses Viruses 130 6.9e-26   NTclustered gi|2060049418|tpg|BK027917.1| 2832643 g142308 i0 96.25 1.28729281767956 80 2 44 1 25 104 21273 21195 MAG TPA_asm: Caudoviricetes sp. isolate ctHwC17, partial genome blastn 233 130 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
3974347 3974347 PRJNA1001940_S_NODE_72544_length_255_cov_2.363208_g71490_i0 PRJNA1001940 72544 255 2.363208 6.0261804 Caudoviricetes sp. 2832643 Viruses Viruses 398 2.5799999999999994e-106   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g71490 i0 97.826 349.352941176471 230 5 90 0 26 255 18424 18195 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 89085 398 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10349450 10349450 PRJNA1001940_S_NODE_151849_length_176_cov_2.165414_g150795_i0 PRJNA1001940 151849 176 2.165414 3.81112864 Caudoviricetes sp. 2832643 Viruses Viruses 281 1.74e-71   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g150795 i0 95.48 373.954545454545 177 6 100 2 1 176 18228 18053 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 65816 281 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
12899564 12899564 PRJNA1001940_S_NODE_124691_length_194_cov_2.225166_g123637_i0 PRJNA1001940 124691 194 2.225166 4.31682204 Staphylococcus phage MarsHill 2796499 Viruses Viruses 270 4.2499999999999985e-68   NTclustered gi|1953870784|gb|MW248466.1| 2796499 g123637 i0 91.753 4.77835051546392 194 16 100 0 1 194 245153 244960 Staphylococcus phage MarsHill, complete genome blastn 927 270 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Staphylococcus phage MarsHill
17997341 17997341 PRJNA1001940_S_NODE_109995_length_207_cov_1.170732_g108941_i0 PRJNA1001940 109995 207 1.170732 2.42341524 Huanghaivirus snothree 3060040 Viruses Viruses 52.8 0.018   NTclustered gi|2438097045|ref|NC_070959.1| 2718943 g108941 i0 96.875 0.154589371980676 32 0 15 1 77 107 130208 130177 Synechococcus phage S-N03, complete genome blastn 32 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Kyanoviridae Huanghaivirus Huanghaivirus snothree

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