contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA493828" and tax_phylum = "Candidatus Saccharimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27393105 | 27393105 | PRJNA493828_P_NODE_12263_length_331_cov_4.689922_g11844_i0 | PRJNA493828 | 12263 | 331 | 4.689922 | 15.52364182 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 49.3 | 4.83e-4 | NR | MCG5105720.1 | 2026720 | g11844 | i0 | 39.7 | 0.706948640483384 | 78 | 45 | 69.8 | 2 | 254 | 24 | 14 | 90 | MCG5105720.1 phage tail tip lysozyme [Candidatus Saccharibacteria bacterium] | diamond | 234 | 49.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27456310 | 27456310 | PRJNA493828_P_NODE_38623_length_242_cov_1.763314_g38204_i0 | PRJNA493828 | 38623 | 242 | 1.763314 | 4.26721988 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 166 | 1.89e-50 | NR | MBN9398527.1 | 2026720 | g38204 | i0 | 96.3 | 0.991735537190083 | 80 | 3 | 99.2 | 0 | 2 | 241 | 95 | 174 | MBN9398527.1 NUDIX hydrolase [Candidatus Saccharibacteria bacterium] | diamond | 240 | 166 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27582333 | 27582333 | PRJNA493828_P_NODE_31764_length_251_cov_2.679775_g31345_i0 | PRJNA493828 | 31764 | 251 | 2.679775 | 6.72623525 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 119 | 1.02e-30 | NR | MBC7546575.1 | 2026720 | g31345 | i0 | 71.1 | 0.99203187250996006 | 83 | 24 | 99.2 | 0 | 1 | 249 | 123 | 205 | MBC7546575.1 M15 family metallopeptidase [Candidatus Saccharibacteria bacterium] | diamond | 249 | 119 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27913579 | 27913579 | PRJNA493828_P_NODE_27745_length_262_cov_2.222222_g27326_i0 | PRJNA493828 | 27745 | 262 | 2.222222 | 5.82222164 | Bacteria | 2 | Bacteria | Bacteria | 124 | 2.62e-32 | NR | OGL22419.1 | 1802132 | g27326 | i0 | 69.4 | 5.95419847328244 | 85 | 26 | 97.3 | 0 | 2 | 256 | 229 | 313 | OGL22419.1 MAG: hypothetical protein A2707_03795 [Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_45_15] | diamond | 1560 | 124 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_45_15 | ||||||
| 28213616 | 28213616 | PRJNA493828_P_NODE_28806_length_259_cov_2.311828_g28387_i0 | PRJNA493828 | 28806 | 259 | 2.311828 | 5.98763452 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 90.9 | 2.69e-21 | NR | HSX29533.1 | 2973664 | g28387 | i0 | 51.9 | 0.891891891891892 | 77 | 37 | 89.2 | 0 | 233 | 3 | 7 | 83 | HSX29533.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 231 | 90.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 28955918 | 28955918 | PRJNA493828_P_NODE_27668_length_262_cov_2.978836_g27249_i0 | PRJNA493828 | 27668 | 262 | 2.978836 | 7.80455032 | Candidatus Saccharimonadaceae | 2171986 | Bacteria | Bacteria | 178 | 3.2599999999999998e-52 | NR | RKV95619.1 | 1917697 | g27249 | i0 | 98.8 | 2.95419847328244 | 86 | 1 | 98.5 | 0 | 260 | 3 | 42 | 127 | RKV95619.1 MAG: hypothetical protein D8G53_08520, partial [Candidatus Saccharimonas sp.] | diamond | 774 | 178 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 29098055 | 29098055 | PRJNA493828_P_NODE_20548_length_285_cov_3.900943_g20129_i0 | PRJNA493828 | 20548 | 285 | 3.900943 | 11.11768755 | Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1 | 1986206 | Bacteria | Bacteria | 173 | 4.749999999999999e-52 | NR | WP_129693356.1 | 1986206 | g20129 | i0 | 93.7 | 1 | 95 | 6 | 100 | 0 | 285 | 1 | 59 | 153 | WP_129693356.1 TrmB family transcriptional regulator [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1] | diamond | 285 | 173 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Nanosynsacchari | Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1 | ||
| 30471774 | 30471774 | PRJNA493828_P_NODE_28573_length_260_cov_1.304813_g28154_i0 | PRJNA493828 | 28573 | 260 | 1.304813 | 3.3925138 | Bacteria | 2 | Bacteria | Bacteria | 143 | 1.77e-39 | NR | MBN9397617.1 | 2026720 | g28154 | i0 | 72.1 | 2.97692307692308 | 86 | 24 | 99.2 | 0 | 258 | 1 | 177 | 262 | MBN9397617.1 DUF916 domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 774 | 144 | 0.993055555555556 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31213874 | 31213874 | PRJNA493828_P_NODE_19815_length_288_cov_2.041860_g19396_i0 | PRJNA493828 | 19815 | 288 | 2.04186 | 5.8805568 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 181 | 1.01e-51 | NR | MCA9335546.1 | 2026720 | g19396 | i0 | 97.9 | 1 | 96 | 2 | 100 | 0 | 1 | 288 | 355 | 450 | MCA9335546.1 recombinase family protein [Candidatus Saccharibacteria bacterium] | diamond | 288 | 181 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31293125 | 31293125 | PRJNA493828_P_NODE_44095_length_226_cov_3.013072_g43676_i0 | PRJNA493828 | 44095 | 226 | 3.013072 | 6.80954272 | Bacteria | 2 | Bacteria | Bacteria | 106 | 2.4e-25 | NR | MBC7868793.1 | 2026720 | g43676 | i0 | 68 | 2.98672566371681 | 75 | 24 | 99.6 | 0 | 226 | 2 | 73 | 147 | MBC7868793.1 glycosyltransferase [Candidatus Saccharibacteria bacterium] | diamond | 675 | 106 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota 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);;