RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1228616" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1228616 · 5 ✖

analysis 1

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
10539439 10539439 PRJNA1228616_S_NODE_4129_length_201_cov_10.715190_g4106_i0 PRJNA1228616 4129 201 10.71519 21.5375319 Cucumis melo 3656 Plants Plants 54.7 0.005   NTclustered gi|733578316|emb|LN713263.1| 3656 g4106 i0 96.97 0.328358208955224 33 0 16 1 131 163 23720629 23720598 Cucumis melo genomic chromosome, chr_9 blastn 66 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Cucumis Cucumis melo
13089250 13089250 PRJNA1228616_S_NODE_8031_length_156_cov_1.380531_g8008_i0 PRJNA1228616 8031 156 1.380531 2.15362836 Ribes rubrum 175228 Plants Plants 52.8 0.013   NTclustered gi|2918370029|emb|OZ237957.1| 175228 g8008 i0 100 0.179487179487179 28 0 18 0 1 28 5363033 5363060 Ribes rubrum genome assembly, chromosome: 7 blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Saxifragales Grossulariaceae Ribes Ribes rubrum
16912659 16912659 PRJNA1228616_S_NODE_1894_length_270_cov_4.563877_g1871_i0 PRJNA1228616 1894 270 4.563877 12.3224679 Calluna vulgaris 13385 Plants Plants 56.5 0.002   NTclustered gi|2917566876|emb|OZ228610.1| 13385 g1871 i0 97.059 0.748148148148148 34 0 12 1 134 166 49713368 49713335 Calluna vulgaris genome assembly, chromosome: 7 blastn 202 56.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Ericaceae Calluna Calluna vulgaris
22724028 22724028 PRJNA1228616_S_NODE_4738_length_191_cov_2.047297_g4715_i0 PRJNA1228616 4738 191 2.047297 3.91033727 Salvia 21880 Plants Plants 52.8 0.016   NTclustered gi|2236115062|ref|XM_048117530.1| 49212 g4715 i0 100 0.879581151832461 28 0 15 0 131 158 1805 1832 PREDICTED: Salvia hispanica stomatal closure-related actin-binding protein 1 (LOC125215943), transcript variant X1, mRNA blastn 168 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Salvia Salvia hispanica
24561752 24561752 PRJNA1228616_S_NODE_2060_length_262_cov_1.812785_g2037_i0 PRJNA1228616 2060 262 1.812785 4.7494967 Cucumis melo 3656 Plants Plants 52.8 0.024   NTclustered gi|733598837|emb|LN681874.1| 3656 g2037 i0 100 0.213740458015267 28 0 11 0 151 178 3720351 3720378 Cucumis melo genomic scaffold, anchoredscaffold00031 blastn 56 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Cucumis Cucumis melo

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