RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA749559" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA749559 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
24952480 24952480 PRJNA749559_P_NODE_5020_length_201_cov_0.914286_g4950_i0 PRJNA749559 5020 201 0.914286 1.83771486 Sphagnum compactum 128190 Plants Plants 102 6.3299999999999995e-25   NR CAM6031714.1 128190 g4950 i0 76.9 1.95522388059702 65 15 97 0 5 199 136 200 CAM6031714.1 unnamed protein product, partial [Sphagnum compactum] diamond 393 102 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum compactum
27747955 27747955 PRJNA749559_P_NODE_3044_length_248_cov_1.711230_g2974_i0 PRJNA749559 3044 248 1.71123 4.2438504 Citrus unshiu 55188 Plants Plants 79.3 5.22e-15   NR GAY34710.1 55188 g2974 i0 53.8 2.90322580645161 80 34 94.4 2 14 247 533 611 GAY34710.1 hypothetical protein CUMW_012880 [Citrus unshiu] diamond 720 79.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus unshiu
27915437 27915437 PRJNA749559_P_NODE_3285_length_238_cov_1.446328_g3215_i0 PRJNA749559 3285 238 1.446328 3.44226064 Streptophyta 35493 Plants Plants 72.8 1.64e-13   NR PTQ48915.1 3197 g3215 i0 45.5 6.85714285714286 77 40 97.1 1 5 235 79 153 PTQ48915.1 hypothetical protein MARPO_0004s0172 [Marchantia polymorpha] diamond 1632 72.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Marchantiopsida Marchantiales Marchantiaceae Marchantia Marchantia polymorpha
28325881 28325881 PRJNA749559_P_NODE_3966_length_214_cov_1.143791_g3896_i0 PRJNA749559 3966 214 1.143791 2.44771274 Magnoliopsida 3398 Plants Plants 97.1 1.48e-21   NR KAJ3695967.1 13579 g3896 i0 59.1 11.481308411215 66 27 92.5 0 213 16 277 342 KAJ3695967.1 hypothetical protein LUZ60_001344 [Juncus effusus] diamond 2457 97.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Juncaceae Juncus Juncus effusus
29326351 29326351 PRJNA749559_P_NODE_1669_length_343_cov_1.347518_g1599_i0 PRJNA749559 1669 343 1.347518 4.62198674 Nymphaea colorata 210225 Plants Plants 137 6.29e-39   NR VVW86319.1 210225 g1599 i0 60.4 5.82507288629738 111 44 97.1 0 338 6 1 111 VVW86319.1 unnamed protein product, partial [Nymphaea colorata] diamond 1998 137 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
31348475 31348475 PRJNA749559_P_NODE_3596_length_227_cov_1.156627_g3526_i0 PRJNA749559 3596 227 1.156627 2.62554329 Eragrostis curvula 38414 Plants Plants 53.5 4.54e-6   NR TVU50040.1 38414 g3526 i0 36 2.49779735682819 75 48 99.1 0 226 2 17 91 TVU50040.1 hypothetical protein EJB05_01394, partial [Eragrostis curvula] diamond 567 53.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Eragrostis Eragrostis curvula
31822625 31822625 PRJNA749559_P_NODE_3677_length_224_cov_1.539877_g3607_i0 PRJNA749559 3677 224 1.539877 3.44932448 Quillaja saponaria 32244 Plants Plants 73.2 3.58e-13   NR KAJ7947068.1 32244 g3607 i0 53.6 2.79910714285714 69 32 92.4 0 224 18 212 280 KAJ7947068.1 Cysteine Protease [Quillaja saponaria] diamond 627 73.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Quillajaceae Quillaja Quillaja saponaria
32676355 32676355 PRJNA749559_P_NODE_3080_length_246_cov_3.367568_g3010_i0 PRJNA749559 3080 246 3.367568 8.28421728 Sphagnum balticum 128184 Plants Plants 100 9.06e-25   NR CAM6005785.1 128184 g3010 i0 72.7 1.64634146341463 66 18 80.5 0 48 245 8 73 CAM6005785.1 unnamed protein product [Sphagnum balticum] diamond 405 100 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum

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