contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA1188114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4146916 | 4146916 | PRJNA1188114_P_NODE_17724_length_162_cov_1.805310_g17672_i0 | PRJNA1188114 | 17724 | 162 | 1.80531 | 2.9246022 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 106 | 7.68e-26 | NR | HSA99715.1 | 2073117 | g17672 | i0 | 84.9 | 14.7222222222222 | 53 | 8 | 98.1 | 0 | 160 | 2 | 223 | 275 | HSA99715.1 amidohydrolase family protein [Anaerolineales bacterium] | diamond | 2385 | 106 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 9247904 | 9247904 | PRJNA1188114_P_NODE_17568_length_163_cov_0.894737_g17516_i0 | PRJNA1188114 | 17568 | 163 | 0.894737 | 1.45842131 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 77 | 8.84e-15 | NR | MCW5879393.1 | 2052143 | g17516 | i0 | 66.7 | 4.93251533742331 | 54 | 18 | 99.4 | 0 | 1 | 162 | 121 | 174 | MCW5879393.1 P1 family peptidase [Anaerolineae bacterium] | diamond | 804 | 77 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 26660547 | 26660547 | PRJNA1188114_P_NODE_6501_length_189_cov_1.750000_g6449_i0 | PRJNA1188114 | 6501 | 189 | 1.75 | 3.3075 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 68.2 | 1.92e-11 | NR | MBV9791054.1 | 2026724 | g6449 | i0 | 56.9 | 1.88888888888889 | 58 | 25 | 92.1 | 0 | 6 | 179 | 364 | 421 | MBV9791054.1 glycosyltransferase family 39 protein [Chloroflexota bacterium] | diamond | 357 | 68.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26819347 | 26819347 | PRJNA1188114_P_NODE_20541_length_152_cov_2.601942_g20489_i0 | PRJNA1188114 | 20541 | 152 | 2.601942 | 3.95495184 | Herpetosiphonaceae bacterium | 2720503 | Bacteria | Bacteria | 50.1 | 2.76e-5 | NR | HEX6290935.1 | 2720503 | g20489 | i0 | 67.6 | 0.671052631578947 | 34 | 11 | 67.1 | 0 | 51 | 152 | 233 | 266 | HEX6290935.1 hypothetical protein [Herpetosiphonaceae bacterium] | diamond | 102 | 50.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 27262118 | 27262118 | PRJNA1188114_P_NODE_8643_length_181_cov_1.454545_g8591_i0 | PRJNA1188114 | 8643 | 181 | 1.454545 | 2.63272645 | Ardenticatenaceae bacterium | 2614247 | Bacteria | Bacteria | 60.5 | 9.06e-9 | NR | MCZ7574426.1 | 2614247 | g8591 | i0 | 50 | 1.02762430939227 | 62 | 29 | 99.4 | 1 | 1 | 180 | 361 | 422 | MCZ7574426.1 hypothetical protein [Ardenticatenaceae bacterium] | diamond | 186 | 60.5 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Ardenticatenales | Ardenticatenaceae | Ardenticatenaceae bacterium | |||
| 28177533 | 28177533 | PRJNA1188114_P_NODE_19446_length_161_cov_0.910714_g19394_i0 | PRJNA1188114 | 19446 | 161 | 0.910714 | 1.46624954 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 45.8 | 8.22e-4 | NR | MBV9791788.1 | 2026724 | g19394 | i0 | 100 | 0.708074534161491 | 19 | 0 | 35.4 | 0 | 105 | 161 | 1 | 19 | MBV9791788.1 ThuA domain-containing protein [Chloroflexota bacterium] | diamond | 114 | 45.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28398785 | 28398785 | PRJNA1188114_P_NODE_18666_length_162_cov_0.902655_g18614_i0 | PRJNA1188114 | 18666 | 162 | 0.902655 | 1.4623011 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 87.4 | 2.19e-18 | NR | MFN8624203.1 | 2026724 | g18614 | i0 | 83 | 0.981481481481482 | 53 | 9 | 98.1 | 0 | 161 | 3 | 311 | 363 | MFN8624203.1 MMPL family transporter [Chloroflexota bacterium] | diamond | 159 | 87.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28525260 | 28525260 | PRJNA1188114_P_NODE_7867_length_184_cov_1.503704_g7815_i0 | PRJNA1188114 | 7867 | 184 | 1.503704 | 2.76681536 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 85.9 | 3.76e-18 | NR | MDP9313565.1 | 2026724 | g7815 | i0 | 93 | 0.701086956521739 | 43 | 3 | 70.1 | 0 | 54 | 182 | 1 | 43 | MDP9313565.1 ABC transporter ATP-binding protein [Chloroflexota bacterium] | diamond | 129 | 85.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28670525 | 28670525 | PRJNA1188114_P_NODE_16527_length_163_cov_1.701754_g16475_i0 | PRJNA1188114 | 16527 | 163 | 1.701754 | 2.77385902 | Bacteria | 2 | Bacteria | Bacteria | 87 | 3.13e-18 | NR | MBV9790534.1 | 2026724 | g16475 | i0 | 72.5 | 1.87730061349693 | 51 | 14 | 93.9 | 0 | 162 | 10 | 596 | 646 | MBV9790534.1 GAF domain-containing protein [Chloroflexota bacterium] | diamond | 306 | 87 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28828132 | 28828132 | PRJNA1188114_P_NODE_12208_length_167_cov_0.864407_g12156_i0 | PRJNA1188114 | 12208 | 167 | 0.864407 | 1.44355969 | Bacteria | 2 | Bacteria | Bacteria | 78.6 | 1.9e-15 | NR | MDP9310511.1 | 2026724 | g12156 | i0 | 69.8 | 1.90419161676647 | 53 | 16 | 95.2 | 0 | 160 | 2 | 58 | 110 | MDP9310511.1 hypothetical protein [Chloroflexota bacterium] | diamond | 318 | 79.3 | 0.991172761664565 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28967278 | 28967278 | PRJNA1188114_P_NODE_12468_length_167_cov_0.864407_g12416_i0 | PRJNA1188114 | 12468 | 167 | 0.864407 | 1.44355969 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 60.8 | 5.2e-9 | NR | PLS79107.1 | 2026724 | g12416 | i0 | 62.5 | 1.0059880239521 | 56 | 20 | 98.8 | 1 | 165 | 1 | 22 | 77 | PLS79107.1 MAG: RNA polymerase sigma factor RpoD [Chloroflexota bacterium] | diamond | 168 | 60.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29377584 | 29377584 | PRJNA1188114_P_NODE_9169_length_178_cov_2.627907_g9117_i0 | PRJNA1188114 | 9169 | 178 | 2.627907 | 4.67767446 | Roseiflexaceae bacterium | 2762507 | Bacteria | Bacteria | 84 | 6.78e-18 | NR | HEU4327780.1 | 2762507 | g9117 | i0 | 65.5 | 0.97752808988764 | 58 | 20 | 97.8 | 0 | 176 | 3 | 173 | 230 | HEU4327780.1 SDR family NAD(P)-dependent oxidoreductase [Roseiflexaceae bacterium] | diamond | 174 | 84 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae bacterium | |||
| 30103813 | 30103813 | PRJNA1188114_P_NODE_9092_length_179_cov_1.284615_g9040_i0 | PRJNA1188114 | 9092 | 179 | 1.284615 | 2.29946085 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 75.9 | 3.28e-14 | NR | UCH86615.1 | 2026734 | g9040 | i0 | 83.7 | 2.56424581005587 | 43 | 7 | 72.1 | 0 | 51 | 179 | 39 | 81 | UCH86615.1 MAG: thrombospondin type 3 repeat-containing protein [Dehalococcoidia bacterium] | diamond | 459 | 75.9 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 30198500 | 30198500 | PRJNA1188114_P_NODE_10112_length_174_cov_3.136000_g10060_i0 | PRJNA1188114 | 10112 | 174 | 3.136 | 5.45664 | Caldilinea sp. | 2293560 | Bacteria | Bacteria | 94.4 | 4.15e-21 | NR | WP_343402105.1 | 2293560 | g10060 | i0 | 80.7 | 0.982758620689655 | 57 | 11 | 98.3 | 0 | 174 | 4 | 62 | 118 | WP_343402105.1 uroporphyrinogen decarboxylase family protein [Caldilinea sp.] | diamond | 171 | 94.4 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilinea | Caldilinea sp. | ||
| 30230299 | 30230299 | PRJNA1188114_P_NODE_1652_length_331_cov_2.680851_g1600_i0 | PRJNA1188114 | 1652 | 331 | 2.680851 | 8.87361681 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 46.6 | 0.00437 | NR | MCA9961175.1 | 2073117 | g1600 | i0 | 37 | 0.661631419939577 | 73 | 38 | 60.7 | 3 | 330 | 130 | 164 | 234 | MCA9961175.1 hypothetical protein [Anaerolineales bacterium] | diamond | 219 | 46.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 30357230 | 30357230 | PRJNA1188114_P_NODE_11712_length_168_cov_1.714286_g11660_i0 | PRJNA1188114 | 11712 | 168 | 1.714286 | 2.88000048 | Herpetosiphonaceae bacterium | 2720503 | Bacteria | Bacteria | 91.3 | 6.71e-20 | NR | HEX6288017.1 | 2720503 | g11660 | i0 | 75 | 1 | 56 | 13 | 98.2 | 1 | 167 | 3 | 169 | 224 | HEX6288017.1 gliding motility-associated C-terminal domain-containing protein [Herpetosiphonaceae bacterium] | diamond | 168 | 91.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 30628300 | 30628300 | PRJNA1188114_P_NODE_17493_length_163_cov_0.894737_g17441_i0 | PRJNA1188114 | 17493 | 163 | 0.894737 | 1.45842131 | Chloroflexia | 32061 | Bacteria | Bacteria | 95.1 | 7.789999999999999e-23 | NR | HEY0735434.1 | 2720503 | g17441 | i0 | 92.5 | 3.90184049079755 | 53 | 4 | 97.5 | 0 | 160 | 2 | 45 | 97 | HEY0735434.1 hypothetical protein [Herpetosiphonaceae bacterium] | diamond | 636 | 95.5 | 0.995811518324607 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 31052084 | 31052084 | PRJNA1188114_P_NODE_4315_length_216_cov_0.916168_g4263_i0 | PRJNA1188114 | 4315 | 216 | 0.916168 | 1.97892288 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 54.3 | 2.01e-6 | NR | MFO7166538.1 | 2026724 | g4263 | i0 | 40 | 1.875 | 65 | 39 | 90.3 | 0 | 213 | 19 | 210 | 274 | MFO7166538.1 glycosyltransferase [Chloroflexota bacterium] | diamond | 405 | 54.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31209326 | 31209326 | PRJNA1188114_P_NODE_10735_length_172_cov_1.658537_g10683_i0 | PRJNA1188114 | 10735 | 172 | 1.658537 | 2.85268364 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 119 | 1.78e-31 | NR | MDP9316371.1 | 2026724 | g10683 | i0 | 94.6 | 2.93023255813953 | 56 | 3 | 97.7 | 0 | 2 | 169 | 20 | 75 | MDP9316371.1 transposase [Chloroflexota bacterium] | diamond | 504 | 119 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31241281 | 31241281 | PRJNA1188114_P_NODE_13815_length_166_cov_0.871795_g13763_i0 | PRJNA1188114 | 13815 | 166 | 0.871795 | 1.4471797 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 62.4 | 1.51e-9 | NR | MFO7167732.1 | 2026724 | g13763 | i0 | 96.8 | 2.80120481927711 | 31 | 1 | 56 | 0 | 93 | 1 | 1 | 31 | MFO7167732.1 ammonium transporter [Chloroflexota bacterium] | diamond | 465 | 62.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31273078 | 31273078 | PRJNA1188114_P_NODE_12355_length_167_cov_0.864407_g12303_i0 | PRJNA1188114 | 12355 | 167 | 0.864407 | 1.44355969 | Roseiflexaceae bacterium | 2762507 | Bacteria | Bacteria | 99.4 | 1.22e-22 | NR | HEU5015846.1 | 2762507 | g12303 | i0 | 83.6 | 0.988023952095808 | 55 | 9 | 98.8 | 0 | 1 | 165 | 402 | 456 | HEU5015846.1 extracellular solute-binding protein [Roseiflexaceae bacterium] | diamond | 165 | 99.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae bacterium | |||
| 31304635 | 31304635 | PRJNA1188114_P_NODE_20075_length_161_cov_0.866071_g20023_i0 | PRJNA1188114 | 20075 | 161 | 0.866071 | 1.39437431 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 71.6 | 7.84e-13 | NR | HEY8730945.1 | 3047546 | g20023 | i0 | 70.6 | 3.87577639751553 | 51 | 15 | 95 | 0 | 159 | 7 | 476 | 526 | HEY8730945.1 3D-(3,5/4)-trihydroxycyclohexane-1,2-dione acylhydrolase (decyclizing) [Candidatus Limnocylindria bacterium] | diamond | 624 | 71.6 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria bacterium | |||||
| 31829627 | 31829627 | PRJNA1188114_P_NODE_14377_length_165_cov_0.879310_g14325_i0 | PRJNA1188114 | 14377 | 165 | 0.87931 | 1.4508615 | Bacteria | 2 | Bacteria | Bacteria | 95.1 | 4.02e-21 | NR | MDQ3227850.1 | 2026724 | g14325 | i0 | 83.3 | 3.83636363636364 | 54 | 9 | 98.2 | 0 | 163 | 2 | 290 | 343 | MDQ3227850.1 GMC family oxidoreductase N-terminal domain-containing protein [Chloroflexota bacterium] | diamond | 633 | 95.9 | 0.991657977059437 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32000574 | 32000574 | PRJNA1188114_P_NODE_8118_length_183_cov_1.522388_g8066_i0 | PRJNA1188114 | 8118 | 183 | 1.522388 | 2.78597004 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 89 | 3.36e-19 | NR | MCC7358894.1 | 2073117 | g8066 | i0 | 71.2 | 0.967213114754098 | 59 | 17 | 96.7 | 0 | 181 | 5 | 179 | 237 | MCC7358894.1 flippase-like domain-containing protein [Anaerolineales bacterium] | diamond | 177 | 89 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32158927 | 32158927 | PRJNA1188114_P_NODE_12698_length_167_cov_0.864407_g12646_i0 | PRJNA1188114 | 12698 | 167 | 0.864407 | 1.44355969 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 65.9 | 9.23e-11 | NR | MBM2849279.1 | 2073117 | g12646 | i0 | 58.2 | 0.988023952095808 | 55 | 23 | 98.8 | 0 | 2 | 166 | 280 | 334 | MBM2849279.1 hypothetical protein [Anaerolineales bacterium] | diamond | 165 | 65.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32412027 | 32412027 | PRJNA1188114_P_NODE_18099_length_162_cov_0.902655_g18047_i0 | PRJNA1188114 | 18099 | 162 | 0.902655 | 1.4623011 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 63.5 | 1.3099999999999999e-10 | NR | HMA32983.1 | 2448782 | g18047 | i0 | 84.4 | 0.592592592592593 | 32 | 5 | 59.3 | 0 | 134 | 39 | 154 | 185 | HMA32983.1 hypothetical protein [Chloroflexia bacterium] | diamond | 96 | 63.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 32601619 | 32601619 | PRJNA1188114_P_NODE_6180_length_190_cov_2.496454_g6128_i0 | PRJNA1188114 | 6180 | 190 | 2.496454 | 4.7432626 | Ktedonobacterales bacterium | 2306968 | Bacteria | Bacteria | 42 | 0.0355 | NR | HLV97439.1 | 2306968 | g6128 | i0 | 48.7 | 0.615789473684211 | 39 | 20 | 61.6 | 0 | 1 | 117 | 544 | 582 | HLV97439.1 SWIM zinc finger family protein [Ktedonobacterales bacterium] | diamond | 117 | 42 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacterales bacterium | ||||
| 32759017 | 32759017 | PRJNA1188114_P_NODE_8940_length_179_cov_3.869231_g8888_i0 | PRJNA1188114 | 8940 | 179 | 3.869231 | 6.92592349 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42.4 | 0.0216 | NR | PLS82595.1 | 2026724 | g8888 | i0 | 61.1 | 1.20670391061453 | 72 | 15 | 98.9 | 1 | 3 | 179 | 204 | 275 | PLS82595.1 MAG: murein L,D-transpeptidase [Chloroflexota bacterium] | diamond | 216 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota 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);;