RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA724011" 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

bioproject 1

  • PRJNA724011 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
27999981 27999981 PRJNA724011_P_NODE_85405_length_266_cov_1.994819_g84382_i0 PRJNA724011 85405 266 1.994819 5.30621854 Balneolaceae bacterium 2053516 Bacteria Bacteria 43.1 0.0366   NR HMB40791.1 2053516 g84382 i0 33.8 0.800751879699248 71 43 80.1 1 37 249 350 416 HMB40791.1 pullulanase-type alpha-1,6-glucosidase [Balneolaceae bacterium] diamond 213 43.1 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
28315618 28315618 PRJNA724011_P_NODE_98666_length_248_cov_0.880000_g97643_i0 PRJNA724011 98666 248 0.88 2.1824 Aliifodinibius sp. S!AR15-1 1872440 Bacteria Bacteria 44.3 0.00848   NR WP_310688425.1 2950437 g97643 i0 42.3 0.629032258064516 52 27 61.7 2 156 4 138 187 WP_310688425.1 hypothetical protein [Aliifodinibius sp. S!AR15-10] diamond 156 44.3 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Fodinibius Aliifodinibius sp. S!AR15-10
29936294 29936294 PRJNA724011_P_NODE_41191_length_413_cov_2.726471_g40168_i0 PRJNA724011 41191 413 2.726471 11.26032523 Fodinibius 1397106 Bacteria Bacteria 186 7.52e-57   NR WP_265789955.1 1920655 g40168 i0 73.7 6.0726392251816 118 31 85.7 0 357 4 1 118 WP_265789955.1 NAD(P)-dependent oxidoreductase [Fodinibius salicampi] diamond 2508 186 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Fodinibius Fodinibius salicampi
31031905 31031905 PRJNA724011_P_NODE_88235_length_261_cov_1.228723_g87212_i0 PRJNA724011 88235 261 1.228723 3.20696703 Cyclonatronum sp. 3024185 Bacteria Bacteria 121 1.75e-31   NR WP_363320519.1 3024185 g87212 i0 69.9 2.86206896551724 83 25 95.4 0 259 11 78 160 WP_363320519.1 3-hydroxybutyryl-CoA dehydrogenase [Cyclonatronum sp.] diamond 747 121 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Cyclonatronaceae Cyclonatronum Cyclonatronum 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);;