RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA421571", tax_clade = "RNA satellites" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 3 ✖

tax_clade 1

  • RNA satellites · 3 ✖

bioproject 1

  • PRJNA421571 · 3 ✖

analysis 1

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
16999846 16999846 PRJNA421571_P_NODE_25434_length_671_cov_4.623746_g22961_i0 PRJNA421571 25434 671 4.623746 31.02533566 Peony yellowing associated secovirus satellite RNA 2800989 Viruses Viruses 488 4.2999999999999986e-133   NTclustered gi|1898324217|gb|MN259157.1| 2800989 g22961 i0 83.554 0.788375558867362 529 80 78 6 1 525 430 955 Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds blastn 529 488 1 Viruses RNA satellites             Peony yellowing associated secovirus satellite RNA
18274478 18274478 PRJNA421571_P_NODE_36495_length_503_cov_1.195349_g33952_i0 PRJNA421571 36495 503 1.195349 6.01260547 Peony yellowing associated secovirus satellite RNA 2800989 Viruses Viruses 104 1.34e-17   NTclustered gi|1898324217|gb|MN259157.1| 2800989 g33952 i0 95.385 0.129224652087475 65 3 13 0 439 503 402 338 Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds blastn 65 104 1 Viruses RNA satellites             Peony yellowing associated secovirus satellite RNA
24649751 24649751 PRJNA421571_P_NODE_57140_length_351_cov_4.636691_g54591_i0 PRJNA421571 57140 351 4.636691 16.27478541 Peony yellowing associated secovirus satellite RNA 2800989 Viruses Viruses 359 1.75e-94   NTclustered gi|1898324217|gb|MN259157.1| 2800989 g54591 i0 89.041 0.831908831908832 292 29 83 2 2 293 360 72 Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds blastn 292 359 1 Viruses RNA satellites             Peony yellowing associated secovirus satellite RNA

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