RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA1241156" and tax_clade = "Embryophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Embryophyta · 9 ✖

bioproject 1

  • PRJNA1241156 · 9 ✖

analysis 1

  • diamond · 9 ✖
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
26820596 26820596 PRJNA1241156_S_NODE_11121_length_414_cov_4.366577_g10663_i0 PRJNA1241156 11121 414 4.366577 18.07762878 Forsythia ovata 205694 Plants Plants 66.2 1.58e-10   NR KAL2548042.1 205694 g10663 i0 57.1 0.456521739130435 63 18 44.2 2 2 184 11 66 KAL2548042.1 Rapid ALkalinization Factor [Forsythia ovata] diamond 189 66.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Forsythia Forsythia ovata
27547500 27547500 PRJNA1241156_S_NODE_33164_length_321_cov_3.043165_g32704_i0 PRJNA1241156 33164 321 3.043165 9.76855965 Persea americana 3435 Plants Plants 103 4.179999999999999e-23   NR KAJ8623546.1 3435 g32704 i0 100 0.523364485981308 56 0 52.3 0 3 170 458 513 KAJ8623546.1 hypothetical protein MRB53_032075 [Persea americana] diamond 168 103 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Laurales Lauraceae Persea Persea americana
28305249 28305249 PRJNA1241156_S_NODE_29866_length_331_cov_2.336806_g29406_i0 PRJNA1241156 29866 331 2.336806 7.73482786 Populus trichocarpa 3694 Plants Plants 86.7 8.71e-20   NR KAI5576512.1 3694 g29406 i0 91.8 0.552870090634441 61 4 55.3 1 330 148 18 77 KAI5576512.1 hypothetical protein BDE02_09G050000 [Populus trichocarpa] diamond 183 86.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Salicaceae Populus Populus trichocarpa
28463333 28463333 PRJNA1241156_S_NODE_64026_length_245_cov_3.594059_g63566_i0 PRJNA1241156 64026 245 3.594059 8.80544455 Forsythia ovata 205694 Plants Plants 51.6 1.45e-5   NR KAL2548041.1 205694 g63566 i0 50 0.587755102040816 48 17 58.8 1 3 146 26 66 KAL2548041.1 Rapid ALkalinization Factor [Forsythia ovata] diamond 144 51.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Forsythia Forsythia ovata
30389931 30389931 PRJNA1241156_S_NODE_36913_length_311_cov_1.197761_g36453_i0 PRJNA1241156 36913 311 1.197761 3.72503671 Gossypium australe 47621 Plants Plants 44.7 0.0166   NR KAA3485701.1 47621 g36453 i0 30.2 0.607717041800643 63 42 60.8 1 190 2 188 248 KAA3485701.1 cryptochrome-1-like isoform X3 [Gossypium australe] diamond 189 44.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium australe
30452975 30452975 PRJNA1241156_S_NODE_69753_length_230_cov_3.743316_g69293_i0 PRJNA1241156 69753 230 3.743316 8.6096268 Quercus rubra 3512 Plants Plants 46.2 0.0015   NR KAK4596498.1 3512 g69293 i0 95 0.508695652173913 20 1 26.1 0 2 61 151 170 KAK4596498.1 hypothetical protein RGQ29_014515 [Quercus rubra] diamond 117 46.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
31305828 31305828 PRJNA1241156_S_NODE_73935_length_209_cov_8.012048_g73475_i0 PRJNA1241156 73935 209 8.012048 16.74518032 Cryptomeria japonica 3369 Plants Plants 52.4 9.27e-6   NR XP_057846409.2 3369 g73475 i0 43.8 2.26794258373206 64 35 90.4 1 190 2 19 82 XP_057846409.2 pectin acetylesterase 8 isoform X3 [Cryptomeria japonica] diamond 474 52.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
31432365 31432365 PRJNA1241156_S_NODE_70036_length_229_cov_4.494624_g69576_i0 PRJNA1241156 70036 229 4.494624 10.29268896 Stephania japonica 461633 Plants Plants 42.7 0.0252   NR KAK9129167.1 461633 g69576 i0 37.3 0.877729257641921 67 37 81.2 2 24 209 105 171 KAK9129167.1 hypothetical protein Sjap_009654 [Stephania japonica] diamond 201 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Menispermaceae Stephania Stephania japonica
31735036 31735036 PRJNA1241156_S_NODE_49497_length_277_cov_3.555556_g49037_i0 PRJNA1241156 49497 277 3.555556 9.84889012 Prunus 3754 Plants Plants 43.1 0.026   NR ONH95927.1 3760 g49037 i0 43.4 1.72202166064982 53 23 54.2 3 36 185 3 51 ONH95927.1 hypothetical protein PRUPE_7G096700 [Prunus persica] diamond 477 43.5 0.990804597701149 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus persica

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