RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA358049" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA358049 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
27707091 27707091 PRJNA358049_S_NODE_13684_length_180_cov_2.381679_g13636_i0 PRJNA358049 13684 180 2.381679 4.2870222 Candidatus Megaera polyxenophila 988779 Bacteria Bacteria 78.2 3.05e-16   NR WP_223939462.1 988779 g13636 i0 82.2 0.75 45 8 75 0 21 155 131 175 WP_223939462.1 30S ribosomal protein S5 [Candidatus Megaera polyxenophila] diamond 135 78.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales Rickettsiaceae Candidatus Megaera Candidatus Megaera polyxenophila
27707094 27707094 PRJNA358049_S_NODE_16404_length_167_cov_1.322034_g16356_i0 PRJNA358049 16404 167 1.322034 2.20779678 Massilia sp. IC2-278 2887200 Bacteria Bacteria 110 6e-28   NR WP_229437424.1 2887200 g16356 i0 94.5 0.988023952095808 55 3 98.8 0 165 1 163 217 WP_229437424.1 HDOD domain-containing protein [Massilia sp. IC2-278] diamond 165 110 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Massilia Massilia sp. IC2-278
28906273 28906273 PRJNA358049_S_NODE_4648_length_280_cov_2.017316_g4600_i0 PRJNA358049 4648 280 2.017316 5.6484848 Enterobacter hormaechei 158836 Bacteria Bacteria 146 9.52e-44   NR WP_416359507.1 158836 g4600 i0 100 0.782142857142857 73 0 78.2 0 1 219 12 84 WP_416359507.1 AMP-binding enzyme, partial [Enterobacter hormaechei] diamond 219 146 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Enterobacter Enterobacter hormaechei
30169482 30169482 PRJNA358049_S_NODE_6552_length_242_cov_1.336788_g6504_i0 PRJNA358049 6552 242 1.336788 3.23502696 Haemophilus parainfluenzae 729 Bacteria Bacteria 152 6.08e-42   NR MBF1224380.1 729 g6504 i0 96.3 0.991735537190083 80 3 99.2 0 1 240 120 199 MBF1224380.1 transferrin-binding protein-like solute binding protein [Haemophilus parainfluenzae] diamond 240 152 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Haemophilus Haemophilus parainfluenzae
30264739 30264739 PRJNA358049_S_NODE_16572_length_167_cov_0.881356_g16524_i0 PRJNA358049 16572 167 0.881356 1.47186452 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 100 8.1999999999999994e-23   NR MEA3178655.1 1913989 g16524 i0 91.8 0.880239520958084 49 4 88 0 1 147 648 696 MEA3178655.1 3-hydroxyacyl-CoA dehydrogenase [Gammaproteobacteria bacterium] diamond 147 100 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
30517188 30517188 PRJNA358049_S_NODE_8953_length_212_cov_1.871166_g8905_i0 PRJNA358049 8953 212 1.871166 3.96687192 Sphingomonas sp. PP-CE-3A-4 28214 Bacteria Bacteria 131 3.41e-35   NR WP_121904846.1 2135659 g8905 i0 90 0.990566037735849 70 7 99.1 0 212 3 203 272 WP_121904846.1 DGQHR domain-containing protein [Sphingomonas sp. PP-CE-3A-406] diamond 210 131 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp. PP-CE-3A-406
31180359 31180359 PRJNA358049_S_NODE_2575_length_369_cov_2.100000_g2527_i0 PRJNA358049 2575 369 2.1 7.749 Sphingobium 165695 Bacteria Bacteria 68.9 2.57e-12   NR WP_041386106.1 165695 g2527 i0 43.6 0.634146341463415 78 44 63.4 0 234 1 1 78 WP_041386106.1 MULTISPECIES: hypothetical protein [Sphingobium] diamond 234 68.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingobium  
32477902 32477902 PRJNA358049_S_NODE_8019_length_222_cov_1.202312_g7971_i0 PRJNA358049 8019 222 1.202312 2.66913264 Pseudomonadota bacterium 1977087 Bacteria Bacteria 64.3 6.49e-10   NR MEM1113356.1 1977087 g7971 i0 43.1 0.972972972972973 72 41 97.3 0 5 220 261 332 MEM1113356.1 glycosyltransferase family 4 protein [Pseudomonadota bacterium] diamond 216 64.3 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
32541238 32541238 PRJNA358049_S_NODE_9959_length_204_cov_1.316129_g9911_i0 PRJNA358049 9959 204 1.316129 2.68490316 Francisella sp. 2047875 Bacteria Bacteria 119 3.5e-31   NR PZU03636.1 2047875 g9911 i0 100 1 68 0 100 0 1 204 134 201 PZU03636.1 MAG: hypothetical protein DI619_04220 [Francisella sp.] diamond 204 119 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Thiotrichales Francisellaceae Francisella Francisella sp.
32621061 32621061 PRJNA358049_S_NODE_4940_length_273_cov_1.531250_g4892_i0 PRJNA358049 4940 273 1.53125 4.1803125 Cellvibrio 10 Bacteria Bacteria 86.7 1.63e-17   NR RYY74350.1 1913989 g4892 i0 89.6 1.58241758241758 48 5 52.7 0 272 129 415 462 RYY74350.1 MAG: UDP-N-acetylmuramate--L-alanine ligase [Gammaproteobacteria bacterium] diamond 432 86.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium

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