RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB66218" 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

  • PRJEB66218 · 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
28707983 28707983 PRJEB66218_P_NODE_237307_length_203_cov_0.894366_g234876_i0 PRJEB66218 237307 203 0.894366 1.81556298 Nosema bombycis 27978 Fungi Fungi 42 0.0405   NR WGJ64385.1 27978 g234876 i0 54.1 0.54679802955665 37 16 54.7 1 79 189 21 56 WGJ64385.1 ricin B lectin-like protein [Nosema bombycis] diamond 111 42 1 Eukaryota Opisthokonta Fungi Microsporidia     Nosematidae Nosema Nosema bombycis
28739415 28739415 PRJEB66218_P_NODE_206347_length_209_cov_0.878378_g203917_i0 PRJEB66218 206347 209 0.878378 1.83581002 Nematocida sp. AWRm8 1927920 Fungi Fungi 50.4 4.26e-5   NR KAI5179627.1 2670343 g203917 i0 56.1 0.588516746411483 41 18 58.9 0 83 205 98 138 KAI5179627.1 hypothetical protein NEOKW01_0090 [Nematocida sp. AWRm80] diamond 123 50.4 1 Eukaryota Opisthokonta Fungi Microsporidia       Nematocida Nematocida sp. AWRm80
31487951 31487951 PRJEB66218_P_NODE_166596_length_229_cov_4.255952_g164166_i0 PRJEB66218 166596 229 4.255952 9.74613008 Anncaliia algerae PRA1 723287 Fungi Fungi 58.5 2.06e-8   NR KCZ75641.1 1240240 g164166 i0 40.8 5.94759825327511 71 42 93 0 214 2 14 84 KCZ75641.1 hypothetical protein H311_03378 [Anncaliia algerae PRA109] diamond 1362 58.5 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);;