contig_metadata
19 rows where bioproject = "PRJNA874604", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9780403 | 9780403 | PRJNA874604_P_NODE_75788_length_249_cov_0.875000_g75436_i0 | PRJNA874604 | 75788 | 249 | 0.875 | 2.17875 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 366 | 7.09e-97 | NTclustered | gi|1950821269|gb|CP066696.1| | 2026720 | g75436 | i0 | 93.173 | 59.1004016064257 | 249 | 17 | 100 | 0 | 1 | 249 | 799854 | 799606 | Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome | blastn | 14716 | 366 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27055337 | 27055337 | PRJNA874604_P_NODE_65602_length_256_cov_1.393443_g65250_i0 | PRJNA874604 | 65602 | 256 | 1.393443 | 3.56721408 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 84.7 | 6.76e-17 | NR | HEY4160733.1 | 2973664 | g65250 | i0 | 60.3 | 3.76171875 | 63 | 25 | 73.8 | 0 | 57 | 245 | 5 | 67 | HEY4160733.1 bifunctional sulfate adenylyltransferase/adenylylsulfate kinase [Candidatus Saccharimonadales bacterium] | diamond | 963 | 84.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 27181481 | 27181481 | PRJNA874604_P_NODE_79262_length_248_cov_0.880000_g78910_i0 | PRJNA874604 | 79262 | 248 | 0.88 | 2.1824 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 95.9 | 7.88e-21 | NR | HOW43725.1 | 2052149 | g78910 | i0 | 64 | 0.907258064516129 | 75 | 27 | 90.7 | 0 | 244 | 20 | 214 | 288 | HOW43725.1 fused MFS/spermidine synthase [Candidatus Aminicenantes bacterium] | diamond | 225 | 95.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 27371580 | 27371580 | PRJNA874604_P_NODE_100923_length_239_cov_2.638554_g100571_i0 | PRJNA874604 | 100923 | 239 | 2.638554 | 6.30614406 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 77.4 | 2e-16 | NR | MBW4061930.1 | 2026720 | g100571 | i0 | 65.4 | 1.26778242677824 | 52 | 18 | 65.3 | 0 | 2 | 157 | 44 | 95 | MBW4061930.1 type II toxin-antitoxin system RelE/ParE family toxin [Candidatus Saccharibacteria bacterium] | diamond | 303 | 77.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27719056 | 27719056 | PRJNA874604_P_NODE_50284_length_283_cov_2.657143_g49932_i0 | PRJNA874604 | 50284 | 283 | 2.657143 | 7.51971469 | Candidatus Magasanikbacteria bacterium CG11_big_fil_rev_8_21_14_ | 2026717 | Bacteria | Bacteria | 45.1 | 0.00879 | NR | PIR03241.1 | 1974654 | g49932 | i0 | 39.2 | 0.784452296819788 | 74 | 39 | 75.3 | 3 | 255 | 43 | 104 | 174 | PIR03241.1 MAG: rod shape-determining protein RodA [Candidatus Magasanikbacteria bacterium CG11_big_fil_rev_8_21_14_0_20_43_7] | diamond | 222 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium CG11_big_fil_rev_8_21_14_0_20_43_7 | ||||||
| 28476405 | 28476405 | PRJNA874604_P_NODE_39726_length_310_cov_1.299578_g39374_i0 | PRJNA874604 | 39726 | 310 | 1.299578 | 4.0286918 | Candidatus Fervidibacterota bacterium | 2080304 | Bacteria | Bacteria | 86.7 | 1.41e-18 | NR | MER3500395.1 | 2080304 | g39374 | i0 | 60.9 | 1.28709677419355 | 69 | 27 | 66.8 | 0 | 210 | 4 | 8 | 76 | MER3500395.1 macrodomain protein [Candidatus Fervidibacterota bacterium] | diamond | 399 | 86.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Fervidibacterota | Candidatus Fervidibacterota bacterium | ||||||
| 28476415 | 28476415 | PRJNA874604_P_NODE_6106_length_663_cov_1.583051_g5777_i0 | PRJNA874604 | 6106 | 663 | 1.583051 | 10.49562813 | candidate division FCPU426 bacterium | 2052330 | Bacteria | Bacteria | 85.1 | 1.33e-17 | NR | MBN1594640.1 | 2052330 | g5777 | i0 | 45.5 | 2.96380090497738 | 88 | 45 | 39.8 | 1 | 476 | 213 | 4 | 88 | MBN1594640.1 stage V sporulation protein S [candidate division FCPU426 bacterium] | diamond | 1965 | 85.1 | 1 | Bacteria | Bacteria candidate phyla | candidate division FCPU426 | candidate division FCPU426 bacterium | ||||||
| 29107975 | 29107975 | PRJNA874604_P_NODE_89068_length_244_cov_1.789474_g88716_i0 | PRJNA874604 | 89068 | 244 | 1.789474 | 4.36631656 | Candidatus Nealsonbacteria bacterium | 2093793 | Bacteria | Bacteria | 45.1 | 0.00286 | NR | XOB42299.1 | 2093793 | g88716 | i0 | 32.9 | 1.6844262295082 | 73 | 48 | 88.5 | 1 | 242 | 27 | 7 | 79 | XOB42299.1 MAG: non-canonical purine NTP pyrophosphatase [Candidatus Nealsonbacteria bacterium] | diamond | 411 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nealsoniibacteriota | Candidatus Nealsonbacteria bacterium | ||||||
| 29328843 | 29328843 | PRJNA874604_P_NODE_55089_length_275_cov_1.183168_g54737_i0 | PRJNA874604 | 55089 | 275 | 1.183168 | 3.253712 | Candidatus Saccharimonadia bacterium | 2890869 | Bacteria | Bacteria | 119 | 2.29e-30 | NR | HEY2004086.1 | 2890869 | g54737 | i0 | 67.4 | 0.970909090909091 | 89 | 29 | 97.1 | 0 | 269 | 3 | 174 | 262 | HEY2004086.1 VWA domain-containing protein [Candidatus Saccharimonadia bacterium] | diamond | 267 | 119 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadia bacterium | |||||
| 29360534 | 29360534 | PRJNA874604_P_NODE_97389_length_242_cov_0.911243_g97037_i0 | PRJNA874604 | 97389 | 242 | 0.911243 | 2.20520806 | Candidatus Saccharibacteria bacterium 49-2 | 1895829 | Bacteria | Bacteria | 107 | 6.0099999999999995e-25 | NR | OJU87796.1 | 1895829 | g97037 | i0 | 64.6 | 1.01652892561983 | 82 | 27 | 99.2 | 1 | 241 | 2 | 82 | 163 | OJU87796.1 MAG: hypothetical protein BGO17_02320 [Candidatus Saccharibacteria bacterium 49-20] | diamond | 246 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 | ||||||
| 29423396 | 29423396 | PRJNA874604_P_NODE_65549_length_256_cov_1.502732_g65197_i0 | PRJNA874604 | 65549 | 256 | 1.502732 | 3.84699392 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 57 | 3.1e-7 | NR | MCK6555379.1 | 2838779 | g65197 | i0 | 47.3 | 0.8671875 | 74 | 32 | 86.7 | 2 | 256 | 35 | 56 | 122 | MCK6555379.1 alpha/beta hydrolase [Candidatus Binatia bacterium] | diamond | 222 | 57 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30118283 | 30118283 | PRJNA874604_P_NODE_93472_length_243_cov_0.905882_g93120_i0 | PRJNA874604 | 93472 | 243 | 0.905882 | 2.20129326 | Candidatus Babelota bacterium | 2030827 | Bacteria | Bacteria | 150 | 6.16e-44 | NR | MBS1987771.1 | 2030827 | g93120 | i0 | 95 | 0.987654320987654 | 80 | 4 | 98.8 | 0 | 2 | 241 | 123 | 202 | MBS1987771.1 hypothetical protein [Candidatus Dependentiae bacterium] | diamond | 240 | 150 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 30466288 | 30466288 | PRJNA874604_P_NODE_85133_length_246_cov_0.890173_g84781_i0 | PRJNA874604 | 85133 | 246 | 0.890173 | 2.18982558 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 125 | 4.32e-33 | NR | HXW82787.1 | 2785449 | g84781 | i0 | 62 | 3.8780487804878 | 79 | 30 | 96.3 | 0 | 1 | 237 | 32 | 110 | HXW82787.1 alpha/beta hydrolase [Candidatus Binataceae bacterium] | diamond | 954 | 125 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 30750391 | 30750391 | PRJNA874604_P_NODE_23474_length_379_cov_1.006536_g23122_i0 | PRJNA874604 | 23474 | 379 | 1.006536 | 3.81477144 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 78.2 | 5.76e-14 | NR | MBK7369343.1 | 2212470 | g23122 | i0 | 46.2 | 3.41952506596306 | 78 | 42 | 61.7 | 0 | 141 | 374 | 38 | 115 | MBK7369343.1 glutamine synthetase III [Candidatus Eiseniibacteriota bacterium] | diamond | 1296 | 78.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 31066535 | 31066535 | PRJNA874604_P_NODE_71395_length_250_cov_1.350282_g71043_i0 | PRJNA874604 | 71395 | 250 | 1.350282 | 3.375705 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 48.5 | 3.72e-4 | NR | MCD6508158.1 | 2026781 | g71043 | i0 | 37.5 | 0.96 | 80 | 46 | 96 | 2 | 241 | 2 | 327 | 402 | MCD6508158.1 right-handed parallel beta-helix repeat-containing protein [Candidatus Poribacteria bacterium] | diamond | 240 | 48.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 31350880 | 31350880 | PRJNA874604_P_NODE_22636_length_384_cov_1.385852_g22284_i0 | PRJNA874604 | 22636 | 384 | 1.385852 | 5.32167168 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 62 | 2.53e-8 | NR | MBN1827380.1 | 2212470 | g22284 | i0 | 42.7 | 2.046875 | 75 | 42 | 58.6 | 1 | 9 | 233 | 32 | 105 | MBN1827380.1 choice-of-anchor A family protein [Candidatus Eiseniibacteriota bacterium] | diamond | 786 | 62 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 31793366 | 31793366 | PRJNA874604_P_NODE_41577_length_305_cov_0.987069_g41225_i0 | PRJNA874604 | 41577 | 305 | 0.987069 | 3.01056045 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 44.7 | 0.0148 | NR | MYB94984.1 | 2026781 | g41225 | i0 | 42.6 | 0.924590163934426 | 47 | 27 | 46.2 | 0 | 69 | 209 | 7 | 53 | MYB94984.1 homoserine kinase [Candidatus Poribacteria bacterium] | diamond | 282 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 32561293 | 32561293 | PRJNA874604_P_NODE_96099_length_242_cov_0.911243_g95747_i0 | PRJNA874604 | 96099 | 242 | 0.911243 | 2.20520806 | Bacteria | 2 | Bacteria | Bacteria | 123 | 1.01e-31 | NR | MDB5181157.1 | 2026720 | g95747 | i0 | 91.3 | 3.42148760330579 | 69 | 6 | 85.5 | 0 | 208 | 2 | 1 | 69 | MDB5181157.1 nusA [Candidatus Saccharibacteria bacterium] | diamond | 828 | 124 | 0.991935483870968 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32616034 | 32616034 | PRJNA874604_P_NODE_96580_length_242_cov_0.911243_g96228_i0 | PRJNA874604 | 96580 | 242 | 0.911243 | 2.20520806 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 94.4 | 2.64e-21 | NR | MAU33634.1 | 2026720 | g96228 | i0 | 55.1 | 1.92148760330579 | 78 | 35 | 96.7 | 0 | 242 | 9 | 194 | 271 | MAU33634.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 465 | 94.4 | 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);;