RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA846486" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA846486 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
11435272 11435272 PRJNA846486_P_NODE_93309_length_162_cov_0.920354_g93213_i0 PRJNA846486 93309 162 0.920354 1.49097348 root 1 Root_unresolved Root_unresolved 107 1.0400000000000002e-27   NR CCA66136.1 184509 g93213 i0 92.3 1.92592592592593 52 4 96.3 0 5 160 70 121 CCA66136.1 cytochrome oxidase subunit III, partial [Hyalotheca mucosa] diamond 312 107 1 Eukaryota   Viridiplantae Streptophyta Zygnematophyceae Desmidiales Desmidiaceae Hyalotheca Hyalotheca mucosa
27220943 27220943 PRJNA846486_P_NODE_77842_length_168_cov_1.731092_g77746_i0 PRJNA846486 77842 168 1.731092 2.90823456 Streptophyta 35493 Plants Plants 72.4 1.05e-13   NR CAH2080529.1 13288 g77746 i0 63 6.25 46 17 82.1 0 4 141 149 194 CAH2080529.1 unnamed protein product, partial [Thlaspi arvense] diamond 1050 72.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Thlaspi Thlaspi arvense
27560117 27560117 PRJNA846486_P_NODE_40244_length_215_cov_1.240964_g40148_i0 PRJNA846486 40244 215 1.240964 2.6680726 Carpinus fangiana 176857 Plants Plants 84 4.98e-19   NR KAE8010300.1 176857 g40148 i0 93.2 0.613953488372093 44 3 61.4 0 2 133 63 106 KAE8010300.1 hypothetical protein FH972_006682 [Carpinus fangiana] diamond 132 84 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Carpinus Carpinus fangiana
27844269 27844269 PRJNA846486_P_NODE_41404_length_212_cov_6.361963_g41308_i0 PRJNA846486 41404 212 6.361963 13.48736156 Canavalia gladiata 3824 Plants Plants 47.4 4.3e-4   NR KAK7296717.1 3824 g41308 i0 44.7 5.37735849056604 76 35 97.6 1 5 211 129 204 KAK7296717.1 hypothetical protein VNO77_49729 [Canavalia gladiata] diamond 1140 47.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Canavalia Canavalia gladiata
27907343 27907343 PRJNA846486_P_NODE_53625_length_193_cov_1.083333_g53529_i0 PRJNA846486 53625 193 1.083333 2.09083269 Avicennia marina 82927 Plants Plants 86.3 8.36e-18   NR AAK55121.1 82927 g53529 i0 62.5 3.97927461139896 64 24 99.5 0 192 1 403 466 AAK55121.1 betaine aldehyde dehydrogenase [Avicennia marina] diamond 768 86.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Acanthaceae Avicennia Avicennia marina
28736960 28736960 PRJNA846486_P_NODE_83627_length_166_cov_0.888889_g83531_i0 PRJNA846486 83627 166 0.888889 1.47555574 Eukaryota 2759 Plants Plants 69.7 3.27e-12   NR KAK1566810.1 4024 g83531 i0 82.9 14.0963855421687 35 6 63.3 0 166 62 302 336 KAK1566810.1 hypothetical protein Q3G72_004508 [Acer saccharum] diamond 2340 69.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer saccharum
28886268 28886268 PRJNA846486_P_NODE_45968_length_204_cov_1.548387_g45872_i0 PRJNA846486 45968 204 1.548387 3.15870948 Rubroshorea leprosula 152421 Plants Plants 39.7 0.0375   NR GKV25766.1 152421 g45872 i0 75 0.470588235294118 32 7 47.1 1 98 3 1 31 GKV25766.1 hypothetical protein SLEP1_g35160 [Rubroshorea leprosula] diamond 96 39.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Dipterocarpaceae Rubroshorea Rubroshorea leprosula
28894694 28894694 PRJNA846486_P_NODE_86088_length_165_cov_0.896552_g85992_i0 PRJNA846486 86088 165 0.896552 1.4793108 Brassicaceae 3700 Plants Plants 57.4 5.13e-8   NR NP_182104.1 3702 g85992 i0 50 3.90909090909091 44 22 80 0 165 34 20 63 NP_182104.1 GATA type zinc finger transcription factor family protein [Arabidopsis thaliana] diamond 645 57.8 0.993079584775087 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
29706886 29706886 PRJNA846486_P_NODE_38450_length_219_cov_1.070588_g38354_i0 PRJNA846486 38450 219 1.070588 2.34458772 Closterium sp. NIES-54 3014311 Plants Plants 56.2 4.82e-7   NR CAI7759161.1 3014311 g38354 i0 40.3 2.56164383561644 62 36 84.9 1 3 188 3178 3238 CAI7759161.1 unnamed protein product [Closterium sp. NIES-54] diamond 561 56.2 1 Eukaryota   Viridiplantae Streptophyta Zygnematophyceae Desmidiales Closteriaceae Closterium Closterium sp. NIES-54
29833618 29833618 PRJNA846486_P_NODE_89711_length_163_cov_1.877193_g89615_i0 PRJNA846486 89711 163 1.877193 3.05982459 Sphagnum balticum 128184 Plants Plants 90.5 1.27e-20   NR CAM6002349.1 128184 g89615 i0 86.8 0.975460122699387 53 7 97.5 0 3 161 145 197 CAM6002349.1 unnamed protein product, partial [Sphagnum balticum] diamond 159 90.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
29991630 29991630 PRJNA846486_P_NODE_33171_length_232_cov_1.136612_g33075_i0 PRJNA846486 33171 232 1.136612 2.63693984 Rhododendron simsii 118357 Plants Plants 48.5 2.9e-4   NR KAF7127372.1 118357 g33075 i0 32.4 5.79310344827586 74 49 94.4 1 6 224 773 846 KAF7127372.1 hypothetical protein RHSIM_Rhsim11G0141400 [Rhododendron simsii] diamond 1344 48.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Ericaceae Rhododendron Rhododendron simsii
30000121 30000121 PRJNA846486_P_NODE_79211_length_168_cov_0.873950_g79115_i0 PRJNA846486 79211 168 0.87395 1.468236 Eukaryota 2759 Plants Plants 76.3 1.57e-15   NR GMD70492.1 4120 g79115 i0 66.7 6.41071428571429 54 18 96.4 0 7 168 23 76 GMD70492.1 40S ribosomal protein S18 [Ipomoea batatas] diamond 1077 76.6 0.996083550913838 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Convolvulaceae Ipomoea Ipomoea batatas
30497214 30497214 PRJNA846486_P_NODE_82053_length_167_cov_0.881356_g81957_i0 PRJNA846486 82053 167 0.881356 1.47186452 Rosa chinensis 74649 Plants Plants 57.4 3.37e-9   NR PRQ52282.1 74649 g81957 i0 78.8 0.592814371257485 33 7 59.3 0 100 2 6 38 PRQ52282.1 putative cysteine-rich transmembrane CYSTM domain-containing protein [Rosa chinensis] diamond 99 57.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Rosa Rosa chinensis
30718178 30718178 PRJNA846486_P_NODE_96534_length_153_cov_2.086538_g96438_i0 PRJNA846486 96534 153 2.086538 3.19240314 Shorea laevis 152420 Plants Plants 71.2 2.2e-14   NR GLT64208.1 152420 g96438 i0 94 0.980392156862745 50 3 98 0 152 3 29 78 GLT64208.1 hypothetical protein SLA2020_367150 [Shorea laevis] diamond 150 71.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Dipterocarpaceae Shorea Shorea laevis
30916419 30916419 PRJNA846486_P_NODE_57994_length_187_cov_2.028986_g57898_i0 PRJNA846486 57994 187 2.028986 3.79420382 Eukaryota 2759 Plants Plants 77.8 1.06e-16   NR XP_052185781.1 55363 g57898 i0 72 10.6042780748663 50 14 80.2 0 150 1 2 51 XP_052185781.1 60S acidic ribosomal protein P1-like [Diospyros lotus] diamond 1983 77.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Ebenaceae Diospyros Diospyros lotus
30971159 30971159 PRJNA846486_P_NODE_61014_length_184_cov_1.014815_g60918_i0 PRJNA846486 61014 184 1.014815 1.8672596 Tanacetum cinerariifolium 118510 Plants Plants 42 0.0317   NR GEW82241.1 118510 g60918 i0 43.5 0.75 46 26 75 0 155 18 121 166 GEW82241.1 reverse transcriptase domain-containing protein [Tanacetum cinerariifolium] diamond 138 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
32046329 32046329 PRJNA846486_P_NODE_96698_length_152_cov_2.524272_g96602_i0 PRJNA846486 96698 152 2.524272 3.83689344 Quercus lobata 97700 Plants Plants 70.1 2.77e-14   NR XP_030946207.1 97700 g96602 i0 64.4 1.83552631578947 45 16 88.8 0 15 149 30 74 XP_030946207.1 major pollen allergen Ole e 6-like [Quercus lobata] diamond 279 70.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus lobata
32867353 32867353 PRJNA846486_P_NODE_33700_length_230_cov_2.060773_g33604_i0 PRJNA846486 33700 230 2.060773 4.7397779 Protea cynaroides 273540 Plants Plants 77 2.58e-14   NR KAJ4962240.1 273540 g33604 i0 44.4 1.87826086956522 72 40 93.9 0 10 225 419 490 KAJ4962240.1 hypothetical protein NE237_022179 [Protea cynaroides] diamond 432 77 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Proteales Proteaceae Protea Protea cynaroides
32867361 32867361 PRJNA846486_P_NODE_79640_length_168_cov_0.873950_g79544_i0 PRJNA846486 79640 168 0.87395 1.468236 Sphagnum jensenii 128206 Plants Plants 42.7 0.013   NR CAK9249689.1 128206 g79544 i0 64.3 1.39285714285714 28 10 50 0 2 85 148 175 CAK9249689.1 unnamed protein product [Sphagnum jensenii] diamond 234 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum jensenii
32898770 32898770 PRJNA846486_P_NODE_70300_length_174_cov_1.312000_g70204_i0 PRJNA846486 70300 174 1.312 2.28288 Chara braunii 69332 Plants Plants 68.6 1.14e-11   NR GBG86551.1 69332 g70204 i0 70.7 15.1724137931034 41 12 70.7 0 44 166 185 225 GBG86551.1 hypothetical protein CBR_g41614 [Chara braunii] diamond 2640 68.6 1 Eukaryota   Viridiplantae Streptophyta Charophyceae Charales Characeae Chara Chara braunii

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