RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA543299" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA543299 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
29351641 29351641 PRJNA543299_P_NODE_12549_length_211_cov_1.654321_g12392_i0 PRJNA543299 12549 211 1.654321 3.49061731 Shorea laevis 152420 Plants Plants 40.4 0.0365   NR GLT50214.1 152420 g12392 i0 44.2 0.611374407582938 43 22 61.1 1 158 30 7 47 GLT50214.1 hypothetical protein SLA2020_237160 [Shorea laevis] diamond 129 40.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Dipterocarpaceae Shorea Shorea laevis
31278476 31278476 PRJNA543299_P_NODE_14715_length_195_cov_9.006849_g14558_i0 PRJNA543299 14715 195 9.006849 17.56335555 Calluna vulgaris 13385 Plants Plants 40 0.0367   NR CAM5845482.1 13385 g14558 i0 42.2 0.692307692307692 45 16 69.2 1 166 32 34 68 CAM5845482.1 unnamed protein product [Calluna vulgaris] diamond 135 40 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Ericaceae Calluna Calluna vulgaris
31310124 31310124 PRJNA543299_P_NODE_17375_length_180_cov_1.557252_g17218_i0 PRJNA543299 17375 180 1.557252 2.8030536 Arachis hypogaea 3818 Plants Plants 43.1 0.00314   NR RYQ90665.1 3818 g17218 i0 72 0.416666666666667 25 7 41.7 0 3 77 80 104 RYQ90665.1 hypothetical protein Ahy_B09g096697 [Arachis hypogaea] diamond 75 43.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Arachis Arachis hypogaea

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