contig_metadata
9 rows where bioproject = "PRJNA340009" and tax_phylum = "Candidatus Curtissiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28102492 | 28102492 | PRJNA340009_P_NODE_29605_length_228_cov_3.301676_g29298_i0 | PRJNA340009 | 29605 | 228 | 3.301676 | 7.52782128 | Bacteria | 2 | Bacteria | Bacteria | 124 | 5.5299999999999996e-31 | NR | OGD83965.1 | 1797706 | g29298 | i0 | 82.2 | 5.80263157894737 | 73 | 13 | 96.1 | 0 | 9 | 227 | 391 | 463 | OGD83965.1 MAG: hypothetical protein A2165_03245 [Candidatus Curtissbacteria bacterium RBG_13_40_7] | diamond | 1323 | 125 | 0.992 | Bacteria | Bacteria candidate phyla | Candidatus Curtissiibacteriota | Candidatus Curtissbacteria bacterium RBG_13_40_7 | ||||||
| 28653813 | 28653813 | PRJNA340009_P_NODE_8727_length_382_cov_117.297297_g8420_i0 | PRJNA340009 | 8727 | 382 | 117.297297 | 448.07567454 | Candidatus Curtissbacteria bacterium GW2 | 2750075 | Bacteria | Bacteria | 109 | 3.9799999999999998e-25 | NR | KKR87357.1 | 1618409 | g8420 | i0 | 81.5 | 0.510471204188482 | 65 | 12 | 51 | 0 | 171 | 365 | 1 | 65 | KKR87357.1 MAG: Aspartyl-tRNA synthetase [Candidatus Curtissbacteria bacterium GW2011_GWA1_41_11] | diamond | 195 | 109 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Curtissiibacteriota | Candidatus Curtissbacteria bacterium GW2011_GWA1_41_11 | ||||||
| 28765599 | 28765599 | PRJNA340009_P_NODE_67907_length_164_cov_5.869565_g67600_i0 | PRJNA340009 | 67907 | 164 | 5.869565 | 9.6260866 | Bacteria | 2 | Bacteria | Bacteria | 80.9 | 2.28e-16 | NR | KKR51407.1 | 1618405 | g67600 | i0 | 83 | 3.4390243902439 | 47 | 8 | 86 | 0 | 142 | 2 | 1 | 47 | KKR51407.1 MAG: NAD dependent epimerase/dehydratase family protein [Candidatus Curtissbacteria bacterium GW2011_GWA1_40_16] | diamond | 564 | 80.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Curtissiibacteriota | Candidatus Curtissbacteria bacterium GW2011_GWA1_40_16 | ||||||
| 30580006 | 30580006 | PRJNA340009_P_NODE_64813_length_166_cov_0.871795_g64506_i0 | PRJNA340009 | 64813 | 166 | 0.871795 | 1.4471797 | Candidatus Curtissbacteria bacterium RIFCSPHIGHO2_12_FULL_38_9b | 1797720 | Bacteria | Bacteria | 94.4 | 8.790000000000001e-21 | NR | OGD95085.1 | 1797720 | g64506 | i0 | 82 | 0.903614457831325 | 50 | 9 | 90.4 | 0 | 162 | 13 | 652 | 701 | OGD95085.1 MAG: hypothetical protein A3F02_04145 [Candidatus Curtissbacteria bacterium RIFCSPHIGHO2_12_FULL_38_9b] | diamond | 150 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Curtissiibacteriota | Candidatus Curtissbacteria bacterium RIFCSPHIGHO2_12_FULL_38_9b | ||||||
| 31813147 | 31813147 | PRJNA340009_P_NODE_77537_length_161_cov_0.875000_g77230_i0 | PRJNA340009 | 77537 | 161 | 0.875 | 1.40875 | Candidatus Curtissbacteria bacterium | 2750075 | Bacteria | Bacteria | 80.1 | 7.55e-16 | NR | MDP2632365.1 | 2750075 | g77230 | i0 | 68 | 1.90062111801242 | 50 | 16 | 93.2 | 0 | 161 | 12 | 288 | 337 | MDP2632365.1 UDP-N-acetylmuramoyl-L-alanine--D-glutamate ligase [Candidatus Curtissbacteria bacterium] | diamond | 306 | 80.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Curtissiibacteriota | Candidatus Curtissbacteria bacterium | ||||||
| 31988468 | 31988468 | PRJNA340009_P_NODE_73318_length_162_cov_1.707965_g73011_i0 | PRJNA340009 | 73318 | 162 | 1.707965 | 2.7669033 | Bacteria | 2 | Bacteria | Bacteria | 79.7 | 9.6e-16 | NR | OGD87770.1 | 1797710 | g73011 | i0 | 72 | 2.75925925925926 | 50 | 14 | 92.6 | 0 | 151 | 2 | 162 | 211 | OGD87770.1 MAG: phosphopyruvate hydratase [Candidatus Curtissbacteria bacterium RIFCSPHIGHO2_01_FULL_40_12] | diamond | 447 | 79.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Curtissiibacteriota | Candidatus Curtissbacteria bacterium RIFCSPHIGHO2_01_FULL_40_12 | ||||||
| 32273513 | 32273513 | PRJNA340009_P_NODE_59878_length_169_cov_2.550000_g59571_i0 | PRJNA340009 | 59878 | 169 | 2.55 | 4.3095 | Bacteria | 2 | Bacteria | Bacteria | 72.8 | 1.68e-14 | NR | OGD87639.1 | 1797710 | g59571 | i0 | 65.4 | 3.74556213017751 | 52 | 18 | 92.3 | 0 | 162 | 7 | 86 | 137 | OGD87639.1 MAG: hypothetical protein A2693_01660 [Candidatus Curtissbacteria bacterium RIFCSPHIGHO2_01_FULL_40_12] | diamond | 633 | 72.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Curtissiibacteriota | Candidatus Curtissbacteria bacterium RIFCSPHIGHO2_01_FULL_40_12 | ||||||
| 32414412 | 32414412 | PRJNA340009_P_NODE_63239_length_166_cov_54.188034_g62932_i0 | PRJNA340009 | 63239 | 166 | 54.188034 | 89.95213644 | Candidatus Curtissbacteria bacterium | 2750075 | Bacteria | Bacteria | 97.8 | 5.559999999999999e-23 | NR | MBI2327430.1 | 2750075 | g62932 | i0 | 82 | 4.53614457831325 | 50 | 9 | 90.4 | 0 | 155 | 6 | 215 | 264 | MBI2327430.1 transketolase [Candidatus Curtissbacteria bacterium] | diamond | 753 | 97.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Curtissiibacteriota | Candidatus Curtissbacteria bacterium | ||||||
| 32572704 | 32572704 | PRJNA340009_P_NODE_67419_length_165_cov_0.879310_g67112_i0 | PRJNA340009 | 67419 | 165 | 0.87931 | 1.4508615 | Candidatus Curtissbacteria bacterium | 2750075 | Bacteria | Bacteria | 67 | 3.47e-11 | NR | MBI3342008.1 | 2750075 | g67112 | i0 | 56.6 | 0.963636363636364 | 53 | 23 | 96.4 | 0 | 3 | 161 | 267 | 319 | MBI3342008.1 hypothetical protein [Candidatus Curtissbacteria bacterium] | diamond | 159 | 67 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Curtissiibacteriota | Candidatus Curtissbacteria 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);;