contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA773778" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 751631 | 751631 | PRJNA773778_S_NODE_6861_length_494_cov_1.741093_g6711_i0 | PRJNA773778 | 6861 | 494 | 1.741093 | 8.60099942 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 262 | 2.3e-87 | NR | OIQ01360.1 | 1805379 | g6711 | i0 | 80.8 | 4.44534412955466 | 146 | 28 | 88.7 | 0 | 493 | 56 | 2 | 147 | OIQ01360.1 MAG: adenylyl-sulfate reductase subunit beta [Syntrophobacteraceae bacterium CG2_30_61_12] | diamond | 2196 | 263 | 0.996197718631179 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Syntrophobacteraceae bacterium CG2_30_61_12 | |||
| 13505074 | 13505074 | PRJNA773778_S_NODE_39411_length_253_cov_1.283333_g39261_i0 | PRJNA773778 | 39411 | 253 | 1.283333 | 3.24683249 | Desulforhabdus amnigena | 40218 | Bacteria | Bacteria | 120 | 2.95e-30 | NR | WP_281793436.1 | 40218 | g39261 | i0 | 88.1 | 3.94861660079051 | 67 | 8 | 79.4 | 0 | 203 | 3 | 1 | 67 | WP_281793436.1 ADP-forming succinate--CoA ligase subunit beta [Desulforhabdus amnigena] | diamond | 999 | 120 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Desulforhabdus | Desulforhabdus amnigena | ||
| 23704188 | 23704188 | PRJNA773778_S_NODE_36919_length_260_cov_1.647059_g36769_i0 | PRJNA773778 | 36919 | 260 | 1.647059 | 4.2823534 | Desulforhabdus sp. TSK | 2925014 | Bacteria | Bacteria | 159 | 1.33e-43 | NR | WP_244083089.1 | 2925014 | g36769 | i0 | 84.9 | 0.992307692307692 | 86 | 13 | 99.2 | 0 | 3 | 260 | 364 | 449 | WP_244083089.1 adenylyl-sulfate reductase subunit alpha [Desulforhabdus sp. TSK] | diamond | 258 | 159 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Desulforhabdus | Desulforhabdus sp. TSK | ||
| 26958230 | 26958230 | PRJNA773778_S_NODE_43562_length_247_cov_0.885057_g43412_i0 | PRJNA773778 | 43562 | 247 | 0.885057 | 2.18609079 | Oceanidesulfovibrio indonesiensis | 54767 | Bacteria | Bacteria | 115 | 6.03e-30 | NR | WP_144303334.1 | 54767 | g43412 | i0 | 68.3 | 0.995951417004049 | 82 | 26 | 99.6 | 0 | 246 | 1 | 1 | 82 | WP_144303334.1 F0F1 ATP synthase subunit A [Oceanidesulfovibrio indonesiensis] | diamond | 246 | 115 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Oceanidesulfovibrio | Oceanidesulfovibrio indonesiensis | ||
| 27568277 | 27568277 | PRJNA773778_S_NODE_19724_length_331_cov_0.988372_g19574_i0 | PRJNA773778 | 19724 | 331 | 0.988372 | 3.27151132 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 155 | 1.36e-45 | NR | WP_211236397.1 | 102109 | g19574 | i0 | 63.6 | 5.87311178247734 | 110 | 40 | 99.7 | 0 | 2 | 331 | 10 | 119 | WP_211236397.1 RNA-guided endonuclease InsQ/TnpB family protein, partial [Desulfovibrio inopinatus] | diamond | 1944 | 155 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio inopinatus | ||
| 27717172 | 27717172 | PRJNA773778_S_NODE_22984_length_313_cov_0.962500_g22834_i0 | PRJNA773778 | 22984 | 313 | 0.9625 | 3.012625 | Desulforhabdus amnigena | 40218 | Bacteria | Bacteria | 205 | 2.67e-60 | NR | WP_281793507.1 | 40218 | g22834 | i0 | 94.2 | 0.987220447284345 | 103 | 6 | 98.7 | 0 | 311 | 3 | 176 | 278 | WP_281793507.1 pyruvate carboxylase subunit B [Desulforhabdus amnigena] | diamond | 309 | 205 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Desulforhabdus | Desulforhabdus amnigena | ||
| 27717176 | 27717176 | PRJNA773778_S_NODE_43204_length_247_cov_1.327586_g43054_i0 | PRJNA773778 | 43204 | 247 | 1.327586 | 3.27913742 | Desulfosarcina cetonica | 90730 | Bacteria | Bacteria | 135 | 3.56e-38 | NR | WP_083456717.1 | 90730 | g43054 | i0 | 84.1 | 3.98380566801619 | 82 | 13 | 99.6 | 0 | 247 | 2 | 39 | 120 | WP_083456717.1 DUF3343 domain-containing protein [Desulfosarcina cetonica] | diamond | 984 | 135 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosarcinaceae | Desulfosarcina | Desulfosarcina cetonica | ||
| 28979901 | 28979901 | PRJNA773778_S_NODE_13088_length_388_cov_1.466667_g12938_i0 | PRJNA773778 | 13088 | 388 | 1.466667 | 5.69066796 | Syntrophobacteraceae bacterium | 2052185 | Bacteria | Bacteria | 162 | 9e-48 | NR | HBZ55111.1 | 2052185 | g12938 | i0 | 78.9 | 2.52835051546392 | 109 | 23 | 84.3 | 0 | 329 | 3 | 1 | 109 | HBZ55111.1 sodium-translocating pyrophosphatase [Syntrophobacteraceae bacterium] | diamond | 981 | 162 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Syntrophobacteraceae bacterium | |||
| 29547855 | 29547855 | PRJNA773778_S_NODE_45070_length_245_cov_0.895349_g44920_i0 | PRJNA773778 | 45070 | 245 | 0.895349 | 2.19360505 | Syntrophobacteraceae bacterium | 2052185 | Bacteria | Bacteria | 159 | 3.8299999999999995e-45 | NR | MCU0586750.1 | 2052185 | g44920 | i0 | 93.8 | 1.98367346938776 | 81 | 5 | 99.2 | 0 | 3 | 245 | 166 | 246 | MCU0586750.1 sulfate adenylyltransferase [Syntrophobacteraceae bacterium] | diamond | 486 | 159 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Syntrophobacteraceae bacterium | |||
| 29841750 | 29841750 | PRJNA773778_S_NODE_42911_length_248_cov_0.880000_g42761_i0 | PRJNA773778 | 42911 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 85.5 | 5.12e-18 | NR | WP_051617167.1 | 53245 | g42761 | i0 | 69.5 | 7.76612903225806 | 59 | 18 | 71.4 | 0 | 178 | 2 | 1 | 59 | WP_051617167.1 sulfurtransferase TusA family protein [Desulfonatronovibrio hydrogenovorans] | diamond | 1926 | 86.3 | 0.990730011587486 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfonatronovibrionaceae | Desulfonatronovibrio | Desulfonatronovibrio hydrogenovorans | ||
| 30306592 | 30306592 | PRJNA773778_S_NODE_26732_length_296_cov_1.035874_g26582_i0 | PRJNA773778 | 26732 | 296 | 1.035874 | 3.06618704 | Desulforhabdus amnigena | 40218 | Bacteria | Bacteria | 78.2 | 6.93e-15 | NR | WP_281792770.1 | 40218 | g26582 | i0 | 76 | 0.993243243243243 | 50 | 10 | 48.6 | 1 | 146 | 3 | 1 | 50 | WP_281792770.1 4Fe-4S dicluster domain-containing protein [Desulforhabdus amnigena] | diamond | 294 | 78.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Desulforhabdus | Desulforhabdus amnigena | ||
| 30369780 | 30369780 | PRJNA773778_S_NODE_38252_length_256_cov_1.677596_g38102_i0 | PRJNA773778 | 38252 | 256 | 1.677596 | 4.29464576 | Solidesulfovibrio fructosivorans | 878 | Bacteria | Bacteria | 153 | 2.05e-45 | NR | WP_336884663.1 | 878 | g38102 | i0 | 98.8 | 0.97265625 | 83 | 1 | 97.3 | 0 | 6 | 254 | 49 | 131 | WP_336884663.1 DUF5320 domain-containing protein [Solidesulfovibrio fructosivorans] | diamond | 249 | 153 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Solidesulfovibrio | Solidesulfovibrio fructosivorans | ||
| 30906628 | 30906628 | PRJNA773778_S_NODE_32054_length_276_cov_1.118227_g31904_i0 | PRJNA773778 | 32054 | 276 | 1.118227 | 3.08630652 | Desulforhabdus amnigena | 40218 | Bacteria | Bacteria | 120 | 1.76e-29 | NR | WP_281793124.1 | 40218 | g31904 | i0 | 83.8 | 0.739130434782609 | 68 | 11 | 73.9 | 0 | 273 | 70 | 450 | 517 | WP_281793124.1 acyl-CoA carboxylase subunit beta [Desulforhabdus amnigena] | diamond | 204 | 120 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Desulforhabdus | Desulforhabdus amnigena | ||
| 31033108 | 31033108 | PRJNA773778_S_NODE_44355_length_246_cov_0.890173_g44205_i0 | PRJNA773778 | 44355 | 246 | 0.890173 | 2.18982558 | Desulfatiglans anilini | 90728 | Bacteria | Bacteria | 55.8 | 2.22e-8 | NR | WP_153306080.1 | 90728 | g44205 | i0 | 65.9 | 0.5 | 41 | 14 | 50 | 0 | 1 | 123 | 8 | 48 | WP_153306080.1 paeninodin family lasso peptide [Desulfatiglans anilini] | diamond | 123 | 55.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfatiglandales | Desulfatiglandaceae | Desulfatiglans | Desulfatiglans anilini | ||
| 31095902 | 31095902 | PRJNA773778_S_NODE_39775_length_252_cov_1.290503_g39625_i0 | PRJNA773778 | 39775 | 252 | 1.290503 | 3.25206756 | Desulforhabdus amnigena | 40218 | Bacteria | Bacteria | 159 | 7.160000000000001e-44 | NR | WP_281792768.1 | 40218 | g39625 | i0 | 88.1 | 3 | 84 | 10 | 100 | 0 | 252 | 1 | 228 | 311 | WP_281792768.1 FAD-binding protein [Desulforhabdus amnigena] | diamond | 756 | 159 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Desulforhabdus | Desulforhabdus amnigena | ||
| 31854937 | 31854937 | PRJNA773778_S_NODE_35377_length_265_cov_1.203125_g35227_i0 | PRJNA773778 | 35377 | 265 | 1.203125 | 3.18828125 | Desulforhabdus amnigena | 40218 | Bacteria | Bacteria | 162 | 7.579999999999999e-48 | NR | WP_281792770.1 | 40218 | g35227 | i0 | 87.5 | 0.99622641509434 | 88 | 11 | 99.6 | 0 | 264 | 1 | 146 | 233 | WP_281792770.1 4Fe-4S dicluster domain-containing protein [Desulforhabdus amnigena] | diamond | 264 | 162 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Desulforhabdus | Desulforhabdus amnigena | ||
| 31918297 | 31918297 | PRJNA773778_S_NODE_19597_length_331_cov_9.158915_g19447_i0 | PRJNA773778 | 19597 | 331 | 9.158915 | 30.31600865 | uncultured Desulfatiglans sp. | 1748965 | Bacteria | Bacteria | 106 | 8.64e-28 | NR | VBB41863.1 | 1748965 | g19447 | i0 | 98 | 0.444108761329305 | 49 | 1 | 44.4 | 0 | 183 | 329 | 1 | 49 | VBB41863.1 hypothetical protein TRIP_B200003 [uncultured Desulfatiglans sp.] | diamond | 147 | 106 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfatiglandales | Desulfatiglandaceae | Desulfatiglans | uncultured Desulfatiglans sp. | ||
| 32329946 | 32329946 | PRJNA773778_S_NODE_19919_length_330_cov_0.848249_g19769_i0 | PRJNA773778 | 19919 | 330 | 0.848249 | 2.7992217 | Desulforhabdus amnigena | 40218 | Bacteria | Bacteria | 82.8 | 1.39e-17 | NR | WP_281796250.1 | 40218 | g19769 | i0 | 82.6 | 0.845454545454545 | 46 | 8 | 41.8 | 0 | 325 | 188 | 93 | 138 | WP_281796250.1 50S ribosomal protein L16 [Desulforhabdus amnigena] | diamond | 279 | 82.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Desulforhabdus | Desulforhabdus amnigena | ||
| 32582824 | 32582824 | PRJNA773778_S_NODE_25639_length_300_cov_2.198238_g25489_i0 | PRJNA773778 | 25639 | 300 | 2.198238 | 6.594714 | Desulforhabdus amnigena | 40218 | Bacteria | Bacteria | 118 | 5.6e-32 | NR | WP_281794113.1 | 40218 | g25489 | i0 | 79.3 | 1.61 | 82 | 13 | 78 | 1 | 236 | 3 | 1 | 82 | WP_281794113.1 ATP synthase F0 subunit C [Desulforhabdus amnigena] | diamond | 483 | 118 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Desulforhabdus | Desulforhabdus amnigena | ||
| 32812472 | 32812472 | PRJNA773778_S_NODE_16500_length_354_cov_1.074733_g16350_i0 | PRJNA773778 | 16500 | 354 | 1.074733 | 3.80455482 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 129 | 5.37e-34 | NR | WP_281793435.1 | 40218 | g16350 | i0 | 85.9 | 1.20338983050847 | 71 | 10 | 60.2 | 0 | 140 | 352 | 1 | 71 | WP_281793435.1 succinate--CoA ligase subunit alpha [Desulforhabdus amnigena] | diamond | 426 | 129 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Desulforhabdus | Desulforhabdus amnigena | ||
| 32834477 | 32834477 | PRJNA773778_S_NODE_37820_length_258_cov_0.945946_g37670_i0 | PRJNA773778 | 37820 | 258 | 0.945946 | 2.44054068 | Syntrophobacter fumaroxidans | 119484 | Bacteria | Bacteria | 125 | 3.1199999999999997e-31 | NR | WP_011699833.1 | 119484 | g37670 | i0 | 80 | 0.988372093023256 | 85 | 17 | 98.8 | 0 | 3 | 257 | 259 | 343 | WP_011699833.1 sodium-translocating pyrophosphatase [Syntrophobacter fumaroxidans] | diamond | 255 | 125 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Syntrophobacter | Syntrophobacter fumaroxidans |
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);;