RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA745553" and tax_phylum = "Chytridiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chytridiomycota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA745553 · 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
11402442 11402442 PRJNA745553_S_NODE_26609_length_241_cov_7.726190_g26414_i0 PRJNA745553 26609 241 7.72619 18.6201179 Eukaryota 2759 Fungi Fungi 412 8.64e-111   NTclustered gi|254039397|dbj|AB512178.1| 175247 g26414 i0 99.127 94.9875518672199 229 2 95 0 13 241 1062 834 Uncultured Chytridiomycota gene for 18S rRNA, partial sequence, clone: EHM5 blastn 22892 412 1 Eukaryota Opisthokonta Fungi Chytridiomycota         uncultured Chytridiomycota
12203746 12203746 PRJNA745553_S_NODE_26490_length_242_cov_1.822485_g26295_i0 PRJNA745553 26490 242 1.822485 4.4104137 Betamyces sp. 2040705 Fungi Fungi 353 5.34e-93   NTclustered gi|1866582807|gb|MT730982.1| 2040705 g26295 i0 92.975 101.96694214876 242 17 100 0 1 242 4816 4575 Betamyces sp. isolate UM1567 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 24676 353 1 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Rhizophydiales Alphamycetaceae Betamyces Betamyces sp.
23677327 23677327 PRJNA745553_S_NODE_29139_length_223_cov_7.780000_g28944_i0 PRJNA745553 29139 223 7.78 17.3494 uncultured Spizellomycetales 417325 Fungi Fungi 296 8.28e-76   NTclustered gi|197210530|gb|FJ004974.1| 417325 g28944 i0 93.103 93.1390134529148 203 12 90 1 23 223 14 216 Uncultured Spizellomycete clone DLQDal2 28S ribosomal RNA gene, partial sequence blastn 20770 296 1 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Spizellomycetales     uncultured Spizellomycetales

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