RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1233465" and tax_phylum = "Cossaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cossaviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1233465 · 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
32916584 32916584 PRJNA1233465f_S_NODE_108809_length_230_cov_3.325967_g106529_i0 PRJNA1233465 108809 230 3.325967 7.6497241 Emberiza spodocephala ambidensovirus 2794446 Viruses Viruses 122 3.4499999999999996e-30   NR QTE04115.1 2794446 g106529 i0 72.4 0.991304347826087 76 21 99.1 0 3 230 551 626 QTE04115.1 MAG: putative nonstructural protein 1 [Emberiza spodocephala ambidensovirus] diamond 228 122 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Ambidensovirus Emberiza spodocephala ambidensovirus
33069365 33069365 PRJNA1233465d_S_NODE_35325_length_282_cov_2.364807_g34214_i0 PRJNA1233465 35325 282 2.364807 6.66875574 Emberiza spodocephala ambidensovirus 2794446 Viruses Viruses 157 8.11e-43   NR QTE04115.1 2794446 g34214 i0 75.5 1 94 23 100 0 282 1 533 626 QTE04115.1 MAG: putative nonstructural protein 1 [Emberiza spodocephala ambidensovirus] diamond 282 157 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Ambidensovirus Emberiza spodocephala ambidensovirus
33120926 33120926 PRJNA1233465e_S_NODE_109879_length_185_cov_2.889706_g108569_i0 PRJNA1233465 109879 185 2.889706 5.3459561 Emberiza spodocephala ambidensovirus 2794446 Viruses Viruses 102 1.19e-23   NR QTE04115.1 2794446 g108569 i0 76.7 0.972972972972973 60 14 97.3 0 183 4 547 606 QTE04115.1 MAG: putative nonstructural protein 1 [Emberiza spodocephala ambidensovirus] diamond 180 102 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Ambidensovirus Emberiza spodocephala ambidensovirus
33173182 33173182 PRJNA1233465f_S_NODE_253032_length_163_cov_2.684211_g250752_i0 PRJNA1233465 253032 163 2.684211 4.37526393 Phoenicurus auroreus ambidensovirus 2794456 Viruses Viruses 55.8 2.89e-7   NR QTZ83142.1 2794456 g250752 i0 79.3 0.533742331288344 29 6 53.4 0 161 75 673 701 QTZ83142.1 MAG: putative non-structural protein [Phoenicurus auroreus ambidensovirus] diamond 87 55.8 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Ambidensovirus Phoenicurus auroreus ambidensovirus

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