RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA781453" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA781453 · 5 ✖

analysis 1

  • diamond · 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
762813 762813 PRJNA781453_P_NODE_33141_length_250_cov_0.870056_g33026_i0 PRJNA781453 33141 250 0.870056 2.17514 Caudoviricetes sp. 2832643 Viruses Viruses 153 5.75e-41   NR DAY73630.1 2832643 g33026 i0 89 1.968 82 9 98.4 0 250 5 138 219 DAY73630.1 MAG TPA: DNA polymerase [Caudoviricetes sp.] diamond 492 153 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
22440261 22440261 PRJNA781453_P_NODE_37438_length_245_cov_0.895349_g37323_i0 PRJNA781453 37438 245 0.895349 2.19360505 Streptococcus phage vB_SbRt-pBovineS21 2961981 Viruses Viruses 108 8.15e-26   NR UVD41291.1 2961981 g37323 i0 77.8 1.55510204081633 63 13 77.1 1 243 55 319 380 UVD41291.1 major capsid protein [Streptococcus phage vB_SbRt-pBovineS21] diamond 381 108 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Rountreeviridae   Streptococcus phage vB_SbRt-pBovineS21
29043281 29043281 PRJNA781453_P_NODE_33848_length_249_cov_0.875000_g33733_i0 PRJNA781453 33848 249 0.875 2.17875 Caudoviricetes sp. 2832643 Viruses Viruses 90.9 1.89e-19   NR DAY73598.1 2832643 g33733 i0 53.6 1.01204819277108 84 38 100 1 1 249 207 290 DAY73598.1 MAG TPA: bifunctional DNA-binding transcriptional repressor/ NMN adenylyltransferase [Caudoviricetes sp.] diamond 252 90.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30053444 30053444 PRJNA781453_P_NODE_13471_length_401_cov_1.353659_g13357_i0 PRJNA781453 13471 401 1.353659 5.42817259 Streptococcus phage vB_SbRt-pBovineS21 2961981 Viruses Viruses 122 1.36e-29   NR UVD41285.1 2961981 g13357 i0 59.8 1.52618453865337 102 38 74.1 1 304 8 16 117 UVD41285.1 tail fiber protein [Streptococcus phage vB_SbRt-pBovineS21] diamond 612 122 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Rountreeviridae   Streptococcus phage vB_SbRt-pBovineS21
32434376 32434376 PRJNA781453_P_NODE_29079_length_267_cov_0.840206_g28964_i0 PRJNA781453 29079 267 0.840206 2.24335002 Viruses 10239 Viruses Viruses 111 1.53e-29   NR QQV91875.1 2801835 g28964 i0 74.6 1.50561797752809 67 17 75.3 0 1 201 42 108 QQV91875.1 hypothetical protein vBKpMFBKp34_046 [Klebsiella phage vB_KpM_FBKp34] diamond 402 111 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Klebsiella phage vB_KpM_FBKp34

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