contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA1002570" and tax_phylum = "Candidatus Binatota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1426903 | 1426903 | PRJNA1002570_P_NODE_18522_length_297_cov_1.031250_g18327_i0 | PRJNA1002570 | 18522 | 297 | 1.03125 | 3.0628125 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 159 | 1.05e-44 | NR | HVA80954.1 | 2785449 | g18327 | i0 | 79.6 | 0.98989898989899 | 98 | 20 | 99 | 0 | 2 | 295 | 257 | 354 | HVA80954.1 IS1182 family transposase [Candidatus Binataceae bacterium] | diamond | 294 | 159 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 2702558 | 2702558 | PRJNA1002570_P_NODE_27303_length_274_cov_1.532338_g27108_i0 | PRJNA1002570 | 27303 | 274 | 1.532338 | 4.19860612 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 152 | 9.45e-41 | NR | HMJ66131.1 | 2838779 | g27108 | i0 | 80.2 | 1.99270072992701 | 91 | 18 | 99.6 | 0 | 1 | 273 | 108 | 198 | HMJ66131.1 type I restriction endonuclease subunit R [Candidatus Binatia bacterium] | diamond | 546 | 152 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 14180864 | 14180864 | PRJNA1002570_P_NODE_21512_length_287_cov_1.747664_g21317_i0 | PRJNA1002570 | 21512 | 287 | 1.747664 | 5.01579568 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 178 | 2.49e-51 | NR | HXV48985.1 | 2838779 | g21317 | i0 | 83.2 | 13.8919860627178 | 95 | 16 | 99.3 | 0 | 286 | 2 | 5 | 99 | HXV48985.1 GMC family oxidoreductase [Candidatus Binatia bacterium] | diamond | 3987 | 178 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27413909 | 27413909 | PRJNA1002570_P_NODE_10083_length_367_cov_1.571429_g9888_i0 | PRJNA1002570 | 10083 | 367 | 1.571429 | 5.76714443 | Candidatus Binatus sp. | 2811406 | Bacteria | Bacteria | 133 | 1.5e-35 | NR | HXN19855.1 | 2811406 | g9888 | i0 | 55.3 | 0.931880108991826 | 114 | 51 | 93.2 | 0 | 365 | 24 | 69 | 182 | HXN19855.1 alpha/beta hydrolase [Candidatus Binatus sp.] | diamond | 342 | 133 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 27666437 | 27666437 | PRJNA1002570_P_NODE_22324_length_285_cov_2.169811_g22129_i0 | PRJNA1002570 | 22324 | 285 | 2.169811 | 6.18396135 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 95.9 | 1.28e-20 | NR | HEV7733660.1 | 2838779 | g22129 | i0 | 57.3 | 0.936842105263158 | 89 | 23 | 77.9 | 1 | 2 | 223 | 695 | 783 | HEV7733660.1 tetratricopeptide repeat protein [Candidatus Binatia bacterium] | diamond | 267 | 95.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27918785 | 27918785 | PRJNA1002570_P_NODE_34085_length_256_cov_1.639344_g33890_i0 | PRJNA1002570 | 34085 | 256 | 1.639344 | 4.19672064 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 63.5 | 1.89e-9 | NR | MFN8602964.1 | 2838779 | g33890 | i0 | 43 | 0.92578125 | 79 | 44 | 91.4 | 1 | 248 | 15 | 205 | 283 | MFN8602964.1 glycosyltransferase family 4 protein [Candidatus Binatia bacterium] | diamond | 237 | 63.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28329269 | 28329269 | PRJNA1002570_P_NODE_8286_length_395_cov_2.816770_g8091_i0 | PRJNA1002570 | 8286 | 395 | 2.81677 | 11.1262415 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 54.3 | 1.57e-5 | NR | HVA81069.1 | 2785449 | g8091 | i0 | 42.4 | 0.448101265822785 | 59 | 34 | 44.8 | 0 | 394 | 218 | 277 | 335 | HVA81069.1 glycosyltransferase family 4 protein [Candidatus Binataceae bacterium] | diamond | 177 | 54.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 28645165 | 28645165 | PRJNA1002570_P_NODE_20407_length_289_cov_2.314815_g20212_i0 | PRJNA1002570 | 20407 | 289 | 2.314815 | 6.68981535 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 113 | 8.240000000000001e-27 | NR | HUN56491.1 | 2785449 | g20212 | i0 | 66.3 | 0.986159169550173 | 95 | 32 | 98.6 | 0 | 287 | 3 | 589 | 683 | HUN56491.1 MobF family relaxase [Candidatus Binataceae bacterium] | diamond | 285 | 113 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 28645183 | 28645183 | PRJNA1002570_P_NODE_3127_length_605_cov_1.588346_g2937_i0 | PRJNA1002570 | 3127 | 605 | 1.588346 | 9.6094933 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 79 | 3.38e-13 | NR | HEX6439573.1 | 2838779 | g2937 | i0 | 37.2 | 0.852892561983471 | 172 | 99 | 81.8 | 4 | 9 | 503 | 378 | 547 | HEX6439573.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 516 | 79 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28897550 | 28897550 | PRJNA1002570_P_NODE_6908_length_425_cov_1.823864_g6714_i0 | PRJNA1002570 | 6908 | 425 | 1.823864 | 7.751422 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 133 | 1.57e-34 | NR | HJU61047.1 | 2838779 | g6714 | i0 | 60.4 | 0.748235294117647 | 106 | 40 | 74.8 | 1 | 423 | 106 | 250 | 353 | HJU61047.1 VOC family protein [Candidatus Binatia bacterium] | diamond | 318 | 133 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29560535 | 29560535 | PRJNA1002570_P_NODE_34270_length_255_cov_2.967033_g34075_i0 | PRJNA1002570 | 34270 | 255 | 2.967033 | 7.56593415 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 78.6 | 1.07e-14 | NR | HEV8716789.1 | 2838779 | g34075 | i0 | 46.5 | 1.01176470588235 | 86 | 40 | 94.1 | 1 | 16 | 255 | 37 | 122 | HEV8716789.1 SBBP repeat-containing protein [Candidatus Binatia bacterium] | diamond | 258 | 78.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30034524 | 30034524 | PRJNA1002570_P_NODE_34191_length_256_cov_1.262295_g33996_i0 | PRJNA1002570 | 34191 | 256 | 1.262295 | 3.2314752 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 49.7 | 1.53e-4 | NR | MFN8602964.1 | 2838779 | g33996 | i0 | 32.6 | 1.0078125 | 86 | 56 | 99.6 | 2 | 2 | 256 | 141 | 225 | MFN8602964.1 glycosyltransferase family 4 protein [Candidatus Binatia bacterium] | diamond | 258 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30065890 | 30065890 | PRJNA1002570_P_NODE_23392_length_283_cov_1.466667_g23197_i0 | PRJNA1002570 | 23392 | 283 | 1.466667 | 4.15066761 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 81.6 | 2.01e-17 | NR | HEY6394378.1 | 2785449 | g23197 | i0 | 45.1 | 6.43462897526502 | 91 | 49 | 95.4 | 1 | 11 | 280 | 3 | 93 | HEY6394378.1 RidA family protein [Candidatus Binataceae bacterium] | diamond | 1821 | 81.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 30539900 | 30539900 | PRJNA1002570_P_NODE_22473_length_285_cov_1.452830_g22278_i0 | PRJNA1002570 | 22473 | 285 | 1.45283 | 4.1405655 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 70.9 | 7.03e-13 | NR | HUS24064.1 | 2838779 | g22278 | i0 | 88.2 | 0.357894736842105 | 34 | 4 | 35.8 | 0 | 104 | 3 | 3 | 36 | HUS24064.1 alpha/beta hydrolase [Candidatus Binatia bacterium] | diamond | 102 | 70.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31202977 | 31202977 | PRJNA1002570_P_NODE_2555_length_676_cov_3.026534_g2368_i0 | PRJNA1002570 | 2555 | 676 | 3.026534 | 20.45936984 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 68.6 | 1.92e-9 | NR | HLK12695.1 | 2838779 | g2368 | i0 | 32.7 | 0.883136094674556 | 199 | 104 | 83.4 | 11 | 100 | 663 | 18 | 197 | HLK12695.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 597 | 68.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31298272 | 31298272 | PRJNA1002570_P_NODE_26475_length_276_cov_1.517241_g26280_i0 | PRJNA1002570 | 26475 | 276 | 1.517241 | 4.18758516 | Candidatus Binatus sp. | 2811406 | Bacteria | Bacteria | 67.4 | 1.16e-10 | NR | HXN17223.1 | 2811406 | g26280 | i0 | 42.2 | 0.978260869565217 | 90 | 52 | 97.8 | 0 | 2 | 271 | 627 | 716 | HXN17223.1 TIGR03790 family protein [Candidatus Binatus sp.] | diamond | 270 | 67.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 32152489 | 32152489 | PRJNA1002570_P_NODE_34998_length_253_cov_2.155556_g34803_i0 | PRJNA1002570 | 34998 | 253 | 2.155556 | 5.45355668 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 70.9 | 5.96e-14 | NR | HJY84106.1 | 2838779 | g34803 | i0 | 81 | 2.70355731225296 | 42 | 8 | 49.8 | 0 | 253 | 128 | 38 | 79 | HJY84106.1 MarR family transcriptional regulator [Candidatus Binatia bacterium] | diamond | 684 | 70.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32247717 | 32247717 | PRJNA1002570_P_NODE_38178_length_248_cov_1.760000_g37983_i0 | PRJNA1002570 | 38178 | 248 | 1.76 | 4.3648 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 71.2 | 2.42e-13 | NR | HJU12786.1 | 2785449 | g37983 | i0 | 43.9 | 0.991935483870968 | 82 | 46 | 99.2 | 0 | 248 | 3 | 28 | 109 | HJU12786.1 hypothetical protein [Candidatus Binataceae bacterium] | diamond | 246 | 71.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 32271713 | 32271713 | PRJNA1002570_P_NODE_22558_length_285_cov_1.330189_g22363_i0 | PRJNA1002570 | 22558 | 285 | 1.330189 | 3.79103865 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 110 | 2.02e-28 | NR | HLW71370.1 | 2785449 | g22363 | i0 | 62.6 | 3.73684210526316 | 91 | 34 | 95.8 | 0 | 275 | 3 | 55 | 145 | HLW71370.1 GNAT family N-acetyltransferase [Candidatus Binataceae bacterium] | diamond | 1065 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae 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);;