contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA382357" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 403627 | 403627 | PRJNA382357_P_NODE_32961_length_395_cov_2.008982_g32222_i0 | PRJNA382357 | 32961 | 395 | 2.008982 | 7.9354789 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 91.3 | 2.17e-21 | NR | MEX1281900.1 | 2044940 | g32222 | i0 | 73.7 | 2.51392405063291 | 57 | 15 | 43.3 | 0 | 395 | 225 | 10 | 66 | MEX1281900.1 type II toxin-antitoxin system HicA family toxin [Desulfobacterales bacterium] | diamond | 993 | 91.7 | 0.995637949836423 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 26726517 | 26726517 | PRJNA382357_P_NODE_44941_length_344_cov_3.717314_g44202_i0 | PRJNA382357 | 44941 | 344 | 3.717314 | 12.78756016 | Geoalkalibacter sp. | 3041440 | Bacteria | Bacteria | 79 | 2.4e-14 | NR | WP_305042379.1 | 3041440 | g44202 | i0 | 70.8 | 0.837209302325581 | 48 | 14 | 41.9 | 0 | 3 | 146 | 707 | 754 | WP_305042379.1 hypothetical protein [Geoalkalibacter sp.] | diamond | 288 | 79 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Geoalkalibacteraceae | Geoalkalibacter | Geoalkalibacter sp. | ||
| 26853751 | 26853751 | PRJNA382357_P_NODE_105601_length_236_cov_2.228571_g104862_i0 | PRJNA382357 | 105601 | 236 | 2.228571 | 5.25942756 | Desulfosalsimonadaceae bacterium | 3060584 | Bacteria | Bacteria | 60.5 | 8.23e-10 | NR | MDO9262657.1 | 3060584 | g104862 | i0 | 82.8 | 0.73728813559322 | 29 | 5 | 36.9 | 0 | 1 | 87 | 52 | 80 | MDO9262657.1 BrnT family toxin [Desulfosalsimonadaceae bacterium] | diamond | 174 | 60.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosalsimonadaceae | Desulfosalsimonadaceae bacterium | |||
| 26948362 | 26948362 | PRJNA382357_P_NODE_110002_length_232_cov_1.654971_g109263_i0 | PRJNA382357 | 110002 | 232 | 1.654971 | 3.83953272 | Smithella sp. | 2053614 | Bacteria | Bacteria | 84.7 | 3.98e-17 | NR | MEN6375517.1 | 2053614 | g109263 | i0 | 70.6 | 1.33189655172414 | 51 | 15 | 65.9 | 0 | 2 | 154 | 154 | 204 | MEN6375517.1 DNA methyltransferase [Smithella sp.] | diamond | 309 | 84.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Smithellaceae | Smithella | Smithella sp. | ||
| 28149033 | 28149033 | PRJNA382357_P_NODE_127565_length_216_cov_2.806452_g126826_i0 | PRJNA382357 | 127565 | 216 | 2.806452 | 6.06193632 | Desulfohalobiaceae bacterium | 2683721 | Bacteria | Bacteria | 88.2 | 7.3e-20 | NR | MEF8822686.1 | 2683721 | g126826 | i0 | 90.5 | 1.16666666666667 | 42 | 4 | 58.3 | 0 | 216 | 91 | 49 | 90 | MEF8822686.1 3D domain-containing protein [Desulfohalobiaceae bacterium] | diamond | 252 | 88.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfohalobiaceae bacterium | |||
| 28338429 | 28338429 | PRJNA382357_P_NODE_35706_length_381_cov_1.621875_g34967_i0 | PRJNA382357 | 35706 | 381 | 1.621875 | 6.17934375 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 92 | 4.26e-19 | NR | UCG05788.1 | 2044940 | g34967 | i0 | 35.8 | 1.90551181102362 | 120 | 76 | 94.5 | 1 | 21 | 380 | 206 | 324 | UCG05788.1 MAG: serpin family protein [Desulfobacterales bacterium] | diamond | 726 | 92 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 28496354 | 28496354 | PRJNA382357_P_NODE_123567_length_220_cov_1.238994_g122828_i0 | PRJNA382357 | 123567 | 220 | 1.238994 | 2.7257868 | Syntrophorhabdaceae bacterium | 2660714 | Bacteria | Bacteria | 48.1 | 1.4e-4 | NR | MCK9226613.1 | 2660714 | g122828 | i0 | 64.1 | 0.531818181818182 | 39 | 14 | 53.2 | 0 | 125 | 9 | 70 | 108 | MCK9226613.1 hypothetical protein [Syntrophorhabdaceae bacterium] | diamond | 117 | 48.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophorhabdia | Syntrophorhabdales | Syntrophorhabdaceae | Syntrophorhabdaceae bacterium | |||
| 28875092 | 28875092 | PRJNA382357_P_NODE_140488_length_208_cov_2.653061_g139749_i0 | PRJNA382357 | 140488 | 208 | 2.653061 | 5.51836688 | Desulfohalobiaceae bacterium | 2683721 | Bacteria | Bacteria | 84 | 8.21e-19 | NR | MEF8941717.1 | 2683721 | g139749 | i0 | 91.3 | 0.663461538461538 | 46 | 4 | 66.3 | 0 | 139 | 2 | 5 | 50 | MEF8941717.1 response regulator [Desulfohalobiaceae bacterium] | diamond | 138 | 84 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfohalobiaceae bacterium | |||
| 29033164 | 29033164 | PRJNA382357_P_NODE_119568_length_223_cov_5.172840_g118829_i0 | PRJNA382357 | 119568 | 223 | 5.17284 | 11.5354332 | Desulfuromonas sp. | 892 | Bacteria | Bacteria | 72 | 1.37e-12 | NR | MDY0189429.1 | 892 | g118829 | i0 | 75 | 1.52017937219731 | 40 | 10 | 53.8 | 0 | 154 | 35 | 409 | 448 | MDY0189429.1 acyl-CoA carboxylase subunit beta [Desulfuromonas sp.] | diamond | 339 | 72 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. | ||
| 29253808 | 29253808 | PRJNA382357_P_NODE_33349_length_393_cov_1.569277_g32610_i0 | PRJNA382357 | 33349 | 393 | 1.569277 | 6.16725861 | Desulfuromonadales bacterium | 2099678 | Bacteria | Bacteria | 114 | 2.08e-26 | NR | MDF1580936.1 | 2099678 | g32610 | i0 | 81 | 0.480916030534351 | 63 | 12 | 48.1 | 0 | 392 | 204 | 278 | 340 | MDF1580936.1 site-specific DNA-methyltransferase [Desulfuromonadales bacterium] | diamond | 189 | 114 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadales bacterium | ||||
| 29285475 | 29285475 | PRJNA382357_P_NODE_55709_length_313_cov_1.519841_g54970_i0 | PRJNA382357 | 55709 | 313 | 1.519841 | 4.75710233 | Desulfuromonas sp. | 892 | Bacteria | Bacteria | 88.2 | 7.68e-20 | NR | PLX96620.1 | 892 | g54970 | i0 | 48.8 | 0.78594249201278 | 82 | 42 | 78.6 | 0 | 67 | 312 | 44 | 125 | PLX96620.1 MAG: gamma-glutamylcyclotransferase [Desulfuromonas sp.] | diamond | 246 | 88.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. | ||
| 30264934 | 30264934 | PRJNA382357_P_NODE_124912_length_219_cov_1.088608_g124173_i0 | PRJNA382357 | 124912 | 219 | 1.088608 | 2.38405152 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 42 | 0.044 | NR | MCP4349423.1 | 2044940 | g124173 | i0 | 53.1 | 0.876712328767123 | 32 | 15 | 43.8 | 0 | 122 | 217 | 181 | 212 | MCP4349423.1 hypothetical protein [Desulfobacterales bacterium] | diamond | 192 | 42 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 31781674 | 31781674 | PRJNA382357_P_NODE_163677_length_189_cov_2.062500_g162938_i0 | PRJNA382357 | 163677 | 189 | 2.0625 | 3.898125 | Solidesulfovibrio alcoholivorans | 81406 | Bacteria | Bacteria | 62.4 | 2.19e-9 | NR | WP_029457415.1 | 81406 | g162938 | i0 | 96.7 | 0.476190476190476 | 30 | 1 | 47.6 | 0 | 189 | 100 | 278 | 307 | WP_029457415.1 PAS domain-containing protein [Solidesulfovibrio alcoholivorans] | diamond | 90 | 62.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Solidesulfovibrio | Solidesulfovibrio alcoholivorans | ||
| 31798628 | 31798628 | PRJNA382357_P_NODE_87537_length_256_cov_14.169231_g86798_i0 | PRJNA382357 | 87537 | 256 | 14.169231 | 36.27323136 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 80.5 | 2.26e-15 | NR | WP_162459126.1 | 83564 | g86798 | i0 | 70.2 | 6.64453125 | 47 | 14 | 55.1 | 0 | 1 | 141 | 74 | 120 | WP_162459126.1 phage terminase large subunit family protein [Desulfosarcina ovata] | diamond | 1701 | 81.3 | 0.990159901599016 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosarcinaceae | Desulfosarcina | Desulfosarcina ovata | ||
| 31908414 | 31908414 | PRJNA382357_P_NODE_54417_length_316_cov_2.070588_g53678_i0 | PRJNA382357 | 54417 | 316 | 2.070588 | 6.54305808 | Desulfobulbaceae bacterium | 2053307 | Bacteria | Bacteria | 87.4 | 6.47e-19 | NR | MBA3014277.1 | 2053307 | g53678 | i0 | 50.7 | 0.674050632911392 | 71 | 35 | 67.4 | 0 | 90 | 302 | 114 | 184 | MBA3014277.1 hypothetical protein [Desulfobulbaceae bacterium] | diamond | 213 | 87.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbaceae bacterium | |||
| 32003295 | 32003295 | PRJNA382357_P_NODE_109978_length_232_cov_1.801170_g109239_i0 | PRJNA382357 | 109978 | 232 | 1.80117 | 4.1787144 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 42 | 0.0494 | NR | MFC1813925.1 | 2202153 | g109239 | i0 | 30.9 | 0.711206896551724 | 55 | 38 | 71.1 | 0 | 62 | 226 | 107 | 161 | MFC1813925.1 hypothetical protein [Thermodesulfobacteriota bacterium] | diamond | 165 | 42 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 32051904 | 32051904 | PRJNA382357_P_NODE_103378_length_238_cov_7.610169_g102639_i0 | PRJNA382357 | 103378 | 238 | 7.610169 | 18.11220222 | Bacteria | 2 | Bacteria | Bacteria | 47.8 | 6.28e-4 | NR | MEW5736956.1 | 2202153 | g102639 | i0 | 50 | 2.53361344537815 | 54 | 26 | 68.1 | 1 | 223 | 62 | 863 | 915 | MEW5736956.1 DEAD/DEAH box helicase family protein [Thermodesulfobacteriota bacterium] | diamond | 603 | 48.1 | 0.993762993762994 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 32161697 | 32161697 | PRJNA382357_P_NODE_169038_length_174_cov_11.132743_g168299_i0 | PRJNA382357 | 169038 | 174 | 11.132743 | 19.37097282 | Geobacteraceae bacterium | 2282154 | Bacteria | Bacteria | 64.3 | 5.32e-12 | NR | RPI71492.1 | 2282154 | g168299 | i0 | 80 | 0.689655172413793 | 40 | 8 | 69 | 0 | 166 | 47 | 6 | 45 | RPI71492.1 MAG: hypothetical protein EHM38_03805 [Geobacteraceae bacterium] | diamond | 120 | 64.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacteraceae bacterium | |||
| 32305357 | 32305357 | PRJNA382357_P_NODE_124339_length_219_cov_1.974684_g123600_i0 | PRJNA382357 | 124339 | 219 | 1.974684 | 4.32455796 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 68.9 | 1.39e-11 | NR | HKZ46425.1 | 2202153 | g123600 | i0 | 75.6 | 1.86301369863014 | 45 | 11 | 61.6 | 0 | 136 | 2 | 133 | 177 | HKZ46425.1 ubiquitin-activating E1 FCCH domain-containing protein [Thermodesulfobacteriota bacterium] | diamond | 408 | 69.3 | 0.994227994227994 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 32400124 | 32400124 | PRJNA382357_P_NODE_141619_length_208_cov_0.884354_g140880_i0 | PRJNA382357 | 141619 | 208 | 0.884354 | 1.83945632 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 121 | 2.27e-31 | NR | WP_211248472.1 | 53332 | g140880 | i0 | 91.2 | 1.64423076923077 | 57 | 5 | 82.2 | 0 | 177 | 7 | 81 | 137 | WP_211248472.1 RNA-directed DNA polymerase [Desulfobulbus elongatus] | diamond | 342 | 121 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | Desulfobulbus elongatus | ||
| 32589906 | 32589906 | PRJNA382357_P_NODE_96539_length_246_cov_1.275676_g95800_i0 | PRJNA382357 | 96539 | 246 | 1.275676 | 3.13816296 | Desulfovibrio | 872 | Bacteria | Bacteria | 57 | 3.52e-7 | NR | WP_303865849.1 | 901 | g95800 | i0 | 43.9 | 2.08536585365854 | 57 | 31 | 68.3 | 1 | 11 | 178 | 234 | 290 | WP_303865849.1 hypothetical protein [Desulfovibrio piger] | diamond | 513 | 57 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio piger | ||
| 32667137 | 32667137 | PRJNA382357_P_NODE_112960_length_229_cov_2.375000_g112221_i0 | PRJNA382357 | 112960 | 229 | 2.375 | 5.43875 | Desulfohalobiaceae bacterium | 2683721 | Bacteria | Bacteria | 92.4 | 3.32e-21 | NR | MEF8824023.1 | 2683721 | g112221 | i0 | 95.7 | 0.615720524017467 | 47 | 2 | 61.6 | 0 | 87 | 227 | 1 | 47 | MEF8824023.1 L-threonylcarbamoyladenylate synthase [Desulfohalobiaceae bacterium] | diamond | 141 | 92.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfohalobiaceae bacterium | |||
| 32698696 | 32698696 | PRJNA382357_P_NODE_88980_length_255_cov_1.108247_g88241_i0 | PRJNA382357 | 88980 | 255 | 1.108247 | 2.82602985 | Desulfuromonadaceae bacterium | 2099677 | Bacteria | Bacteria | 53.5 | 6.9e-6 | NR | MDD2580852.1 | 2099677 | g88241 | i0 | 36.1 | 2.65882352941176 | 83 | 38 | 80 | 2 | 49 | 252 | 182 | 264 | MDD2580852.1 diguanylate cyclase [Desulfuromonadaceae bacterium] | diamond | 678 | 53.5 | 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);;