contig_metadata
22 rows where bioproject = "PRJNA1150539", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16877938 | 16877938 | PRJNA1150539_S_NODE_103894_length_239_cov_2.319277_g103298_i0 | PRJNA1150539 | 103894 | 239 | 2.319277 | 5.54307203 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 138 | 8.4e-37 | NR | MBA2753169.1 | 2448782 | g103298 | i0 | 95.9 | 0.916317991631799 | 73 | 3 | 91.6 | 0 | 239 | 21 | 200 | 272 | MBA2753169.1 YvcK family protein [Chloroflexia bacterium] | diamond | 219 | 138 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 26723243 | 26723243 | PRJNA1150539_S_NODE_69321_length_280_cov_4.091787_g68725_i0 | PRJNA1150539 | 69321 | 280 | 4.091787 | 11.4570036 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 44.3 | 0.0165 | NR | MEM9955894.1 | 2026724 | g68725 | i0 | 34 | 0.567857142857143 | 53 | 35 | 56.8 | 0 | 113 | 271 | 198 | 250 | MEM9955894.1 ATP-binding protein [Chloroflexota bacterium] | diamond | 159 | 44.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26723250 | 26723250 | PRJNA1150539_S_NODE_97281_length_246_cov_1.335260_g96685_i0 | PRJNA1150539 | 97281 | 246 | 1.33526 | 3.2847396 | Chloroflexales bacterium | 2725990 | Bacteria | Bacteria | 43.1 | 0.0282 | NR | MEI7642886.1 | 2725990 | g96685 | i0 | 42.6 | 0.658536585365854 | 54 | 28 | 62.2 | 2 | 171 | 19 | 160 | 213 | MEI7642886.1 type III-B CRISPR module RAMP protein Cmr1 [Chloroflexales bacterium] | diamond | 162 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexales bacterium | ||||
| 26850603 | 26850603 | PRJNA1150539_S_NODE_75561_length_272_cov_1.160804_g74965_i0 | PRJNA1150539 | 75561 | 272 | 1.160804 | 3.15738688 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 43.5 | 0.0275 | NR | MBI4498881.1 | 2026724 | g74965 | i0 | 36.6 | 0.783088235294118 | 71 | 39 | 78.3 | 1 | 252 | 40 | 367 | 431 | MBI4498881.1 ammonium transporter [Chloroflexota bacterium] | diamond | 213 | 43.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26882222 | 26882222 | PRJNA1150539_S_NODE_91661_length_251_cov_3.550562_g91065_i0 | PRJNA1150539 | 91661 | 251 | 3.550562 | 8.91191062 | Leptolinea sp. | 2699749 | Bacteria | Bacteria | 46.2 | 0.00229 | NR | HEX7556536.1 | 2699749 | g91065 | i0 | 49 | 0.609561752988048 | 51 | 24 | 59.8 | 2 | 16 | 165 | 94 | 143 | HEX7556536.1 sugar ABC transporter permease [Leptolinea sp.] | diamond | 153 | 46.2 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Leptolinea | Leptolinea sp. | ||
| 26913612 | 26913612 | PRJNA1150539_S_NODE_86802_length_257_cov_2.722826_g86206_i0 | PRJNA1150539 | 86802 | 257 | 2.722826 | 6.99766282 | Dictyobacter aurantiacus | 1936993 | Bacteria | Bacteria | 42.7 | 0.0444 | NR | WP_160145687.1 | 1936993 | g86206 | i0 | 37.5 | 0.747081712062257 | 64 | 39 | 74.7 | 1 | 22 | 213 | 349 | 411 | WP_160145687.1 GAF domain-containing protein [Dictyobacter aurantiacus] | diamond | 192 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Dictyobacteraceae | Dictyobacter | Dictyobacter aurantiacus | ||
| 27103387 | 27103387 | PRJNA1150539_S_NODE_104982_length_236_cov_5.650307_g104386_i0 | PRJNA1150539 | 104982 | 236 | 5.650307 | 13.33472452 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42.4 | 0.0255 | NR | MCJ7709616.1 | 2026724 | g104386 | i0 | 35.3 | 0.648305084745763 | 51 | 33 | 64.8 | 0 | 190 | 38 | 4 | 54 | MCJ7709616.1 hypothetical protein [Chloroflexota bacterium] | diamond | 153 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27356532 | 27356532 | PRJNA1150539_S_NODE_94223_length_249_cov_1.312500_g93627_i0 | PRJNA1150539 | 94223 | 249 | 1.3125 | 3.268125 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 42.7 | 0.0361 | NR | MBL8055502.1 | 2073117 | g93627 | i0 | 38.1 | 0.759036144578313 | 63 | 34 | 75.9 | 2 | 32 | 220 | 94 | 151 | MBL8055502.1 hypothetical protein [Anaerolineales bacterium] | diamond | 189 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 27987949 | 27987949 | PRJNA1150539_S_NODE_82045_length_263_cov_2.489474_g81449_i0 | PRJNA1150539 | 82045 | 263 | 2.489474 | 6.54731662 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 43.9 | 0.0152 | NR | MBC7257967.1 | 2026724 | g81449 | i0 | 44.4 | 0.718631178707224 | 63 | 30 | 68.4 | 3 | 204 | 25 | 116 | 176 | MBC7257967.1 B-box zinc finger protein [Chloroflexota bacterium] | diamond | 189 | 43.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28177063 | 28177063 | PRJNA1150539_S_NODE_41026_length_328_cov_1.415686_g40430_i0 | PRJNA1150539 | 41026 | 328 | 1.415686 | 4.64345008 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 43.5 | 0.00914 | NR | MCK4976665.1 | 2073117 | g40430 | i0 | 31.7 | 0.75 | 82 | 52 | 71.3 | 1 | 50 | 283 | 1 | 82 | MCK4976665.1 hypothetical protein [Anaerolineales bacterium] | diamond | 246 | 43.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28303625 | 28303625 | PRJNA1150539_S_NODE_73066_length_275_cov_2.287129_g72470_i0 | PRJNA1150539 | 73066 | 275 | 2.287129 | 6.28960475 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 43.1 | 0.0137 | NR | MCI0776852.1 | 2026724 | g72470 | i0 | 42.9 | 0.381818181818182 | 35 | 20 | 38.2 | 0 | 218 | 114 | 74 | 108 | MCI0776852.1 hypothetical protein [Chloroflexota bacterium] | diamond | 105 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28398293 | 28398293 | PRJNA1150539_S_NODE_52886_length_306_cov_2.416309_g52290_i0 | PRJNA1150539 | 52886 | 306 | 2.416309 | 7.3939055400000004 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 44.3 | 0.0216 | NR | MBI5963137.1 | 2026724 | g52290 | i0 | 26.5 | 0.96078431372549 | 98 | 65 | 89.2 | 2 | 282 | 10 | 282 | 379 | MBI5963137.1 ammonium transporter [Chloroflexota bacterium] | diamond | 294 | 44.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28398295 | 28398295 | PRJNA1150539_S_NODE_69066_length_281_cov_1.475962_g68470_i0 | PRJNA1150539 | 69066 | 281 | 1.475962 | 4.14745322 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 45.4 | 0.00568 | NR | MBA2454780.1 | 2448782 | g68470 | i0 | 48.9 | 0.480427046263345 | 45 | 18 | 48 | 1 | 124 | 258 | 195 | 234 | MBA2454780.1 alpha/beta fold hydrolase [Chloroflexia bacterium] | diamond | 135 | 45.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 28619531 | 28619531 | PRJNA1150539_S_NODE_54047_length_304_cov_2.562771_g53451_i0 | PRJNA1150539 | 54047 | 304 | 2.562771 | 7.79082384 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 45.4 | 0.00782 | NR | MFN3741663.1 | 2073117 | g53451 | i0 | 34.8 | 0.680921052631579 | 69 | 45 | 68.1 | 0 | 5 | 211 | 96 | 164 | MFN3741663.1 DMT family transporter [Anaerolineales bacterium] | diamond | 207 | 45.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28745677 | 28745677 | PRJNA1150539_S_NODE_86087_length_258_cov_2.135135_g85491_i0 | PRJNA1150539 | 86087 | 258 | 2.135135 | 5.5086483 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 46.2 | 0.00257 | NR | HEY8868469.1 | 2952938 | g85491 | i0 | 46.6 | 0.848837209302326 | 73 | 36 | 84.9 | 3 | 36 | 254 | 315 | 384 | HEY8868469.1 ISNCY family transposase [Candidatus Limnocylindrales bacterium] | diamond | 219 | 46.2 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 28808480 | 28808480 | PRJNA1150539_S_NODE_84628_length_260_cov_1.647059_g84032_i0 | PRJNA1150539 | 84628 | 260 | 1.647059 | 4.2823534 | Herpetosiphonaceae bacterium | 2720503 | Bacteria | Bacteria | 44.3 | 0.00996 | NR | HEY0605044.1 | 2720503 | g84032 | i0 | 38.9 | 0.623076923076923 | 54 | 29 | 62.3 | 1 | 232 | 71 | 93 | 142 | HEY0605044.1 hypothetical protein [Herpetosiphonaceae bacterium] | diamond | 162 | 44.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 29377123 | 29377123 | PRJNA1150539_S_NODE_105329_length_236_cov_2.085890_g104733_i0 | PRJNA1150539 | 105329 | 236 | 2.08589 | 4.9227004 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 43.1 | 0.0198 | NR | MBP7692257.1 | 2073117 | g104733 | i0 | 32.8 | 2.55508474576271 | 67 | 43 | 83.9 | 2 | 225 | 28 | 5 | 70 | MBP7692257.1 hypothetical protein [Anaerolineales bacterium] | diamond | 603 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 30672092 | 30672092 | PRJNA1150539_S_NODE_79053_length_267_cov_1.984536_g78457_i0 | PRJNA1150539 | 79053 | 267 | 1.984536 | 5.29871112 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 45.1 | 0.00712 | NR | MBL8092631.1 | 2073117 | g78457 | i0 | 32.1 | 0.910112359550562 | 81 | 46 | 83.1 | 3 | 3 | 224 | 121 | 199 | MBL8092631.1 histone deacetylase family protein [Anaerolineales bacterium] | diamond | 243 | 45.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 30956736 | 30956736 | PRJNA1150539_S_NODE_109154_length_227_cov_2.792208_g108558_i0 | PRJNA1150539 | 109154 | 227 | 2.792208 | 6.33831216 | Chloroflexi bacterium ADurb.Bin36 | 1852861 | Bacteria | Bacteria | 42.4 | 0.0398 | NR | OQA15764.1 | 1852861 | g108558 | i0 | 36.5 | 0.832599118942731 | 63 | 39 | 81.9 | 1 | 9 | 194 | 46 | 108 | OQA15764.1 MAG: hypothetical protein BWY63_02862 [Chloroflexi bacterium ADurb.Bin360] | diamond | 189 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium ADurb.Bin360 | ||||||
| 31683583 | 31683583 | PRJNA1150539_S_NODE_65477_length_286_cov_2.075117_g64881_i0 | PRJNA1150539 | 65477 | 286 | 2.075117 | 5.93483462 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 43.9 | 0.0171 | NR | MDE2903152.1 | 2026724 | g64881 | i0 | 39.7 | 0.608391608391608 | 58 | 33 | 59.8 | 2 | 95 | 265 | 99 | 155 | MDE2903152.1 rhomboid family intramembrane serine protease [Chloroflexota bacterium] | diamond | 174 | 43.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32063303 | 32063303 | PRJNA1150539_S_NODE_66298_length_285_cov_1.452830_g65702_i0 | PRJNA1150539 | 66298 | 285 | 1.45283 | 4.1405655 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 44.7 | 0.0123 | NR | HJO06254.1 | 2026724 | g65702 | i0 | 32.9 | 0.863157894736842 | 82 | 47 | 80 | 2 | 248 | 21 | 103 | 182 | HJO06254.1 anthranilate synthase component I family protein [Chloroflexota bacterium] | diamond | 246 | 44.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32601174 | 32601174 | PRJNA1150539_S_NODE_102840_length_241_cov_1.142857_g102244_i0 | PRJNA1150539 | 102840 | 241 | 1.142857 | 2.75428537 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 43.1 | 0.0268 | NR | HVF24650.1 | 2073117 | g102244 | i0 | 29.2 | 0.809128630705394 | 65 | 45 | 79.7 | 1 | 7 | 198 | 344 | 408 | HVF24650.1 transporter substrate-binding domain-containing protein [Anaerolineales bacterium] | diamond | 195 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales 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);;