RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJEB11523 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
13706 13706 PRJEB11523_P_NODE_1081_length_570_cov_6.577735_g1005_i0 PRJEB11523 1081 570 6.577735 37.4930895 Penstemon smallii 265156 Plants Plants 78.2 1.6e-15   NR KAL3834214.1 265156 g1005 i0 59.1 0.347368421052632 66 27 34.7 0 178 375 1 66 KAL3834214.1 hypothetical protein ACJIZ3_008950 [Penstemon smallii] diamond 198 78.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Plantaginaceae Penstemon Penstemon smallii
1287982 1287982 PRJEB11523_P_NODE_1042_length_581_cov_34.298872_g966_i0 PRJEB11523 1042 581 34.298872 199.27644632 Eukaryota 2759 Plants Plants 213 2.52e-64   NR NP_194680.1 3702 g966 i0 54 44.4888123924269 176 81 90.9 0 27 554 215 390 NP_194680.1 arginine methyltransferase 11 [Arabidopsis thaliana] diamond 25848 214 0.995327102803738 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
1287984 1287984 PRJEB11523_P_NODE_1122_length_557_cov_22.309055_g1046_i0 PRJEB11523 1122 557 22.309055 124.26143635 Macadamia integrifolia 60698 Plants Plants 120 7.59e-31   NR XP_042506272.1 60698 g1046 i0 55.4 0.845601436265709 157 58 78.6 6 492 55 1 156 XP_042506272.1 uncharacterized protein LOC122082644 [Macadamia integrifolia] diamond 471 120 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Proteales Proteaceae Macadamia Macadamia integrifolia
8635629 8635629 PRJEB11523_P_NODE_2007_length_384_cov_4.011940_g1929_i0 PRJEB11523 2007 384 4.01194 15.4058496 Morus notabilis 981085 Plants Plants 79 1.52e-16   NR EXC32934.1 981085 g1929 i0 71.4 0.3828125 49 14 38.3 0 99 245 14 62 EXC32934.1 hypothetical protein L484_013049 [Morus notabilis] diamond 147 79 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Moraceae Morus Morus notabilis
14041801 14041801 PRJEB11523_P_NODE_3112_length_284_cov_4.434043_g3034_i0 PRJEB11523 3112 284 4.434043 12.59268212 Paspalum notatum var. saurae 547442 Plants Plants 129 1.71e-32   NR WVZ50601.1 547442 g3034 i0 79.2 3.79225352112676 72 15 76.1 0 45 260 903 974 WVZ50601.1 LOW QUALITY PROTEIN: hypothetical protein U9M48_001841 [Paspalum notatum var. saurae] diamond 1077 129 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Paspalum Paspalum notatum
24239628 24239628 PRJEB11523_P_NODE_2240_length_357_cov_6.402597_g2162_i0 PRJEB11523 2240 357 6.402597 22.85727129 Tarenaya hassleriana 28532 Plants Plants 99.8 7.729999999999998e-24   NR XP_010540173.1 28532 g2162 i0 44.7 1.73109243697479 103 48 83.2 3 332 36 59 156 XP_010540173.1 PREDICTED: uncharacterized protein LOC104814026 [Tarenaya hassleriana] diamond 618 99.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Cleomaceae Tarenaya Tarenaya hassleriana
26684426 26684426 PRJEB11523_P_NODE_1861_length_403_cov_2.957627_g1783_i0 PRJEB11523 1861 403 2.957627 11.91923681 Quercus lobata 97700 Plants Plants 52.8 3.22e-5   NR XP_030959259.1 97700 g1783 i0 66.7 0.290322580645161 39 13 29 0 200 316 67 105 XP_030959259.1 ras-related protein SEC4-like [Quercus lobata] diamond 117 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus lobata
27816562 27816562 PRJEB11523_P_NODE_4924_length_212_cov_1.975460_g4846_i0 PRJEB11523 4924 212 1.97546 4.1879752 Magnoliopsida 3398 Plants Plants 90.9 6.110000000000001e-21   NR PON33239.1 3476 g4846 i0 86.4 6.84905660377358 44 6 62.3 0 179 48 138 181 PON33239.1 C2 domain containing protein [Parasponia andersonii] diamond 1452 91.3 0.995618838992333 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Parasponia Parasponia andersonii
27822657 27822657 PRJEB11523_P_NODE_2364_length_343_cov_3.003401_g2286_i0 PRJEB11523 2364 343 3.003401 10.30166543 Prunus mume 102107 Plants Plants 86.3 1.01e-18   NR XP_008224055.1 102107 g2286 i0 52.8 2.3265306122449 89 42 77.8 0 278 12 63 151 XP_008224055.1 PREDICTED: late embryogenesis abundant protein 1 [Prunus mume] diamond 798 86.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus mume
27948794 27948794 PRJEB11523_P_NODE_3645_length_254_cov_27.175610_g3567_i0 PRJEB11523 3645 254 27.17561 69.0260494 Nymphaea colorata 210225 Plants Plants 58.2 4.32e-9   NR VVW89238.1 210225 g3567 i0 92.9 0.330708661417323 28 2 33.1 0 232 149 38 65 VVW89238.1 unnamed protein product, partial [Nymphaea colorata] diamond 84 58.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
28643568 28643568 PRJEB11523_P_NODE_2827_length_302_cov_9.588933_g2749_i0 PRJEB11523 2827 302 9.588933 28.95857766 Ceratopteris richardii 49495 Plants Plants 43.5 0.0379   NR KAH7427296.1 49495 g2749 i0 41.8 0.78476821192053 79 37 75.5 3 24 251 327 399 KAH7427296.1 hypothetical protein KP509_10G038100 [Ceratopteris richardii] diamond 237 43.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
29085568 29085568 PRJEB11523_P_NODE_5768_length_193_cov_1.743056_g5690_i0 PRJEB11523 5768 193 1.743056 3.36409808 Rhamnella rubrinervis 2594499 Plants Plants 41.2 0.00867   NR KAF3442225.1 2594499 g5690 i0 70.3 0.575129533678757 37 9 57.5 2 186 76 25 59 KAF3442225.1 hypothetical protein FNV43_RR16141 [Rhamnella rubrinervis] diamond 111 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rhamnaceae Rhamnella Rhamnella rubrinervis
29117191 29117191 PRJEB11523_P_NODE_749_length_695_cov_63.693498_g684_i0 PRJEB11523 749 695 63.693498 442.6698111 Juncus effusus 13579 Plants Plants 263 6.04e-85   NR KAJ3671790.1 13579 g684 i0 90 0.647482014388489 150 15 64.7 0 22 471 107 256 KAJ3671790.1 hypothetical protein LUZ60_007869 [Juncus effusus] diamond 450 263 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Juncaceae Juncus Juncus effusus
29306352 29306352 PRJEB11523_P_NODE_5909_length_190_cov_2.170213_g5831_i0 PRJEB11523 5909 190 2.170213 4.1234047 Beta vulgaris subsp. vulgaris 3555 Plants Plants 42.4 0.013   NR KMT04641.1 3555 g5831 i0 36.5 0.821052631578947 52 33 82.1 0 3 158 93 144 KMT04641.1 hypothetical protein BVRB_8g182940 [Beta vulgaris subsp. vulgaris] diamond 156 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Chenopodiaceae Beta Beta vulgaris
29621725 29621725 PRJEB11523_P_NODE_8010_length_164_cov_1.773913_g7932_i0 PRJEB11523 8010 164 1.773913 2.90921732 Aegilops tauschii subsp. strangulata 200361 Plants Plants 82.4 3.95e-17   NR XP_045087681.1 200361 g7932 i0 88 1.82926829268293 50 6 91.5 0 163 14 17 66 XP_045087681.1 uncharacterized protein LOC109779513 [Aegilops tauschii subsp. strangulata] diamond 300 82.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Aegilops Aegilops tauschii
30026776 30026776 PRJEB11523_P_NODE_3111_length_284_cov_5.434043_g3033_i0 PRJEB11523 3111 284 5.434043 15.43268212 Magnoliopsida 3398 Plants Plants 81.6 5.47e-17   NR XP_015903064.1 326968 g3033 i0 70.6 4.24647887323944 68 14 66.5 3 282 94 109 175 XP_015903064.1 transcription initiation factor TFIID subunit 9 [Ziziphus jujuba] diamond 1206 81.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rhamnaceae Ziziphus Ziziphus jujuba
30406175 30406175 PRJEB11523_P_NODE_2593_length_322_cov_5.619048_g2515_i0 PRJEB11523 2593 322 5.619048 18.09333456 Eukaryota 2759 Plants Plants 47 0.00308   NR KAK4788674.1 22666 g2515 i0 51.2 5.11490683229814 43 21 40.1 0 22 150 782 824 KAK4788674.1 hypothetical protein SAY86_019993 [Trapa natans] diamond 1647 47.4 0.991561181434599 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Myrtales Lythraceae Trapa Trapa natans
31296618 31296618 PRJEB11523_P_NODE_655_length_745_cov_38.428161_g592_i0 PRJEB11523 655 745 38.428161 286.28979945 Juncus effusus 13579 Plants Plants 230 1.77e-65   NR KAJ3674689.1 13579 g592 i0 69.6 0.914093959731544 227 51 86.2 5 47 688 328 549 KAJ3674689.1 hypothetical protein LUZ60_005305 [Juncus effusus] diamond 681 230 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Juncaceae Juncus Juncus effusus
31929247 31929247 PRJEB11523_P_NODE_397_length_957_cov_11.000000_g341_i0 PRJEB11523 397 957 11 105.27 Penstemon davidsonii 160366 Plants Plants 315 5.6e-104   NR KAK4486638.1 160366 g341 i0 61.8 1.50783699059561 225 85 70.2 1 130 801 43 267 KAK4486638.1 hypothetical protein RD792_006794 [Penstemon davidsonii] diamond 1443 315 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Plantaginaceae Penstemon Penstemon davidsonii
32303170 32303170 PRJEB11523_P_NODE_4499_length_223_cov_2.126437_g4421_i0 PRJEB11523 4499 223 2.126437 4.74195451 Fabaceae 3803 Plants Plants 58.9 5.78e-8   NR KOM29709.1 3914 g4421 i0 58.5 5.81165919282511 41 15 52.5 1 220 104 1099 1139 KOM29709.1 hypothetical protein LR48_Vigan747s001100 [Vigna angularis] diamond 1296 58.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Vigna Vigna angularis
32429515 32429515 PRJEB11523_P_NODE_3079_length_286_cov_2.308017_g3001_i0 PRJEB11523 3079 286 2.308017 6.60092862 Magnoliopsida 3398 Plants Plants 113 4.93e-29   NR KDO53056.1 2711 g3001 i0 84.6 9.75524475524475 65 10 68.2 0 196 2 16 80 KDO53056.1 hypothetical protein CISIN_1g028993mg [Citrus sinensis] diamond 2790 113 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis

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