RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA473201", tax_clade = "RNA satellites" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 6 ✖

tax_clade 1

  • RNA satellites · 6 ✖

bioproject 1

  • PRJNA473201 · 6 ✖

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
1718502 1718502 PRJNA473201_P_NODE_3002_length_1144_cov_13.519141_g2576_i0 PRJNA473201 3002 1144 13.519141 154.65897304 Peony yellowing associated secovirus satellite RNA 2800989 Viruses Viruses 1295 0   NTclustered gi|1898324217|gb|MN259157.1| 2800989 g2576 i0 91.272 0.831293706293706 951 81 83 2 2 951 6 955 Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds blastn 951 1295 1 Viruses RNA satellites             Peony yellowing associated secovirus satellite RNA
9371426 9371426 PRJNA473201_P_NODE_3008_length_1142_cov_12.420019_g2581_i0 PRJNA473201 3008 1142 12.420019 141.83661698 Peony yellowing associated secovirus satellite RNA 2800989 Viruses Viruses 1290 0   NTclustered gi|1898324217|gb|MN259157.1| 2800989 g2581 i0 91.176 0.833625218914186 952 80 83 4 2 951 6 955 Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds blastn 952 1290 1 Viruses RNA satellites             Peony yellowing associated secovirus satellite RNA
13197300 13197300 PRJNA473201_P_NODE_3411_length_1083_cov_14.568317_g2948_i0 PRJNA473201 3411 1083 14.568317 157.77487311 Peony yellowing associated secovirus satellite RNA 2800989 Viruses Viruses 708 0   NTclustered gi|1898324217|gb|MN259157.1| 2800989 g2948 i0 83.462 0.797783933518006 780 109 71 13 20 793 34 799 Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds blastn 864 708 1 Viruses RNA satellites             Peony yellowing associated secovirus satellite RNA
17020959 17020959 PRJNA473201_P_NODE_2894_length_1160_cov_14.457222_g2481_i0 PRJNA473201 2894 1160 14.457222 167.7037752 Peony yellowing associated secovirus satellite RNA 2800989 Viruses Viruses 1408 0   NTclustered gi|1898324217|gb|MN259157.1| 2800989 g2481 i0 90.26 0.929310344827586 1078 104 93 1 2 1079 6 1082 Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds blastn 1078 1408 1 Viruses RNA satellites             Peony yellowing associated secovirus satellite RNA
20845356 20845356 PRJNA473201_P_NODE_3417_length_1082_cov_11.482656_g2954_i0 PRJNA473201 3417 1082 11.482656 124.24233792 Peony yellowing associated secovirus satellite RNA 2800989 Viruses Viruses 1476 0   NTclustered gi|1898324217|gb|MN259157.1| 2800989 g2954 i0 91.381 0.997227356746765 1079 91 99 1 3 1081 1082 6 Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds blastn 1079 1476 1 Viruses RNA satellites             Peony yellowing associated secovirus satellite RNA
22120205 22120205 PRJNA473201_P_NODE_3398_length_1085_cov_63.624506_g2939_i0 PRJNA473201 3398 1085 63.624506 690.3258901 Peony yellowing associated secovirus satellite RNA 2800989 Viruses Viruses 691 0   NTclustered gi|1898324217|gb|MN259157.1| 2800989 g2939 i0 83.077 7.14285714285714 780 112 71 12 290 1063 799 34 Peony yellowing associated secovirus satellite RNA strain BJ 31 kDa protein gene, complete cds blastn 7750 691 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);;