RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA379145 · 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
4227941 4227941 PRJNA379145_P_NODE_28444_length_439_cov_2.731527_g26351_i0 PRJNA379145 28444 439 2.731527 11.99140353 Vavraia culicis 103449 Fungi Fungi 289 2.97e-73   NTclustered gi|667631888|ref|XM_008075036.1| 948595 g26351 i0 79.798 64.6332574031891 396 80 90 0 10 405 540 145 Vavraia culicis subsp. floridensis actin-1 (VCUG_00207), mRNA blastn 28374 289 1 Eukaryota Opisthokonta Fungi Microsporidia     Pleistophoridae Vavraia Vavraia culicis
15101858 15101858 PRJNA379145_P_NODE_52012_length_223_cov_1.357895_g49858_i0 PRJNA379145 52012 223 1.357895 3.02810585 Pleistophoridae 35232 Fungi Fungi 324 3.8e-84   NTclustered gi|134147422|gb|EF119339.1| 249366 g49858 i0 92.825 68.2780269058296 223 16 100 0 1 223 2150 1928 Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 15226 324 1 Eukaryota Opisthokonta Fungi Microsporidia     Pleistophoridae Pleistophora Pleistophora mulleri
17651613 17651613 PRJNA379145_P_NODE_30414_length_410_cov_73.692308_g28291_i0 PRJNA379145 30414 410 73.692308 302.1384628 Heterosporis 157917 Fungi Fungi 331 4.52e-86   NTclustered gi|448278458|gb|KC137554.1| 1289055 g28291 i0 94.811 37.9560975609756 212 11 60 0 2 213 3597 3386 Heterosporis sp. NBDP-2013a isolate MN/CISCO small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 15562 331 1 Eukaryota Opisthokonta Fungi Microsporidia     Pleistophoridae Heterosporis Heterosporis sp. NBDP-2013a

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