RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA206070" 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

  • PRJNA206070 · 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
27786881 27786881 PRJNA206070_S_NODE_15084_length_263_cov_7.154867_g13208_i0 PRJNA206070 15084 263 7.154867 18.81730021 Saccharomyces 4930 Fungi Fungi 64.7 9.96e-11   NR KAF4001137.1 4932 g13208 i0 53.7 3.76425855513308 67 21 76.4 1 262 62 51 107 KAF4001137.1 Protein TAR1 domain protein [Saccharomyces cerevisiae] diamond 990 64.7 1 Eukaryota Opisthokonta Fungi Ascomycota Saccharomycetes Saccharomycetales Saccharomycetaceae Saccharomyces Saccharomyces cerevisiae
27926790 27926790 PRJNA206070_S_NODE_11705_length_331_cov_2.602041_g9829_i0 PRJNA206070 11705 331 2.602041 8.61275571 Epichloe bromicola 79588 Fungi Fungi 46.2 0.0047   NR GAB0147160.1 79588 g9829 i0 55.6 0.326283987915408 36 16 32.6 0 331 224 192 227 GAB0147160.1 hypothetical protein EsHS_00007537 [Epichloe bromicola] diamond 108 46.2 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Clavicipitaceae Epichloe Epichloe bromicola
31938766 31938766 PRJNA206070_S_NODE_29657_length_155_cov_2.618644_g27781_i0 PRJNA206070 29657 155 2.618644 4.0588982 Epichloe bromicola 79588 Fungi Fungi 49.7 2.54e-5   NR GAB0147163.1 79588 g27781 i0 49 1.93548387096774 51 26 98.7 0 1 153 49 99 GAB0147163.1 hypothetical protein EsHS_00007541, partial [Epichloe bromicola] diamond 300 49.7 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Clavicipitaceae Epichloe Epichloe bromicola

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