contig_metadata
4 rows where bioproject = "PRJEB43370", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5162514 | 5162514 | PRJEB43370_P_NODE_3325_length_240_cov_1.089005_g3282_i0 | PRJEB43370 | 3325 | 240 | 1.089005 | 2.613612 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 134 | 7.49e-27 | NTclustered | gi|2621703510|emb|OY762557.1| | 2910168 | g3282 | i0 | 81.875 | 27.6875 | 160 | 27 | 66 | 2 | 80 | 238 | 547794 | 547952 | MAG: Longimicrobiales bacterium isolate c10e2151-7d97-4465-9cf7-a78a4796a63d genome assembly, chromosome: 1 | blastn | 6645 | 134 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 27412973 | 27412973 | PRJEB43370_P_NODE_6663_length_178_cov_1.209302_g6620_i0 | PRJEB43370 | 6663 | 178 | 1.209302 | 2.15255756 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 59.7 | 1.57e-8 | NR | HEX9894848.1 | 2448054 | g6620 | i0 | 46.6 | 0.97752808988764 | 58 | 27 | 97.8 | 1 | 3 | 176 | 303 | 356 | HEX9894848.1 acylase [Gemmatimonadales bacterium] | diamond | 174 | 59.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 27563661 | 27563661 | PRJEB43370_P_NODE_604_length_556_cov_1.715976_g562_i0 | PRJEB43370 | 604 | 556 | 1.715976 | 9.54082656 | Gemmatimonadota | 142182 | Bacteria | Bacteria | 142 | 1.7199999999999998e-35 | NR | HEY2377597.1 | 2026741 | g562 | i0 | 47 | 9.44244604316547 | 166 | 78 | 84.7 | 5 | 473 | 3 | 599 | 763 | HEY2377597.1 Ig-like domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 5250 | 142 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31107570 | 31107570 | PRJEB43370_P_NODE_7575_length_169_cov_0.866667_g7532_i0 | PRJEB43370 | 7575 | 169 | 0.866667 | 1.46466723 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 59.7 | 1.37e-8 | NR | HSW30076.1 | 2910168 | g7532 | i0 | 59.6 | 0.834319526627219 | 47 | 18 | 81.7 | 1 | 167 | 30 | 357 | 403 | HSW30076.1 hypothetical protein [Longimicrobiales bacterium] | diamond | 141 | 59.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales 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);;