RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA1085664" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Bacteria · 23 ✖

bioproject 1

  • PRJNA1085664 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
26687618 26687618 PRJNA1085664_S_NODE_8221_length_301_cov_3.542636_g7802_i0 PRJNA1085664 8221 301 3.542636 10.66333436 Shigella sonnei 624 Bacteria Bacteria 108 1.47e-28   NR WP_353763804.1 624 g7802 i0 95.1 0.60797342192691 61 2 60.8 1 226 44 23 82 WP_353763804.1 hypothetical protein, partial [Shigella sonnei] diamond 183 108 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
27162089 27162089 PRJNA1085664_S_NODE_32362_length_157_cov_1.026316_g31943_i0 PRJNA1085664 32362 157 1.026316 1.61131612 Cutibacterium acnes 1747 Bacteria Bacteria 60.8 4.04e-9   NR MES6284439.1 1747 g31943 i0 62 1.8343949044586 50 19 95.5 0 6 155 109 158 MES6284439.1 hypothetical protein [Cutibacterium acnes] diamond 288 60.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
27257128 27257128 PRJNA1085664_S_NODE_29983_length_162_cov_1.605042_g29564_i0 PRJNA1085664 29983 162 1.605042 2.60016804 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 54.3 1.01e-6   NR WP_187150751.1 432608 g29564 i0 57.1 0.777777777777778 42 18 77.8 0 3 128 433 474 WP_187150751.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 126 54.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27794193 27794193 PRJNA1085664_S_NODE_9304_length_284_cov_2.564315_g8885_i0 PRJNA1085664 9304 284 2.564315 7.2826546 Streptomyces sp. NPDC 1931 Bacteria Bacteria 42.7 0.0425   NR WP_366067297.1 3155153 g8885 i0 38.9 0.76056338028169 72 43 75 1 37 249 15 86 WP_366067297.1 hypothetical protein [Streptomyces sp. NPDC049577] diamond 216 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC049577
28046602 28046602 PRJNA1085664_S_NODE_23065_length_183_cov_1.007143_g22646_i0 PRJNA1085664 23065 183 1.007143 1.84307169 Mycoplasma wenyonii 65123 Bacteria Bacteria 50.4 2.95e-5   NR WP_112665014.1 65123 g22646 i0 81.5 0.442622950819672 27 5 44.3 0 5 85 12 38 WP_112665014.1 hypothetical protein [Mycoplasma wenyonii] diamond 81 50.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28330719 28330719 PRJNA1085664_S_NODE_30186_length_162_cov_0.831933_g29767_i0 PRJNA1085664 30186 162 0.831933 1.34773146 Aphanothece hegewaldii 1521625 Bacteria Bacteria 41.2 0.0438   NR WP_106456550.1 1521625 g29767 i0 58.3 0.444444444444444 24 10 44.4 0 32 103 148 171 WP_106456550.1 PAS domain S-box protein [Aphanothece hegewaldii] diamond 72 41.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Aphanothece Aphanothece hegewaldii
28678279 28678279 PRJNA1085664_S_NODE_23387_length_182_cov_0.906475_g22968_i0 PRJNA1085664 23387 182 0.906475 1.6497845 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 110 1.52e-26   NR WP_187150185.1 432608 g22968 i0 98.3 0.989010989010989 60 1 98.9 0 2 181 513 572 WP_187150185.1 VacB/RNase II family 3'-5' exoribonuclease [Candidatus Mycoplasma haematobovis] diamond 180 110 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28994150 28994150 PRJNA1085664_S_NODE_16768_length_212_cov_2.272189_g16349_i0 PRJNA1085664 16768 212 2.272189 4.81704068 Micromonospora sp. NPDC 1876 Bacteria Bacteria 42.7 0.0246   NR WP_393523195.1 3364269 g16349 i0 41.2 0.721698113207547 51 29 72.2 1 158 6 227 276 WP_393523195.1 aspartate aminotransferase family protein [Micromonospora sp. NPDC049282] diamond 153 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Micromonospora Micromonospora sp. NPDC049282
29152094 29152094 PRJNA1085664_S_NODE_35309_length_152_cov_0.880734_g34890_i0 PRJNA1085664 35309 152 0.880734 1.33871568 Salmonella enterica 28901 Bacteria Bacteria 42.4 0.00299   NR WP_348968400.1 28901 g34890 i0 52.5 0.789473684210526 40 18 77 1 148 32 8 47 WP_348968400.1 hypothetical protein, partial [Salmonella enterica] diamond 120 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
29688173 29688173 PRJNA1085664_S_NODE_9950_length_275_cov_3.818966_g9531_i0 PRJNA1085664 9950 275 3.818966 10.5021565 Escherichia coli 562 Bacteria Bacteria 43.1 0.00451   NR WP_318767919.1 562 g9531 i0 52.5 0.436363636363636 40 18 42.5 1 171 55 16 55 WP_318767919.1 RBD-like domain-containing protein, partial [Escherichia coli] diamond 120 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
29846385 29846385 PRJNA1085664_S_NODE_21751_length_188_cov_0.889655_g21332_i0 PRJNA1085664 21751 188 0.889655 1.6725514 Chloroflexota bacterium 2026724 Bacteria Bacteria 42.7 0.0117   NR HEX2036551.1 2026724 g21332 i0 42.6 0.861702127659574 54 31 86.2 0 15 176 10 63 HEX2036551.1 pyridoxal-phosphate dependent enzyme [Chloroflexota bacterium] diamond 162 42.7 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
30225427 30225427 PRJNA1085664_S_NODE_37172_length_150_cov_0.897196_g36753_i0 PRJNA1085664 37172 150 0.897196 1.345794 Posidoniimonas polymericola 2528002 Bacteria Bacteria 40.4 0.0212   NR WP_146590768.1 2528002 g36753 i0 47.7 0.88 44 21 86 2 20 148 31 73 WP_146590768.1 hypothetical protein [Posidoniimonas polymericola] diamond 132 40.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Posidoniimonas Posidoniimonas polymericola
30320801 30320801 PRJNA1085664_S_NODE_22592_length_184_cov_2.921986_g22173_i0 PRJNA1085664 22592 184 2.921986 5.37645424 Myxococcota bacterium 2818507 Bacteria Bacteria 46.2 0.00102   NR MEC8276633.1 2818507 g22173 i0 35.8 2.47826086956522 53 29 86.4 1 14 172 186 233 MEC8276633.1 hypothetical protein [Myxococcota bacterium] diamond 456 46.2 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
30352407 30352407 PRJNA1085664_S_NODE_11812_length_253_cov_1.371429_g11393_i0 PRJNA1085664 11812 253 1.371429 3.46971537 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 43.9 0.00823   NR MEY2498050.1 2026799 g11393 i0 31 1.03162055335968 87 41 83 3 249 40 36 120 MEY2498050.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 261 43.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30762693 30762693 PRJNA1085664_S_NODE_13354_length_238_cov_1.035897_g12935_i0 PRJNA1085664 13354 238 1.035897 2.46543486 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 42.4 0.0461   NR MBS0660550.1 2026799 g12935 i0 40.8 0.894957983193277 71 38 88.2 3 28 237 170 237 MBS0660550.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 213 42.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30794106 30794106 PRJNA1085664_S_NODE_27474_length_169_cov_1.142857_g27055_i0 PRJNA1085664 27474 169 1.142857 1.93142833 Helicobacter pylori 210 Bacteria Bacteria 59.7 2.44e-10   NR GAA8856488.1 210 g27055 i0 71.8 0.692307692307692 39 11 69.2 0 18 134 4 42 GAA8856488.1 hypothetical protein Kyoto154A_2050 [Helicobacter pylori] diamond 117 59.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30983955 30983955 PRJNA1085664_S_NODE_23134_length_182_cov_3.575540_g22715_i0 PRJNA1085664 23134 182 3.57554 6.5074828 Anaerolineales bacterium 2073117 Bacteria Bacteria 43.5 0.00841   NR HET9588558.1 2073117 g22715 i0 41.7 0.791208791208791 48 28 79.1 0 22 165 136 183 HET9588558.1 ABC-2 family transporter protein [Anaerolineales bacterium] diamond 144 43.5 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
31489847 31489847 PRJNA1085664_S_NODE_12416_length_246_cov_6.369458_g11997_i0 PRJNA1085664 12416 246 6.369458 15.66886668 Aureitalea sp. L 1872661 Bacteria Bacteria 46.2 0.00229   NR WP_265198814.1 2816962 g11997 i0 30.8 0.951219512195122 78 54 95.1 0 2 235 226 303 WP_265198814.1 hybrid sensor histidine kinase/response regulator [Aureitalea sp. L0-47] diamond 234 46.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Aureitalea Aureitalea sp. L0-47
31489848 31489848 PRJNA1085664_S_NODE_20456_length_193_cov_1.880000_g20037_i0 PRJNA1085664 20456 193 1.88 3.6284 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 81.3 3.49e-16   NR WP_187150734.1 432608 g20037 i0 62.3 0.948186528497409 61 21 94.8 1 192 10 33 91 WP_187150734.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 183 81.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31647581 31647581 PRJNA1085664_S_NODE_19457_length_198_cov_0.870968_g19038_i0 PRJNA1085664 19457 198 0.870968 1.72451664 Actinomycetota bacterium 2900548 Bacteria Bacteria 42.4 0.0232   NR MEA2843586.1 2900548 g19038 i0 48.6 0.560606060606061 37 19 56.1 0 24 134 61 97 MEA2843586.1 purine-nucleoside/S-methyl-5-thioadenosine phosphorylase / adenosine deaminase [Actinomycetota bacterium] diamond 111 42.4 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31711045 31711045 PRJNA1085664_S_NODE_34437_length_153_cov_0.872727_g34018_i0 PRJNA1085664 34437 153 0.872727 1.33527231 Gammaproteobacteria bacterium 28-57-27 1970513 Bacteria Bacteria 43.5 0.00574   NR OYY73998.1 1970513 g34018 i0 35.7 0.823529411764706 42 27 82.4 0 152 27 331 372 OYY73998.1 MAG: hypothetical protein B7Y40_07020 [Gammaproteobacteria bacterium 28-57-27] diamond 126 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium 28-57-27
32027411 32027411 PRJNA1085664_S_NODE_28998_length_165_cov_1.163934_g28579_i0 PRJNA1085664 28998 165 1.163934 1.9204911 Rouxiella aceris 2703884 Bacteria Bacteria 41.2 0.0377   NR WP_169402176.1 2703884 g28579 i0 42.6 0.854545454545454 47 26 83.6 1 163 26 141 187 WP_169402176.1 type III secretion system domain-containing protein [Rouxiella aceris] diamond 141 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Yersiniaceae Rouxiella Rouxiella aceris
32848601 32848601 PRJNA1085664_S_NODE_21540_length_188_cov_5.296552_g21121_i0 PRJNA1085664 21540 188 5.296552 9.95751776 Klebsiella pneumoniae 573 Bacteria Bacteria 48.5 4.63e-5   NR WP_416532855.1 573 g21121 i0 59.4 1.00531914893617 32 13 51.1 0 186 91 100 131 WP_416532855.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 189 48.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae

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