contig_metadata
20 rows where bioproject = "PRJNA917598", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3447892 | 3447892 | PRJNA917598_P_NODE_83823_length_249_cov_0.875000_g82879_i0 | PRJNA917598 | 83823 | 249 | 0.875 | 2.17875 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 141 | 7.12e-41 | NR | GJM17675.1 | 2202153 | g82879 | i0 | 82.9 | 2.96385542168675 | 82 | 14 | 98.8 | 0 | 2 | 247 | 8 | 89 | GJM17675.1 MAG: hypothetical protein DHS20C13_30020 [Thermodesulfobacteriota bacterium] | diamond | 738 | 141 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 4724466 | 4724466 | PRJNA917598_P_NODE_38684_length_369_cov_1.560811_g37740_i0 | PRJNA917598 | 38684 | 369 | 1.560811 | 5.75939259 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 249 | 2.13e-78 | NR | PLX93317.1 | 892 | g37740 | i0 | 97.6 | 76 | 123 | 3 | 100 | 0 | 1 | 369 | 155 | 277 | PLX93317.1 MAG: SAM-dependent DNA methyltransferase [Desulfuromonas sp.] | diamond | 28044 | 249 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. | ||
| 15279539 | 15279539 | PRJNA917598_P_NODE_68952_length_274_cov_1.502488_g68008_i0 | PRJNA917598 | 68952 | 274 | 1.502488 | 4.11681712 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 140 | 3.65e-38 | NR | WP_066853628.1 | 1560234 | g68008 | i0 | 64.4 | 6.83211678832117 | 90 | 32 | 98.5 | 0 | 2 | 271 | 253 | 342 | WP_066853628.1 HD-GYP domain-containing protein [Halodesulfovibrio spirochaetisodalis] | diamond | 1872 | 141 | 0.99290780141844 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Halodesulfovibrio | Halodesulfovibrio spirochaetisodalis | ||
| 17473801 | 17473801 | PRJNA917598_P_NODE_25974_length_453_cov_4.221053_g25030_i0 | PRJNA917598 | 25974 | 453 | 4.221053 | 19.12137009 | Nitratidesulfovibrio oxamicus | 32016 | Bacteria | Bacteria | 100 | 1.09e-24 | NR | WP_196610302.1 | 32016 | g25030 | i0 | 76.7 | 1.19205298013245 | 60 | 14 | 39.7 | 0 | 196 | 17 | 1 | 60 | WP_196610302.1 hypothetical protein [Nitratidesulfovibrio oxamicus] | diamond | 540 | 100 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Nitratidesulfovibrio | Nitratidesulfovibrio oxamicus | ||
| 21297602 | 21297602 | PRJNA917598_P_NODE_2597_length_1561_cov_3.276882_g2139_i0 | PRJNA917598 | 2597 | 1561 | 3.276882 | 51.15212802 | Smithellaceae bacterium | 2964540 | Bacteria | Bacteria | 686 | 0 | NTclustered | gi|2626216295|emb|OY821638.1| | 2964540 | g2139 | i0 | 80.466 | 1.61563100576553 | 901 | 172 | 58 | 3 | 624 | 1522 | 4801644 | 4802542 | MAG: Smithellaceae bacterium isolate 7d888188-1d27-4603-a379-950c855845c6 genome assembly, chromosome: 1 | blastn | 2522 | 686 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Smithellaceae | Smithellaceae bacterium | |||
| 26810407 | 26810407 | PRJNA917598_P_NODE_91701_length_244_cov_0.900585_g90757_i0 | PRJNA917598 | 91701 | 244 | 0.900585 | 2.1974274 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 62.4 | 4.57e-9 | NR | MEW6594902.1 | 2202153 | g90757 | i0 | 38.7 | 3.68852459016393 | 75 | 46 | 92.2 | 0 | 244 | 20 | 648 | 722 | MEW6594902.1 response regulator [Thermodesulfobacteriota bacterium] | diamond | 900 | 62.8 | 0.993630573248408 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 27845745 | 27845745 | PRJNA917598_P_NODE_18664_length_540_cov_2.203426_g17728_i0 | PRJNA917598 | 18664 | 540 | 2.203426 | 11.8985004 | Desulfonatronovibrio sp. MSAO_Bac4 | 2293858 | Bacteria | Bacteria | 89.4 | 1.99e-17 | NR | RQD64540.1 | 2293858 | g17728 | i0 | 80.4 | 1.10555555555556 | 51 | 10 | 28.3 | 0 | 163 | 11 | 6 | 56 | RQD64540.1 MAG: dTDP-glucose 4,6-dehydratase [Desulfonatronovibrio sp. MSAO_Bac4] | diamond | 597 | 89.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfonatronovibrionaceae | Desulfonatronovibrio | Desulfonatronovibrio sp. MSAO_Bac4 | ||
| 28319456 | 28319456 | PRJNA917598_P_NODE_17066_length_567_cov_1.917004_g16131_i0 | PRJNA917598 | 17066 | 567 | 1.917004 | 10.86941268 | Desulfococcaceae bacterium HSG7 | 3055597 | Bacteria | Bacteria | 140 | 8.06e-36 | NR | MDM8554390.1 | 3055597 | g16131 | i0 | 41.8 | 2.78306878306878 | 182 | 95 | 94.7 | 4 | 563 | 27 | 140 | 313 | MDM8554390.1 radical SAM protein [Desulfococcaceae bacterium HSG7] | diamond | 1578 | 140 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfococcaceae | Desulfococcaceae bacterium HSG7 | |||
| 28382621 | 28382621 | PRJNA917598_P_NODE_11986_length_684_cov_2.317512_g11069_i0 | PRJNA917598 | 11986 | 684 | 2.317512 | 15.85178208 | Maridesulfovibrio sp. | 2795000 | Bacteria | Bacteria | 117 | 1.8e-27 | NR | WP_320008946.1 | 2795000 | g11069 | i0 | 41.4 | 2.27631578947368 | 133 | 77 | 58.3 | 1 | 408 | 10 | 5 | 136 | WP_320008946.1 P-type conjugative transfer ATPase TrbB [Maridesulfovibrio sp.] | diamond | 1557 | 117 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Maridesulfovibrio | Maridesulfovibrio sp. | ||
| 28674190 | 28674190 | PRJNA917598_P_NODE_14387_length_622_cov_1.220401_g13453_i0 | PRJNA917598 | 14387 | 622 | 1.220401 | 7.59089422 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 213 | 1.87e-62 | NR | MDP3429836.1 | 52017 | g13453 | i0 | 52.4 | 12.0337620578778 | 208 | 98 | 99.8 | 1 | 621 | 1 | 256 | 463 | MDP3429836.1 efflux RND transporter permease subunit [Desulfomicrobium sp.] | diamond | 7485 | 213 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfomicrobiaceae | Desulfomicrobium | Desulfomicrobium sp. | ||
| 29203797 | 29203797 | PRJNA917598_P_NODE_52649_length_315_cov_1.272727_g51705_i0 | PRJNA917598 | 52649 | 315 | 1.272727 | 4.00909005 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 137 | 3.68e-40 | NR | KAB2829472.1 | 2080303 | g51705 | i0 | 90.5 | 0.704761904761905 | 74 | 7 | 70.5 | 0 | 12 | 233 | 2 | 75 | KAB2829472.1 MAG: zinc ribbon domain-containing protein [Candidatus Dadabacteria bacterium] | diamond | 222 | 137 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 29235238 | 29235238 | PRJNA917598_P_NODE_24529_length_467_cov_1.228426_g23586_i0 | PRJNA917598 | 24529 | 467 | 1.228426 | 5.73674942 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 137 | 8.4e-36 | NR | HDH86499.1 | 2049433 | g23586 | i0 | 48.9 | 2.74946466809422 | 135 | 68 | 86.7 | 1 | 467 | 63 | 57 | 190 | HDH86499.1 glycosyltransferase [Desulfobacteraceae bacterium] | diamond | 1284 | 137 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 29337253 | 29337253 | PRJNA917598_P_NODE_78009_length_254_cov_1.657459_g77065_i0 | PRJNA917598 | 78009 | 254 | 1.657459 | 4.20994586 | Bacteria | 2 | Bacteria | Bacteria | 80.9 | 1.42e-15 | NR | MCG8617155.1 | 2044940 | g77065 | i0 | 56.7 | 6.15354330708661 | 67 | 29 | 79.1 | 0 | 204 | 4 | 2 | 68 | MCG8617155.1 hypothetical protein [Desulfobacterales bacterium] | diamond | 1563 | 81.6 | 0.991421568627451 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 29519322 | 29519322 | PRJNA917598_P_NODE_55570_length_305_cov_1.991379_g54626_i0 | PRJNA917598 | 55570 | 305 | 1.991379 | 6.07370595 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 50.1 | 8.99e-5 | NR | MEW6667361.1 | 2202153 | g54626 | i0 | 37.3 | 0.501639344262295 | 51 | 32 | 50.2 | 0 | 162 | 10 | 1 | 51 | MEW6667361.1 hypothetical protein [Thermodesulfobacteriota bacterium] | diamond | 153 | 50.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 29930058 | 29930058 | PRJNA917598_P_NODE_49651_length_325_cov_1.833333_g48707_i0 | PRJNA917598 | 49651 | 325 | 1.833333 | 5.95833225 | Syntrophorhabdales bacterium | 2819264 | Bacteria | Bacteria | 56.2 | 7.37e-7 | NR | HME44994.1 | 2819264 | g48707 | i0 | 34.6 | 0.987692307692308 | 107 | 65 | 97.8 | 2 | 321 | 4 | 67 | 169 | HME44994.1 hypothetical protein [Syntrophorhabdales bacterium] | diamond | 321 | 56.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophorhabdia | Syntrophorhabdales | Syntrophorhabdales bacterium | ||||
| 30435622 | 30435622 | PRJNA917598_P_NODE_17813_length_554_cov_2.642412_g16877_i0 | PRJNA917598 | 17813 | 554 | 2.642412 | 14.63896248 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 57.8 | 6.6e-8 | NR | MBC2734153.1 | 2049433 | g16877 | i0 | 81.4 | 0.232851985559567 | 43 | 8 | 23.3 | 0 | 209 | 81 | 1 | 43 | MBC2734153.1 hypothetical protein [Desulfobacteraceae bacterium] | diamond | 129 | 57.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 31351904 | 31351904 | PRJNA917598_P_NODE_85496_length_247_cov_1.752874_g84552_i0 | PRJNA917598 | 85496 | 247 | 1.752874 | 4.32959878 | Desulforhopalus sp. | 2099376 | Bacteria | Bacteria | 42.7 | 0.0403 | NR | MFT5701255.1 | 2099376 | g84552 | i0 | 39.6 | 0.643724696356275 | 53 | 28 | 60.7 | 2 | 180 | 31 | 714 | 765 | MFT5701255.1 diguanylate cyclase (GGDEF)-like protein [Desulforhopalus sp.] | diamond | 159 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfocapsaceae | Desulforhopalus | Desulforhopalus sp. | ||
| 31510125 | 31510125 | PRJNA917598_P_NODE_4736_length_1134_cov_2.987747_g4070_i0 | PRJNA917598 | 4736 | 1134 | 2.987747 | 33.88105098 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 124 | 2.06e-29 | NR | MEW6076227.1 | 2202153 | g4070 | i0 | 59.4 | 0.28042328042328 | 106 | 41 | 27.5 | 1 | 823 | 1134 | 55 | 160 | MEW6076227.1 L,D-transpeptidase family protein [Thermodesulfobacteriota bacterium] | diamond | 318 | 124 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 32427521 | 32427521 | PRJNA917598_P_NODE_95599_length_241_cov_0.916667_g94655_i0 | PRJNA917598 | 95599 | 241 | 0.916667 | 2.20916747 | Desulfuromonadales bacterium C | 2099678 | Bacteria | Bacteria | 85.5 | 3.14e-17 | NR | OEU50711.1 | 1869311 | g94655 | i0 | 55.6 | 0.896265560165975 | 72 | 32 | 89.6 | 0 | 239 | 24 | 99 | 170 | OEU50711.1 MAG: hypothetical protein BA871_16540 [Desulfuromonadales bacterium C00003096] | diamond | 216 | 85.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadales bacterium C00003096 | ||||
| 32781543 | 32781543 | PRJNA917598_P_NODE_34860_length_389_cov_1.354430_g33916_i0 | PRJNA917598 | 34860 | 389 | 1.35443 | 5.2687327 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 58.5 | 4.25e-7 | NR | WP_300719211.1 | 167968 | g33916 | i0 | 42.9 | 2.39845758354756 | 63 | 36 | 48.6 | 0 | 7 | 195 | 45 | 107 | WP_300719211.1 glycerophosphodiester phosphodiesterase family protein [uncultured Desulfovibrio sp.] | diamond | 933 | 58.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | uncultured Desulfovibrio sp. |
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);;