RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA826497" 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

  • PRJNA826497 · 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
9748641 9748641 PRJNA826497_S_NODE_1528_length_303_cov_7.185185_g1488_i0 PRJNA826497 1528 303 7.185185 21.77111055 Poaceae 4479 Plants Plants 145 6.149999999999998e-41   NR KAG0549180.1 4558 g1488 i0 70 4.95049504950495 100 30 99 0 3 302 120 219 KAG0549180.1 hypothetical protein BDA96_01G233200 [Sorghum bicolor] diamond 1500 146 0.993150684931507 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Sorghum Sorghum bicolor
12299826 12299826 PRJNA826497_S_NODE_1550_length_302_cov_10.498141_g1510_i0 PRJNA826497 1550 302 10.498141 31.70438582 Asteraceae 4210 Plants Plants 157 2.98e-43   NR XP_043617407.1 72917 g1510 i0 87.2 14.8807947019868 94 12 93.4 0 282 1 417 510 XP_043617407.1 sucrose transport protein-like [Erigeron canadensis] diamond 4494 157 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Erigeron Erigeron canadensis
13574194 13574194 PRJNA826497_S_NODE_4771_length_230_cov_2.512690_g4731_i0 PRJNA826497 4771 230 2.51269 5.779187 Taxus chinensis 29808 Plants Plants 100 2.03e-22   NR KAH9316782.1 29808 g4731 i0 68.1 0.939130434782609 72 23 93.9 0 1 216 1056 1127 KAH9316782.1 hypothetical protein KI387_044020 [Taxus chinensis] diamond 216 100 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
24179867 24179867 PRJNA826497_S_NODE_3779_length_244_cov_2.530806_g3739_i0 PRJNA826497 3779 244 2.530806 6.17516664 Streptophyta 35493 Plants Plants 114 1.42e-29   NR KAJ7536280.1 34168 g3739 i0 64.6 12.405737704918 82 27 98.4 1 240 1 56 137 KAJ7536280.1 hypothetical protein O6H91_12G063100 [Diphasiastrum complanatum] diamond 3027 114 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Lycopodiales Lycopodiaceae Diphasiastrum Diphasiastrum complanatum
26864917 26864917 PRJNA826497_S_NODE_4961_length_227_cov_19.453608_g4921_i0 PRJNA826497 4961 227 19.453608 44.15969016 Trifolium subterraneum 3900 Plants Plants 84.7 4.96e-17   NR GAU24519.1 3900 g4921 i0 69.8 4.16299559471366 63 15 78 1 20 196 21 83 GAU24519.1 hypothetical protein TSUD_156310 [Trifolium subterraneum] diamond 945 84.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium subterraneum
27244110 27244110 PRJNA826497_S_NODE_1223_length_321_cov_12.843750_g1183_i0 PRJNA826497 1223 321 12.84375 41.2284375 Picea sitchensis 3332 Plants Plants 145 8.53e-39   NR ABK25130.1 3332 g1183 i0 73.9 0.85981308411215 92 24 86 0 42 317 246 337 ABK25130.1 unknown [Picea sitchensis] diamond 276 145 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
28294799 28294799 PRJNA826497_S_NODE_14066_length_168_cov_10.577778_g14026_i0 PRJNA826497 14066 168 10.577778 17.77066704 Magnoliopsida 3398 Plants Plants 55.5 4.32e-7   NR CAD5331326.1 3702 g14026 i0 52.1 6.94642857142857 48 23 85.7 0 9 152 849 896 CAD5331326.1 unnamed protein product [Arabidopsis thaliana] diamond 1167 55.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
28380895 28380895 PRJNA826497_S_NODE_15946_length_162_cov_2.550388_g15906_i0 PRJNA826497 15946 162 2.550388 4.13162856 Medicago truncatula 3880 Plants Plants 85.5 6.83e-20   NR XP_039683326.1 3880 g15906 i0 92 0.925925925925926 50 4 92.6 0 2 151 48 97 XP_039683326.1 uncharacterized protein LOC112417073 isoform X2 [Medicago truncatula] diamond 150 85.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Medicago Medicago truncatula
28728272 28728272 PRJNA826497_S_NODE_6347_length_213_cov_4.011111_g6307_i0 PRJNA826497 6347 213 4.011111 8.54366643 Humulus lupulus 3486 Plants Plants 105 9.12e-26   NR XP_062112397.1 3486 g6307 i0 71 1.94366197183099 69 20 97.2 0 212 6 150 218 XP_062112397.1 uncharacterized protein LOC133823577 isoform X1 [Humulus lupulus] diamond 414 105 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Humulus Humulus lupulus
29273447 29273447 PRJNA826497_S_NODE_17089_length_158_cov_7.368000_g17049_i0 PRJNA826497 17089 158 7.368 11.64144 Oleaceae 4144 Plants Plants 62.4 1.1e-9   NR CAI9770229.1 56036 g17049 i0 54.9 2.90506329113924 51 22 94.9 1 156 7 235 285 CAI9770229.1 unnamed protein product [Fraxinus pennsylvanica] diamond 459 62.8 0.993630573248408 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Fraxinus Fraxinus pennsylvanica
29391410 29391410 PRJNA826497_S_NODE_13429_length_171_cov_3.659420_g13389_i0 PRJNA826497 13429 171 3.65942 6.2576082 Olea europaea subsp. europaea 158383 Plants Plants 57 1.5e-8   NR CAA3004356.1 158383 g13389 i0 47.4 1 57 29 100 1 171 1 12 67 CAA3004356.1 Hypothetical predicted protein, partial [Olea europaea subsp. europaea] diamond 171 57 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
29391413 29391413 PRJNA826497_S_NODE_18089_length_155_cov_7.418033_g18049_i0 PRJNA826497 18089 155 7.418033 11.49795115 Hordeum vulgare 4513 Plants Plants 111 8.21e-27   NR KAE8811722.1 4513 g18049 i0 98 0.987096774193548 51 1 98.7 0 155 3 646 696 KAE8811722.1 hypothetical protein D1007_11522 [Hordeum vulgare] diamond 153 111 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
29422632 29422632 PRJNA826497_S_NODE_10189_length_186_cov_2.816993_g10149_i0 PRJNA826497 10189 186 2.816993 5.23960698 Klebsormidium nitens 105231 Plants Plants 53.5 2.03e-6   NR GAQ89198.1 105231 g10149 i0 96 0.403225806451613 25 1 40.3 0 2 76 224 248 GAQ89198.1 chloroplastic PPL1 PsbP-like protein 1 [Klebsormidium nitens] diamond 75 53.5 1 Eukaryota   Viridiplantae Streptophyta Klebsormidiophyceae Klebsormidiales Klebsormidiaceae Klebsormidium Klebsormidium nitens
29770032 29770032 PRJNA826497_S_NODE_6291_length_213_cov_12.355556_g6251_i0 PRJNA826497 6291 213 12.355556 26.31733428 Trifolium pratense 57577 Plants Plants 43.9 0.00944   NR PNX89523.1 57577 g6251 i0 36.5 0.887323943661972 63 39 88.7 1 24 212 10 71 PNX89523.1 hypothetical protein L195_g045643, partial [Trifolium pratense] diamond 189 43.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium pratense
29959649 29959649 PRJNA826497_S_NODE_6171_length_215_cov_2.153846_g6131_i0 PRJNA826497 6171 215 2.153846 4.6307689 Telopea speciosissima 54955 Plants Plants 86.7 1.43e-19   NR XP_043695672.1 54955 g6131 i0 64.3 1.53488372093023 56 20 78.1 0 48 215 60 115 XP_043695672.1 secreted RxLR effector protein 161-like [Telopea speciosissima] diamond 330 86.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Proteales Proteaceae Telopea Telopea speciosissima
30085973 30085973 PRJNA826497_S_NODE_8912_length_194_cov_1.962733_g8872_i0 PRJNA826497 8912 194 1.962733 3.80770202 Medicago truncatula 3880 Plants Plants 66.6 3.01e-11   NR XP_024632722.1 3880 g8872 i0 73.8 1.29896907216495 42 11 64.9 0 67 192 94 135 XP_024632722.1 uncharacterized protein LOC112419352 [Medicago truncatula] diamond 252 66.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Medicago Medicago truncatula
30094555 30094555 PRJNA826497_S_NODE_6112_length_215_cov_7.587912_g6072_i0 PRJNA826497 6112 215 7.587912 16.3140108 Brassicaceae 3700 Plants Plants 73.6 1.78e-14   NR KFK32322.1 50452 g6072 i0 47.1 6.83720930232558 70 36 96.3 1 210 4 64 133 KFK32322.1 hypothetical protein AALP_AA6G226700 [Arabis alpina] diamond 1470 73.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabis Arabis alpina
30465518 30465518 PRJNA826497_S_NODE_1753_length_293_cov_5.788462_g1713_i0 PRJNA826497 1753 293 5.788462 16.96019366 Hordeum vulgare 4513 Plants Plants 55.8 3.29e-7   NR KAI5015768.1 4513 g1713 i0 79.4 0.348122866894198 34 7 34.8 0 178 77 113 146 KAI5015768.1 hypothetical protein ZWY2020_057158 [Hordeum vulgare] diamond 102 55.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
30559753 30559753 PRJNA826497_S_NODE_15913_length_162_cov_3.062016_g15873_i0 PRJNA826497 15913 162 3.062016 4.96046592 Cinnamomum micranthum f. kanehirae 337451 Plants Plants 63.9 5.01e-11   NR RWR89946.1 337451 g15873 i0 63 8.92592592592593 46 16 85.2 1 142 5 80 124 RWR89946.1 cytochrome c oxidase subunit 6b-1-like protein [Cinnamomum micranthum f. kanehirae] diamond 1446 63.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Laurales Lauraceae Cinnamomum Cinnamomum micranthum
30591549 30591549 PRJNA826497_S_NODE_2953_length_259_cov_8.969027_g2913_i0 PRJNA826497 2953 259 8.969027 23.22977993 Medicago truncatula 3880 Plants Plants 42 0.0234   NR KEH35432.1 3880 g2913 i0 57.6 0.382239382239382 33 14 38.2 0 6 104 65 97 KEH35432.1 hypothetical protein MTR_3g090635 [Medicago truncatula] diamond 99 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Medicago Medicago truncatula
30600106 30600106 PRJNA826497_S_NODE_2413_length_272_cov_12.410042_g2373_i0 PRJNA826497 2413 272 12.410042 33.75531424 Trifolium 3898 Plants Plants 112 1.72e-26   NR WJX80398.1 3899 g2373 i0 58 4.48897058823529 81 29 89.3 1 11 253 696 771 WJX80398.1 hypothetical protein P8452_63402 [Trifolium repens] diamond 1221 113 0.991150442477876 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium repens
30623017 30623017 PRJNA826497_S_NODE_14253_length_168_cov_2.103704_g14213_i0 PRJNA826497 14253 168 2.103704 3.53422272 Trifolium pratense 57577 Plants Plants 40.8 0.0244   NR CAJ2656812.1 57577 g14213 i0 68.2 0.785714285714286 22 7 39.3 0 1 66 67 88 CAJ2656812.1 unnamed protein product [Trifolium pratense] diamond 132 40.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium pratense
30907735 30907735 PRJNA826497_S_NODE_7574_length_202_cov_19.260355_g7534_i0 PRJNA826497 7574 202 19.260355 38.9059171 Medicago truncatula 3880 Plants Plants 99.8 1.81e-22   NR ABN08564.1 3880 g7534 i0 68.2 0.98019801980198 66 21 98 0 200 3 308 373 ABN08564.1 RNA-directed DNA polymerase (Reverse transcriptase) [Medicago truncatula] diamond 198 99.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Medicago Medicago truncatula
31255108 31255108 PRJNA826497_S_NODE_5015_length_227_cov_3.644330_g4975_i0 PRJNA826497 5015 227 3.64433 8.2726291 Oryza sativa Japonica Group 39947 Plants Plants 43.1 0.0215   NR XP_025877327.1 39947 g4975 i0 51.3 1.61233480176211 39 19 51.5 0 72 188 256 294 XP_025877327.1 uncharacterized protein [Oryza sativa Japonica Group] diamond 366 43.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
32457461 32457461 PRJNA826497_S_NODE_8059_length_199_cov_4.271084_g8019_i0 PRJNA826497 8059 199 4.271084 8.49945716 Prunus brigantina 151428 Plants Plants 42.4 0.0139   NR CAL8988667.1 151428 g8019 i0 41.7 3.25628140703518 72 30 90.5 2 4 183 2 73 CAL8988667.1 unnamed protein product [Prunus brigantina] diamond 648 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus brigantina
32655023 32655023 PRJNA826497_S_NODE_13720_length_170_cov_2.642336_g13680_i0 PRJNA826497 13720 170 2.642336 4.4919712 Magnoliopsida 3398 Plants Plants 76.3 2.11e-14   NR KAL2346659.1 520843 g13680 i0 54.5 4.00588235294118 66 18 95.3 1 7 168 514 579 KAL2346659.1 hypothetical protein Fmac_000659 [Flemingia macrophylla] diamond 681 76.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Flemingia Flemingia macrophylla
32709620 32709620 PRJNA826497_S_NODE_12640_length_174_cov_6.290780_g12600_i0 PRJNA826497 12640 174 6.29078 10.9459572 Senna tora 362788 Plants Plants 54.3 1.19e-6   NR KAF7840333.1 362788 g12600 i0 45.8 0.827586206896552 48 25 81 1 145 5 286 333 KAF7840333.1 ervatamin-B-like [Senna tora] diamond 144 54.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Senna Senna tora
32867072 32867072 PRJNA826497_S_NODE_4740_length_230_cov_4.649746_g4700_i0 PRJNA826497 4740 230 4.649746 10.6944158 Heracleum sosnowskyi 360622 Plants Plants 53.9 1.08e-6   NR KAK1386965.1 360622 g4700 i0 84.6 0.339130434782609 26 4 33.9 0 228 151 135 160 KAK1386965.1 hypothetical protein POM88_015143 [Heracleum sosnowskyi] diamond 78 53.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Heracleum Heracleum sosnowskyi

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