RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA438687" 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 · 14 ✖

bioproject 1

  • PRJNA438687 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
26600866 26600866 PRJNA438687_S_NODE_5161_length_195_cov_2.212500_g5071_i0 PRJNA438687 5161 195 2.2125 4.314375 Sphagnum balticum 128184 Plants Plants 54.7 1.19e-6   NR CAM5999697.1 128184 g5071 i0 54.5 0.846153846153846 55 23 84.6 1 8 172 353 405 CAM5999697.1 unnamed protein product [Sphagnum balticum] diamond 165 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
26965691 26965691 PRJNA438687_S_NODE_4882_length_201_cov_4.620482_g4792_i0 PRJNA438687 4882 201 4.620482 9.28716882 Magnoliopsida 3398 Plants Plants 48.5 1.96e-4   NR KAG9438594.1 158543 g4792 i0 56.1 1.35820895522388 41 18 61.2 0 200 78 827 867 KAG9438594.1 hypothetical protein H6P81_021466 [Aristolochia fimbriata] diamond 273 48.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Piperales Aristolochiaceae Aristolochia Aristolochia fimbriata
27455421 27455421 PRJNA438687_S_NODE_2523_length_279_cov_4.508197_g2433_i0 PRJNA438687 2523 279 4.508197 12.57786963 Prunus brigantina 151428 Plants Plants 47.8 9.07e-4   NR CAL8988931.1 151428 g2433 i0 40 2.25806451612903 105 37 90.3 8 7 258 54 153 CAL8988931.1 unnamed protein product, partial [Prunus brigantina] diamond 630 47.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus brigantina
28086588 28086588 PRJNA438687_S_NODE_5445_length_189_cov_3.883117_g5355_i0 PRJNA438687 5445 189 3.883117 7.33909113 Hordeum vulgare subsp. vulgare 112509 Plants Plants 89 9.22e-19   NR BAK00514.1 112509 g5355 i0 86.9 0.968253968253968 61 8 96.8 0 2 184 253 313 BAK00514.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 183 89 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
28860664 28860664 PRJNA438687_S_NODE_8208_length_150_cov_2.617391_g8118_i0 PRJNA438687 8208 150 2.617391 3.9260865 Magnoliopsida 3398 Plants Plants 50.4 1.94e-5   NR KAI3475460.1 114280 g8118 i0 65 1.6 40 14 80 0 3 122 116 155 KAI3475460.1 hypothetical protein L1887_63148 [Cichorium endivia] diamond 240 50.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Cichorium Cichorium endivia
29191926 29191926 PRJNA438687_S_NODE_5689_length_185_cov_2.166667_g5599_i0 PRJNA438687 5689 185 2.166667 4.00833395 Capsicum baccatum 33114 Plants Plants 42 0.0166   NR PHT24772.1 33114 g5599 i0 43.1 0.827027027027027 51 29 82.7 0 166 14 69 119 PHT24772.1 hypothetical protein CQW23_35556 [Capsicum baccatum] diamond 153 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Capsicum Capsicum baccatum
29807901 29807901 PRJNA438687_S_NODE_2731_length_270_cov_1.106383_g2641_i0 PRJNA438687 2731 270 1.106383 2.9872341 Streptophyta 35493 Plants Plants 60.5 1.31e-8   NR WZY99505.1 3708 g2641 i0 61.4 4.87777777777778 44 17 48.9 0 266 135 175 218 WZY99505.1 hypothetical protein YC2023_071834 [Brassica napus] diamond 1317 60.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus
30202146 30202146 PRJNA438687_S_NODE_5752_length_184_cov_1.348993_g5662_i0 PRJNA438687 5752 184 1.348993 2.48214712 Aristolochia fimbriata 158543 Plants Plants 51.6 1.29e-5   NR KAG9438594.1 158543 g5662 i0 65 1.92391304347826 40 12 65.2 1 121 2 909 946 KAG9438594.1 hypothetical protein H6P81_021466 [Aristolochia fimbriata] diamond 354 51.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Piperales Aristolochiaceae Aristolochia Aristolochia fimbriata
30423947 30423947 PRJNA438687_S_NODE_4113_length_219_cov_1.554348_g4023_i0 PRJNA438687 4113 219 1.554348 3.40402212 Hordeum vulgare subsp. vulgare 112509 Plants Plants 100 6.45e-25   NR BAJ99990.1 112509 g4023 i0 94.3 0.726027397260274 53 3 72.6 0 218 60 20 72 BAJ99990.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 159 100 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
30549850 30549850 PRJNA438687_S_NODE_3493_length_238_cov_2.315271_g3403_i0 PRJNA438687 3493 238 2.315271 5.51034498 Capsicum baccatum 33114 Plants Plants 43.5 0.0185   NR PHT27117.1 33114 g3403 i0 41.8 0.84453781512605 67 32 84.5 2 31 231 178 237 PHT27117.1 hypothetical protein CQW23_33278 [Capsicum baccatum] diamond 201 43.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Capsicum Capsicum baccatum
30549851 30549851 PRJNA438687_S_NODE_6453_length_172_cov_2.934307_g6363_i0 PRJNA438687 6453 172 2.934307 5.04700804 Castanea mollissima 60419 Plants Plants 42 0.0271   NR KAF3975281.1 60419 g6363 i0 45.6 0.994186046511628 57 28 99.4 1 171 1 112 165 KAF3975281.1 hypothetical protein CMV_001441 [Castanea mollissima] diamond 171 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Castanea Castanea mollissima
31909336 31909336 PRJNA438687_S_NODE_3837_length_227_cov_2.666667_g3747_i0 PRJNA438687 3837 227 2.666667 6.05333409 Hordeum vulgare subsp. vulgare 112509 Plants Plants 93.6 3.75e-20   NR BAK00514.1 112509 g3747 i0 60 0.92511013215859 70 27 91.2 1 15 221 15 84 BAK00514.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 210 93.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
32590156 32590156 PRJNA438687_S_NODE_7619_length_157_cov_1.213115_g7529_i0 PRJNA438687 7619 157 1.213115 1.90459055 Magnoliopsida 3398 Plants Plants 42.4 0.00997   NR KAH0674099.1 4113 g7529 i0 51.2 1.66242038216561 41 19 78.3 1 17 139 116 155 KAH0674099.1 hypothetical protein KY284_025186 [Solanum tuberosum] diamond 261 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Solanum Solanum tuberosum
32636464 32636464 PRJNA438687_S_NODE_7720_length_156_cov_0.942149_g7630_i0 PRJNA438687 7720 156 0.942149 1.46975244 Nymphaea colorata 210225 Plants Plants 48.1 1.4e-4   NR XP_031472663.1 210225 g7630 i0 69.7 0.634615384615385 33 10 63.5 0 56 154 483 515 XP_031472663.1 uncharacterized protein LOC116245094 [Nymphaea colorata] diamond 99 48.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata

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