contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA815356" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 819157 | 819157 | PRJNA815356_P_NODE_9301_length_250_cov_0.881356_g9138_i0 | PRJNA815356 | 9301 | 250 | 0.881356 | 2.20339 | Actinomycetes | 1760 | Bacteria | Bacteria | 120 | 2.89e-30 | NR | WP_375432178.1 | 335381 | g9138 | i0 | 87.9 | 1.584 | 66 | 8 | 79.2 | 0 | 198 | 1 | 33 | 98 | WP_375432178.1 ABC transporter substrate-binding protein [uncultured Friedmanniella sp.] | diamond | 396 | 120 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Friedmanniella | uncultured Friedmanniella sp. | ||
| 12298379 | 12298379 | PRJNA815356_P_NODE_9930_length_246_cov_0.901734_g9767_i0 | PRJNA815356 | 9930 | 246 | 0.901734 | 2.21826564 | Rhodoglobus sp. | 1950123 | Bacteria | Bacteria | 160 | 5.2999999999999994e-46 | NR | HWR86478.1 | 1950123 | g9767 | i0 | 92.5 | 0.975609756097561 | 80 | 6 | 97.6 | 0 | 3 | 242 | 192 | 271 | HWR86478.1 aminotransferase class V-fold PLP-dependent enzyme [Rhodoglobus sp.] | diamond | 240 | 160 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Rhodoglobus | Rhodoglobus sp. | ||
| 17397427 | 17397427 | PRJNA815356_P_NODE_10374_length_244_cov_0.912281_g10211_i0 | PRJNA815356 | 10374 | 244 | 0.912281 | 2.22596564 | Knoellia sp. Soil729 | 1736394 | Bacteria | Bacteria | 150 | 1.45e-41 | NR | WP_056138954.1 | 1736394 | g10211 | i0 | 95.1 | 0.995901639344262 | 81 | 4 | 99.6 | 0 | 244 | 2 | 83 | 163 | WP_056138954.1 THUMP-like domain-containing protein [Knoellia sp. Soil729] | diamond | 243 | 150 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Intrasporangiaceae | Knoellia | Knoellia sp. Soil729 | ||
| 21221128 | 21221128 | PRJNA815356_P_NODE_10137_length_245_cov_0.906977_g9974_i0 | PRJNA815356 | 10137 | 245 | 0.906977 | 2.22209365 | Mycobacterium sp. | 1785 | Bacteria | Bacteria | 163 | 8.72e-48 | NR | WP_292981776.1 | 1785 | g9974 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 2 | 244 | 86 | 166 | WP_292981776.1 SCO6745 family protein [Mycobacterium sp.] | diamond | 243 | 163 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium sp. | ||
| 23771601 | 23771601 | PRJNA815356_P_NODE_9359_length_250_cov_0.881356_g9196_i0 | PRJNA815356 | 9359 | 250 | 0.881356 | 2.20339 | Nocardioides humi | 449461 | Bacteria | Bacteria | 155 | 4.139999999999999e-43 | NR | WP_141003214.1 | 449461 | g9196 | i0 | 93.9 | 0.984 | 82 | 5 | 98.4 | 0 | 3 | 248 | 173 | 254 | WP_141003214.1 aldehyde dehydrogenase family protein [Nocardioides humi] | diamond | 246 | 155 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides humi | ||
| 26873570 | 26873570 | PRJNA815356_P_NODE_9921_length_246_cov_1.346821_g9758_i0 | PRJNA815356 | 9921 | 246 | 1.346821 | 3.31317966 | PVC group | 1783257 | Bacteria | Bacteria | 67.8 | 8.09e-13 | NR | WP_277495596.1 | 708131 | g9758 | i0 | 43.1 | 3.60975609756098 | 72 | 41 | 87.8 | 0 | 224 | 9 | 5 | 76 | WP_277495596.1 acyl carrier protein [Aurantimicrobium minutum] | diamond | 888 | 68.2 | 0.994134897360704 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Aurantimicrobium | Aurantimicrobium minutum | ||
| 26990925 | 26990925 | PRJNA815356_P_NODE_9282_length_250_cov_0.881356_g9119_i0 | PRJNA815356 | 9282 | 250 | 0.881356 | 2.20339 | Mycobacterium sp. | 1785 | Bacteria | Bacteria | 85.9 | 1.43e-19 | NR | WP_292988655.1 | 1785 | g9119 | i0 | 100 | 0.54 | 45 | 0 | 54 | 0 | 136 | 2 | 1 | 45 | WP_292988655.1 hypothetical protein [Mycobacterium sp.] | diamond | 135 | 85.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium sp. | ||
| 27433924 | 27433924 | PRJNA815356_P_NODE_10683_length_242_cov_0.923077_g10520_i0 | PRJNA815356 | 10683 | 242 | 0.923077 | 2.23384634 | Mycolicibacterium mageritense | 53462 | Bacteria | Bacteria | 130 | 7e-33 | NR | WP_036436713.1 | 53462 | g10520 | i0 | 73.4 | 0.979338842975207 | 79 | 21 | 97.9 | 0 | 4 | 240 | 686 | 764 | WP_036436713.1 hypothetical protein [Mycolicibacterium mageritense] | diamond | 237 | 130 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycolicibacterium | Mycolicibacterium mageritense | ||
| 28475669 | 28475669 | PRJNA815356_P_NODE_9346_length_250_cov_0.881356_g9183_i0 | PRJNA815356 | 9346 | 250 | 0.881356 | 2.20339 | Mycobacterium sp. | 1785 | Bacteria | Bacteria | 155 | 6.199999999999999e-46 | NR | WP_292988849.1 | 1785 | g9183 | i0 | 100 | 0.984 | 82 | 0 | 98.4 | 0 | 248 | 3 | 16 | 97 | WP_292988849.1 TetR/AcrR family transcriptional regulator [Mycobacterium sp.] | diamond | 246 | 155 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium sp. | ||
| 28633724 | 28633724 | PRJNA815356_P_NODE_7407_length_271_cov_1.575758_g7244_i0 | PRJNA815356 | 7407 | 271 | 1.575758 | 4.27030418 | Mycobacterium sp. | 1785 | Bacteria | Bacteria | 179 | 1.63e-53 | NR | WP_292981243.1 | 1785 | g7244 | i0 | 100 | 0.985239852398524 | 89 | 0 | 98.5 | 0 | 269 | 3 | 232 | 320 | WP_292981243.1 hypothetical protein [Mycobacterium sp.] | diamond | 267 | 179 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium sp. | ||
| 29485757 | 29485757 | PRJNA815356_P_NODE_9790_length_247_cov_0.896552_g9627_i0 | PRJNA815356 | 9790 | 247 | 0.896552 | 2.21448344 | uncultured Amnibacterium sp. | 1631851 | Bacteria | Bacteria | 150 | 8.879999999999997e-42 | NR | WP_375405853.1 | 1631851 | g9627 | i0 | 93.9 | 0.995951417004049 | 82 | 5 | 99.6 | 0 | 246 | 1 | 128 | 209 | WP_375405853.1 tyrosine-type recombinase/integrase [uncultured Amnibacterium sp.] | diamond | 246 | 150 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Amnibacterium | uncultured Amnibacterium sp. | ||
| 29801642 | 29801642 | PRJNA815356_P_NODE_10131_length_245_cov_0.906977_g9968_i0 | PRJNA815356 | 10131 | 245 | 0.906977 | 2.22209365 | Mycobacterium sp. | 1785 | Bacteria | Bacteria | 60.8 | 1.53e-8 | NR | WP_292974838.1 | 1785 | g9968 | i0 | 100 | 0.355102040816327 | 29 | 0 | 35.5 | 0 | 228 | 142 | 410 | 438 | WP_292974838.1 PPE family protein [Mycobacterium sp.] | diamond | 87 | 60.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium sp. | ||
| 30212267 | 30212267 | PRJNA815356_P_NODE_9012_length_252_cov_0.871508_g8849_i0 | PRJNA815356 | 9012 | 252 | 0.871508 | 2.19620016 | Nocardioides sp. | 35761 | Bacteria | Bacteria | 93.6 | 5.26e-20 | NR | WP_292676795.1 | 35761 | g8849 | i0 | 59.5 | 0.94047619047619 | 79 | 29 | 92.9 | 2 | 2 | 235 | 562 | 638 | WP_292676795.1 right-handed parallel beta-helix repeat-containing protein [Nocardioides sp.] | diamond | 237 | 93.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. | ||
| 30339282 | 30339282 | PRJNA815356_P_NODE_10132_length_245_cov_0.906977_g9969_i0 | PRJNA815356 | 10132 | 245 | 0.906977 | 2.22209365 | Actinomycetospora atypica | 1290095 | Bacteria | Bacteria | 151 | 3.2e-43 | NR | WP_378038687.1 | 1290095 | g9969 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 1 | 243 | 129 | 209 | WP_378038687.1 anti-sigma-D factor RsdA [Actinomycetospora atypica] | diamond | 243 | 151 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Actinomycetospora | Actinomycetospora atypica | ||
| 30812688 | 30812688 | PRJNA815356_P_NODE_9174_length_251_cov_0.876404_g9011_i0 | PRJNA815356 | 9174 | 251 | 0.876404 | 2.19977404 | Pseudoclavibacter sp. | 1915061 | Bacteria | Bacteria | 147 | 2.2199999999999998e-42 | NR | HHW50447.1 | 1915061 | g9011 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 2 | 250 | 81 | 163 | HHW50447.1 hydantoinase B/oxoprolinase family protein [Pseudoclavibacter sp.] | diamond | 249 | 147 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Pseudoclavibacter | Pseudoclavibacter sp. | ||
| 30852975 | 30852975 | PRJNA815356_P_NODE_9534_length_249_cov_0.886364_g9371_i0 | PRJNA815356 | 9534 | 249 | 0.886364 | 2.20704636 | Actinomycetes | 1760 | Bacteria | Bacteria | 70.1 | 9.12e-12 | NR | MCW2714814.1 | 1909291 | g9371 | i0 | 62 | 4.55421686746988 | 71 | 26 | 84.3 | 1 | 248 | 39 | 133 | 203 | MCW2714814.1 hypothetical protein [Frankiales bacterium] | diamond | 1134 | 70.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Frankiales | Frankiales bacterium | ||||
| 31002403 | 31002403 | PRJNA815356_P_NODE_10734_length_242_cov_0.923077_g10571_i0 | PRJNA815356 | 10734 | 242 | 0.923077 | 2.23384634 | Mycobacterium sp. | 1785 | Bacteria | Bacteria | 157 | 2.4499999999999998e-47 | NR | WP_293004563.1 | 1785 | g10571 | i0 | 98.8 | 0.991735537190083 | 80 | 1 | 99.2 | 0 | 242 | 3 | 4 | 83 | WP_293004563.1 DUF2599 domain-containing protein [Mycobacterium sp.] | diamond | 240 | 157 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium sp. | ||
| 31508333 | 31508333 | PRJNA815356_P_NODE_9936_length_246_cov_0.901734_g9773_i0 | PRJNA815356 | 9936 | 246 | 0.901734 | 2.21826564 | Microbacterium sp. | 51671 | Bacteria | Bacteria | 67.8 | 5.87e-11 | NR | HEX5860161.1 | 51671 | g9773 | i0 | 94.1 | 0.414634146341463 | 34 | 2 | 41.5 | 0 | 246 | 145 | 509 | 542 | HEX5860161.1 phosphatase PAP2 family protein [Microbacterium sp.] | diamond | 102 | 67.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. | ||
| 31824301 | 31824301 | PRJNA815356_P_NODE_9337_length_250_cov_0.881356_g9174_i0 | PRJNA815356 | 9337 | 250 | 0.881356 | 2.20339 | Mycobacterium sp. | 1785 | Bacteria | Bacteria | 84.3 | 3.43e-18 | NR | MDT5206821.1 | 1785 | g9174 | i0 | 82.7 | 1.236 | 52 | 9 | 62.4 | 0 | 1 | 156 | 122 | 173 | MDT5206821.1 multiple sugar transport system ATP-binding protein [Mycobacterium sp.] | diamond | 309 | 84.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium sp. | ||
| 32181318 | 32181318 | PRJNA815356_P_NODE_10738_length_242_cov_0.923077_g10575_i0 | PRJNA815356 | 10738 | 242 | 0.923077 | 2.23384634 | Friedmanniella | 53387 | Bacteria | Bacteria | 141 | 2.83e-38 | NR | WP_294693294.1 | 335381 | g10575 | i0 | 85 | 3.96694214876033 | 80 | 12 | 99.2 | 0 | 2 | 241 | 299 | 378 | WP_294693294.1 M16 family metallopeptidase [uncultured Friedmanniella sp.] | diamond | 960 | 141 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Friedmanniella | uncultured Friedmanniella sp. | ||
| 32267596 | 32267596 | PRJNA815356_P_NODE_9418_length_249_cov_1.607955_g9255_i0 | PRJNA815356 | 9418 | 249 | 1.607955 | 4.00380795 | Mycobacterium sp. | 1785 | Bacteria | Bacteria | 78.6 | 5.54e-15 | NR | MCW2690558.1 | 1785 | g9255 | i0 | 58.4 | 0.927710843373494 | 77 | 29 | 90.4 | 2 | 242 | 18 | 80 | 155 | MCW2690558.1 hypothetical protein [Mycobacterium sp.] | diamond | 231 | 78.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium sp. |
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);;