contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA380416" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6779757 | 6779757 | PRJNA380416_P_NODE_3426_length_325_cov_2.018116_g3279_i0 | PRJNA380416 | 3426 | 325 | 2.018116 | 6.558877 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 196 | 3.8999999999999995e-62 | NR | MBX9724270.1 | 2364082 | g3279 | i0 | 93 | 0.923076923076923 | 100 | 7 | 92.3 | 0 | 314 | 15 | 71 | 170 | MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] | diamond | 300 | 196 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 15704726 | 15704726 | PRJNA380416_P_NODE_13753_length_161_cov_0.910714_g13606_i0 | PRJNA380416 | 13753 | 161 | 0.910714 | 1.46624954 | Leifsonia sp. TF | 1870902 | Bacteria | Bacteria | 100 | 5.519999999999999e-23 | NR | WP_208039097.1 | 2815212 | g13606 | i0 | 98.1 | 0.987577639751553 | 53 | 1 | 98.8 | 0 | 2 | 160 | 485 | 537 | WP_208039097.1 magnesium-translocating P-type ATPase [Leifsonia sp. TF02-11] | diamond | 159 | 100 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Leifsonia | Leifsonia sp. TF02-11 | ||
| 27296277 | 27296277 | PRJNA380416_P_NODE_13483_length_162_cov_0.902655_g13336_i0 | PRJNA380416 | 13483 | 162 | 0.902655 | 1.4623011 | Mycobacterium sp. | 1785 | Bacteria | Bacteria | 113 | 3.5199999999999995e-31 | NR | MBI3217013.1 | 1785 | g13336 | i0 | 96.2 | 0.981481481481482 | 53 | 2 | 98.1 | 0 | 160 | 2 | 7 | 59 | MBI3217013.1 hypothetical protein [Mycobacterium sp.] | diamond | 159 | 113 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium sp. | ||
| 27738742 | 27738742 | PRJNA380416_P_NODE_13104_length_163_cov_0.894737_g12957_i0 | PRJNA380416 | 13104 | 163 | 0.894737 | 1.45842131 | Kitasatospora sp. NPDC | 1871188 | Bacteria | Bacteria | 66.2 | 6.51e-11 | NR | WP_401088305.1 | 3364085 | g12957 | i0 | 63.4 | 14.0981595092025 | 41 | 15 | 75.5 | 0 | 40 | 162 | 760 | 800 | WP_401088305.1 non-ribosomal peptide synthetase [Kitasatospora sp. NPDC091335] | diamond | 2298 | 66.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Kitasatospora | Kitasatospora sp. NPDC091335 | ||
| 27959385 | 27959385 | PRJNA380416_P_NODE_4705_length_270_cov_1.674208_g4558_i0 | PRJNA380416 | 4705 | 270 | 1.674208 | 4.5203616 | Cyanobacteriota bacterium | 2847862 | Bacteria | Bacteria | 162 | 1.24e-49 | NR | MBX9692690.1 | 2847862 | g4558 | i0 | 86.9 | 0.933333333333333 | 84 | 11 | 93.3 | 0 | 269 | 18 | 34 | 117 | MBX9692690.1 (2Fe-2S)-binding protein [Cyanobacteriota bacterium] | diamond | 252 | 162 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanobacteriota bacterium | |||||
| 28180220 | 28180220 | PRJNA380416_P_NODE_11946_length_165_cov_3.250000_g11799_i0 | PRJNA380416 | 11946 | 165 | 3.25 | 5.3625 | Gaiellaceae bacterium | 2838783 | Bacteria | Bacteria | 42 | 0.0228 | NR | HST17223.1 | 2838783 | g11799 | i0 | 59 | 0.709090909090909 | 39 | 14 | 67.3 | 2 | 47 | 157 | 42 | 80 | HST17223.1 hypothetical protein [Gaiellaceae bacterium] | diamond | 117 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Gaiellales | Gaiellaceae | Gaiellaceae bacterium | |||
| 28275044 | 28275044 | PRJNA380416_P_NODE_11406_length_167_cov_0.864407_g11259_i0 | PRJNA380416 | 11406 | 167 | 0.864407 | 1.44355969 | Loigolactobacillus bifermentans | 1607 | Bacteria | Bacteria | 41.2 | 0.0432 | NR | WP_057903302.1 | 1607 | g11259 | i0 | 41.3 | 0.826347305389222 | 46 | 27 | 82.6 | 0 | 151 | 14 | 174 | 219 | WP_057903302.1 rhomboid family intramembrane serine protease [Loigolactobacillus bifermentans] | diamond | 138 | 41.2 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Loigolactobacillus | Loigolactobacillus bifermentans | ||
| 28401469 | 28401469 | PRJNA380416_P_NODE_9666_length_183_cov_1.783582_g9519_i0 | PRJNA380416 | 9666 | 183 | 1.783582 | 3.26395506 | Nocardioides pantholopis | 2483798 | Bacteria | Bacteria | 62.4 | 1.77e-9 | NR | WP_127479640.1 | 2483798 | g9519 | i0 | 72.7 | 0.540983606557377 | 33 | 9 | 54.1 | 0 | 182 | 84 | 317 | 349 | WP_127479640.1 glycoside hydrolase family 99-like domain-containing protein [Nocardioides pantholopis] | diamond | 99 | 62.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides pantholopis | ||
| 29222570 | 29222570 | PRJNA380416_P_NODE_12549_length_164_cov_0.886957_g12402_i0 | PRJNA380416 | 12549 | 164 | 0.886957 | 1.45460948 | Erysipelotrichaceae bacterium | 2049044 | Bacteria | Bacteria | 59.3 | 1.8e-8 | NR | MEG2909868.1 | 2049044 | g12402 | i0 | 61.2 | 1.79268292682927 | 49 | 18 | 87.8 | 1 | 162 | 19 | 448 | 496 | MEG2909868.1 hypothetical protein [Erysipelotrichaceae bacterium] | diamond | 294 | 59.3 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Erysipelotrichaceae | Erysipelotrichaceae bacterium | |||
| 29285399 | 29285399 | PRJNA380416_P_NODE_11249_length_167_cov_0.864407_g11102_i0 | PRJNA380416 | 11249 | 167 | 0.864407 | 1.44355969 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 83.2 | 7.42e-17 | NR | MEZ4864036.1 | 2614250 | g11102 | i0 | 81.1 | 4.76047904191617 | 53 | 10 | 95.2 | 0 | 165 | 7 | 3079 | 3131 | MEZ4864036.1 SdrD B-like domain-containing protein [Caldilineaceae bacterium] | diamond | 795 | 83.2 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 29411732 | 29411732 | PRJNA380416_P_NODE_6649_length_223_cov_0.741379_g6502_i0 | PRJNA380416 | 6649 | 223 | 0.741379 | 1.65327517 | Rhodococcus erythropolis | 1833 | Bacteria | Bacteria | 43.1 | 0.0203 | NR | KAB2584130.1 | 1833 | g6502 | i0 | 42.6 | 0.726457399103139 | 54 | 26 | 67.3 | 2 | 63 | 212 | 373 | 425 | KAB2584130.1 DUF2029 domain-containing protein [Rhodococcus erythropolis] | diamond | 162 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcus | Rhodococcus erythropolis | ||
| 30391446 | 30391446 | PRJNA380416_P_NODE_12313_length_165_cov_0.879310_g12166_i0 | PRJNA380416 | 12313 | 165 | 0.87931 | 1.4508615 | Pseudoclavibacter sp. | 1915061 | Bacteria | Bacteria | 57.8 | 6.26e-8 | NR | HHW50484.1 | 1915061 | g12166 | i0 | 91.4 | 0.636363636363636 | 35 | 3 | 63.6 | 0 | 59 | 163 | 1 | 35 | HHW50484.1 hypothetical protein [Pseudoclavibacter sp.] | diamond | 105 | 57.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Pseudoclavibacter | Pseudoclavibacter sp. | ||
| 30422967 | 30422967 | PRJNA380416_P_NODE_12133_length_165_cov_0.879310_g11986_i0 | PRJNA380416 | 12133 | 165 | 0.87931 | 1.4508615 | Alicyclobacillus acidocaldarius | 405212 | Bacteria | Bacteria | 97.1 | 7.61e-22 | NR | WP_014464833.1 | 405212 | g11986 | i0 | 87 | 0.981818181818182 | 54 | 7 | 98.2 | 0 | 165 | 4 | 308 | 361 | WP_014464833.1 ISLre2-like element ISAlac1 family transposase [Alicyclobacillus acidocaldarius] | diamond | 162 | 97.1 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Alicyclobacillaceae | Alicyclobacillus | Alicyclobacillus acidocaldarius | ||
| 30422968 | 30422968 | PRJNA380416_P_NODE_3173_length_338_cov_0.878893_g3026_i0 | PRJNA380416 | 3173 | 338 | 0.878893 | 2.97065834 | Pantanalinema sp. | 3088176 | Bacteria | Bacteria | 57.4 | 8.2e-7 | NR | HEY9897812.1 | 3088176 | g3026 | i0 | 33.3 | 0.958579881656805 | 108 | 68 | 92.3 | 2 | 313 | 2 | 548 | 655 | HEY9897812.1 5-histidylcysteine sulfoxide synthase [Pantanalinema sp.] | diamond | 324 | 57.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Leptolyngbyales | Leptolyngbyaceae | Pantanalinema | Pantanalinema sp. | |
| 30675192 | 30675192 | PRJNA380416_P_NODE_12293_length_165_cov_0.879310_g12146_i0 | PRJNA380416 | 12293 | 165 | 0.87931 | 1.4508615 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 94 | 1.14e-20 | NR | NPA30405.1 | 2026724 | g12146 | i0 | 83.3 | 41.2363636363636 | 54 | 9 | 98.2 | 0 | 2 | 163 | 239 | 292 | NPA30405.1 ATP-dependent zinc metalloprotease FtsH [Chloroflexota bacterium] | diamond | 6804 | 94 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30896671 | 30896671 | PRJNA380416_P_NODE_5034_length_259_cov_2.133333_g4887_i0 | PRJNA380416 | 5034 | 259 | 2.133333 | 5.52533247 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 42 | 0.0444 | NR | MBX9573951.1 | 2364082 | g4887 | i0 | 28.3 | 0.613899613899614 | 53 | 36 | 61.4 | 1 | 55 | 213 | 55 | 105 | MBX9573951.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 159 | 42 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31117398 | 31117398 | PRJNA380416_P_NODE_14275_length_154_cov_2.238095_g14128_i0 | PRJNA380416 | 14275 | 154 | 2.238095 | 3.4466663 | Nocardioides sp. | 35761 | Bacteria | Bacteria | 55.1 | 4.68e-7 | NR | WP_324499474.1 | 35761 | g14128 | i0 | 58.7 | 0.896103896103896 | 46 | 19 | 89.6 | 0 | 3 | 140 | 103 | 148 | WP_324499474.1 hypothetical protein [Nocardioides sp.] | diamond | 138 | 55.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. | ||
| 31433772 | 31433772 | PRJNA380416_P_NODE_5976_length_236_cov_0.925134_g5829_i0 | PRJNA380416 | 5976 | 236 | 0.925134 | 2.18331624 | Nocardia asteroides | 1824 | Bacteria | Bacteria | 40.8 | 0.0374 | NR | WP_378807785.1 | 1824 | g5829 | i0 | 51.2 | 0.546610169491525 | 43 | 21 | 54.7 | 0 | 145 | 17 | 36 | 78 | WP_378807785.1 hypothetical protein, partial [Nocardia asteroides] | diamond | 129 | 40.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Nocardia | Nocardia asteroides | ||
| 32256730 | 32256730 | PRJNA380416_P_NODE_13858_length_161_cov_0.910714_g13711_i0 | PRJNA380416 | 13858 | 161 | 0.910714 | 1.46624954 | Candidatus Equicaccousia limihippi | 3083095 | Bacteria | Bacteria | 77 | 9.94e-15 | NR | MBQ0111261.1 | 3083095 | g13711 | i0 | 78.3 | 0.857142857142857 | 46 | 10 | 85.7 | 0 | 10 | 147 | 81 | 126 | MBQ0111261.1 cation-translocating P-type ATPase [Candidatus Equicaccousia limihippi] | diamond | 138 | 77 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Acutalibacteraceae | Candidatus Equicaccousia | Candidatus Equicaccousia limihippi | ||
| 32652377 | 32652377 | PRJNA380416_P_NODE_6700_length_222_cov_0.826590_g6553_i0 | PRJNA380416 | 6700 | 222 | 0.82659 | 1.8350298 | Bacillaceae | 186817 | Bacteria | Bacteria | 52.4 | 1.1e-5 | NR | WP_217038746.1 | 1895002 | g6553 | i0 | 42.5 | 1.97297297297297 | 73 | 38 | 93.2 | 1 | 2 | 208 | 279 | 351 | WP_217038746.1 APC family permease [Bacillus sp. FJAT-29790] | diamond | 438 | 52.4 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus sp. FJAT-29790 | ||
| 32698572 | 32698572 | PRJNA380416_P_NODE_260_length_1214_cov_2.544206_g195_i0 | PRJNA380416 | 260 | 1214 | 2.544206 | 30.88666084 | Cyanobacteriota bacterium | 2847862 | Bacteria | Bacteria | 459 | 9.74e-159 | NR | MBX9694561.1 | 2847862 | g195 | i0 | 73.1 | 2.40939044481054 | 308 | 78 | 74.9 | 2 | 46 | 954 | 15 | 322 | MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] | diamond | 2925 | 459 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanobacteriota bacterium | |||||
| 32856052 | 32856052 | PRJNA380416_P_NODE_3000_length_348_cov_0.775920_g2853_i0 | PRJNA380416 | 3000 | 348 | 0.77592 | 2.7002016 | Actinomycetes bacterium | 1883427 | Bacteria | Bacteria | 48.1 | 0.00148 | NR | MDO5286548.1 | 1883427 | g2853 | i0 | 32.4 | 0.586206896551724 | 68 | 45 | 57.8 | 1 | 229 | 29 | 154 | 221 | MDO5286548.1 ABC transporter permease [Actinomycetes bacterium] | diamond | 204 | 48.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetes 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);;