RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA358209" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Bacteria · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA358209 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
10602655 10602655 PRJNA358209_P_NODE_889_length_163_cov_1.456140_g887_i0 PRJNA358209 889 163 1.45614 2.3735082 Phyllobacterium myrsinacearum 28101 Bacteria Bacteria 105 9.9e-26   NR WP_105736151.1 28101 g887 i0 100 2.98159509202454 54 0 99.4 0 163 2 78 131 WP_105736151.1 carboxylating nicotinate-nucleotide diphosphorylase [Phyllobacterium myrsinacearum] diamond 486 105 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Phyllobacterium Phyllobacterium myrsinacearum
20800397 20800397 PRJNA358209_P_NODE_677_length_165_cov_0.879310_g675_i0 PRJNA358209 677 165 0.87931 1.4508615 Pseudomonadota bacterium 1977087 Bacteria Bacteria 107 2.48e-25   NR MEW6596987.1 1977087 g675 i0 100 0.945454545454545 52 0 94.5 0 3 158 137 188 MEW6596987.1 ATP-binding cassette domain-containing protein [Pseudomonadota bacterium] diamond 156 107 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
26870833 26870833 PRJNA358209_P_NODE_1061_length_162_cov_0.902655_g1059_i0 PRJNA358209 1061 162 0.902655 1.4623011 Halomonadaceae 28256 Bacteria Bacteria 97.4 6.67e-22   NR WP_077529624.1 86177 g1059 i0 88.2 3.77777777777778 51 6 94.4 0 6 158 724 774 WP_077529624.1 DUF1631 family protein [Vreelandella utahensis] diamond 612 98.2 0.991853360488798 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Halomonadaceae Vreelandella Vreelandella halophila
26916668 26916668 PRJNA358209_P_NODE_1242_length_161_cov_0.910714_g1240_i0 PRJNA358209 1242 161 0.910714 1.46624954 Marinobacter sp. 50741 Bacteria Bacteria 81.6 3.99e-18   NR HEV8078339.1 50741 g1240 i0 90.9 1.6583850931677 44 4 82 0 1 132 8 51 HEV8078339.1 MFS transporter [Marinobacter sp.] diamond 267 81.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Marinobacteraceae Marinobacter Marinobacter sp.
26948188 26948188 PRJNA358209_P_NODE_782_length_164_cov_0.886957_g780_i0 PRJNA358209 782 164 0.886957 1.45460948 Pseudobdellovibrionaceae bacterium 2026715 Bacteria Bacteria 71.6 8.18e-13   NR MCM2280861.1 2026715 g780 i0 68.8 0.878048780487805 48 15 87.8 0 147 4 8 55 MCM2280861.1 electron transfer flavoprotein-ubiquinone oxidoreductase [Pseudobdellovibrionaceae bacterium] diamond 144 71.6 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae   Pseudobdellovibrionaceae bacterium
27565760 27565760 PRJNA358209_P_NODE_984_length_163_cov_0.894737_g982_i0 PRJNA358209 984 163 0.894737 1.45842131 root 1 Root_unresolved Root_unresolved 65.5 3.76e-11   NR MEM7802456.1 2026724 g982 i0 69 1.52760736196319 42 11 77.3 1 36 161 32 71 MEM7802456.1 VOC family protein [Chloroflexota bacterium] diamond 249 65.5 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28102536 28102536 PRJNA358209_P_NODE_665_length_165_cov_0.956897_g663_i0 PRJNA358209 665 165 0.956897 1.57888005 Gammaproteobacteria 1236 Bacteria Bacteria 39.7 0.049   NR MBN0217501.1 287 g663 i0 41.7 1.74545454545455 48 25 85.5 2 2 142 10 55 MBN0217501.1 MFS transporter [Pseudomonas aeruginosa] diamond 288 39.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
28464585 28464585 PRJNA358209_P_NODE_546_length_166_cov_0.871795_g544_i0 PRJNA358209 546 166 0.871795 1.4471797 Actinomycetota bacterium 2900548 Bacteria Bacteria 94.4 8.770000000000001e-21   NR MDP9376881.1 2900548 g544 i0 83.3 4.95180722891566 54 9 97.6 0 165 4 571 624 MDP9376881.1 transketolase [Actinomycetota bacterium] diamond 822 94.4 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28559351 28559351 PRJNA358209_P_NODE_187_length_233_cov_0.869565_g185_i0 PRJNA358209 187 233 0.869565 2.02608645 Rubripirellula sp. 1973111 Bacteria Bacteria 42.4 0.0442   NR MDE0864581.1 1973111 g185 i0 43.1 0.656652360515021 51 29 65.7 0 71 223 332 382 MDE0864581.1 sulfatase [Rubripirellula sp.] diamond 153 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rubripirellula Rubripirellula sp.
28811445 28811445 PRJNA358209_P_NODE_1028_length_162_cov_0.902655_g1026_i0 PRJNA358209 1028 162 0.902655 1.4623011 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 75.1 4.71e-14   NR MDO8675294.1 2035772 g1026 i0 82.6 0.851851851851852 46 8 85.2 0 5 142 372 417 MDO8675294.1 TonB family protein [Candidatus Omnitrophota bacterium] diamond 138 75.1 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
29159268 29159268 PRJNA358209_P_NODE_1029_length_162_cov_0.902655_g1027_i0 PRJNA358209 1029 162 0.902655 1.4623011 Nostocoides vanveenii 330835 Bacteria Bacteria 64.7 1.74e-10   NR WP_344060306.1 330835 g1027 i0 80.5 0.759259259259259 41 8 75.9 0 124 2 274 314 WP_344060306.1 hypothetical protein [Nostocoides vanveenii] diamond 123 64.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Intrasporangiaceae Nostocoides Nostocoides vanveenii
29285226 29285226 PRJNA358209_P_NODE_1109_length_162_cov_0.902655_g1107_i0 PRJNA358209 1109 162 0.902655 1.4623011 Salicola sp. Rm-C-2C1-2 3141321 Bacteria Bacteria 72.8 3.19e-13   NR WP_349750058.1 3141321 g1107 i0 81 0.777777777777778 42 8 77.8 0 156 31 235 276 WP_349750058.1 bifunctional 23S rRNA (guanine(2069)-N(7))-methyltransferase RlmK/23S rRNA (guanine(2445)-N(2))-methyltransferase RlmL [Salicola sp. Rm-C-2C1-2] diamond 126 72.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Halomonadaceae Salicola Salicola sp. Rm-C-2C1-2
29460050 29460050 PRJNA358209_P_NODE_490_length_167_cov_0.864407_g488_i0 PRJNA358209 490 167 0.864407 1.44355969 Nevskia 64001 Bacteria Bacteria 112 2.79e-27   NR WP_051748936.1 418856 g488 i0 90.9 1.97604790419162 55 5 98.8 0 165 1 570 624 WP_051748936.1 S46 family peptidase [Nevskia soli] diamond 330 112 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Nevskiales Nevskiaceae Nevskia Nevskia soli
30264744 30264744 PRJNA358209_P_NODE_672_length_165_cov_0.879310_g670_i0 PRJNA358209 672 165 0.87931 1.4508615 Dermatophilaceae bacterium 2728912 Bacteria Bacteria 43.1 0.00938   NR HOF64828.1 2728912 g670 i0 46.5 0.781818181818182 43 20 78.2 1 16 144 134 173 HOF64828.1 alpha/beta hydrolase-fold protein [Dermatophilaceae bacterium] diamond 129 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermatophilaceae   Dermatophilaceae bacterium
30706692 30706692 PRJNA358209_P_NODE_1094_length_162_cov_0.902655_g1092_i0 PRJNA358209 1094 162 0.902655 1.4623011 Caulobacter sp. CCUG 6 78 Bacteria Bacteria 108 1.09e-25   NR WP_242918357.1 2100090 g1092 i0 98.1 0.981481481481482 53 1 98.1 0 160 2 1623 1675 WP_242918357.1 filamentous haemagglutinin family protein [Caulobacter sp. CCUG 60055] diamond 159 108 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae Caulobacter Caulobacter sp. CCUG 60055
31022777 31022777 PRJNA358209_P_NODE_955_length_163_cov_0.894737_g953_i0 PRJNA358209 955 163 0.894737 1.45842131 Actinomyces bouchesdurhonensis 1852361 Bacteria Bacteria 113 2.1e-29   NR WP_073982439.1 1852361 g953 i0 98.1 0.993865030674847 54 1 99.4 0 1 162 19 72 WP_073982439.1 WecB/TagA/CpsF family glycosyltransferase [Actinomyces bouchesdurhonensis] diamond 162 113 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Actinomyces Actinomyces bouchesdurhonensis
31054608 31054608 PRJNA358209_P_NODE_975_length_163_cov_0.894737_g973_i0 PRJNA358209 975 163 0.894737 1.45842131 Rhodovibrio salinarum 1087 Bacteria Bacteria 87 3.12e-18   NR MBK1697528.1 1087 g973 i0 79.2 1.76687116564417 48 10 88.3 0 145 2 316 363 MBK1697528.1 aspartate--tRNA ligase [Rhodovibrio salinarum] diamond 288 87 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Rhodovibrionaceae Rhodovibrio Rhodovibrio salinarum
31465580 31465580 PRJNA358209_P_NODE_676_length_165_cov_0.879310_g674_i0 PRJNA358209 676 165 0.87931 1.4508615 Rickettsiales bacterium 2026788 Bacteria Bacteria 64.7 2.28e-10   NR MBK67232.1 2026788 g674 i0 59.3 0.981818181818182 54 22 98.2 0 163 2 394 447 MBK67232.1 hypothetical protein [Rickettsiales bacterium] diamond 162 64.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales     Rickettsiales bacterium
32431659 32431659 PRJNA358209_P_NODE_679_length_165_cov_0.879310_g677_i0 PRJNA358209 679 165 0.87931 1.4508615 Pseudomonas 286 Bacteria Bacteria 47.8 2.16e-4   NR MEW6597180.1 1977087 g677 i0 100 0.727272727272727 20 0 36.4 0 164 105 444 463 MEW6597180.1 glutamine synthetase family protein [Pseudomonadota bacterium] diamond 120 47.8 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
32541239 32541239 PRJNA358209_P_NODE_779_length_164_cov_0.886957_g777_i0 PRJNA358209 779 164 0.886957 1.45460948 Thiohalorhabdaceae bacterium 3107638 Bacteria Bacteria 68.9 5.36e-12   NR MFB6259944.1 3107638 g777 i0 93.9 0.603658536585366 33 2 60.4 0 162 64 289 321 MFB6259944.1 ABC transporter ATP-binding protein [Thiohalorhabdaceae bacterium] diamond 99 68.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Thiohalorhabdales Thiohalorhabdaceae   Thiohalorhabdaceae 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);;