contig_metadata
26 rows where bioproject = "PRJNA715462", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 706289 | 706289 | PRJNA715462_P_NODE_57361_length_247_cov_1.729885_g56565_i0 | PRJNA715462 | 57361 | 247 | 1.729885 | 4.27281595 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 112 | 8.37e-30 | NR | GJM17742.1 | 2202153 | g56565 | i0 | 72 | 0.995951417004049 | 82 | 18 | 99.6 | 1 | 2 | 247 | 12 | 88 | GJM17742.1 MAG: hypothetical protein DHS20C13_30690 [Thermodesulfobacteriota bacterium] | diamond | 246 | 112 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 1982367 | 1982367 | PRJNA715462_P_NODE_62442_length_245_cov_0.895349_g61646_i0 | PRJNA715462 | 62442 | 245 | 0.895349 | 2.19360505 | Bacteria | 2 | Bacteria | Bacteria | 118 | 1.79e-30 | NR | OQX20245.1 | 1934250 | g61646 | i0 | 71.6 | 5.95102040816327 | 81 | 23 | 99.2 | 0 | 244 | 2 | 34 | 114 | OQX20245.1 MAG: polyphosphate kinase 2 [Desulfobulbaceae bacterium A2] | diamond | 1458 | 119 | 0.991596638655462 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbaceae bacterium A2 | |||
| 3743981 | 3743981 | PRJNA715462_P_NODE_42803_length_272_cov_1.924623_g42007_i0 | PRJNA715462 | 42803 | 272 | 1.924623 | 5.23497456 | Geobacter | 28231 | Bacteria | Bacteria | 52.8 | 0.025 | NTclustered | gi|779731694|gb|CP010430.1| | 35554 | g42007 | i0 | 100 | 0.617647058823529 | 28 | 0 | 10 | 0 | 204 | 231 | 2130121 | 2130148 | Geobacter sulfurreducens strain AM-1 genome | blastn | 168 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sulfurreducens | ||
| 4534080 | 4534080 | PRJNA715462_P_NODE_29804_length_327_cov_1.212598_g29008_i0 | PRJNA715462 | 29804 | 327 | 1.212598 | 3.96519546 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 54.7 | 0.009 | NTclustered | gi|2621701778|emb|OY759308.1| | 2044940 | g29008 | i0 | 100 | 0.174311926605505 | 29 | 0 | 9 | 0 | 41 | 69 | 511667 | 511695 | MAG: Desulfobacterales bacterium isolate 4b48c405-a8b0-44ce-a896-9916d3c4254b genome assembly, chromosome: 1 | blastn | 57 | 54.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 26745590 | 26745590 | PRJNA715462_P_NODE_56301_length_248_cov_0.880000_g55505_i0 | PRJNA715462 | 56301 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 75.5 | 1.13e-13 | NR | MDZ7832195.1 | 2044940 | g55505 | i0 | 63.6 | 5.79435483870968 | 55 | 18 | 66.5 | 1 | 81 | 245 | 1 | 53 | MDZ7832195.1 glycerol kinase GlpK [Desulfobacterales bacterium] | diamond | 1437 | 75.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 27399734 | 27399734 | PRJNA715462_P_NODE_2443_length_1692_cov_2.154416_g2074_i0 | PRJNA715462 | 2443 | 1692 | 2.154416 | 36.45271872 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 51.2 | 0.00342 | NR | GJM17643.1 | 2202153 | g2074 | i0 | 24.1 | 0.404255319148936 | 228 | 144 | 38.7 | 9 | 747 | 94 | 4 | 212 | GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] | diamond | 684 | 51.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 27494392 | 27494392 | PRJNA715462_P_NODE_68423_length_241_cov_0.916667_g67627_i0 | PRJNA715462 | 68423 | 241 | 0.916667 | 2.20916747 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 59.3 | 1.49e-9 | NR | MCP3922521.1 | 2044940 | g67627 | i0 | 46.7 | 0.746887966804979 | 60 | 31 | 74.7 | 1 | 24 | 203 | 9 | 67 | MCP3922521.1 hypothetical protein [Desulfobacterales bacterium] | diamond | 180 | 59.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 27810246 | 27810246 | PRJNA715462_P_NODE_35064_length_298_cov_1.711111_g34268_i0 | PRJNA715462 | 35064 | 298 | 1.711111 | 5.09911078 | Candidatus Magnetomorum sp. HK-1 | 1509431 | Bacteria | Bacteria | 43.9 | 0.0124 | NR | KPA15116.1 | 1509431 | g34268 | i0 | 36.1 | 0.36241610738255 | 36 | 23 | 36.2 | 0 | 9 | 116 | 8 | 43 | KPA15116.1 prenyltransferase, partial [Candidatus Magnetomorum sp. HK-1] | diamond | 108 | 43.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Candidatus Magnetomoraceae | Candidatus Magnetomorum | Candidatus Magnetomorum sp. HK-1 | ||
| 28220336 | 28220336 | PRJNA715462_P_NODE_47126_length_260_cov_1.385027_g46330_i0 | PRJNA715462 | 47126 | 260 | 1.385027 | 3.6010702 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 110 | 9.49e-26 | NR | NNG00607.1 | 2049433 | g46330 | i0 | 58.3 | 0.969230769230769 | 84 | 34 | 96.9 | 1 | 256 | 5 | 938 | 1020 | NNG00607.1 hypothetical protein [Desulfobacteraceae bacterium] | diamond | 252 | 110 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 28283426 | 28283426 | PRJNA715462_P_NODE_40006_length_281_cov_1.283654_g39210_i0 | PRJNA715462 | 40006 | 281 | 1.283654 | 3.60706774 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 60.1 | 4.3e-8 | NR | MFC1844185.1 | 2202153 | g39210 | i0 | 46.3 | 0.715302491103203 | 67 | 29 | 71.5 | 1 | 78 | 278 | 209 | 268 | MFC1844185.1 DHHA2 domain-containing protein [Thermodesulfobacteriota bacterium] | diamond | 201 | 60.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 28346790 | 28346790 | PRJNA715462_P_NODE_47626_length_259_cov_0.860215_g46830_i0 | PRJNA715462 | 47626 | 259 | 0.860215 | 2.22795685 | Syntrophaceae bacterium | 2052184 | Bacteria | Bacteria | 47 | 0.00109 | NR | MEN6466244.1 | 2052184 | g46830 | i0 | 30.6 | 0.833976833976834 | 72 | 50 | 83.4 | 0 | 29 | 244 | 51 | 122 | MEN6466244.1 PEP-CTERM sorting domain-containing protein [Syntrophaceae bacterium] | diamond | 216 | 47 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophaceae bacterium | |||
| 28662693 | 28662693 | PRJNA715462_P_NODE_58807_length_247_cov_0.885057_g58011_i0 | PRJNA715462 | 58807 | 247 | 0.885057 | 2.18609079 | Desulfomonilaceae bacterium | 3034167 | Bacteria | Bacteria | 45.1 | 0.00606 | NR | HTY25060.1 | 3034167 | g58011 | i0 | 40 | 0.728744939271255 | 60 | 31 | 72.9 | 1 | 184 | 5 | 577 | 631 | HTY25060.1 3-hydroxyacyl-CoA dehydrogenase NAD-binding domain-containing protein [Desulfomonilaceae bacterium] | diamond | 180 | 45.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfomonilia | Desulfomonilales | Desulfomonilaceae | Desulfomonilaceae bacterium | |||
| 28757208 | 28757208 | PRJNA715462_P_NODE_61027_length_245_cov_1.372093_g60231_i0 | PRJNA715462 | 61027 | 245 | 1.372093 | 3.36162785 | Desulfovibrionales bacterium | 2448050 | Bacteria | Bacteria | 48.5 | 1.08e-4 | NR | MFP4315930.1 | 2448050 | g60231 | i0 | 36.9 | 0.795918367346939 | 65 | 39 | 79.6 | 2 | 37 | 231 | 58 | 120 | MFP4315930.1 universal stress protein [Desulfovibrionales bacterium] | diamond | 195 | 48.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionales bacterium | ||||
| 28788680 | 28788680 | PRJNA715462_P_NODE_31687_length_316_cov_1.267490_g30891_i0 | PRJNA715462 | 31687 | 316 | 1.26749 | 4.0052684 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 48.5 | 8.12e-4 | NR | HAO22905.1 | 2049433 | g30891 | i0 | 26 | 0.911392405063291 | 96 | 68 | 88.3 | 1 | 1 | 279 | 441 | 536 | HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] | diamond | 288 | 48.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 29104751 | 29104751 | PRJNA715462_P_NODE_64808_length_243_cov_0.905882_g64012_i0 | PRJNA715462 | 64808 | 243 | 0.905882 | 2.20129326 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 56.6 | 4.69e-7 | NR | MCP3875986.1 | 2049433 | g64012 | i0 | 43.2 | 1.74074074074074 | 74 | 34 | 82.7 | 2 | 3 | 203 | 504 | 576 | MCP3875986.1 reverse transcriptase family protein [Desulfobacteraceae bacterium] | diamond | 423 | 56.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 29357267 | 29357267 | PRJNA715462_P_NODE_47689_length_258_cov_1.989189_g46893_i0 | PRJNA715462 | 47689 | 258 | 1.989189 | 5.13210762 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 42.4 | 0.0128 | NR | MFQ5843315.1 | 2202153 | g46893 | i0 | 32.7 | 0.604651162790698 | 52 | 33 | 58.1 | 1 | 62 | 211 | 10 | 61 | MFQ5843315.1 hypothetical protein [Thermodesulfobacteriota bacterium] | diamond | 156 | 42.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 29357270 | 29357270 | PRJNA715462_P_NODE_51589_length_251_cov_0.865169_g50793_i0 | PRJNA715462 | 51589 | 251 | 0.865169 | 2.17157419 | Desulfonema ishimotonii | 45657 | Bacteria | Bacteria | 114 | 3.6800000000000005e-27 | NR | WP_124328343.1 | 45657 | g50793 | i0 | 63.8 | 1.91235059760956 | 80 | 29 | 95.6 | 0 | 246 | 7 | 82 | 161 | WP_124328343.1 alpha/beta hydrolase family esterase [Desulfonema ishimotonii] | diamond | 480 | 114 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfococcaceae | Desulfonema | Desulfonema ishimotonii | ||
| 29809662 | 29809662 | PRJNA715462_P_NODE_61691_length_245_cov_0.895349_g60895_i0 | PRJNA715462 | 61691 | 245 | 0.895349 | 2.19360505 | Desulfocurvus | 700595 | Bacteria | Bacteria | 51.6 | 2.77e-5 | NR | WP_245588475.1 | 399548 | g60895 | i0 | 67.6 | 1.2734693877551 | 34 | 11 | 41.6 | 0 | 138 | 239 | 30 | 63 | WP_245588475.1 diaminopimelate decarboxylase [Desulfocurvus vexinensis] | diamond | 312 | 51.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfocurvus | Desulfocurvus vexinensis | ||
| 29988799 | 29988799 | PRJNA715462_P_NODE_58131_length_247_cov_0.885057_g57335_i0 | PRJNA715462 | 58131 | 247 | 0.885057 | 2.18609079 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 77.4 | 2.45e-14 | NR | MCU0559980.1 | 2044940 | g57335 | i0 | 47.5 | 1.96761133603239 | 80 | 38 | 97.2 | 1 | 240 | 1 | 42 | 117 | MCU0559980.1 3-hydroxyacyl-CoA dehydrogenase NAD-binding domain-containing protein [Desulfobacterales bacterium] | diamond | 486 | 77.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 30178245 | 30178245 | PRJNA715462_P_NODE_51932_length_250_cov_1.740113_g51136_i0 | PRJNA715462 | 51932 | 250 | 1.740113 | 4.3502825 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 45.1 | 0.00594 | NR | MCG8638584.1 | 2044940 | g51136 | i0 | 33.8 | 0.96 | 80 | 48 | 92.4 | 2 | 232 | 2 | 15 | 92 | MCG8638584.1 NAD-dependent epimerase/dehydratase family protein [Desulfobacterales bacterium] | diamond | 240 | 45.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 31442386 | 31442386 | PRJNA715462_P_NODE_47156_length_260_cov_1.267380_g46360_i0 | PRJNA715462 | 47156 | 260 | 1.26738 | 3.295188 | Solidesulfovibrio aerotolerans | 295255 | Bacteria | Bacteria | 42.7 | 0.0442 | NR | WP_160962005.1 | 295255 | g46360 | i0 | 33.8 | 0.923076923076923 | 80 | 41 | 78.5 | 3 | 49 | 252 | 206 | 285 | WP_160962005.1 acyltransferase family protein [Solidesulfovibrio aerotolerans] | diamond | 240 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Solidesulfovibrio | Solidesulfovibrio aerotolerans | ||
| 31474139 | 31474139 | PRJNA715462_P_NODE_27136_length_345_cov_1.077206_g26340_i0 | PRJNA715462 | 27136 | 345 | 1.077206 | 3.7163607 | Desulfovermiculus sp. | 2821143 | Bacteria | Bacteria | 55.1 | 2.23e-7 | NR | MFO7876311.1 | 2821143 | g26340 | i0 | 65.2 | 0.4 | 46 | 14 | 40 | 1 | 102 | 239 | 24 | 67 | MFO7876311.1 hypothetical protein [Desulfovermiculus sp.] | diamond | 138 | 55.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfovermiculus | Desulfovermiculus sp. | ||
| 31853495 | 31853495 | PRJNA715462_P_NODE_48117_length_257_cov_1.652174_g47321_i0 | PRJNA715462 | 48117 | 257 | 1.652174 | 4.24608718 | Desulfamplus sp. | 2006184 | Bacteria | Bacteria | 43.9 | 0.0179 | NR | MBF0413228.1 | 2006184 | g47321 | i0 | 35.2 | 0.630350194552529 | 54 | 35 | 63 | 0 | 59 | 220 | 1013 | 1066 | MBF0413228.1 filamentous hemagglutinin N-terminal domain-containing protein [Desulfamplus sp.] | diamond | 162 | 43.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfamplus | Desulfamplus sp. | ||
| 32360113 | 32360113 | PRJNA715462_P_NODE_44019_length_269_cov_1.321429_g43223_i0 | PRJNA715462 | 44019 | 269 | 1.321429 | 3.55464401 | Desulfobacula sp. | 2593537 | Bacteria | Bacteria | 70.9 | 2.32e-12 | NR | MDA3786894.1 | 2593537 | g43223 | i0 | 54.5 | 0.613382899628253 | 55 | 25 | 61.3 | 0 | 267 | 103 | 2 | 56 | MDA3786894.1 NHL repeat-containing protein [Desulfobacula sp.] | diamond | 165 | 70.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacula | Desulfobacula sp. | ||
| 32486561 | 32486561 | PRJNA715462_P_NODE_29259_length_330_cov_2.023346_g28463_i0 | PRJNA715462 | 29259 | 330 | 2.023346 | 6.6770418 | Candidatus Magnetomorum sp. HK-1 | 1509431 | Bacteria | Bacteria | 44.7 | 0.0233 | NR | KPA10826.1 | 1509431 | g28463 | i0 | 40.8 | 0.445454545454545 | 49 | 29 | 44.5 | 0 | 37 | 183 | 3112 | 3160 | KPA10826.1 secreted protein containing Dystroglycan-type cadherin-like domain protein [Candidatus Magnetomorum sp. HK-1] | diamond | 147 | 44.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Candidatus Magnetomoraceae | Candidatus Magnetomorum | Candidatus Magnetomorum sp. HK-1 | ||
| 32864619 | 32864619 | PRJNA715462_P_NODE_63580_length_244_cov_0.900585_g62784_i0 | PRJNA715462 | 63580 | 244 | 0.900585 | 2.1974274 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 110 | 5.61e-26 | NR | HEY7536226.1 | 2202153 | g62784 | i0 | 63.3 | 0.971311475409836 | 79 | 29 | 97.1 | 0 | 237 | 1 | 435 | 513 | HEY7536226.1 reverse transcriptase domain-containing protein [Thermodesulfobacteriota bacterium] | diamond | 237 | 110 | 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);;