contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1174234" and tax_phylum = "Chloroflexota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27293412 | 27293412 | PRJNA1174234_P_NODE_28663_length_253_cov_1.283333_g28467_i0 | PRJNA1174234 | 28663 | 253 | 1.283333 | 3.24683249 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 45.8 | 0.00325 | NR | MYB77647.1 | 2026724 | g28467 | i0 | 42.9 | 1.6600790513834 | 70 | 37 | 79.4 | 2 | 37 | 237 | 70 | 139 | MYB77647.1 delta(24(24(1)))-sterol reductase [Chloroflexota bacterium] | diamond | 420 | 45.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27861737 | 27861737 | PRJNA1174234_P_NODE_35205_length_242_cov_0.911243_g35009_i0 | PRJNA1174234 | 35205 | 242 | 0.911243 | 2.20520806 | Chloroflexi bacterium RBG_13_66_1 | 1797637 | Bacteria | Bacteria | 42.4 | 0.0486 | NR | OGO08765.1 | 1797637 | g35009 | i0 | 28 | 0.929752066115702 | 75 | 37 | 79.3 | 2 | 226 | 35 | 83 | 151 | OGO08765.1 MAG: hypothetical protein A2Z66_07905 [Chloroflexi bacterium RBG_13_66_10] | diamond | 225 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium RBG_13_66_10 | ||||||
| 29503539 | 29503539 | PRJNA1174234_P_NODE_12210_length_394_cov_1.411215_g12014_i0 | PRJNA1174234 | 12210 | 394 | 1.411215 | 5.5601871 | Caldilineales bacterium | 2306055 | Bacteria | Bacteria | 46.6 | 0.00218 | NR | MEZ4768260.1 | 2306055 | g12014 | i0 | 28.3 | 1.99492385786802 | 127 | 76 | 89.1 | 4 | 27 | 377 | 5 | 126 | MEZ4768260.1 META domain-containing protein [Caldilineales bacterium] | diamond | 786 | 46.6 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineales bacterium | ||||
| 30470662 | 30470662 | PRJNA1174234_P_NODE_5933_length_558_cov_1.550515_g5737_i0 | PRJNA1174234 | 5933 | 558 | 1.550515 | 8.6518737 | Bacteria | 2 | Bacteria | Bacteria | 166 | 3.62e-47 | NR | MBI5962342.1 | 2026724 | g5737 | i0 | 48.9 | 14.8655913978495 | 184 | 91 | 98.9 | 1 | 6 | 557 | 102 | 282 | MBI5962342.1 DUF1295 domain-containing protein [Chloroflexota bacterium] | diamond | 8295 | 167 | 0.994011976047904 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31367975 | 31367975 | PRJNA1174234_P_NODE_33156_length_245_cov_0.895349_g32960_i0 | PRJNA1174234 | 33156 | 245 | 0.895349 | 2.19360505 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 54.7 | 2.26e-6 | NR | MBN1810906.1 | 2052143 | g32960 | i0 | 39 | 5.3265306122449 | 77 | 41 | 89.4 | 2 | 25 | 243 | 56 | 130 | MBN1810906.1 DUF4231 domain-containing protein [Anaerolineae bacterium] | diamond | 1305 | 54.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31399558 | 31399558 | PRJNA1174234_P_NODE_28616_length_253_cov_1.622222_g28420_i0 | PRJNA1174234 | 28616 | 253 | 1.622222 | 4.10422166 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 120 | 1.22e-30 | NR | MCA0452379.1 | 2026724 | g28420 | i0 | 79 | 0.960474308300395 | 81 | 17 | 96 | 0 | 252 | 10 | 260 | 340 | MCA0452379.1 hypothetical protein [Chloroflexota bacterium] | diamond | 243 | 120 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31589355 | 31589355 | PRJNA1174234_P_NODE_33536_length_244_cov_0.900585_g33340_i0 | PRJNA1174234 | 33536 | 244 | 0.900585 | 2.1974274 | Ktedonobacterales bacterium | 2306968 | Bacteria | Bacteria | 48.5 | 1.15e-4 | NR | HLV98750.1 | 2306968 | g33340 | i0 | 41.5 | 2.5327868852459 | 65 | 37 | 79.9 | 1 | 35 | 229 | 1 | 64 | HLV98750.1 nuclear transport factor 2 family protein [Ktedonobacterales bacterium] | diamond | 618 | 48.5 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacterales bacterium | ||||
| 32019600 | 32019600 | PRJNA1174234_P_NODE_27578_length_259_cov_1.548387_g27382_i0 | PRJNA1174234 | 27578 | 259 | 1.548387 | 4.01032233 | Bacteria | 2 | Bacteria | Bacteria | 60.1 | 2.6e-8 | NR | MBI9051985.1 | 2024896 | g27382 | i0 | 42.5 | 4.41312741312741 | 80 | 46 | 92.7 | 0 | 254 | 15 | 9 | 88 | MBI9051985.1 DUF1295 domain-containing protein [Anaerolineaceae bacterium] | diamond | 1143 | 60.5 | 0.993388429752066 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 32380217 | 32380217 | PRJNA1174234_P_NODE_35879_length_241_cov_0.916667_g35683_i0 | PRJNA1174234 | 35879 | 241 | 0.916667 | 2.20916747 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 148 | 6.26e-41 | NR | HYJ16406.1 | 3047546 | g35683 | i0 | 100 | 0.995850622406639 | 80 | 0 | 99.6 | 0 | 2 | 241 | 114 | 193 | HYJ16406.1 molybdopterin cofactor-binding domain-containing protein [Candidatus Limnocylindria bacterium] | diamond | 240 | 148 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria 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);;