RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA766854" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA766854 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
12224626 12224626 PRJNA766854_P_NODE_1470_length_342_cov_3.702875_g1345_i0 PRJNA766854 1470 342 3.702875 12.6638325 root 1 Root_unresolved Root_unresolved 171 1.84e-51   NR HAL9334457.1 562 g1345 i0 90.5 4.16666666666667 95 5 83.3 1 289 5 13 103 HAL9334457.1 MobA/MobL family protein [Escherichia coli] diamond 1425 171 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
26873273 26873273 PRJNA766854_P_NODE_2261_length_285_cov_3.136719_g2135_i0 PRJNA766854 2261 285 3.136719 8.93964915 root 1 Root_unresolved Root_unresolved 77.4 4.73e-15   NR HAL9334457.1 562 g2135 i0 100 2.08421052631579 33 0 34.7 0 2 100 20 52 HAL9334457.1 MobA/MobL family protein [Escherichia coli] diamond 594 77.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
27315864 27315864 PRJNA766854_P_NODE_1923_length_306_cov_1.873646_g1798_i0 PRJNA766854 1923 306 1.873646 5.73335676 Tepidiphilus 203470 Bacteria Bacteria 55.1 3.75e-6   NR WP_028873866.1 203471 g1798 i0 39.8 2.01960784313725 103 48 99 2 303 1 547 637 WP_028873866.1 sensor domain-containing diguanylate cyclase [Tepidiphilus margaritifer] diamond 618 55.1 1 Bacteria   Pseudomonadati Pseudomonadota Hydrogenophilia Hydrogenophilales Hydrogenophilaceae Tepidiphilus Tepidiphilus margaritifer
27622035 27622035 PRJNA766854_P_NODE_864_length_442_cov_1.225182_g753_i0 PRJNA766854 864 442 1.225182 5.41530444 Tepidiphilus olei 2502184 Bacteria Bacteria 46.6 0.0123   NR WP_142809912.1 2502184 g753 i0 40.2 0.556561085972851 82 43 55.7 1 246 1 45 120 WP_142809912.1 cysteine--tRNA ligase [Tepidiphilus olei] diamond 246 46.6 1 Bacteria   Pseudomonadati Pseudomonadota Hydrogenophilia Hydrogenophilales Hydrogenophilaceae Tepidiphilus Tepidiphilus olei
28831213 28831213 PRJNA766854_P_NODE_1768_length_313_cov_2.443662_g1643_i0 PRJNA766854 1768 313 2.443662 7.64866206 Pseudomonadota 1224 Bacteria Bacteria 44.3 0.0219   NR MDD2408326.1 1892567 g1643 i0 100 0.766773162939297 20 0 19.2 0 119 60 298 317 MDD2408326.1 porin [Tepidiphilus sp.] diamond 240 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Hydrogenophilia Hydrogenophilales Hydrogenophilaceae Tepidiphilus Tepidiphilus sp.
28894337 28894337 PRJNA766854_P_NODE_2588_length_269_cov_2.412500_g2462_i0 PRJNA766854 2588 269 2.4125 6.489625 Acinetobacter 469 Bacteria Bacteria 82.4 5.61e-17   NR WP_255032004.1 470 g2462 i0 52.8 1.98513011152416 89 42 99.3 0 2 268 93 181 WP_255032004.1 hypothetical protein, partial [Acinetobacter baumannii] diamond 534 82.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
29642323 29642323 PRJNA766854_P_NODE_1950_length_305_cov_3.782609_g1825_i0 PRJNA766854 1950 305 3.782609 11.53695745 Rheinheimera sp. F8 1763998 Bacteria Bacteria 83.6 9.65e-17   NR WP_208932254.1 1763998 g1825 i0 95.7 0.462295081967213 47 2 46.2 0 165 305 55 101 WP_208932254.1 tol-pal system protein YbgF [Rheinheimera sp. F8] diamond 141 83.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera sp. F8
29683487 29683487 PRJNA766854_P_NODE_18550_length_229_cov_9.060000_g18423_i0 PRJNA766854 18550 229 9.06 20.7474 root 1 Root_unresolved Root_unresolved 115 1.5999999999999999e-29   NR HAL9652624.1 562 g18423 i0 92.1 2.98689956331878 76 4 96.9 1 4 225 192 267 HAL9652624.1 MobA/MobL family protein [Escherichia coli] diamond 684 115 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
30347707 30347707 PRJNA766854_P_NODE_972_length_426_cov_2.085642_g857_i0 PRJNA766854 972 426 2.085642 8.88483492 Halomonadaceae 28256 Bacteria Bacteria 96.3 3.3700000000000003e-22   NR GHB13662.1 453962 g857 i0 70.1 1.41549295774648 67 20 47.2 0 350 150 44 110 GHB13662.1 hypothetical protein GCM10007159_40060 [Modicisalibacter luteus] diamond 603 97.1 0.991761071060762 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Halomonadaceae Modicisalibacter Modicisalibacter luteus
30442096 30442096 PRJNA766854_P_NODE_773_length_459_cov_1.344186_g664_i0 PRJNA766854 773 459 1.344186 6.16981374 Tepidiphilus 203470 Bacteria Bacteria 55.1 1.1e-5   NR WP_055423004.1 203470 g664 i0 36.9 1.34640522875817 103 48 56.2 1 459 202 130 232 WP_055423004.1 MULTISPECIES: methyltransferase domain-containing protein [Tepidiphilus] diamond 618 55.1 1 Bacteria   Pseudomonadati Pseudomonadota Hydrogenophilia Hydrogenophilales Hydrogenophilaceae Tepidiphilus  
31475418 31475418 PRJNA766854_P_NODE_18856_length_153_cov_3.112903_g18729_i0 PRJNA766854 18856 153 3.112903 4.76274159 Rheinheimera aquimaris 412437 Bacteria Bacteria 53.1 2.26e-6   NR WP_230819794.1 412437 g18729 i0 62.7 1 51 14 90.2 1 5 142 26 76 WP_230819794.1 hypothetical protein [Rheinheimera aquimaris] diamond 153 53.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera aquimaris
32582682 32582682 PRJNA766854_P_NODE_779_length_458_cov_1.244755_g670_i0 PRJNA766854 779 458 1.244755 5.7009779 Tepidiphilus succinatimandens 224436 Bacteria Bacteria 49.7 0.00114   NR WP_141056166.1 224436 g670 i0 100 0.137554585152838 21 0 13.8 0 65 3 211 231 WP_141056166.1 cytochrome D1 domain-containing protein [Tepidiphilus succinatimandens] diamond 63 49.7 1 Bacteria   Pseudomonadati Pseudomonadota Hydrogenophilia Hydrogenophilales Hydrogenophilaceae Tepidiphilus Tepidiphilus succinatimandens
32780831 32780831 PRJNA766854_P_NODE_2160_length_291_cov_2.450382_g2034_i0 PRJNA766854 2160 291 2.450382 7.13061162 Tepidiphilus 203470 Bacteria Bacteria 49.7 1.96e-5   NR WP_028875147.1 203470 g2034 i0 100 0.43298969072165 21 0 21.6 0 5 67 47 67 WP_028875147.1 MULTISPECIES: hypothetical protein [Tepidiphilus] diamond 126 49.7 1 Bacteria   Pseudomonadati Pseudomonadota Hydrogenophilia Hydrogenophilales Hydrogenophilaceae Tepidiphilus  

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