contig_metadata
22 rows where bioproject = "PRJNA683669" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9593609 | 9593609 | PRJNA683669_P_NODE_25988_length_251_cov_0.865169_g25756_i0 | PRJNA683669 | 25988 | 251 | 0.865169 | 2.17157419 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 140 | 5.6499999999999995e-37 | NR | HMJ66402.1 | 2838779 | g25756 | i0 | 78 | 0.9800796812749 | 82 | 18 | 98 | 0 | 249 | 4 | 301 | 382 | HMJ66402.1 gamma-glutamyltransferase [Candidatus Binatia bacterium] | diamond | 246 | 140 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 15967723 | 15967723 | PRJNA683669_P_NODE_28173_length_248_cov_1.760000_g27941_i0 | PRJNA683669 | 28173 | 248 | 1.76 | 4.3648 | Vermiphilus pyriformis | 1763547 | Bacteria | Bacteria | 459 | 1.13e-124 | NTclustered | gi|2207817285|gb|CP074345.1| | 1763547 | g27941 | i0 | 100 | 71.6209677419355 | 248 | 0 | 100 | 0 | 1 | 248 | 974277 | 974030 | MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome | blastn | 17762 | 459 | 1 | Bacteria | Bacteria candidate phyla | Vermiphilus | Vermiphilus pyriformis | ||||||
| 22342251 | 22342251 | PRJNA683669_P_NODE_22658_length_272_cov_1.407035_g22426_i0 | PRJNA683669 | 22658 | 272 | 1.407035 | 3.8271352 | Vermiphilus pyriformis | 1763547 | Bacteria | Bacteria | 497 | 2.67e-136 | NTclustered | gi|2207817285|gb|CP074345.1| | 1763547 | g22426 | i0 | 99.632 | 74.5073529411765 | 272 | 1 | 100 | 0 | 1 | 272 | 974675 | 974404 | MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome | blastn | 20266 | 497 | 1 | Bacteria | Bacteria candidate phyla | Vermiphilus | Vermiphilus pyriformis | ||||||
| 26607156 | 26607156 | PRJNA683669_P_NODE_30241_length_246_cov_0.890173_g30009_i0 | PRJNA683669 | 30241 | 246 | 0.890173 | 2.18982558 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 61.6 | 8.5e-9 | NR | HVU06200.1 | 2053589 | g30009 | i0 | 39.5 | 0.98780487804878 | 81 | 49 | 98.8 | 0 | 246 | 4 | 302 | 382 | HVU06200.1 histidine--tRNA ligase [Candidatus Paceibacterota bacterium] | diamond | 243 | 61.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26618961 | 26618961 | PRJNA683669_P_NODE_8161_length_447_cov_3.296791_g7930_i0 | PRJNA683669 | 8161 | 447 | 3.296791 | 14.73665577 | Bacteria | 2 | Bacteria | Bacteria | 120 | 2.75e-30 | NR | KKQ42611.1 | 1618511 | g7930 | i0 | 48.9 | 10.0939597315436 | 139 | 65 | 89.3 | 3 | 13 | 411 | 1 | 139 | KKQ42611.1 MAG: Chaperone protein DnaJ [Microgenomates group bacterium GW2011_GWC1_37_8] | diamond | 4512 | 120 | 1 | Bacteria | Bacteria candidate phyla | Microgenomates group bacterium GW2011_GWC1_37_8 | |||||||
| 28187337 | 28187337 | PRJNA683669_P_NODE_24226_length_262_cov_1.423280_g23994_i0 | PRJNA683669 | 24226 | 262 | 1.42328 | 3.7289936 | Candidatus Schekmanbacteria bacterium | 2419984 | Bacteria | Bacteria | 62.4 | 5.73e-9 | NR | MBI2566042.1 | 2419984 | g23994 | i0 | 47.3 | 0.847328244274809 | 74 | 37 | 84.7 | 2 | 39 | 260 | 2643 | 2714 | MBI2566042.1 DUF11 domain-containing protein [Candidatus Schekmanbacteria bacterium] | diamond | 222 | 62.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Schekmaniibacteriota | Candidatus Schekmanbacteria bacterium | ||||||
| 28345414 | 28345414 | PRJNA683669_P_NODE_21126_length_282_cov_0.861244_g20894_i0 | PRJNA683669 | 21126 | 282 | 0.861244 | 2.42870808 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 55.8 | 1.31e-6 | NR | MCC6350238.1 | 2212470 | g20894 | i0 | 44.9 | 2.73404255319149 | 78 | 38 | 80.9 | 3 | 231 | 4 | 160 | 234 | MCC6350238.1 alpha/beta hydrolase [Candidatus Eiseniibacteriota bacterium] | diamond | 771 | 55.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 29103371 | 29103371 | PRJNA683669_P_NODE_30748_length_245_cov_0.895349_g30516_i0 | PRJNA683669 | 30748 | 245 | 0.895349 | 2.19360505 | candidate division WOR-3 bacterium | 2052148 | Bacteria | Bacteria | 58.2 | 1.36e-7 | NR | MEA3311896.1 | 2052148 | g30516 | i0 | 47.7 | 2.11836734693878 | 44 | 23 | 53.9 | 0 | 132 | 1 | 194 | 237 | MEA3311896.1 ABC transporter substrate-binding protein [candidate division WOR-3 bacterium] | diamond | 519 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | candidate division WOR-3 | candidate division WOR-3 bacterium | ||||||
| 29450299 | 29450299 | PRJNA683669_P_NODE_31190_length_245_cov_0.895349_g30958_i0 | PRJNA683669 | 31190 | 245 | 0.895349 | 2.19360505 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 65.5 | 3.29e-10 | NR | MDD3662974.1 | 2053589 | g30958 | i0 | 68.2 | 1.07755102040816 | 44 | 14 | 53.9 | 0 | 132 | 1 | 1 | 44 | MDD3662974.1 oxidoreductase [Candidatus Paceibacterota bacterium] | diamond | 264 | 65.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29461835 | 29461835 | PRJNA683669_P_NODE_24830_length_258_cov_1.448649_g24598_i0 | PRJNA683669 | 24830 | 258 | 1.448649 | 3.73751442 | Bacteria | 2 | Bacteria | Bacteria | 62 | 1.25e-9 | NR | MDH4270745.1 | 2052149 | g24598 | i0 | 45.8 | 3.33720930232558 | 72 | 39 | 83.7 | 0 | 218 | 3 | 24 | 95 | MDH4270745.1 ankyrin repeat domain-containing protein [Candidatus Aminicenantes bacterium] | diamond | 861 | 62.4 | 0.993589743589744 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 29904330 | 29904330 | PRJNA683669_P_NODE_18191_length_303_cov_1.621739_g17959_i0 | PRJNA683669 | 18191 | 303 | 1.621739 | 4.91386917 | Bacteria | 2 | Bacteria | Bacteria | 53.1 | 1.73e-5 | NR | KKR74821.1 | 1618730 | g17959 | i0 | 39.1 | 3.44554455445545 | 87 | 42 | 83.2 | 5 | 267 | 16 | 650 | 728 | KKR74821.1 MAG: Cell wall/surface repeat protein [Candidatus Nomurabacteria bacterium GW2011_GWA1_40_8] | diamond | 1044 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium GW2011_GWA1_40_8 | ||||||
| 29924307 | 29924307 | PRJNA683669_P_NODE_23611_length_266_cov_1.580311_g23379_i0 | PRJNA683669 | 23611 | 266 | 1.580311 | 4.20362726 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 107 | 9.07e-25 | NR | HXU87673.1 | 2072417 | g23379 | i0 | 61.1 | 2.03007518796993 | 90 | 32 | 99.2 | 2 | 1 | 264 | 288 | 376 | HXU87673.1 4-coumarate--CoA ligase family protein [Candidatus Methylomirabilota bacterium] | diamond | 540 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30188464 | 30188464 | PRJNA683669_P_NODE_13672_length_350_cov_1.111913_g13441_i0 | PRJNA683669 | 13672 | 350 | 1.111913 | 3.8916955 | Herbaspirillum | 963 | Bacteria | Bacteria | 134 | 5.83e-35 | NR | PID60891.1 | 2044937 | g13441 | i0 | 52.9 | 7.15714285714286 | 104 | 49 | 89.1 | 0 | 34 | 345 | 118 | 221 | PID60891.1 MAG: ABC transporter substrate-binding protein [candidate division KSB3 bacterium] | diamond | 2505 | 134 | 1 | Bacteria | Bacteria candidate phyla | candidate division KSB3 bacterium | |||||||
| 30208256 | 30208256 | PRJNA683669_P_NODE_28352_length_248_cov_0.880000_g28120_i0 | PRJNA683669 | 28352 | 248 | 0.88 | 2.1824 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 94.4 | 2.55e-20 | NR | HEY2386520.1 | 2838779 | g28120 | i0 | 57.5 | 1.95967741935484 | 80 | 34 | 96.8 | 0 | 2 | 241 | 376 | 455 | HEY2386520.1 malonate decarboxylase subunit alpha [Candidatus Binatia bacterium] | diamond | 486 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30777306 | 30777306 | PRJNA683669_P_NODE_11594_length_379_cov_1.006536_g11363_i0 | PRJNA683669 | 11594 | 379 | 1.006536 | 3.81477144 | Candidatus Doudnabacteria bacterium | 2052150 | Bacteria | Bacteria | 51.2 | 4.2e-5 | NR | MFA4880568.1 | 2052150 | g11363 | i0 | 37.5 | 1.40105540897098 | 88 | 46 | 67.3 | 4 | 255 | 1 | 3 | 84 | MFA4880568.1 dUTP diphosphatase [Candidatus Doudnabacteria bacterium] | diamond | 531 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Doudnaibacteriota | Candidatus Doudnabacteria bacterium | ||||||
| 31030275 | 31030275 | PRJNA683669_P_NODE_24295_length_262_cov_1.222222_g24063_i0 | PRJNA683669 | 24295 | 262 | 1.222222 | 3.20222164 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 52.4 | 1.86e-5 | NR | HUU05466.1 | 2052139 | g24063 | i0 | 44.1 | 0.675572519083969 | 59 | 32 | 67.6 | 1 | 226 | 50 | 158 | 215 | HUU05466.1 ankyrin repeat domain-containing protein [Patescibacteria group bacterium] | diamond | 177 | 52.4 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31156065 | 31156065 | PRJNA683669_P_NODE_21075_length_282_cov_1.105263_g20843_i0 | PRJNA683669 | 21075 | 282 | 1.105263 | 3.11684166 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 129 | 3.66e-33 | NR | MCK5592451.1 | 2053589 | g20843 | i0 | 84.7 | 1.5531914893617 | 72 | 11 | 76.6 | 0 | 216 | 1 | 5 | 76 | MCK5592451.1 argininosuccinate synthase [Candidatus Paceibacterota bacterium] | diamond | 438 | 129 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32327206 | 32327206 | PRJNA683669_P_NODE_25959_length_251_cov_1.224719_g25727_i0 | PRJNA683669 | 25959 | 251 | 1.224719 | 3.07404469 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 68.6 | 1.56e-11 | NR | HXJ35497.1 | 2212470 | g25727 | i0 | 53.7 | 0.800796812749004 | 67 | 31 | 80.1 | 0 | 27 | 227 | 191 | 257 | HXJ35497.1 enoyl-CoA hydratase-related protein [Candidatus Eiseniibacteriota bacterium] | diamond | 201 | 68.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 32421747 | 32421747 | PRJNA683669_P_NODE_16359_length_320_cov_1.866397_g16128_i0 | PRJNA683669 | 16359 | 320 | 1.866397 | 5.9724704 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 42.7 | 0.00666 | NR | MCL4419688.1 | 2052139 | g16128 | i0 | 50 | 0.3375 | 36 | 18 | 33.8 | 0 | 137 | 244 | 6 | 41 | MCL4419688.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 108 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32453653 | 32453653 | PRJNA683669_P_NODE_25099_length_256_cov_1.683060_g24867_i0 | PRJNA683669 | 25099 | 256 | 1.68306 | 4.3086336 | Candidatus Babeliales bacterium | 2803731 | Bacteria | Bacteria | 101 | 6.929999999999999e-23 | NR | MFA6526926.1 | 2803731 | g24867 | i0 | 58.3 | 1.921875 | 84 | 35 | 98.4 | 0 | 1 | 252 | 259 | 342 | MFA6526926.1 Npt1/Npt2 family nucleotide transporter [Candidatus Babeliales bacterium] | diamond | 492 | 101 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Babeliales bacterium | |||||
| 32548539 | 32548539 | PRJNA683669_P_NODE_22379_length_274_cov_1.169154_g22147_i0 | PRJNA683669 | 22379 | 274 | 1.169154 | 3.20348196 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 49.3 | 2.74e-4 | NR | MDA3839708.1 | 2052139 | g22147 | i0 | 55.6 | 0.492700729927007 | 45 | 20 | 49.3 | 0 | 7 | 141 | 541 | 585 | MDA3839708.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 135 | 49.3 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32894572 | 32894572 | PRJNA683669_P_NODE_10620_length_395_cov_1.108696_g10389_i0 | PRJNA683669 | 10620 | 395 | 1.108696 | 4.3793492 | Candidatus Desantisiibacteriota bacterium | 2282144 | Bacteria | Bacteria | 70.5 | 4.34e-11 | NR | MFH1098086.1 | 2282144 | g10389 | i0 | 34.1 | 0.956962025316456 | 126 | 81 | 95.7 | 2 | 3 | 380 | 265 | 388 | MFH1098086.1 PEGA domain-containing protein [Candidatus Desantisbacteria bacterium] | diamond | 378 | 70.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Desantisiibacteriota | Candidatus Desantisiibacteriota 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);;