RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA509429 · 4 ✖

analysis 1

  • blastn · 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
1760392 1760392 PRJNA509429_P_NODE_12022_length_414_cov_3.886544_g11203_i0 PRJNA509429 12022 414 3.886544 16.09029216 Pseudoloma neurophilia 146866 Fungi Fungi 761 0   NTclustered gi|11993647|gb|AF322654.1| 146866 g11203 i0 99.758 99.0386473429952 414 1 100 0 1 414 1963 1550 Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 41002 761 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
6862952 6862952 PRJNA509429_P_NODE_12826_length_399_cov_1.760989_g12006_i0 PRJNA509429 12826 399 1.760989 7.02634611 Pseudoloma neurophilia 146866 Fungi Fungi 699 0   NTclustered gi|11993647|gb|AF322654.1| 146866 g12006 i0 99.737 95.2832080200501 380 1 95 0 20 399 813 434 Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 38018 699 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
11963944 11963944 PRJNA509429_P_NODE_25850_length_251_cov_1.754630_g25022_i0 PRJNA509429 25850 251 1.75463 4.4041213 Pseudoloma neurophilia 146866 Fungi Fungi 460 3.1899999999999997e-125   NTclustered gi|11993647|gb|AF322654.1| 146866 g25022 i0 99.602 49.3067729083665 251 1 100 0 1 251 274 24 Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 12376 460 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
15787973 15787973 PRJNA509429_P_NODE_40753_length_178_cov_3.608392_g39925_i0 PRJNA509429 40753 178 3.608392 6.42293776 Vavraia culicis 103449 Fungi Fungi 217 5.0499999999999996e-52   NTclustered gi|667636757|ref|XR_552273.1| 948595 g39925 i0 89.474 1.91573033707865 171 18 96 0 2 172 2395 2565 Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA blastn 341 217 1 Eukaryota Opisthokonta Fungi Microsporidia     Pleistophoridae Vavraia Vavraia culicis

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