contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJEB14175" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26053500 | 26053500 | PRJEB14175_P_NODE_37837_length_607_cov_1.791209_g35663_i0 | PRJEB14175 | 37837 | 607 | 1.791209 | 10.87263863 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 176 | 7.76e-53 | NR | HJU61822.1 | 2838779 | g35663 | i0 | 73.9 | 1.08731466227348 | 111 | 29 | 54.9 | 0 | 605 | 273 | 25 | 135 | HJU61822.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 660 | 176 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 26186314 | 26186314 | PRJEB14175_P_NODE_204702_length_224_cov_19.098160_g202435_i0 | PRJEB14175 | 204702 | 224 | 19.09816 | 42.7798784 | Candidatus Binatus sp. | 2811406 | Bacteria | Bacteria | 57 | 2.33e-7 | NR | HZD13180.1 | 2811406 | g202435 | i0 | 49 | 1.32589285714286 | 51 | 26 | 68.3 | 0 | 19 | 171 | 251 | 301 | HZD13180.1 DUF5309 family protein [Candidatus Binatus sp.] | diamond | 297 | 57 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 26328018 | 26328018 | PRJEB14175_P_NODE_81239_length_404_cov_100.058309_g78977_i0 | PRJEB14175 | 81239 | 404 | 100.058309 | 404.23556836 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 114 | 2.63e-27 | NR | HYC79955.1 | 2838779 | g78977 | i0 | 49.5 | 0.809405940594059 | 109 | 55 | 80.9 | 0 | 390 | 64 | 240 | 348 | HYC79955.1 ribosome small subunit-dependent GTPase A [Candidatus Binatia bacterium] | diamond | 327 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32925579 | 32925579 | PRJEB14175_P_NODE_138249_length_292_cov_1.870130_g135982_i0 | PRJEB14175 | 138249 | 292 | 1.87013 | 5.4607796 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 134 | 2.18e-34 | NR | HEX6172948.1 | 2838779 | g135982 | i0 | 92.1 | 1.56164383561644 | 76 | 6 | 78.1 | 0 | 63 | 290 | 1 | 76 | HEX6172948.1 molybdopterin cofactor-binding domain-containing protein [Candidatus Binatia bacterium] | diamond | 456 | 134 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32926923 | 32926923 | PRJEB14175_P_NODE_38425_length_602_cov_1.828096_g36248_i0 | PRJEB14175 | 38425 | 602 | 1.828096 | 11.00513792 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 75.5 | 2.55e-12 | NR | HEX6175314.1 | 2838779 | g36248 | i0 | 86.8 | 0.18936877076412 | 38 | 5 | 18.9 | 0 | 257 | 370 | 14 | 51 | HEX6175314.1 transposase [Candidatus Binatia bacterium] | diamond | 114 | 75.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32943824 | 32943824 | PRJEB14175_P_NODE_258786_length_201_cov_0.914286_g256518_i0 | PRJEB14175 | 258786 | 201 | 0.914286 | 1.83771486 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 42.7 | 0.0209 | NR | HEY7553935.1 | 2838779 | g256518 | i0 | 35.7 | 0.835820895522388 | 56 | 34 | 80.6 | 1 | 21 | 182 | 331 | 386 | HEY7553935.1 glycosyltransferase [Candidatus Binatia bacterium] | diamond | 168 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32961260 | 32961260 | PRJEB14175_P_NODE_30146_length_677_cov_4.511364_g28055_i0 | PRJEB14175 | 30146 | 677 | 4.511364 | 30.54193428 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 145 | 4.24e-36 | NR | HEX9273875.1 | 2838779 | g28055 | i0 | 37.9 | 1.02806499261448 | 232 | 124 | 97.5 | 7 | 15 | 674 | 49 | 272 | HEX9273875.1 Atxe2 family lasso peptide isopeptidase [Candidatus Binatia bacterium] | diamond | 696 | 145 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32973974 | 32973974 | PRJEB14175_P_NODE_183962_length_241_cov_2.811111_g181695_i0 | PRJEB14175 | 183962 | 241 | 2.811111 | 6.77477751 | Bacillati | 1783272 | Bacteria | Bacteria | 83.2 | 1.75e-16 | NR | HYC53889.1 | 2838779 | g181695 | i0 | 59.7 | 1.54356846473029 | 62 | 25 | 77.2 | 0 | 198 | 13 | 138 | 199 | HYC53889.1 cytochrome P450 [Candidatus Binatia bacterium] | diamond | 372 | 84 | 0.990476190476191 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32977066 | 32977066 | PRJEB14175_P_NODE_136835_length_294_cov_1.648069_g134568_i0 | PRJEB14175 | 136835 | 294 | 1.648069 | 4.84532286 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 84.7 | 7.89e-17 | NR | HEX9143897.1 | 2838779 | g134568 | i0 | 81.1 | 0.540816326530612 | 53 | 10 | 54.1 | 0 | 136 | 294 | 246 | 298 | HEX9143897.1 THUMP domain-containing protein [Candidatus Binatia bacterium] | diamond | 159 | 84.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 33012554 | 33012554 | PRJEB14175_P_NODE_58644_length_485_cov_4.002358_g56391_i0 | PRJEB14175 | 58644 | 485 | 4.002358 | 19.4114363 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 241 | 3.7e-79 | NR | HSC41633.1 | 2838779 | g56391 | i0 | 92.2 | 0.797938144329897 | 129 | 9 | 79.8 | 1 | 405 | 19 | 1 | 128 | HSC41633.1 CsbD family protein [Candidatus Binatia bacterium] | diamond | 387 | 241 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 33029960 | 33029960 | PRJEB14175_P_NODE_91908_length_376_cov_25.815873_g89642_i0 | PRJEB14175 | 91908 | 376 | 25.815873 | 97.06768248 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 57.4 | 8.74e-7 | NR | HEV8714539.1 | 2838779 | g89642 | i0 | 52.3 | 0.351063829787234 | 44 | 21 | 35.1 | 0 | 277 | 146 | 231 | 274 | HEV8714539.1 IS5 family transposase [Candidatus Binatia bacterium] | diamond | 132 | 57.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 33045437 | 33045437 | PRJEB14175_P_NODE_168413_length_256_cov_2.087179_g166146_i0 | PRJEB14175 | 168413 | 256 | 2.087179 | 5.34317824 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 135 | 1.3e-36 | NR | HXV81098.1 | 2838779 | g166146 | i0 | 92.1 | 0.890625 | 76 | 6 | 89.1 | 0 | 230 | 3 | 179 | 254 | HXV81098.1 ABC transporter substrate-binding protein [Candidatus Binatia bacterium] | diamond | 228 | 135 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 33062979 | 33062979 | PRJEB14175_P_NODE_223317_length_211_cov_2.786667_g221049_i0 | PRJEB14175 | 223317 | 211 | 2.786667 | 5.87986737 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 53.1 | 5.06e-6 | NR | MET0501614.1 | 2838779 | g221049 | i0 | 100 | 0.369668246445498 | 26 | 0 | 37 | 0 | 78 | 1 | 1 | 26 | MET0501614.1 ABC transporter substrate-binding protein [Candidatus Binatia bacterium] | diamond | 78 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 33076021 | 33076021 | PRJEB14175_P_NODE_132045_length_301_cov_1.366667_g129778_i0 | PRJEB14175 | 132045 | 301 | 1.366667 | 4.11366767 | Bacillati | 1783272 | Bacteria | Bacteria | 184 | 1.4599999999999997e-52 | NR | HWP63754.1 | 2838779 | g129778 | i0 | 86 | 7.9734219269103 | 100 | 14 | 99.7 | 0 | 2 | 301 | 430 | 529 | HWP63754.1 vanadium-dependent haloperoxidase [Candidatus Binatia bacterium] | diamond | 2400 | 185 | 0.994594594594595 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 33096087 | 33096087 | PRJEB14175_P_NODE_104558_length_348_cov_3.296167_g102292_i0 | PRJEB14175 | 104558 | 348 | 3.296167 | 11.47066116 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 78.6 | 1.26e-16 | NR | HEY6996375.1 | 2838779 | g102292 | i0 | 90.9 | 0.379310344827586 | 44 | 4 | 37.9 | 0 | 254 | 123 | 25 | 68 | HEY6996375.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 132 | 78.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 33096446 | 33096446 | PRJEB14175_P_NODE_143494_length_285_cov_1.142857_g141227_i0 | PRJEB14175 | 143494 | 285 | 1.142857 | 3.25714245 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 159 | 3.25e-45 | NR | HEV8725742.1 | 2838779 | g141227 | i0 | 77.4 | 2.93684210526316 | 93 | 21 | 97.9 | 0 | 1 | 279 | 172 | 264 | HEV8725742.1 glycosyltransferase [Candidatus Binatia bacterium] | diamond | 837 | 159 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 33147696 | 33147696 | PRJEB14175_P_NODE_154840_length_271_cov_1.771429_g152573_i0 | PRJEB14175 | 154840 | 271 | 1.771429 | 4.80057259 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 42 | 0.0186 | NR | HVC44605.1 | 2785449 | g152573 | i0 | 48.1 | 0.575645756457565 | 52 | 26 | 56.5 | 1 | 111 | 263 | 3 | 54 | HVC44605.1 hypothetical protein [Candidatus Binataceae bacterium] | diamond | 156 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 33164545 | 33164545 | PRJEB14175_P_NODE_142768_length_286_cov_1.137778_g140501_i0 | PRJEB14175 | 142768 | 286 | 1.137778 | 3.25404508 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 59.3 | 8.61e-8 | NR | HZC25017.1 | 2838779 | g140501 | i0 | 46.8 | 0.828671328671329 | 79 | 37 | 78.7 | 4 | 2 | 226 | 288 | 365 | HZC25017.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 237 | 59.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 33166281 | 33166281 | PRJEB14175_P_NODE_86584_length_390_cov_3.425532_g84319_i0 | PRJEB14175 | 86584 | 390 | 3.425532 | 13.3595748 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 171 | 4.6e-52 | NR | HEY2922760.1 | 2838779 | g84319 | i0 | 71.3 | 4.5 | 115 | 33 | 88.5 | 0 | 347 | 3 | 1 | 115 | HEY2922760.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 1755 | 171 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia 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);;