contig_metadata
25 rows where bioproject = "PRJNA1156092", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9230649 | 9230649 | PRJNA1156092_P_NODE_13228_length_316_cov_0.950617_g13098_i0 | PRJNA1156092 | 13228 | 316 | 0.950617 | 3.00394972 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2381092847|gb|CP113000.1| | 2202153 | g13098 | i0 | 100 | 1.08227848101266 | 30 | 0 | 9 | 0 | 1 | 30 | 1495593 | 1495564 | MAG: Thermodesulfobacteriota bacterium isolate ORM2a chromosome, complete genome | blastn | 342 | 56.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 17614944 | 17614944 | PRJNA1156092_P_NODE_21294_length_254_cov_2.077348_g21164_i0 | PRJNA1156092 | 21294 | 254 | 2.077348 | 5.27646392 | Bacteria | 2 | Bacteria | Bacteria | 353 | 5.65e-93 | NTclustered | gi|2518551120|emb|OX638332.1| | 2080303 | g21164 | i0 | 91.732 | 147.751968503937 | 254 | 21 | 100 | 0 | 1 | 254 | 24129 | 24382 | MAG: Candidatus Dadabacteria bacterium isolate 28c7ac20-cd97-4a81-9be0-f5b43b5a8d2b genome assembly, chromosome: 1 | blastn | 37529 | 353 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 21979542 | 21979542 | PRJNA1156092_P_NODE_18158_length_276_cov_1.482759_g18028_i0 | PRJNA1156092 | 18158 | 276 | 1.482759 | 4.09241484 | Desulfarculia bacterium | 3065862 | Bacteria | Bacteria | 52.8 | 0.025 | NTclustered | gi|2621701822|emb|OY759352.1| | 3065862 | g18028 | i0 | 100 | 0.101449275362319 | 28 | 0 | 10 | 0 | 189 | 216 | 2529376 | 2529349 | MAG: Desulfarculia bacterium isolate c1361fd1-6016-418c-9b2d-a8e9625d1ec5 genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Desulfarculia bacterium | |||||
| 26628724 | 26628724 | PRJNA1156092_P_NODE_32561_length_241_cov_0.916667_g32431_i0 | PRJNA1156092 | 32561 | 241 | 0.916667 | 2.20916747 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 121 | 2.6e-30 | NR | MCD4742063.1 | 2049433 | g32431 | i0 | 76.7 | 0.908713692946058 | 73 | 17 | 90.9 | 0 | 239 | 21 | 377 | 449 | MCD4742063.1 putative glycoside hydrolase family 15 protein [Desulfobacteraceae bacterium] | diamond | 219 | 121 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 26660118 | 26660118 | PRJNA1156092_P_NODE_26401_length_247_cov_0.885057_g26271_i0 | PRJNA1156092 | 26401 | 247 | 0.885057 | 2.18609079 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 150 | 9.59e-41 | NR | MCK4987556.1 | 2044940 | g26271 | i0 | 97.5 | 0.983805668016194 | 81 | 2 | 98.4 | 0 | 3 | 245 | 39 | 119 | MCK4987556.1 hydantoinase/oxoprolinase family protein [Desulfobacterales bacterium] | diamond | 243 | 150 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 26660127 | 26660127 | PRJNA1156092_P_NODE_32581_length_241_cov_0.916667_g32451_i0 | PRJNA1156092 | 32581 | 241 | 0.916667 | 2.20916747 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 159 | 1.82e-45 | NR | MDJ0667892.1 | 2044940 | g32451 | i0 | 93.8 | 2.98755186721992 | 80 | 5 | 99.6 | 0 | 241 | 2 | 39 | 118 | MDJ0667892.1 response regulator [Desulfobacterales bacterium] | diamond | 720 | 159 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 26976974 | 26976974 | PRJNA1156092_P_NODE_31102_length_242_cov_0.911243_g30972_i0 | PRJNA1156092 | 31102 | 242 | 0.911243 | 2.20520806 | Desulfuromonadales bacterium | 2099678 | Bacteria | Bacteria | 151 | 4.369999999999999e-42 | NR | MDH3544576.1 | 2099678 | g30972 | i0 | 91.3 | 2.97520661157025 | 80 | 7 | 99.2 | 0 | 3 | 242 | 15 | 94 | MDH3544576.1 AMIN domain-containing protein [Desulfuromonadales bacterium] | diamond | 720 | 151 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadales bacterium | ||||
| 27451378 | 27451378 | PRJNA1156092_P_NODE_30083_length_243_cov_0.905882_g29953_i0 | PRJNA1156092 | 30083 | 243 | 0.905882 | 2.20129326 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 146 | 3.24e-42 | NR | MDJ0668231.1 | 2044940 | g29953 | i0 | 91.4 | 1 | 81 | 7 | 100 | 0 | 1 | 243 | 74 | 154 | MDJ0668231.1 response regulator transcription factor [Desulfobacterales bacterium] | diamond | 243 | 146 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 27893033 | 27893033 | PRJNA1156092_P_NODE_17525_length_281_cov_0.846154_g17395_i0 | PRJNA1156092 | 17525 | 281 | 0.846154 | 2.37769274 | Desulfovibrionaceae bacterium | 2049043 | Bacteria | Bacteria | 48.9 | 2.39e-4 | NR | MDD6181102.1 | 2049043 | g17395 | i0 | 37.7 | 0.736654804270463 | 69 | 42 | 72.6 | 1 | 207 | 4 | 35 | 103 | MDD6181102.1 glycerol-3-phosphate 1-O-acyltransferase PlsY [Desulfovibrionaceae bacterium] | diamond | 207 | 48.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrionaceae bacterium | |||
| 27893038 | 27893038 | PRJNA1156092_P_NODE_23705_length_250_cov_0.870056_g23575_i0 | PRJNA1156092 | 23705 | 250 | 0.870056 | 2.17514 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 122 | 1.4999999999999995e-32 | NR | NVM20702.1 | 2044940 | g23575 | i0 | 72 | 0.984 | 82 | 23 | 98.4 | 0 | 3 | 248 | 67 | 148 | NVM20702.1 methyltransferase domain-containing protein [Desulfobacterales bacterium] | diamond | 246 | 122 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 28480906 | 28480906 | PRJNA1156092_P_NODE_25506_length_248_cov_0.880000_g25376_i0 | PRJNA1156092 | 25506 | 248 | 0.88 | 2.1824 | Desulfosarcina | 2299 | Bacteria | Bacteria | 99.4 | 4.87e-22 | NR | WP_246804835.1 | 90730 | g25376 | i0 | 59.5 | 2.90322580645161 | 79 | 32 | 95.6 | 0 | 248 | 12 | 242 | 320 | WP_246804835.1 RHS repeat-associated core domain-containing protein [Desulfosarcina cetonica] | diamond | 720 | 100 | 0.994 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosarcinaceae | Desulfosarcina | Desulfosarcina cetonica | ||
| 28619558 | 28619558 | PRJNA1156092_P_NODE_23367_length_250_cov_0.870056_g23237_i0 | PRJNA1156092 | 23367 | 250 | 0.870056 | 2.17514 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 112 | 1.41e-28 | NR | MCK4987298.1 | 2044940 | g23237 | i0 | 68.8 | 0.96 | 80 | 25 | 96 | 0 | 241 | 2 | 1 | 80 | MCK4987298.1 tetratricopeptide repeat protein [Desulfobacterales bacterium] | diamond | 240 | 112 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 28935190 | 28935190 | PRJNA1156092_P_NODE_31148_length_242_cov_0.911243_g31018_i0 | PRJNA1156092 | 31148 | 242 | 0.911243 | 2.20520806 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 136 | 1.55e-36 | NR | UCD77108.1 | 2044940 | g31018 | i0 | 82.5 | 0.991735537190083 | 80 | 14 | 99.2 | 0 | 2 | 241 | 133 | 212 | UCD77108.1 MAG: MFS transporter [Desulfobacterales bacterium] | diamond | 240 | 136 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 29175708 | 29175708 | PRJNA1156092_P_NODE_28389_length_245_cov_0.895349_g28259_i0 | PRJNA1156092 | 28389 | 245 | 0.895349 | 2.19360505 | Bacteria | 2 | Bacteria | Bacteria | 57.4 | 1.84e-8 | NR | MCK5205386.1 | 2044940 | g28259 | i0 | 93.1 | 0.710204081632653 | 29 | 2 | 35.5 | 0 | 158 | 244 | 1 | 29 | MCK5205386.1 transposase [Desulfobacterales bacterium] | diamond | 174 | 57.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 29187929 | 29187929 | PRJNA1156092_P_NODE_25129_length_248_cov_0.880000_g24999_i0 | PRJNA1156092 | 25129 | 248 | 0.88 | 2.1824 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 42.7 | 0.0369 | NR | MEX1346497.1 | 2044940 | g24999 | i0 | 29.6 | 0.979838709677419 | 81 | 54 | 94.4 | 1 | 247 | 14 | 23 | 103 | MEX1346497.1 cache domain-containing protein [Desulfobacterales bacterium] | diamond | 243 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 29471549 | 29471549 | PRJNA1156092_P_NODE_27610_length_246_cov_0.890173_g27480_i0 | PRJNA1156092 | 27610 | 246 | 0.890173 | 2.18982558 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 73.6 | 4.97e-14 | NR | MDH3882605.1 | 2044940 | g27480 | i0 | 86.5 | 0.451219512195122 | 37 | 5 | 45.1 | 0 | 111 | 1 | 37 | 73 | MDH3882605.1 PilZ domain-containing protein [Desulfobacterales bacterium] | diamond | 111 | 73.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 29901859 | 29901859 | PRJNA1156092_P_NODE_22551_length_251_cov_0.865169_g22421_i0 | PRJNA1156092 | 22551 | 251 | 0.865169 | 2.17157419 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 100 | 1.04e-22 | NR | WP_020875089.1 | 897 | g22421 | i0 | 77.4 | 11.402390438247 | 62 | 14 | 74.1 | 0 | 188 | 3 | 1 | 62 | WP_020875089.1 2-oxoglutarate dehydrogenase complex dihydrolipoyllysine-residue succinyltransferase [Desulfococcus multivorans] | diamond | 2862 | 100 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfococcaceae | Desulfococcus | Desulfococcus multivorans | ||
| 30356796 | 30356796 | PRJNA1156092_P_NODE_31652_length_242_cov_0.911243_g31522_i0 | PRJNA1156092 | 31652 | 242 | 0.911243 | 2.20520806 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 157 | 1.08e-46 | NR | MEE4605004.1 | 2049433 | g31522 | i0 | 92.5 | 0.991735537190083 | 80 | 6 | 99.2 | 0 | 2 | 241 | 51 | 130 | MEE4605004.1 sigma-70 family RNA polymerase sigma factor [Desulfobacteraceae bacterium] | diamond | 240 | 157 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 30830174 | 30830174 | PRJNA1156092_P_NODE_29114_length_244_cov_0.900585_g28984_i0 | PRJNA1156092 | 29114 | 244 | 0.900585 | 2.1974274 | Desulfobacula sp. | 2593537 | Bacteria | Bacteria | 111 | 9.53e-28 | NR | WP_300465117.1 | 2593537 | g28984 | i0 | 58.5 | 1.00819672131148 | 82 | 33 | 99.6 | 1 | 1 | 243 | 168 | 249 | WP_300465117.1 SpoIIE family protein phosphatase [Desulfobacula sp.] | diamond | 246 | 111 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacula | Desulfobacula sp. | ||
| 31082968 | 31082968 | PRJNA1156092_P_NODE_22055_length_251_cov_0.865169_g21925_i0 | PRJNA1156092 | 22055 | 251 | 0.865169 | 2.17157419 | Syntrophobacteria bacterium | 3024410 | Bacteria | Bacteria | 110 | 1.33e-26 | NR | MEE9532040.1 | 3024410 | g21925 | i0 | 82 | 0.729083665338645 | 61 | 11 | 72.9 | 0 | 2 | 184 | 306 | 366 | MEE9532040.1 hypothetical protein [Syntrophobacteria bacterium] | diamond | 183 | 110 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacteria bacterium | |||||
| 31177474 | 31177474 | PRJNA1156092_P_NODE_21915_length_251_cov_0.865169_g21785_i0 | PRJNA1156092 | 21915 | 251 | 0.865169 | 2.17157419 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 89 | 1.61e-18 | NR | NNK95751.1 | 2044940 | g21785 | i0 | 74.1 | 0.645418326693227 | 54 | 14 | 64.5 | 0 | 2 | 163 | 375 | 428 | NNK95751.1 2-oxo acid dehydrogenase subunit E2 [Desulfobacterales bacterium] | diamond | 162 | 89 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 31683606 | 31683606 | PRJNA1156092_P_NODE_22217_length_251_cov_0.865169_g22087_i0 | PRJNA1156092 | 22217 | 251 | 0.865169 | 2.17157419 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 172 | 4.71e-51 | NR | MCK5486872.1 | 2044940 | g22087 | i0 | 94 | 3.9681274900398402 | 83 | 5 | 99.2 | 0 | 249 | 1 | 77 | 159 | MCK5486872.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Desulfobacterales bacterium] | diamond | 996 | 172 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 32000147 | 32000147 | PRJNA1156092_P_NODE_25698_length_248_cov_0.874286_g25568_i0 | PRJNA1156092 | 25698 | 248 | 0.874286 | 2.16822928 | Syntrophobacteria bacterium | 3024410 | Bacteria | Bacteria | 105 | 3.01e-26 | NR | MEE8315769.1 | 3024410 | g25568 | i0 | 94.4 | 1.29435483870968 | 54 | 3 | 65.3 | 0 | 164 | 3 | 1 | 54 | MEE8315769.1 ribosome recycling factor [Syntrophobacteria bacterium] | diamond | 321 | 105 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacteria bacterium | |||||
| 32285232 | 32285232 | PRJNA1156092_P_NODE_30499_length_243_cov_0.905882_g30369_i0 | PRJNA1156092 | 30499 | 243 | 0.905882 | 2.20129326 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 94 | 3.46e-20 | NR | THB75532.1 | 2049433 | g30369 | i0 | 72.3 | 0.802469135802469 | 65 | 18 | 80.2 | 0 | 197 | 3 | 22 | 86 | THB75532.1 MAG: response regulator [Desulfobacteraceae bacterium] | diamond | 195 | 94 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 32379922 | 32379922 | PRJNA1156092_P_NODE_23159_length_250_cov_0.870056_g23029_i0 | PRJNA1156092 | 23159 | 250 | 0.870056 | 2.17514 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 145 | 1.67e-40 | NR | MEA3231415.1 | 2202153 | g23029 | i0 | 77.8 | 0.972 | 81 | 18 | 97.2 | 0 | 245 | 3 | 230 | 310 | MEA3231415.1 response regulator [Thermodesulfobacteriota bacterium] | diamond | 243 | 145 | 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);;