contig_metadata
9 rows where bioproject = "PRJNA382558" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8058182 | 8058182 | PRJNA382558_S_NODE_3027_length_242_cov_6.814634_g3023_i0 | PRJNA382558 | 3027 | 242 | 6.814634 | 16.49141428 | Pelobacter propionicus | 29543 | Bacteria | Bacteria | 99 | 2.76e-16 | NTclustered | gi|118501159|gb|CP000482.1| | 338966 | g3023 | i0 | 82.258 | 0.512396694214876 | 124 | 12 | 49 | 6 | 17 | 135 | 1952398 | 1952280 | Pelobacter propionicus DSM 2379, complete genome | blastn | 124 | 99 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Pelobacter | Pelobacter propionicus | ||
| 23357006 | 23357006 | PRJNA382558_S_NODE_4259_length_221_cov_6.896739_g4255_i0 | PRJNA382558 | 4259 | 221 | 6.896739 | 15.24179319 | Desulfobacula sp. | 2593537 | Bacteria | Bacteria | 138 | 1.0799999999999998e-37 | NR | MDA3787935.1 | 2593537 | g4255 | i0 | 88.9 | 13.6696832579186 | 72 | 8 | 97.7 | 0 | 3 | 218 | 21 | 92 | MDA3787935.1 GDP-mannose 4,6-dehydratase [Desulfobacula sp.] | diamond | 3021 | 138 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacula | Desulfobacula sp. | ||
| 24631201 | 24631201 | PRJNA382558_S_NODE_13280_length_158_cov_8.925620_g13276_i0 | PRJNA382558 | 13280 | 158 | 8.92562 | 14.1024796 | Desulfobacteraceae bacterium 4572_187 | 1971620 | Bacteria | Bacteria | 67 | 3.19e-11 | NR | OQY09568.1 | 1971620 | g13276 | i0 | 56.9 | 3.53164556962025 | 51 | 16 | 85.4 | 1 | 20 | 154 | 411 | 461 | OQY09568.1 MAG: hypothetical protein B6I30_09665 [Desulfobacteraceae bacterium 4572_187] | diamond | 558 | 67 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium 4572_187 | |||
| 28338501 | 28338501 | PRJNA382558_S_NODE_7866_length_185_cov_9.641892_g7862_i0 | PRJNA382558 | 7866 | 185 | 9.641892 | 17.8375002 | Desulfuromonadales bacterium | 2099678 | Bacteria | Bacteria | 55.5 | 4.46e-8 | NR | MCK4508898.1 | 2099678 | g7862 | i0 | 48 | 1.60540540540541 | 50 | 25 | 79.5 | 1 | 165 | 19 | 44 | 93 | MCK4508898.1 hypothetical protein [Desulfuromonadales bacterium] | diamond | 297 | 55.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadales bacterium | ||||
| 28369952 | 28369952 | PRJNA382558_S_NODE_11686_length_165_cov_5.109375_g11682_i0 | PRJNA382558 | 11686 | 165 | 5.109375 | 8.43046875 | Geobacteraceae bacterium | 2282154 | Bacteria | Bacteria | 41.6 | 0.0219 | NR | MDD2320802.1 | 2282154 | g11682 | i0 | 35.8 | 0.963636363636364 | 53 | 34 | 96.4 | 0 | 1 | 159 | 88 | 140 | MDD2320802.1 hypothetical protein [Geobacteraceae bacterium] | diamond | 159 | 41.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacteraceae bacterium | |||
| 32383054 | 32383054 | PRJNA382558_S_NODE_6959_length_192_cov_7.380645_g6955_i0 | PRJNA382558 | 6959 | 192 | 7.380645 | 14.1708384 | Trichlorobacter lovleyi | 313985 | Bacteria | Bacteria | 57.4 | 1.13e-7 | NR | WP_265555564.1 | 313985 | g6955 | i0 | 53.4 | 0.90625 | 58 | 27 | 90.6 | 0 | 8 | 181 | 252 | 309 | WP_265555564.1 hypothetical protein [Trichlorobacter lovleyi] | diamond | 174 | 57.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Trichlorobacter | Trichlorobacter lovleyi | ||
| 32541549 | 32541549 | PRJNA382558_S_NODE_679_length_347_cov_9.941935_g675_i0 | PRJNA382558 | 679 | 347 | 9.941935 | 34.49851445 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 44.3 | 0.0295 | NR | MCL4243911.1 | 2080303 | g675 | i0 | 31.7 | 0.544668587896254 | 63 | 38 | 54.5 | 1 | 242 | 54 | 43 | 100 | MCL4243911.1 pentapeptide repeat-containing protein [Candidatus Dadabacteria bacterium] | diamond | 189 | 44.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 32684061 | 32684061 | PRJNA382558_S_NODE_4260_length_221_cov_6.885870_g4256_i0 | PRJNA382558 | 4260 | 221 | 6.88587 | 15.2177727 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 59.7 | 2.71e-8 | NR | MDD4457013.1 | 29542 | g4256 | i0 | 46.9 | 1.38461538461538 | 64 | 30 | 81.4 | 2 | 185 | 6 | 33 | 96 | MDD4457013.1 phosphoadenosine phosphosulfate reductase family protein [Syntrophotalea acetylenica] | diamond | 306 | 60.1 | 0.993344425956739 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Syntrophotaleaceae | Syntrophotalea | Syntrophotalea acetylenica | ||
| 32793034 | 32793034 | PRJNA382558_S_NODE_240_length_443_cov_7.778325_g236_i0 | PRJNA382558 | 240 | 443 | 7.778325 | 34.45797975 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 90.1 | 1.01e-17 | NR | MEW6290971.1 | 2202153 | g236 | i0 | 52.4 | 0.55530474040632 | 82 | 39 | 55.5 | 0 | 258 | 13 | 1280 | 1361 | MEW6290971.1 RHS repeat-associated core domain-containing protein [Thermodesulfobacteriota bacterium] | diamond | 246 | 90.1 | 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);;