contig_metadata
27 rows where bioproject = "PRJNA1122875", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2828350 | 2828350 | PRJNA1122875_P_NODE_3423_length_811_cov_3.867209_g3237_i0 | PRJNA1122875 | 3423 | 811 | 3.867209 | 31.36306499 | Geotalea daltonii | 1203471 | Bacteria | Bacteria | 54.7 | 0.023 | NTclustered | gi|221562406|gb|CP001390.1| | 316067 | g3237 | i0 | 92.308 | 0.0480887792848335 | 39 | 2 | 5 | 1 | 62 | 99 | 3441075 | 3441113 | Geobacter daltonii FRC-32, complete genome | blastn | 39 | 54.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geotalea | Geotalea daltonii | ||
| 2828499 | 2828499 | PRJNA1122875_P_NODE_46223_length_248_cov_0.880000_g45999_i0 | PRJNA1122875 | 46223 | 248 | 0.88 | 2.1824 | Desulfovibrio sp. | 885 | Bacteria | Bacteria | 175 | 6.83e-53 | NR | MCX4310444.1 | 885 | g45999 | i0 | 100 | 0.991935483870968 | 82 | 0 | 99.2 | 0 | 2 | 247 | 42 | 123 | MCX4310444.1 prolipoprotein diacylglyceryl transferase [Desulfovibrio sp.] | diamond | 246 | 175 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. | ||
| 6655679 | 6655679 | PRJNA1122875_P_NODE_47226_length_247_cov_1.097701_g47002_i0 | PRJNA1122875 | 47226 | 247 | 1.097701 | 2.71132147 | Geomonas paludis | 2740185 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2233265061|gb|CP096574.1| | 2740185 | g47002 | i0 | 96.875 | 0.129554655870445 | 32 | 1 | 13 | 0 | 216 | 247 | 3521945 | 3521914 | Geomonas paludis strain RG22 chromosome, complete genome | blastn | 32 | 54.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geomonas | Geomonas paludis | ||
| 7406545 | 7406545 | PRJNA1122875_P_NODE_15206_length_428_cov_1.735211_g14982_i0 | PRJNA1122875 | 15206 | 428 | 1.735211 | 7.42670308 | Syntrophales bacterium | 2928017 | Bacteria | Bacteria | 218 | 2.78e-65 | NR | MDO8785014.1 | 2928017 | g14982 | i0 | 66.2 | 12.946261682243 | 142 | 47 | 99.5 | 1 | 426 | 1 | 280 | 420 | MDO8785014.1 phosphoenolpyruvate carboxykinase (GTP) [Syntrophales bacterium] | diamond | 5541 | 218 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophales bacterium | ||||
| 9205884 | 9205884 | PRJNA1122875_P_NODE_52768_length_242_cov_0.911243_g52544_i0 | PRJNA1122875 | 52768 | 242 | 0.911243 | 2.20520806 | Desulfobotulus sp. | 1940337 | Bacteria | Bacteria | 85.5 | 3.24e-17 | NR | WP_320353836.1 | 1940337 | g52544 | i0 | 59.1 | 0.818181818181818 | 66 | 27 | 81.8 | 0 | 241 | 44 | 410 | 475 | WP_320353836.1 acyl CoA:acetate/3-ketoacid CoA transferase [Desulfobotulus sp.] | diamond | 198 | 85.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobotulus | Desulfobotulus sp. | ||
| 20678834 | 20678834 | PRJNA1122875_P_NODE_11957_length_481_cov_1.848039_g11734_i0 | PRJNA1122875 | 11957 | 481 | 1.848039 | 8.88906759 | uncultured Syntrophus sp. | 228671 | Bacteria | Bacteria | 62.1 | 7.79e-5 | NTclustered | gi|2621703419|emb|OY762510.1| | 228671 | g11734 | i0 | 89.796 | 0.218295218295218 | 49 | 4 | 10 | 1 | 427 | 474 | 201943 | 201991 | MAG: uncultured Syntrophus sp. isolate ce8641d8-6ba7-4885-b5ca-0195441cf687 genome assembly, chromosome: 1 | blastn | 105 | 62.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophus | uncultured Syntrophus sp. | ||
| 26753301 | 26753301 | PRJNA1122875_P_NODE_54021_length_241_cov_0.916667_g53797_i0 | PRJNA1122875 | 54021 | 241 | 0.916667 | 2.20916747 | Syntrophales bacterium | 2928017 | Bacteria | Bacteria | 111 | 1.89e-26 | NR | HPN10256.1 | 2928017 | g53797 | i0 | 67.5 | 2.97510373443983 | 80 | 26 | 99.6 | 0 | 2 | 241 | 535 | 614 | HPN10256.1 nucleoside-diphosphate sugar epimerase/dehydratase [Syntrophales bacterium] | diamond | 717 | 111 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophales bacterium | ||||
| 26901318 | 26901318 | PRJNA1122875_P_NODE_14401_length_440_cov_1.040872_g14177_i0 | PRJNA1122875 | 14401 | 440 | 1.040872 | 4.5798368 | Bacteria | 2 | Bacteria | Bacteria | 136 | 2.8e-36 | NR | HAR32551.1 | 2294 | g14177 | i0 | 51.5 | 11.3795454545455 | 136 | 58 | 92.7 | 1 | 3 | 410 | 155 | 282 | HAR32551.1 3-oxosteroid 1-dehydrogenase [Desulfobacter sp.] | diamond | 5007 | 137 | 0.992700729927007 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacter | Desulfobacter sp. | ||
| 26995843 | 26995843 | PRJNA1122875_P_NODE_41102_length_258_cov_1.248649_g40878_i0 | PRJNA1122875 | 41102 | 258 | 1.248649 | 3.22151442 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 89.4 | 1.81e-18 | NR | WP_084554044.1 | 231440 | g40878 | i0 | 50 | 3.01162790697674 | 86 | 43 | 100 | 0 | 1 | 258 | 69 | 154 | WP_084554044.1 NAD-dependent malic enzyme [Desulfopila aestuarii] | diamond | 777 | 89.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfocapsaceae | Desulfopila | Desulfopila aestuarii | ||
| 27228035 | 27228035 | PRJNA1122875_P_NODE_10763_length_506_cov_1.602771_g10542_i0 | PRJNA1122875 | 10763 | 506 | 1.602771 | 8.11002126 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 94.7 | 1.62e-19 | NR | MCU0563932.1 | 2044940 | g10542 | i0 | 37 | 0.960474308300395 | 162 | 96 | 94.3 | 2 | 505 | 29 | 187 | 345 | MCU0563932.1 carboxypeptidase regulatory-like domain-containing protein [Desulfobacterales bacterium] | diamond | 486 | 94.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 27280717 | 27280717 | PRJNA1122875_P_NODE_39423_length_264_cov_1.612565_g39199_i0 | PRJNA1122875 | 39423 | 264 | 1.612565 | 4.2571716 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 61.2 | 5.71e-9 | NR | WP_011939322.1 | 351604 | g39199 | i0 | 44 | 2.93181818181818 | 84 | 45 | 93.2 | 1 | 260 | 15 | 41 | 124 | WP_011939322.1 protease inhibitor I42 family protein [Geotalea uraniireducens] | diamond | 774 | 61.6 | 0.993506493506494 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geotalea | Geotalea uraniireducens | ||
| 27480918 | 27480918 | PRJNA1122875_P_NODE_25483_length_328_cov_1.996078_g25259_i0 | PRJNA1122875 | 25483 | 328 | 1.996078 | 6.54713584 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 45.8 | 0.00841 | NR | MCP4020984.1 | 2049433 | g25259 | i0 | 52.5 | 0.365853658536585 | 40 | 18 | 36.6 | 1 | 30 | 149 | 2016 | 2054 | MCP4020984.1 amino acid adenylation domain-containing protein [Desulfobacteraceae bacterium] | diamond | 120 | 45.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 27891257 | 27891257 | PRJNA1122875_P_NODE_21625_length_357_cov_1.292254_g21401_i0 | PRJNA1122875 | 21625 | 357 | 1.292254 | 4.61334678 | Desulfobacula sp. | 2593537 | Bacteria | Bacteria | 45.4 | 0.0149 | NR | MCP4673026.1 | 2593537 | g21401 | i0 | 26.2 | 1.09243697478992 | 130 | 79 | 98.3 | 3 | 4 | 354 | 223 | 348 | MCP4673026.1 DUF3418 domain-containing protein [Desulfobacula sp.] | diamond | 390 | 45.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacula | Desulfobacula sp. | ||
| 28385797 | 28385797 | PRJNA1122875_P_NODE_43806_length_251_cov_0.865169_g43582_i0 | PRJNA1122875 | 43806 | 251 | 0.865169 | 2.17157419 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 86.3 | 8.87e-18 | NR | MCL6622620.1 | 2282155 | g43582 | i0 | 62 | 5.33067729083665 | 71 | 27 | 84.9 | 0 | 230 | 18 | 135 | 205 | MCL6622620.1 NAD(P)-dependent glycerol-3-phosphate dehydrogenase [Syntrophobacterales bacterium] | diamond | 1338 | 86.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacterales bacterium | ||||
| 28512104 | 28512104 | PRJNA1122875_P_NODE_13387_length_455_cov_2.183246_g13163_i0 | PRJNA1122875 | 13387 | 455 | 2.183246 | 9.9337693 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 219 | 1.6299999999999998e-66 | NR | WP_072906653.1 | 57040 | g13163 | i0 | 65.1 | 5.75604395604396 | 146 | 51 | 96.3 | 0 | 442 | 5 | 314 | 459 | WP_072906653.1 asparagine--tRNA ligase [Malonomonas rubra] | diamond | 2619 | 220 | 0.995454545454545 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Geopsychrobacteraceae | Malonomonas | Malonomonas rubra | ||
| 28554622 | 28554622 | PRJNA1122875_P_NODE_28087_length_310_cov_1.949367_g27863_i0 | PRJNA1122875 | 28087 | 310 | 1.949367 | 6.0430377 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 78.6 | 7.28e-15 | NR | MFC1858079.1 | 2202153 | g27863 | i0 | 44.7 | 0.909677419354839 | 94 | 51 | 90 | 1 | 300 | 22 | 133 | 226 | MFC1858079.1 hypothetical protein [Thermodesulfobacteriota bacterium] | diamond | 282 | 78.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 29028360 | 29028360 | PRJNA1122875_P_NODE_2768_length_871_cov_1.922306_g2602_i0 | PRJNA1122875 | 2768 | 871 | 1.922306 | 16.74328526 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 158 | 1.83e-39 | NR | MBF0100972.1 | 2044940 | g2602 | i0 | 34.9 | 0.936854190585534 | 272 | 169 | 91.6 | 4 | 868 | 71 | 467 | 736 | MBF0100972.1 carbohydrate-binding protein [Desulfobacterales bacterium] | diamond | 816 | 158 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 29248957 | 29248957 | PRJNA1122875_P_NODE_25549_length_328_cov_1.196078_g25325_i0 | PRJNA1122875 | 25549 | 328 | 1.196078 | 3.92313584 | Syntrophales bacterium | 2928017 | Bacteria | Bacteria | 64.7 | 1.94e-10 | NR | HLE16848.1 | 2928017 | g25325 | i0 | 45.2 | 1.66463414634146 | 62 | 34 | 56.7 | 0 | 5 | 190 | 79 | 140 | HLE16848.1 Hsp20/alpha crystallin family protein [Syntrophales bacterium] | diamond | 546 | 64.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophales bacterium | ||||
| 30512398 | 30512398 | PRJNA1122875_P_NODE_10413_length_513_cov_2.518182_g10193_i0 | PRJNA1122875 | 10413 | 513 | 2.518182 | 12.91827366 | Desulfarculaceae bacterium | 2528248 | Bacteria | Bacteria | 65.5 | 5.85e-10 | NR | MCF8043161.1 | 2528248 | g10193 | i0 | 40.4 | 2.12280701754386 | 94 | 51 | 55 | 2 | 106 | 387 | 52 | 140 | MCF8043161.1 Hsp20/alpha crystallin family protein [Desulfarculaceae bacterium] | diamond | 1089 | 65.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Desulfarculales | Desulfarculaceae | Desulfarculaceae bacterium | |||
| 30627878 | 30627878 | PRJNA1122875_P_NODE_46793_length_248_cov_0.880000_g46569_i0 | PRJNA1122875 | 46793 | 248 | 0.88 | 2.1824 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 98.6 | 1.0699999999999997e-23 | NR | MDB4303473.1 | 2027861 | g46569 | i0 | 63.5 | 2.72177419354839 | 74 | 27 | 89.5 | 0 | 225 | 4 | 101 | 174 | MDB4303473.1 AAA family ATPase [Desulfosarcina sp.] | diamond | 675 | 99.4 | 0.991951710261569 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosarcinaceae | Desulfosarcina | Desulfosarcina sp. | ||
| 30670352 | 30670352 | PRJNA1122875_P_NODE_12173_length_477_cov_1.641089_g11950_i0 | PRJNA1122875 | 12173 | 477 | 1.641089 | 7.82799453 | Desulfobacca sp. | 2067990 | Bacteria | Bacteria | 55.1 | 1.44e-5 | NR | MDD3580436.1 | 2067990 | g11950 | i0 | 48 | 1.0125786163522 | 50 | 21 | 31.4 | 1 | 435 | 286 | 226 | 270 | MDD3580436.1 archaemetzincin [Desulfobacca sp.] | diamond | 483 | 55.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobaccia | Desulfobaccales | Desulfobaccaceae | Desulfobacca | Desulfobacca sp. | ||
| 30670369 | 30670369 | PRJNA1122875_P_NODE_23673_length_342_cov_1.568773_g23449_i0 | PRJNA1122875 | 23673 | 342 | 1.568773 | 5.36520366 | Desulfovibrio aminophilus | 81425 | Bacteria | Bacteria | 112 | 2.9e-26 | NR | WP_027176993.1 | 81425 | g23449 | i0 | 72.4 | 4.01754385964912 | 76 | 21 | 66.7 | 0 | 111 | 338 | 1 | 76 | WP_027176993.1 hydroxylamine reductase [Desulfovibrio aminophilus] | diamond | 1374 | 112 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio aminophilus | ||
| 30817675 | 30817675 | PRJNA1122875_P_NODE_43334_length_251_cov_0.865169_g43110_i0 | PRJNA1122875 | 43334 | 251 | 0.865169 | 2.17157419 | FCB group | 1783270 | Bacteria | Bacteria | 43.1 | 0.0182 | NR | RUM88750.1 | 1874629 | g43110 | i0 | 37.5 | 3.76494023904382 | 56 | 34 | 65.7 | 1 | 4 | 168 | 103 | 158 | RUM88750.1 MAG: peptide deformylase [Thermodesulfatator sp.] | diamond | 945 | 43.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteria | Thermodesulfobacteriales | Thermodesulfatatoraceae | Thermodesulfatator | Thermodesulfatator sp. | ||
| 30860063 | 30860063 | PRJNA1122875_P_NODE_6114_length_644_cov_1.562172_g5900_i0 | PRJNA1122875 | 6114 | 644 | 1.562172 | 10.06038768 | Desulfarculaceae bacterium | 2528248 | Bacteria | Bacteria | 72.4 | 3.32e-11 | NR | MCB2228602.1 | 2528248 | g5900 | i0 | 25.5 | 0.93167701863354 | 200 | 115 | 92.7 | 7 | 47 | 643 | 59 | 225 | MCB2228602.1 hypothetical protein [Desulfarculaceae bacterium] | diamond | 600 | 72.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Desulfarculales | Desulfarculaceae | Desulfarculaceae bacterium | |||
| 30955062 | 30955062 | PRJNA1122875_P_NODE_53954_length_241_cov_0.916667_g53730_i0 | PRJNA1122875 | 53954 | 241 | 0.916667 | 2.20916747 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 132 | 7.519999999999998e-35 | NR | MDJ0669282.1 | 2044940 | g53730 | i0 | 82.5 | 0.995850622406639 | 80 | 14 | 99.6 | 0 | 2 | 241 | 112 | 191 | MDJ0669282.1 2-isopropylmalate synthase [Desulfobacterales bacterium] | diamond | 240 | 132 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 31039136 | 31039136 | PRJNA1122875_P_NODE_6315_length_635_cov_3.222420_g6099_i0 | PRJNA1122875 | 6315 | 635 | 3.22242 | 20.462367 | Bacteria | 2 | Bacteria | Bacteria | 80.9 | 8.85e-14 | NR | WP_254278414.1 | 35554 | g6099 | i0 | 28.4 | 1.79055118110236 | 169 | 113 | 76.1 | 2 | 545 | 63 | 170 | 338 | WP_254278414.1 ammonium transporter [Geobacter sulfurreducens] | diamond | 1137 | 80.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sulfurreducens | ||
| 32346697 | 32346697 | PRJNA1122875_P_NODE_46699_length_248_cov_0.880000_g46475_i0 | PRJNA1122875 | 46699 | 248 | 0.88 | 2.1824 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 70.5 | 2.44e-13 | NR | MBC2734148.1 | 2049433 | g46475 | i0 | 47.8 | 0.810483870967742 | 67 | 34 | 81 | 1 | 246 | 46 | 59 | 124 | MBC2734148.1 hypothetical protein [Desulfobacteraceae bacterium] | diamond | 201 | 70.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae 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);;