RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA326068" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA326068 · 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
13142976 13142976 PRJNA326068_P_NODE_16211_length_207_cov_2.455056_g15248_i0 PRJNA326068 16211 207 2.455056 5.08196592 Candida dubliniensis CD36 573826 Fungi Fungi 78.6 1.42e-17   NR XP_002417266.1 573826 g15248 i0 75.5 16.7536231884058 49 12 71 0 3 149 3 51 XP_002417266.1 60S ribosomal protein L39 [Candida dubliniensis CD36] diamond 3468 78.6 1 Eukaryota Opisthokonta Fungi Ascomycota Pichiomycetes Serinales Debaryomycetaceae Candida Candida dubliniensis
27137370 27137370 PRJNA326068_P_NODE_18102_length_179_cov_2.506667_g17139_i0 PRJNA326068 18102 179 2.506667 4.48693393 Teratosphaeria nubilosa 161662 Fungi Fungi 55.8 6.37e-8   NR KAF2765129.1 161662 g17139 i0 48.3 0.972067039106145 58 30 97.2 0 6 179 5 62 KAF2765129.1 hypothetical protein EJ03DRAFT_339308 [Teratosphaeria nubilosa] diamond 174 55.8 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Mycosphaerellales Teratosphaeriaceae Teratosphaeria Teratosphaeria nubilosa
28576168 28576168 PRJNA326068_P_NODE_9707_length_324_cov_4.810169_g8748_i0 PRJNA326068 9707 324 4.810169 15.58494756 Saccharomycetaceae 4893 Fungi Fungi 63.5 5.61e-10   NR KAF4001137.1 4932 g8748 i0 54.5 3.72222222222222 66 20 61.1 1 314 117 51 106 KAF4001137.1 Protein TAR1 domain protein [Saccharomyces cerevisiae] diamond 1206 63.9 0.993740219092332 Eukaryota Opisthokonta Fungi Ascomycota Saccharomycetes Saccharomycetales Saccharomycetaceae Saccharomyces Saccharomyces cerevisiae

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