contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax_phylum = "Thermodesulfobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8268960 | 8268960 | PRJNA641707_P_NODE_311727_length_161_cov_3.517857_g309064_i0 | PRJNA641707 | 311727 | 161 | 3.517857 | 5.66374977 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 67.4 | 2.44e-11 | NR | WP_137425402.1 | 361111 | g309064 | i0 | 65.3 | 23.6273291925466 | 49 | 17 | 91.3 | 0 | 7 | 153 | 532 | 580 | WP_137425402.1 response regulator [Desulfoglaeba alkanexedens] | diamond | 3804 | 67.8 | 0.994100294985251 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Desulfoglaeba | Desulfoglaeba alkanexedens | ||
| 10820037 | 10820037 | PRJNA641707_P_NODE_317529_length_159_cov_2.618182_g314866_i0 | PRJNA641707 | 317529 | 159 | 2.618182 | 4.16290938 | Syntrophales bacterium | 2928017 | Bacteria | Bacteria | 73.2 | 2.15e-13 | NR | MCK9364235.1 | 2928017 | g314866 | i0 | 80.4 | 0.962264150943396 | 51 | 10 | 96.2 | 0 | 154 | 2 | 382 | 432 | MCK9364235.1 Ig-like domain-containing protein [Syntrophales bacterium] | diamond | 153 | 73.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophales bacterium | ||||
| 26681888 | 26681888 | PRJNA641707_P_NODE_120221_length_245_cov_7.632653_g117558_i0 | PRJNA641707 | 120221 | 245 | 7.632653 | 18.69999985 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 56.6 | 4.84e-7 | NR | HEX3034643.1 | 2202153 | g117558 | i0 | 80 | 2.86530612244898 | 30 | 6 | 36.7 | 0 | 91 | 2 | 464 | 493 | HEX3034643.1 FAD-dependent oxidoreductase [Thermodesulfobacteriota bacterium] | diamond | 702 | 57 | 0.992982456140351 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 26732551 | 26732551 | PRJNA641707_P_NODE_203961_length_196_cov_17.136054_g201298_i0 | PRJNA641707 | 203961 | 196 | 17.136054 | 33.58666584 | Desulfobacter curvatus | 2290 | Bacteria | Bacteria | 46.2 | 0.00123 | NR | WP_083927932.1 | 2290 | g201298 | i0 | 46.9 | 0.979591836734694 | 64 | 33 | 96.4 | 1 | 190 | 2 | 999 | 1062 | WP_083927932.1 beta strand repeat-containing protein [Desulfobacter curvatus] | diamond | 192 | 46.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacter | Desulfobacter curvatus | ||
| 26732608 | 26732608 | PRJNA641707_P_NODE_295221_length_165_cov_11.844828_g292558_i0 | PRJNA641707 | 295221 | 165 | 11.844828 | 19.5439662 | Syntrophobacterales bacterium | 2282155 | Bacteria | Bacteria | 42.7 | 0.00185 | NR | MCX7823568.1 | 2282155 | g292558 | i0 | 46.7 | 0.818181818181818 | 45 | 24 | 81.8 | 0 | 5 | 139 | 1 | 45 | MCX7823568.1 hypothetical protein [Syntrophobacterales bacterium] | diamond | 135 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacterales bacterium | ||||
| 26903834 | 26903834 | PRJNA641707_P_NODE_316821_length_159_cov_3.909091_g314158_i0 | PRJNA641707 | 316821 | 159 | 3.909091 | 6.21545469 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 42 | 0.0223 | NR | VTR68157.1 | 90730 | g314158 | i0 | 66.7 | 5.83018867924528 | 27 | 9 | 50.9 | 0 | 17 | 97 | 704 | 730 | VTR68157.1 putative Histidine kinase [Desulfosarcina cetonica] | diamond | 927 | 42.4 | 0.990566037735849 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosarcinaceae | Desulfosarcina | Desulfosarcina cetonica | ||
| 27017833 | 27017833 | PRJNA641707_P_NODE_238862_length_187_cov_1.963768_g236199_i0 | PRJNA641707 | 238862 | 187 | 1.963768 | 3.67224616 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 42.7 | 0.0102 | NR | MEJ2661977.1 | 2049433 | g236199 | i0 | 43.9 | 0.914438502673797 | 57 | 31 | 89.8 | 1 | 169 | 2 | 80 | 136 | MEJ2661977.1 metallophosphoesterase family protein [Desulfobacteraceae bacterium] | diamond | 171 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 27460486 | 27460486 | PRJNA641707_P_NODE_231263_length_189_cov_17.157143_g228600_i0 | PRJNA641707 | 231263 | 189 | 17.157143 | 32.42700027 | Lawsonia intracellularis PHE/MN1- | 29546 | Bacteria | Bacteria | 41.2 | 0.044 | NR | CAJ55201.1 | 363253 | g228600 | i0 | 45 | 0.952380952380952 | 60 | 31 | 95.2 | 1 | 189 | 10 | 94 | 151 | CAJ55201.1 NA [Lawsonia intracellularis PHE/MN1-00] | diamond | 180 | 41.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Lawsonia | Lawsonia intracellularis | ||
| 27618413 | 27618413 | PRJNA641707_P_NODE_330284_length_154_cov_4.133333_g327621_i0 | PRJNA641707 | 330284 | 154 | 4.133333 | 6.36533282 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 80.9 | 3.85e-16 | NR | MEW6269823.1 | 2202153 | g327621 | i0 | 81.6 | 0.954545454545455 | 49 | 9 | 95.5 | 0 | 149 | 3 | 50 | 98 | MEW6269823.1 PQQ-dependent sugar dehydrogenase [Thermodesulfobacteriota bacterium] | diamond | 147 | 80.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 27838978 | 27838978 | PRJNA641707_P_NODE_108704_length_246_cov_3.065990_g106041_i0 | PRJNA641707 | 108704 | 246 | 3.06599 | 7.5423354 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 99.4 | 4.66e-22 | NR | MDJ0667760.1 | 2044940 | g106041 | i0 | 61.5 | 1.91463414634146 | 78 | 27 | 95.1 | 1 | 7 | 240 | 241 | 315 | MDJ0667760.1 FAD-dependent oxidoreductase [Desulfobacterales bacterium] | diamond | 471 | 99.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 27870631 | 27870631 | PRJNA641707_P_NODE_126285_length_244_cov_20.497436_g123622_i0 | PRJNA641707 | 126285 | 244 | 20.497436 | 50.01374384 | Mailhella sp. | 1981029 | Bacteria | Bacteria | 70.1 | 8.48e-12 | NR | MBQ2760668.1 | 1981029 | g123622 | i0 | 97 | 2.4344262295082 | 33 | 1 | 40.6 | 0 | 144 | 242 | 28 | 60 | MBQ2760668.1 LPS-assembly protein LptD [Mailhella sp.] | diamond | 594 | 70.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Mailhella | Mailhella sp. | ||
| 28060119 | 28060119 | PRJNA641707_P_NODE_124925_length_245_cov_3.744898_g122262_i0 | PRJNA641707 | 124925 | 245 | 3.744898 | 9.1750001 | Geotalea uraniireducens | 351604 | Bacteria | Bacteria | 46.2 | 0.00224 | NR | WP_157046243.1 | 351604 | g122262 | i0 | 61.3 | 0.379591836734694 | 31 | 12 | 38 | 0 | 237 | 145 | 376 | 406 | WP_157046243.1 hypothetical protein [Geotalea uraniireducens] | diamond | 93 | 46.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geotalea | Geotalea uraniireducens | ||
| 28060320 | 28060320 | PRJNA641707_P_NODE_99385_length_246_cov_4.309645_g96722_i0 | PRJNA641707 | 99385 | 246 | 4.309645 | 10.6017267 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 59.3 | 5.7e-8 | NR | MCP4113711.1 | 2049433 | g96722 | i0 | 84.4 | 0.390243902439024 | 32 | 5 | 39 | 0 | 148 | 243 | 102 | 133 | MCP4113711.1 hypothetical protein [Desulfobacteraceae bacterium] | diamond | 96 | 59.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 28261883 | 28261883 | PRJNA641707_P_NODE_167286_length_202_cov_4.836601_g164623_i0 | PRJNA641707 | 167286 | 202 | 4.836601 | 9.7699340200000009 | FCB group | 1783270 | Bacteria | Bacteria | 57.8 | 4.13e-9 | NR | HAO22109.1 | 2049433 | g164623 | i0 | 81.3 | 4.9009900990099 | 32 | 6 | 47.5 | 0 | 8 | 103 | 28 | 59 | HAO22109.1 hypothetical protein [Desulfobacteraceae bacterium] | diamond | 990 | 58.2 | 0.993127147766323 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 28849426 | 28849426 | PRJNA641707_P_NODE_253428_length_181_cov_1.803030_g250765_i0 | PRJNA641707 | 253428 | 181 | 1.80303 | 3.2634843 | Desulfobulbaceae bacterium | 2053307 | Bacteria | Bacteria | 91.7 | 9e-20 | NR | MCP4341286.1 | 2053307 | g250765 | i0 | 78.9 | 0.94475138121547 | 57 | 12 | 94.5 | 0 | 173 | 3 | 403 | 459 | MCP4341286.1 nicotinate phosphoribosyltransferase [Desulfobulbaceae bacterium] | diamond | 171 | 91.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbaceae bacterium | |||
| 29134006 | 29134006 | PRJNA641707_P_NODE_325169_length_156_cov_3.429907_g322506_i0 | PRJNA641707 | 325169 | 156 | 3.429907 | 5.35065492 | uncultured Desulfobacterales bacterium HF | 246132 | Bacteria | Bacteria | 43.1 | 0.00348 | NR | ADI17936.1 | 710741 | g322506 | i0 | 46.9 | 0.942307692307692 | 49 | 26 | 94.2 | 0 | 156 | 10 | 79 | 127 | ADI17936.1 hypothetical protein [uncultured Desulfobacterales bacterium HF0200_07G10] | diamond | 147 | 43.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | uncultured Desulfobacterales bacterium HF0200_07G10 | ||||
| 29828319 | 29828319 | PRJNA641707_P_NODE_239551_length_186_cov_9.291971_g236888_i0 | PRJNA641707 | 239551 | 186 | 9.291971 | 17.28306606 | Geobacteraceae bacterium | 2282154 | Bacteria | Bacteria | 86.3 | 7.94e-18 | NR | KAF0221305.1 | 2282154 | g236888 | i0 | 59 | 1.96774193548387 | 61 | 25 | 98.4 | 0 | 2 | 184 | 1118 | 1178 | KAF0221305.1 MAG: hypothetical protein FD174_443 [Geobacteraceae bacterium] | diamond | 366 | 86.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacteraceae bacterium | |||
| 30535823 | 30535823 | PRJNA641707_P_NODE_26793_length_419_cov_13.254054_g24201_i0 | PRJNA641707 | 26793 | 419 | 13.254054 | 55.53448626 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 53.5 | 2.05e-5 | NR | WP_054691334.1 | 90730 | g24201 | i0 | 35.6 | 2.46300715990453 | 90 | 45 | 59.4 | 3 | 80 | 328 | 112 | 195 | WP_054691334.1 hypothetical protein [Desulfosarcina cetonica] | diamond | 1032 | 53.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosarcinaceae | Desulfosarcina | Desulfosarcina cetonica | ||
| 30744634 | 30744634 | PRJNA641707_P_NODE_182454_length_200_cov_2.403974_g179791_i0 | PRJNA641707 | 182454 | 200 | 2.403974 | 4.807948 | Desulfoferula mesophila | 3058419 | Bacteria | Bacteria | 42.4 | 0.0292 | NR | WP_338601940.1 | 3058419 | g179791 | i0 | 43.9 | 0.855 | 57 | 31 | 85.5 | 1 | 28 | 198 | 13 | 68 | WP_338601940.1 hypothetical protein [Desulfoferula mesophila] | diamond | 171 | 42.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Desulfarculales | Desulfarculaceae | Desulfoferula | Desulfoferula mesophila | ||
| 31230803 | 31230803 | PRJNA641707_P_NODE_67775_length_255_cov_15.781553_g65112_i0 | PRJNA641707 | 67775 | 255 | 15.781553 | 40.24296015 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 88.6 | 1.99e-19 | NR | WP_011339779.1 | 19 | g65112 | i0 | 58.6 | 1.64705882352941 | 70 | 29 | 82.4 | 0 | 211 | 2 | 1 | 70 | WP_011339779.1 heteromeric transposase endonuclease subunit TnsA [Syntrophotalea carbinolica] | diamond | 420 | 88.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Syntrophotaleaceae | Syntrophotalea | Syntrophotalea carbinolica | ||
| 31420717 | 31420717 | PRJNA641707_P_NODE_232116_length_189_cov_7.535714_g229453_i0 | PRJNA641707 | 232116 | 189 | 7.535714 | 14.24249946 | Bacteria | 2 | Bacteria | Bacteria | 56.6 | 2.27e-7 | NR | KQC12184.1 | 1735325 | g229453 | i0 | 63.9 | 6.09523809523809 | 36 | 13 | 57.1 | 0 | 110 | 3 | 106 | 141 | KQC12184.1 MAG: elongation factor G [Desulfuromonas sp. SDB] | diamond | 1152 | 56.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. SDB | ||
| 31566700 | 31566700 | PRJNA641707_P_NODE_161496_length_211_cov_1.833333_g158833_i0 | PRJNA641707 | 161496 | 211 | 1.833333 | 3.86833263 | Geobacter sp. | 46610 | Bacteria | Bacteria | 94.7 | 5.07e-22 | NR | RII29852.1 | 46610 | g158833 | i0 | 64.2 | 1.90521327014218 | 67 | 24 | 95.3 | 0 | 9 | 209 | 27 | 93 | RII29852.1 MAG: peptidoglycan-binding protein [Geobacter sp.] | diamond | 402 | 94.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sp. | ||
| 31566791 | 31566791 | PRJNA641707_P_NODE_304636_length_163_cov_2.657895_g301973_i0 | PRJNA641707 | 304636 | 163 | 2.657895 | 4.33236885 | Fundidesulfovibrio agrisoli | 2922717 | Bacteria | Bacteria | 46.2 | 7.64e-4 | NR | WP_243310596.1 | 2922717 | g301973 | i0 | 48.8 | 0.754601226993865 | 41 | 21 | 75.5 | 0 | 157 | 35 | 44 | 84 | WP_243310596.1 7TM diverse intracellular signaling domain-containing protein [Fundidesulfovibrio agrisoli] | diamond | 123 | 46.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Fundidesulfovibrio | Fundidesulfovibrio agrisoli | ||
| 31629696 | 31629696 | PRJNA641707_P_NODE_106436_length_246_cov_3.365482_g103773_i0 | PRJNA641707 | 106436 | 246 | 3.365482 | 8.27908572 | Candidatus Magnetomorum sp. HK-1 | 1509431 | Bacteria | Bacteria | 55.8 | 9.1e-7 | NR | KPA09358.1 | 1509431 | g103773 | i0 | 83.3 | 0.74390243902439 | 30 | 5 | 36.6 | 0 | 157 | 246 | 40 | 69 | KPA09358.1 protein containing DUF820 [Candidatus Magnetomorum sp. HK-1] | diamond | 183 | 55.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Candidatus Magnetomoraceae | Candidatus Magnetomorum | Candidatus Magnetomorum sp. HK-1 | ||
| 32420690 | 32420690 | PRJNA641707_P_NODE_108499_length_246_cov_3.091371_g105836_i0 | PRJNA641707 | 108499 | 246 | 3.091371 | 7.60477266 | Geotalea uraniireducens | 351604 | Bacteria | Bacteria | 57.4 | 2.14e-7 | NR | WP_011940289.1 | 351604 | g105836 | i0 | 81.3 | 0.390243902439024 | 32 | 6 | 39 | 0 | 150 | 245 | 176 | 207 | WP_011940289.1 hypothetical protein [Geotalea uraniireducens] | diamond | 96 | 57.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geotalea | Geotalea uraniireducens | ||
| 32515940 | 32515940 | PRJNA641707_P_NODE_317839_length_158_cov_20.302752_g315176_i0 | PRJNA641707 | 317839 | 158 | 20.302752 | 32.07834816 | Pelobacter seleniigenes | 407188 | Bacteria | Bacteria | 62.8 | 9.66e-10 | NR | WP_029918103.1 | 407188 | g315176 | i0 | 63.3 | 1.86075949367089 | 49 | 15 | 91.1 | 2 | 1 | 144 | 72 | 118 | WP_029918103.1 amino acid aminotransferase [Pelobacter seleniigenes] | diamond | 294 | 62.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Pelobacter | Pelobacter seleniigenes | ||
| 32862192 | 32862192 | PRJNA641707_P_NODE_248220_length_183_cov_3.574627_g245557_i0 | PRJNA641707 | 248220 | 183 | 3.574627 | 6.54156741 | Desulfuromonadaceae bacterium | 2099677 | Bacteria | Bacteria | 64.7 | 2.95e-10 | NR | MDD2850390.1 | 2099677 | g245557 | i0 | 52.5 | 0.967213114754098 | 59 | 28 | 96.7 | 0 | 3 | 179 | 11 | 69 | MDD2850390.1 calcium-binding protein [Desulfuromonadaceae bacterium] | diamond | 177 | 64.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonadaceae 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);;