RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA771359 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
4575316 4575316 PRJNA771359_S_NODE_264_length_569_cov_2.601504_g191_i0 PRJNA771359 264 569 2.601504 14.80255776 Streptophyta 35493 Plants Plants 226 6.739999999999999e-72   NR XP_024385696.1 3218 g191 i0 73.1 44.7100175746924 160 43 84.4 0 1 480 14 173 XP_024385696.1 60S ribosomal protein L19-3-like [Physcomitrium patens] diamond 25440 226 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Funariales Funariaceae Physcomitrium Physcomitrium patens
8400241 8400241 PRJNA771359_S_NODE_1947_length_237_cov_1.920000_g1864_i0 PRJNA771359 1947 237 1.92 4.5504 Eukaryota 2759 Plants Plants 92.8 6.170000000000001e-21   NR KAH9625905.1 39905 g1864 i0 69.2 23.6962025316456 52 16 65.8 0 1 156 194 245 KAH9625905.1 hypothetical protein KSS87_023425 [Heliosperma pusillum] diamond 5616 93.6 0.991452991452991 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Caryophyllaceae Heliosperma Heliosperma pusillum
16049656 16049656 PRJNA771359_S_NODE_393_length_479_cov_1.712670_g315_i0 PRJNA771359 393 479 1.71267 8.2036893 Streptophyta 35493 Plants Plants 169 2.25e-50   NR KAG0590150.1 3225 g315 i0 58.4 19.6033402922756 149 59 93.3 2 479 33 12 157 KAG0590150.1 hypothetical protein KC19_1G076400 [Ceratodon purpureus] diamond 9390 169 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Pseudoditrichales Ditrichaceae Ceratodon Ceratodon purpureus
18598784 18598784 PRJNA771359_S_NODE_2115_length_229_cov_2.687500_g2032_i0 PRJNA771359 2115 229 2.6875 6.154375 Picea mariana 3335 Plants Plants 124 1.02e-33   NR O65082.1 3335 g2032 i0 85.3 19.6506550218341 75 11 98.3 0 227 3 31 105 O65082.1 RecName: Full=Large ribosomal subunit protein eL15y; AltName: Full=60S ribosomal protein L15-2 [Picea mariana] diamond 4500 124 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea mariana
23700027 23700027 PRJNA771359_S_NODE_4559_length_159_cov_1.590164_g4476_i0 PRJNA771359 4559 159 1.590164 2.52836076 Streptophyta 35493 Plants Plants 99 2.81e-23   NR BAJ98689.1 112509 g4476 i0 94.1 2.90566037735849 51 3 96.2 0 154 2 110 160 BAJ98689.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 462 99.4 0.995975855130785 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
26619644 26619644 PRJNA771359_S_NODE_4361_length_162_cov_2.176000_g4278_i0 PRJNA771359 4361 162 2.176 3.52512 Malvales 41938 Plants Plants 44.3 0.00138   NR GLT77624.1 152420 g4278 i0 65.6 2.37037037037037 32 11 59.3 0 13 108 46 77 GLT77624.1 hypothetical protein SLA2020_491920 [Shorea laevis] diamond 384 44.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Dipterocarpaceae Shorea Shorea laevis
27274592 27274592 PRJNA771359_S_NODE_2983_length_194_cov_1.949045_g2900_i0 PRJNA771359 2983 194 1.949045 3.7811473 Linum trigynum 586398 Plants Plants 100 3.389999999999999e-23   NR CAL1394758.1 586398 g2900 i0 75 1.97938144329897 64 16 99 0 1 192 201 264 CAL1394758.1 unnamed protein product [Linum trigynum] diamond 384 100 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Linaceae Linum Linum trigynum
27631638 27631638 PRJNA771359_S_NODE_2344_length_219_cov_2.747253_g2261_i0 PRJNA771359 2344 219 2.747253 6.01648407 Magnoliopsida 3398 Plants Plants 103 1.53e-26   NR GMN33601.1 3494 g2261 i0 73 54.2739726027397 63 17 86.3 0 218 30 49 111 GMN33601.1 hypothetical protein TIFTF001_004254 [Ficus carica] diamond 11886 104 0.990384615384615 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Moraceae Ficus Ficus carica
28421071 28421071 PRJNA771359_S_NODE_1086_length_319_cov_1.421986_g1003_i0 PRJNA771359 1086 319 1.421986 4.53613534 Eukaryota 2759 Plants Plants 134 5.079999999999998e-35   NR KAF2302395.1 3981 g1003 i0 72 37.8056426332288 93 23 84.6 1 2 271 305 397 KAF2302395.1 hypothetical protein GH714_036161 [Hevea brasiliensis] diamond 12060 135 0.992592592592593 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Hevea Hevea brasiliensis
29715072 29715072 PRJNA771359_S_NODE_3050_length_192_cov_2.548387_g2967_i0 PRJNA771359 3050 192 2.548387 4.89290304 Magnoliopsida 3398 Plants Plants 56.6 3.47e-8   NR XP_030507550.1 3483 g2967 i0 80.6 12.015625 31 6 48.4 0 3 95 74 104 XP_030507550.1 small ribosomal subunit protein eS26x [Cannabis sativa] diamond 2307 56.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
30021864 30021864 PRJNA771359_S_NODE_2511_length_211_cov_2.212644_g2428_i0 PRJNA771359 2511 211 2.212644 4.66867884 Hordeum vulgare subsp. vulgare 112509 Plants Plants 85.9 6.08e-20   NR BAK02400.1 112509 g2428 i0 66.7 0.853080568720379 60 20 85.3 0 209 30 37 96 BAK02400.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 180 85.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
30147840 30147840 PRJNA771359_S_NODE_4132_length_166_cov_2.387597_g4049_i0 PRJNA771359 4132 166 2.387597 3.96341102 Lotus japonicus 34305 Plants Plants 77 5.58e-15   NR AFK37198.1 34305 g4049 i0 73.1 5.81927710843374 52 14 94 0 7 162 107 158 AFK37198.1 unknown [Lotus japonicus] diamond 966 77 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lotus Lotus japonicus
30631403 30631403 PRJNA771359_S_NODE_1133_length_313_cov_1.931159_g1050_i0 PRJNA771359 1133 313 1.931159 6.04452767 Magnoliopsida 3398 Plants Plants 141 2.3e-36   NR RZC54608.1 3469 g1050 i0 69.5 39.1341853035144 105 31 99.7 1 2 313 91 195 RZC54608.1 hypothetical protein C5167_013451 [Papaver somniferum] diamond 12249 142 0.992957746478873 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Papaveraceae Papaver Papaver somniferum
30694733 30694733 PRJNA771359_S_NODE_4913_length_154_cov_1.632479_g4830_i0 PRJNA771359 4913 154 1.632479 2.51401766 Eukaryota 2759 Plants Plants 69.3 5.97e-13   NR AFK43985.1 34305 g4830 i0 60.8 2.98051948051948 51 20 99.4 0 154 2 97 147 AFK43985.1 unknown [Lotus japonicus] diamond 459 69.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lotus Lotus japonicus
31033036 31033036 PRJNA771359_S_NODE_4035_length_168_cov_1.480916_g3952_i0 PRJNA771359 4035 168 1.480916 2.48793888 Melastoma candidum 119954 Plants Plants 80.1 6.58e-17   NR KAI4341126.1 119954 g3952 i0 73.2 4 56 15 100 0 168 1 27 82 KAI4341126.1 hypothetical protein MLD38_025886 [Melastoma candidum] diamond 672 80.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Myrtales Melastomataceae Melastoma Melastoma candidum
31390225 31390225 PRJNA771359_S_NODE_1316_length_295_cov_3.275194_g1233_i0 PRJNA771359 1316 295 3.275194 9.6618223 Riccia 41843 Plants Plants 102 7.28e-25   NR KAL2634571.1 41844 g1233 i0 59.1 6.64067796610169 93 38 94.6 0 291 13 99 191 KAL2634571.1 hypothetical protein R1flu_006050 [Riccia fluitans] diamond 1959 103 0.990291262135922 Eukaryota Embryophyta Viridiplantae Streptophyta Marchantiopsida Marchantiales Ricciaceae Riccia Riccia fluitans
31674576 31674576 PRJNA771359_S_NODE_2757_length_202_cov_1.648485_g2674_i0 PRJNA771359 2757 202 1.648485 3.3299397 Streptophyta 35493 Plants Plants 82 1.15e-17   NR KAH7294285.1 49495 g2674 i0 63.5 5.61386138613861 63 23 93.6 0 2 190 100 162 KAH7294285.1 hypothetical protein KP509_28G064000 [Ceratopteris richardii] diamond 1134 82 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
31706333 31706333 PRJNA771359_S_NODE_1677_length_259_cov_1.734234_g1594_i0 PRJNA771359 1677 259 1.734234 4.49166606 Eukaryota 2759 Plants Plants 126 3.94e-35   NR NP_001365255.1 3218 g1594 i0 70.9 27.8918918918919 86 25 99.6 0 2 259 7 92 NP_001365255.1 40S ribosomal protein S24-1 [Physcomitrium patens] diamond 7224 126 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Funariales Funariaceae Physcomitrium Physcomitrium patens
31823160 31823160 PRJNA771359_S_NODE_4377_length_162_cov_1.216000_g4294_i0 PRJNA771359 4377 162 1.216 1.96992 Nymphaea colorata 210225 Plants Plants 80.5 6.79e-18   NR XP_031505839.1 210225 g4294 i0 100 0.833333333333333 45 0 83.3 0 161 27 70 114 XP_031505839.1 uncharacterized protein LOC116268258 [Nymphaea colorata] diamond 135 80.5 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);;