RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA547066" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA547066 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
26919779 26919779 PRJNA547066_P_NODE_4202_length_196_cov_1.490683_g4108_i0 PRJNA547066 4202 196 1.490683 2.92173868 Cinnamomum micranthum f. kanehirae 337451 Plants Plants 130 4.95e-35   NR RWR77887.1 337451 g4108 i0 96.9 0.994897959183674 65 2 99.5 0 195 1 234 298 RWR77887.1 transcription factor bHLH93 [Cinnamomum micranthum f. kanehirae] diamond 195 130 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Laurales Lauraceae Cinnamomum Cinnamomum micranthum
27962326 27962326 PRJNA547066_P_NODE_4505_length_186_cov_1.026490_g4411_i0 PRJNA547066 4505 186 1.02649 1.9092714 Cryptomeria japonica 3369 Plants Plants 81.6 3.47e-16   NR XP_059067200.1 3369 g4411 i0 62.3 1.75806451612903 61 19 98.4 1 183 1 323 379 XP_059067200.1 uncharacterized protein LOC131858147 [Cryptomeria japonica] diamond 327 81.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
30488683 30488683 PRJNA547066_P_NODE_3513_length_228_cov_1.450777_g3419_i0 PRJNA547066 3513 228 1.450777 3.30777156 Sphagnum jensenii 128206 Plants Plants 62.4 5.08e-10   NR CAK9252391.1 128206 g3419 i0 70.3 0.486842105263158 37 11 48.7 0 1 111 42 78 CAK9252391.1 unnamed protein product [Sphagnum jensenii] diamond 111 62.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum jensenii
30583247 30583247 PRJNA547066_P_NODE_5393_length_163_cov_1.109375_g5299_i0 PRJNA547066 5393 163 1.109375 1.80828125 Cryptomeria japonica 3369 Plants Plants 58.9 1.95e-8   NR XP_059073583.1 3369 g5299 i0 54.5 4.04907975460123 55 24 99.4 1 162 1 163 217 XP_059073583.1 aspartic proteinase nepenthesin-2-like [Cryptomeria japonica] diamond 660 58.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica

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