contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA807347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14834558 | 14834558 | PRJNA807347_P_NODE_6712_length_316_cov_1.547325_g6609_i0 | PRJNA807347 | 6712 | 316 | 1.547325 | 4.889547 | Bacteria | 2 | Bacteria | Bacteria | 149 | 2.62e-39 | NR | OGG51549.1 | 1798483 | g6609 | i0 | 70.5 | 8.97151898734177 | 105 | 31 | 99.7 | 0 | 2 | 316 | 474 | 578 | OGG51549.1 MAG: hypothetical protein A2704_04715 [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_54_36b] | diamond | 2835 | 149 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_54_36b | ||||||
| 27465136 | 27465136 | PRJNA807347_P_NODE_7983_length_290_cov_1.875576_g7880_i0 | PRJNA807347 | 7983 | 290 | 1.875576 | 5.4391704 | Candidatus Acetothermia bacterium | 2053493 | Bacteria | Bacteria | 52.8 | 3.99e-6 | NR | MFP4647282.1 | 2053493 | g7880 | i0 | 47.1 | 0.962068965517241 | 51 | 27 | 52.8 | 0 | 6 | 158 | 73 | 123 | MFP4647282.1 hypothetical protein [Candidatus Acetothermia bacterium] | diamond | 279 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Bipolaricaulota | Candidatus Acetothermia bacterium | ||||||
| 27654599 | 27654599 | PRJNA807347_P_NODE_5164_length_362_cov_1.608997_g5061_i0 | PRJNA807347 | 5164 | 362 | 1.608997 | 5.82456914 | Candidatus Roizmanbacteria bacterium GW2 | 2282149 | Bacteria | Bacteria | 72.8 | 4.5e-12 | NR | KKQ23516.1 | 1618483 | g5061 | i0 | 40.2 | 0.845303867403315 | 102 | 55 | 82 | 3 | 297 | 1 | 491 | 589 | KKQ23516.1 MAG: hypothetical protein US38_C0014G0003 [Candidatus Roizmanbacteria bacterium GW2011_GWC1_37_12] | diamond | 306 | 72.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium GW2011_GWC1_37_12 | ||||||
| 27663442 | 27663442 | PRJNA807347_P_NODE_1344_length_710_cov_2.155416_g1249_i0 | PRJNA807347 | 1344 | 710 | 2.155416 | 15.3034536 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 357 | 2.29e-121 | NR | PIT91713.1 | 1974593 | g1249 | i0 | 79.6 | 19.4957746478873 | 211 | 43 | 89.2 | 0 | 78 | 710 | 40 | 250 | PIT91713.1 MAG: site-specific DNA-methyltransferase [Candidatus Jorgensenbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_54_38] | diamond | 13842 | 359 | 0.994428969359331 | Bacteria | Bacteria candidate phyla | Candidatus Joergenseniibacteriota | Candidatus Jorgensenbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_54_38 | ||||||
| 28443942 | 28443942 | PRJNA807347_P_NODE_9946_length_268_cov_2.051282_g9843_i0 | PRJNA807347 | 9946 | 268 | 2.051282 | 5.49743576 | Candidatus Glassbacteria bacterium | 2602803 | Bacteria | Bacteria | 88.6 | 1.56e-19 | NR | MBW7998567.1 | 2602803 | g9843 | i0 | 50.6 | 0.951492537313433 | 85 | 42 | 95.1 | 0 | 6 | 260 | 8 | 92 | MBW7998567.1 hypothetical protein [Candidatus Glassbacteria bacterium] | diamond | 255 | 88.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Glassiibacteriota | Candidatus Glassbacteria bacterium | ||||||
| 28831429 | 28831429 | PRJNA807347_P_NODE_2988_length_485_cov_1.123786_g2885_i0 | PRJNA807347 | 2988 | 485 | 1.123786 | 5.4503621 | Bacteria | 2 | Bacteria | Bacteria | 116 | 1.19e-26 | NR | MBM3255883.1 | 2045217 | g2885 | i0 | 38.5 | 2.9319587628866 | 156 | 87 | 95.3 | 2 | 17 | 478 | 752 | 900 | MBM3255883.1 hypothetical protein [Candidatus Moraniibacteriota bacterium] | diamond | 1422 | 117 | 0.991452991452991 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 29233262 | 29233262 | PRJNA807347_P_NODE_13109_length_250_cov_0.870056_g13006_i0 | PRJNA807347 | 13109 | 250 | 0.870056 | 2.17514 | Candidatus Glassbacteria bacterium | 2602803 | Bacteria | Bacteria | 62 | 1.39e-10 | NR | HUU89521.1 | 2602803 | g13006 | i0 | 54.4 | 0.684 | 57 | 26 | 68.4 | 0 | 1 | 171 | 5 | 61 | HUU89521.1 hypothetical protein [Candidatus Glassbacteria bacterium] | diamond | 171 | 62 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Glassiibacteriota | Candidatus Glassbacteria bacterium | ||||||
| 29391114 | 29391114 | PRJNA807347_P_NODE_11869_length_252_cov_1.631285_g11766_i0 | PRJNA807347 | 11869 | 252 | 1.631285 | 4.1108382 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 156 | 5.3499999999999997e-42 | NR | HEX6437915.1 | 2838779 | g11766 | i0 | 91.5 | 0.976190476190476 | 82 | 7 | 97.6 | 0 | 6 | 251 | 749 | 830 | HEX6437915.1 GAF domain-containing protein [Candidatus Binatia bacterium] | diamond | 246 | 156 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29643252 | 29643252 | PRJNA807347_P_NODE_15190_length_245_cov_1.500000_g15087_i0 | PRJNA807347 | 15190 | 245 | 1.5 | 3.675 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 70.5 | 6.36e-12 | NR | MEK7133684.1 | 2052139 | g15087 | i0 | 53.8 | 0.979591836734694 | 80 | 36 | 96.7 | 1 | 4 | 240 | 142 | 221 | MEK7133684.1 efflux RND transporter periplasmic adaptor subunit [Patescibacteria group bacterium] | diamond | 240 | 70.5 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 30180453 | 30180453 | PRJNA807347_P_NODE_6932_length_311_cov_1.613445_g6829_i0 | PRJNA807347 | 6932 | 311 | 1.613445 | 5.01781395 | Candidatus Rifleibacteriota bacterium | 2053586 | Bacteria | Bacteria | 43.9 | 0.0312 | NR | MBF0545875.1 | 2053586 | g6829 | i0 | 44.3 | 0.588424437299035 | 61 | 31 | 55.9 | 2 | 194 | 21 | 121 | 181 | MBF0545875.1 signal recognition particle-docking protein FtsY [Candidatus Rifleibacteriota bacterium] | diamond | 183 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rifleibacteriota | Candidatus Rifleibacteriota bacterium | ||||||
| 30211970 | 30211970 | PRJNA807347_P_NODE_1812_length_619_cov_2.362637_g1711_i0 | PRJNA807347 | 1812 | 619 | 2.362637 | 14.62472303 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 54.3 | 7.07e-5 | NR | MFV0485547.1 | 2973664 | g1711 | i0 | 71.9 | 0.310177705977383 | 32 | 9 | 15.5 | 0 | 98 | 3 | 205 | 236 | MFV0485547.1 DNA adenine methylase [Candidatus Saccharimonadales bacterium] | diamond | 192 | 54.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30559470 | 30559470 | PRJNA807347_P_NODE_16733_length_242_cov_1.887574_g16630_i0 | PRJNA807347 | 16733 | 242 | 1.887574 | 4.56792908 | Candidatus Dojkabacteria bacterium | 2099670 | Bacteria | Bacteria | 58.5 | 2.8e-8 | NR | TXG75823.1 | 2099670 | g16630 | i0 | 45.2 | 0.90495867768595 | 73 | 36 | 85.5 | 2 | 232 | 26 | 67 | 139 | TXG75823.1 MAG: GNAT family N-acetyltransferase [Candidatus Dojkabacteria bacterium] | diamond | 219 | 58.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Dojkabacteria bacterium | |||||||
| 32181247 | 32181247 | PRJNA807347_P_NODE_2998_length_484_cov_2.240876_g2895_i0 | PRJNA807347 | 2998 | 484 | 2.240876 | 10.84583984 | Bacteria | 2 | Bacteria | Bacteria | 259 | 8.22e-86 | NR | MBU2540066.1 | 2052139 | g2895 | i0 | 79.2 | 6.68181818181818 | 154 | 32 | 95.5 | 0 | 483 | 22 | 41 | 194 | MBU2540066.1 HNH endonuclease [Patescibacteria group bacterium] | diamond | 3234 | 260 | 0.996153846153846 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32583641 | 32583641 | PRJNA807347_P_NODE_11319_length_255_cov_2.714286_g11216_i0 | PRJNA807347 | 11319 | 255 | 2.714286 | 6.9214293 | Candidatus Muiribacterium halophilum | 2053465 | Bacteria | Bacteria | 75.9 | 2.02e-15 | NR | MCK9476971.1 | 2053465 | g11216 | i0 | 70.5 | 0.517647058823529 | 44 | 13 | 51.8 | 0 | 133 | 2 | 2 | 45 | MCK9476971.1 hypothetical protein [Candidatus Muiribacterium halophilum] | diamond | 132 | 75.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Muiribacteriota | Candidatus Muiribacteriia | Candidatus Muiribacteriaceae | Candidatus Muiribacterium | Candidatus Muiribacterium halophilum | |||
| 32835281 | 32835281 | PRJNA807347_P_NODE_8700_length_282_cov_0.966507_g8597_i0 | PRJNA807347 | 8700 | 282 | 0.966507 | 2.72554974 | Candidatus Muiribacterium halophilum | 2053465 | Bacteria | Bacteria | 120 | 1.35e-29 | NR | MCK9476338.1 | 2053465 | g8597 | i0 | 65.1 | 1.75531914893617 | 83 | 29 | 88.3 | 0 | 281 | 33 | 248 | 330 | MCK9476338.1 hypothetical protein [Candidatus Muiribacterium halophilum] | diamond | 495 | 120 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Muiribacteriota | Candidatus Muiribacteriia | Candidatus Muiribacteriaceae | Candidatus Muiribacterium | Candidatus Muiribacterium halophilum | |||
| 32835282 | 32835282 | PRJNA807347_P_NODE_9040_length_278_cov_1.141463_g8937_i0 | PRJNA807347 | 9040 | 278 | 1.141463 | 3.17326714 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 45.1 | 0.00881 | NR | MFC1653590.1 | 2052139 | g8937 | i0 | 80.8 | 0.280575539568345 | 26 | 5 | 28.1 | 0 | 166 | 243 | 754 | 779 | MFC1653590.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 78 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group 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);;