RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA832865" 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

  • PRJNA832865 · 4 ✖

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
27086281 27086281 PRJNA832865_S_NODE_67042_length_302_cov_1.222707_g61956_i0 PRJNA832865 67042 302 1.222707 3.69257514 Cucumispora dikerogammari 658444 Fungi Fungi 46.2 0.00421   NR KAF7685156.1 658444 g61956 i0 46.3 1.63907284768212 54 29 53.6 0 58 219 131 184 KAF7685156.1 RNA-directed DNA polymerase from mobile element jockey, partial [Cucumispora dikerogammari] diamond 495 46.2 1 Eukaryota Opisthokonta Fungi Microsporidia       Cucumispora Cucumispora dikerogammari
27212432 27212432 PRJNA832865_S_NODE_30502_length_526_cov_19.013245_g25445_i0 PRJNA832865 30502 526 19.013245 100.0096687 Pancytospora philotis 1923975 Fungi Fungi 50.8 9.43e-4   NR KAI4293155.1 1923975 g25445 i0 52.3 0.861216730038023 44 21 25.1 0 206 337 630 673 KAI4293155.1 hypothetical protein PAPHI01_2429 [Pancytospora philotis] diamond 453 50.8 1 Eukaryota Opisthokonta Fungi Microsporidia       Pancytospora Pancytospora philotis
28096858 28096858 PRJNA832865_S_NODE_24925_length_634_cov_15.172906_g19971_i0 PRJNA832865 24925 634 15.172906 96.19622404 Pancytospora philotis 1923975 Fungi Fungi 50.8 0.00193   NR KAI4293155.1 1923975 g19971 i0 52.3 0.714511041009464 44 21 20.8 0 429 298 630 673 KAI4293155.1 hypothetical protein PAPHI01_2429 [Pancytospora philotis] diamond 453 50.8 1 Eukaryota Opisthokonta Fungi Microsporidia       Pancytospora Pancytospora philotis
31002532 31002532 PRJNA832865_S_NODE_50614_length_356_cov_1.466431_g45528_i0 PRJNA832865 50614 356 1.466431 5.22049436 Vairimorpha ceranae 40302 Fungi Fungi 44.3 0.0383   NR XP_024331809.1 40302 g45528 i0 37 0.455056179775281 54 34 45.5 0 163 2 754 807 XP_024331809.1 transcription initiation factor tfiid subunit taf1 [Vairimorpha ceranae] diamond 162 44.3 1 Eukaryota Opisthokonta Fungi Microsporidia     Nosematidae Vairimorpha Vairimorpha ceranae

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