contig_metadata
22 rows where bioproject = "PRJEB75230", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7788298 | 7788298 | PRJEB75230_P_NODE_115567_length_252_cov_1.290503_g115385_i0 | PRJEB75230 | 115567 | 252 | 1.290503 | 3.25206756 | Geobacter sp. DSM 9736 | 1277350 | Bacteria | Bacteria | 52.8 | 0.023 | NTclustered | gi|1210070030|emb|LT896716.1| | 1277350 | g115385 | i0 | 100 | 0.111111111111111 | 28 | 0 | 11 | 0 | 183 | 210 | 3582581 | 3582554 | Geobacter sp. DSM 9736 genome assembly, chromosome: I | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sp. DSM 9736 | ||
| 23088120 | 23088120 | PRJEB75230_P_NODE_142099_length_247_cov_0.885057_g141917_i0 | PRJEB75230 | 142099 | 247 | 0.885057 | 2.18609079 | Candidatus Electronema halotolerans | 3036122 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2322424479|emb|OW818675.1| | 3036122 | g141917 | i0 | 96.97 | 0.133603238866397 | 33 | 1 | 13 | 0 | 111 | 143 | 1790704 | 1790736 | Candidatus Electronema halotolerans isolate LOGT-cMAG genome assembly, chromosome: 1 | blastn | 33 | 56.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Candidatus Electronema | Candidatus Electronema halotolerans | ||
| 26781127 | 26781127 | PRJEB75230_P_NODE_135301_length_248_cov_1.320000_g135119_i0 | PRJEB75230 | 135301 | 248 | 1.32 | 3.2736 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 43.5 | 0.0206 | NR | MBI9086707.1 | 2044940 | g135119 | i0 | 37.8 | 0.544354838709677 | 45 | 28 | 54.4 | 0 | 233 | 99 | 177 | 221 | MBI9086707.1 MFS transporter [Desulfobacterales bacterium] | diamond | 135 | 43.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 26812751 | 26812751 | PRJEB75230_P_NODE_79081_length_280_cov_1.685990_g78899_i0 | PRJEB75230 | 79081 | 280 | 1.68599 | 4.720772 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 66.2 | 3.15e-10 | NR | MCI0454035.1 | 2080303 | g78899 | i0 | 37.4 | 0.975 | 91 | 57 | 97.5 | 0 | 277 | 5 | 424 | 514 | MCI0454035.1 lipase maturation factor family protein [Candidatus Dadabacteria bacterium] | diamond | 273 | 66.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 27255381 | 27255381 | PRJEB75230_P_NODE_109403_length_256_cov_2.409836_g109221_i0 | PRJEB75230 | 109403 | 256 | 2.409836 | 6.16918016 | Desulfococcaceae bacterium HSG8 | 3055603 | Bacteria | Bacteria | 47 | 0.00144 | NR | MDM8523231.1 | 3055603 | g109221 | i0 | 36.3 | 0.9375 | 80 | 48 | 90.2 | 1 | 19 | 249 | 529 | 608 | MDM8523231.1 COR domain-containing protein [Desulfococcaceae bacterium HSG8] | diamond | 240 | 47 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfococcaceae | Desulfococcaceae bacterium HSG8 | |||
| 27690763 | 27690763 | PRJEB75230_P_NODE_91864_length_270_cov_1.172589_g91682_i0 | PRJEB75230 | 91864 | 270 | 1.172589 | 3.1659903 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 44.3 | 0.0155 | NR | KPA09563.1 | 1509431 | g91682 | i0 | 37.3 | 3.12222222222222 | 67 | 36 | 74.4 | 2 | 213 | 13 | 583 | 643 | KPA09563.1 repeat-containing protein [Candidatus Magnetomorum sp. HK-1] | diamond | 843 | 44.7 | 0.991051454138702 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Candidatus Magnetomoraceae | Candidatus Magnetomorum | Candidatus Magnetomorum sp. HK-1 | ||
| 28392259 | 28392259 | PRJEB75230_P_NODE_157746_length_245_cov_0.895349_g157564_i0 | PRJEB75230 | 157746 | 245 | 0.895349 | 2.19360505 | Desulfobulbus sp. | 895 | Bacteria | Bacteria | 43.9 | 0.014 | NR | MCL2344526.1 | 895 | g157564 | i0 | 34 | 0.575510204081633 | 47 | 31 | 57.6 | 0 | 156 | 16 | 58 | 104 | MCL2344526.1 adenosylcobinamide-phosphate synthase CbiB [Desulfobulbus sp.] | diamond | 141 | 43.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | Desulfobulbus sp. | ||
| 28550321 | 28550321 | PRJEB75230_P_NODE_148267_length_246_cov_0.890173_g148085_i0 | PRJEB75230 | 148267 | 246 | 0.890173 | 2.18982558 | Pseudodesulfovibrio hydrargyri | 2125990 | Bacteria | Bacteria | 42.4 | 0.0481 | NR | WP_071543937.1 | 2125990 | g148085 | i0 | 38.6 | 0.695121951219512 | 57 | 31 | 69.5 | 1 | 37 | 207 | 119 | 171 | WP_071543937.1 TVP38/TMEM64 family protein [Pseudodesulfovibrio hydrargyri] | diamond | 171 | 42.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Pseudodesulfovibrio | Pseudodesulfovibrio hydrargyri | ||
| 28771111 | 28771111 | PRJEB75230_P_NODE_2407_length_861_cov_1.362944_g2259_i0 | PRJEB75230 | 2407 | 861 | 1.362944 | 11.73494784 | Desulfobulbaceae bacterium | 2053307 | Bacteria | Bacteria | 80.1 | 4.35e-13 | NR | MDH3329873.1 | 2053307 | g2259 | i0 | 50.7 | 0.240418118466899 | 69 | 34 | 24 | 0 | 859 | 653 | 8 | 76 | MDH3329873.1 leucine-rich repeat domain-containing protein [Desulfobulbaceae bacterium] | diamond | 207 | 80.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbaceae bacterium | |||
| 29213437 | 29213437 | PRJEB75230_P_NODE_62129_length_297_cov_1.254464_g61947_i0 | PRJEB75230 | 62129 | 297 | 1.254464 | 3.72575808 | Desulfococcus sp. 4484_241 | 1968522 | Bacteria | Bacteria | 43.5 | 0.021 | NR | OQX61953.1 | 1968522 | g61947 | i0 | 39.6 | 0.535353535353535 | 53 | 32 | 53.5 | 0 | 102 | 260 | 2 | 54 | OQX61953.1 MAG: hypothetical protein B5M56_07985 [Desulfococcus sp. 4484_241] | diamond | 159 | 43.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfococcaceae | Desulfococcus | Desulfococcus sp. 4484_241 | ||
| 29465383 | 29465383 | PRJEB75230_P_NODE_111210_length_255_cov_1.505495_g111028_i0 | PRJEB75230 | 111210 | 255 | 1.505495 | 3.83901225 | Desulfuromonas sp. | 892 | Bacteria | Bacteria | 43.1 | 0.0318 | NR | MDY0190193.1 | 892 | g111028 | i0 | 31 | 0.835294117647059 | 71 | 42 | 83.5 | 1 | 39 | 251 | 882 | 945 | MDY0190193.1 MMPL family transporter [Desulfuromonas sp.] | diamond | 213 | 43.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. | ||
| 29591680 | 29591680 | PRJEB75230_P_NODE_142050_length_247_cov_0.885057_g141868_i0 | PRJEB75230 | 142050 | 247 | 0.885057 | 2.18609079 | Desulfofustis sp. | 2053546 | Bacteria | Bacteria | 43.1 | 0.0252 | NR | NNF46335.1 | 2053546 | g141868 | i0 | 40 | 1.45748987854251 | 40 | 24 | 48.6 | 0 | 25 | 144 | 62 | 101 | NNF46335.1 prohead protease [Desulfofustis sp.] | diamond | 360 | 43.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfocapsaceae | Desulfofustis | Desulfofustis sp. | ||
| 29623125 | 29623125 | PRJEB75230_P_NODE_11350_length_451_cov_1.756614_g11168_i0 | PRJEB75230 | 11350 | 451 | 1.756614 | 7.92232914 | Desulfuromonadales bacterium C | 2099678 | Bacteria | Bacteria | 70.5 | 2.1e-11 | NR | OEU50623.1 | 1869311 | g11168 | i0 | 42.7 | 3.27937915742794 | 96 | 51 | 61.2 | 1 | 449 | 174 | 140 | 235 | OEU50623.1 MAG: hypothetical protein BA871_16770 [Desulfuromonadales bacterium C00003096] | diamond | 1479 | 70.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadales bacterium C00003096 | ||||
| 30002778 | 30002778 | PRJEB75230_P_NODE_148691_length_246_cov_0.890173_g148509_i0 | PRJEB75230 | 148691 | 246 | 0.890173 | 2.18982558 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 71.6 | 2.58e-12 | NR | MCP4683295.1 | 2044940 | g148509 | i0 | 46.8 | 1.86585365853659 | 79 | 38 | 95.1 | 2 | 2 | 235 | 771 | 846 | MCP4683295.1 glycosyltransferase family 39 protein [Desulfobacterales bacterium] | diamond | 459 | 71.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 30280134 | 30280134 | PRJEB75230_P_NODE_119672_length_251_cov_0.865169_g119490_i0 | PRJEB75230 | 119672 | 251 | 0.865169 | 2.17157419 | Desulfobacterales | 213118 | Bacteria | Bacteria | 43.1 | 0.0305 | NR | MDY0313348.1 | 2044940 | g119490 | i0 | 43.1 | 2.0796812749004 | 58 | 31 | 69.3 | 1 | 4 | 177 | 405 | 460 | MDY0313348.1 beta-ketoacyl synthase N-terminal-like domain-containing protein [Desulfobacterales bacterium] | diamond | 522 | 43.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 30319154 | 30319154 | PRJEB75230_P_NODE_88452_length_273_cov_1.005000_g88270_i0 | PRJEB75230 | 88452 | 273 | 1.005 | 2.74365 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 46.2 | 0.00316 | NR | MBF0102416.1 | 2044940 | g88270 | i0 | 39.4 | 0.725274725274725 | 66 | 40 | 72.5 | 0 | 261 | 64 | 261 | 326 | MBF0102416.1 response regulator [Desulfobacterales bacterium] | diamond | 198 | 46.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 30761016 | 30761016 | PRJEB75230_P_NODE_94094_length_268_cov_1.230769_g93912_i0 | PRJEB75230 | 94094 | 268 | 1.230769 | 3.29846092 | Syntrophales bacterium LBB04 | 2914040 | Bacteria | Bacteria | 42.7 | 0.0074400000000000004 | NR | MCG6537932.1 | 2914040 | g93912 | i0 | 45.9 | 0.414179104477612 | 37 | 20 | 41.4 | 0 | 5 | 115 | 18 | 54 | MCG6537932.1 MarC family protein [Syntrophales bacterium LBB04] | diamond | 111 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophales bacterium LBB04 | ||||
| 31804059 | 31804059 | PRJEB75230_P_NODE_165437_length_243_cov_2.717647_g165255_i0 | PRJEB75230 | 165437 | 243 | 2.717647 | 6.60388221 | Desulfofustis sp. | 2053546 | Bacteria | Bacteria | 42.7 | 0.0369 | NR | MBE0586312.1 | 2053546 | g165255 | i0 | 39.7 | 0.716049382716049 | 58 | 35 | 71.6 | 0 | 185 | 12 | 239 | 296 | MBE0586312.1 hypothetical protein [Desulfofustis sp.] | diamond | 174 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfocapsaceae | Desulfofustis | Desulfofustis sp. | ||
| 32247497 | 32247497 | PRJEB75230_P_NODE_136558_length_248_cov_0.880000_g136376_i0 | PRJEB75230 | 136558 | 248 | 0.88 | 2.1824 | Desulfovibrio sp. | 885 | Bacteria | Bacteria | 42.7 | 0.0393 | NR | MDE6735817.1 | 885 | g136376 | i0 | 50 | 0.459677419354839 | 38 | 19 | 46 | 0 | 73 | 186 | 396 | 433 | MDE6735817.1 cytochrome c biogenesis protein CcsA [Desulfovibrio sp.] | diamond | 114 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. | ||
| 32595169 | 32595169 | PRJEB75230_P_NODE_136680_length_248_cov_0.880000_g136498_i0 | PRJEB75230 | 136680 | 248 | 0.88 | 2.1824 | Desulfohalobiaceae bacterium | 2683721 | Bacteria | Bacteria | 82 | 3.98e-18 | NR | MCF8030028.1 | 2683721 | g136498 | i0 | 95.3 | 0.520161290322581 | 43 | 2 | 52 | 0 | 248 | 120 | 59 | 101 | MCF8030028.1 rubrerythrin [Desulfohalobiaceae bacterium] | diamond | 129 | 82 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfohalobiaceae bacterium | |||
| 32657701 | 32657701 | PRJEB75230_P_NODE_17580_length_397_cov_2.043210_g17398_i0 | PRJEB75230 | 17580 | 397 | 2.04321 | 8.1115437 | Desulfocapsa sp. | 2066021 | Bacteria | Bacteria | 53.5 | 2.62e-5 | NR | MCF8056622.1 | 2066021 | g17398 | i0 | 46.9 | 0.483627204030227 | 64 | 33 | 48.4 | 1 | 168 | 359 | 54 | 116 | MCF8056622.1 class I SAM-dependent methyltransferase [Desulfocapsa sp.] | diamond | 192 | 53.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfocapsaceae | Desulfocapsa | Desulfocapsa sp. | ||
| 32745373 | 32745373 | PRJEB75230_P_NODE_88900_length_272_cov_1.547739_g88718_i0 | PRJEB75230 | 88900 | 272 | 1.547739 | 4.20985008 | Desulfotignum | 115780 | Bacteria | Bacteria | 75.1 | 6.2e-14 | NR | MCG8688045.1 | 2044940 | g88718 | i0 | 43.9 | 4.54411764705882 | 82 | 46 | 90.4 | 0 | 268 | 23 | 125 | 206 | MCG8688045.1 DUF4197 domain-containing protein [Desulfobacterales bacterium] | diamond | 1236 | 75.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales 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);;