RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1028258" and tax_phylum = "Tubulinea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Tubulinea · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA1028258 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
21840942 21840942 PRJNA1028258_P_NODE_166518_length_227_cov_0.898734_g165955_i0 PRJNA1028258 166518 227 0.898734 2.04012618 Amoeba proteus 5775 Tubulinea other_Eukaryota 130 5.339999999999998e-35   NR AFX84537.1 5775 g165955 i0 82.7 0.991189427312775 75 13 99.1 0 227 3 128 202 AFX84537.1 alpha tubulin, partial [Amoeba proteus] diamond 225 130 1 Eukaryota Amoebozoa   Tubulinea Elardia Euamoebida Amoebidae Amoeba Amoeba proteus
26591594 26591594 PRJNA1028258_P_NODE_170621_length_226_cov_0.904459_g170058_i0 PRJNA1028258 170621 226 0.904459 2.04407734 Vermamoeba vermiformis 5778 Tubulinea other_Eukaryota 45.1 0.00412   NR AAY87037.1 5778 g170058 i0 53.1 0.424778761061947 32 15 42.5 0 131 226 123 154 AAY87037.1 CmfA-like protein, partial [Vermamoeba vermiformis] diamond 96 45.1 1 Eukaryota Amoebozoa   Tubulinea Echinamoebida     Vermamoeba Vermamoeba vermiformis
29403547 29403547 PRJNA1028258_P_NODE_78949_length_290_cov_1.606335_g78386_i0 PRJNA1028258 78949 290 1.606335 4.6583715 Copromyxa protea 931554 Tubulinea other_Eukaryota 61.6 1.45e-8   NR BAN33737.1 931554 g78386 i0 100 0.310344827586207 30 0 31 0 289 200 435 464 BAN33737.1 elongation factor-like protein [Copromyxa protea] diamond 90 61.6 1 Eukaryota Amoebozoa   Tubulinea Elardia Euamoebida Hartmannellidae Copromyxa Copromyxa protea
29490145 29490145 PRJNA1028258_P_NODE_137330_length_234_cov_0.860606_g136767_i0 PRJNA1028258 137330 234 0.860606 2.01381804 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 121 2.4e-30   NR BAN33737.1 931554 g136767 i0 70.1 2.96153846153846 77 23 98.7 0 3 233 300 376 BAN33737.1 elongation factor-like protein [Copromyxa protea] diamond 693 122 0.991803278688525 Eukaryota Amoebozoa   Tubulinea Elardia Euamoebida Hartmannellidae Copromyxa Copromyxa protea
31646727 31646727 PRJNA1028258_P_NODE_160397_length_229_cov_0.887500_g159834_i0 PRJNA1028258 160397 229 0.8875 2.032375 Chaos carolinense 160823 Tubulinea other_Eukaryota 143 1.9199999999999998e-40   NR AFX73090.1 160823 g159834 i0 90.7 0.982532751091703 75 7 98.3 0 227 3 54 128 AFX73090.1 elongation factor 2 alpha, partial [Chaos carolinense] diamond 225 143 1 Eukaryota Amoebozoa   Tubulinea Elardia Euamoebida Amoebidae Chaos Chaos carolinense

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