RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA753112" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA753112 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
2005060 2005060 PRJNA753112_P_NODE_2642_length_843_cov_1.868831_g2344_i0 PRJNA753112 2642 843 1.868831 15.75424533 Tanacetum cinerariifolium 118510 Plants Plants 345 1.3099999999999999e-104   NR GEU28059.1 118510 g2344 i0 66.7 0.97153024911032 273 44 97.2 1 843 25 2440 2665 GEU28059.1 translation initiation factor IF-2, chloroplastic [Tanacetum cinerariifolium] diamond 819 345 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
2005324 2005324 PRJNA753112_P_NODE_9762_length_434_cov_3.193906_g9420_i0 PRJNA753112 9762 434 3.193906 13.86155204 Sphagnum balticum 128184 Plants Plants 204 9.85e-65   NR CAM6005785.1 128184 g9420 i0 75.8 1.79032258064516 128 31 88.5 0 386 3 8 135 CAM6005785.1 unnamed protein product [Sphagnum balticum] diamond 777 204 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
2476782 2476782 PRJNA753112_P_NODE_1062_length_1372_cov_4.363356_g874_i0 PRJNA753112 1062 1372 4.363356 59.86524432 Tanacetum cinerariifolium 118510 Plants Plants 738 1.1599999999999994e-238   NR GEU28371.1 118510 g874 i0 81.7 1.0036443148688 459 59 99.9 2 2 1372 8188 8623 GEU28371.1 adenylosuccinate synthetase 2, chloroplastic [Tanacetum cinerariifolium] diamond 1377 738 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
4557241 4557241 PRJNA753112_P_NODE_1504_length_1127_cov_5.809298_g1282_i0 PRJNA753112 1504 1127 5.809298 65.47078846 Tanacetum cinerariifolium 118510 Plants Plants 272 8.56e-78   NR GEU28248.1 118510 g1282 i0 67 0.620230700976043 233 68 59.6 2 1 672 1954 2186 GEU28248.1 threonine--tRNA ligase, chloroplastic/mitochondrial 2 [Tanacetum cinerariifolium] diamond 699 272 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
4557370 4557370 PRJNA753112_P_NODE_22264_length_288_cov_2.032558_g21922_i0 PRJNA753112 22264 288 2.032558 5.85376704 Eukaryota 2759 Plants Plants 130 1.39e-35   NR NP_192132.1 3702 g21922 i0 66 28.4479166666667 94 32 97.9 0 283 2 3 96 NP_192132.1 Ribosomal protein L19e family protein [Arabidopsis thaliana] diamond 8193 130 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
17306921 17306921 PRJNA753112_P_NODE_1554_length_1109_cov_3.051158_g1330_i0 PRJNA753112 1554 1109 3.051158 33.83734222 Tanacetum cinerariifolium 118510 Plants Plants 307 4.769999999999999e-90   NR GEU28496.1 118510 g1330 i0 59 0.692515779981966 256 68 69.3 1 1105 338 516 734 GEU28496.1 hypothetical protein [Tanacetum cinerariifolium] diamond 768 307 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
27125553 27125553 PRJNA753112_P_NODE_10742_length_414_cov_1.372434_g10400_i0 PRJNA753112 10742 414 1.372434 5.68187676 Magnoliopsida 3398 Plants Plants 84.7 3.99e-16   NR PWZ12094.1 4577 g10400 i0 36.7 13.5652173913043 128 78 92.8 2 5 388 56 180 PWZ12094.1 Urease accessory protein G [Zea mays] diamond 5616 85.1 0.995299647473561 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zea Zea mays
27905458 27905458 PRJNA753112_P_NODE_16505_length_334_cov_1.754789_g16163_i0 PRJNA753112 16505 334 1.754789 5.86099526 Marsilea vestita 59764 Plants Plants 75.1 4.01e-13   NR AFN42825.1 59764 g16163 i0 38.5 2.91017964071856 104 61 93.4 1 314 3 219 319 AFN42825.1 vacuolar-type H pump pyrophosphatase-like protein, partial [Marsilea vestita] diamond 972 75.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Salviniales Marsileaceae Marsilea Marsilea vestita
28568725 28568725 PRJNA753112_P_NODE_33967_length_239_cov_2.349398_g33625_i0 PRJNA753112 33967 239 2.349398 5.61506122 Lactuca sativa 4236 Plants Plants 97.4 3.47e-24   NR KAJ0201537.1 4236 g33625 i0 100 1.85774058577406 45 0 56.5 0 33 167 64 108 KAJ0201537.1 hypothetical protein LSAT_V11C600333910 [Lactuca sativa] diamond 444 97.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lactuca Lactuca sativa
28695293 28695293 PRJNA753112_P_NODE_29507_length_251_cov_1.421348_g29165_i0 PRJNA753112 29507 251 1.421348 3.56758348 Physcomitrium patens 3218 Plants Plants 75.9 8.4e-14   NR XP_024382602.1 3218 g29165 i0 46.1 0.908366533864542 76 35 90.8 2 2 229 279 348 XP_024382602.1 low-temperature-induced cysteine proteinase-like [Physcomitrium patens] diamond 228 75.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Funariales Funariaceae Physcomitrium Physcomitrium patens
30210624 30210624 PRJNA753112_P_NODE_23412_length_282_cov_0.966507_g23070_i0 PRJNA753112 23412 282 0.966507 2.72554974 Trifolium medium 97028 Plants Plants 40.4 0.0484   NR MCI51886.1 97028 g23070 i0 38.5 0.553191489361702 52 23 45.7 1 199 71 5 56 MCI51886.1 hypothetical protein [Trifolium medium] diamond 156 40.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium medium
31380225 31380225 PRJNA753112_P_NODE_28436_length_254_cov_1.955801_g28094_i0 PRJNA753112 28436 254 1.955801 4.96773454 Helianthus annuus 4232 Plants Plants 43.5 0.0232   NR KAJ0483299.1 4232 g28094 i0 34.4 1.48818897637795 64 31 63.8 3 91 252 907 969 KAJ0483299.1 putative RNA-directed DNA polymerase [Helianthus annuus] diamond 378 43.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Helianthus Helianthus annuus
32212539 32212539 PRJNA753112_P_NODE_25018_length_272_cov_2.005025_g24676_i0 PRJNA753112 25018 272 2.005025 5.453668 Magnoliopsida 3398 Plants Plants 79.7 5.16e-17   NR GAA0142781.1 34254 g24676 i0 50.7 9.13235294117647 75 36 81.6 1 2 223 30 104 GAA0142781.1 ribosomal protein [Lithospermum erythrorhizon] diamond 2484 79.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Boraginales Boraginaceae Lithospermum Lithospermum erythrorhizon
32234523 32234523 PRJNA753112_P_NODE_8718_length_461_cov_1.592784_g8376_i0 PRJNA753112 8718 461 1.592784 7.34273424 Nymphaea colorata 210225 Plants Plants 147 2.5899999999999998e-42   NR XP_031472781.1 210225 g8376 i0 53.5 0.924078091106291 142 62 89.8 1 434 21 6 147 XP_031472781.1 LOW QUALITY PROTEIN: uncharacterized protein LOC116245286 [Nymphaea colorata] diamond 426 147 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
32613676 32613676 PRJNA753112_P_NODE_32440_length_244_cov_3.333333_g32098_i0 PRJNA753112 32440 244 3.333333 8.13333252 Lactuca virosa 75947 Plants Plants 115 2.2799999999999997e-31   NR CAH1427772.1 75947 g32098 i0 100 0.700819672131147 57 0 70.1 0 74 244 1 57 CAH1427772.1 unnamed protein product [Lactuca virosa] diamond 171 115 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lactuca Lactuca virosa
32623404 32623404 PRJNA753112_P_NODE_12560_length_382_cov_1.653722_g12218_i0 PRJNA753112 12560 382 1.653722 6.31721804 root 1 Root_unresolved Root_unresolved 140 1.34e-39   NR VVW89318.1 210225 g12218 i0 56.3 3.94240837696335 126 55 99 0 382 5 7 132 VVW89318.1 unnamed protein product [Nymphaea colorata] diamond 1506 140 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
32654657 32654657 PRJNA753112_P_NODE_13240_length_373_cov_1.300000_g12898_i0 PRJNA753112 13240 373 1.3 4.849 root 1 Root_unresolved Root_unresolved 45.1 0.0248   NR RLM86681.1 4540 g12898 i0 33.8 4.4798927613941 80 42 55.5 1 306 100 341 420 RLM86681.1 hypothetical protein C2845_PM04G04080 [Panicum miliaceum] diamond 1671 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Panicum Panicum miliaceum

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