RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA527965 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
18348437 18348437 PRJNA527965_S_NODE_4455_length_178_cov_3.216783_g4372_i0 PRJNA527965 4455 178 3.216783 5.72587374 Ilex paraguariensis 185542 Plants Plants 127 9.22e-37   NR CAK9163939.1 185542 g4372 i0 94.8 0.97752808988764 58 3 97.8 0 178 5 31 88 CAK9163939.1 unnamed protein product [Ilex paraguariensis] diamond 174 127 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Aquifoliales Aquifoliaceae Ilex Ilex paraguariensis
23449240 23449240 PRJNA527965_S_NODE_2799_length_229_cov_1.072165_g2716_i0 PRJNA527965 2799 229 1.072165 2.45525785 Sphagnum balticum 128184 Plants Plants 134 2.3e-35   NR CAM6002297.1 128184 g2716 i0 85.3 3.93013100436681 75 11 98.3 0 1 225 155 229 CAM6002297.1 unnamed protein product [Sphagnum balticum] diamond 900 134 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
27835370 27835370 PRJNA527965_S_NODE_2404_length_249_cov_4.710280_g2321_i0 PRJNA527965 2404 249 4.71028 11.7285972 Brassica napus 3708 Plants Plants 46.2 2.77e-4   NR CAF2043616.1 3708 g2321 i0 40.9 1.59036144578313 66 39 79.5 0 52 249 13 78 CAF2043616.1 unnamed protein product, partial [Brassica napus] diamond 396 46.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus
28498734 28498734 PRJNA527965_S_NODE_5547_length_159_cov_1.612903_g5464_i0 PRJNA527965 5547 159 1.612903 2.56451577 Sphagnum balticum 128184 Plants Plants 93.6 7.16e-23   NR CAM6001409.1 128184 g5464 i0 83 1 53 9 100 0 159 1 35 87 CAM6001409.1 unnamed protein product [Sphagnum balticum] diamond 159 93.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
28593385 28593385 PRJNA527965_S_NODE_5167_length_165_cov_1.046154_g5084_i0 PRJNA527965 5167 165 1.046154 1.7261541 Prunus brigantina 151428 Plants Plants 56.6 1.92e-8   NR CAL8988986.1 151428 g5084 i0 57.8 1.63636363636364 45 19 81.8 0 11 145 73 117 CAL8988986.1 unnamed protein product [Prunus brigantina] diamond 270 56.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus brigantina
32495630 32495630 PRJNA527965_S_NODE_2739_length_231_cov_3.693878_g2656_i0 PRJNA527965 2739 231 3.693878 8.53285818 Streptophyta 35493 Plants Plants 41.6 0.02   NR RYQ87857.1 3818 g2656 i0 68.8 4.24675324675325 32 10 41.6 0 101 6 64 95 RYQ87857.1 hypothetical protein Ahy_B09g095397 [Arachis hypogaea] diamond 981 41.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Arachis Arachis hypogaea
32606593 32606593 PRJNA527965_S_NODE_4820_length_170_cov_3.666667_g4737_i0 PRJNA527965 4820 170 3.666667 6.2333339 Anisodus tanguticus 243964 Plants Plants 40 0.0403   NR KAK4369403.1 243964 g4737 i0 57.6 0.582352941176471 33 14 58.2 0 133 35 67 99 KAK4369403.1 hypothetical protein RND71_013195 [Anisodus tanguticus] diamond 99 40 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Anisodus Anisodus tanguticus

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