contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA1020641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1435388 | 1435388 | PRJNA1020641_P_NODE_5762_length_250_cov_0.870056_g5719_i0 | PRJNA1020641 | 5762 | 250 | 0.870056 | 2.17514 | Candidatus Rifleibacteriota bacterium | 2053586 | Bacteria | Bacteria | 158 | 2.1499999999999998e-46 | NR | MBR4329455.1 | 2053586 | g5719 | i0 | 87.8 | 0.984 | 82 | 10 | 98.4 | 0 | 3 | 248 | 74 | 155 | MBR4329455.1 hypothetical protein [Candidatus Rifleibacteriota bacterium] | diamond | 246 | 158 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rifleibacteriota | Candidatus Rifleibacteriota bacterium | ||||||
| 13756410 | 13756410 | PRJNA1020641_P_NODE_5991_length_249_cov_0.875000_g5948_i0 | PRJNA1020641 | 5991 | 249 | 0.875 | 2.17875 | Candidatus Nanosyncoccus | 2171995 | Bacteria | Bacteria | 163 | 3.0199999999999996e-47 | NR | MBR3368735.1 | 2026720 | g5948 | i0 | 92.8 | 14 | 83 | 6 | 100 | 0 | 249 | 1 | 213 | 295 | MBR3368735.1 recombinase RecA [Candidatus Saccharibacteria bacterium] | diamond | 3486 | 163 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 26686559 | 26686559 | PRJNA1020641_P_NODE_5541_length_251_cov_0.865169_g5498_i0 | PRJNA1020641 | 5541 | 251 | 0.865169 | 2.17157419 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 155 | 8.58e-44 | NR | MBO4812542.1 | 2026720 | g5498 | i0 | 86.7 | 1.9840637450199201 | 83 | 11 | 99.2 | 0 | 1 | 249 | 162 | 244 | MBO4812542.1 class I SAM-dependent RNA methyltransferase [Candidatus Saccharibacteria bacterium] | diamond | 498 | 155 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27098034 | 27098034 | PRJNA1020641_P_NODE_6162_length_248_cov_0.880000_g6119_i0 | PRJNA1020641 | 6162 | 248 | 0.88 | 2.1824 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 47.8 | 5.7e-4 | NR | MBR3332535.1 | 2026720 | g6119 | i0 | 35.1 | 0.895161290322581 | 74 | 46 | 87.1 | 1 | 225 | 10 | 112 | 185 | MBR3332535.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 222 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27216502 | 27216502 | PRJNA1020641_P_NODE_5742_length_250_cov_0.870056_g5699_i0 | PRJNA1020641 | 5742 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 91.7 | 2.53e-19 | NR | KKT22313.1 | 1618779 | g5699 | i0 | 60.5 | 3.9 | 81 | 32 | 97.2 | 0 | 243 | 1 | 721 | 801 | KKT22313.1 MAG: hypothetical protein UW07_C0039G0021 [Candidatus Nomurabacteria bacterium GW2011_GWF2_43_8] | diamond | 975 | 92 | 0.996739130434783 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium GW2011_GWF2_43_8 | ||||||
| 27761733 | 27761733 | PRJNA1020641_P_NODE_7224_length_242_cov_0.911243_g7181_i0 | PRJNA1020641 | 7224 | 242 | 0.911243 | 2.20520806 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 88.2 | 3.58e-18 | NR | MCX6751953.1 | 2052152 | g7181 | i0 | 59.7 | 2.87603305785124 | 77 | 31 | 95.5 | 0 | 10 | 240 | 137 | 213 | MCX6751953.1 hypothetical protein [Candidatus Nomurabacteria bacterium] | diamond | 696 | 88.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 28014247 | 28014247 | PRJNA1020641_P_NODE_6925_length_244_cov_0.900585_g6882_i0 | PRJNA1020641 | 6925 | 244 | 0.900585 | 2.1974274 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 149 | 3.139999999999999e-43 | NR | MBR5669715.1 | 2026720 | g6882 | i0 | 100 | 0.983606557377049 | 80 | 0 | 98.4 | 0 | 3 | 242 | 91 | 170 | MBR5669715.1 hemolysin III family protein [Candidatus Saccharibacteria bacterium] | diamond | 240 | 149 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28045578 | 28045578 | PRJNA1020641_P_NODE_6225_length_248_cov_0.862857_g6182_i0 | PRJNA1020641 | 6225 | 248 | 0.862857 | 2.13988536 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 85.5 | 1.53e-18 | NR | MDR0282711.1 | 2053688 | g6182 | i0 | 54.9 | 1.98387096774194 | 82 | 37 | 99.2 | 0 | 246 | 1 | 73 | 154 | MDR0282711.1 hypothetical protein [Candidatus Peribacteria bacterium] | diamond | 492 | 85.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 28677212 | 28677212 | PRJNA1020641_P_NODE_7307_length_242_cov_0.887574_g7264_i0 | PRJNA1020641 | 7307 | 242 | 0.887574 | 2.14792908 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 115 | 1.14e-30 | NR | MBR3269980.1 | 2026720 | g7264 | i0 | 73.8 | 0.991735537190083 | 80 | 21 | 99.2 | 0 | 3 | 242 | 37 | 116 | MBR3269980.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 240 | 115 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28803132 | 28803132 | PRJNA1020641_P_NODE_3548_length_325_cov_0.916667_g3505_i0 | PRJNA1020641 | 3548 | 325 | 0.916667 | 2.97916775 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 177 | 7.04e-49 | NR | MBR6126027.1 | 2026720 | g3505 | i0 | 86.1 | 0.996923076923077 | 108 | 15 | 99.7 | 0 | 325 | 2 | 219 | 326 | MBR6126027.1 FHA domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 324 | 177 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29718795 | 29718795 | PRJNA1020641_P_NODE_2990_length_355_cov_1.014184_g2947_i0 | PRJNA1020641 | 2990 | 355 | 1.014184 | 3.6003532 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 181 | 3.2299999999999998e-52 | NR | MBQ6414554.1 | 2026720 | g2947 | i0 | 87 | 1.55492957746479 | 92 | 12 | 77.7 | 0 | 3 | 278 | 401 | 492 | MBQ6414554.1 CapA family protein [Candidatus Saccharibacteria bacterium] | diamond | 552 | 181 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30034981 | 30034981 | PRJNA1020641_P_NODE_7111_length_243_cov_0.905882_g7068_i0 | PRJNA1020641 | 7111 | 243 | 0.905882 | 2.20129326 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 122 | 4.97e-30 | NR | MBR6126027.1 | 2026720 | g7068 | i0 | 82.7 | 1 | 81 | 14 | 100 | 0 | 1 | 243 | 211 | 291 | MBR6126027.1 FHA domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 243 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30066389 | 30066389 | PRJNA1020641_P_NODE_7392_length_241_cov_0.916667_g7349_i0 | PRJNA1020641 | 7392 | 241 | 0.916667 | 2.20916747 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 142 | 1.52e-39 | NR | MDO5475333.1 | 2026720 | g7349 | i0 | 98.6 | 0.858921161825726 | 69 | 1 | 85.9 | 0 | 208 | 2 | 1 | 69 | MDO5475333.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 207 | 142 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30224377 | 30224377 | PRJNA1020641_P_NODE_3272_length_339_cov_1.109023_g3229_i0 | PRJNA1020641 | 3272 | 339 | 1.109023 | 3.75958797 | Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_ | 1802312 | Bacteria | Bacteria | 44.3 | 0.0212 | NR | OHA27170.1 | 1802312 | g3229 | i0 | 38 | 0.699115044247788 | 79 | 44 | 69 | 3 | 12 | 245 | 98 | 172 | OHA27170.1 MAG: hypothetical protein A3C06_03790 [Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_02_FULL_46_13] | diamond | 237 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_02_FULL_46_13 | ||||||
| 30540394 | 30540394 | PRJNA1020641_P_NODE_5933_length_249_cov_0.875000_g5890_i0 | PRJNA1020641 | 5933 | 249 | 0.875 | 2.17875 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 87.4 | 3.86e-18 | NR | MBQ6127516.1 | 2026720 | g5890 | i0 | 52.1 | 2.33734939759036 | 96 | 30 | 98.8 | 2 | 247 | 2 | 198 | 291 | MBQ6127516.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 582 | 87.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31267220 | 31267220 | PRJNA1020641_P_NODE_5555_length_251_cov_0.865169_g5512_i0 | PRJNA1020641 | 5555 | 251 | 0.865169 | 2.17157419 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 135 | 7.5e-35 | NR | MBP5656152.1 | 2026720 | g5512 | i0 | 77.1 | 0.99203187250996006 | 83 | 19 | 99.2 | 0 | 250 | 2 | 536 | 618 | MBP5656152.1 ion transporter [Candidatus Saccharibacteria bacterium] | diamond | 249 | 135 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32279692 | 32279692 | PRJNA1020641_P_NODE_7479_length_241_cov_0.916667_g7436_i0 | PRJNA1020641 | 7479 | 241 | 0.916667 | 2.20916747 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 146 | 1.07e-38 | NR | MBQ6487445.1 | 2026720 | g7436 | i0 | 88.5 | 2.91286307053942 | 78 | 9 | 97.1 | 0 | 237 | 4 | 4 | 81 | MBQ6487445.1 valine--tRNA ligase [Candidatus Saccharibacteria bacterium] | diamond | 702 | 146 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota 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);;