RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Prasinodermophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Prasinodermophyta · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA630162 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
9530037 9530037 PRJNA630162_P_NODE_125328_length_171_cov_4.885246_g123805_i0 PRJNA630162 125328 171 4.885246 8.35377066 Prasinococcus capsulatus 156131 Plants Plants 71.3 3.95e-8   NTclustered gi|371782109|emb|HE610141.1| 156131 g123805 i0 75.294 26.672514619883 170 31 97 10 1 166 2403 2241 Prasinococcus capsulatus 5.8S rRNA gene, 28S rRNA gene (partial) and ITS2, strain CCMP1202 blastn 4561 71.3 1 Eukaryota   Viridiplantae Prasinodermophyta Palmophyllophyceae Prasinococcales Prasinococcaceae Prasinococcus Prasinococcus capsulatus
10805837 10805837 PRJNA630162_P_NODE_137889_length_167_cov_2.118644_g136366_i0 PRJNA630162 137889 167 2.118644 3.5381354800000002 Verdigellas peltata 542676 Plants Plants 87.9 3.84e-13   NTclustered gi|1026942297|emb|LT174528.1| 542676 g136366 i0 79.545 89.748502994012 132 20 76 7 6 132 4203 4332 Verdigellas peltata LAF:8-26-12-6-1 complete nuclear ribosomal DNA unit blastn 14988 87.9 1 Eukaryota   Viridiplantae Prasinodermophyta Palmophyllophyceae Palmophyllales Palmophyllaceae Verdigellas Verdigellas peltata
21005281 21005281 PRJNA630162_P_NODE_99997_length_185_cov_3.941176_g98474_i0 PRJNA630162 99997 185 3.941176 7.2911756 Verdigellas peltata 542676 Plants Plants 63.9 7.3e-6   NTclustered gi|1026942297|emb|LT174528.1| 542676 g98474 i0 83.099 4.25405405405405 71 11 38 1 24 93 5584 5654 Verdigellas peltata LAF:8-26-12-6-1 complete nuclear ribosomal DNA unit blastn 787 63.9 1 Eukaryota   Viridiplantae Prasinodermophyta Palmophyllophyceae Palmophyllales Palmophyllaceae Verdigellas Verdigellas peltata

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