RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA602115" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA602115 · 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
26668177 26668177 PRJNA602115_P_NODE_10001_length_206_cov_0.882759_g9976_i0 PRJNA602115 10001 206 0.882759 1.81848354 Salix brachista 2182728 Plants Plants 53.5 3.6e-6   NR KAB5541615.1 2182728 g9976 i0 74.4 0.567961165048544 39 6 56.8 1 205 89 814 848 KAB5541615.1 hypothetical protein DKX38_014589 [Salix brachista] diamond 117 53.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Salicaceae Salix Salix brachista
27996025 27996025 PRJNA602115_P_NODE_6705_length_246_cov_0.778378_g6680_i0 PRJNA602115 6705 246 0.778378 1.91480988 Solanum verrucosum 315347 Plants Plants 43.9 0.0142   NR WMV10992.1 315347 g6680 i0 38.1 3.17073170731707 63 31 75.6 3 58 243 123 178 WMV10992.1 hypothetical protein MTR67_004377 [Solanum verrucosum] diamond 780 43.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Solanum Solanum verrucosum
28374736 28374736 PRJNA602115_P_NODE_11546_length_202_cov_0.900709_g11521_i0 PRJNA602115 11546 202 0.900709 1.81943218 Populus tomentosa 118781 Plants Plants 50.4 3.26e-5   NR KAG6793008.1 118781 g11521 i0 100 0.311881188118812 21 0 31.2 0 2 64 145 165 KAG6793008.1 hypothetical protein POTOM_002178 [Populus tomentosa] diamond 63 50.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Salicaceae Populus Populus tomentosa
28627638 28627638 PRJNA602115_P_NODE_3887_length_313_cov_0.900794_g3862_i0 PRJNA602115 3887 313 0.900794 2.81948522 Lotus japonicus 34305 Plants Plants 146 3.369999999999999e-42   NR AFK43985.1 34305 g3862 i0 66.3 0.996805111821086 104 35 99.7 0 313 2 34 137 AFK43985.1 unknown [Lotus japonicus] diamond 312 146 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lotus Lotus japonicus
31122215 31122215 PRJNA602115_P_NODE_9575_length_207_cov_0.876712_g9550_i0 PRJNA602115 9575 207 0.876712 1.81479384 Zea mays 4577 Plants Plants 65.1 2.93e-10   NR ONM29629.1 4577 g9550 i0 91.2 0.492753623188406 34 3 49.3 0 103 2 358 391 ONM29629.1 Pectin lyase-like superfamily protein [Zea mays] diamond 102 65.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zea Zea mays
31185501 31185501 PRJNA602115_P_NODE_11695_length_201_cov_0.914286_g11670_i0 PRJNA602115 11695 201 0.914286 1.83771486 Paspalum notatum var. saurae 547442 Plants Plants 55.5 3.81e-7   NR WVZ67832.1 547442 g11670 i0 65.2 0.686567164179104 46 14 65.7 1 27 158 171 216 WVZ67832.1 hypothetical protein U9M48_016861 [Paspalum notatum var. saurae] diamond 138 55.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Paspalum Paspalum notatum
32829631 32829631 PRJNA602115_P_NODE_8940_length_209_cov_0.864865_g8915_i0 PRJNA602115 8940 209 0.864865 1.80756785 Sphagnum balticum 128184 Plants Plants 106 1.24e-25   NR CAM6002056.1 128184 g8915 i0 73.5 0.976076555023923 68 18 97.6 0 204 1 121 188 CAM6002056.1 unnamed protein product, partial [Sphagnum balticum] diamond 204 106 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);;