contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA630162" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14631153 | 14631153 | PRJNA630162_P_NODE_3652_length_987_cov_38.815565_g2789_i0 | PRJNA630162 | 3652 | 987 | 38.815565 | 383.10962655 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 75.1 | 7.67e-11 | NR | MFN8601370.1 | 2838779 | g2789 | i0 | 32.8 | 0.620060790273556 | 204 | 112 | 57.1 | 11 | 93 | 656 | 18 | 212 | MFN8601370.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 612 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27080644 | 27080644 | PRJNA630162_P_NODE_1222_length_1527_cov_37.710419_g209_i6 | PRJNA630162 | 1222 | 1527 | 37.710419 | 575.83809813 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 79 | 2.88e-11 | NR | HZR82167.1 | 2838779 | g209 | i6 | 34.1 | 1.1139489194499 | 179 | 89 | 33.2 | 8 | 524 | 18 | 47 | 206 | HZR82167.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 1701 | 79 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27681368 | 27681368 | PRJNA630162_P_NODE_704_length_1859_cov_199.483425_g472_i0 | PRJNA630162 | 704 | 1859 | 199.483425 | 3708.39687075 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 53.1 | 0.00363 | NR | MFN8601370.1 | 2838779 | g472 | i0 | 36.4 | 1.10220548682087 | 118 | 62 | 17.9 | 6 | 350 | 18 | 18 | 129 | MFN8601370.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 2049 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27775903 | 27775903 | PRJNA630162_P_NODE_344_length_2408_cov_98.414159_g209_i0 | PRJNA630162 | 344 | 2408 | 98.414159 | 2369.81294872 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 79 | 7.59e-11 | NR | HZR82167.1 | 2838779 | g209 | i0 | 34.1 | 0.706395348837209 | 179 | 89 | 21.1 | 8 | 1885 | 2391 | 47 | 206 | HZR82167.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 1701 | 79 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27996895 | 27996895 | PRJNA630162_P_NODE_705_length_1859_cov_64.781215_g473_i0 | PRJNA630162 | 705 | 1859 | 64.781215 | 1204.28278685 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 53.1 | 0.00363 | NR | MFN8601370.1 | 2838779 | g473 | i0 | 36.4 | 1.10220548682087 | 118 | 62 | 17.9 | 6 | 350 | 18 | 18 | 129 | MFN8601370.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 2049 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28154815 | 28154815 | PRJNA630162_P_NODE_485_length_2129_cov_86.864904_g209_i1 | PRJNA630162 | 485 | 2129 | 86.864904 | 1849.35380616 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 79 | 6.1e-11 | NR | HZR82167.1 | 2838779 | g209 | i1 | 34.1 | 0.798966651009864 | 179 | 89 | 23.8 | 8 | 1606 | 2112 | 47 | 206 | HZR82167.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 1701 | 79 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28249135 | 28249135 | PRJNA630162_P_NODE_43206_length_270_cov_0.900452_g41683_i0 | PRJNA630162 | 43206 | 270 | 0.900452 | 2.4312204 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 49.3 | 2.47e-4 | NR | MFN2375181.1 | 2838779 | g41683 | i0 | 37.6 | 1.91111111111111 | 93 | 34 | 94.4 | 5 | 257 | 3 | 99 | 175 | MFN2375181.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 516 | 49.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28912160 | 28912160 | PRJNA630162_P_NODE_748_length_1814_cov_7.714448_g507_i0 | PRJNA630162 | 748 | 1814 | 7.714448 | 139.94008672 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 89.7 | 1.89e-14 | NR | HZR82167.1 | 2838779 | g507 | i0 | 35.9 | 0.955898566703418 | 192 | 97 | 31.1 | 8 | 1162 | 1725 | 36 | 205 | HZR82167.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 1734 | 89.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29386094 | 29386094 | PRJNA630162_P_NODE_3449_length_1008_cov_41.298227_g2629_i0 | PRJNA630162 | 3449 | 1008 | 41.298227 | 416.28612816 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 74.7 | 1.12e-10 | NR | MFN8601370.1 | 2838779 | g2629 | i0 | 32.8 | 0.607142857142857 | 204 | 112 | 56 | 11 | 93 | 656 | 18 | 212 | MFN8601370.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 612 | 74.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30112212 | 30112212 | PRJNA630162_P_NODE_161772_length_162_cov_0.920354_g160249_i0 | PRJNA630162 | 161772 | 162 | 0.920354 | 1.49097348 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 61.2 | 4.58e-10 | NR | MFN2428019.1 | 2838779 | g160249 | i0 | 62.7 | 0.944444444444444 | 51 | 19 | 94.4 | 0 | 8 | 160 | 90 | 140 | MFN2428019.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 153 | 61.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30270457 | 30270457 | PRJNA630162_P_NODE_1032_length_1616_cov_66.077856_g209_i5 | PRJNA630162 | 1032 | 1616 | 66.077856 | 1067.81815296 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 79 | 3.35e-11 | NR | HZR82167.1 | 2838779 | g209 | i5 | 34.1 | 1.05259900990099 | 179 | 89 | 31.4 | 8 | 1093 | 1599 | 47 | 206 | HZR82167.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 1701 | 79 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30302346 | 30302346 | PRJNA630162_P_NODE_2032_length_1255_cov_38.105307_g209_i7 | PRJNA630162 | 2032 | 1255 | 38.105307 | 478.22160285 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 80.1 | 6.49e-12 | NR | HZR82167.1 | 2838779 | g209 | i7 | 34.1 | 0.427888446215139 | 179 | 89 | 40.4 | 8 | 337 | 843 | 47 | 206 | HZR82167.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 537 | 80.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30902260 | 30902260 | PRJNA630162_P_NODE_164254_length_160_cov_2.135135_g162731_i0 | PRJNA630162 | 164254 | 160 | 2.135135 | 3.416216 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 56.2 | 2.11e-7 | NR | HEU4344052.1 | 2838779 | g162731 | i0 | 51 | 0.91875 | 49 | 24 | 91.9 | 0 | 151 | 5 | 599 | 647 | HEU4344052.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 147 | 56.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31186354 | 31186354 | PRJNA630162_P_NODE_495_length_2113_cov_65.920058_g209_i2 | PRJNA630162 | 495 | 2113 | 65.920058 | 1392.89082554 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 79 | 6e-11 | NR | HZR82167.1 | 2838779 | g209 | i2 | 34.1 | 0.805016564126834 | 179 | 89 | 24 | 8 | 524 | 18 | 47 | 206 | HZR82167.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 1701 | 79 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31344895 | 31344895 | PRJNA630162_P_NODE_89936_length_192_cov_1.188811_g88413_i0 | PRJNA630162 | 89936 | 192 | 1.188811 | 2.28251712 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 123 | 6.619999999999999e-31 | NR | HET9296885.1 | 2838779 | g88413 | i0 | 96.8 | 2.90625 | 62 | 2 | 96.9 | 0 | 186 | 1 | 395 | 456 | HET9296885.1 DNA gyrase subunit A [Candidatus Binatia bacterium] | diamond | 558 | 123 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31502981 | 31502981 | PRJNA630162_P_NODE_130156_length_169_cov_2.141667_g128633_i0 | PRJNA630162 | 130156 | 169 | 2.141667 | 3.61941723 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 41.2 | 0.0472 | NR | HUE40172.1 | 2838779 | g128633 | i0 | 37 | 0.816568047337278 | 46 | 29 | 81.7 | 0 | 161 | 24 | 196 | 241 | HUE40172.1 wax ester/triacylglycerol synthase family O-acyltransferase [Candidatus Binatia bacterium] | diamond | 138 | 41.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32040686 | 32040686 | PRJNA630162_P_NODE_5138_length_841_cov_34.699495_g4081_i0 | PRJNA630162 | 5138 | 841 | 34.699495 | 291.82275295 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 75.9 | 2.04e-11 | NR | MFN8601370.1 | 2838779 | g4081 | i0 | 32.8 | 1.48038049940547 | 204 | 112 | 67.1 | 11 | 93 | 656 | 18 | 212 | MFN8601370.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 1245 | 75.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32388778 | 32388778 | PRJNA630162_P_NODE_98119_length_187_cov_1.115942_g96596_i0 | PRJNA630162 | 98119 | 187 | 1.115942 | 2.08681154 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 44.3 | 0.00451 | NR | HJY83341.1 | 2838779 | g96596 | i0 | 64.3 | 0.449197860962567 | 28 | 10 | 44.9 | 0 | 84 | 1 | 59 | 86 | HJY83341.1 class I SAM-dependent methyltransferase [Candidatus Binatia bacterium] | diamond | 84 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32767350 | 32767350 | PRJNA630162_P_NODE_660_length_1899_cov_64.263243_g209_i3 | PRJNA630162 | 660 | 1899 | 64.263243 | 1220.35898457 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 79 | 4.86e-11 | NR | HZR82167.1 | 2838779 | g209 | i3 | 34.1 | 0.895734597156398 | 179 | 89 | 26.7 | 8 | 1376 | 1882 | 47 | 206 | HZR82167.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 1701 | 79 | 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);;