contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA1249042" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26820673 | 26820673 | PRJNA1249042_S_NODE_34261_length_233_cov_3.036842_g34047_i0 | PRJNA1249042 | 34261 | 233 | 3.036842 | 7.07584186 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 43.5 | 0.0138 | NR | GJM17366.1 | 2202153 | g34047 | i0 | 34.8 | 0.849785407725322 | 66 | 43 | 85 | 0 | 227 | 30 | 2 | 67 | GJM17366.1 MAG: hypothetical protein DHS20C13_26930 [Thermodesulfobacteriota bacterium] | diamond | 198 | 43.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 27547571 | 27547571 | PRJNA1249042_S_NODE_116004_length_151_cov_0.888889_g115790_i0 | PRJNA1249042 | 116004 | 151 | 0.888889 | 1.34222239 | Desulfobacter hydrogenophilus | 2291 | Bacteria | Bacteria | 99.4 | 1.0499999999999999e-23 | NR | WP_111960685.1 | 2291 | g115790 | i0 | 98 | 0.993377483443709 | 50 | 1 | 99.3 | 0 | 151 | 2 | 137 | 186 | WP_111960685.1 SHOCT domain-containing protein [Desulfobacter hydrogenophilus] | diamond | 150 | 99.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacter | Desulfobacter hydrogenophilus | ||
| 28305357 | 28305357 | PRJNA1249042_S_NODE_7406_length_334_cov_2.522337_g7192_i0 | PRJNA1249042 | 7406 | 334 | 2.522337 | 8.42460558 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 42.7 | 0.0438 | NR | RJQ84504.1 | 2049433 | g7192 | i0 | 37.7 | 0.476047904191617 | 53 | 33 | 47.6 | 0 | 302 | 144 | 3 | 55 | RJQ84504.1 MAG: YcgN family cysteine cluster protein [Desulfobacteraceae bacterium] | diamond | 159 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 29378904 | 29378904 | PRJNA1249042_S_NODE_28689_length_244_cov_2.084577_g28475_i0 | PRJNA1249042 | 28689 | 244 | 2.084577 | 5.08636788 | Trichloromonas sp. | 3069249 | Bacteria | Bacteria | 42.7 | 0.0387 | NR | MDX9708327.1 | 3069249 | g28475 | i0 | 35.1 | 0.700819672131147 | 57 | 37 | 70.1 | 0 | 171 | 1 | 803 | 859 | MDX9708327.1 response regulator [Trichloromonas sp.] | diamond | 171 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Trichloromonadaceae | Trichloromonas | Trichloromonas sp. | ||
| 29978877 | 29978877 | PRJNA1249042_S_NODE_55551_length_203_cov_2.350000_g55337_i0 | PRJNA1249042 | 55551 | 203 | 2.35 | 4.7705 | Mailhella sp. | 1981029 | Bacteria | Bacteria | 130 | 2.71e-36 | NR | MBO4318236.1 | 1981029 | g55337 | i0 | 86.6 | 0.990147783251232 | 67 | 9 | 99 | 0 | 203 | 3 | 19 | 85 | MBO4318236.1 ABC transporter ATP-binding protein [Mailhella sp.] | diamond | 201 | 130 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Mailhella | Mailhella sp. | ||
| 31970191 | 31970191 | PRJNA1249042_S_NODE_86138_length_172_cov_3.131783_g85924_i0 | PRJNA1249042 | 86138 | 172 | 3.131783 | 5.38666676 | Desulfovibrio sp. | 885 | Bacteria | Bacteria | 108 | 4.91e-26 | NR | MBQ2515633.1 | 885 | g85924 | i0 | 91.2 | 0.994186046511628 | 57 | 5 | 99.4 | 0 | 172 | 2 | 350 | 406 | MBQ2515633.1 DNA polymerase [Desulfovibrio sp.] | diamond | 171 | 108 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. | ||
| 32065104 | 32065104 | PRJNA1249042_S_NODE_24018_length_254_cov_2.004739_g23804_i0 | PRJNA1249042 | 24018 | 254 | 2.004739 | 5.09203706 | Smithellaceae bacterium | 2964540 | Bacteria | Bacteria | 138 | 5.71e-40 | NR | HLZ18954.1 | 2964540 | g23804 | i0 | 76.2 | 2.97637795275591 | 84 | 20 | 99.2 | 0 | 252 | 1 | 14 | 97 | HLZ18954.1 GNAT family N-acetyltransferase [Smithellaceae bacterium] | diamond | 756 | 138 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Smithellaceae | Smithellaceae bacterium | |||
| 32318600 | 32318600 | PRJNA1249042_S_NODE_28259_length_245_cov_1.628713_g28045_i0 | PRJNA1249042 | 28259 | 245 | 1.628713 | 3.99034685 | Desulfobacter sp. | 2294 | Bacteria | Bacteria | 42.4 | 0.0389 | NR | WDP88703.1 | 2294 | g28045 | i0 | 35.1 | 0.697959183673469 | 57 | 35 | 69.8 | 1 | 234 | 64 | 86 | 140 | WDP88703.1 MAG: hypothetical protein HUN04_02700 [Desulfobacter sp.] | diamond | 171 | 42.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacter | Desulfobacter 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);;