RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA520845" and tax_phylum = "Tubulinea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Tubulinea · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA520845 · 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
491262 491262 PRJNA520845_P_NODE_254701_length_243_cov_0.905882_g253202_i0 PRJNA520845 254701 243 0.905882 2.20129326 Saccamoeba lacustris 704142 Tubulinea other_Eukaryota 157 1.3e-45   NR AFX84551.1 704142 g253202 i0 98.8 1 81 1 100 0 1 243 7 87 AFX84551.1 alpha tubulin, partial [Saccamoeba lacustris] diamond 243 157 1 Eukaryota Amoebozoa   Tubulinea Elardia Euamoebida Hartmannellidae Saccamoeba Saccamoeba lacustris
8144368 8144368 PRJNA520845_P_NODE_254307_length_243_cov_0.905882_g252808_i0 PRJNA520845 254307 243 0.905882 2.20129326 Amoeba proteus 5775 Tubulinea other_Eukaryota 139 1.75e-37   NR AAP88974.1 5775 g252808 i0 78.8 1.97530864197531 80 17 98.8 0 2 241 65 144 AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] diamond 480 139 1 Eukaryota Amoebozoa   Tubulinea Elardia Euamoebida Amoebidae Amoeba Amoeba proteus
28940730 28940730 PRJNA520845_P_NODE_56968_length_494_cov_1.665083_g55474_i0 PRJNA520845 56968 494 1.665083 8.22551002 Saccamoeba lacustris 704142 Tubulinea other_Eukaryota 234 1.38e-74   NR AFX73097.1 704142 g55474 i0 72 0.977732793522267 161 41 97.8 1 12 494 102 258 AFX73097.1 elongation factor 2 alpha, partial [Saccamoeba lacustris] diamond 483 234 1 Eukaryota Amoebozoa   Tubulinea Elardia Euamoebida Hartmannellidae Saccamoeba Saccamoeba lacustris

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