RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax_phylum = "Microsporidia"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Microsporidia · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA641707 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
28817634 28817634 PRJNA641707_P_NODE_137128_length_242_cov_10.295337_g134465_i0 PRJNA641707 137128 242 10.295337 24.91471554 Nematocida minor 1912983 Fungi Fungi 47.4 4.52e-4   NR XP_051332481.1 1912983 g134465 i0 63.6 0.409090909090909 33 10 38.4 2 97 5 99 131 XP_051332481.1 translation initiation factor 5 [Nematocida minor] diamond 99 47.4 1 Eukaryota Opisthokonta Fungi Microsporidia       Nematocida Nematocida minor
30081031 30081031 PRJNA641707_P_NODE_87052_length_246_cov_6.284264_g84389_i0 PRJNA641707 87052 246 6.284264 15.45928944 Nosema granulosis 83296 Fungi Fungi 44.7 0.00784   NR KAF9762364.1 83296 g84389 i0 60 0.365853658536585 30 12 36.6 0 115 204 60 89 KAF9762364.1 Zinc transporter 8 [Nosema granulosis] diamond 90 44.7 1 Eukaryota Opisthokonta Fungi Microsporidia     Nosematidae Nosema Nosema granulosis
31977725 31977725 PRJNA641707_P_NODE_340278_length_150_cov_4.019802_g337615_i0 PRJNA641707 340278 150 4.019802 6.029703 Mitosporidium daphniae 1485682 Fungi Fungi 41.2 0.0379   NR XP_013236427.1 1485682 g337615 i0 35.4 0.96 48 30 96 1 150 7 254 300 XP_013236427.1 adenylyl cyclase-associated protein [Mitosporidium daphniae] diamond 144 41.2 1 Eukaryota Opisthokonta Fungi Microsporidia       Mitosporidium Mitosporidium daphniae
32673110 32673110 PRJNA641707_P_NODE_172820_length_201_cov_4.506579_g170157_i0 PRJNA641707 172820 201 4.506579 9.05822379 Nematocida ausubeli 1913371 Fungi Fungi 84.3 5.01e-18   NR KAI5163269.1 1913371 g170157 i0 69 1.05970149253731 71 17 98.5 1 2 199 116 186 KAI5163269.1 hypothetical protein NEAUS03_2265 [Nematocida ausubeli] diamond 213 84.3 1 Eukaryota Opisthokonta Fungi Microsporidia       Nematocida Nematocida ausubeli

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