RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA683902" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA683902 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
2450861 2450861 PRJNA683902_S_NODE_30962_length_175_cov_1.413043_g30518_i0 PRJNA683902 30962 175 1.413043 2.47282525 Juncus effusus 13579 Plants Plants 85.1 4.54e-18   NR KAJ3679406.1 13579 g30518 i0 78.9 5.65714285714286 57 12 97.7 0 173 3 121 177 KAJ3679406.1 hypothetical protein LUZ60_017417 [Juncus effusus] diamond 990 85.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Juncaceae Juncus Juncus effusus
4493146 4493146 PRJNA683902_S_NODE_16504_length_280_cov_3.378601_g16060_i0 PRJNA683902 16504 280 3.378601 9.4600828 Quercus rubra 3512 Plants Plants 139 4.57e-41   NR KAK4605734.1 3512 g16060 i0 97.1 0.728571428571429 68 2 72.9 0 278 75 1 68 KAK4605734.1 hypothetical protein RGQ29_000149 [Quercus rubra] diamond 204 139 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
5003947 5003947 PRJNA683902_S_NODE_30844_length_175_cov_2.985507_g30400_i0 PRJNA683902 30844 175 2.985507 5.22463725 Eukaryota 2759 Plants Plants 90.9 1.57e-20   NR CAK9251874.1 128206 g30400 i0 77.6 2.00571428571429 58 13 99.4 0 174 1 124 181 CAK9251874.1 unnamed protein product [Sphagnum jensenii] diamond 351 91.7 0.991275899672846 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum jensenii
9593970 9593970 PRJNA683902_S_NODE_31808_length_172_cov_1.725926_g31364_i0 PRJNA683902 31808 172 1.725926 2.96859272 Carya illinoinensis 32201 Plants Plants 124 3.67e-35   NR KAG2722713.1 32201 g31364 i0 100 0.976744186046512 56 0 97.7 0 3 170 2 57 KAG2722713.1 hypothetical protein I3760_02G139400, partial [Carya illinoinensis] diamond 168 124 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Juglandaceae Carya Carya illinoinensis
13419184 13419184 PRJNA683902_S_NODE_18251_length_257_cov_2.077273_g17807_i0 PRJNA683902 18251 257 2.077273 5.33859161 Sphagnum jensenii 128206 Plants Plants 111 1.43e-29   NR CAK9251875.1 128206 g17807 i0 74.7 1.72762645914397 75 19 87.5 0 227 3 1 75 CAK9251875.1 unnamed protein product [Sphagnum jensenii] diamond 444 111 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum jensenii
15204525 15204525 PRJNA683902_S_NODE_7872_length_601_cov_9.427305_g7468_i0 PRJNA683902 7872 601 9.427305 56.65810305 Ipomoea batatas 4120 Plants Plants 236 6.09e-68   NR GME07254.1 4120 g7468 i0 61.3 2.05657237936772 212 70 99.8 1 600 1 2065 2276 GME07254.1 DNA mismatch repair endonuclease MutL [Ipomoea batatas] diamond 1236 236 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Convolvulaceae Ipomoea Ipomoea batatas
17243235 17243235 PRJNA683902_S_NODE_26554_length_194_cov_1.974522_g26110_i0 PRJNA683902 26554 194 1.974522 3.83057268 Sphagnum jensenii 128206 Plants Plants 90.9 4.65e-22   NR CAK9251397.1 128206 g26110 i0 78.4 6.29381443298969 51 11 78.9 0 192 40 42 92 CAK9251397.1 unnamed protein product, partial [Sphagnum jensenii] diamond 1221 90.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum jensenii
21067731 21067731 PRJNA683902_S_NODE_23677_length_211_cov_1.218391_g23233_i0 PRJNA683902 23677 211 1.218391 2.57080501 Ilex paraguariensis 185542 Plants Plants 140 9.569999999999998e-42   NR CAK9163939.1 185542 g23233 i0 93.8 0.909952606635071 64 4 91 0 211 20 20 83 CAK9163939.1 unnamed protein product [Ilex paraguariensis] diamond 192 140 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Aquifoliales Aquifoliaceae Ilex Ilex paraguariensis
24891426 24891426 PRJNA683902_S_NODE_28900_length_183_cov_1.424658_g28456_i0 PRJNA683902 28900 183 1.424658 2.60712414 Magnoliopsida 3398 Plants Plants 86.7 4.9e-18   NR KAF5956841.1 4442 g28456 i0 75.5 7.91803278688525 53 12 86.9 1 20 178 283 334 KAF5956841.1 hypothetical protein HYC85_004066 [Camellia sinensis] diamond 1449 87.4 0.991990846681922 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia sinensis
27176817 27176817 PRJNA683902_S_NODE_23162_length_214_cov_1.514124_g22718_i0 PRJNA683902 23162 214 1.514124 3.24022536 Hordeum vulgare subsp. vulgare 112509 Plants Plants 91.7 3.7799999999999997e-20   NR BAK02263.1 112509 g22718 i0 84.9 0.742990654205608 53 8 74.3 0 210 52 263 315 BAK02263.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 159 91.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
27240146 27240146 PRJNA683902_S_NODE_33303_length_167_cov_1.746154_g32859_i0 PRJNA683902 33303 167 1.746154 2.91607718 Sphagnum balticum 128184 Plants Plants 99 5.83e-25   NR CAM6001409.1 128184 g32859 i0 81.8 0.988023952095808 55 10 98.8 0 165 1 5 59 CAM6001409.1 unnamed protein product [Sphagnum balticum] diamond 165 99 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
27430080 27430080 PRJNA683902_S_NODE_19623_length_242_cov_4.156098_g19179_i0 PRJNA683902 19623 242 4.156098 10.05775716 Hordeum vulgare subsp. vulgare 112509 Plants Plants 142 1.21e-39   NR BAK02263.1 112509 g19179 i0 85 0.991735537190083 80 12 99.2 0 2 241 182 261 BAK02263.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 240 142 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
27650977 27650977 PRJNA683902_S_NODE_20264_length_236_cov_1.567839_g19820_i0 PRJNA683902 20264 236 1.567839 3.70010004 Juglans regia 51240 Plants Plants 45.8 0.00282   NR XP_018840122.1 51240 g19820 i0 37 0.927966101694915 73 42 91.5 2 234 19 689 758 XP_018840122.1 disease resistance protein RPV1-like isoform X1 [Juglans regia] diamond 219 45.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Juglandaceae Juglans Juglans regia
27650978 27650978 PRJNA683902_S_NODE_24064_length_208_cov_3.397661_g23620_i0 PRJNA683902 24064 208 3.397661 7.06713488 Dendrobium thyrsiflorum 117978 Plants Plants 46.6 8.7e-4   NR KAL0919950.1 117978 g23620 i0 63.3 1.29807692307692 30 11 43.3 0 127 38 182 211 KAL0919950.1 hypothetical protein M5K25_009041 [Dendrobium thyrsiflorum] diamond 270 46.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asparagales Orchidaceae Dendrobium Dendrobium thyrsiflorum
28724414 28724414 PRJNA683902_S_NODE_35587_length_160_cov_2.219512_g35143_i0 PRJNA683902 35587 160 2.219512 3.5512192 Cinnamomum micranthum f. kanehirae 337451 Plants Plants 71.2 3.05e-13   NR RWR76487.1 337451 g35143 i0 78.6 1.5375 42 9 78.8 0 127 2 23 64 RWR76487.1 60S ribosomal protein L19-3-like protein [Cinnamomum micranthum f. kanehirae] diamond 246 71.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Laurales Lauraceae Cinnamomum Cinnamomum micranthum
28850458 28850458 PRJNA683902_S_NODE_33788_length_165_cov_3.609375_g33344_i0 PRJNA683902 33788 165 3.609375 5.95546875 Brassica napus 3708 Plants Plants 45.8 7.12e-4   NR CAF2086696.1 3708 g33344 i0 75.9 1.10909090909091 29 7 52.7 0 1 87 155 183 CAF2086696.1 unnamed protein product, partial [Brassica napus] diamond 183 45.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus
29209691 29209691 PRJNA683902_S_NODE_25849_length_198_cov_1.658385_g25405_i0 PRJNA683902 25849 198 1.658385 3.2836023 Fabaceae 3803 Plants Plants 89.7 4.79e-20   NR KAK7344254.1 3824 g25405 i0 70.3 25.2727272727273 64 19 97 0 7 198 66 129 KAK7344254.1 hypothetical protein VNO77_13655 [Canavalia gladiata] diamond 5004 90.5 0.991160220994475 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Canavalia Canavalia gladiata
29556739 29556739 PRJNA683902_S_NODE_29850_length_179_cov_1.619718_g29406_i0 PRJNA683902 29850 179 1.619718 2.89929522 Magnoliopsida 3398 Plants Plants 52.8 1.21e-6   NR KAF6165811.1 39325 g29406 i0 53.7 11.2960893854749 54 20 83.8 2 9 158 69 121 KAF6165811.1 hypothetical protein GIB67_012708 [Kingdonia uniflora] diamond 2022 53.1 0.994350282485876 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Circaeasteraceae Kingdonia Kingdonia uniflora
29608070 29608070 PRJNA683902_S_NODE_39170_length_152_cov_1.182609_g38726_i0 PRJNA683902 39170 152 1.182609 1.79756568 Quercus rubra 3512 Plants Plants 100 3.24e-26   NR KAK4589130.1 3512 g38726 i0 100 0.986842105263158 50 0 98.7 0 151 2 1 50 KAK4589130.1 hypothetical protein RGQ29_019925 [Quercus rubra] diamond 150 100 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
29639715 29639715 PRJNA683902_S_NODE_26690_length_193_cov_3.429487_g26246_i0 PRJNA683902 26690 193 3.429487 6.61890991 Hordeum vulgare subsp. vulgare 112509 Plants Plants 106 7.890000000000001e-26   NR BAK02263.1 112509 g26246 i0 87.1 0.963730569948187 62 8 96.4 0 8 193 3 64 BAK02263.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 186 106 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
29892834 29892834 PRJNA683902_S_NODE_14831_length_309_cov_5.463235_g14387_i0 PRJNA683902 14831 309 5.463235 16.88139615 Hordeum vulgare subsp. vulgare 112509 Plants Plants 108 4.81e-26   NR BAK02263.1 112509 g14387 i0 89.8 0.572815533980582 59 6 57.3 0 307 131 257 315 BAK02263.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 177 108 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
30145074 30145074 PRJNA683902_S_NODE_39052_length_152_cov_1.695652_g38608_i0 PRJNA683902 39052 152 1.695652 2.57739104 Morus notabilis 981085 Plants Plants 68.6 1.1e-13   NR EXB51901.1 981085 g38608 i0 90.9 0.651315789473684 33 3 65.1 0 2 100 41 73 EXB51901.1 hypothetical protein L484_006246 [Morus notabilis] diamond 99 68.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Moraceae Morus Morus notabilis
30315452 30315452 PRJNA683902_S_NODE_28672_length_184_cov_1.455782_g28228_i0 PRJNA683902 28672 184 1.455782 2.67863888 root 1 Root_unresolved Root_unresolved 64.3 1.66e-10   NR CAM6031272.1 128190 g28228 i0 87.5 1.05978260869565 32 4 52.2 0 3 98 199 230 CAM6031272.1 unnamed protein product, partial [Sphagnum compactum] diamond 195 64.7 0.993817619783617 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum compactum
30788907 30788907 PRJNA683902_S_NODE_39154_length_152_cov_1.339130_g38710_i0 PRJNA683902 39154 152 1.33913 2.0354776 Malvales 41938 Plants Plants 45.8 2.98e-4   NR GLT77624.1 152420 g38710 i0 65.6 2.52631578947368 32 11 63.2 0 144 49 46 77 GLT77624.1 hypothetical protein SLA2020_491920 [Shorea laevis] diamond 384 45.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Dipterocarpaceae Shorea Shorea laevis
31156108 31156108 PRJNA683902_S_NODE_22675_length_217_cov_2.333333_g22231_i0 PRJNA683902 22675 217 2.333333 5.06333261 Sphagnum balticum 128184 Plants Plants 115 2.3399999999999997e-31   NR CAM6001409.1 128184 g22231 i0 80 0.967741935483871 70 14 96.8 0 3 212 20 89 CAM6001409.1 unnamed protein product [Sphagnum balticum] diamond 210 115 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
31294449 31294449 PRJNA683902_S_NODE_38215_length_154_cov_1.333333_g37771_i0 PRJNA683902 38215 154 1.333333 2.05333282 root 1 Root_unresolved Root_unresolved 42 0.021   NR KAI5440954.1 3888 g37771 i0 48.9 1.48051948051948 45 23 87.7 0 147 13 154 198 KAI5440954.1 hypothetical protein KIW84_010431 [Pisum sativum] diamond 228 42.4 0.990566037735849 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lathyrus Lathyrus oleraceus
31852112 31852112 PRJNA683902_S_NODE_37737_length_155_cov_1.652542_g37293_i0 PRJNA683902 37737 155 1.652542 2.5614401 Carya illinoinensis 32201 Plants Plants 112 4.31e-30   NR KAG2701900.1 32201 g37293 i0 100 0.987096774193548 51 0 98.7 0 155 3 55 105 KAG2701900.1 hypothetical protein I3760_06G066500 [Carya illinoinensis] diamond 153 112 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Juglandaceae Carya Carya illinoinensis
32642589 32642589 PRJNA683902_S_NODE_23820_length_210_cov_1.346821_g23376_i0 PRJNA683902 23820 210 1.346821 2.8283241 Trema orientale 63057 Plants Plants 62 3.34e-10   NR PON96497.1 63057 g23376 i0 46.6 1.65714285714286 58 31 82.9 0 3 176 20 77 PON96497.1 Rapid ALkalinization Factor [Trema orientale] diamond 348 62 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Trema Trema orientale

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