contig_metadata
14 rows where bioproject = "PRJNA908278", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 890191 | 890191 | PRJNA908278_P_NODE_1541_length_877_cov_11.643035_g1459_i0 | PRJNA908278 | 1541 | 877 | 11.643035 | 102.10941695 | uncultured Desulfobacter sp. | 240139 | Bacteria | Bacteria | 60.2 | 5.28e-4 | NTclustered | gi|2814788332|emb|OY762228.2| | 240139 | g1459 | i0 | 97.143 | 0.0399087799315849 | 35 | 1 | 4 | 0 | 538 | 572 | 3980971 | 3980937 | MAG: uncultured Desulfobacter sp. isolate cd87f30c-30a5-471b-81aa-180dc00a34f5 genome assembly, chromosome: 1 | blastn | 35 | 60.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacter | uncultured Desulfobacter sp. | ||
| 4718971 | 4718971 | PRJNA908278_P_NODE_6184_length_471_cov_4.412060_g6081_i0 | PRJNA908278 | 6184 | 471 | 4.41206 | 20.7808026 | Pseudodesulfovibrio sp. zrk46 | 2725288 | Bacteria | Bacteria | 60.2 | 2.74e-4 | NTclustered | gi|1832582227|gb|CP051216.1| | 2725288 | g6081 | i0 | 94.872 | 0.719745222929936 | 39 | 1 | 8 | 1 | 250 | 288 | 470351 | 470388 | Pseudodesulfovibrio sp. zrk46 chromosome, complete genome | blastn | 339 | 60.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Pseudodesulfovibrio | Pseudodesulfovibrio sp. zrk46 | ||
| 9818029 | 9818029 | PRJNA908278_P_NODE_12748_length_347_cov_1.401460_g12645_i0 | PRJNA908278 | 12748 | 347 | 1.40146 | 4.8630662 | root | 1 | Root_unresolved | Root_unresolved | 154 | 4.52e-42 | NR | WP_092345590.1 | 37625 | g12645 | i0 | 74.3 | 7.91066282420749 | 101 | 25 | 87.3 | 1 | 1 | 303 | 380 | 479 | WP_092345590.1 adenosylhomocysteinase [Desulfuromusa kysingii] | diamond | 2745 | 155 | 0.993548387096774 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Geopsychrobacteraceae | Desulfuromusa | Desulfuromusa kysingii | ||
| 11093724 | 11093724 | PRJNA908278_P_NODE_10229_length_379_cov_1.241830_g10126_i0 | PRJNA908278 | 10229 | 379 | 1.24183 | 4.7065357 | Desulfovibrio subterraneus | 2718620 | Bacteria | Bacteria | 135 | 7.72e-34 | NR | WP_174405317.1 | 2718620 | g10126 | i0 | 59.5 | 7.95514511873351 | 126 | 45 | 99.7 | 1 | 378 | 1 | 481 | 600 | WP_174405317.1 ATP-dependent chaperone ClpB [Desulfovibrio subterraneus] | diamond | 3015 | 135 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio subterraneus | ||
| 26683519 | 26683519 | PRJNA908278_P_NODE_11901_length_357_cov_1.341549_g11798_i0 | PRJNA908278 | 11901 | 357 | 1.341549 | 4.78932993 | Desulfosalsimonas | 377149 | Bacteria | Bacteria | 48.9 | 1.79e-4 | NR | WP_220128339.1 | 332175 | g11798 | i0 | 31.1 | 2.23529411764706 | 74 | 50 | 61.3 | 1 | 298 | 80 | 21 | 94 | WP_220128339.1 DUF1330 domain-containing protein [Desulfosalsimonas propionicica] | diamond | 798 | 48.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosalsimonadaceae | Desulfosalsimonas | Desulfosalsimonas propionicica | ||
| 29424200 | 29424200 | PRJNA908278_P_NODE_19569_length_290_cov_1.170507_g19466_i0 | PRJNA908278 | 19569 | 290 | 1.170507 | 3.3944703 | Malonomonas sp. | 3050478 | Bacteria | Bacteria | 52.4 | 2.55e-5 | NR | HEY5673455.1 | 3050478 | g19466 | i0 | 40 | 1.30344827586207 | 70 | 38 | 68.3 | 2 | 91 | 288 | 20 | 89 | HEY5673455.1 ATP-binding protein [Malonomonas sp.] | diamond | 378 | 52.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Geopsychrobacteraceae | Malonomonas | Malonomonas sp. | ||
| 30474364 | 30474364 | PRJNA908278_P_NODE_35573_length_241_cov_0.916667_g35470_i0 | PRJNA908278 | 35573 | 241 | 0.916667 | 2.20916747 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 99.4 | 1.3e-22 | NR | WP_035239590.1 | 34031 | g35470 | i0 | 57 | 3.93360995850622 | 79 | 34 | 98.3 | 0 | 239 | 3 | 268 | 346 | WP_035239590.1 2-aminoethylphosphonate--pyruvate transaminase [Desulfobacter vibrioformis] | diamond | 948 | 100 | 0.994 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacter | Desulfobacter vibrioformis | ||
| 30814270 | 30814270 | PRJNA908278_P_NODE_574_length_1265_cov_2.537752_g529_i0 | PRJNA908278 | 574 | 1265 | 2.537752 | 32.1025628 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 59.7 | 3.13e-6 | NR | GJM17643.1 | 2202153 | g529 | i0 | 41.1 | 0.173122529644269 | 73 | 43 | 17.3 | 0 | 1055 | 837 | 141 | 213 | GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] | diamond | 219 | 59.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 31067279 | 31067279 | PRJNA908278_P_NODE_9075_length_398_cov_1.861538_g8972_i0 | PRJNA908278 | 9075 | 398 | 1.861538 | 7.40892124 | Desulfacinum infernum | 35837 | Bacteria | Bacteria | 96.7 | 2.55e-20 | NR | WP_073039723.1 | 35837 | g8972 | i0 | 46.2 | 2.51005025125628 | 104 | 56 | 78.4 | 0 | 313 | 2 | 24 | 127 | WP_073039723.1 NADP-dependent glyceraldehyde-3-phosphate dehydrogenase [Desulfacinum infernum] | diamond | 999 | 96.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Desulfacinum | Desulfacinum infernum | ||
| 31359179 | 31359179 | PRJNA908278_P_NODE_2516_length_706_cov_2.856240_g2417_i0 | PRJNA908278 | 2516 | 706 | 2.85624 | 20.1650544 | Geobacter | 28231 | Bacteria | Bacteria | 134 | 8.459999999999998e-35 | NR | RII25625.1 | 46610 | g2417 | i0 | 39.8 | 1.52549575070822 | 181 | 107 | 76.1 | 1 | 24 | 560 | 41 | 221 | RII25625.1 MAG: CAP domain-containing protein [Geobacter sp.] | diamond | 1077 | 135 | 0.992592592592593 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sp. | ||
| 32205753 | 32205753 | PRJNA908278_P_NODE_33058_length_244_cov_0.900585_g32955_i0 | PRJNA908278 | 33058 | 244 | 0.900585 | 2.1974274 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 49.7 | 1.32e-4 | NR | MEE8423992.1 | 2202153 | g32955 | i0 | 35.8 | 0.995901639344262 | 81 | 48 | 99.6 | 1 | 243 | 1 | 253 | 329 | MEE8423992.1 VWA domain-containing protein [Thermodesulfobacteriota bacterium] | diamond | 243 | 49.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 32554086 | 32554086 | PRJNA908278_P_NODE_9879_length_384_cov_2.787781_g9776_i0 | PRJNA908278 | 9879 | 384 | 2.787781 | 10.70507904 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 46.6 | 0.0065 | NR | MEW6298056.1 | 2202153 | g9776 | i0 | 31.6 | 0.59375 | 76 | 50 | 59.4 | 1 | 249 | 22 | 207 | 280 | MEW6298056.1 hypothetical protein [Thermodesulfobacteriota bacterium] | diamond | 228 | 46.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 32742847 | 32742847 | PRJNA908278_P_NODE_11760_length_359_cov_0.877622_g11657_i0 | PRJNA908278 | 11760 | 359 | 0.877622 | 3.15066298 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 46.2 | 0.00792 | NR | MCD4764364.1 | 2044940 | g11657 | i0 | 28.5 | 1.31197771587744 | 123 | 75 | 94.4 | 3 | 357 | 19 | 191 | 310 | MCD4764364.1 SDR family NAD(P)-dependent oxidoreductase [Desulfobacterales bacterium] | diamond | 471 | 46.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 32750158 | 32750158 | PRJNA908278_P_NODE_18840_length_295_cov_1.139640_g18737_i0 | PRJNA908278 | 18840 | 295 | 1.13964 | 3.361938 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 75.5 | 2.15e-13 | NR | VBB41500.1 | 1748965 | g18737 | i0 | 39.6 | 24.7322033898305 | 101 | 54 | 95.6 | 2 | 13 | 294 | 101 | 201 | VBB41500.1 ATP-dependent zinc metalloprotease FtsH [uncultured Desulfatiglans sp.] | diamond | 7296 | 75.9 | 0.994729907773386 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfatiglandales | Desulfatiglandaceae | Desulfatiglans | uncultured Desulfatiglans 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);;