RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA559720", tax_kingdom = "Fungi" 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

  • Fungi · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA559720 · 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
27552666 27552666 PRJNA559720_P_NODE_5884_length_425_cov_1.329545_g5745_i0 PRJNA559720 5884 425 1.329545 5.65056625 Nematocida displodere 1805483 Fungi Fungi 170 6.859999999999999e-46   NR XP_067545532.1 1805483 g5745 i0 54.3 1.94823529411765 138 63 97.4 0 416 3 624 761 XP_067545532.1 lysophospholipid hydrolase [Nematocida displodere] diamond 828 170 1 Eukaryota Opisthokonta Fungi Microsporidia       Nematocida Nematocida displodere
30679090 30679090 PRJNA559720_P_NODE_2233_length_683_cov_1.001639_g2119_i0 PRJNA559720 2233 683 1.001639 6.84119437 Cucumispora dikerogammari 658444 Fungi Fungi 120 9.55e-29   NR KAF7684917.1 658444 g2119 i0 37 0.961932650073206 219 106 89.2 7 609 1 80 282 KAF7684917.1 hypothetical protein CDIK_4334 [Cucumispora dikerogammari] diamond 657 120 1 Eukaryota Opisthokonta Fungi Microsporidia       Cucumispora Cucumispora dikerogammari
30742433 30742433 PRJNA559720_P_NODE_10034_length_307_cov_2.132479_g9895_i0 PRJNA559720 10034 307 2.132479 6.54671053 Tubulinosema ratisbonensis 291195 Fungi Fungi 60.1 5.05e-8   NR RVD91227.1 291195 g9895 i0 37.3 0.996742671009772 102 57 99.7 4 2 307 207 301 RVD91227.1 ethanolamine-phosphate cytidylytransferase [Tubulinosema ratisbonensis] diamond 306 60.1 1 Eukaryota Opisthokonta Fungi Microsporidia     Tubulinosematidae Tubulinosema Tubulinosema ratisbonensis

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