contig_metadata
20 rows where bioproject = "PRJNA494251", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2382498 | 2382498 | PRJNA494251_P_NODE_6622_length_505_cov_1.777778_g6321_i0 | PRJNA494251 | 6622 | 505 | 1.777778 | 8.9777789 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 121 | 1.33e-22 | NTclustered | gi|2007135636|gb|CP061800.1| | 45655 | g6321 | i0 | 75.385 | 17.5465346534653 | 260 | 58 | 51 | 6 | 249 | 505 | 7420126 | 7420382 | Desulfonema magnum strain 4be13 chromosome, complete genome | blastn | 8861 | 121 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfococcaceae | Desulfonema | Desulfonema magnum | ||
| 10035351 | 10035351 | PRJNA494251_P_NODE_32008_length_265_cov_1.515625_g31694_i0 | PRJNA494251 | 32008 | 265 | 1.515625 | 4.01640625 | Bacteria | 2 | Bacteria | Bacteria | 169 | 1.15e-49 | NR | OGE23203.1 | 1797756 | g31694 | i0 | 94.3 | 2.98867924528302 | 88 | 5 | 99.6 | 0 | 1 | 264 | 17 | 104 | OGE23203.1 MAG: quinolinate synthase [Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21] | diamond | 792 | 169 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21 | |||||
| 14503876 | 14503876 | PRJNA494251_P_NODE_15252_length_355_cov_1.893617_g14939_i0 | PRJNA494251 | 15252 | 355 | 1.893617 | 6.72234035 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 96.7 | 1.02e-21 | NR | WP_092215278.1 | 419481 | g14939 | i0 | 48.1 | 8.03661971830986 | 106 | 50 | 87.9 | 2 | 42 | 353 | 135 | 237 | WP_092215278.1 triose-phosphate isomerase [Desulfoluna spongiiphila] | diamond | 2853 | 97.1 | 0.995880535530381 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfolunaceae | Desulfoluna | Desulfoluna spongiiphila | ||
| 14504156 | 14504156 | PRJNA494251_P_NODE_38072_length_250_cov_0.870056_g37758_i0 | PRJNA494251 | 38072 | 250 | 0.870056 | 2.17514 | Desulfuromonas sp. DDH964 | 1823759 | Bacteria | Bacteria | 91.6 | 4.8e-14 | NTclustered | gi|1015516084|gb|CP015080.1| | 1823759 | g37758 | i0 | 100 | 20.708 | 49 | 0 | 20 | 0 | 202 | 250 | 2882299 | 2882347 | Desulfuromonas sp. DDH964 chromosome, complete genome | blastn | 5177 | 91.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. DDH964 | ||
| 23427929 | 23427929 | PRJNA494251_P_NODE_47559_length_242_cov_7.426036_g47245_i0 | PRJNA494251 | 47559 | 242 | 7.426036 | 17.97100712 | Desulfosarcina widdelii | 947919 | Bacteria | Bacteria | 147 | 9.72e-31 | NTclustered | gi|1773416083|dbj|AP021875.1| | 947919 | g47245 | i0 | 89.167 | 83.698347107438 | 120 | 10 | 49 | 3 | 33 | 151 | 6916258 | 6916375 | Desulfosarcina widdelii PP31 DNA, complete genome | blastn | 20255 | 147 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosarcinaceae | Desulfosarcina | Desulfosarcina widdelii | ||
| 26807785 | 26807785 | PRJNA494251_P_NODE_19701_length_319_cov_1.869919_g19387_i0 | PRJNA494251 | 19701 | 319 | 1.869919 | 5.96504161 | Bacteria | 2 | Bacteria | Bacteria | 51.2 | 2.33e-5 | NR | HKJ04526.1 | 3065857 | g19387 | i0 | 35.9 | 1.97492163009404 | 78 | 46 | 72.4 | 2 | 317 | 87 | 67 | 141 | HKJ04526.1 Hsp20/alpha crystallin family protein [Geopsychrobacteraceae bacterium] | diamond | 630 | 51.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Geopsychrobacteraceae | Geopsychrobacteraceae bacterium | |||
| 26887303 | 26887303 | PRJNA494251_P_NODE_36381_length_252_cov_1.441341_g36067_i0 | PRJNA494251 | 36381 | 252 | 1.441341 | 3.63217932 | Desulfoplanes formicivorans | 1592317 | Bacteria | Bacteria | 44.7 | 0.00863 | NR | WP_069859250.1 | 1592317 | g36067 | i0 | 43.9 | 0.488095238095238 | 41 | 23 | 48.8 | 0 | 101 | 223 | 112 | 152 | WP_069859250.1 AsmA family protein [Desulfoplanes formicivorans] | diamond | 123 | 44.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfoplanaceae | Desulfoplanes | Desulfoplanes formicivorans | ||
| 27045311 | 27045311 | PRJNA494251_P_NODE_12862_length_380_cov_1.954397_g12554_i0 | PRJNA494251 | 12862 | 380 | 1.954397 | 7.4267086 | Desulfamplus sp. | 2006184 | Bacteria | Bacteria | 89 | 1.99e-20 | NR | MBF0379354.1 | 2006184 | g12554 | i0 | 84 | 1.17631578947368 | 50 | 8 | 39.5 | 0 | 41 | 190 | 30 | 79 | MBF0379354.1 porin [Desulfamplus sp.] | diamond | 447 | 89 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfamplus | Desulfamplus sp. | ||
| 28213663 | 28213663 | PRJNA494251_P_NODE_33586_length_260_cov_1.647059_g33272_i0 | PRJNA494251 | 33586 | 260 | 1.647059 | 4.2823534 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 52 | 2.19e-5 | NR | MEE8382216.1 | 2202153 | g33272 | i0 | 35.7 | 0.969230769230769 | 84 | 53 | 95.8 | 1 | 259 | 11 | 121 | 204 | MEE8382216.1 hypothetical protein [Thermodesulfobacteriota bacterium] | diamond | 252 | 52 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 29397749 | 29397749 | PRJNA494251_P_NODE_48329_length_242_cov_0.911243_g48015_i0 | PRJNA494251 | 48329 | 242 | 0.911243 | 2.20520806 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 128 | 5.36e-33 | NR | WP_014259438.1 | 873 | g48015 | i0 | 73.4 | 8.85123966942149 | 79 | 21 | 97.9 | 0 | 242 | 6 | 42 | 120 | WP_014259438.1 adenosylhomocysteinase [Desulfocurvibacter africanus] | diamond | 2142 | 129 | 0.992248062015504 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfocurvibacter | Desulfocurvibacter africanus | ||
| 29634374 | 29634374 | PRJNA494251_P_NODE_36590_length_251_cov_2.039326_g36276_i0 | PRJNA494251 | 36590 | 251 | 2.039326 | 5.11870826 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 135 | 9.2e-39 | NR | GJM17744.1 | 2202153 | g36276 | i0 | 79.5 | 1.9840637450199201 | 83 | 17 | 99.2 | 0 | 250 | 2 | 19 | 101 | GJM17744.1 MAG: hypothetical protein DHS20C13_30710 [Thermodesulfobacteriota bacterium] | diamond | 498 | 135 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 29919080 | 29919080 | PRJNA494251_P_NODE_19851_length_318_cov_1.857143_g19537_i0 | PRJNA494251 | 19851 | 318 | 1.857143 | 5.90571474 | Syntrophorhabdus sp. PtaU1.Bin153 | 1811705 | Bacteria | Bacteria | 98.2 | 4.179999999999999e-23 | NR | OPY80869.1 | 1811705 | g19537 | i0 | 50.5 | 3.58490566037736 | 95 | 46 | 89.6 | 1 | 316 | 32 | 92 | 185 | OPY80869.1 MAG: heat shock protein GrpE [Syntrophorhabdus sp. PtaU1.Bin153] | diamond | 1140 | 98.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophorhabdia | Syntrophorhabdales | Syntrophorhabdaceae | Syntrophorhabdus | Syntrophorhabdus sp. PtaU1.Bin153 | ||
| 30013839 | 30013839 | PRJNA494251_P_NODE_42711_length_246_cov_1.352601_g42397_i0 | PRJNA494251 | 42711 | 246 | 1.352601 | 3.32739846 | Syntrophales bacterium | 2928017 | Bacteria | Bacteria | 63.5 | 1.7e-9 | NR | HET6490911.1 | 2928017 | g42397 | i0 | 46.9 | 0.780487804878049 | 64 | 33 | 78 | 1 | 238 | 47 | 132 | 194 | HET6490911.1 C1 family peptidase [Syntrophales bacterium] | diamond | 192 | 63.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophales bacterium | ||||
| 30424907 | 30424907 | PRJNA494251_P_NODE_22653_length_302_cov_1.746725_g22339_i0 | PRJNA494251 | 22653 | 302 | 1.746725 | 5.2751095 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 73.2 | 4.6e-14 | NR | MEW5914649.1 | 2202153 | g22339 | i0 | 38.6 | 2.80132450331126 | 88 | 48 | 87.4 | 1 | 298 | 35 | 35 | 116 | MEW5914649.1 protease inhibitor I42 family protein [Thermodesulfobacteriota bacterium] | diamond | 846 | 73.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 31245968 | 31245968 | PRJNA494251_P_NODE_38235_length_250_cov_0.870056_g37921_i0 | PRJNA494251 | 38235 | 250 | 0.870056 | 2.17514 | Desulfatiglans sp. | 1969697 | Bacteria | Bacteria | 147 | 1.4199999999999999e-42 | NR | NLD38355.1 | 1969697 | g37921 | i0 | 85.4 | 0.984 | 82 | 12 | 98.4 | 0 | 3 | 248 | 31 | 112 | NLD38355.1 class I SAM-dependent methyltransferase [Desulfatiglans sp.] | diamond | 246 | 147 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfatiglandales | Desulfatiglandaceae | Desulfatiglans | Desulfatiglans sp. | ||
| 31309196 | 31309196 | PRJNA494251_P_NODE_46615_length_243_cov_1.070588_g46301_i0 | PRJNA494251 | 46615 | 243 | 1.070588 | 2.60152884 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 50.8 | 5.06e-5 | NR | MFC1834884.1 | 2202153 | g46301 | i0 | 31.3 | 1.76543209876543 | 80 | 50 | 97.5 | 2 | 6 | 242 | 30 | 105 | MFC1834884.1 hypothetical protein [Thermodesulfobacteriota bacterium] | diamond | 429 | 50.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 31467565 | 31467565 | PRJNA494251_P_NODE_15296_length_355_cov_1.088652_g14983_i0 | PRJNA494251 | 15296 | 355 | 1.088652 | 3.8647146 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 56.6 | 8.35e-7 | NR | GJM17643.1 | 2202153 | g14983 | i0 | 39.2 | 0.667605633802817 | 79 | 47 | 65.9 | 1 | 89 | 322 | 134 | 212 | GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] | diamond | 237 | 56.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 32448380 | 32448380 | PRJNA494251_P_NODE_34439_length_257_cov_6.010870_g34125_i0 | PRJNA494251 | 34439 | 257 | 6.01087 | 15.4479359 | Desulfosediminicola flagellatus | 2569541 | Bacteria | Bacteria | 48.5 | 3.97e-4 | NR | WP_136805682.1 | 2569541 | g34125 | i0 | 59.4 | 0.373540856031128 | 32 | 10 | 37.4 | 1 | 256 | 161 | 468 | 496 | WP_136805682.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Desulfosediminicola flagellatus] | diamond | 96 | 48.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfocapsaceae | Desulfosediminicola | Desulfosediminicola flagellatus | ||
| 32543280 | 32543280 | PRJNA494251_P_NODE_7339_length_483_cov_1.482927_g7036_i0 | PRJNA494251 | 7339 | 483 | 1.482927 | 7.16253741 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 94.7 | 1.62e-19 | NR | MBF0226922.1 | 2044940 | g7036 | i0 | 36.8 | 0.962732919254658 | 155 | 90 | 91.3 | 2 | 30 | 470 | 109 | 263 | MBF0226922.1 sulfotransferase domain-containing protein [Desulfobacterales bacterium] | diamond | 465 | 94.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 32763547 | 32763547 | PRJNA494251_P_NODE_49200_length_241_cov_1.119048_g48886_i0 | PRJNA494251 | 49200 | 241 | 1.119048 | 2.69690568 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 52.8 | 8.04e-7 | NR | GJM17551.1 | 2202153 | g48886 | i0 | 37.7 | 0.759336099585062 | 61 | 38 | 75.9 | 0 | 21 | 203 | 14 | 74 | GJM17551.1 MAG: hypothetical protein DHS20C13_28780 [Thermodesulfobacteriota bacterium] | diamond | 183 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota 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);;