RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA727760" and tax_phylum = "Basidiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Basidiomycota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA727760 · 3 ✖

analysis 1

  • diamond · 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
27716103 27716103 PRJNA727760_S_NODE_2544_length_285_cov_1.561321_g2516_i0 PRJNA727760 2544 285 1.561321 4.44976485 Malassezia restricta CBS 7877 425264 Fungi Fungi 118 6.229999999999999e-31   NR AYO44820.1 425264 g2516 i0 71.1 0.947368421052632 90 26 94.7 0 283 14 61 150 AYO44820.1 heat shock protein GrpE [Malassezia restricta CBS 7877] diamond 270 118 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
28104746 28104746 PRJNA727760_S_NODE_2505_length_288_cov_0.934884_g2477_i0 PRJNA727760 2505 288 0.934884 2.69246592 Microbotryomycetes 162481 Fungi Fungi 60.5 6.06e-9   NR GAA5898551.1 183962 g2477 i0 75.5 2.86458333333333 49 4 44.8 3 286 158 110 156 GAA5898551.1 hypothetical protein JCM6883_003349 [Sporobolomyces salmoneus] diamond 825 60.8 0.995065789473684 Eukaryota Opisthokonta Fungi Basidiomycota Microbotryomycetes Sporidiobolales Sporidiobolaceae Sporobolomyces Sporobolomyces salmoneus
31664041 31664041 PRJNA727760_S_NODE_3637_length_246_cov_0.901734_g3609_i0 PRJNA727760 3637 246 0.901734 2.21826564 Malassezia psittaci 1821823 Fungi Fungi 60.5 7.19e-9   NR WFD42247.1 1821823 g3609 i0 43 0.963414634146341 79 32 80.5 2 5 202 119 197 WFD42247.1 hypothetical protein MPSI1_000888 [Malassezia psittaci] diamond 237 60.5 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia psittaci

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