contig_metadata
6 rows where bioproject = "PRJNA897077", tax_clade = "FCB group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25470834 | 25470834 | PRJNA897077_P_NODE_13100_length_274_cov_1.547264_g12973_i0 | PRJNA897077 | 13100 | 274 | 1.547264 | 4.23950336 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 169 | 4.78e-47 | NR | NUQ12829.1 | 2026741 | g12973 | i0 | 91.1 | 0.985401459854015 | 90 | 8 | 98.5 | 0 | 272 | 3 | 556 | 645 | NUQ12829.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Gemmatimonadaceae bacterium] | diamond | 270 | 169 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27213562 | 27213562 | PRJNA897077_P_NODE_12562_length_280_cov_1.280193_g12435_i0 | PRJNA897077 | 12562 | 280 | 1.280193 | 3.5845404 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 76.3 | 1.68e-15 | NR | HEY3013408.1 | 2448054 | g12435 | i0 | 45.6 | 1.71428571428571 | 90 | 49 | 96.4 | 0 | 7 | 276 | 17 | 106 | HEY3013408.1 tetratricopeptide repeat protein [Gemmatimonadales bacterium] | diamond | 480 | 76.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 27245345 | 27245345 | PRJNA897077_P_NODE_16823_length_249_cov_0.886364_g16696_i0 | PRJNA897077 | 16823 | 249 | 0.886364 | 2.20704636 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 94.7 | 1.99e-20 | NR | HEX5072692.1 | 2026741 | g16696 | i0 | 57.5 | 2.86746987951807 | 80 | 34 | 96.4 | 0 | 247 | 8 | 496 | 575 | HEX5072692.1 DUF2723 domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 714 | 94.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31453990 | 31453990 | PRJNA897077_P_NODE_17316_length_248_cov_0.891429_g17189_i0 | PRJNA897077 | 17316 | 248 | 0.891429 | 2.21074392 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 94 | 9.18e-21 | NR | MBB27874.1 | 2026742 | g17189 | i0 | 68.2 | 2.39516129032258 | 66 | 21 | 79.8 | 0 | 198 | 1 | 1 | 66 | MBB27874.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 594 | 94 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32174020 | 32174020 | PRJNA897077_P_NODE_19718_length_242_cov_0.923077_g19591_i0 | PRJNA897077 | 19718 | 242 | 0.923077 | 2.23384634 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 102 | 3.06e-26 | NR | HJR66347.1 | 2026741 | g19591 | i0 | 96.4 | 0.681818181818182 | 55 | 2 | 68.2 | 0 | 241 | 77 | 34 | 88 | HJR66347.1 DUF2277 domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 165 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32426948 | 32426948 | PRJNA897077_P_NODE_18479_length_245_cov_0.906977_g18352_i0 | PRJNA897077 | 18479 | 245 | 0.906977 | 2.22209365 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 107 | 1.6200000000000003e-27 | NR | HET9636793.1 | 2026741 | g18352 | i0 | 64.5 | 0.930612244897959 | 76 | 27 | 93.1 | 0 | 230 | 3 | 1 | 76 | HET9636793.1 isoprenylcysteine carboxylmethyltransferase family protein [Gemmatimonadaceae bacterium] | diamond | 228 | 107 | 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);;