RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA270367" and tax_phylum = "Microsporidia"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Microsporidia · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA270367 · 3 ✖

analysis 1

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
30818461 30818461 PRJNA270367_P_NODE_32314_length_194_cov_1.075862_g32109_i0 PRJNA270367 32314 194 1.075862 2.08717228 Eukaryota 2759 Fungi Fungi 70.9 1.41e-12   NR XP_024331730.1 40302 g32109 i0 65.9 6.34020618556701 41 14 63.4 0 71 193 34 74 XP_024331730.1 ser thr protein phosphatase 2-a [Vairimorpha ceranae] diamond 1230 71.2 0.995786516853933 Eukaryota Opisthokonta Fungi Microsporidia     Nosematidae Vairimorpha Vairimorpha ceranae
31147865 31147865 PRJNA270367_P_NODE_28835_length_209_cov_1.125000_g28630_i0 PRJNA270367 28835 209 1.125 2.35125 Mitosporidium daphniae 1485682 Fungi Fungi 48.1 8.37e-5   NR XP_013238926.1 1485682 g28630 i0 52.5 0.574162679425837 40 19 57.4 0 207 88 91 130 XP_013238926.1 histone H2A [Mitosporidium daphniae] diamond 120 48.1 1 Eukaryota Opisthokonta Fungi Microsporidia       Mitosporidium Mitosporidium daphniae
32223850 32223850 PRJNA270367_P_NODE_36838_length_177_cov_1.617188_g36633_i0 PRJNA270367 36838 177 1.617188 2.86242276 Anncaliia algerae PRA1 723287 Fungi Fungi 45.1 0.00115   NR KCZ75368.1 1240240 g36633 i0 63.6 0.559322033898305 33 12 55.9 0 115 17 113 145 KCZ75368.1 hypothetical protein H311_03657, partial [Anncaliia algerae PRA109] diamond 99 45.1 1 Eukaryota Opisthokonta Fungi Microsporidia     Tubulinosematidae Anncaliia Anncaliia algerae

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