contig_metadata
12 rows where bioproject = "PRJNA799842" and tax_phylum = "Candidatus Woeseibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19920474 | 19920474 | PRJNA799842_P_NODE_150936_length_248_cov_0.880000_g149363_i0 | PRJNA799842 | 150936 | 248 | 0.88 | 2.1824 | Candidatus Woesebacteria bacterium | 2026804 | Bacteria | Bacteria | 155 | 2.53e-47 | NR | MBP6933299.1 | 2026804 | g149363 | i0 | 81.7 | 5.95161290322581 | 82 | 15 | 99.2 | 0 | 246 | 1 | 8 | 89 | MBP6933299.1 30S ribosomal protein S19 [Candidatus Woesebacteria bacterium] | diamond | 1476 | 155 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium | ||||||
| 26904899 | 26904899 | PRJNA799842_P_NODE_158921_length_247_cov_0.885057_g157348_i0 | PRJNA799842 | 158921 | 247 | 0.885057 | 2.18609079 | Bacteria | 2 | Bacteria | Bacteria | 132 | 5.609999999999999e-35 | NR | KKQ37352.1 | 1618545 | g157348 | i0 | 72.8 | 2.95141700404858 | 81 | 22 | 98.4 | 0 | 245 | 3 | 286 | 366 | KKQ37352.1 MAG: Quinoprotein glucose dehydrogenase [Candidatus Woesebacteria bacterium GW2011_GWA1_37_7] | diamond | 729 | 132 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GW2011_GWA1_37_7 | ||||||
| 27843544 | 27843544 | PRJNA799842_P_NODE_155564_length_247_cov_0.885057_g153991_i0 | PRJNA799842 | 155564 | 247 | 0.885057 | 2.18609079 | Candidatus Woesebacteria bacterium | 2026804 | Bacteria | Bacteria | 46.2 | 0.00235 | NR | TEU01770.1 | 2026804 | g153991 | i0 | 60.5 | 0.923076923076923 | 38 | 15 | 46.2 | 0 | 53 | 166 | 244 | 281 | TEU01770.1 MAG: phospholipid carrier-dependent glycosyltransferase [Candidatus Woesebacteria bacterium] | diamond | 228 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium | ||||||
| 28064721 | 28064721 | PRJNA799842_P_NODE_156985_length_247_cov_0.885057_g155412_i0 | PRJNA799842 | 156985 | 247 | 0.885057 | 2.18609079 | Candidatus Woesebacteria bacterium GWB1_37_5 | 1802473 | Bacteria | Bacteria | 77.8 | 1.74e-14 | NR | OGM04143.1 | 1802473 | g155412 | i0 | 82.6 | 2.79352226720648 | 46 | 8 | 55.9 | 0 | 28 | 165 | 1 | 46 | OGM04143.1 MAG: hypothetical protein A2124_04210 [Candidatus Woesebacteria bacterium GWB1_37_5] | diamond | 690 | 77.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GWB1_37_5 | ||||||
| 28853874 | 28853874 | PRJNA799842_P_NODE_124248_length_262_cov_1.629630_g122675_i0 | PRJNA799842 | 124248 | 262 | 1.62963 | 4.2696306 | Candidatus Woesebacteria bacterium GW2 | 2026804 | Bacteria | Bacteria | 120 | 5.85e-30 | NR | KKR72209.1 | 1618562 | g122675 | i0 | 71.3 | 2.98854961832061 | 87 | 25 | 99.6 | 0 | 1 | 261 | 260 | 346 | KKR72209.1 MAG: hypothetical protein UU16_C0044G0007 [Candidatus Woesebacteria bacterium GW2011_GWA2_40_7] | diamond | 783 | 120 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GW2011_GWA2_40_7 | ||||||
| 29241982 | 29241982 | PRJNA799842_P_NODE_140809_length_250_cov_0.870056_g139236_i0 | PRJNA799842 | 140809 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 149 | 3.5899999999999998e-40 | NR | OGM02468.1 | 1802471 | g139236 | i0 | 90.2 | 8.844 | 82 | 8 | 98.4 | 0 | 248 | 3 | 399 | 480 | OGM02468.1 MAG: cell division protein FtsH [Candidatus Woesebacteria bacterium GWA1_41_8] | diamond | 2211 | 149 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GWA1_41_8 | ||||||
| 30252766 | 30252766 | PRJNA799842_P_NODE_119972_length_267_cov_1.587629_g118399_i0 | PRJNA799842 | 119972 | 267 | 1.587629 | 4.23896943 | Bacteria | 2 | Bacteria | Bacteria | 99.4 | 6.89e-23 | NR | KKQ96782.1 | 1618549 | g118399 | i0 | 60.6 | 3.95505617977528 | 71 | 28 | 79.8 | 0 | 54 | 266 | 55 | 125 | KKQ96782.1 MAG: Glycosyl transferase, family 2 [Candidatus Woesebacteria bacterium GW2011_GWA1_39_12] | diamond | 1056 | 99.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GW2011_GWA1_39_12 | ||||||
| 30600012 | 30600012 | PRJNA799842_P_NODE_162513_length_246_cov_0.890173_g160940_i0 | PRJNA799842 | 162513 | 246 | 0.890173 | 2.18982558 | Bacteria | 2 | Bacteria | Bacteria | 138 | 3.11e-36 | NR | MBP9814044.1 | 2026804 | g160940 | i0 | 81.5 | 3.98780487804878 | 81 | 15 | 98.8 | 0 | 4 | 246 | 144 | 224 | MBP9814044.1 ATP-dependent DNA ligase [Candidatus Woesebacteria bacterium] | diamond | 981 | 139 | 0.992805755395683 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium | ||||||
| 30780702 | 30780702 | PRJNA799842_P_NODE_190114_length_241_cov_0.916667_g188541_i0 | PRJNA799842 | 190114 | 241 | 0.916667 | 2.20916747 | Candidatus Woesebacteria bacterium GW2 | 2026804 | Bacteria | Bacteria | 75.5 | 1.07e-13 | NR | AKM83696.1 | 1618600 | g188541 | i0 | 72.1 | 0.535269709543568 | 43 | 12 | 53.5 | 0 | 231 | 103 | 511 | 553 | AKM83696.1 MAG: type 11 methyltransferase [Candidatus Woesebacteria bacterium GW2011_GWF1_31_35] | diamond | 129 | 75.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GW2011_GWF1_31_35 | ||||||
| 31602781 | 31602781 | PRJNA799842_P_NODE_179976_length_243_cov_0.905882_g178403_i0 | PRJNA799842 | 179976 | 243 | 0.905882 | 2.20129326 | Candidatus Woesebacteria bacterium RIFCSPHIGHO2_ | 2026804 | Bacteria | Bacteria | 84 | 1.11e-16 | NR | OGM24407.1 | 1802497 | g178403 | i0 | 51.3 | 0.938271604938272 | 76 | 37 | 93.8 | 0 | 241 | 14 | 77 | 152 | OGM24407.1 MAG: hypothetical protein A2715_00550 [Candidatus Woesebacteria bacterium RIFCSPHIGHO2_01_FULL_39_32] | diamond | 228 | 84 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium RIFCSPHIGHO2_01_FULL_39_32 | ||||||
| 31729062 | 31729062 | PRJNA799842_P_NODE_150597_length_248_cov_0.880000_g149024_i0 | PRJNA799842 | 150597 | 248 | 0.88 | 2.1824 | Candidatus Woesebacteria bacterium GWB1_37_5 | 1802473 | Bacteria | Bacteria | 122 | 7.729999999999999e-31 | NR | OGM05086.1 | 1802473 | g149024 | i0 | 81.3 | 2.92741935483871 | 80 | 15 | 96.8 | 0 | 244 | 5 | 287 | 366 | OGM05086.1 MAG: hypothetical protein A2124_01280 [Candidatus Woesebacteria bacterium GWB1_37_5] | diamond | 726 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GWB1_37_5 | ||||||
| 32425234 | 32425234 | PRJNA799842_P_NODE_148819_length_249_cov_0.875000_g147246_i0 | PRJNA799842 | 148819 | 249 | 0.875 | 2.17875 | Candidatus Woesebacteria bacterium RIFCSPHIGHO2_ | 2026804 | Bacteria | Bacteria | 95.1 | 7.840000000000001e-21 | NR | OGM28918.1 | 1802498 | g147246 | i0 | 92.3 | 0.626506024096386 | 52 | 4 | 62.7 | 0 | 1 | 156 | 352 | 403 | OGM28918.1 MAG: glycine C-acetyltransferase [Candidatus Woesebacteria bacterium RIFCSPHIGHO2_01_FULL_39_95] | diamond | 156 | 95.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium RIFCSPHIGHO2_01_FULL_39_95 |
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);;