contig_metadata
20 rows where bioproject = "PRJNA879067", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 855314 | 855314 | PRJNA879067_P_NODE_48901_length_534_cov_3.032538_g45422_i0 | PRJNA879067 | 48901 | 534 | 3.032538 | 16.19375292 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 150 | 5.81e-41 | NR | MFI5324066.1 | 2202153 | g45422 | i0 | 80 | 0.50561797752809 | 90 | 18 | 50.6 | 0 | 532 | 263 | 228 | 317 | MFI5324066.1 thioredoxin-disulfide reductase [Thermodesulfobacteriota bacterium] | diamond | 270 | 150 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 3407404 | 3407404 | PRJNA879067_P_NODE_99003_length_266_cov_1.502591_g95517_i0 | PRJNA879067 | 99003 | 266 | 1.502591 | 3.99689206 | Bacteria | 2 | Bacteria | Bacteria | 166 | 2.2e-46 | NR | MCL4244294.1 | 2080303 | g95517 | i0 | 90.1 | 3.65413533834586 | 81 | 8 | 91.4 | 0 | 266 | 24 | 222 | 302 | MCL4244294.1 PQQ-dependent sugar dehydrogenase [Candidatus Dadabacteria bacterium] | diamond | 972 | 166 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 4683364 | 4683364 | PRJNA879067_P_NODE_39904_length_624_cov_2.190563_g36459_i0 | PRJNA879067 | 39904 | 624 | 2.190563 | 13.66911312 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 223 | 2.61e-69 | NR | MBF0120026.1 | 2044940 | g36459 | i0 | 52 | 2.91826923076923 | 202 | 95 | 96.2 | 1 | 25 | 624 | 45 | 246 | MBF0120026.1 SDR family oxidoreductase [Desulfobacterales bacterium] | diamond | 1821 | 223 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 13608943 | 13608943 | PRJNA879067_P_NODE_50951_length_517_cov_2.067568_g47468_i0 | PRJNA879067 | 50951 | 517 | 2.067568 | 10.68932656 | Desulfovibrio desulfuricans | 876 | Bacteria | Bacteria | 739 | 0 | NTclustered | gi|2172810686|gb|CP077745.1| | 876 | g47468 | i0 | 92.486 | 16.2321083172147 | 519 | 36 | 100 | 3 | 1 | 517 | 2990258 | 2989741 | Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome | blastn | 8392 | 739 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio desulfuricans | ||
| 19980878 | 19980878 | PRJNA879067_P_NODE_17716_length_1096_cov_6.317693_g14928_i0 | PRJNA879067 | 17716 | 1096 | 6.317693 | 69.24191528 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 475 | 7.239999999999998e-166 | NR | MCC6713589.1 | 2080303 | g14928 | i0 | 88.8 | 0.736313868613139 | 269 | 30 | 73.6 | 0 | 60 | 866 | 30 | 298 | MCC6713589.1 GTPase Era [Candidatus Dadabacteria bacterium] | diamond | 807 | 475 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 21256842 | 21256842 | PRJNA879067_P_NODE_33577_length_706_cov_14.619273_g30206_i0 | PRJNA879067 | 33577 | 706 | 14.619273 | 103.21206738 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 244 | 1.04e-77 | NR | MCA9809583.1 | 2080303 | g30206 | i0 | 90.4 | 0.573654390934844 | 135 | 13 | 57.4 | 0 | 429 | 25 | 1 | 135 | MCA9809583.1 ABC transporter ATP-binding protein [Candidatus Dadabacteria bacterium] | diamond | 405 | 244 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 21257307 | 21257307 | PRJNA879067_P_NODE_48837_length_534_cov_19.075922_g45358_i0 | PRJNA879067 | 48837 | 534 | 19.075922 | 101.86542348 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 468 | 4.39e-127 | NTclustered | gi|2575803239|emb|OY729416.1| | 2202153 | g45358 | i0 | 83.658 | 152.634831460674 | 514 | 66 | 95 | 13 | 26 | 534 | 75138 | 75638 | MAG: Thermodesulfobacteriota bacterium isolate ba02c5ff-97d3-4768-ae28-618c4039653d genome assembly, chromosome: 1 | blastn | 81507 | 468 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 22530783 | 22530783 | PRJNA879067_P_NODE_14078_length_1273_cov_7.803333_g11542_i0 | PRJNA879067 | 14078 | 1273 | 7.803333 | 99.33642909 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 800 | 6.6e-288 | NR | MCC6713144.1 | 2080303 | g11542 | i0 | 94.3 | 0.996857816182247 | 423 | 24 | 99.7 | 0 | 1273 | 5 | 39 | 461 | MCC6713144.1 tRNA uridine-5-carboxymethylaminomethyl(34) synthesis enzyme MnmG [Candidatus Dadabacteria bacterium] | diamond | 1269 | 800 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 25081769 | 25081769 | PRJNA879067_P_NODE_65380_length_414_cov_3.645161_g61895_i0 | PRJNA879067 | 65380 | 414 | 3.645161 | 15.09096654 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 263 | 5.150000000000001e-86 | NR | MCL4246093.1 | 2080303 | g61895 | i0 | 95.6 | 1.98550724637681 | 137 | 6 | 99.3 | 0 | 3 | 413 | 2 | 138 | MCL4246093.1 phosphoribosylformylglycinamidine cyclo-ligase [Candidatus Dadabacteria bacterium] | diamond | 822 | 263 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 26643609 | 26643609 | PRJNA879067_P_NODE_6821_length_1928_cov_16.364960_g5133_i0 | PRJNA879067 | 6821 | 1928 | 16.36496 | 315.51642880000003 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 773 | 8.31e-271 | NR | HML96064.1 | 2202153 | g5133 | i0 | 93.1 | 0.676867219917012 | 435 | 30 | 67.7 | 0 | 30 | 1334 | 387 | 821 | HML96064.1 DNA gyrase subunit A [Thermodesulfobacteriota bacterium] | diamond | 1305 | 773 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 26706793 | 26706793 | PRJNA879067_P_NODE_71241_length_381_cov_4.646104_g67756_i0 | PRJNA879067 | 71241 | 381 | 4.646104 | 17.70165624 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 144 | 2.1399999999999996e-41 | NR | HML95674.1 | 2202153 | g67756 | i0 | 82.9 | 0.645669291338583 | 82 | 14 | 64.6 | 0 | 380 | 135 | 80 | 161 | HML95674.1 hypothetical protein [Thermodesulfobacteriota bacterium] | diamond | 246 | 144 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 27276636 | 27276636 | PRJNA879067_P_NODE_17703_length_1096_cov_18.576735_g14917_i0 | PRJNA879067 | 17703 | 1096 | 18.576735 | 203.6010156 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 444 | 4.39e-154 | NR | MEZ4548516.1 | 2202153 | g14917 | i0 | 82.7 | 0.695255474452555 | 254 | 44 | 69.5 | 0 | 764 | 3 | 19 | 272 | MEZ4548516.1 cyclase family protein [Thermodesulfobacteriota bacterium] | diamond | 762 | 444 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 27663700 | 27663700 | PRJNA879067_P_NODE_27744_length_808_cov_2.400000_g24494_i0 | PRJNA879067 | 27744 | 808 | 2.4 | 19.392 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 245 | 2.62e-77 | NR | OQX22780.1 | 1934248 | g24494 | i0 | 49.8 | 4.59282178217822 | 255 | 123 | 93.2 | 2 | 763 | 11 | 2 | 255 | OQX22780.1 MAG: hypothetical protein BWK80_29385 [Desulfobacteraceae bacterium IS3] | diamond | 3711 | 246 | 0.995934959349594 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium IS3 | |||
| 29297365 | 29297365 | PRJNA879067_P_NODE_102989_length_251_cov_1.297753_g99503_i0 | PRJNA879067 | 102989 | 251 | 1.297753 | 3.25736003 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 134 | 6.65e-39 | NR | MCC6713473.1 | 2080303 | g99503 | i0 | 97.1 | 0.812749003984064 | 68 | 2 | 81.3 | 0 | 3 | 206 | 28 | 95 | MCC6713473.1 co-chaperone GroES [Candidatus Dadabacteria bacterium] | diamond | 204 | 134 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 29644272 | 29644272 | PRJNA879067_P_NODE_36850_length_661_cov_3.959184_g33431_i0 | PRJNA879067 | 36850 | 661 | 3.959184 | 26.17020624 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 245 | 3.9000000000000005e-80 | NR | MCC6713440.1 | 2080303 | g33431 | i0 | 93.1 | 0.590015128593041 | 130 | 9 | 59 | 0 | 401 | 12 | 1 | 130 | MCC6713440.1 30S ribosomal protein S9 [Candidatus Dadabacteria bacterium] | diamond | 390 | 245 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 30213102 | 30213102 | PRJNA879067_P_NODE_108152_length_244_cov_2.701754_g104666_i0 | PRJNA879067 | 108152 | 244 | 2.701754 | 6.59227976 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 138 | 1.05e-39 | NR | MCL4244700.1 | 2080303 | g104666 | i0 | 87.5 | 1.9672131147541 | 80 | 10 | 98.4 | 0 | 242 | 3 | 30 | 109 | MCL4244700.1 hypothetical protein [Candidatus Dadabacteria bacterium] | diamond | 480 | 138 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 30403255 | 30403255 | PRJNA879067_P_NODE_54733_length_487_cov_2.898551_g51248_i0 | PRJNA879067 | 54733 | 487 | 2.898551 | 14.11594337 | Geobacteraceae bacterium | 2282154 | Bacteria | Bacteria | 73.2 | 9.74e-13 | NR | HTP66667.1 | 2282154 | g51248 | i0 | 34.4 | 0.788501026694045 | 128 | 81 | 78.9 | 2 | 485 | 102 | 13 | 137 | HTP66667.1 ACT domain-containing protein [Geobacteraceae bacterium] | diamond | 384 | 73.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacteraceae bacterium | |||
| 30497692 | 30497692 | PRJNA879067_P_NODE_77493_length_350_cov_1.960289_g74007_i0 | PRJNA879067 | 77493 | 350 | 1.960289 | 6.8610115 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 125 | 9.71e-34 | NR | MCL4244011.1 | 2080303 | g74007 | i0 | 86.7 | 0.642857142857143 | 75 | 10 | 64.3 | 0 | 80 | 304 | 1 | 75 | MCL4244011.1 hypothetical protein [Candidatus Dadabacteria bacterium] | diamond | 225 | 125 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 31793431 | 31793431 | PRJNA879067_P_NODE_58677_length_458_cov_6.322078_g55192_i0 | PRJNA879067 | 58677 | 458 | 6.322078 | 28.95511724 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 238 | 1.75e-75 | NR | MCL4244852.1 | 2080303 | g55192 | i0 | 84.7 | 0.897379912663755 | 137 | 21 | 89.7 | 0 | 24 | 434 | 188 | 324 | MCL4244852.1 hypothetical protein [Candidatus Dadabacteria bacterium] | diamond | 411 | 238 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 31825105 | 31825105 | PRJNA879067_P_NODE_19617_length_1022_cov_10.813488_g16714_i0 | PRJNA879067 | 19617 | 1022 | 10.813488 | 110.51384736 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 597 | 1.4799999999999999e-204 | NR | HML95316.1 | 2202153 | g16714 | i0 | 92.2 | 1.96086105675147 | 334 | 25 | 97.7 | 1 | 24 | 1022 | 146 | 479 | HML95316.1 MXAN_5808 family serine peptidase [Thermodesulfobacteriota bacterium] | diamond | 2004 | 597 | 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);;