RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA982720 · 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
12750565 12750565 PRJNA982720_S_NODE_8250_length_257_cov_0.902174_g8222_i0 PRJNA982720 8250 257 0.902174 2.31858718 Pseudoalteromonas sp. CO1 53249 Bacteria Bacteria 114 8.4e-31   NR WP_205990978.1 1777235 g8222 i0 95 0.700389105058366 60 3 70 0 211 32 33 92 WP_205990978.1 hypothetical protein, partial [Pseudoalteromonas sp. CO109Y] diamond 180 114 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Pseudoalteromonadaceae Pseudoalteromonas Pseudoalteromonas sp. CO109Y
27215773 27215773 PRJNA982720_S_NODE_8782_length_251_cov_0.977528_g8754_i0 PRJNA982720 8782 251 0.977528 2.45359528 Klebsiella pneumoniae 573 Bacteria Bacteria 62 1.74e-10   NR WP_305200423.1 573 g8754 i0 62.2 0.537848605577689 45 17 53.8 0 73 207 5 49 WP_305200423.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 135 62 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28295562 28295562 PRJNA982720_S_NODE_7306_length_269_cov_1.015306_g7278_i0 PRJNA982720 7306 269 1.015306 2.73117314 root 1 Root_unresolved Root_unresolved 68.6 3.63e-13   NR CUV48234.1 305 g7278 i0 68 2.23048327137546 50 16 55.8 0 178 29 11 60 CUV48234.1 protein of unknown function [Ralstonia solanacearum] diamond 600 68.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Ralstonia Ralstonia solanacearum
31163498 31163498 PRJNA982720_S_NODE_6835_length_275_cov_1.044554_g6807_i0 PRJNA982720 6835 275 1.044554 2.8725235 Rhizobium laguerreae 1076926 Bacteria Bacteria 55.1 8.21e-8   NR WP_204347672.1 1076926 g6807 i0 65.9 0.447272727272727 41 14 44.7 0 125 247 20 60 WP_204347672.1 hypothetical protein, partial [Rhizobium laguerreae] diamond 123 55.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Rhizobium Rhizobium laguerreae
31258614 31258614 PRJNA982720_S_NODE_9375_length_245_cov_0.883721_g9347_i0 PRJNA982720 9375 245 0.883721 2.16511645 Stutzerimonas stutzeri 316 Bacteria Bacteria 86.3 5.27e-20   NR WP_219853451.1 316 g9347 i0 72.7 0.673469387755102 55 15 67.3 0 1 165 2 56 WP_219853451.1 hypothetical protein, partial [Stutzerimonas stutzeri] diamond 165 86.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Stutzerimonas Stutzerimonas stutzeri
31701421 31701421 PRJNA982720_S_NODE_4157_length_320_cov_0.878543_g4129_i0 PRJNA982720 4157 320 0.878543 2.8113376 Enterobacter hormaechei 158836 Bacteria Bacteria 89.4 5.53e-21   NR WP_251276324.1 158836 g4129 i0 63.8 0.646875 69 25 64.7 0 209 3 2 70 WP_251276324.1 hypothetical protein, partial [Enterobacter hormaechei] diamond 207 89.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Enterobacter Enterobacter hormaechei
32372021 32372021 PRJNA982720_S_NODE_6239_length_284_cov_0.810427_g6211_i0 PRJNA982720 6239 284 0.810427 2.30161268 Bacteria 2 Bacteria Bacteria 41.6 0.0169   NR WP_254995941.1 470 g6211 i0 61.3 1.10915492957746 31 12 32.7 0 209 117 25 55 WP_254995941.1 hypothetical protein, partial [Acinetobacter baumannii] diamond 315 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii

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