RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJEB43370" 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

  • PRJEB43370 · 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
21736853 21736853 PRJEB43370_P_NODE_10318_length_163_cov_0.912281_g10275_i0 PRJEB43370 10318 163 0.912281 1.48701803 Mitosporidium daphniae 1485682 Fungi Fungi 75.1 1.55e-15   NR XP_013238444.1 1485682 g10275 i0 57.4 3.97546012269939 54 23 99.4 0 162 1 71 124 XP_013238444.1 40S ribosomal protein S20 [Mitosporidium daphniae] diamond 648 75.1 1 Eukaryota Opisthokonta Fungi Microsporidia       Mitosporidium Mitosporidium daphniae
28107236 28107236 PRJEB43370_P_NODE_7305_length_169_cov_2.608333_g7262_i0 PRJEB43370 7305 169 2.608333 4.40808277 Dictyocoela muelleri 279532 Fungi Fungi 59.3 1.97e-8   NR KAG0439306.1 279532 g7262 i0 51.8 0.994082840236686 56 27 99.4 0 2 169 165 220 KAG0439306.1 Transposon Tf2-9 polyprotein [Dictyocoela muelleri] diamond 168 59.3 1 Eukaryota Opisthokonta Fungi Microsporidia       Dictyocoela Dictyocoela muelleri
30469413 30469413 PRJEB43370_P_NODE_4313_length_215_cov_1.253012_g4270_i0 PRJEB43370 4313 215 1.253012 2.6939758 root 1 Root_unresolved Root_unresolved 93.6 1.99e-22   NR KCZ78541.1 1240240 g4270 i0 57.4 2.81860465116279 68 29 94.9 0 206 3 47 114 KCZ78541.1 hypothetical protein H311_00425 [Anncaliia algerae PRA109] diamond 606 93.6 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);;