contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1137393" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26880723 | 26880723 | PRJNA1137393_P_NODE_69001_length_163_cov_0.912281_g68485_i0 | PRJNA1137393 | 69001 | 163 | 0.912281 | 1.48701803 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 71.2 | 1.08e-12 | NR | HEY1063943.1 | 2973664 | g68485 | i0 | 66 | 0.975460122699387 | 53 | 18 | 97.5 | 0 | 1 | 159 | 237 | 289 | HEY1063943.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 159 | 71.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 27260102 | 27260102 | PRJNA1137393_P_NODE_53123_length_166_cov_0.888889_g52607_i0 | PRJNA1137393 | 53123 | 166 | 0.888889 | 1.47555574 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 45.8 | 3.2e-4 | NR | MCA0228232.1 | 2052139 | g52607 | i0 | 78.1 | 2.33132530120482 | 32 | 7 | 57.8 | 0 | 1 | 96 | 86 | 117 | MCA0228232.1 30S ribosomal protein S6 [Patescibacteria group bacterium] | diamond | 387 | 45.8 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27323302 | 27323302 | PRJNA1137393_P_NODE_68923_length_163_cov_0.912281_g68407_i0 | PRJNA1137393 | 68923 | 163 | 0.912281 | 1.48701803 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 100 | 2.9099999999999996e-23 | NR | MBP9667703.1 | 2026720 | g68407 | i0 | 88.9 | 0.993865030674847 | 54 | 6 | 99.4 | 0 | 2 | 163 | 363 | 416 | MBP9667703.1 recombinase family protein [Candidatus Saccharibacteria bacterium] | diamond | 162 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27691617 | 27691617 | PRJNA1137393_P_NODE_55924_length_165_cov_1.948276_g55408_i0 | PRJNA1137393 | 55924 | 165 | 1.948276 | 3.2146554 | Bacteria | 2 | Bacteria | Bacteria | 106 | 4.14e-25 | NR | NCC20352.1 | 2026720 | g55408 | i0 | 90.9 | 7 | 55 | 5 | 100 | 0 | 1 | 165 | 320 | 374 | NCC20352.1 M1 family peptidase [Candidatus Saccharibacteria bacterium] | diamond | 1155 | 106 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28965330 | 28965330 | PRJNA1137393_P_NODE_59108_length_165_cov_0.896552_g58592_i0 | PRJNA1137393 | 59108 | 165 | 0.896552 | 1.4793108 | Candidatus Saccharimonas sp. | 1917697 | Bacteria | Bacteria | 84.3 | 2.42e-18 | NR | MEO5949493.1 | 1917697 | g58592 | i0 | 71.7 | 0.963636363636364 | 53 | 15 | 96.4 | 0 | 6 | 164 | 129 | 181 | MEO5949493.1 phosphatase PAP2 family protein [Candidatus Saccharimonas sp.] | diamond | 159 | 84.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 29533504 | 29533504 | PRJNA1137393_P_NODE_67610_length_163_cov_0.912281_g67094_i0 | PRJNA1137393 | 67610 | 163 | 0.912281 | 1.48701803 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 75.1 | 4.89e-14 | NR | MBW7944192.1 | 2052139 | g67094 | i0 | 60.4 | 1.95092024539877 | 53 | 21 | 97.5 | 0 | 163 | 5 | 132 | 184 | MBW7944192.1 2,3-bisphosphoglycerate-independent phosphoglycerate mutase [Patescibacteria group bacterium] | diamond | 318 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 29691030 | 29691030 | PRJNA1137393_P_NODE_63890_length_164_cov_0.904348_g63374_i0 | PRJNA1137393 | 63890 | 164 | 0.904348 | 1.48313072 | Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_ | 1802132 | Bacteria | Bacteria | 58.5 | 3.38e-8 | NR | OGL22522.1 | 1802132 | g63374 | i0 | 50 | 0.98780487804878 | 54 | 27 | 98.8 | 0 | 164 | 3 | 626 | 679 | OGL22522.1 MAG: hypothetical protein A2707_04325 [Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_45_15] | diamond | 162 | 58.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_45_15 | ||||||
| 30007369 | 30007369 | PRJNA1137393_P_NODE_28331_length_184_cov_1.451852_g27815_i0 | PRJNA1137393 | 28331 | 184 | 1.451852 | 2.67140768 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 59.7 | 1.29e-8 | NR | MBU6231627.1 | 2052139 | g27815 | i0 | 46.3 | 0.880434782608696 | 54 | 29 | 88 | 0 | 164 | 3 | 33 | 86 | MBU6231627.1 gamma-glutamyl-gamma-aminobutyrate hydrolase family protein [Patescibacteria group bacterium] | diamond | 162 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31587529 | 31587529 | PRJNA1137393_P_NODE_40216_length_169_cov_0.866667_g39700_i0 | PRJNA1137393 | 40216 | 169 | 0.866667 | 1.46466723 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 101 | 1.3299999999999995e-23 | NR | HSI63942.1 | 2890869 | g39700 | i0 | 80.4 | 3.8698224852071 | 56 | 11 | 99.4 | 0 | 168 | 1 | 81 | 136 | HSI63942.1 hypothetical protein [Candidatus Saccharimonadia bacterium] | diamond | 654 | 101 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 31650439 | 31650439 | PRJNA1137393_P_NODE_72697_length_162_cov_0.920354_g72181_i0 | PRJNA1137393 | 72697 | 162 | 0.920354 | 1.49097348 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 71.6 | 3.67e-13 | NR | MBA3723923.1 | 2052151 | g72181 | i0 | 59.3 | 1 | 54 | 22 | 100 | 0 | 162 | 1 | 50 | 103 | MBA3723923.1 lamin tail domain-containing protein [Candidatus Levyibacteriota bacterium] | diamond | 162 | 71.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 31840262 | 31840262 | PRJNA1137393_P_NODE_70677_length_162_cov_0.920354_g70161_i0 | PRJNA1137393 | 70677 | 162 | 0.920354 | 1.49097348 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 62 | 1.93e-9 | NR | MBP6962308.1 | 2026720 | g70161 | i0 | 52.8 | 1.96296296296296 | 53 | 25 | 98.1 | 0 | 2 | 160 | 98 | 150 | MBP6962308.1 ComEC/Rec2 family competence protein [Candidatus Saccharibacteria bacterium] | diamond | 318 | 62 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32462371 | 32462371 | PRJNA1137393_P_NODE_68859_length_163_cov_0.912281_g68343_i0 | PRJNA1137393 | 68859 | 163 | 0.912281 | 1.48701803 | Candidatus Saccharimonas | 1331051 | Bacteria | Bacteria | 89 | 8.18e-21 | NR | WP_015641906.1 | 1332188 | g68343 | i0 | 84.9 | 2.92638036809816 | 53 | 8 | 97.5 | 0 | 161 | 3 | 61 | 113 | WP_015641906.1 transcription elongation factor GreA [Candidatus Saccharimonas aalborgensis] | diamond | 477 | 89 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas aalborgensis |
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);;