RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond" and tax_clade = "Adomaviruses"

✎ View and edit SQL

This data as json, CSV (advanced)

bioproject 3

tax_superkingdom 1

tax_clade 1

  • Adomaviruses · 6 ✖

analysis 1

  • diamond · 6 ✖

tax_phylum 0

tax_kingdom 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
26711626 26711626 PRJNA207719_P_NODE_21_length_1234_cov_7.056432_g19_i0 PRJNA207719 21 1234 7.056432 87.07637088 Viruses 10239 Viruses Viruses 91.3 8.65e-16   NR DAC81149.1 2609873 g19 i0 25.5 2.12722852512156 286 197 65.9 7 42 854 236 520 DAC81149.1 TPA_asm: LO7 [Bueycito anole adomavirus] diamond 2625 91.3 1 Viruses Adomaviruses             Bueycito anole adomavirus
27168577 27168577 PRJNA207719_P_NODE_902_length_201_cov_6.889535_g882_i0 PRJNA207719 902 201 6.889535 13.84796535 Catfish adomavirus 2609875 Viruses Viruses 65.9 5.18e-11   NR DAC81156.1 2609875 g882 i0 49.2 1.82089552238806 63 32 94 0 4 192 101 163 DAC81156.1 TPA_asm: LO8, partial [Catfish adomavirus] diamond 366 65.9 1 Viruses Adomaviruses             Catfish adomavirus
28691695 28691695 PRJNA630877_S_NODE_83407_length_279_cov_3.710084_g64270_i0 PRJNA630877 83407 279 3.710084 10.35113436 Blueface angelfish adomavirus 2609871 Viruses Viruses 46.6 0.00227   NR DAC81128.1 2609871 g64270 i0 36 0.537634408602151 50 32 53.8 0 232 83 248 297 DAC81128.1 TPA_asm: LO6 [Blueface angelfish adomavirus] diamond 150 46.6 1 Viruses Adomaviruses             Blueface angelfish adomavirus
29662128 29662128 PRJNA1237347_P_NODE_369550_length_293_cov_1.395455_g362977_i0 PRJNA1237347 369550 293 1.395455 4.08868315 Leatherback sea turtle adomavirus 2707294 Viruses Viruses 47.4 0.00154   NR DAC81231.1 2707294 g362977 i0 34.5 0.593856655290102 58 38 59.4 0 78 251 366 423 DAC81231.1 TPA_asm: EO3 [Leatherback sea turtle adomavirus] diamond 174 47.4 1 Viruses Adomaviruses             Leatherback sea turtle adomavirus
31496279 31496279 PRJNA207719_P_NODE_136_length_615_cov_4.003413_g119_i0 PRJNA207719 136 615 4.003413 24.62098995 Zebrafish adomavirus RQ02 Viruses Viruses 93.6 6.42e-19   NR YP_009553058.1 RQ02 g119 i0 44.2 0.717073170731707 147 61 65.9 5 546 142 85 222 YP_009553058.1 LO6 [Symphysodon discus adomavirus 1] diamond 441 93.6 1 Viruses Adomaviruses             Zebrafish adomavirus
31780596 31780596 PRJNA207719_P_NODE_217_length_466_cov_4.526316_g197_i0 PRJNA207719 217 466 4.526316 21.09263256 Adomavirus sceloporus8187 3115978 Viruses Viruses 65.1 6.08e-9   NR DBA49608.1 3115978 g197 i0 28.6 4.10085836909871 161 105 97.9 3 10 465 60 219 DBA49608.1 MAG TPA_asm: Hexon [Adomavirus sceloporus8187] diamond 1911 65.1 1 Viruses Adomaviruses             Adomavirus sceloporus8187

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