contig_metadata
18 rows where bioproject = "PRJNA605033" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 582927 | 582927 | PRJNA605033_P_NODE_54941_length_232_cov_5.908629_g53373_i0 | PRJNA605033 | 54941 | 232 | 5.908629 | 13.70801928 | Desulfatibacillum aliphaticivorans | 218208 | Bacteria | Bacteria | 75 | 4.43e-9 | NTclustered | gi|218759244|gb|CP001322.1| | 218208 | g53373 | i0 | 97.674 | 0.185344827586207 | 43 | 1 | 19 | 0 | 152 | 194 | 2833497 | 2833455 | Desulfatibacillum aliphaticivorans strain AK-01, complete genome | blastn | 43 | 75 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfatibacillaceae | Desulfatibacillum | Desulfatibacillum aliphaticivorans | ||
| 1857959 | 1857959 | PRJNA605033_P_NODE_197722_length_167_cov_1.113636_g196153_i0 | PRJNA605033 | 197722 | 167 | 1.113636 | 1.85977212 | Desulfosarcina alkanivorans | 571177 | Bacteria | Bacteria | 52.8 | 0.014 | NTclustered | gi|1773409569|dbj|AP021874.1| | 571177 | g196153 | i0 | 100 | 0.167664670658683 | 28 | 0 | 17 | 0 | 2 | 29 | 5802817 | 5802844 | Desulfosarcina alkanivorans PL12 DNA, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosarcinaceae | Desulfosarcina | Desulfosarcina alkanivorans | ||
| 13899709 | 13899709 | PRJNA605033_P_NODE_55971_length_231_cov_2.806122_g54403_i0 | PRJNA605033 | 55971 | 231 | 2.806122 | 6.48214182 | Nitratidesulfovibrio | 2802295 | Bacteria | Bacteria | 93.5 | 1.22e-14 | NTclustered | gi|2431395895|gb|CP116246.1| | 881 | g54403 | i0 | 81.667 | 3.22077922077922 | 120 | 14 | 50 | 7 | 1 | 116 | 326091 | 326206 | Nitratidesulfovibrio vulgaris strain L2 chromosome, complete genome | blastn | 744 | 93.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Nitratidesulfovibrio | Nitratidesulfovibrio vulgaris | ||
| 19709176 | 19709176 | PRJNA605033_P_NODE_27656_length_286_cov_1.876494_g26091_i0 | PRJNA605033 | 27656 | 286 | 1.876494 | 5.36677284 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 74.3 | 3.21e-13 | NR | WP_027714398.1 | 1232410 | g26091 | i0 | 71.7 | 2.89510489510489 | 46 | 13 | 48.3 | 0 | 149 | 286 | 193 | 238 | WP_027714398.1 zinc-dependent alcohol dehydrogenase family protein [Desulfuromonas sp. TF] | diamond | 828 | 74.7 | 0.994645247657296 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. TF | ||
| 26731529 | 26731529 | PRJNA605033_P_NODE_93101_length_222_cov_2.112299_g91532_i0 | PRJNA605033 | 93101 | 222 | 2.112299 | 4.68930378 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 40.4 | 0.0271 | NR | HLA50914.1 | 2202153 | g91532 | i0 | 66.7 | 0.324324324324324 | 24 | 8 | 32.4 | 0 | 1 | 72 | 32 | 55 | HLA50914.1 hypothetical protein [Thermodesulfobacteriota bacterium] | diamond | 72 | 40.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 26953353 | 26953353 | PRJNA605033_P_NODE_61962_length_224_cov_2.634921_g60393_i0 | PRJNA605033 | 61962 | 224 | 2.634921 | 5.90222304 | uncultured Desulfobulbus sp. | 239745 | Bacteria | Bacteria | 45.1 | 0.0045 | NR | WP_319586187.1 | 239745 | g60393 | i0 | 61.3 | 1.20535714285714 | 31 | 12 | 41.5 | 0 | 130 | 222 | 345 | 375 | WP_319586187.1 glycoside hydrolase family 3 C-terminal domain-containing protein [uncultured Desulfobulbus sp.] | diamond | 270 | 45.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | uncultured Desulfobulbus sp. | ||
| 27490978 | 27490978 | PRJNA605033_P_NODE_89203_length_222_cov_2.208556_g87634_i0 | PRJNA605033 | 89203 | 222 | 2.208556 | 4.90299432 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 47.4 | 6.46e-4 | NR | RMF14029.1 | 2080303 | g87634 | i0 | 92 | 0.675675675675676 | 25 | 2 | 33.8 | 0 | 222 | 148 | 13 | 37 | RMF14029.1 MAG: GDP-L-fucose synthase [Candidatus Dadabacteria bacterium] | diamond | 150 | 47.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 27617271 | 27617271 | PRJNA605033_P_NODE_160844_length_186_cov_1.549669_g159275_i0 | PRJNA605033 | 160844 | 186 | 1.549669 | 2.88238434 | Dissulfuribacterales bacterium | 3050474 | Bacteria | Bacteria | 45.4 | 0.00195 | NR | MEZ0328300.1 | 3050474 | g159275 | i0 | 46.9 | 1.61290322580645 | 49 | 26 | 79 | 0 | 167 | 21 | 1003 | 1051 | MEZ0328300.1 6-hydroxymethylpterin diphosphokinase MptE-like protein [Dissulfuribacterales bacterium] | diamond | 300 | 45.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Dissulfuribacteria | Dissulfuribacterales | Dissulfuribacterales bacterium | ||||
| 27680602 | 27680602 | PRJNA605033_P_NODE_169124_length_181_cov_1.061644_g167555_i0 | PRJNA605033 | 169124 | 181 | 1.061644 | 1.92157564 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 45.8 | 2.49e-4 | NR | MEW6350267.1 | 2202153 | g167555 | i0 | 51.1 | 2.2707182320442 | 45 | 20 | 74.6 | 1 | 1 | 135 | 45 | 87 | MEW6350267.1 type II toxin-antitoxin system RelE/ParE family toxin [Thermodesulfobacteriota bacterium] | diamond | 411 | 45.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 27819943 | 27819943 | PRJNA605033_P_NODE_208264_length_162_cov_3.905512_g206695_i0 | PRJNA605033 | 208264 | 162 | 3.905512 | 6.32692944 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 54.3 | 1.01e-6 | NR | WP_207680843.1 | 45655 | g206695 | i0 | 49.1 | 5.7962962962963 | 53 | 24 | 98.1 | 1 | 160 | 2 | 425 | 474 | WP_207680843.1 response regulator [Desulfonema magnum] | diamond | 939 | 54.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfococcaceae | Desulfonema | Desulfonema magnum | ||
| 27851215 | 27851215 | PRJNA605033_P_NODE_241004_length_152_cov_1.367521_g239435_i0 | PRJNA605033 | 241004 | 152 | 1.367521 | 2.07863192 | Desulfuromonadia | 3031651 | Bacteria | Bacteria | 60.8 | 2.06e-9 | NR | WP_223907274.1 | 1566346 | g239435 | i0 | 58 | 3.94736842105263 | 50 | 20 | 98.7 | 1 | 151 | 2 | 136 | 184 | WP_223907274.1 hypothetical protein [Geobacter sp. AOG1] | diamond | 600 | 60.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sp. AOG1 | ||
| 28911352 | 28911352 | PRJNA605033_P_NODE_164948_length_183_cov_2.256757_g163379_i0 | PRJNA605033 | 164948 | 183 | 2.256757 | 4.12986531 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 70.1 | 1.13e-13 | NR | MEJ2170728.1 | 2044940 | g163379 | i0 | 50 | 0.983606557377049 | 60 | 30 | 98.4 | 0 | 182 | 3 | 54 | 113 | MEJ2170728.1 DUF5615 family PIN-like protein [Desulfobacterales bacterium] | diamond | 180 | 70.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 29195959 | 29195959 | PRJNA605033_P_NODE_105889_length_222_cov_1.855615_g104320_i0 | PRJNA605033 | 105889 | 222 | 1.855615 | 4.1194653 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 53.9 | 7.89e-7 | NR | HHO47422.1 | 2049433 | g104320 | i0 | 96 | 0.675675675675676 | 25 | 1 | 33.8 | 0 | 1 | 75 | 6 | 30 | HHO47422.1 hypothetical protein [Desulfobacteraceae bacterium] | diamond | 150 | 53.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 29511423 | 29511423 | PRJNA605033_P_NODE_102690_length_222_cov_1.909091_g101121_i0 | PRJNA605033 | 102690 | 222 | 1.909091 | 4.23818202 | Desulfobulbus sp. | 895 | Bacteria | Bacteria | 45.8 | 0.00231 | NR | MCL2344359.1 | 895 | g101121 | i0 | 84 | 0.337837837837838 | 25 | 4 | 33.8 | 0 | 148 | 222 | 15 | 39 | MCL2344359.1 Do family serine endopeptidase [Desulfobulbus sp.] | diamond | 75 | 45.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | Desulfobulbus sp. | ||
| 30269874 | 30269874 | PRJNA605033_P_NODE_125392_length_220_cov_4.756757_g123823_i0 | PRJNA605033 | 125392 | 220 | 4.756757 | 10.4648654 | Desulfovermiculus sp. | 2821143 | Bacteria | Bacteria | 50.8 | 3.14e-6 | NR | MDZ7760902.1 | 2821143 | g123823 | i0 | 44 | 1.36363636363636 | 50 | 28 | 68.2 | 0 | 210 | 61 | 2 | 51 | MDZ7760902.1 hypothetical protein [Desulfovermiculus sp.] | diamond | 300 | 50.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfovermiculus | Desulfovermiculus sp. | ||
| 30396471 | 30396471 | PRJNA605033_P_NODE_246893_length_150_cov_3.156522_g245324_i0 | PRJNA605033 | 246893 | 150 | 3.156522 | 4.734783 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 53.1 | 2.17e-6 | NR | HXG31615.1 | 2202153 | g245324 | i0 | 100 | 1.44 | 24 | 0 | 48 | 0 | 74 | 3 | 76 | 99 | HXG31615.1 phosphoenolpyruvate--protein phosphotransferase [Thermodesulfobacteriota bacterium] | diamond | 216 | 53.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 31344100 | 31344100 | PRJNA605033_P_NODE_83956_length_222_cov_2.363636_g82387_i0 | PRJNA605033 | 83956 | 222 | 2.363636 | 5.24727192 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 67.8 | 3.92e-11 | NR | HZX36284.1 | 2202153 | g82387 | i0 | 50.7 | 1.95945945945946 | 73 | 23 | 98.6 | 1 | 2 | 220 | 188 | 247 | HZX36284.1 Fic family protein [Thermodesulfobacteriota bacterium] | diamond | 435 | 67.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 32451544 | 32451544 | PRJNA605033_P_NODE_36939_length_261_cov_1.150442_g35372_i0 | PRJNA605033 | 36939 | 261 | 1.150442 | 3.00265362 | Desulfovibrio sp. | 885 | Bacteria | Bacteria | 42.4 | 0.0473 | NR | WP_291439204.1 | 885 | g35372 | i0 | 37 | 0.620689655172414 | 54 | 34 | 62.1 | 0 | 100 | 261 | 18 | 71 | WP_291439204.1 shikimate kinase AroL [Desulfovibrio sp.] | diamond | 162 | 42.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | 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);;