contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax_phylum = "Abditibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4442665 | 4442665 | PRJNA641707_P_NODE_283844_length_169_cov_2.750000_g281181_i0 | PRJNA641707 | 283844 | 169 | 2.75 | 4.6475 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 81.6 | 1.86e-18 | NR | HEY0076435.1 | 2800791 | g281181 | i0 | 74.1 | 1.91715976331361 | 54 | 14 | 95.9 | 0 | 166 | 5 | 3 | 56 | HEY0076435.1 50S ribosomal protein L23 [Abditibacteriaceae bacterium] | diamond | 324 | 81.6 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 4443691 | 4443691 | PRJNA641707_P_NODE_327904_length_155_cov_3.443396_g325241_i0 | PRJNA641707 | 327904 | 155 | 3.443396 | 5.3372638 | Abditibacterium | 2109263 | Bacteria | Bacteria | 99 | 1.76e-22 | NR | WP_157947561.1 | 1960156 | g325241 | i0 | 98 | 5.80645161290323 | 50 | 1 | 96.8 | 0 | 5 | 154 | 649 | 698 | WP_157947561.1 transcription-repair coupling factor [Abditibacterium utsteinense] | diamond | 900 | 99 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium utsteinense | ||
| 17194801 | 17194801 | PRJNA641707_P_NODE_62434_length_268_cov_11.082192_g59773_i0 | PRJNA641707 | 62434 | 268 | 11.082192 | 29.70027456 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 88.6 | 1.01e-19 | NR | HEX8464743.1 | 2109264 | g59773 | i0 | 59.5 | 1.54477611940298 | 79 | 30 | 86.2 | 1 | 231 | 1 | 94 | 172 | HEX8464743.1 fasciclin domain-containing protein [Abditibacterium sp.] | diamond | 414 | 88.6 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 18467349 | 18467349 | PRJNA641707_P_NODE_293015_length_166_cov_4.170940_g290352_i0 | PRJNA641707 | 293015 | 166 | 4.17094 | 6.9237604 | Abditibacterium utsteinense | 1960156 | Bacteria | Bacteria | 89.4 | 1.56e-19 | NR | WP_105482401.1 | 1960156 | g290352 | i0 | 76.4 | 0.993975903614458 | 55 | 13 | 99.4 | 0 | 165 | 1 | 100 | 154 | WP_105482401.1 NADPH:quinone reductase [Abditibacterium utsteinense] | diamond | 165 | 89.4 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium utsteinense | ||
| 24840755 | 24840755 | PRJNA641707_P_NODE_258340_length_179_cov_1.600000_g255677_i0 | PRJNA641707 | 258340 | 179 | 1.6 | 2.864 | Abditibacterium utsteinense | 1960156 | Bacteria | Bacteria | 105 | 3.4900000000000006e-27 | NR | WP_105483736.1 | 1960156 | g255677 | i0 | 100 | 0.854748603351955 | 51 | 0 | 85.5 | 0 | 26 | 178 | 1 | 51 | WP_105483736.1 50S ribosomal protein L11 [Abditibacterium utsteinense] | diamond | 153 | 105 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium utsteinense | ||
| 26922935 | 26922935 | PRJNA641707_P_NODE_183362_length_199_cov_15.340000_g180699_i0 | PRJNA641707 | 183362 | 199 | 15.34 | 30.5266 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 86.3 | 9.74e-18 | NR | HEX8550976.1 | 2800791 | g180699 | i0 | 48.4 | 2.84924623115578 | 95 | 18 | 96.5 | 1 | 193 | 2 | 229 | 323 | HEX8550976.1 acetate--CoA ligase [Abditibacteriaceae bacterium] | diamond | 567 | 86.3 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 27143886 | 27143886 | PRJNA641707_P_NODE_201242_length_197_cov_6.263514_g198579_i0 | PRJNA641707 | 201242 | 197 | 6.263514 | 12.33912258 | Abditibacterium utsteinense | 1960156 | Bacteria | Bacteria | 56.6 | 6.06e-9 | NR | WP_157947470.1 | 1960156 | g198579 | i0 | 96.3 | 0.411167512690355 | 27 | 1 | 41.1 | 0 | 164 | 84 | 1 | 27 | WP_157947470.1 hypothetical protein [Abditibacterium utsteinense] | diamond | 81 | 56.6 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium utsteinense | ||
| 27334212 | 27334212 | PRJNA641707_P_NODE_309863_length_161_cov_14.875000_g307200_i0 | PRJNA641707 | 309863 | 161 | 14.875 | 23.94875 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 73.6 | 7.74e-15 | NR | HEX8834991.1 | 2800791 | g307200 | i0 | 78.7 | 0.875776397515528 | 47 | 10 | 87.6 | 0 | 8 | 148 | 99 | 145 | HEX8834991.1 S1 RNA-binding domain-containing protein [Abditibacteriaceae bacterium] | diamond | 141 | 73.6 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 27681736 | 27681736 | PRJNA641707_P_NODE_290044_length_167_cov_2.949153_g287381_i0 | PRJNA641707 | 290044 | 167 | 2.949153 | 4.92508551 | Abditibacterium utsteinense | 1960156 | Bacteria | Bacteria | 53.1 | 2.81e-6 | NR | WP_157947692.1 | 1960156 | g287381 | i0 | 54.8 | 0.754491017964072 | 42 | 19 | 75.4 | 0 | 7 | 132 | 118 | 159 | WP_157947692.1 type II secretion system protein GspD [Abditibacterium utsteinense] | diamond | 126 | 53.1 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium utsteinense | ||
| 27807814 | 27807814 | PRJNA641707_P_NODE_127724_length_244_cov_9.564103_g125061_i0 | PRJNA641707 | 127724 | 244 | 9.564103 | 23.33641132 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 59.3 | 5.23e-8 | NR | BCM91669.1 | 2783868 | g125061 | i0 | 96.8 | 0.737704918032787 | 31 | 1 | 38.1 | 0 | 239 | 147 | 454 | 484 | BCM91669.1 hypothetical protein IAD21_03544 [Abditibacteriota bacterium] | diamond | 180 | 59.3 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 27933989 | 27933989 | PRJNA641707_P_NODE_242005_length_185_cov_10.235294_g239342_i0 | PRJNA641707 | 242005 | 185 | 10.235294 | 18.9352939 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 99 | 5.52e-24 | NR | HEX8465368.1 | 2109264 | g239342 | i0 | 81.7 | 0.972972972972973 | 60 | 11 | 97.3 | 0 | 185 | 6 | 43 | 102 | HEX8465368.1 hypothetical protein [Abditibacterium sp.] | diamond | 180 | 99 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 28217887 | 28217887 | PRJNA641707_P_NODE_264806_length_176_cov_5.433071_g262143_i0 | PRJNA641707 | 264806 | 176 | 5.433071 | 9.56220496 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 52.8 | 1.47e-6 | NR | HEX9998652.1 | 2109264 | g262143 | i0 | 66.7 | 1.39772727272727 | 42 | 14 | 71.6 | 0 | 128 | 3 | 28 | 69 | HEX9998652.1 rhodanese-like domain-containing protein [Abditibacterium sp.] | diamond | 246 | 52.8 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 28597208 | 28597208 | PRJNA641707_P_NODE_328107_length_155_cov_3.141509_g325444_i0 | PRJNA641707 | 328107 | 155 | 3.141509 | 4.86933895 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 49.3 | 5.45e-5 | NR | HEX9997069.1 | 2109264 | g325444 | i0 | 59.1 | 0.851612903225806 | 44 | 18 | 85.2 | 0 | 152 | 21 | 496 | 539 | HEX9997069.1 stalk domain-containing protein [Abditibacterium sp.] | diamond | 132 | 49.3 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 28849442 | 28849442 | PRJNA641707_P_NODE_275228_length_172_cov_4.552846_g272565_i0 | PRJNA641707 | 275228 | 172 | 4.552846 | 7.83089512 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 62.8 | 1.23e-9 | NR | HVF84426.1 | 2800791 | g272565 | i0 | 52.7 | 6.76744186046512 | 55 | 26 | 95.9 | 0 | 8 | 172 | 210 | 264 | HVF84426.1 glycoside hydrolase family 15 protein [Abditibacteriaceae bacterium] | diamond | 1164 | 62.8 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 29259825 | 29259825 | PRJNA641707_P_NODE_169149_length_201_cov_9.868421_g166486_i0 | PRJNA641707 | 169149 | 201 | 9.868421 | 19.83552621 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 62 | 3.38e-9 | NR | HVF11230.1 | 2800791 | g166486 | i0 | 68.6 | 2.08955223880597 | 35 | 11 | 52.2 | 0 | 107 | 3 | 775 | 809 | HVF11230.1 stalk domain-containing protein [Abditibacteriaceae bacterium] | diamond | 420 | 62 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 29745801 | 29745801 | PRJNA641707_P_NODE_288930_length_167_cov_5.644068_g286267_i0 | PRJNA641707 | 288930 | 167 | 5.644068 | 9.42559356 | Bacteria | 2 | Bacteria | Bacteria | 80.1 | 8.92e-16 | NR | MDF2440000.1 | 2783868 | g286267 | i0 | 71.7 | 1.88622754491018 | 53 | 15 | 95.2 | 0 | 160 | 2 | 190 | 242 | MDF2440000.1 proteasome-associated ATPase [Abditibacteriota bacterium] | diamond | 315 | 80.1 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 30239064 | 30239064 | PRJNA641707_P_NODE_199332_length_197_cov_9.925676_g196669_i0 | PRJNA641707 | 199332 | 197 | 9.925676 | 19.55358172 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 87 | 3.38e-18 | NR | HEX9997493.1 | 2109264 | g196669 | i0 | 63.8 | 3.71573604060914 | 80 | 11 | 94.4 | 1 | 190 | 5 | 293 | 372 | HEX9997493.1 bifunctional phosphopantothenoylcysteine decarboxylase/phosphopantothenate--cysteine ligase CoaBC [Abditibacterium sp.] | diamond | 732 | 87 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 30270932 | 30270932 | PRJNA641707_P_NODE_226572_length_191_cov_6.866197_g223909_i0 | PRJNA641707 | 226572 | 191 | 6.866197 | 13.11443627 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 70.9 | 1.58e-14 | NR | HEX8238046.1 | 2800791 | g223909 | i0 | 61.8 | 0.863874345549738 | 55 | 21 | 86.4 | 0 | 187 | 23 | 1 | 55 | HEX8238046.1 Flp family type IVb pilin [Abditibacteriaceae bacterium] | diamond | 165 | 70.9 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 31029342 | 31029342 | PRJNA641707_P_NODE_83235_length_246_cov_7.203046_g80572_i0 | PRJNA641707 | 83235 | 246 | 7.203046 | 17.71949316 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 67 | 7.37e-11 | NR | BCM88180.1 | 2783868 | g80572 | i0 | 90.6 | 0.390243902439024 | 32 | 3 | 39 | 0 | 149 | 244 | 272 | 303 | BCM88180.1 hypothetical protein IAD21_00007 [Abditibacteriota bacterium] | diamond | 96 | 67 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 31250162 | 31250162 | PRJNA641707_P_NODE_270595_length_174_cov_3.376000_g267932_i0 | PRJNA641707 | 270595 | 174 | 3.376 | 5.87424 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 45.4 | 0.00159 | NR | HEX8464976.1 | 2109264 | g267932 | i0 | 61.3 | 1.06896551724138 | 31 | 11 | 51.7 | 1 | 169 | 80 | 296 | 326 | HEX8464976.1 H-X9-DG-CTERM domain-containing protein [Abditibacterium sp.] | diamond | 186 | 45.4 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 31408528 | 31408528 | PRJNA641707_P_NODE_75516_length_246_cov_13.167513_g72853_i0 | PRJNA641707 | 75516 | 246 | 13.167513 | 32.39208198 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 55.5 | 1.29e-6 | NR | MBV9864486.1 | 2800791 | g72853 | i0 | 33.3 | 2.70731707317073 | 111 | 43 | 97.6 | 1 | 244 | 5 | 570 | 680 | MBV9864486.1 carboxypeptidase regulatory-like domain-containing protein [Abditibacteriaceae bacterium] | diamond | 666 | 55.5 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 31566685 | 31566685 | PRJNA641707_P_NODE_144376_length_240_cov_8.319372_g141713_i0 | PRJNA641707 | 144376 | 240 | 8.319372 | 19.9664928 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 62.4 | 2.27e-9 | NR | HEX8551560.1 | 2800791 | g141713 | i0 | 43.4 | 1.0375 | 83 | 39 | 93.8 | 1 | 3 | 227 | 166 | 248 | HEX8551560.1 beta-ketoacyl synthase N-terminal-like domain-containing protein [Abditibacteriaceae bacterium] | diamond | 249 | 62.4 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 31692932 | 31692932 | PRJNA641707_P_NODE_182497_length_200_cov_2.139073_g179834_i0 | PRJNA641707 | 182497 | 200 | 2.139073 | 4.278146 | Abditibacterium utsteinense | 1960156 | Bacteria | Bacteria | 65.5 | 1.83e-10 | NR | WP_106381296.1 | 1960156 | g179834 | i0 | 97.1 | 0.51 | 34 | 1 | 51 | 0 | 3 | 104 | 195 | 228 | WP_106381296.1 DNA polymerase III subunit beta [Abditibacterium utsteinense] | diamond | 102 | 65.5 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium utsteinense | ||
| 31882719 | 31882719 | PRJNA641707_P_NODE_256217_length_179_cov_12.223077_g253554_i0 | PRJNA641707 | 256217 | 179 | 12.223077 | 21.87930783 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 55.5 | 4.85e-7 | NR | BCM89456.1 | 2783868 | g253554 | i0 | 52.3 | 1.08938547486034 | 65 | 24 | 97.2 | 2 | 4 | 177 | 181 | 245 | BCM89456.1 hypothetical protein IAD21_01302 [Abditibacteriota bacterium] | diamond | 195 | 55.5 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 32294565 | 32294565 | PRJNA641707_P_NODE_329679_length_154_cov_5.495238_g327016_i0 | PRJNA641707 | 329679 | 154 | 5.495238 | 8.46266652 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 89.7 | 1.7e-19 | NR | HEX9997459.1 | 2109264 | g327016 | i0 | 80.4 | 0.993506493506494 | 51 | 10 | 99.4 | 0 | 153 | 1 | 328 | 378 | HEX9997459.1 hypothetical protein [Abditibacterium sp.] | diamond | 153 | 89.7 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 32357721 | 32357721 | PRJNA641707_P_NODE_277739_length_171_cov_4.901639_g275076_i0 | PRJNA641707 | 277739 | 171 | 4.901639 | 8.38180269 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 107 | 1.6600000000000003e-27 | NR | HEX9995754.1 | 2109264 | g275076 | i0 | 87.3 | 1.92982456140351 | 55 | 7 | 96.5 | 0 | 5 | 169 | 17 | 71 | HEX9995754.1 G/U mismatch-specific DNA glycosylase [Abditibacterium sp.] | diamond | 330 | 107 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 32369994 | 32369994 | PRJNA641707_P_NODE_190859_length_198_cov_22.308725_g188196_i0 | PRJNA641707 | 190859 | 198 | 22.308725 | 44.1712755 | Abditibacterium | 2109263 | Bacteria | Bacteria | 80.5 | 6.94e-16 | NR | WP_157947649.1 | 1960156 | g188196 | i0 | 63.5 | 5.84848484848485 | 63 | 21 | 92.4 | 1 | 11 | 193 | 147 | 209 | WP_157947649.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Abditibacterium utsteinense] | diamond | 1158 | 81.3 | 0.990159901599016 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium utsteinense |
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);;