RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA515078 · 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
12589945 12589945 PRJNA515078_P_NODE_8790_length_308_cov_1.726937_g8557_i0 PRJNA515078 8790 308 1.726937 5.31896596 Mitosporidium daphniae 1485682 Fungi Fungi 157 2.1e-45   NR XP_013239139.1 1485682 g8557 i0 76.8 0.964285714285714 99 23 96.4 0 306 10 30 128 XP_013239139.1 uncharacterized protein DI09_141p50 [Mitosporidium daphniae] diamond 297 157 1 Eukaryota Opisthokonta Fungi Microsporidia       Mitosporidium Mitosporidium daphniae
27077203 27077203 PRJNA515078_P_NODE_5142_length_419_cov_3.133508_g4909_i0 PRJNA515078 5142 419 3.133508 13.12939852 Pseudoloma neurophilia 146866 Fungi Fungi 69.3 1.24e-10   NR KRH92582.1 146866 g4909 i0 47 1.35322195704057 66 34 46.5 1 317 123 17 82 KRH92582.1 ATP-dependent RNA helicase, partial [Pseudoloma neurophilia] diamond 567 69.3 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
32052429 32052429 PRJNA515078_P_NODE_10598_length_276_cov_4.669456_g10365_i0 PRJNA515078 10598 276 4.669456 12.88769856 Nematocida 586132 Fungi Fungi 49.3 1.89e-4   NR OAG30539.1 1805481 g10365 i0 50 1.18478260869565 42 21 45.7 0 56 181 145 186 OAG30539.1 hypothetical protein NEIG_00051 [Nematocida sp. ERTm5] diamond 327 49.3 1 Eukaryota Opisthokonta Fungi Microsporidia       Nematocida Nematocida sp. ERTm5

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