contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA725806" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26894317 | 26894317 | PRJNA725806_P_NODE_75541_length_217_cov_12.600000_g75240_i0 | PRJNA725806 | 75541 | 217 | 12.6 | 27.342 | Candidatus Giovannonibacteria bacterium | 2053557 | Bacteria | Bacteria | 42.4 | 0.0374 | NR | MBI2020948.1 | 2053557 | g75240 | i0 | 35.6 | 0.622119815668203 | 45 | 29 | 62.2 | 0 | 37 | 171 | 71 | 115 | MBI2020948.1 tetratricopeptide repeat protein [Candidatus Giovannonibacteria bacterium] | diamond | 135 | 42.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Giovannoniibacteriota | Candidatus Giovannonibacteria bacterium | ||||||
| 27115256 | 27115256 | PRJNA725806_P_NODE_130422_length_178_cov_5.936170_g130120_i0 | PRJNA725806 | 130422 | 178 | 5.93617 | 10.5663826 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 41.6 | 0.0391 | NR | HHZ89897.1 | 2026781 | g130120 | i0 | 43.8 | 0.808988764044944 | 48 | 24 | 75.8 | 1 | 137 | 3 | 21 | 68 | HHZ89897.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 144 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 27146659 | 27146659 | PRJNA725806_P_NODE_86522_length_208_cov_1.350877_g86221_i0 | PRJNA725806 | 86522 | 208 | 1.350877 | 2.80982416 | Candidatus Saccharibacteria bacterium 49-2 | 1895829 | Bacteria | Bacteria | 130 | 3.65e-33 | NR | OJU87461.1 | 1895829 | g86221 | i0 | 100 | 0.980769230769231 | 68 | 0 | 98.1 | 0 | 3 | 206 | 437 | 504 | OJU87461.1 MAG: ATP-dependent DNA helicase PcrA [Candidatus Saccharibacteria bacterium 49-20] | diamond | 204 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 | ||||||
| 27273524 | 27273524 | PRJNA725806_P_NODE_145923_length_170_cov_9.135338_g145621_i0 | PRJNA725806 | 145923 | 170 | 9.135338 | 15.5300746 | Candidatus Moraniibacteriota bacterium | 2045217 | Bacteria | Bacteria | 42 | 0.0265 | NR | MBD3300581.1 | 2045217 | g145621 | i0 | 52.4 | 0.741176470588235 | 42 | 18 | 70.6 | 1 | 45 | 164 | 428 | 469 | MBD3300581.1 glycosyltransferase [Candidatus Moraniibacteriota bacterium] | diamond | 126 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 27947045 | 27947045 | PRJNA725806_P_NODE_93805_length_202_cov_1.854545_g93503_i0 | PRJNA725806 | 93805 | 202 | 1.854545 | 3.7461809 | root | 1 | Root_unresolved | Root_unresolved | 50.4 | 4.15e-5 | NR | HLK86067.1 | 2785449 | g93503 | i0 | 41.5 | 2.58415841584158 | 53 | 31 | 78.7 | 0 | 34 | 192 | 5 | 57 | HLK86067.1 DEAD/DEAH box helicase [Candidatus Binataceae bacterium] | diamond | 522 | 50.8 | 0.992125984251969 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 29168294 | 29168294 | PRJNA725806_P_NODE_75629_length_217_cov_9.055556_g75328_i0 | PRJNA725806 | 75629 | 217 | 9.055556 | 19.65055652 | Candidatus Shapirobacteria bacterium CG | 2053613 | Bacteria | Bacteria | 41.2 | 0.0426 | NR | PIS14228.1 | 1974481 | g75328 | i0 | 32.7 | 0.76036866359447 | 55 | 32 | 76 | 1 | 173 | 9 | 6 | 55 | PIS14228.1 MAG: hypothetical protein COT65_00010 [Candidatus Shapirobacteria bacterium CG09_land_8_20_14_0_10_47_13] | diamond | 165 | 41.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium CG09_land_8_20_14_0_10_47_13 | ||||||
| 29736133 | 29736133 | PRJNA725806_P_NODE_103530_length_195_cov_1.303797_g103228_i0 | PRJNA725806 | 103530 | 195 | 1.303797 | 2.54240415 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 46.6 | 8.57e-4 | NR | MBN9398373.1 | 2026720 | g103228 | i0 | 41.1 | 0.861538461538462 | 56 | 29 | 83.1 | 3 | 33 | 194 | 378 | 431 | MBN9398373.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 168 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30052101 | 30052101 | PRJNA725806_P_NODE_18551_length_324_cov_1.177700_g18257_i0 | PRJNA725806 | 18551 | 324 | 1.1777 | 3.815748 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 63.2 | 6.58e-9 | NR | HVX24508.1 | 2973664 | g18257 | i0 | 43.2 | 0.75 | 81 | 45 | 75 | 1 | 279 | 37 | 101 | 180 | HVX24508.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 243 | 63.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30400296 | 30400296 | PRJNA725806_P_NODE_66933_length_226_cov_9.523810_g66633_i0 | PRJNA725806 | 66933 | 226 | 9.52381 | 21.5238106 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 43.5 | 0.0155 | NR | HET6924576.1 | 2973664 | g66633 | i0 | 32.4 | 0.902654867256637 | 68 | 45 | 88.9 | 1 | 214 | 14 | 71 | 138 | HET6924576.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 204 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 31189322 | 31189322 | PRJNA725806_P_NODE_102635_length_195_cov_6.037975_g102333_i0 | PRJNA725806 | 102635 | 195 | 6.037975 | 11.77405125 | Candidatus Rifleibacteriota bacterium | 2053586 | Bacteria | Bacteria | 42.7 | 0.0198 | NR | MDD3146703.1 | 2053586 | g102333 | i0 | 35.6 | 0.692307692307692 | 45 | 29 | 69.2 | 0 | 189 | 55 | 34 | 78 | MDD3146703.1 hypothetical protein [Candidatus Rifleibacteriota bacterium] | diamond | 135 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rifleibacteriota | Candidatus Rifleibacteriota bacterium | ||||||
| 31189334 | 31189334 | PRJNA725806_P_NODE_142855_length_172_cov_2.570370_g142553_i0 | PRJNA725806 | 142855 | 172 | 2.57037 | 4.4210364 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 42.7 | 0.0146 | NR | MFQ6040197.1 | 2026781 | g142553 | i0 | 41.3 | 0.802325581395349 | 46 | 25 | 76.7 | 1 | 29 | 160 | 180 | 225 | MFQ6040197.1 aldehyde dehydrogenase family protein [Candidatus Poribacteria bacterium] | diamond | 138 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 31506149 | 31506149 | PRJNA725806_P_NODE_113036_length_188_cov_6.231788_g112734_i0 | PRJNA725806 | 113036 | 188 | 6.231788 | 11.71576144 | Candidatus Nomurabacteria bacterium RIFCSPLOWO2_ | 2052152 | Bacteria | Bacteria | 43.1 | 0.0133 | NR | OGI90090.1 | 1801772 | g112734 | i0 | 32.1 | 0.845744680851064 | 53 | 33 | 79.8 | 1 | 164 | 15 | 682 | 734 | OGI90090.1 MAG: hypothetical protein A2911_00275 [Candidatus Nomurabacteria bacterium RIFCSPLOWO2_01_FULL_40_15] | diamond | 159 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium RIFCSPLOWO2_01_FULL_40_15 | ||||||
| 31601027 | 31601027 | PRJNA725806_P_NODE_152136_length_168_cov_0.984733_g151834_i0 | PRJNA725806 | 152136 | 168 | 0.984733 | 1.65435144 | Candidatus Wolfebacteria bacterium GW2 | 2030812 | Bacteria | Bacteria | 40.4 | 0.0396 | NR | KKR12499.1 | 1619013 | g151834 | i0 | 32.1 | 0.946428571428571 | 53 | 35 | 92.9 | 1 | 161 | 6 | 36 | 88 | KKR12499.1 MAG: hypothetical protein UT41_C0001G0043 [Candidatus Wolfebacteria bacterium GW2011_GWC2_39_22] | diamond | 159 | 40.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Wolfeibacteriota | Candidatus Wolfebacteria bacterium GW2011_GWC2_39_22 | ||||||
| 32360481 | 32360481 | PRJNA725806_P_NODE_86539_length_208_cov_1.239766_g86238_i0 | PRJNA725806 | 86539 | 208 | 1.239766 | 2.57871328 | candidate division WOR-3 bacterium | 2052148 | Bacteria | Bacteria | 40.8 | 0.0269 | NR | MEO0292599.1 | 2052148 | g86238 | i0 | 37.5 | 0.576923076923077 | 40 | 25 | 57.7 | 0 | 87 | 206 | 18 | 57 | MEO0292599.1 4Fe-4S dicluster domain-containing protein [candidate division WOR-3 bacterium] | diamond | 120 | 40.8 | 1 | Bacteria | Bacteria candidate phyla | candidate division WOR-3 | candidate division WOR-3 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);;