RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA512103" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 4 ✖

bioproject 1

  • PRJNA512103 · 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
3037113 3037113 PRJNA512103_P_NODE_26643_length_182_cov_1.105263_g26231_i0 PRJNA512103 26643 182 1.105263 2.01157866 Vibrio phage VBM1 754074 Viruses Viruses 243 8.559999999999999e-60   NTclustered gi|472340788|ref|NC_020850.1| 754074 g26231 i0 92.814 0.917582417582418 167 12 92 0 10 176 31263 31097 Vibrio phage VBM1 genomic sequence blastn 167 243 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage VBM1
4313228 4313228 PRJNA512103_P_NODE_33924_length_163_cov_0.912281_g33512_i0 PRJNA512103 33924 163 0.912281 1.48701803 Vibrio phage XM1 2748688 Viruses Viruses 228 2.0999999999999998e-55   NTclustered gi|1882344635|gb|MT720689.1| 2748688 g33512 i0 94.595 4.47852760736196 148 7 91 1 12 159 13065 12919 Vibrio phage XM1, complete genome blastn 730 228 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage XM1
5589970 5589970 PRJNA512103_P_NODE_29765_length_171_cov_1.327869_g29353_i0 PRJNA512103 29765 171 1.327869 2.27065599 Vibrio phage 1.154.O._10N.222.52.B12 1881387 Viruses Viruses 241 2.85e-59   NTclustered gi|1332550747|gb|MG592522.1| 1881387 g29353 i0 93.252 0.953216374269006 163 11 95 0 9 171 28851 29013 Vibrio phage 1.154.O._10N.222.52.B12, partial genome blastn 163 241 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage 1.154.O._10N.222.52.B12
10689402 10689402 PRJNA512103_P_NODE_15529_length_258_cov_1.076555_g15117_i0 PRJNA512103 15529 258 1.076555 2.7775119 Vibrio phage vB_Vp_PvVp04_M 2928754 Viruses Viruses 252 2.16e-62   NTclustered gi|2220660719|gb|OM837731.1| 2928754 g15117 i0 86.463 0.887596899224806 229 31 89 0 30 258 38700 38472 Vibrio phage vB_Vp_PvVp04_M, complete genome blastn 229 252 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage vB_Vp_PvVp04_M

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