RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA927284" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA927284 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
17479995 17479995 PRJNA927284_P_NODE_6354_length_211_cov_1.384615_g6147_i0 PRJNA927284 6354 211 1.384615 2.92153765 Undibacterium 401469 Bacteria Bacteria 118 2.8199999999999997e-30   NR WP_189357611.1 1131567 g6147 i0 91.3 1.96208530805687 69 6 98.1 0 3 209 15 83 WP_189357611.1 porin [Undibacterium squillarum] diamond 414 119 0.991596638655462 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium squillarum
22579013 22579013 PRJNA927284_P_NODE_6018_length_221_cov_1.739583_g5811_i0 PRJNA927284 6018 221 1.739583 3.84447843 Salmonella sp. s54925 3159674 Bacteria Bacteria 80.1 1.19e-17   NR WP_411027451.1 3159674 g5811 i0 93 1.81900452488688 43 3 58.4 0 89 217 4 46 WP_411027451.1 MC/SLC25 family protein, partial [Salmonella sp. s54925] diamond 402 80.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella sp. s54925
30853419 30853419 PRJNA927284_P_NODE_8114_length_172_cov_1.748252_g7907_i0 PRJNA927284 8114 172 1.748252 3.00699344 root 1 Root_unresolved Root_unresolved 80.9 2.08e-18   NR TOF73137.1 670 g7907 i0 69.1 7.67441860465116 55 17 95.9 0 6 170 5 59 TOF73137.1 hypothetical protein CGJ15_27410, partial [Vibrio parahaemolyticus] diamond 1320 81.3 0.995079950799508 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio parahaemolyticus
30941239 30941239 PRJNA927284_P_NODE_2414_length_442_cov_2.329298_g2219_i0 PRJNA927284 2414 442 2.329298 10.29549716 unclassified Psychrobacter 196806 Bacteria Bacteria 45.1 0.0162   NR WP_192519134.1 196806 g2219 i0 43.5 0.420814479638009 62 30 42.1 2 393 208 67 123 WP_192519134.1 MULTISPECIES: hypothetical protein [unclassified Psychrobacter] diamond 186 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Psychrobacter  
32781574 32781574 PRJNA927284_P_NODE_8660_length_162_cov_2.729323_g8453_i0 PRJNA927284 8660 162 2.729323 4.42150326 root 1 Root_unresolved Root_unresolved 107 1.39e-25   NR WP_337456038.1 562 g8453 i0 96.3 674.944444444444 54 2 100 0 162 1 111 164 WP_337456038.1 tubulin alpha chain, partial [Escherichia coli] diamond 109341 108 0.990740740740741 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli

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