contig_metadata
8 rows where bioproject = "PRJNA608894", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10790161 | 10790161 | PRJNA608894_P_NODE_7729_length_988_cov_3.607650_g7329_i0 | PRJNA608894 | 7729 | 988 | 3.60765 | 35.643582 | Pseudodesulfovibrio piezophilus | 879567 | Bacteria | Bacteria | 69.4 | 9.94e-7 | NTclustered | gi|451894361|emb|FO203427.1| | 1322246 | g7329 | i0 | 78.992 | 2.80668016194332 | 119 | 11 | 11 | 10 | 112 | 220 | 2362018 | 2361904 | Desulfovibrio piezophilus C1TLV30 complete genome | blastn | 2773 | 69.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Pseudodesulfovibrio | Pseudodesulfovibrio piezophilus | ||
| 22262597 | 22262597 | PRJNA608894_P_NODE_38098_length_290_cov_1.705069_g37599_i0 | PRJNA608894 | 38098 | 290 | 1.705069 | 4.9447001 | Geobacter sp. FeAm09 | 2597769 | Bacteria | Bacteria | 285 | 2.43e-72 | NTclustered | gi|1735471693|gb|CP042466.1| | 2597769 | g37599 | i0 | 84.775 | 385.258620689655 | 289 | 39 | 100 | 5 | 1 | 287 | 692020 | 692305 | Geobacter sp. FeAm09 chromosome, complete genome | blastn | 111725 | 285 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sp. FeAm09 | ||
| 27459478 | 27459478 | PRJNA608894_P_NODE_8283_length_933_cov_2.708140_g7869_i0 | PRJNA608894 | 8283 | 933 | 2.70814 | 25.2669462 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 72.4 | 6.1e-11 | NR | GJM17643.1 | 2202153 | g7869 | i0 | 33.8 | 0.418006430868167 | 130 | 75 | 40.5 | 5 | 899 | 522 | 91 | 213 | GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] | diamond | 390 | 72.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 29574553 | 29574553 | PRJNA608894_P_NODE_18250_length_489_cov_3.487981_g17754_i0 | PRJNA608894 | 18250 | 489 | 3.487981 | 17.05622709 | uncultured Desulfuromusa sp. | 219183 | Bacteria | Bacteria | 49.7 | 0.00151 | NR | WP_321391052.1 | 219183 | g17754 | i0 | 38.6 | 0.429447852760736 | 70 | 42 | 42.9 | 1 | 392 | 183 | 325 | 393 | WP_321391052.1 PEP-CTERM-box response regulator transcription factor [uncultured Desulfuromusa sp.] | diamond | 210 | 49.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Geopsychrobacteraceae | Desulfuromusa | uncultured Desulfuromusa sp. | ||
| 29764038 | 29764038 | PRJNA608894_P_NODE_23091_length_407_cov_1.610778_g22594_i0 | PRJNA608894 | 23091 | 407 | 1.610778 | 6.55586646 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 54.7 | 6.96e-6 | NR | GJM17643.1 | 2202153 | g22594 | i0 | 39.2 | 0.582309582309582 | 79 | 47 | 57.5 | 1 | 374 | 141 | 134 | 212 | GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] | diamond | 237 | 54.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 31438875 | 31438875 | PRJNA608894_P_NODE_4296_length_1504_cov_2.380154_g4036_i0 | PRJNA608894 | 4296 | 1504 | 2.380154 | 35.79751616 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 56.2 | 6e-5 | NR | GJM17643.1 | 2202153 | g4036 | i0 | 34.2 | 0.157579787234043 | 79 | 51 | 15.6 | 1 | 1501 | 1268 | 134 | 212 | GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] | diamond | 237 | 56.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 32451590 | 32451590 | PRJNA608894_P_NODE_51699_length_249_cov_1.579545_g51200_i0 | PRJNA608894 | 51699 | 249 | 1.579545 | 3.93306705 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 59.7 | 4.16e-8 | NR | HAO22905.1 | 2049433 | g51200 | i0 | 36.3 | 0.963855421686747 | 80 | 51 | 96.4 | 0 | 3 | 242 | 293 | 372 | HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] | diamond | 240 | 59.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 32559677 | 32559677 | PRJNA608894_P_NODE_46479_length_261_cov_1.271277_g45980_i0 | PRJNA608894 | 46479 | 261 | 1.271277 | 3.31803297 | Bacteria | 2 | Bacteria | Bacteria | 103 | 2.52e-23 | NR | PLX86992.1 | 892 | g45980 | i0 | 57 | 37.5632183908046 | 86 | 37 | 98.9 | 0 | 3 | 260 | 496 | 581 | PLX86992.1 MAG: endopeptidase La [Desulfuromonas sp.] | diamond | 9804 | 103 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas 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);;