contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA283169" and tax_phylum = "Candidatus Tayloriibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14400822 | 14400822 | PRJNA283169_S_NODE_3012_length_168_cov_0.134454_g2998_i0 | PRJNA283169 | 3012 | 168 | 0.134454 | 0.22588272 | Bacteria | 2 | Bacteria | Bacteria | 109 | 4.9e-26 | NR | OHA31366.1 | 1802316 | g2998 | i0 | 94.6 | 56 | 56 | 3 | 100 | 0 | 1 | 168 | 555 | 610 | OHA31366.1 MAG: ATP-dependent chaperone ClpB [Candidatus Taylorbacteria bacterium RIFCSPLOWO2_01_FULL_43_44] | diamond | 9408 | 110 | 0.990909090909091 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Taylorbacteria bacterium RIFCSPLOWO2_01_FULL_43_44 | ||||||
| 26680146 | 26680146 | PRJNA283169_P_NODE_6641_length_168_cov_0.865546_g6578_i0 | PRJNA283169 | 6641 | 168 | 0.865546 | 1.45411728 | Bacteria | 2 | Bacteria | Bacteria | 117 | 4.98e-30 | NR | MEI7463047.1 | 2052153 | g6578 | i0 | 98.2 | 11 | 56 | 1 | 100 | 0 | 168 | 1 | 3 | 58 | MEI7463047.1 conjugal transfer protein TraC [Candidatus Taylorbacteria bacterium] | diamond | 1848 | 117 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota bacterium | ||||||
| 27358762 | 27358762 | PRJNA283169_P_NODE_6483_length_169_cov_0.866667_g6420_i0 | PRJNA283169 | 6483 | 169 | 0.866667 | 1.46466723 | Candidatus Taylorbacteria bacterium CG1 | 1975024 | Bacteria | Bacteria | 43.1 | 0.00274 | NR | PJE74196.1 | 1975024 | g6420 | i0 | 43.9 | 1.01183431952663 | 57 | 25 | 90.5 | 2 | 9 | 161 | 31 | 86 | PJE74196.1 MAG: hypothetical protein COV01_01725 [Candidatus Taylorbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_41_48] | diamond | 171 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Taylorbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_41_48 | ||||||
| 27390356 | 27390356 | PRJNA283169_P_NODE_2763_length_249_cov_1.465000_g2700_i0 | PRJNA283169 | 2763 | 249 | 1.465 | 3.64785 | Candidatus Tayloriibacteriota bacterium | 2052153 | Bacteria | Bacteria | 66.2 | 1.06e-10 | NR | MEI8249044.1 | 2052153 | g2700 | i0 | 75.7 | 1.78313253012048 | 37 | 9 | 44.6 | 0 | 3 | 113 | 202 | 238 | MEI8249044.1 PD-(D/E)XK nuclease family protein [Candidatus Taylorbacteria bacterium] | diamond | 444 | 66.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota bacterium | ||||||
| 27976117 | 27976117 | PRJNA283169_P_NODE_3665_length_217_cov_1.154762_g3602_i0 | PRJNA283169 | 3665 | 217 | 1.154762 | 2.50583354 | Bacteria | 2 | Bacteria | Bacteria | 142 | 4.12e-41 | NR | OHA25084.1 | 1802310 | g3602 | i0 | 98.6 | 2.94470046082949 | 71 | 1 | 98.2 | 0 | 213 | 1 | 30 | 100 | OHA25084.1 MAG: hypothetical protein A3C79_01325 [Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_02_FULL_45_28] | diamond | 639 | 142 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_02_FULL_45_28 | ||||||
| 31085199 | 31085199 | PRJNA283169_P_NODE_7615_length_164_cov_0.886957_g7552_i0 | PRJNA283169 | 7615 | 164 | 0.886957 | 1.45460948 | Candidatus Tayloriibacteriota bacterium | 2052153 | Bacteria | Bacteria | 71.6 | 2.99e-13 | NR | MDB5204080.1 | 2052153 | g7552 | i0 | 69.8 | 2.92682926829268 | 53 | 16 | 97 | 0 | 160 | 2 | 171 | 223 | MDB5204080.1 Undecaprenyl-diphosphatase [Candidatus Taylorbacteria bacterium] | diamond | 480 | 71.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota bacterium | ||||||
| 32051665 | 32051665 | PRJNA283169_P_NODE_4158_length_206_cov_1.121019_g4095_i0 | PRJNA283169 | 4158 | 206 | 1.121019 | 2.30929914 | Bacteria | 2 | Bacteria | Bacteria | 109 | 7.66e-26 | NR | MDO8430473.1 | 2052153 | g4095 | i0 | 80.9 | 2.97087378640777 | 68 | 13 | 99 | 0 | 3 | 206 | 482 | 549 | MDO8430473.1 tetratricopeptide repeat protein [Candidatus Taylorbacteria bacterium] | diamond | 612 | 110 | 0.990909090909091 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota bacterium | ||||||
| 32603380 | 32603380 | PRJNA283169_S_NODE_540_length_342_cov_0.215017_g526_i0 | PRJNA283169 | 540 | 342 | 0.215017 | 0.73535814 | Candidatus Tayloriibacteriota bacterium | 2052153 | Bacteria | Bacteria | 127 | 3.09e-35 | NR | MDO8430518.1 | 2052153 | g526 | i0 | 64.6 | 0.842105263157895 | 96 | 34 | 84.2 | 0 | 323 | 36 | 31 | 126 | MDO8430518.1 hypothetical protein [Candidatus Taylorbacteria bacterium] | diamond | 288 | 127 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota 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);;