contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1215774" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14360436 | 14360436 | PRJNA1215774_P_NODE_69632_length_250_cov_1.740113_g69312_i0 | PRJNA1215774 | 69632 | 250 | 1.740113 | 4.3502825 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 72 | 2e-12 | NR | HYE30524.1 | 2072417 | g69312 | i0 | 48.8 | 6.852 | 84 | 42 | 99.6 | 1 | 250 | 2 | 169 | 252 | HYE30524.1 TonB-dependent receptor [Candidatus Methylomirabilota bacterium] | diamond | 1713 | 72 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 26883015 | 26883015 | PRJNA1215774_P_NODE_60261_length_270_cov_1.563452_g59941_i0 | PRJNA1215774 | 60261 | 270 | 1.563452 | 4.2213204 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 71.2 | 2.7e-13 | NR | MBP9782489.1 | 2053589 | g59941 | i0 | 42 | 0.977777777777778 | 88 | 49 | 97.8 | 2 | 266 | 3 | 33 | 118 | MBP9782489.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 264 | 71.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27988701 | 27988701 | PRJNA1215774_P_NODE_26385_length_414_cov_1.806452_g26065_i0 | PRJNA1215774 | 26385 | 414 | 1.806452 | 7.47871128 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 53.1 | 3.83e-5 | NR | MDE2100585.1 | 2052139 | g26065 | i0 | 32.3 | 0.963768115942029 | 133 | 89 | 96.4 | 1 | 413 | 15 | 110 | 241 | MDE2100585.1 DnaJ domain-containing protein [Patescibacteria group bacterium] | diamond | 399 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28367434 | 28367434 | PRJNA1215774_P_NODE_84406_length_241_cov_0.916667_g84086_i0 | PRJNA1215774 | 84406 | 241 | 0.916667 | 2.20916747 | Candidatus Sumerlaeia bacterium | 2715255 | Bacteria | Bacteria | 50.1 | 9.19e-5 | NR | MCC5876835.1 | 2715255 | g84086 | i0 | 35.6 | 0.908713692946058 | 73 | 47 | 90.9 | 0 | 21 | 239 | 478 | 550 | MCC5876835.1 hypothetical protein [Candidatus Sumerlaeia bacterium] | diamond | 219 | 50.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeia | Candidatus Sumerlaeia bacterium | |||||
| 28430826 | 28430826 | PRJNA1215774_P_NODE_81726_length_243_cov_0.905882_g81406_i0 | PRJNA1215774 | 81726 | 243 | 0.905882 | 2.20129326 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 74.7 | 1.1e-14 | NR | HMQ96275.1 | 2026720 | g81406 | i0 | 64 | 0.617283950617284 | 50 | 15 | 58 | 1 | 5 | 145 | 92 | 141 | HMQ96275.1 HIT family protein [Candidatus Saccharibacteria bacterium] | diamond | 150 | 74.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28525602 | 28525602 | PRJNA1215774_P_NODE_75287_length_247_cov_0.885057_g74967_i0 | PRJNA1215774 | 75287 | 247 | 0.885057 | 2.18609079 | Minisyncoccia bacterium | 3120121 | Bacteria | Bacteria | 85.5 | 5.22e-19 | NR | MFN3693035.1 | 3120121 | g74967 | i0 | 75.5 | 0.643724696356275 | 53 | 13 | 64.4 | 0 | 3 | 161 | 94 | 146 | MFN3693035.1 type II secretion system protein [Minisyncoccia bacterium] | diamond | 159 | 85.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccia | Minisyncoccia bacterium | |||||
| 29617393 | 29617393 | PRJNA1215774_P_NODE_75330_length_247_cov_0.885057_g75010_i0 | PRJNA1215774 | 75330 | 247 | 0.885057 | 2.18609079 | Bacteria | 2 | Bacteria | Bacteria | 118 | 4.51e-29 | NR | MBY0538354.1 | 2052139 | g75010 | i0 | 100 | 3.10931174089069 | 64 | 0 | 77.7 | 0 | 246 | 55 | 461 | 524 | MBY0538354.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 768 | 118 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 29807062 | 29807062 | PRJNA1215774_P_NODE_74011_length_248_cov_0.880000_g73691_i0 | PRJNA1215774 | 74011 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 68.9 | 2.29e-11 | NR | MCA9358153.1 | 2030810 | g73691 | i0 | 100 | 3.70161290322581 | 34 | 0 | 41.1 | 0 | 1 | 102 | 476 | 509 | MCA9358153.1 ribonuclease Y [Candidatus Kaiserbacteria bacterium] | diamond | 918 | 68.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 30483482 | 30483482 | PRJNA1215774_P_NODE_67673_length_252_cov_1.720670_g67353_i0 | PRJNA1215774 | 67673 | 252 | 1.72067 | 4.3360884 | Candidatus Saccharibacteria bacterium 32-5 | 1970481 | Bacteria | Bacteria | 120 | 1.84e-29 | NR | OYX53809.1 | 1970481 | g67353 | i0 | 69.9 | 1.97619047619048 | 83 | 25 | 98.8 | 0 | 251 | 3 | 458 | 540 | OYX53809.1 MAG: hypothetical protein B7Y92_01820 [Candidatus Saccharibacteria bacterium 32-50-13] | diamond | 498 | 120 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-50-13 | ||||||
| 30767813 | 30767813 | PRJNA1215774_P_NODE_75134_length_247_cov_0.885057_g74814_i0 | PRJNA1215774 | 75134 | 247 | 0.885057 | 2.18609079 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 103 | 3.7e-25 | NR | HET6747498.1 | 2973664 | g74814 | i0 | 57.7 | 2.84210526315789 | 78 | 33 | 94.7 | 0 | 1 | 234 | 139 | 216 | HET6747498.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 702 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30989087 | 30989087 | PRJNA1215774_P_NODE_82434_length_242_cov_0.911243_g82114_i0 | PRJNA1215774 | 82434 | 242 | 0.911243 | 2.20520806 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 107 | 6.45e-25 | NR | MFN8544203.1 | 2838779 | g82114 | i0 | 71.3 | 0.991735537190083 | 80 | 23 | 99.2 | 0 | 3 | 242 | 747 | 826 | MFN8544203.1 alanine--tRNA ligase [Candidatus Binatia bacterium] | diamond | 240 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31589853 | 31589853 | PRJNA1215774_P_NODE_71716_length_249_cov_0.875000_g71396_i0 | PRJNA1215774 | 71716 | 249 | 0.875 | 2.17875 | Candidatus Saccharibacteria bacterium 49-2 | 1895829 | Bacteria | Bacteria | 150 | 1.77e-40 | NR | OJU88086.1 | 1895829 | g71396 | i0 | 95.1 | 0.975903614457831 | 81 | 4 | 97.6 | 0 | 248 | 6 | 214 | 294 | OJU88086.1 MAG: DNA primase [Candidatus Saccharibacteria bacterium 49-20] | diamond | 243 | 150 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 | ||||||
| 32539029 | 32539029 | PRJNA1215774_P_NODE_74699_length_247_cov_0.885057_g74379_i0 | PRJNA1215774 | 74699 | 247 | 0.885057 | 2.18609079 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 89 | 7.320000000000001e-21 | NR | MDB5180837.1 | 2026720 | g74379 | i0 | 93.5 | 1.11740890688259 | 46 | 3 | 55.9 | 0 | 139 | 2 | 3 | 48 | MDB5180837.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 276 | 89 | 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);;