contig_metadata
7 rows where bioproject = "PRJNA879314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5961060 | 5961060 | PRJNA879314_P_NODE_10565_length_243_cov_0.917647_g10515_i0 | PRJNA879314 | 10565 | 243 | 0.917647 | 2.22988221 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 127 | 1.08e-34 | NR | MEP6571880.1 | 2026742 | g10515 | i0 | 88.7 | 2.62962962962963 | 71 | 8 | 87.7 | 0 | 31 | 243 | 1 | 71 | MEP6571880.1 transcriptional repressor LexA [Gemmatimonadota bacterium] | diamond | 639 | 127 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 13611506 | 13611506 | PRJNA879314_P_NODE_4531_length_253_cov_0.866667_g4481_i0 | PRJNA879314 | 4531 | 253 | 0.866667 | 2.19266751 | Gemmatimonas groenlandica | 2732249 | Bacteria | Bacteria | 385 | 1.99e-102 | NTclustered | gi|1839994010|gb|CP053085.1| | 2732249 | g4481 | i0 | 94.071 | 1.12252964426877 | 253 | 15 | 100 | 0 | 1 | 253 | 4845167 | 4844915 | Gemmatimonas groenlandica strain TET16 chromosome, complete genome | blastn | 284 | 385 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas groenlandica | |
| 27624171 | 27624171 | PRJNA879314_P_NODE_2764_length_294_cov_1.208145_g2714_i0 | PRJNA879314 | 2764 | 294 | 1.208145 | 3.5519463 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 44.3 | 0.0198 | NR | HTT69055.1 | 2448054 | g2714 | i0 | 33.7 | 0.908163265306122 | 89 | 56 | 89.8 | 2 | 280 | 17 | 187 | 273 | HTT69055.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 267 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 28381748 | 28381748 | PRJNA879314_P_NODE_7986_length_247_cov_0.896552_g7936_i0 | PRJNA879314 | 7986 | 247 | 0.896552 | 2.21448344 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 117 | 1.42e-28 | NR | HEX7547346.1 | 2026741 | g7936 | i0 | 71.6 | 0.983805668016194 | 81 | 23 | 98.4 | 0 | 2 | 244 | 78 | 158 | HEX7547346.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 243 | 117 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28855181 | 28855181 | PRJNA879314_P_NODE_4388_length_253_cov_0.866667_g4338_i0 | PRJNA879314 | 4388 | 253 | 0.866667 | 2.19266751 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 88.6 | 1.65e-19 | NR | HYW51013.1 | 2026741 | g4338 | i0 | 67.7 | 0.735177865612648 | 62 | 20 | 73.5 | 0 | 2 | 187 | 144 | 205 | HYW51013.1 histidine phosphatase family protein [Gemmatimonadaceae bacterium] | diamond | 186 | 88.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31105816 | 31105816 | PRJNA879314_P_NODE_11015_length_242_cov_0.923077_g10965_i0 | PRJNA879314 | 11015 | 242 | 0.923077 | 2.23384634 | Bacteria | 2 | Bacteria | Bacteria | 108 | 1.8e-25 | NR | MEO7822682.1 | 2026741 | g10965 | i0 | 61.5 | 5.7396694214876 | 78 | 29 | 96.7 | 1 | 7 | 240 | 574 | 650 | MEO7822682.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 1389 | 109 | 0.990825688073395 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32616095 | 32616095 | PRJNA879314_P_NODE_10000_length_244_cov_0.912281_g9950_i0 | PRJNA879314 | 10000 | 244 | 0.912281 | 2.22596564 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 162 | 5.49e-49 | NR | MBY0492309.1 | 2026741 | g9950 | i0 | 97.5 | 0.995901639344262 | 81 | 2 | 99.6 | 0 | 243 | 1 | 66 | 146 | MBY0492309.1 ribose 5-phosphate isomerase B [Gemmatimonadaceae bacterium] | diamond | 243 | 162 | 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);;