RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA864829", tax_kingdom = "Metazoa" and tax_phylum = "Nematoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Nematoda · 3 ✖

tax_kingdom 1

  • Metazoa · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA864829 · 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
11440629 11440629 PRJNA864829_S_NODE_10889_length_192_cov_2.958042_g10803_i0 PRJNA864829 10889 192 2.958042 5.67944064 Micoletzkya 669149 Nematoda Nematoda 113 7.480000000000001e-21   NTclustered gi|632796480|gb|KJ530999.1| 1498070 g10803 i0 80.537 9.171875 149 27 77 2 1 148 325 178 Micoletzkya hylurginophila large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds blastn 1761 113 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Diplogasteridae Micoletzkya Micoletzkya hylurginophila
26833694 26833694 PRJNA864829_S_NODE_3001_length_317_cov_1.735075_g2915_i0 PRJNA864829 3001 317 1.735075 5.50018775 Ditylenchus destructor 166010 Nematoda Nematoda 66.6 3.59e-10   NR KAI1730178.1 166010 g2915 i0 43.8 2.85804416403785 64 33 60.6 2 2 193 239 299 KAI1730178.1 EGF-like domain-containing protein [Ditylenchus destructor] diamond 906 66.6 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Anguinidae Ditylenchus Ditylenchus destructor
27876332 27876332 PRJNA864829_S_NODE_6645_length_237_cov_1.505319_g6559_i0 PRJNA864829 6645 237 1.505319 3.56760603 Halicephalobus sp. NKZ332 2598192 Nematoda Nematoda 87.4 6.31e-18   NR KAE9549880.1 2598192 g6559 i0 61.8 2.91139240506329 76 29 96.2 0 9 236 621 696 KAE9549880.1 hypothetical protein FO519_006909 [Halicephalobus sp. NKZ332] diamond 690 87.4 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Panagrolaimidae Halicephalobus Halicephalobus sp. NKZ332

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