RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA533623", tax_phylum = "Phixviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 5 ✖

tax_phylum 1

  • Phixviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA533623 · 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
20908347 20908347 PRJNA533623_P_NODE_3237_length_1210_cov_17.153177_g2279_i0 PRJNA533623 3237 1210 17.153177 207.5534417 Microvirus 10842 Viruses Viruses 142 5.04e-33   NR WAE43528.1 2202644 g2279 i0 76.5 1.05619834710744 85 20 21.1 0 1113 859 585 669 WAE43528.1 MAG: major capsid protein [Microviridae sp.] diamond 1278 142 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
25344544 25344544 PRJNA533623_P_NODE_75340_length_206_cov_1.365517_g73559_i0 PRJNA533623 75340 206 1.365517 2.81296502 Viruses 10239 Viruses Viruses 331 2.0700000000000002e-86   NTclustered gi|2057955467|tpg|BK046278.1| 2202644 g73559 i0 95.631 19.004854368932 206 9 100 0 1 206 9503 9298 MAG TPA_asm: Microviridae sp. isolate ctZ9e15, partial genome blastn 3915 331 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
28530663 28530663 PRJNA533623_P_NODE_34287_length_380_cov_8.874608_g32516_i0 PRJNA533623 34287 380 8.874608 33.7235104 Microviridae sp. 2202644 Viruses Viruses 133 1.88e-33   NR WGN98173.1 2202644 g32516 i0 71.8 4.71315789473684 85 24 67.1 0 366 112 437 521 WGN98173.1 MAG: major capsid protein [Microviridae sp.] diamond 1791 133 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
28941191 28941191 PRJNA533623_P_NODE_35228_length_374_cov_4.849840_g33456_i0 PRJNA533623 35228 374 4.84984 18.1384016 Sedum sarmentosum microvirus 2740151 Viruses Viruses 69.3 7.71e-11   NR QKI28952.1 2740151 g33456 i0 48.5 0.529411764705882 66 34 52.9 0 21 218 455 520 QKI28952.1 VP1 [Sedum sarmentosum microvirus] diamond 198 69.3 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Sedum sarmentosum microvirus
29793309 29793309 PRJNA533623_P_NODE_40591_length_341_cov_6.639286_g38817_i0 PRJNA533623 40591 341 6.639286 22.63996526 Microvirus AZ-2 2944756 Viruses Viruses 129 1.31e-35   NR UQT28874.1 2944756 g38817 i0 84.2 0.668621700879765 76 12 66.9 0 229 2 45 120 UQT28874.1 internal scaffolding protein [Microvirus AZ-2020] diamond 228 129 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus AZ-2020

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