RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Bacteria · 23 ✖

tax_clade 1

bioproject 1

  • PRJNA1168532 · 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
5418288 5418288 PRJNA1168532_S_NODE_9285_length_801_cov_2.121372_g7745_i0 PRJNA1168532 9285 801 2.121372 16.99218972 Fructilactobacillus sanfranciscensis 1625 Bacteria Bacteria 143 2.87e-39   NR POH17992.1 1625 g7745 i0 60.3 0.49063670411985 131 52 49.1 0 102 494 1 131 POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis] diamond 393 143 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Fructilactobacillus Fructilactobacillus sanfranciscensis
26597009 26597009 PRJNA1168532_S_NODE_264961_length_183_cov_1.307143_g262018_i0 PRJNA1168532 264961 183 1.307143 2.39207169 Mycoplasma wenyonii 65123 Bacteria Bacteria 51.2 6.9e-6   NR WP_112665915.1 65123 g262018 i0 47.9 0.786885245901639 48 9 78.7 1 3 146 58 89 WP_112665915.1 hypothetical protein [Mycoplasma wenyonii] diamond 144 51.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27103583 27103583 PRJNA1168532_S_NODE_254542_length_188_cov_1.296552_g251599_i0 PRJNA1168532 254542 188 1.296552 2.43751776 Helicobacter pylori 210 Bacteria Bacteria 43.9 0.00646   NR GAA8854026.1 210 g251599 i0 48 3.98936170212766 50 18 67 2 63 188 67 116 GAA8854026.1 hypothetical protein Kyoto154A_0970 [Helicobacter pylori] diamond 750 43.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27281089 27281089 PRJNA1168532_S_NODE_169343_length_242_cov_1.964824_g166400_i0 PRJNA1168532 169343 242 1.964824 4.75487408 Nitrosomonas 914 Bacteria Bacteria 75.1 1.46e-13   NR WP_082110325.1 914 g166400 i0 49.4 4.97107438016529 81 40 99.2 1 1 240 383 463 WP_082110325.1 MULTISPECIES: glycosyltransferase [Nitrosomonas] diamond 1203 75.5 0.994701986754967 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosomonas  
28082737 28082737 PRJNA1168532_S_NODE_260745_length_185_cov_1.288732_g257802_i0 PRJNA1168532 260745 185 1.288732 2.3841542 Acidobacteriota bacterium 1978231 Bacteria Bacteria 41.6 0.0431   NR MBM3765365.1 1978231 g257802 i0 44 0.810810810810811 50 24 81.1 1 28 177 163 208 MBM3765365.1 hypothetical protein [Acidobacteriota bacterium] diamond 150 41.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28146170 28146170 PRJNA1168532_S_NODE_232565_length_200_cov_0.885350_g229622_i0 PRJNA1168532 232565 200 0.88535 1.7707 Staphylococcus aureus 1280 Bacteria Bacteria 54.7 1.26e-6   NR QHG80002.1 1280 g229622 i0 50 1.02 68 28 99 3 198 1 297 360 QHG80002.1 hypothetical protein D7B62_12520 [Staphylococcus aureus] diamond 204 54.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
28146171 28146171 PRJNA1168532_S_NODE_348325_length_153_cov_1.281818_g345382_i0 PRJNA1168532 348325 153 1.281818 1.96118154 Mycoplasma wenyonii 65123 Bacteria Bacteria 63.5 5.07e-10   NR WP_112665000.1 65123 g345382 i0 100 0.647058823529412 33 0 64.7 0 99 1 529 561 WP_112665000.1 CHC2 zinc finger domain-containing protein [Mycoplasma wenyonii] diamond 99 63.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28430247 28430247 PRJNA1168532_S_NODE_363046_length_150_cov_0.878505_g360103_i0 PRJNA1168532 363046 150 0.878505 1.3177575 Pseudomonas oryzihabitans 47885 Bacteria Bacteria 75.9 9.81e-15   NR WP_313333256.1 47885 g360103 i0 100 0.78 39 0 78 0 149 33 256 294 WP_313333256.1 LysR family transcriptional regulator [Pseudomonas oryzihabitans] diamond 117 75.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas oryzihabitans
28682903 28682903 PRJNA1168532_S_NODE_230747_length_201_cov_0.892405_g227804_i0 PRJNA1168532 230747 201 0.892405 1.79373405 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 105 1.24e-26   NR WP_187149852.1 432608 g227804 i0 100 0.82089552238806 55 0 82.1 0 192 28 1 55 WP_187149852.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 165 105 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
29377334 29377334 PRJNA1168532_S_NODE_275489_length_178_cov_1.740741_g272546_i0 PRJNA1168532 275489 178 1.740741 3.09851898 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 44.7 0.00316   NR WP_187150753.1 432608 g272546 i0 58.1 0.72471910112359506 43 18 72.5 0 48 176 4 46 WP_187150753.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 129 44.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30040527 30040527 PRJNA1168532_S_NODE_243411_length_194_cov_1.205298_g240468_i0 PRJNA1168532 243411 194 1.205298 2.33827812 Mycoplasma ovis 171632 Bacteria Bacteria 88.6 1.3e-18   NR WP_327084515.1 171632 g240468 i0 81.8 2.55154639175258 55 10 85.1 0 3 167 271 325 WP_327084515.1 methionine--tRNA ligase [Mycoplasma ovis] diamond 495 88.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
30166730 30166730 PRJNA1168532_S_NODE_337692_length_156_cov_1.415929_g334749_i0 PRJNA1168532 337692 156 1.415929 2.20884924 Mycoplasma wenyonii 65123 Bacteria Bacteria 92 4.49e-20   NR WP_112665841.1 65123 g334749 i0 81.8 1.05769230769231 55 7 100 1 156 1 223 277 WP_112665841.1 MIP family Ig-specific serine endopeptidase [Mycoplasma wenyonii] diamond 165 92 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30293670 30293670 PRJNA1168532_S_NODE_232152_length_200_cov_1.331210_g229209_i0 PRJNA1168532 232152 200 1.33121 2.66242 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 44.7 0.00434   NR WP_187150745.1 432608 g229209 i0 71.4 0.9 28 7 40.5 1 14 94 332 359 WP_187150745.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 180 44.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30672299 30672299 PRJNA1168532_S_NODE_345493_length_154_cov_1.036036_g342550_i0 PRJNA1168532 345493 154 1.036036 1.59549544 Bacteroidales bacterium 2030927 Bacteria Bacteria 73.9 5.77e-15   NR MCI5814055.1 2030927 g342550 i0 100 0.720779220779221 37 0 72.1 0 113 3 1 37 MCI5814055.1 hypothetical protein [Bacteroidales bacterium] diamond 111 73.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
30703965 30703965 PRJNA1168532_S_NODE_302314_length_168_cov_1.128000_g299371_i0 PRJNA1168532 302314 168 1.128 1.89504 Bacteroidales bacterium 2030927 Bacteria Bacteria 55.8 3.14e-7   NR MBO5471727.1 2030927 g299371 i0 100 0.482142857142857 27 0 48.2 0 87 167 1 27 MBO5471727.1 TonB-dependent receptor [Bacteroidales bacterium] diamond 81 55.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
30735561 30735561 PRJNA1168532_S_NODE_174514_length_238_cov_1.266667_g171571_i0 PRJNA1168532 174514 238 1.266667 3.01466746 Mycoplasma wenyonii 65123 Bacteria Bacteria 146 4.22e-44   NR WP_110555200.1 65123 g171571 i0 97.3 0.920168067226891 73 2 92 0 237 19 4 76 WP_110555200.1 50S ribosomal protein L31 [Mycoplasma wenyonii] diamond 219 146 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30735562 30735562 PRJNA1168532_S_NODE_84734_length_345_cov_2.453642_g81791_i0 PRJNA1168532 84734 345 2.453642 8.4650649 Cutibacterium acnes 1747 Bacteria Bacteria 54.3 9.04e-6   NR MES6376112.1 1747 g81791 i0 46.6 0.504347826086956 58 29 48.7 1 134 301 258 315 MES6376112.1 reverse transcriptase family protein [Cutibacterium acnes] diamond 174 54.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
31165272 31165272 PRJNA1168532_S_NODE_314215_length_164_cov_0.809917_g311272_i0 PRJNA1168532 314215 164 0.809917 1.32826388 root 1 Root_unresolved Root_unresolved 90.1 3.4900000000000005e-21   NR WP_236536977.1 317 g311272 i0 83.3 36.530487804878 54 9 98.8 0 1 162 76 129 WP_236536977.1 phosphotransferase, partial [Pseudomonas syringae] diamond 5991 90.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae
31241040 31241040 PRJNA1168532_S_NODE_182275_length_232_cov_1.174603_g179332_i0 PRJNA1168532 182275 232 1.174603 2.72507896 Pseudomonas aeruginosa 287 Bacteria Bacteria 75.1 4.4e-16   NR WP_410954888.1 287 g179332 i0 86 0.556034482758621 43 6 55.6 0 99 227 7 49 WP_410954888.1 hypothetical protein, partial [Pseudomonas aeruginosa] diamond 129 75.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
31494359 31494359 PRJNA1168532_S_NODE_208496_length_214_cov_1.099415_g205553_i0 PRJNA1168532 208496 214 1.099415 2.3527481 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 120 5.1e-32   NR WP_187149669.1 432608 g205553 i0 100 0.883177570093458 63 0 88.3 0 191 3 133 195 WP_187149669.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 189 120 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31652180 31652180 PRJNA1168532_S_NODE_311017_length_165_cov_1.155738_g308074_i0 PRJNA1168532 311017 165 1.155738 1.9069677 Mycoplasma wenyonii 65123 Bacteria Bacteria 72.4 4.56e-13   NR WP_014849924.1 65123 g308074 i0 80.5 0.745454545454545 41 8 74.5 0 123 1 361 401 WP_014849924.1 glutamine-hydrolyzing GMP synthase [Mycoplasma wenyonii] diamond 123 72.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32127106 32127106 PRJNA1168532_S_NODE_160498_length_250_cov_1.338164_g157555_i0 PRJNA1168532 160498 250 1.338164 3.34541 Sulfitobacter sp. 1903071 Bacteria Bacteria 44.3 0.00695   NR MEH6831101.1 1903071 g157555 i0 46.2 0.468 39 20 45.6 1 128 15 36 74 MEH6831101.1 GNAT family N-acetyltransferase [Sulfitobacter sp.] diamond 117 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Roseobacteraceae Sulfitobacter Sulfitobacter sp.
32884596 32884596 PRJNA1168532_S_NODE_360480_length_150_cov_1.317757_g357537_i0 PRJNA1168532 360480 150 1.317757 1.9766355 Mycoplasma wenyonii 65123 Bacteria Bacteria 71.6 5.29e-13   NR WP_112665748.1 65123 g357537 i0 75.6 0.82 41 10 82 0 3 125 1 41 WP_112665748.1 hypothetical protein [Mycoplasma wenyonii] diamond 123 71.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii

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