contig_metadata
7 rows where bioproject = "PRJNA565778" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29335212 | 29335212 | PRJNA565778_S_NODE_37949_length_175_cov_2.826087_g37653_i0 | PRJNA565778 | 37949 | 175 | 2.826087 | 4.94565225 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 67 | 3.49e-11 | NR | WP_008870065.1 | 488939 | g37653 | i0 | 54.5 | 6.56571428571429 | 55 | 25 | 94.3 | 0 | 5 | 169 | 251 | 305 | WP_008870065.1 hypothetical protein [Desulfonatronospira thiodismutans] | diamond | 1149 | 67 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfonatronovibrionaceae | Desulfonatronospira | Desulfonatronospira thiodismutans | ||
| 30932627 | 30932627 | PRJNA565778_S_NODE_19834_length_248_cov_333.061611_g19538_i0 | PRJNA565778 | 19834 | 248 | 333.061611 | 825.99279528 | Smithella sp. | 2053614 | Bacteria | Bacteria | 88.2 | 1.14e-18 | NR | MEN6621319.1 | 2053614 | g19538 | i0 | 60 | 0.846774193548387 | 70 | 28 | 84.7 | 0 | 210 | 1 | 80 | 149 | MEN6621319.1 hypothetical protein [Smithella sp.] | diamond | 210 | 88.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Smithellaceae | Smithella | Smithella sp. | ||
| 30995834 | 30995834 | PRJNA565778_S_NODE_22814_length_232_cov_1.800000_g22518_i0 | PRJNA565778 | 22814 | 232 | 1.8 | 4.176 | Thermodesulfobacteriales bacterium | 2528040 | Bacteria | Bacteria | 50.8 | 4.37e-5 | NR | TFG75492.1 | 2528040 | g22518 | i0 | 38.6 | 1.47413793103448 | 57 | 35 | 73.7 | 0 | 4 | 174 | 251 | 307 | TFG75492.1 MAG: type IV pilus assembly protein PilM [Thermodesulfobacteriales bacterium] | diamond | 342 | 50.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteria | Thermodesulfobacteriales | Thermodesulfobacteriales bacterium | ||||
| 31596720 | 31596720 | PRJNA565778_S_NODE_12156_length_314_cov_9.985560_g11860_i0 | PRJNA565778 | 12156 | 314 | 9.98556 | 31.3546584 | Caldimicrobium sp. | 2024963 | Bacteria | Bacteria | 89 | 8.87e-20 | NR | NAZ30503.1 | 2024963 | g11860 | i0 | 64.6 | 0.621019108280255 | 65 | 23 | 62.1 | 0 | 309 | 115 | 101 | 165 | NAZ30503.1 hypothetical protein [Caldimicrobium sp.] | diamond | 195 | 89 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteria | Thermodesulfobacteriales | Thermodesulfobacteriaceae | Caldimicrobium | Caldimicrobium sp. | ||
| 31722926 | 31722926 | PRJNA565778_S_NODE_22937_length_231_cov_5.134021_g22641_i0 | PRJNA565778 | 22937 | 231 | 5.134021 | 11.85958851 | Thermodesulfobacterium commune | 1741 | Bacteria | Bacteria | 44.7 | 0.00298 | NR | WP_038062177.1 | 1741 | g22641 | i0 | 94.4 | 0.233766233766234 | 18 | 1 | 23.4 | 0 | 59 | 6 | 1 | 18 | WP_038062177.1 hypothetical protein [Thermodesulfobacterium commune] | diamond | 54 | 44.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteria | Thermodesulfobacteriales | Thermodesulfobacteriaceae | Thermodesulfobacterium | Thermodesulfobacterium commune | ||
| 32039408 | 32039408 | PRJNA565778_S_NODE_34658_length_185_cov_4.391892_g34362_i0 | PRJNA565778 | 34658 | 185 | 4.391892 | 8.1250002 | Smithella sp. | 2053614 | Bacteria | Bacteria | 52.8 | 5.33e-7 | NR | MEN6621307.1 | 2053614 | g34362 | i0 | 43.6 | 0.891891891891892 | 55 | 30 | 89.2 | 1 | 5 | 169 | 25 | 78 | MEN6621307.1 hypothetical protein [Smithella sp.] | diamond | 165 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Smithellaceae | Smithella | Smithella sp. | ||
| 32545834 | 32545834 | PRJNA565778_S_NODE_17679_length_263_cov_3.066372_g17383_i0 | PRJNA565778 | 17679 | 263 | 3.066372 | 8.06455836 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 81.6 | 8.03e-17 | NR | NIP30736.1 | 2080303 | g17383 | i0 | 62.7 | 1.57414448669202 | 67 | 25 | 76.4 | 0 | 45 | 245 | 7 | 73 | NIP30736.1 DUF2828 family protein [Candidatus Dadabacteria bacterium] | diamond | 414 | 81.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria 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);;