RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA814235" and tax_phylum = "Balneolota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Balneolota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA814235 · 3 ✖

analysis 1

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
27789763 27789763 PRJNA814235_P_NODE_113284_length_203_cov_1.981928_g111889_i0 PRJNA814235 113284 203 1.981928 4.02331384 Fodinibius 1397106 Bacteria Bacteria 58.2 4.55e-8   NR NIT61587.1 1872440 g111889 i0 100 0.738916256157635 25 0 36.9 0 2 76 141 165 NIT61587.1 ABC transporter ATP-binding protein [Fodinibius sp.] diamond 150 58.2 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Fodinibius Fodinibius sp.
29643428 29643428 PRJNA814235_P_NODE_118110_length_203_cov_1.837349_g116715_i0 PRJNA814235 118110 203 1.837349 3.72981847 Gracilimonas sp. 1974203 Bacteria Bacteria 54.7 1.37e-6   NR MEX2605035.1 1974203 g116715 i0 100 0.369458128078818 25 0 36.9 0 75 1 1430 1454 MEX2605035.1 cell surface protein SprA [Gracilimonas sp.] diamond 75 54.7 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Gracilimonas Gracilimonas sp.
31896342 31896342 PRJNA814235_P_NODE_191797_length_151_cov_2.859649_g190402_i0 PRJNA814235 191797 151 2.859649 4.31806999 Pseudomonadati 3379134 Bacteria Bacteria 53.5 1.64e-6   NR WP_290877122.1 1974203 g190402 i0 88 2.48344370860927 25 3 49.7 0 2 76 237 261 WP_290877122.1 radical SAM family heme chaperone HemW [Gracilimonas sp.] diamond 375 53.5 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Gracilimonas Gracilimonas sp.

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