contig_metadata
7 rows where bioproject = "PRJNA1253698", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1634462 | 1634462 | PRJNA1253698_S_NODE_5102_length_306_cov_2.186770_g4736_i0 | PRJNA1253698 | 5102 | 306 | 2.18677 | 6.6915162 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 433 | 8.72e-117 | NTclustered | gi|2874253966|emb|OY970291.1| | 2081523 | g4736 | i0 | 92.182 | 264.653594771242 | 307 | 22 | 100 | 2 | 1 | 306 | 141114 | 141419 | MAG: Terriglobia bacterium isolate MFD05513.bin.c.1 genome assembly, chromosome: 1 | blastn | 80984 | 433 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 2910299 | 2910299 | PRJNA1253698_S_NODE_11143_length_207_cov_1.316456_g10777_i0 | PRJNA1253698 | 11143 | 207 | 1.316456 | 2.72506392 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 353 | 4.429999999999999e-93 | NTclustered | gi|2874254120|emb|OY970205.1| | 194844 | g10777 | i0 | 97.585 | 104.009661835749 | 207 | 3 | 99 | 2 | 1 | 206 | 2084062 | 2084267 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD02248.bin.1.24 genome assembly, chromosome: 1 | blastn | 21530 | 353 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 4186751 | 4186751 | PRJNA1253698_S_NODE_17204_length_171_cov_1.893443_g16838_i0 | PRJNA1253698 | 17204 | 171 | 1.893443 | 3.23778753 | Edaphobacter paludis | 3035702 | Bacteria | Bacteria | 267 | 4.699999999999999e-67 | NTclustered | gi|2737763816|gb|CP121194.1| | 3035702 | g16838 | i0 | 95.238 | 62.8713450292398 | 168 | 8 | 98 | 0 | 2 | 169 | 662736 | 662569 | Edaphobacter paludis strain DSM 109919 chromosome, complete genome | blastn | 10751 | 267 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter paludis | ||
| 18211372 | 18211372 | PRJNA1253698_S_NODE_18735_length_168_cov_0.873950_g18369_i0 | PRJNA1253698 | 18735 | 168 | 0.87395 | 1.468236 | Bacteria | 2 | Bacteria | Bacteria | 107 | 5.72e-28 | NR | HWY26806.1 | 2976921 | g18369 | i0 | 87.3 | 4.91071428571429 | 55 | 7 | 98.2 | 0 | 166 | 2 | 42 | 96 | HWY26806.1 (2Fe-2S)-binding protein [Candidatus Angelobacter sp.] | diamond | 825 | 107 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Angelobacter | Candidatus Angelobacter sp. | ||||
| 18904173 | 18904173 | PRJNA1253698_S_NODE_12195_length_199_cov_1.986667_g11829_i0 | PRJNA1253698 | 12195 | 199 | 1.986667 | 3.95346733 | Acidobacterium | 33973 | Bacteria | Bacteria | 226 | 9.619999999999998e-55 | NTclustered | gi|470484216|ref|NR_076636.1| | 33075 | g11829 | i0 | 87.562 | 132.180904522613 | 201 | 18 | 100 | 6 | 1 | 199 | 322 | 127 | Acidobacterium capsulatum strain 161 23S ribosomal RNA gene, complete sequence | blastn | 26304 | 226 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacterium | Acidobacterium capsulatum | ||
| 20761249 | 20761249 | PRJNA1253698_S_NODE_2657_length_437_cov_2.059278_g2294_i0 | PRJNA1253698 | 2657 | 437 | 2.059278 | 8.99904486 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 717 | 0 | NTclustered | gi|2874253956|emb|OY970281.1| | 194844 | g2294 | i0 | 96.33 | 106.036613272311 | 436 | 16 | 99 | 0 | 2 | 437 | 422556 | 422121 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD00008.bin.c.2 genome assembly, chromosome: 1 | blastn | 46338 | 717 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 31134051 | 31134051 | PRJNA1253698_S_NODE_22455_length_163_cov_0.912281_g22089_i0 | PRJNA1253698 | 22455 | 163 | 0.912281 | 1.48701803 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 101 | 1.68e-23 | NR | HEY2861336.1 | 1964191 | g22089 | i0 | 92.5 | 9.88343558282209 | 53 | 4 | 97.5 | 0 | 4 | 162 | 168 | 220 | HEY2861336.1 amidohydrolase family protein [Terracidiphilus sp.] | diamond | 1611 | 102 | 0.990196078431373 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus 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);;