RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA314497" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA314497 · 7 ✖

analysis 1

  • diamond · 7 ✖

tax_clade 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
24606676 24606676 PRJNA314497_S_NODE_20_length_1327_cov_7.984592_g15_i0 PRJNA314497 20 1327 7.984592 105.95553584 unclassified Undibacterium 2630295 Bacteria Bacteria 323 4.27e-100   NR WP_322119055.1 2630295 g15 i0 63.4 1.81763376036172 279 95 61.9 4 828 7 1 277 WP_322119055.1 MULTISPECIES: chemotaxis protein CheA [unclassified Undibacterium] diamond 2412 323 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium  
26599187 26599187 PRJNA314497_P_NODE_2881_length_306_cov_2.267148_g2730_i0 PRJNA314497 2881 306 2.267148 6.93747288 Pasteurella skyensis 97481 Bacteria Bacteria 135 5.37e-37   NR WP_306400629.1 97481 g2730 i0 65.3 4.72549019607843 95 33 93.1 0 293 9 11 105 WP_306400629.1 IS256 family transposase, variant Zn-binding type, partial [Pasteurella skyensis] diamond 1446 135 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Phocoenobacter Phocoenobacter skyensis
27579765 27579765 PRJNA314497_P_NODE_3044_length_295_cov_3.338346_g2892_i0 PRJNA314497 3044 295 3.338346 9.8481207 Geminicoccus harenae 2498453 Bacteria Bacteria 52 1.91e-6   NR WP_222185125.1 2498453 g2892 i0 95.5 0.223728813559322 22 1 22.4 0 293 228 1 22 WP_222185125.1 hypothetical protein, partial [Geminicoccus harenae] diamond 66 52 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Geminicoccales Geminicoccaceae Geminicoccus Geminicoccus harenae
28116509 28116509 PRJNA314497_S_NODE_645_length_296_cov_6.209738_g622_i0 PRJNA314497 645 296 6.209738 18.38082448 Herbaspirillum rubrisubalbicans 80842 Bacteria Bacteria 60.1 3.48e-9   NR WP_237742021.1 80842 g622 i0 65.2 0.466216216216216 46 15 46.6 1 259 122 1 45 WP_237742021.1 hypothetical protein, partial [Herbaspirillum rubrisubalbicans] diamond 138 60.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Herbaspirillum Herbaspirillum rubrisubalbicans
28621936 28621936 PRJNA314497_S_NODE_507_length_338_cov_5.944984_g484_i0 PRJNA314497 507 338 5.944984 20.09404592 Herbaspirillum rubrisubalbicans 80842 Bacteria Bacteria 60.5 3.9e-9   NR WP_237742021.1 80842 g484 i0 67.9 0.470414201183432 53 15 47 1 106 264 2 52 WP_237742021.1 hypothetical protein, partial [Herbaspirillum rubrisubalbicans] diamond 159 60.5 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Herbaspirillum Herbaspirillum rubrisubalbicans
29348067 29348067 PRJNA314497_P_NODE_3149_length_286_cov_2.190661_g2997_i0 PRJNA314497 3149 286 2.190661 6.26529046 Coxiella sp. RIFCSPHIGHO2_12_FULL_44_14 1797697 Bacteria Bacteria 89.4 2.64e-18   NR OGO93707.1 1797697 g2997 i0 44.4 13.4895104895105 99 51 99.7 1 285 1 382 480 OGO93707.1 MAG: ATP-dependent Clp protease ATP-binding subunit ClpA [Coxiella sp. RIFCSPHIGHO2_12_FULL_44_14] diamond 3858 89.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Legionellales Coxiellaceae Coxiella Coxiella sp. RIFCSPHIGHO2_12_FULL_44_14
32336708 32336708 PRJNA314497_S_NODE_1519_length_179_cov_2.773333_g1496_i0 PRJNA314497 1519 179 2.773333 4.96426607 Marinobacter 2742 Bacteria Bacteria 117 5.57e-30   NR WP_273017580.1 83889 g1496 i0 91.5 4.94413407821229 59 5 98.9 0 2 178 74 132 WP_273017580.1 MULTISPECIES: polysaccharide deacetylase family protein [unclassified Marinobacter] diamond 885 117 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Marinobacteraceae Marinobacter  

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