RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA556842" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA556842 · 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
27078266 27078266 PRJNA556842_P_NODE_11802_length_210_cov_2.236994_g11297_i0 PRJNA556842 11802 210 2.236994 4.6976874 Aureobasidium melanogenum 46634 Fungi Fungi 75.9 5.54e-16   NR KAG9514618.1 46634 g11297 i0 68.6 0.728571428571429 51 16 72.9 0 58 210 1 51 KAG9514618.1 hypothetical protein KCV07_g7983, partial [Aureobasidium melanogenum] diamond 153 75.9 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Dothideales Saccotheciaceae Aureobasidium Aureobasidium melanogenum
32859328 32859328 PRJNA556842_P_NODE_10880_length_226_cov_1.359788_g10375_i0 PRJNA556842 10880 226 1.359788 3.07312088 Cladophialophora bantiana CBS 173.52 1442370 Fungi Fungi 42.4 0.0422   NR XP_016621673.1 1442370 g10375 i0 38.2 1.00884955752212 76 33 83.6 4 2 190 815 889 XP_016621673.1 uncharacterized protein Z519_04984 [Cladophialophora bantiana CBS 173.52] diamond 228 42.4 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Chaetothyriales Herpotrichiellaceae Cladophialophora Cladophialophora bantiana

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