contig_metadata
9 rows where bioproject = "PRJNA756891" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13485775 | 13485775 | PRJNA756891_P_NODE_14131_length_246_cov_0.890173_g14062_i0 | PRJNA756891 | 14131 | 246 | 0.890173 | 2.18982558 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 187 | 5.839999999999998e-43 | NTclustered | gi|2108172456|gb|CP070716.1| | 2026742 | g14062 | i0 | 82.629 | 3 | 213 | 35 | 86 | 2 | 28 | 239 | 1846772 | 1846561 | MAG: Gemmatimonadetes bacterium isolate bin486 chromosome | blastn | 738 | 187 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 26989409 | 26989409 | PRJNA756891_P_NODE_14402_length_246_cov_0.890173_g14333_i0 | PRJNA756891 | 14402 | 246 | 0.890173 | 2.18982558 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 125 | 2.58e-33 | NR | HEV7367156.1 | 2448054 | g14333 | i0 | 86.3 | 0.975609756097561 | 80 | 11 | 97.6 | 0 | 241 | 2 | 200 | 279 | HEV7367156.1 DMT family transporter [Gemmatimonadales bacterium] | diamond | 240 | 125 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 27053019 | 27053019 | PRJNA756891_P_NODE_4442_length_399_cov_1.668712_g4373_i0 | PRJNA756891 | 4442 | 399 | 1.668712 | 6.65816088 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 110 | 9.23e-26 | NR | HVK00657.1 | 2448054 | g4373 | i0 | 60.9 | 13.5037593984962 | 92 | 34 | 67.7 | 2 | 110 | 379 | 3 | 94 | HVK00657.1 ferrochelatase [Gemmatimonadales bacterium] | diamond | 5388 | 110 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 27220543 | 27220543 | PRJNA756891_P_NODE_11002_length_264_cov_1.408377_g10933_i0 | PRJNA756891 | 11002 | 264 | 1.408377 | 3.71811528 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 103 | 1.55e-23 | NR | MEP7347511.1 | 2026741 | g10933 | i0 | 57.5 | 4.94318181818182 | 87 | 36 | 98.9 | 1 | 262 | 2 | 99 | 184 | MEP7347511.1 M28 family metallopeptidase [Gemmatimonadaceae bacterium] | diamond | 1305 | 104 | 0.990384615384615 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27748140 | 27748140 | PRJNA756891_P_NODE_12064_length_251_cov_0.865169_g11995_i0 | PRJNA756891 | 12064 | 251 | 0.865169 | 2.17157419 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 118 | 1.4499999999999998e-31 | NR | MEO6878498.1 | 2026741 | g11995 | i0 | 61.4 | 1.9840637450199201 | 83 | 32 | 99.2 | 0 | 2 | 250 | 56 | 138 | MEO6878498.1 carbonic anhydrase [Gemmatimonadaceae bacterium] | diamond | 498 | 118 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30589969 | 30589969 | PRJNA756891_P_NODE_16513_length_241_cov_0.916667_g16444_i0 | PRJNA756891 | 16513 | 241 | 0.916667 | 2.20916747 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 88.6 | 2.58e-18 | NR | MEQ1855688.1 | 2910168 | g16444 | i0 | 53.2 | 0.95850622406639 | 77 | 36 | 95.9 | 0 | 239 | 9 | 504 | 580 | MEQ1855688.1 3-hydroxyacyl-CoA dehydrogenase NAD-binding domain-containing protein [Longimicrobiales bacterium] | diamond | 231 | 88.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 31032648 | 31032648 | PRJNA756891_P_NODE_11715_length_255_cov_1.500000_g11646_i0 | PRJNA756891 | 11715 | 255 | 1.5 | 3.825 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 56.2 | 4.33e-7 | NR | UCF41094.1 | 2026742 | g11646 | i0 | 43.9 | 0.776470588235294 | 66 | 37 | 77.6 | 0 | 3 | 200 | 154 | 219 | UCF41094.1 MAG: chalcone isomerase family protein [Gemmatimonadota bacterium] | diamond | 198 | 56.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32550991 | 32550991 | PRJNA756891_P_NODE_16599_length_241_cov_0.916667_g16530_i0 | PRJNA756891 | 16599 | 241 | 0.916667 | 2.20916747 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 120 | 1.3e-29 | NR | HEY3011917.1 | 2448054 | g16530 | i0 | 79.2 | 0.896265560165975 | 72 | 12 | 85.9 | 1 | 5 | 211 | 28 | 99 | HEY3011917.1 serine/threonine-protein kinase [Gemmatimonadales bacterium] | diamond | 216 | 120 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32865579 | 32865579 | PRJNA756891_P_NODE_15820_length_243_cov_0.900000_g15751_i0 | PRJNA756891 | 15820 | 243 | 0.9 | 2.187 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 138 | 3.34e-36 | NR | HEY5441176.1 | 2026741 | g15751 | i0 | 84 | 3.64197530864198 | 75 | 12 | 92.6 | 0 | 17 | 241 | 157 | 231 | HEY5441176.1 amidohydrolase [Gemmatimonadaceae bacterium] | diamond | 885 | 138 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae 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);;