RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA724039" and tax_phylum = "Nematoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nematoda · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA724039 · 2 ✖

analysis 1

  • diamond · 2 ✖
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
25420773 25420773 PRJNA724039_S_NODE_9080_length_217_cov_2.305556_g8873_i0 PRJNA724039 9080 217 2.305556 5.00305652 Bursaphelenchus cocophilus 269710 Nematoda Nematoda 105 2.5e-26   NR AAS90523.1 269710 g8873 i0 91.5 0.815668202764977 59 4 80.2 1 2 175 52 110 AAS90523.1 cytochrome oxidase subunit I, partial [Bursaphelenchus cocophilus] diamond 177 105 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Aphelenchoididae Bursaphelenchus Bursaphelenchus cocophilus
29619985 29619985 PRJNA724039_S_NODE_8810_length_221_cov_2.190217_g8603_i0 PRJNA724039 8810 221 2.190217 4.84037957 Metazoa 33208 Nematoda Nematoda 97.8 3.07e-23   NR CAD5212188.1 6326 g8603 i0 65.3 10.6968325791855 72 25 97.7 0 220 5 26 97 CAD5212188.1 unnamed protein product [Bursaphelenchus xylophilus] diamond 2364 98.6 0.991886409736308 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Aphelenchoididae Bursaphelenchus Bursaphelenchus xylophilus

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