RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA891846" and tax_clade = "Amoebozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Amoebozoa · 3 ✖

bioproject 1

  • PRJNA891846 · 3 ✖

analysis 1

  • diamond · 3 ✖

tax_kingdom 0

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
12346185 12346185 PRJNA891846_P_NODE_32030_length_270_cov_1.512690_g31811_i0 PRJNA891846 32030 270 1.51269 4.084263 Planoprotostelium fungivorum 1890364 Evosea other_Eukaryota 141 1.28e-36   NR PRP81006.1 1890364 g31811 i0 78.7 0.988888888888889 89 19 98.9 0 270 4 803 891 PRP81006.1 cytoplasmic aconitate hydratase isoform 1 [Planoprotostelium fungivorum] diamond 267 141 1 Eukaryota Amoebozoa   Evosea Variosea Cavosteliida Cavosteliaceae Planoprotostelium Planoprotostelium fungivorum
30466640 30466640 PRJNA891846_P_NODE_28033_length_288_cov_1.302326_g27814_i0 PRJNA891846 28033 288 1.302326 3.75069888 Tieghemostelium lacteum 361077 Evosea other_Eukaryota 68.2 7.8e-11   NR KYQ90277.1 361077 g27814 i0 38.3 8.79166666666667 94 54 93.8 2 270 1 133 226 KYQ90277.1 myosin II heavy chain [Tieghemostelium lacteum] diamond 2532 68.2 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Dictyosteliales Raperosteliaceae Tieghemostelium Tieghemostelium lacteum
32585076 32585076 PRJNA891846_P_NODE_23999_length_311_cov_1.105042_g23780_i0 PRJNA891846 23999 311 1.105042 3.43668062 uncultured Dictyostelium 1227963 Evosea other_Eukaryota 58.9 3.11e-8   NR AIA90852.1 1227963 g23780 i0 59.5 0.405144694533762 42 17 40.5 0 309 184 3 44 AIA90852.1 CAZy families GT77 protein, partial [uncultured Dictyostelium] diamond 126 58.9 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Dictyosteliales Dictyosteliaceae   uncultured Dictyostelium

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