RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA893346 · 3 ✖

analysis 1

  • blastn · 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
8520759 8520759 PRJNA893346_P_NODE_14747_length_405_cov_2.039157_g14259_i0 PRJNA893346 14747 405 2.039157 8.25858585 Glugoides intestinalis 174680 Fungi Fungi 204 1.0099999999999999e-47   NTclustered gi|113470857|gb|DQ680158.2| 174680 g14259 i0 77.461 29.5061728395062 386 57 93 22 28 405 1264 1627 Glugoides intestinalis isolate Gi3 23S ribosomal RNA gene, partial sequence; 23S-16S ribosomal RNA spacer, complete sequence; and 16S ribosomal RNA gene, partial sequence blastn 11950 204 1 Eukaryota Opisthokonta Fungi Microsporidia     Glugeidae Glugoides Glugoides intestinalis
9795873 9795873 PRJNA893346_P_NODE_1788_length_1213_cov_2.375439_g1521_i0 PRJNA893346 1788 1213 2.375439 28.81407507 Hepatospora eriocheir 1081669 Fungi Fungi 1513 0   NTclustered gi|2231793236|gb|ON365850.1| 1081669 g1521 i0 99.758 77.3091508656224 825 2 68 0 1 825 825 1 Hepatospora eriocheir isolate HP14_PL small subunit ribosomal RNA gene, partial sequence blastn 93776 1513 1 Eukaryota Opisthokonta Fungi Microsporidia     Hepatosporidae Hepatospora Hepatospora eriocheir
17446345 17446345 PRJNA893346_P_NODE_2494_length_1040_cov_1.574974_g2164_i0 PRJNA893346 2494 1040 1.574974 16.3797296 Hepatospora eriocheir 1081669 Fungi Fungi 1882 0   NTclustered gi|1013854584|gb|KU695718.1| 1822052 g2164 i0 99.327 5.95384615384615 1040 7 100 0 1 1040 15 1054 Hepatospora eriocheir 'edible crab parasite' beta-tubulin gene, complete cds blastn 6192 1882 1 Eukaryota Opisthokonta Fungi Microsporidia     Hepatosporidae Hepatospora Hepatospora eriocheir

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