RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJEB65329" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Bacteria · 18 ✖

bioproject 1

  • PRJEB65329 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
5232645 5232645 PRJEB65329_S_NODE_2405_length_640_cov_37.464812_g2287_i0 PRJEB65329 2405 640 37.464812 239.7747968 Phenylobacterium hankyongense 1813876 Bacteria Bacteria 129 6.519999999999998e-35   NR WP_207801906.1 1813876 g2287 i0 80.6 0.61875 67 13 31.4 0 581 381 15 81 WP_207801906.1 hypothetical protein, partial [Phenylobacterium hankyongense] diamond 396 129 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae Phenylobacterium Phenylobacterium hankyongense
15432637 15432637 PRJEB65329_S_NODE_7133_length_276_cov_4.562753_g6971_i0 PRJEB65329 7133 276 4.562753 12.59319828 root 1 Root_unresolved Root_unresolved 174 1.16e-52   NR WP_321130271.1 1496 g6971 i0 92.4 2 92 7 100 0 276 1 99 190 WP_321130271.1 GTP-binding protein, partial [Clostridioides difficile] diamond 552 174 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
26685610 26685610 PRJEB65329_S_NODE_12841_length_186_cov_2.089172_g12679_i0 PRJEB65329 12841 186 2.089172 3.88585992 Shigella flexneri 623 Bacteria Bacteria 73.6 2.3e-15   NR MDD0148654.1 623 g12679 i0 54.1 1.96774193548387 61 28 98.4 0 184 2 19 79 MDD0148654.1 hypothetical protein [Shigella flexneri] diamond 366 73.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella flexneri
26970540 26970540 PRJEB65329_S_NODE_7862_length_258_cov_2.633188_g7700_i0 PRJEB65329 7862 258 2.633188 6.79362504 Polyangia bacterium 3058050 Bacteria Bacteria 40.4 0.0376   NR HJX65230.1 3058050 g7700 i0 45 0.465116279069767 40 22 46.5 0 249 130 17 56 HJX65230.1 hypothetical protein [Polyangia bacterium] diamond 120 40.4 1 Bacteria   Pseudomonadati Myxococcota         Polyangia bacterium
27058514 27058514 PRJEB65329_S_NODE_18302_length_151_cov_2.934426_g18140_i0 PRJEB65329 18302 151 2.934426 4.43098326 root 1 Root_unresolved Root_unresolved 90.1 8.480000000000001e-21   NR MCJ0157548.1 1496 g18140 i0 76 13.8675496688742 50 12 99.3 0 150 1 99 148 MCJ0157548.1 40S ribosomal protein S3a/S1 [Clostridioides difficile] diamond 2094 90.9 0.991199119911991 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
27508117 27508117 PRJEB65329_S_NODE_17743_length_154_cov_2.016000_g17581_i0 PRJEB65329 17743 154 2.016 3.10464 Cyanobium sp. ELA507 3064509 Bacteria Bacteria 38.5 0.0448   NR MEI6617027.1 3064509 g17581 i0 50 0.701298701298701 36 15 64.3 1 123 25 1 36 MEI6617027.1 MBL fold metallo-hydrolase [Cyanobium sp. ELA507] diamond 108 38.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Cyanobium Cyanobium sp. ELA507
27792176 27792176 PRJEB65329_S_NODE_3624_length_475_cov_8.668161_g3468_i0 PRJEB65329 3624 475 8.668161 41.17376475 Phenylobacterium hankyongense 1813876 Bacteria Bacteria 110 2.5599999999999998e-28   NR WP_133255066.1 1813876 g3468 i0 65.5 1.22526315789474 87 30 54.9 0 67 327 13 99 WP_133255066.1 hypothetical protein, partial [Phenylobacterium hankyongense] diamond 582 110 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae Phenylobacterium Phenylobacterium hankyongense
28518373 28518373 PRJEB65329_S_NODE_13187_length_183_cov_2.045455_g13025_i0 PRJEB65329 13187 183 2.045455 3.74318265 Helicobacter pylori 210 Bacteria Bacteria 67.8 1.95e-13   NR GAA6795254.1 210 g13025 i0 62.2 0.737704918032787 45 17 73.8 0 165 31 2 46 GAA6795254.1 hypothetical protein Kyoto200A_0170 [Helicobacter pylori] diamond 135 67.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28613012 28613012 PRJEB65329_S_NODE_13247_length_182_cov_2.784314_g13085_i0 PRJEB65329 13247 182 2.784314 5.06745148 Thermogemmatispora sp. 1968838 Bacteria Bacteria 41.6 0.0419   NR WP_376797019.1 1968838 g13085 i0 38.2 0.906593406593407 55 18 87.4 2 24 182 82 122 WP_376797019.1 zinc-binding alcohol dehydrogenase family protein [Thermogemmatispora sp.] diamond 165 41.6 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Thermogemmatisporales Thermogemmatisporaceae Thermogemmatispora Thermogemmatispora sp.
29118408 29118408 PRJEB65329_S_NODE_12389_length_190_cov_3.055901_g12227_i0 PRJEB65329 12389 190 3.055901 5.8062119 Phycisphaerae bacterium 2026778 Bacteria Bacteria 43.1 0.0134   NR MAC74229.1 2026778 g12227 i0 41.3 0.726315789473684 46 25 72.6 1 50 187 3 46 MAC74229.1 hypothetical protein [Phycisphaerae bacterium] diamond 138 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
29497055 29497055 PRJEB65329_S_NODE_15970_length_163_cov_2.343284_g15808_i0 PRJEB65329 15970 163 2.343284 3.81955292 Planctomycetota bacterium 2026780 Bacteria Bacteria 42 0.0238   NR MBA4685306.1 2026780 g15808 i0 48.8 0.791411042944785 43 22 79.1 0 22 150 182 224 MBA4685306.1 glycosyltransferase family 2 protein [Planctomycetota bacterium] diamond 129 42 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29654525 29654525 PRJEB65329_S_NODE_12650_length_188_cov_1.886792_g12488_i0 PRJEB65329 12650 188 1.886792 3.54716896 Streptomyces caniscabiei 2746961 Bacteria Bacteria 41.2 0.0372   NR WP_319106296.1 2746961 g12488 i0 47.2 0.574468085106383 36 19 57.4 0 171 64 37 72 WP_319106296.1 peptidase inhibitor family I36 protein [Streptomyces caniscabiei] diamond 108 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces caniscabiei
30027032 30027032 PRJEB65329_S_NODE_7351_length_270_cov_4.763485_g7189_i0 PRJEB65329 7351 270 4.763485 12.8614095 root 1 Root_unresolved Root_unresolved 62 2.24e-10   NR WP_337453918.1 562 g7189 i0 93.9 28.2333333333333 33 2 36.7 0 1 99 46 78 WP_337453918.1 MC/SLC25 family protein, partial [Escherichia coli] diamond 7623 62.4 0.993589743589744 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
30507879 30507879 PRJEB65329_S_NODE_10353_length_214_cov_2.535135_g10191_i0 PRJEB65329 10353 214 2.535135 5.4251889 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 40.8 0.0247   NR HKM54239.1 2691532 g10191 i0 46.3 0.574766355140187 41 17 57.5 2 54 176 37 72 HKM54239.1 hypothetical protein [Isosphaeraceae bacterium] diamond 123 40.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
30855383 30855383 PRJEB65329_S_NODE_9034_length_234_cov_2.702439_g8872_i0 PRJEB65329 9034 234 2.702439 6.32370726 Streptomyces sp. KM77-8 3074435 Bacteria Bacteria 44.3 0.00927   NR BFO18157.1 3074435 g8872 i0 40 0.897435897435897 70 39 89.7 1 211 2 421 487 BFO18157.1 hypothetical protein SHKM778_45450 [Streptomyces sp. KM77-8] diamond 210 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces haneummycinicus
31891751 31891751 PRJEB65329_S_NODE_14637_length_171_cov_6.105634_g14475_i0 PRJEB65329 14637 171 6.105634 10.44063414 root 1 Root_unresolved Root_unresolved 49.3 2.74e-5   NR MAO08131.1 232 g14475 i0 100 621.789473684211 22 0 38.6 0 3 68 136 157 MAO08131.1 hypothetical protein [Alteromonas sp.] diamond 106326 49.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas sp.
32745302 32745302 PRJEB65329_S_NODE_6540_length_294_cov_8.901887_g6378_i0 PRJEB65329 6540 294 8.901887 26.17154778 root 1 Root_unresolved Root_unresolved 101 8.5e-26   NR WP_336505983.1 573 g6378 i0 89.2 5.22448979591837 65 6 65.3 1 69 260 24 88 WP_336505983.1 translation machinery-associated protein 7, partial [Klebsiella pneumoniae] diamond 1536 101 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32846572 32846572 PRJEB65329_S_NODE_12060_length_193_cov_4.310976_g11898_i0 PRJEB65329 12060 193 4.310976 8.32018368 Paenibacillus woosongensis 307580 Bacteria Bacteria 40 0.0299   NR WP_306422036.1 307580 g11898 i0 44.2 0.808290155440414 52 26 77.7 2 26 175 1 51 WP_306422036.1 hypothetical protein [Paenibacillus woosongensis] diamond 156 40 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus woosongensis

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