contig_metadata
13 rows where bioproject = "PRJNA1108487" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3571132 | 3571132 | PRJNA1108487_P_NODE_6923_length_274_cov_1.398010_g6857_i0 | PRJNA1108487 | 6923 | 274 | 1.39801 | 3.8305474 | Candidatus Brennerbacteria bacterium | 2750072 | Bacteria | Bacteria | 117 | 2.21e-28 | NR | MBI2591856.1 | 2750072 | g6857 | i0 | 63.3 | 2.93430656934307 | 90 | 30 | 96.4 | 2 | 274 | 11 | 64 | 152 | MBI2591856.1 leucine--tRNA ligase [Candidatus Brennerbacteria bacterium] | diamond | 804 | 117 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Brenneribacteriota | Candidatus Brennerbacteria bacterium | ||||||
| 7398386 | 7398386 | PRJNA1108487_P_NODE_4926_length_317_cov_1.278689_g4860_i0 | PRJNA1108487 | 4926 | 317 | 1.278689 | 4.05344413 | Candidatus Anderseniibacteriota bacterium | 2053502 | Bacteria | Bacteria | 86.7 | 1.62e-18 | NR | MCE9643451.1 | 2053502 | g4860 | i0 | 65.5 | 0.520504731861199 | 55 | 17 | 52.1 | 1 | 316 | 152 | 147 | 199 | MCE9643451.1 superoxide dismutase [Candidatus Andersenbacteria bacterium] | diamond | 165 | 86.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Anderseniibacteriota | Candidatus Anderseniibacteriota bacterium | ||||||
| 27762971 | 27762971 | PRJNA1108487_P_NODE_6744_length_277_cov_1.529412_g6678_i0 | PRJNA1108487 | 6744 | 277 | 1.529412 | 4.23647124 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 58.2 | 1.94e-7 | NR | MFA6407615.1 | 2053589 | g6678 | i0 | 44.1 | 1.91696750902527 | 59 | 33 | 63.9 | 0 | 4 | 180 | 291 | 349 | MFA6407615.1 trypsin-like peptidase domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 531 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27880272 | 27880272 | PRJNA1108487_P_NODE_10725_length_244_cov_0.912281_g10659_i0 | PRJNA1108487 | 10725 | 244 | 0.912281 | 2.22596564 | root | 1 | Root_unresolved | Root_unresolved | 74.3 | 2.84e-13 | NR | OGN00929.1 | 1802665 | g10659 | i0 | 38 | 3.1844262295082 | 92 | 40 | 94.7 | 2 | 4 | 234 | 152 | 241 | OGN00929.1 MAG: hypothetical protein A2742_02690 [Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_01_FULL_43_32] | diamond | 777 | 74.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Yanofskyibacteriota | Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_01_FULL_43_32 | ||||||
| 29120599 | 29120599 | PRJNA1108487_P_NODE_109_length_1566_cov_2.919625_g85_i0 | PRJNA1108487 | 109 | 1566 | 2.919625 | 45.7213275 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 65.5 | 5.16e-7 | NR | MCF7812026.1 | 2044595 | g85 | i0 | 42.9 | 0.524904214559387 | 70 | 38 | 13.4 | 2 | 426 | 635 | 450 | 517 | MCF7812026.1 DUF4215 domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 822 | 65.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29742918 | 29742918 | PRJNA1108487_P_NODE_9910_length_247_cov_0.896552_g9844_i0 | PRJNA1108487 | 9910 | 247 | 0.896552 | 2.21448344 | Bacteria | 2 | Bacteria | Bacteria | 54.3 | 3.12e-6 | NR | OGL44026.1 | 1817879 | g9844 | i0 | 48.5 | 1.77327935222672 | 66 | 32 | 80.2 | 2 | 50 | 247 | 77 | 140 | OGL44026.1 MAG: hypothetical protein A2W05_06085 [Candidatus Schekmanbacteria bacterium RBG_16_38_10] | diamond | 438 | 54.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Schekmaniibacteriota | Candidatus Schekmanbacteria bacterium RBG_16_38_10 | ||||||
| 30004640 | 30004640 | PRJNA1108487_P_NODE_8211_length_254_cov_1.292818_g8145_i0 | PRJNA1108487 | 8211 | 254 | 1.292818 | 3.28375772 | Candidatus Hydrothermia bacterium | 3014280 | Bacteria | Bacteria | 113 | 1.0400000000000002e-27 | NR | MDT7879665.1 | 3014280 | g8145 | i0 | 59.5 | 0.992125984251969 | 84 | 32 | 99.2 | 1 | 2 | 253 | 258 | 339 | MDT7879665.1 ornithine--oxo-acid transaminase [Candidatus Hydrothermia bacterium] | diamond | 252 | 113 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Hydrothermota | Candidatus Hydrothermia | Candidatus Hydrothermia bacterium | |||||
| 30384091 | 30384091 | PRJNA1108487_P_NODE_4033_length_345_cov_1.397059_g3967_i0 | PRJNA1108487 | 4033 | 345 | 1.397059 | 4.81985355 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 49.3 | 5.34e-4 | NR | MEO2002766.1 | 2026781 | g3967 | i0 | 55.3 | 1.8 | 38 | 17 | 33 | 0 | 2 | 115 | 91 | 128 | MEO2002766.1 WD40 repeat domain-containing protein [Candidatus Poribacteria bacterium] | diamond | 621 | 49.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 31204720 | 31204720 | PRJNA1108487_P_NODE_7895_length_259_cov_1.516129_g7829_i0 | PRJNA1108487 | 7895 | 259 | 1.516129 | 3.92677411 | Candidatus Berkelbacteria bacterium | 2053521 | Bacteria | Bacteria | 48.1 | 5.59e-4 | NR | MBI4948062.1 | 2053521 | g7829 | i0 | 35.9 | 0.741312741312741 | 64 | 39 | 71.8 | 1 | 192 | 7 | 72 | 135 | MBI4948062.1 HD domain-containing protein [Candidatus Berkelbacteria bacterium] | diamond | 192 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Berkelbacteria | Candidatus Berkelbacteria bacterium | ||||||
| 31300033 | 31300033 | PRJNA1108487_P_NODE_6015_length_291_cov_2.128440_g5949_i0 | PRJNA1108487 | 6015 | 291 | 2.12844 | 6.1937604 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 127 | 9.72e-32 | NR | MCL4419431.1 | 2052139 | g5949 | i0 | 92.5 | 0.690721649484536 | 67 | 5 | 69.1 | 0 | 289 | 89 | 521 | 587 | MCL4419431.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 201 | 127 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31553346 | 31553346 | PRJNA1108487_P_NODE_9036_length_250_cov_1.559322_g8970_i0 | PRJNA1108487 | 9036 | 250 | 1.559322 | 3.898305 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 42.7 | 0.0351 | NR | HDP95785.1 | 2052149 | g8970 | i0 | 41 | 0.732 | 61 | 34 | 73.2 | 1 | 20 | 202 | 48 | 106 | HDP95785.1 bifunctional histidinol-phosphatase/imidazoleglycerol-phosphate dehydratase [Candidatus Aminicenantes bacterium] | diamond | 183 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 31584893 | 31584893 | PRJNA1108487_P_NODE_9796_length_247_cov_1.666667_g9730_i0 | PRJNA1108487 | 9796 | 247 | 1.666667 | 4.11666749 | Candidatus Babeliales bacterium | 2803731 | Bacteria | Bacteria | 42.7 | 0.0378 | NR | MDR3549977.1 | 2803731 | g9730 | i0 | 50 | 0.534412955465587 | 44 | 21 | 52.2 | 1 | 117 | 245 | 278 | 321 | MDR3549977.1 ankyrin repeat domain-containing protein [Candidatus Babeliales bacterium] | diamond | 132 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Babeliales bacterium | |||||
| 31901017 | 31901017 | PRJNA1108487_P_NODE_10937_length_243_cov_0.917647_g10871_i0 | PRJNA1108487 | 10937 | 243 | 0.917647 | 2.22988221 | Candidatus Aerophobota bacterium | 2030807 | Bacteria | Bacteria | 79 | 4.88e-17 | NR | MCD6082691.1 | 2030807 | g10871 | i0 | 53.7 | 10.4567901234568 | 67 | 31 | 82.7 | 0 | 215 | 15 | 25 | 91 | MCD6082691.1 30S ribosomal protein S19 [Candidatus Aerophobetes bacterium] | diamond | 2541 | 79 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobota 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);;