contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA451191" and tax_kingdom = "Bacillati"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26696120 | 26696120 | PRJNA451191_P_NODE_50861_length_206_cov_0.896552_g50590_i0 | PRJNA451191 | 50861 | 206 | 0.896552 | 1.84689712 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 127 | 6.3e-33 | NR | MSW51487.1 | 2900548 | g50590 | i0 | 100 | 0.990291262135922 | 68 | 0 | 99 | 0 | 204 | 1 | 274 | 341 | MSW51487.1 MCE family protein [Actinomycetota bacterium] | diamond | 204 | 127 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 27012756 | 27012756 | PRJNA451191_P_NODE_49422_length_207_cov_0.890411_g49151_i0 | PRJNA451191 | 49422 | 207 | 0.890411 | 1.84315077 | Nocardioidaceae bacterium | 1871072 | Bacteria | Bacteria | 106 | 4.77e-26 | NR | MEO5709695.1 | 1871072 | g49151 | i0 | 76.5 | 0.985507246376812 | 68 | 16 | 98.6 | 0 | 205 | 2 | 167 | 234 | MEO5709695.1 TIGR01777 family oxidoreductase [Nocardioidaceae bacterium] | diamond | 204 | 106 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioidaceae bacterium | |||
| 27329090 | 27329090 | PRJNA451191_P_NODE_39123_length_228_cov_1.143713_g38852_i0 | PRJNA451191 | 39123 | 228 | 1.143713 | 2.60766564 | Fusibacter sp. | 2004507 | Bacteria | Bacteria | 43.5 | 0.0153 | NR | HSN66110.1 | 2004507 | g38852 | i0 | 44.8 | 0.789473684210526 | 29 | 16 | 38.2 | 0 | 122 | 36 | 162 | 190 | HSN66110.1 reverse transcriptase family protein [Fusibacter sp.] | diamond | 180 | 43.5 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Eubacteriales Family XII. Incertae Sedis | Fusibacter | Fusibacter sp. | ||
| 27928966 | 27928966 | PRJNA451191_P_NODE_51425_length_205_cov_1.222222_g51154_i0 | PRJNA451191 | 51425 | 205 | 1.222222 | 2.5055551 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 44.3 | 0.00666 | NR | MFN3962062.1 | 2682144 | g51154 | i0 | 43.5 | 0.673170731707317 | 46 | 26 | 67.3 | 0 | 142 | 5 | 706 | 751 | MFN3962062.1 LPD38 domain-containing protein [Fimbriimonadaceae bacterium] | diamond | 138 | 44.3 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 28529012 | 28529012 | PRJNA451191_P_NODE_50827_length_206_cov_0.896552_g50556_i0 | PRJNA451191 | 50827 | 206 | 0.896552 | 1.84689712 | Ornithinimicrobium avium | 2283195 | Bacteria | Bacteria | 53.5 | 4.34e-7 | NR | WP_114929965.1 | 2283195 | g50556 | i0 | 40.3 | 0.975728155339806 | 67 | 39 | 97.6 | 1 | 4 | 204 | 18 | 83 | WP_114929965.1 hypothetical protein [Ornithinimicrobium avium] | diamond | 201 | 53.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Ornithinimicrobiaceae | Ornithinimicrobium | Ornithinimicrobium avium | ||
| 28560522 | 28560522 | PRJNA451191_P_NODE_17007_length_351_cov_4.141379_g16736_i0 | PRJNA451191 | 17007 | 351 | 4.141379 | 14.53624029 | Microcystis sp. 53602_E8 | 2904984 | Bacteria | Bacteria | 87 | 3.82e-17 | NR | MCE2664493.1 | 2904984 | g16736 | i0 | 35.7 | 0.957264957264957 | 112 | 67 | 91.5 | 2 | 325 | 5 | 702 | 813 | MCE2664493.1 hypothetical protein [Microcystis sp. 53602_E8] | diamond | 336 | 87 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Chroococcales | Microcystaceae | Microcystis | Microcystis sp. 53602_E8 | |
| 28560527 | 28560527 | PRJNA451191_P_NODE_51127_length_205_cov_1.958333_g50856_i0 | PRJNA451191 | 51127 | 205 | 1.958333 | 4.01458265 | Solirubrobacteraceae bacterium | 2586742 | Bacteria | Bacteria | 42.4 | 0.0106 | NR | MEJ7781125.1 | 2586742 | g50856 | i0 | 44.1 | 0.497560975609756 | 34 | 19 | 49.8 | 0 | 127 | 26 | 36 | 69 | MEJ7781125.1 hypothetical protein [Solirubrobacteraceae bacterium] | diamond | 102 | 42.4 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacteraceae bacterium | |||
| 28718352 | 28718352 | PRJNA451191_P_NODE_51467_length_205_cov_0.902778_g51196_i0 | PRJNA451191 | 51467 | 205 | 0.902778 | 1.8506949 | Eubacterium brachy ATCC 33 | 35517 | Bacteria | Bacteria | 42.4 | 0.0318 | NR | ESE30890.1 | 1321814 | g51196 | i0 | 34.6 | 0.760975609756098 | 52 | 32 | 73.2 | 1 | 38 | 187 | 8 | 59 | ESE30890.1 putative ATP-dependent DNA helicase RecG [Eubacterium brachy ATCC 33089] | diamond | 156 | 42.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Anaerovoracaceae | [Eubacterium] brachy | |||
| 28812653 | 28812653 | PRJNA451191_P_NODE_27148_length_273_cov_1.174528_g26877_i0 | PRJNA451191 | 27148 | 273 | 1.174528 | 3.20646144 | Cohnella caldifontis | 3027471 | Bacteria | Bacteria | 45.4 | 0.00587 | NR | WP_276354092.1 | 3027471 | g26877 | i0 | 40.3 | 0.681318681318681 | 62 | 37 | 68.1 | 0 | 214 | 29 | 517 | 578 | WP_276354092.1 CPBP family glutamic-type intramembrane protease [Cohnella caldifontis] | diamond | 186 | 45.4 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Cohnella | Cohnella caldifontis | ||
| 28970901 | 28970901 | PRJNA451191_P_NODE_47648_length_209_cov_0.878378_g47377_i0 | PRJNA451191 | 47648 | 209 | 0.878378 | 1.83581002 | Neobacillus jeddahensis | 1461580 | Bacteria | Bacteria | 43.5 | 0.00456 | NR | WP_096911866.1 | 1461580 | g47377 | i0 | 38.3 | 0.674641148325359 | 47 | 28 | 67.5 | 1 | 171 | 31 | 67 | 112 | WP_096911866.1 DUF1360 domain-containing protein [Neobacillus jeddahensis] | diamond | 141 | 43.5 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Neobacillus | Neobacillus jeddahensis | ||
| 29823136 | 29823136 | PRJNA451191_P_NODE_50711_length_206_cov_0.896552_g50440_i0 | PRJNA451191 | 50711 | 206 | 0.896552 | 1.84689712 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 42 | 0.0361 | NR | WP_388519618.1 | 3364767 | g50440 | i0 | 41.1 | 0.815533980582524 | 56 | 28 | 74.3 | 2 | 181 | 29 | 117 | 172 | WP_388519618.1 bifunctional DNA primase/polymerase [Streptomyces sp. NPDC006879] | diamond | 168 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC006879 | ||
| 29855025 | 29855025 | PRJNA451191_P_NODE_31611_length_253_cov_1.354167_g31340_i0 | PRJNA451191 | 31611 | 253 | 1.354167 | 3.42604251 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42.4 | 0.0499 | NR | MEZ4595107.1 | 2026724 | g31340 | i0 | 37 | 0.640316205533597 | 54 | 34 | 64 | 0 | 194 | 33 | 196 | 249 | MEZ4595107.1 prolipoprotein diacylglyceryl transferase [Chloroflexota bacterium] | diamond | 162 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29949764 | 29949764 | PRJNA451191_P_NODE_31671_length_253_cov_1.015625_g31400_i0 | PRJNA451191 | 31671 | 253 | 1.015625 | 2.56953125 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 43.1 | 0.0314 | NR | HKV86391.1 | 2052315 | g31400 | i0 | 39.7 | 0.74703557312253 | 63 | 37 | 74.7 | 1 | 35 | 223 | 329 | 390 | HKV86391.1 MMPL family transporter [Candidatus Dormiibacterota bacterium] | diamond | 189 | 43.1 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 30265956 | 30265956 | PRJNA451191_P_NODE_48932_length_208_cov_0.884354_g48661_i0 | PRJNA451191 | 48932 | 208 | 0.884354 | 1.83945632 | Streptomyces sp. NBC_ | 1931 | Bacteria | Bacteria | 42 | 0.0111 | NR | WP_328895565.1 | 2903639 | g48661 | i0 | 38.3 | 0.677884615384615 | 47 | 29 | 67.8 | 0 | 141 | 1 | 14 | 60 | WP_328895565.1 hypothetical protein [Streptomyces sp. NBC_00236] | diamond | 141 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NBC_00236 | ||
| 30424028 | 30424028 | PRJNA451191_P_NODE_48933_length_208_cov_0.884354_g48662_i0 | PRJNA451191 | 48933 | 208 | 0.884354 | 1.83945632 | Oceanobacillus massiliensis | 1465765 | Bacteria | Bacteria | 124 | 7.92e-33 | NR | WP_337019773.1 | 1465765 | g48662 | i0 | 89.7 | 1.96153846153846 | 68 | 7 | 98.1 | 0 | 206 | 3 | 89 | 156 | WP_337019773.1 stage IV sporulation protein A, partial [Oceanobacillus massiliensis] | diamond | 408 | 124 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Oceanobacillus | Oceanobacillus massiliensis | ||
| 30518413 | 30518413 | PRJNA451191_P_NODE_42233_length_219_cov_1.607595_g41962_i0 | PRJNA451191 | 42233 | 219 | 1.607595 | 3.52063305 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 42 | 0.0417 | NR | MBQ3415788.1 | 2044939 | g41962 | i0 | 37.7 | 0.726027397260274 | 53 | 31 | 72.6 | 1 | 18 | 176 | 158 | 208 | MBQ3415788.1 class B sortase [Clostridia bacterium] | diamond | 159 | 42 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 30613077 | 30613077 | PRJNA451191_P_NODE_48413_length_208_cov_0.884354_g48142_i0 | PRJNA451191 | 48413 | 208 | 0.884354 | 1.83945632 | Ectobacillus panaciterrae | 363872 | Bacteria | Bacteria | 41.6 | 0.0232 | NR | WP_028402115.1 | 363872 | g48142 | i0 | 41 | 0.879807692307692 | 61 | 29 | 86.5 | 3 | 17 | 196 | 2 | 56 | WP_028402115.1 fluoride efflux transporter CrcB [Ectobacillus panaciterrae] | diamond | 183 | 41.6 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Ectobacillus | Ectobacillus panaciterrae | ||
| 30739546 | 30739546 | PRJNA451191_P_NODE_52994_length_204_cov_0.909091_g52723_i0 | PRJNA451191 | 52994 | 204 | 0.909091 | 1.85454564 | Baekduia sp. | 2600305 | Bacteria | Bacteria | 42.7 | 0.0204 | NR | WP_324904960.1 | 2600305 | g52723 | i0 | 37.3 | 0.75 | 51 | 32 | 75 | 0 | 2 | 154 | 77 | 127 | WP_324904960.1 precorrin-2 C(20)-methyltransferase [Baekduia sp.] | diamond | 153 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Baekduiaceae | Baekduia | Baekduia sp. | ||
| 30992459 | 30992459 | PRJNA451191_P_NODE_52054_length_205_cov_0.902778_g51783_i0 | PRJNA451191 | 52054 | 205 | 0.902778 | 1.8506949 | Cutibacterium namnetense | 1574624 | Bacteria | Bacteria | 110 | 1.3e-26 | NR | WP_108773122.1 | 1574624 | g51783 | i0 | 98.5 | 0.965853658536585 | 66 | 1 | 96.6 | 0 | 203 | 6 | 405 | 470 | WP_108773122.1 PP2C family protein-serine/threonine phosphatase [Cutibacterium namnetense] | diamond | 198 | 110 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium namnetense | ||
| 31434841 | 31434841 | PRJNA451191_P_NODE_33316_length_247_cov_1.048387_g33045_i0 | PRJNA451191 | 33316 | 247 | 1.048387 | 2.58951589 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 45.8 | 0.00315 | NR | WP_366426767.1 | 3155164 | g33045 | i0 | 38.3 | 0.728744939271255 | 60 | 36 | 71.7 | 1 | 7 | 183 | 248 | 307 | WP_366426767.1 helix-turn-helix domain-containing protein [Streptomyces sp. NPDC051173] | diamond | 180 | 45.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC051173 | ||
| 31656146 | 31656146 | PRJNA451191_P_NODE_37097_length_234_cov_1.306358_g36826_i0 | PRJNA451191 | 37097 | 234 | 1.306358 | 3.05687772 | Micromonospora pisi | 589240 | Bacteria | Bacteria | 42.7 | 0.0281 | NR | WP_281278651.1 | 589240 | g36826 | i0 | 40.5 | 0.474358974358974 | 37 | 22 | 47.4 | 0 | 68 | 178 | 64 | 100 | WP_281278651.1 succinate dehydrogenase cytochrome b subunit [Micromonospora pisi] | diamond | 111 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Micromonospora | Micromonospora pisi | ||
| 31830539 | 31830539 | PRJNA451191_P_NODE_45937_length_211_cov_0.866667_g45666_i0 | PRJNA451191 | 45937 | 211 | 0.866667 | 1.82866737 | FCB group | 1783270 | Bacteria | Bacteria | 41.2 | 0.0225 | NR | WP_156103664.1 | 762212 | g45666 | i0 | 38.1 | 1.60663507109005 | 63 | 35 | 85.3 | 3 | 30 | 209 | 30 | 91 | WP_156103664.1 hypothetical protein [Bifidobacterium biavatii] | diamond | 339 | 41.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Bifidobacteriales | Bifidobacteriaceae | Bifidobacterium | Bifidobacterium biavatii | ||
| 31877593 | 31877593 | PRJNA451191_P_NODE_45557_length_211_cov_0.866667_g45286_i0 | PRJNA451191 | 45557 | 211 | 0.866667 | 1.82866737 | Halanaerobiales bacterium | 2094029 | Bacteria | Bacteria | 60.1 | 1.91e-8 | NR | MBS3812162.1 | 2094029 | g45286 | i0 | 67.4 | 0.611374407582938 | 43 | 14 | 61.1 | 0 | 156 | 28 | 362 | 404 | MBS3812162.1 hypothetical protein [Halanaerobiales bacterium] | diamond | 129 | 60.1 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Halanaerobiales | Halanaerobiales bacterium | ||||
| 31940843 | 31940843 | PRJNA451191_P_NODE_33817_length_245_cov_1.195652_g33546_i0 | PRJNA451191 | 33817 | 245 | 1.195652 | 2.9293474 | Cyanobacteria bacterium J06553_1 | 3023125 | Bacteria | Bacteria | 43.5 | 0.00333 | NR | MEL7522188.1 | 3023125 | g33546 | i0 | 38.2 | 0.673469387755102 | 55 | 34 | 67.3 | 0 | 22 | 186 | 5 | 59 | MEL7522188.1 hypothetical protein [Cyanobacteria bacterium J06553_1] | diamond | 165 | 43.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanobacteria bacterium J06553_1 | |||||
| 32321060 | 32321060 | PRJNA451191_P_NODE_53619_length_203_cov_0.915493_g53348_i0 | PRJNA451191 | 53619 | 203 | 0.915493 | 1.85845079 | Spirillospora sp. NPDC | 2052479 | Bacteria | Bacteria | 43.1 | 0.0161 | NR | WP_366618139.1 | 3154599 | g53348 | i0 | 32.4 | 1.0935960591133 | 74 | 35 | 87.2 | 1 | 17 | 193 | 225 | 298 | WP_366618139.1 FAD-dependent oxidoreductase [Spirillospora sp. NPDC029432] | diamond | 222 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Thermomonosporaceae | Spirillospora | Spirillospora sp. NPDC029432 | ||
| 32415782 | 32415782 | PRJNA451191_P_NODE_49619_length_207_cov_0.890411_g49348_i0 | PRJNA451191 | 49619 | 207 | 0.890411 | 1.84315077 | Lawsonella clevelandensis | 1528099 | Bacteria | Bacteria | 145 | 3.6e-39 | NR | PZP89177.1 | 1528099 | g49348 | i0 | 100 | 1 | 69 | 0 | 100 | 0 | 1 | 207 | 405 | 473 | PZP89177.1 MAG: FAD-binding protein [Lawsonella clevelandensis] | diamond | 207 | 145 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Lawsonellaceae | Lawsonella | Lawsonella clevelandensis | ||
| 32636543 | 32636543 | PRJNA451191_P_NODE_54860_length_202_cov_0.921986_g54589_i0 | PRJNA451191 | 54860 | 202 | 0.921986 | 1.86241172 | Halanaerobiales bacterium | 2094029 | Bacteria | Bacteria | 48.5 | 2.03e-4 | NR | MBS3812162.1 | 2094029 | g54589 | i0 | 40.4 | 0.772277227722772 | 52 | 31 | 77.2 | 0 | 190 | 35 | 718 | 769 | MBS3812162.1 hypothetical protein [Halanaerobiales bacterium] | diamond | 156 | 48.5 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Halanaerobiales | Halanaerobiales bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;