RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA658591" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA658591 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
10829709 10829709 PRJNA658591_S_NODE_2069_length_293_cov_4.737705_g2006_i0 PRJNA658591 2069 293 4.737705 13.88147565 Eukaryota 2759 Plants Plants 148 5.469999999999999e-42   NR XP_023536739.1 3664 g2006 i0 86.7 122.150170648464 83 11 85 0 2 250 170 252 XP_023536739.1 14-3-3-like protein GF14 iota [Cucurbita pepo subsp. pepo] diamond 35790 149 0.993288590604027 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Cucurbita Cucurbita pepo
14654440 14654440 PRJNA658591_S_NODE_9552_length_165_cov_2.793103_g9489_i0 PRJNA658591 9552 165 2.793103 4.60861995 Eukaryota 2759 Plants Plants 84.7 2.25e-18   NR KAH0913690.1 3708 g9489 i0 75.5 14.7454545454545 49 12 89.1 0 147 1 34 82 KAH0913690.1 hypothetical protein HID58_037011 [Brassica napus] diamond 2433 84.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus
26606335 26606335 PRJNA658591_S_NODE_4241_length_220_cov_6.076023_g4178_i0 PRJNA658591 4241 220 6.076023 13.3672506 Sphagnum balticum 128184 Plants Plants 89.7 5.8e-20   NR CAM6002349.1 128184 g4178 i0 57.5 0.995454545454545 73 31 99.5 0 1 219 7 79 CAM6002349.1 unnamed protein product, partial [Sphagnum balticum] diamond 219 89.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
26828354 26828354 PRJNA658591_S_NODE_3501_length_237_cov_3.223404_g3438_i0 PRJNA658591 3501 237 3.223404 7.63946748 Sphagnum balticum 128184 Plants Plants 115 7.18e-30   NR CAM6002349.1 128184 g3438 i0 65.8 1 79 27 100 0 237 1 102 180 CAM6002349.1 unnamed protein product, partial [Sphagnum balticum] diamond 237 115 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
27081347 27081347 PRJNA658591_S_NODE_7222_length_181_cov_2.068182_g7159_i0 PRJNA658591 7222 181 2.068182 3.74340942 Sphagnum jensenii 128206 Plants Plants 79.7 8.76e-16   NR CAK9251169.1 128206 g7159 i0 56.9 1.93922651933702 58 25 96.1 0 179 6 239 296 CAK9251169.1 unnamed protein product [Sphagnum jensenii] diamond 351 79.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum jensenii
27681956 27681956 PRJNA658591_S_NODE_10084_length_163_cov_0.956140_g10021_i0 PRJNA658591 10084 163 0.95614 1.5585082 Sphagnum compactum 128190 Plants Plants 100 8.76e-24   NR CAM6032031.1 128190 g10021 i0 92.6 0.993865030674847 54 4 99.4 0 2 163 150 203 CAM6032031.1 unnamed protein product, partial [Sphagnum compactum] diamond 162 100 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum compactum
27681957 27681957 PRJNA658591_S_NODE_4264_length_220_cov_1.538012_g4201_i0 PRJNA658591 4264 220 1.538012 3.3836264 Hordeum vulgare subsp. vulgare 112509 Plants Plants 80.5 1.34e-15   NR BAK03058.1 112509 g4201 i0 53.5 1.95 71 33 96.8 0 1 213 128 198 BAK03058.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 429 80.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
27820269 27820269 PRJNA658591_S_NODE_9204_length_167_cov_1.322034_g9141_i0 PRJNA658591 9204 167 1.322034 2.20779678 Eukaryota 2759 Plants Plants 106 6.92e-26   NR CAM0881047.1 114194 g9141 i0 85.5 373.473053892216 55 8 98.8 0 2 166 182 236 CAM0881047.1 unnamed protein product [Alopecurus aequalis] diamond 62370 107 0.990654205607477 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Alopecurus Alopecurus aequalis
29008021 29008021 PRJNA658591_S_NODE_2008_length_297_cov_1.814516_g1945_i0 PRJNA658591 2008 297 1.814516 5.38911252 Mangifera indica 29780 Plants Plants 43.5 0.0374   NR XP_044495229.1 29780 g1945 i0 30 0.808080808080808 80 55 80.8 1 265 26 151 229 XP_044495229.1 probable potassium transporter 13 isoform X2 [Mangifera indica] diamond 240 43.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Anacardiaceae Mangifera Mangifera indica
30049603 30049603 PRJNA658591_S_NODE_5551_length_199_cov_6.293333_g5488_i0 PRJNA658591 5551 199 6.293333 12.52373267 Sphagnum balticum 128184 Plants Plants 106 1.6e-26   NR CAM6002349.1 128184 g5488 i0 93.4 1.8391959798995 61 4 92 0 197 15 171 231 CAM6002349.1 unnamed protein product, partial [Sphagnum balticum] diamond 366 106 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
30662286 30662286 PRJNA658591_S_NODE_7133_length_182_cov_1.052632_g7070_i0 PRJNA658591 7133 182 1.052632 1.91579024 Arabidopsis 3701 Plants Plants 58.9 3.23e-8   NR CAE5956253.1 38785 g7070 i0 75.7 2.91758241758242 37 9 61 0 115 5 1848 1884 CAE5956253.1 unnamed protein product [Arabidopsis arenosa] diamond 531 58.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis arenosa
32231333 32231333 PRJNA658591_S_NODE_8638_length_170_cov_1.297521_g8575_i0 PRJNA658591 8638 170 1.297521 2.2057857 Carnegiea gigantea 171969 Plants Plants 53.9 1.59e-6   NR KAJ8447308.1 171969 g8575 i0 53.7 7.11176470588235 41 19 72.4 0 127 5 1646 1686 KAJ8447308.1 hypothetical protein Cgig2_013085 [Carnegiea gigantea] diamond 1209 53.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Cactaceae Carnegiea Carnegiea gigantea

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