contig_metadata
23 rows where bioproject = "PRJNA382558" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4232094 | 4232094 | PRJNA382558_S_NODE_5524_length_206_cov_3.662722_g5520_i0 | PRJNA382558 | 5524 | 206 | 3.662722 | 7.54520732 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 123 | 1.33e-33 | NR | HXI17455.1 | 2026724 | g5520 | i0 | 100 | 0.990291262135922 | 68 | 0 | 99 | 0 | 2 | 205 | 63 | 130 | HXI17455.1 hypothetical protein [Chloroflexota bacterium] | diamond | 204 | 123 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 5508599 | 5508599 | PRJNA382558_S_NODE_3105_length_241_cov_4.779412_g3101_i0 | PRJNA382558 | 3105 | 241 | 4.779412 | 11.51838292 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 140 | 1.1e-36 | NR | MDP8922424.1 | 2026724 | g3101 | i0 | 73.8 | 3.98340248962656 | 80 | 21 | 99.6 | 0 | 241 | 2 | 338 | 417 | MDP8922424.1 glycoside hydrolase family 78 protein [Chloroflexota bacterium] | diamond | 960 | 140 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 25301899 | 25301899 | PRJNA382558_S_NODE_220_length_448_cov_11.892944_g216_i0 | PRJNA382558 | 220 | 448 | 11.892944 | 53.28038912 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 89.4 | 4.43e-20 | NR | HXI17312.1 | 2026724 | g216 | i0 | 89.6 | 0.321428571428571 | 48 | 5 | 32.1 | 0 | 3 | 146 | 47 | 94 | HXI17312.1 hypothetical protein [Chloroflexota bacterium] | diamond | 144 | 89.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26726562 | 26726562 | PRJNA382558_S_NODE_10721_length_169_cov_7.083333_g10717_i0 | PRJNA382558 | 10721 | 169 | 7.083333 | 11.97083277 | Herpetosiphonaceae bacterium | 2720503 | Bacteria | Bacteria | 54.7 | 8.06e-7 | NR | MBA3945156.1 | 2720503 | g10717 | i0 | 46.4 | 0.994082840236686 | 56 | 27 | 94.1 | 1 | 9 | 167 | 391 | 446 | MBA3945156.1 ATP-dependent RecD-like DNA helicase [Herpetosiphonaceae bacterium] | diamond | 168 | 54.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 27738887 | 27738887 | PRJNA382558_S_NODE_5924_length_201_cov_9.835366_g5920_i0 | PRJNA382558 | 5924 | 201 | 9.835366 | 19.76908566 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 75.5 | 6.01e-14 | NR | GIK76248.1 | 2026724 | g5920 | i0 | 53 | 3.55223880597015 | 66 | 31 | 98.5 | 0 | 199 | 2 | 263 | 328 | GIK76248.1 MAG: hypothetical protein BroJett021_52360 [Chloroflexota bacterium] | diamond | 714 | 75.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27818798 | 27818798 | PRJNA382558_S_NODE_5564_length_205_cov_7.541667_g5560_i0 | PRJNA382558 | 5564 | 205 | 7.541667 | 15.46041735 | root | 1 | Root_unresolved | Root_unresolved | 102 | 5.34e-25 | NR | KPK04502.1 | 1703386 | g5560 | i0 | 75 | 1.99024390243902 | 68 | 17 | 99.5 | 0 | 204 | 1 | 154 | 221 | KPK04502.1 MAG: hypothetical protein AMJ56_17365 [Anaerolineae bacterium SG8_19] | diamond | 408 | 103 | 0.990291262135922 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium SG8_19 | |||||
| 28085770 | 28085770 | PRJNA382558_S_NODE_4145_length_222_cov_8.837838_g4141_i0 | PRJNA382558 | 4145 | 222 | 8.837838 | 19.62000036 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 135 | 1.15e-36 | NR | HXI15985.1 | 2026724 | g4141 | i0 | 100 | 0.891891891891892 | 66 | 0 | 89.2 | 0 | 220 | 23 | 279 | 344 | HXI15985.1 IS630 family transposase [Chloroflexota bacterium] | diamond | 198 | 135 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28243550 | 28243550 | PRJNA382558_S_NODE_9526_length_175_cov_7.615942_g9522_i0 | PRJNA382558 | 9526 | 175 | 7.615942 | 13.3278985 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 117 | 1.61e-31 | NR | HXI17455.1 | 2026724 | g9522 | i0 | 100 | 0.994285714285714 | 58 | 0 | 99.4 | 0 | 174 | 1 | 139 | 196 | HXI17455.1 hypothetical protein [Chloroflexota bacterium] | diamond | 174 | 117 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28433218 | 28433218 | PRJNA382558_S_NODE_3946_length_225_cov_9.824468_g3942_i0 | PRJNA382558 | 3946 | 225 | 9.824468 | 22.105053 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 40.4 | 0.0363 | NR | MDO8614614.1 | 2026734 | g3942 | i0 | 37.5 | 0.64 | 48 | 25 | 64 | 1 | 190 | 47 | 30 | 72 | MDO8614614.1 hypothetical protein [Dehalococcoidia bacterium] | diamond | 144 | 40.4 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 29001924 | 29001924 | PRJNA382558_S_NODE_6928_length_192_cov_12.935484_g6924_i0 | PRJNA382558 | 6928 | 192 | 12.935484 | 24.83612928 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 130 | 8.079999999999999e-37 | NR | HXI17456.1 | 2026724 | g6924 | i0 | 100 | 0.9375 | 60 | 0 | 93.8 | 0 | 13 | 192 | 1 | 60 | HXI17456.1 exosortase/archaeosortase family protein [Chloroflexota bacterium] | diamond | 180 | 130 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29664168 | 29664168 | PRJNA382558_S_NODE_10650_length_169_cov_10.030303_g10646_i0 | PRJNA382558 | 10650 | 169 | 10.030303 | 16.95121207 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 111 | 1.3800000000000002e-27 | NR | HXI18558.1 | 2026724 | g10646 | i0 | 100 | 0.994082840236686 | 56 | 0 | 99.4 | 0 | 169 | 2 | 266 | 321 | HXI18558.1 prolyl oligopeptidase family serine peptidase [Chloroflexota bacterium] | diamond | 168 | 111 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29790627 | 29790627 | PRJNA382558_S_NODE_12231_length_162_cov_9.224000_g12227_i0 | PRJNA382558 | 12231 | 162 | 9.224 | 14.94288 | Ktedonobacteraceae bacterium | 2740538 | Bacteria | Bacteria | 60.8 | 4.86e-9 | NR | MBO0781359.1 | 2740538 | g12227 | i0 | 60.4 | 0.981481481481482 | 53 | 21 | 98.1 | 0 | 3 | 161 | 158 | 210 | MBO0781359.1 MFS transporter [Ktedonobacteraceae bacterium] | diamond | 159 | 60.8 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacteraceae bacterium | |||
| 30485948 | 30485948 | PRJNA382558_S_NODE_733_length_342_cov_6.662295_g729_i0 | PRJNA382558 | 733 | 342 | 6.662295 | 22.7850489 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 242 | 1.48e-77 | NR | HXI18558.1 | 2026724 | g729 | i0 | 100 | 0.991228070175439 | 113 | 0 | 99.1 | 0 | 340 | 2 | 118 | 230 | HXI18558.1 prolyl oligopeptidase family serine peptidase [Chloroflexota bacterium] | diamond | 339 | 242 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30692286 | 30692286 | PRJNA382558_S_NODE_15773_length_151_cov_3.350877_g15769_i0 | PRJNA382558 | 15773 | 151 | 3.350877 | 5.05982427 | Bacteria | 2 | Bacteria | Bacteria | 52.8 | 1.27e-6 | NR | MCD4738304.1 | 2052143 | g15769 | i0 | 47.1 | 3.03973509933775 | 51 | 26 | 99.3 | 1 | 151 | 2 | 79 | 129 | MCD4738304.1 hypothetical protein [Anaerolineae bacterium] | diamond | 459 | 52.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31212147 | 31212147 | PRJNA382558_S_NODE_11675_length_165_cov_5.257812_g11671_i0 | PRJNA382558 | 11675 | 165 | 5.257812 | 8.6753898 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 55.1 | 5.87e-7 | NR | MEK7216931.1 | 2026724 | g11671 | i0 | 43.6 | 1 | 55 | 31 | 100 | 0 | 1 | 165 | 370 | 424 | MEK7216931.1 SNF2-related protein [Chloroflexota bacterium] | diamond | 165 | 55.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31402552 | 31402552 | PRJNA382558_S_NODE_9476_length_175_cov_10.297101_g9472_i0 | PRJNA382558 | 9476 | 175 | 10.297101 | 18.01992675 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 119 | 2.91e-32 | NR | HXI17313.1 | 2026724 | g9472 | i0 | 100 | 0.994285714285714 | 58 | 0 | 99.4 | 0 | 175 | 2 | 22 | 79 | HXI17313.1 serine hydrolase [Chloroflexota bacterium] | diamond | 174 | 119 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31655234 | 31655234 | PRJNA382558_S_NODE_977_length_320_cov_9.215548_g973_i0 | PRJNA382558 | 977 | 320 | 9.215548 | 29.4897536 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 134 | 2.62e-34 | NR | MEK7216931.1 | 2026724 | g973 | i0 | 63.8 | 0.984375 | 105 | 38 | 98.4 | 0 | 6 | 320 | 420 | 524 | MEK7216931.1 SNF2-related protein [Chloroflexota bacterium] | diamond | 315 | 134 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31718684 | 31718684 | PRJNA382558_S_NODE_8257_length_183_cov_4.958904_g8253_i0 | PRJNA382558 | 8257 | 183 | 4.958904 | 9.07479432 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 96.7 | 2.1e-23 | NR | HXI17456.1 | 2026724 | g8253 | i0 | 93.6 | 0.770491803278688 | 47 | 3 | 77 | 0 | 1 | 141 | 131 | 177 | HXI17456.1 exosortase/archaeosortase family protein [Chloroflexota bacterium] | diamond | 141 | 96.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31830284 | 31830284 | PRJNA382558_S_NODE_1357_length_296_cov_9.594595_g1353_i0 | PRJNA382558 | 1357 | 296 | 9.594595 | 28.4000012 | Bacillati | 1783272 | Bacteria | Bacteria | 62.4 | 8.29e-9 | NR | MSQ36852.1 | 2026724 | g1353 | i0 | 39.2 | 2.91891891891892 | 97 | 48 | 98.3 | 4 | 295 | 5 | 135 | 220 | MSQ36852.1 hypothetical protein [Chloroflexota bacterium] | diamond | 864 | 62.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31861943 | 31861943 | PRJNA382558_S_NODE_2177_length_263_cov_12.871681_g2173_i0 | PRJNA382558 | 2177 | 263 | 12.871681 | 33.85252103 | Bacteria | 2 | Bacteria | Bacteria | 57.4 | 3.23e-7 | NR | OGO11299.1 | 1797638 | g2173 | i0 | 46.4 | 3.9467680608365 | 69 | 33 | 78.7 | 3 | 209 | 3 | 113 | 177 | OGO11299.1 MAG: hypothetical protein A2Y93_11610 [Chloroflexi bacterium RBG_13_68_17] | diamond | 1038 | 57.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium RBG_13_68_17 | ||||||
| 32098236 | 32098236 | PRJNA382558_S_NODE_18_length_930_cov_9.218365_g16_i0 | PRJNA382558 | 18 | 930 | 9.218365 | 85.7307945 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 546 | 2.2399999999999994e-194 | NR | HXI15985.1 | 2026724 | g16 | i0 | 99.6 | 0.896774193548387 | 278 | 1 | 89.7 | 0 | 834 | 1 | 1 | 278 | HXI15985.1 IS630 family transposase [Chloroflexota bacterium] | diamond | 834 | 546 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32509927 | 32509927 | PRJNA382558_S_NODE_5999_length_201_cov_5.000000_g5995_i0 | PRJNA382558 | 5999 | 201 | 5 | 10.05 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 132 | 2.17e-37 | NR | HXI17456.1 | 2026724 | g5995 | i0 | 100 | 0.955223880597015 | 64 | 0 | 95.5 | 0 | 194 | 3 | 61 | 124 | HXI17456.1 exosortase/archaeosortase family protein [Chloroflexota bacterium] | diamond | 192 | 132 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32684055 | 32684055 | PRJNA382558_S_NODE_10700_length_169_cov_7.803030_g10696_i0 | PRJNA382558 | 10700 | 169 | 7.80303 | 13.1871207 | Bacteria | 2 | Bacteria | Bacteria | 70.9 | 4.65e-13 | NR | WP_069803676.1 | 732234 | g10696 | i0 | 60.7 | 9.94082840236686 | 56 | 18 | 99.4 | 2 | 168 | 1 | 172 | 223 | WP_069803676.1 hypothetical protein [Thermogemmatispora onikobensis] | diamond | 1680 | 70.9 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Thermogemmatisporales | Thermogemmatisporaceae | Thermogemmatispora | Thermogemmatispora onikobensis |
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);;