RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1249042" 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

  • PRJNA1249042 · 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
28115823 28115823 PRJNA1249042_S_NODE_98845_length_162_cov_1.974790_g98631_i0 PRJNA1249042 98845 162 1.97479 3.1991598 Caudoviricetes sp. 2832643 Viruses Viruses 97.1 4.23e-22   NR DAT71371.1 2832643 g98631 i0 83 0.981481481481482 53 9 98.1 0 161 3 110 162 DAT71371.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 159 97.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29599663 29599663 PRJNA1249042_S_NODE_78850_length_179_cov_1.713235_g78636_i0 PRJNA1249042 78850 179 1.713235 3.06669065 Caudoviricetes sp. 2832643 Viruses Viruses 103 1.86e-26   NR DAV29426.1 2832643 g78636 i0 77.2 9.63687150837989 57 13 95.5 0 7 177 54 110 DAV29426.1 MAG TPA: YopX protein [Caudoviricetes sp.] diamond 1725 103 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30326939 30326939 PRJNA1249042_S_NODE_86412_length_172_cov_2.186047_g86198_i0 PRJNA1249042 86412 172 2.186047 3.76000084 Xanthomonas phage CP1 2994055 Viruses Viruses 40.8 0.0105   NR YP_007238114.1 2994055 g86198 i0 45 0.697674418604651 40 22 69.8 0 152 33 17 56 YP_007238114.1 hypothetical protein G176_gp44 [Xanthomonas phage CP1] diamond 120 40.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Klementvirus Klementvirus CP1
31084738 31084738 PRJNA1249042_S_NODE_39095_length_225_cov_3.098901_g38881_i0 PRJNA1249042 39095 225 3.098901 6.97252725 Listeria phage vB_Lino_VEfB7 2712944 Viruses Viruses 80.9 9.94e-16   NR QIG60834.1 2712944 g38881 i0 76.1 0.613333333333333 46 11 61.3 0 223 86 423 468 QIG60834.1 putative major capsid protein [Listeria phage vB_Lino_VEfB7] diamond 138 80.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae Pecentumvirus Listeria phage vB_Lino_VEfB7
32223427 32223427 PRJNA1249042_S_NODE_25018_length_252_cov_1.349282_g24804_i0 PRJNA1249042 25018 252 1.349282 3.40019064 Caudoviricetes sp. 2832643 Viruses Viruses 55.8 4.95e-7   NR DAO50445.1 2832643 g24804 i0 60 0.476190476190476 40 16 47.6 0 131 250 30 69 DAO50445.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 120 55.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32886073 32886073 PRJNA1249042_S_NODE_10200_length_307_cov_2.515152_g9986_i0 PRJNA1249042 10200 307 2.515152 7.72151664 Caudoviricetes sp. 2832643 Viruses Viruses 73.6 3.01e-14   NR DAH73638.1 2832643 g9986 i0 40.6 0.986970684039088 101 57 98.7 2 306 4 16 113 DAH73638.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 303 73.6 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);;