RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA557436", 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 · 4 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 4 ✖

bioproject 1

  • PRJNA557436 · 4 ✖

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
28689668 28689668 PRJNA557436_S_NODE_967_length_365_cov_2.848485_g919_i0 PRJNA557436 967 365 2.848485 10.39697025 Fodinibius sp. 1872440 Bacteria Bacteria 160 1.62e-44   NR NIT58425.1 1872440 g919 i0 59.5 0.994520547945206 121 49 99.5 0 364 2 202 322 NIT58425.1 hypothetical protein [Fodinibius sp.] diamond 363 160 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Fodinibius Fodinibius sp.
30584172 30584172 PRJNA557436_S_NODE_3813_length_203_cov_1.863095_g3765_i0 PRJNA557436 3813 203 1.863095 3.78208285 Fodinibius sp. 1872440 Bacteria Bacteria 97.8 5.85e-22   NR NIT58425.1 1872440 g3765 i0 64.1 0.945812807881773 64 23 94.6 0 192 1 243 306 NIT58425.1 hypothetical protein [Fodinibius sp.] diamond 192 97.8 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Fodinibius Fodinibius sp.
31943605 31943605 PRJNA557436_S_NODE_3097_length_220_cov_2.778378_g3049_i0 PRJNA557436 3097 220 2.778378 6.1124316 Fodinibius sp. 1872440 Bacteria Bacteria 64.7 5e-10   NR NIT58379.1 1872440 g3049 i0 58.6 0.790909090909091 58 24 79.1 0 46 219 1 58 NIT58379.1 hypothetical protein [Fodinibius sp.] diamond 174 64.7 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Fodinibius Fodinibius sp.
32828530 32828530 PRJNA557436_S_NODE_6140_length_171_cov_2.647059_g6092_i0 PRJNA557436 6140 171 2.647059 4.52647089 Balneola sp. 2024824 Bacteria Bacteria 49.7 4.95e-5   NR HCT52799.1 2024824 g6092 i0 41.1 0.982456140350877 56 33 98.2 0 2 169 69 124 HCT52799.1 hypothetical protein [Balneola sp.] diamond 168 49.7 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola 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);;