RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA966993", tax_clade = "FCB group" 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

  • FCB group · 3 ✖

bioproject 1

  • PRJNA966993 · 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
29078714 29078714 PRJNA966993_P_NODE_28748_length_395_cov_1.434783_g28296_i0 PRJNA966993 28748 395 1.434783 5.66739285 Balneolaceae bacterium 2053516 Bacteria Bacteria 49.7 7.16e-4   NR MDX1590317.1 2053516 g28296 i0 38.2 0.577215189873418 76 45 57.7 1 395 168 527 600 MDX1590317.1 molecular chaperone DnaK [Balneolaceae bacterium] diamond 228 49.7 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
29899687 29899687 PRJNA966993_P_NODE_67391_length_274_cov_1.398010_g66939_i0 PRJNA966993 67391 274 1.39801 3.8305474 Balneolales bacterium 2497613 Bacteria Bacteria 132 2.3399999999999998e-34   NR MCH8569152.1 2497613 g66939 i0 62.6 1.99270072992701 91 34 99.6 0 1 273 316 406 MCH8569152.1 DASH family cryptochrome [Balneolales bacterium] diamond 546 132 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales     Balneolales bacterium
32618229 32618229 PRJNA966993_P_NODE_47480_length_314_cov_0.921162_g47028_i0 PRJNA966993 47480 314 0.921162 2.89244868 Balneolaceae bacterium 2053516 Bacteria Bacteria 69.3 3.87e-11   NR MBN2731275.1 2053516 g47028 i0 41.4 0.945859872611465 99 49 94.6 2 303 7 127 216 MBN2731275.1 serine hydrolase [Balneolaceae bacterium] diamond 297 69.3 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium

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