RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA594101 · 4 ✖

analysis 1

  • diamond · 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
26890198 26890198 PRJNA594101_S_NODE_9481_length_533_cov_2.256522_g9181_i0 PRJNA594101 9481 533 2.256522 12.02726226 uncultured phage cr125_1 2772091 Viruses Viruses 47.4 0.00709   NR YP_010113198.1 2772091 g9181 i0 26.6 0.951219512195122 169 96 86.7 6 485 24 18 173 YP_010113198.1 hypothetical protein KNV58_gp045 [uncultured phage cr125_1] diamond 507 47.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Crassvirales Suoliviridae Aurodevirus Aurodevirus hominis
28343055 28343055 PRJNA594101_S_NODE_39126_length_278_cov_1.287805_g38824_i0 PRJNA594101 39126 278 1.287805 3.5800979 Staphylococcus phage Madawaska 2797424 Viruses Viruses 43.5 0.0288   NR QQO92768.1 2797424 g38824 i0 33.3 0.744604316546763 69 42 74.5 1 274 68 248 312 QQO92768.1 homing endonuclease [Staphylococcus phage Madawaska] diamond 207 43.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Staphylococcus phage Madawaska
30630156 30630156 PRJNA594101_S_NODE_4413_length_767_cov_3.037464_g4142_i0 PRJNA594101 4413 767 3.037464 23.29734888 root 1 Root_unresolved Root_unresolved 96.3 7.75e-21   NR BAR16220.1 1407671 g4142 i0 38.1 1.70925684485007 147 83 56.7 3 476 42 8 148 BAR16220.1 Phage-related lysozyme (muraminidase) (COG3772) [uncultured Mediterranean phage uvMED] diamond 1311 96.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       uncultured Mediterranean phage uvMED
31059549 31059549 PRJNA594101_S_NODE_42495_length_267_cov_2.298969_g42193_i0 PRJNA594101 42495 267 2.298969 6.13824723 Bacillus phage SP-15 1792032 Viruses Viruses 70.9 4.21e-12   NR YP_009302495.1 1792032 g42193 i0 49.3 1.52808988764045 67 34 75.3 0 265 65 90 156 YP_009302495.1 endonuclease [Bacillus phage SP-15] diamond 408 70.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Thornevirus Thornevirus SP15

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