RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA371613 · 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
28590892 28590892 PRJNA371613_P_NODE_8167_length_167_cov_0.984615_g7991_i0 PRJNA371613 8167 167 0.984615 1.64430705 Caudoviricetes sp. 2832643 Viruses Viruses 52 7.28e-6   NR XOS08210.1 2832643 g7991 i0 76.7 0.538922155688623 30 7 53.9 0 91 2 1 30 XOS08210.1 MAG: hypothetical protein MSP0190_50 [Caudoviricetes sp.] diamond 90 52 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28653943 28653943 PRJNA371613_P_NODE_8267_length_166_cov_1.488372_g8091_i0 PRJNA371613 8267 166 1.488372 2.47069752 Caudoviricetes sp. 2832643 Viruses Viruses 59.7 1.39e-8   NR XOS08210.1 2832643 g8091 i0 52 0.903614457831325 50 24 90.4 0 163 14 1609 1658 XOS08210.1 MAG: hypothetical protein MSP0190_50 [Caudoviricetes sp.] diamond 150 59.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29917089 29917089 PRJNA371613_P_NODE_7831_length_169_cov_0.969697_g7655_i0 PRJNA371613 7831 169 0.969697 1.63878793 Caudoviricetes sp. 2832643 Viruses Viruses 82 1.06e-17   NR XOR69599.1 2832643 g7655 i0 83.6 0.976331360946746 55 9 97.6 0 167 3 128 182 XOR69599.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 165 82 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29917090 29917090 PRJNA371613_P_NODE_8751_length_164_cov_1.007874_g8575_i0 PRJNA371613 8751 164 1.007874 1.65291336 uncultured Caudovirales phage 2100421 Viruses Viruses 97.4 9.5e-23   NR CAB4143299.1 2100421 g8575 i0 83.3 0.98780487804878 54 9 98.8 0 2 163 158 211 CAB4143299.1 Oxoglutarate/iron-dependent dioxygenase [uncultured Caudovirales phage] diamond 162 97.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
32572862 32572862 PRJNA371613_P_NODE_7179_length_172_cov_0.948148_g7003_i0 PRJNA371613 7179 172 0.948148 1.63081456 Caudoviricetes sp. 2832643 Viruses Viruses 80.5 7.15e-16   NR XOS08250.1 2832643 g7003 i0 68.4 0.994186046511628 57 18 99.4 0 1 171 539 595 XOS08250.1 MAG: hypothetical protein MSP0190_90 [Caudoviricetes sp.] diamond 171 80.5 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);;