RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA855894" and tax_phylum = "Basidiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Basidiomycota · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA855894 · 2 ✖

analysis 1

  • diamond · 2 ✖
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
27212912 27212912 PRJNA855894_P_NODE_30402_length_250_cov_0.870056_g30280_i0 PRJNA855894 30402 250 0.870056 2.17514 Malassezia obtusa 76774 Fungi Fungi 106 1.38e-24   NR WFD03131.1 76774 g30280 i0 65.4 2.916 81 28 97.2 0 244 2 871 951 WFD03131.1 hypothetical protein MOBT1_001820 [Malassezia obtusa] diamond 729 106 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia obtusa
31003000 31003000 PRJNA855894_P_NODE_32674_length_245_cov_0.895349_g32552_i0 PRJNA855894 32674 245 0.895349 2.19360505 Malassezia sympodialis ATCC 42132 1230383 Fungi Fungi 83.2 1.75e-16   NR XP_018741583.1 1230383 g32552 i0 49.3 0.918367346938776 75 38 91.8 0 231 7 222 296 XP_018741583.1 uncharacterized protein MSY001_3089 [Malassezia sympodialis ATCC 42132] diamond 225 83.2 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia sympodialis

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