RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB55122" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB55122 · 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
27539213 27539213 PRJEB55122_P_NODE_37044_length_169_cov_0.866667_g36647_i0 PRJEB55122 37044 169 0.866667 1.46466723 Capitella teleta 283909 Annelida Annelida 54.7 6.69e-7   NR ELT99409.1 283909 g36647 i0 51.9 1.95266272189349 54 25 94.1 1 3 161 200 253 ELT99409.1 hypothetical protein CAPTEDRAFT_188524 [Capitella teleta] diamond 330 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Capitellidae Capitella Capitella teleta
29749006 29749006 PRJEB55122_P_NODE_29671_length_193_cov_1.444444_g29274_i0 PRJEB55122 29671 193 1.444444 2.78777692 Owenia fusiformis 6347 Annelida Annelida 44.3 0.0043   NR CAH1787106.1 6347 g29274 i0 37.3 1.2279792746114 51 32 79.3 0 191 39 81 131 CAH1787106.1 unnamed protein product [Owenia fusiformis] diamond 237 44.3 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis
31796621 31796621 PRJEB55122_P_NODE_18577_length_261_cov_1.424528_g18180_i0 PRJEB55122 18577 261 1.424528 3.71801808 Polychaeta 6341 Annelida Annelida 78.6 4.61e-15   NR CAH1773255.1 6347 g18180 i0 70 4.20689655172414 50 14 56.3 1 149 3 9 58 CAH1773255.1 unnamed protein product [Owenia fusiformis] diamond 1098 79.3 0.991172761664565 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis

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