RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA1263632" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 27 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1263632 · 27 ✖

analysis 1

  • diamond · 27 ✖
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
7431962 7431962 PRJNA1263632_P_NODE_3546_length_329_cov_1.464844_g3528_i0 PRJNA1263632 3546 329 1.464844 4.81933676 Sphagnum balticum 128184 Plants Plants 190 4.5099999999999996e-60   NR CAM6001409.1 128184 g3528 i0 84.4 0.993920972644377 109 17 99.4 0 327 1 20 128 CAM6001409.1 unnamed protein product [Sphagnum balticum] diamond 327 190 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
8017056 8017056 PRJNA1263632_P_NODE_3147_length_346_cov_1.124542_g3129_i0 PRJNA1263632 3147 346 1.124542 3.89091532 Eukaryota 2759 Plants Plants 202 1.63e-62   NR BAK03012.1 112509 g3129 i0 83.5 20.9393063583815 115 19 99.7 0 1 345 157 271 BAK03012.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 7245 202 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
8017129 8017129 PRJNA1263632_P_NODE_5547_length_269_cov_1.178571_g5529_i0 PRJNA1263632 5547 269 1.178571 3.17035599 Hordeum vulgare subsp. vulgare 112509 Plants Plants 151 6.3299999999999985e-43   NR BAK02263.1 112509 g5529 i0 80.9 3.97026022304833 89 17 99.3 0 269 3 165 253 BAK02263.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 1068 151 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
8017193 8017193 PRJNA1263632_P_NODE_8167_length_242_cov_0.911243_g8149_i0 PRJNA1263632 8167 242 0.911243 2.20520806 root 1 Root_unresolved Root_unresolved 123 6.36e-32   NR XP_020254878.1 4686 g8149 i0 65.8 10.7727272727273 79 27 97.9 0 240 4 186 264 XP_020254878.1 serine/threonine-protein phosphatase PP1-like isoform X2 [Asparagus officinalis] diamond 2607 124 0.991935483870968 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asparagales Asparagaceae Asparagus Asparagus officinalis
10567916 10567916 PRJNA1263632_P_NODE_8029_length_243_cov_0.905882_g8011_i0 PRJNA1263632 8029 243 0.905882 2.20129326 Eukaryota 2759 Plants Plants 139 2.39e-36   NR THU67984.1 52838 g8011 i0 84.6 93.320987654321 78 12 96.3 0 3 236 488 565 THU67984.1 hypothetical protein C4D60_Mb05t30470 [Musa balbisiana] diamond 22677 139 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Musaceae Musa Musa balbisiana
15666567 15666567 PRJNA1263632_P_NODE_2973_length_355_cov_1.092199_g2955_i0 PRJNA1263632 2973 355 1.092199 3.87730645 Sphagnum balticum 128184 Plants Plants 193 7.53e-60   NR CAM6006450.1 128184 g2955 i0 81.5 0.912676056338028 108 20 91.3 0 353 30 128 235 CAM6006450.1 unnamed protein product [Sphagnum balticum] diamond 324 193 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
20765383 20765383 PRJNA1263632_P_NODE_8137_length_242_cov_0.911243_g8119_i0 PRJNA1263632 8137 242 0.911243 2.20520806 Eukaryota 2759 Plants Plants 74.3 2.7e-13   NR XP_021890247.1 3649 g8119 i0 56.9 9.64462809917355 65 27 80.6 1 200 6 423 486 XP_021890247.1 probable carboxylesterase 18 [Carica papaya] diamond 2334 74.7 0.994645247657296 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Caricaceae Carica Carica papaya
22040312 22040312 PRJNA1263632_P_NODE_1858_length_443_cov_3.251351_g1840_i0 PRJNA1263632 1858 443 3.251351 14.40348493 Eukaryota 2759 Plants Plants 99 5.03e-21   NR KAH8497352.1 3696 g1840 i0 41.2 9.05417607223476 148 70 94.1 5 418 2 61 200 KAH8497352.1 hypothetical protein H0E87_019865 [Populus deltoides] diamond 4011 99 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Salicaceae Populus Populus deltoides
26662067 26662067 PRJNA1263632_P_NODE_6201_length_254_cov_1.685083_g6183_i0 PRJNA1263632 6201 254 1.685083 4.28011082 Sphagnum balticum 128184 Plants Plants 117 5.739999999999999e-31   NR CAM6000181.1 128184 g6183 i0 77.9 0.803149606299213 68 15 80.3 0 206 3 72 139 CAM6000181.1 unnamed protein product [Sphagnum balticum] diamond 204 117 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
26725298 26725298 PRJNA1263632_P_NODE_6241_length_253_cov_2.050000_g6223_i0 PRJNA1263632 6241 253 2.05 5.1865 Heliosperma pusillum 39905 Plants Plants 97.1 1.27e-21   NR KAH9606054.1 39905 g6223 i0 55.6 3.78260869565217 81 36 96 0 2 244 227 307 KAH9606054.1 hypothetical protein KSS87_006691 [Heliosperma pusillum] diamond 957 97.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Caryophyllaceae Heliosperma Heliosperma pusillum
26757247 26757247 PRJNA1263632_P_NODE_8141_length_242_cov_0.911243_g8123_i0 PRJNA1263632 8141 242 0.911243 2.20520806 Xanthoceras sorbifolium 99658 Plants Plants 56.2 6.59e-7   NR KAH7554234.1 99658 g8123 i0 47.9 0.90495867768595 73 35 90.5 2 10 228 1027 1096 KAH7554234.1 hypothetical protein JRO89_XS12G0139000 [Xanthoceras sorbifolium] diamond 219 56.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Xanthoceras Xanthoceras sorbifolium
26775401 26775401 PRJNA1263632_P_NODE_6961_length_248_cov_0.880000_g6943_i0 PRJNA1263632 6961 248 0.88 2.1824 root 1 Root_unresolved Root_unresolved 92.4 3.21e-21   NR XP_047308700.1 253017 g6943 i0 54.3 2.95161290322581 81 37 98 0 6 248 6 86 XP_047308700.1 60S ribosomal protein L9-like isoform X1 [Impatiens glandulifera] diamond 732 92.8 0.995689655172414 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Balsaminaceae Impatiens Impatiens glandulifera
27028483 27028483 PRJNA1263632_P_NODE_3942_length_313_cov_1.108333_g3924_i0 PRJNA1263632 3942 313 1.108333 3.46908229 Streptophyta 35493 Plants Plants 105 4.42e-24   NR KAG9139385.1 34254 g3924 i0 55.8 21.9297124600639 104 45 99.7 1 312 1 184 286 KAG9139385.1 hypothetical protein Leryth_017310 [Lithospermum erythrorhizon] diamond 6864 106 0.990566037735849 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Boraginales Boraginaceae Lithospermum Lithospermum erythrorhizon
27453320 27453320 PRJNA1263632_P_NODE_2523_length_382_cov_1.747573_g2505_i0 PRJNA1263632 2523 382 1.747573 6.67572886 Gossypium barbadense 3634 Plants Plants 182 2.5599999999999996e-56   NR PPD68800.1 3634 g2505 i0 66.7 26.6937172774869 126 42 99 0 382 5 4 129 PPD68800.1 hypothetical protein GOBAR_DD34321 [Gossypium barbadense] diamond 10197 182 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium barbadense
27534100 27534100 PRJNA1263632_P_NODE_2583_length_379_cov_0.986928_g2565_i0 PRJNA1263632 2583 379 0.986928 3.74045712 Streptophyta 35493 Plants Plants 154 6.899999999999998e-44   NR KAF2315973.1 3981 g2565 i0 68.4 34.131926121372 114 32 87.1 1 378 49 139 252 KAF2315973.1 hypothetical protein GH714_040768 [Hevea brasiliensis] diamond 12936 154 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Hevea Hevea brasiliensis
27737602 27737602 PRJNA1263632_P_NODE_3304_length_338_cov_1.992453_g3286_i0 PRJNA1263632 3304 338 1.992453 6.73449114 Nymphaea colorata 210225 Plants Plants 121 4.5700000000000005e-33   NR XP_031472904.1 210225 g3286 i0 57.3 0.85207100591716 96 41 85.2 0 335 48 5 100 XP_031472904.1 uncharacterized protein LOC116245563 [Nymphaea colorata] diamond 288 121 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
28007865 28007865 PRJNA1263632_P_NODE_3465_length_332_cov_1.482625_g3447_i0 PRJNA1263632 3465 332 1.482625 4.922315 Camellia 4441 Plants Plants 96.3 5.3e-21   NR KAF5932931.1 4442 g3447 i0 53.5 4.66265060240964 86 40 77.7 0 67 324 56 141 KAF5932931.1 hypothetical protein HYC85_029102 [Camellia sinensis] diamond 1548 96.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia sinensis
28652959 28652959 PRJNA1263632_P_NODE_5087_length_280_cov_1.149758_g5069_i0 PRJNA1263632 5087 280 1.149758 3.2193224 Nymphaea colorata 210225 Plants Plants 162 5.459999999999998e-47   NR XP_031472866.1 210225 g5069 i0 80 0.964285714285714 90 18 96.4 0 279 10 224 313 XP_031472866.1 uncharacterized protein LOC116245496 [Nymphaea colorata] diamond 270 162 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
28968751 28968751 PRJNA1263632_P_NODE_7588_length_245_cov_0.895349_g7570_i0 PRJNA1263632 7588 245 0.895349 2.19360505 Nymphaea colorata 210225 Plants Plants 151 4.16e-44   NR XP_031472837.1 210225 g7570 i0 87.7 0.991836734693878 81 10 99.2 0 244 2 107 187 XP_031472837.1 poly [ADP-ribose] polymerase 2 [Nymphaea colorata] diamond 243 151 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
29252588 29252588 PRJNA1263632_P_NODE_6289_length_252_cov_3.569832_g6271_i0 PRJNA1263632 6289 252 3.569832 8.99597664 Hordeum vulgare subsp. vulgare 112509 Plants Plants 66.2 7.93e-11   NR BAK02246.1 112509 g6271 i0 65.5 1.30952380952381 58 19 69 1 3 176 45 101 BAK02246.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 330 66.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
29365439 29365439 PRJNA1263632_P_NODE_8449_length_241_cov_0.916667_g8431_i0 PRJNA1263632 8449 241 0.916667 2.20916747 Streptophyta 35493 Plants Plants 98.6 4.13e-22   NR GMN54664.1 3494 g8431 i0 58.2 9.82157676348548 79 33 98.3 0 238 2 273 351 GMN54664.1 hypothetical protein TIFTF001_023783 [Ficus carica] diamond 2367 99 0.995959595959596 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Moraceae Ficus Ficus carica
29459798 29459798 PRJNA1263632_P_NODE_8150_length_242_cov_0.911243_g8132_i0 PRJNA1263632 8150 242 0.911243 2.20520806 Magnoliopsida 3398 Plants Plants 124 6.76e-34   NR PPD68800.1 3634 g8132 i0 65.8 47.0082644628099 79 27 97.9 0 241 5 13 91 PPD68800.1 hypothetical protein GOBAR_DD34321 [Gossypium barbadense] diamond 11376 124 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium barbadense
30231866 30231866 PRJNA1263632_P_NODE_5652_length_267_cov_1.185567_g5634_i0 PRJNA1263632 5652 267 1.185567 3.16546389 Prosopis alba 207710 Plants Plants 141 8.959999999999999e-40   NR XP_028768962.1 207710 g5634 i0 76.4 11 89 21 100 0 1 267 3 91 XP_028768962.1 40S ribosomal protein S4-like [Prosopis alba] diamond 2937 141 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Neltuma Neltuma alba
31228946 31228946 PRJNA1263632_P_NODE_2695_length_372_cov_1.287625_g2677_i0 PRJNA1263632 2695 372 1.287625 4.789965 Eukaryota 2759 Plants Plants 117 3.12e-29   NR KAJ4701367.1 155640 g2677 i0 54.9 6.88709677419355 122 51 98.4 2 369 4 64 181 KAJ4701367.1 40S ribosomal protein S6 [Melia azedarach] diamond 2562 117 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Meliaceae Melia Melia azedarach
31780526 31780526 PRJNA1263632_P_NODE_5337_length_273_cov_1.895000_g5319_i0 PRJNA1263632 5337 273 1.895 5.17335 Hordeum vulgare subsp. vulgare 112509 Plants Plants 156 1.05e-44   NR BAK02263.1 112509 g5319 i0 82.2 1.97802197802198 90 16 98.9 0 271 2 194 283 BAK02263.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 540 156 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
32431401 32431401 PRJNA1263632_P_NODE_5299_length_274_cov_1.880597_g5281_i0 PRJNA1263632 5299 274 1.880597 5.15283578 Magnoliopsida 3398 Plants Plants 69.7 1.44e-11   NR KAG2278996.1 52824 g5281 i0 39.5 9.0985401459854 86 51 94.2 1 262 5 37 121 KAG2278996.1 hypothetical protein Bca52824_061551 [Brassica carinata] diamond 2493 69.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica carinata
32683726 32683726 PRJNA1263632_P_NODE_8080_length_242_cov_1.798817_g8062_i0 PRJNA1263632 8080 242 1.798817 4.35313714 Opisthokonta 33154 Plants Plants 124 4.849999999999999e-32   NR GBG75744.1 69332 g8062 i0 65.8 15.6446280991736 79 27 97.9 0 240 4 69 147 GBG75744.1 hypothetical protein CBR_g20991 [Chara braunii] diamond 3786 124 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);;