RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA724039" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA724039 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
9639725 9639725 PRJNA724039_S_NODE_5588_length_293_cov_2.113281_g5381_i0 PRJNA724039 5588 293 2.113281 6.19191333 Tanacetum cinerariifolium 118510 Plants Plants 123 2.86e-30   NR GEV46093.1 118510 g5381 i0 68.8 0.982935153583618 96 30 98.3 0 2 289 1360 1455 GEV46093.1 elongation factor G-2, chloroplastic [Tanacetum cinerariifolium] diamond 288 123 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
10122620 10122620 PRJNA724039_S_NODE_10388_length_201_cov_2.445122_g10181_i0 PRJNA724039 10388 201 2.445122 4.91469522 Eukaryota 2759 Plants Plants 100 1.65e-24   NR MQL93400.1 4460 g10181 i0 74.2 13.7910447761194 66 17 98.5 0 200 3 69 134 MQL93400.1 hypothetical protein [Colocasia esculenta] diamond 2772 100 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Alismatales Araceae Colocasia Colocasia esculenta
11397767 11397767 PRJNA724039_S_NODE_17009_length_155_cov_0.949153_g16802_i0 PRJNA724039 17009 155 0.949153 1.47118715 Eukaryota 2759 Plants Plants 78.6 2.13e-15   NR KAJ7563211.1 34168 g16802 i0 84.3 7.89677419354839 51 8 98.7 0 155 3 328 378 KAJ7563211.1 hypothetical protein O6H91_03G101000 [Diphasiastrum complanatum] diamond 1224 78.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Lycopodiales Lycopodiaceae Diphasiastrum Diphasiastrum complanatum
12190333 12190333 PRJNA724039_S_NODE_10250_length_203_cov_1.060241_g10043_i0 PRJNA724039 10250 203 1.060241 2.15228923 Eukaryota 2759 Plants Plants 88.2 2.16e-18   NR RXH72289.1 3750 g10043 i0 72.1 39.8128078817734 61 17 90.1 0 3 185 888 948 RXH72289.1 hypothetical protein DVH24_033827 [Malus domestica] diamond 8082 89 0.991011235955056 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Malus Malus domestica
17289081 17289081 PRJNA724039_S_NODE_12454_length_182_cov_1.579310_g12247_i0 PRJNA724039 12454 182 1.57931 2.8743442 Catharanthus roseus 4058 Plants Plants 76.6 1.84e-14   NR KAI5648452.1 4058 g12247 i0 65 6.92307692307692 60 21 98.9 0 181 2 267 326 KAI5648452.1 hypothetical protein M9H77_34457 [Catharanthus roseus] diamond 1260 76.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Gentianales Apocynaceae Catharanthus Catharanthus roseus
23664087 23664087 PRJNA724039_S_NODE_10879_length_196_cov_1.276730_g10672_i0 PRJNA724039 10879 196 1.27673 2.5023908 Eukaryota 2759 Plants Plants 115 4.99e-28   NR KAH0916634.1 3708 g10672 i0 79.7 45.0612244897959 64 13 98 0 4 195 29 92 KAH0916634.1 hypothetical protein HID58_031080, partial [Brassica napus] diamond 8832 116 0.991379310344828 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus
24145667 24145667 PRJNA724039_S_NODE_15179_length_164_cov_1.354331_g14972_i0 PRJNA724039 15179 164 1.354331 2.22110284 Eukaryota 2759 Plants Plants 92.4 4e-20   NR XP_024535924.1 88036 g14972 i0 79.6 5.92682926829268 54 11 98.8 0 163 2 269 322 XP_024535924.1 uncharacterized protein LOC9630123 [Selaginella moellendorffii] diamond 972 92.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Selaginellales Selaginellaceae Selaginella Selaginella moellendorffii
27347221 27347221 PRJNA724039_S_NODE_17083_length_154_cov_2.478632_g16876_i0 PRJNA724039 17083 154 2.478632 3.81709328 Streptophyta 35493 Plants Plants 94.7 1.9799999999999998e-23   NR KAI5063350.1 13818 g16876 i0 88 6.81818181818182 50 6 97.4 0 3 152 38 87 KAI5063350.1 hypothetical protein GOP47_0021897 [Adiantum capillus-veneris] diamond 1050 94.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Adiantum Adiantum capillus-veneris
27663003 27663003 PRJNA724039_S_NODE_12784_length_179_cov_3.260563_g12577_i0 PRJNA724039 12784 179 3.260563 5.83640777 root 1 Root_unresolved Root_unresolved 83.2 1.77e-18   NR CAM6002648.1 128184 g12577 i0 74.1 3.62011173184358 54 14 90.5 0 4 165 94 147 CAM6002648.1 unnamed protein product [Sphagnum balticum] diamond 648 83.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
27726388 27726388 PRJNA724039_S_NODE_11624_length_189_cov_1.144737_g11417_i0 PRJNA724039 11624 189 1.144737 2.16355293 Eukaryota 2759 Plants Plants 85.5 1.39e-19   NR KAL3691291.1 122646 g11417 i0 71.4 5 63 18 100 0 189 1 37 99 KAL3691291.1 hypothetical protein R1sor_004942 [Riccia sorocarpa] diamond 945 85.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Marchantiopsida Marchantiales Ricciaceae Riccia Riccia sorocarpa
27936778 27936778 PRJNA724039_S_NODE_16665_length_156_cov_1.932773_g16458_i0 PRJNA724039 16665 156 1.932773 3.01512588 Brachiaria hybrid cultivar 680201 Plants Plants 54.7 6.84e-7   NR ACX43954.1 680201 g16458 i0 51 0.980769230769231 51 24 98.1 1 153 1 79 128 ACX43954.1 cysteine protease 1 [Brachiaria hybrid cultivar] diamond 153 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Brachiaria Brachiaria hybrid cultivar
28820400 28820400 PRJNA724039_S_NODE_10668_length_198_cov_1.869565_g10461_i0 PRJNA724039 10668 198 1.869565 3.7017387 Ipomoea batatas 4120 Plants Plants 50.1 3.67e-5   NR GMD66833.1 4120 g10461 i0 61.4 1.24242424242424 44 17 66.7 0 187 56 87 130 GMD66833.1 40S ribosomal protein S24-1 [Ipomoea batatas] diamond 246 50.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Convolvulaceae Ipomoea Ipomoea batatas
29262543 29262543 PRJNA724039_S_NODE_11969_length_186_cov_1.624161_g11762_i0 PRJNA724039 11969 186 1.624161 3.02093946 Zea mays 4577 Plants Plants 44.7 0.00378   NR ONM21081.1 4577 g11762 i0 36.5 2.03225806451613 63 31 95.2 2 10 186 196 253 ONM21081.1 COP1-interacting protein-related [Zea mays] diamond 378 44.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zea Zea mays
29357540 29357540 PRJNA724039_S_NODE_6169_length_275_cov_15.823529_g5962_i0 PRJNA724039 6169 275 15.823529 43.51470475 Rubroshorea leprosula 152421 Plants Plants 53.5 3.17e-6   NR GKV53457.1 152421 g5962 i0 66.7 0.905454545454545 42 14 45.8 0 9 134 123 164 GKV53457.1 hypothetical protein SLEP1_g59979 [Rubroshorea leprosula] diamond 249 53.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Dipterocarpaceae Rubroshorea Rubroshorea leprosula
29389226 29389226 PRJNA724039_S_NODE_9129_length_216_cov_3.368715_g8922_i0 PRJNA724039 9129 216 3.368715 7.2764244 Lotus japonicus 34305 Plants Plants 67.4 4.1e-12   NR AFK38515.1 34305 g8922 i0 45.1 0.986111111111111 71 39 98.6 0 1 213 35 105 AFK38515.1 unknown [Lotus japonicus] diamond 213 67.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lotus Lotus japonicus
29894411 29894411 PRJNA724039_S_NODE_3771_length_370_cov_2.759760_g3564_i0 PRJNA724039 3771 370 2.75976 10.211112 Triticum aestivum 4565 Plants Plants 52.4 4.47e-5   NR XBJ03889.1 4565 g3564 i0 40.2 0.745945945945946 92 51 71.4 3 72 335 79 170 XBJ03889.1 hypothetical protein VPH35_022935 [Triticum aestivum] diamond 276 52.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
29894418 29894418 PRJNA724039_S_NODE_8791_length_221_cov_3.228261_g8584_i0 PRJNA724039 8791 221 3.228261 7.13445681 Solanum lycopersicum 4081 Plants Plants 42.4 0.0137   NR AYE66860.1 4081 g8584 i0 51.1 0.610859728506787 45 22 61.1 0 137 3 27 71 AYE66860.1 hypothetical protein, partial [Solanum lycopersicum] diamond 135 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Solanum Solanum lycopersicum
30083665 30083665 PRJNA724039_S_NODE_1852_length_572_cov_3.014953_g1660_i0 PRJNA724039 1852 572 3.014953 17.24553116 Urochloa decumbens 240449 Plants Plants 92.4 3.68e-19   NR CAL5092093.1 240449 g1660 i0 43.1 2.00874125874126 123 63 64.5 3 433 65 66 181 CAL5092093.1 unnamed protein product [Urochloa decumbens] diamond 1149 92.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Urochloa Urochloa decumbens
30694468 30694468 PRJNA724039_S_NODE_9153_length_216_cov_2.134078_g8946_i0 PRJNA724039 9153 216 2.134078 4.60960848 root 1 Root_unresolved Root_unresolved 136 8.01e-36   NR GEU28239.1 118510 g8946 i0 93 25.6388888888889 71 5 98.6 0 2 214 122 192 GEU28239.1 ribosomal protein S2, chloroplastic [Tanacetum cinerariifolium] diamond 5538 137 0.992700729927007 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
30842212 30842212 PRJNA724039_S_NODE_10194_length_203_cov_5.620482_g9987_i0 PRJNA724039 10194 203 5.620482 11.40957846 Ambrosia artemisiifolia 4212 Plants Plants 42.4 0.03   NR KAI7732304.1 4212 g9987 i0 41.5 0.783251231527094 53 27 78.3 1 172 14 371 419 KAI7732304.1 hypothetical protein M8C21_008104 [Ambrosia artemisiifolia] diamond 159 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Ambrosia Ambrosia artemisiifolia
30968658 30968658 PRJNA724039_S_NODE_17554_length_152_cov_2.860870_g17347_i0 PRJNA724039 17554 152 2.86087 4.3485224 Marchantia polymorpha 3197 Plants Plants 39.7 0.0367   NR PTQ41999.1 3197 g17347 i0 51.2 0.848684210526316 43 19 84.9 1 147 19 31 71 PTQ41999.1 hypothetical protein MARPO_0032s0161 [Marchantia polymorpha] diamond 129 39.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Marchantiopsida Marchantiales Marchantiaceae Marchantia Marchantia polymorpha
32180769 32180769 PRJNA724039_S_NODE_14478_length_168_cov_0.885496_g14271_i0 PRJNA724039 14478 168 0.885496 1.48763328 Streptophyta 35493 Plants Plants 63.2 8.11e-10   NR XP_003571724.1 15368 g14271 i0 51.9 6.75 54 26 96.4 0 3 164 294 347 XP_003571724.1 elongation factor 1-gamma 2 [Brachypodium distachyon] diamond 1134 63.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Brachypodium Brachypodium distachyon

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