contig_metadata
10 rows where 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1629222 | 1629222 | PRJNA1249042_S_NODE_37222_length_228_cov_3.048649_g37008_i0 | PRJNA1249042 | 37222 | 228 | 3.048649 | 6.95091972 | Maridesulfovibrio sp. | 2795000 | Bacteria | Bacteria | 52.8 | 0.02 | NTclustered | gi|2621785158|emb|OY781616.1| | 2795000 | g37008 | i0 | 100 | 0.12280701754386 | 28 | 0 | 12 | 0 | 185 | 212 | 946982 | 946955 | MAG: Maridesulfovibrio sp. isolate 7570950b-8a73-422e-b528-09704edcd613 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Maridesulfovibrio | Maridesulfovibrio sp. | ||
| 15657174 | 15657174 | PRJNA1249042_S_NODE_13653_length_287_cov_3.618852_g13439_i0 | PRJNA1249042 | 13653 | 287 | 3.618852 | 10.38610524 | Desulfarculia bacterium | 3065862 | Bacteria | Bacteria | 204 | 6.919999999999999e-48 | NTclustered | gi|2621702698|emb|OY759590.1| | 3065862 | g13439 | i0 | 84.689 | 140.543554006969 | 209 | 27 | 72 | 5 | 78 | 285 | 335762 | 335558 | MAG: Desulfarculia bacterium isolate 49400898-fc5b-42b7-bef8-a303f8702bb8 genome assembly, chromosome: 1 | blastn | 40336 | 204 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Desulfarculia bacterium | |||||
| 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);;