contig_metadata
18 rows where bioproject = "PRJNA1108487" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4040219 | 4040219 | PRJNA1108487_P_NODE_4604_length_326_cov_1.213439_g4538_i0 | PRJNA1108487 | 4604 | 326 | 1.213439 | 3.95581114 | Chloroflexota | 200795 | Bacteria | Bacteria | 130 | 9.81e-33 | NR | MCA9951013.1 | 2073117 | g4538 | i0 | 60.2 | 1.99693251533742 | 108 | 42 | 98.5 | 1 | 324 | 4 | 165 | 272 | MCA9951013.1 SCP2 sterol-binding domain-containing protein [Anaerolineales bacterium] | diamond | 651 | 130 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 11223984 | 11223984 | PRJNA1108487_P_NODE_5409_length_305_cov_2.017241_g5343_i0 | PRJNA1108487 | 5409 | 305 | 2.017241 | 6.15258505 | Bacteria | 2 | Bacteria | Bacteria | 107 | 1.0799999999999999e-24 | NR | MEC9141140.1 | 2026724 | g5343 | i0 | 58.4 | 4.9672131147541 | 101 | 42 | 99.3 | 0 | 3 | 305 | 527 | 627 | MEC9141140.1 sodium-translocating pyrophosphatase [Chloroflexota bacterium] | diamond | 1515 | 107 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27731444 | 27731444 | PRJNA1108487_P_NODE_8844_length_251_cov_0.876404_g8778_i0 | PRJNA1108487 | 8844 | 251 | 0.876404 | 2.19977404 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 65.1 | 5.45e-10 | NR | MDO9332954.1 | 2026733 | g8778 | i0 | 44.6 | 0.884462151394422 | 74 | 40 | 88.4 | 1 | 5 | 226 | 495 | 567 | MDO9332954.1 hypothetical protein [Dehalococcoidales bacterium] | diamond | 222 | 65.1 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 28204528 | 28204528 | PRJNA1108487_P_NODE_1566_length_534_cov_1.045553_g1500_i0 | PRJNA1108487 | 1566 | 534 | 1.045553 | 5.58325302 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 95.1 | 1.69e-19 | NR | MCC6382455.1 | 2026734 | g1500 | i0 | 38.4 | 0.775280898876405 | 138 | 82 | 77.5 | 2 | 522 | 109 | 88 | 222 | MCC6382455.1 phosphate ABC transporter substrate-binding protein PstS [Dehalococcoidia bacterium] | diamond | 414 | 95.1 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 28552208 | 28552208 | PRJNA1108487_P_NODE_8207_length_254_cov_1.292818_g8141_i0 | PRJNA1108487 | 8207 | 254 | 1.292818 | 3.28375772 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 43.1 | 0.0314 | NR | MCB0102013.1 | 2073117 | g8141 | i0 | 40.3 | 0.732283464566929 | 62 | 36 | 73.2 | 1 | 231 | 46 | 228 | 288 | MCB0102013.1 tetratricopeptide repeat protein [Anaerolineales bacterium] | diamond | 186 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28678511 | 28678511 | PRJNA1108487_P_NODE_6207_length_288_cov_1.446512_g6141_i0 | PRJNA1108487 | 6207 | 288 | 1.446512 | 4.16595456 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42.4 | 0.0318 | NR | MCX6019144.1 | 2026724 | g6141 | i0 | 39 | 0.427083333333333 | 41 | 25 | 42.7 | 0 | 58 | 180 | 76 | 116 | MCX6019144.1 globin domain-containing protein [Chloroflexota bacterium] | diamond | 123 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29341497 | 29341497 | PRJNA1108487_P_NODE_9609_length_248_cov_0.891429_g9543_i0 | PRJNA1108487 | 9609 | 248 | 0.891429 | 2.21074392 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 108 | 1.28e-25 | NR | MDO9334462.1 | 2026733 | g9543 | i0 | 67.1 | 0.883064516129032 | 73 | 24 | 88.3 | 0 | 246 | 28 | 121 | 193 | MDO9334462.1 hypothetical protein [Dehalococcoidales bacterium] | diamond | 219 | 108 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 29499195 | 29499195 | PRJNA1108487_P_NODE_6590_length_280_cov_1.120773_g6524_i0 | PRJNA1108487 | 6590 | 280 | 1.120773 | 3.1381644 | Ktedonobacteraceae bacterium | 2740538 | Bacteria | Bacteria | 77.4 | 3.74e-14 | NR | HVU71151.1 | 2740538 | g6524 | i0 | 56.1 | 2.1 | 66 | 29 | 70.7 | 0 | 278 | 81 | 802 | 867 | HVU71151.1 malectin domain-containing carbohydrate-binding protein [Ktedonobacteraceae bacterium] | diamond | 588 | 77.4 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacteraceae bacterium | |||
| 29562281 | 29562281 | PRJNA1108487_P_NODE_2310_length_446_cov_3.281501_g2244_i0 | PRJNA1108487 | 2310 | 446 | 3.281501 | 14.63549446 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 48.5 | 0.00309 | NR | MEP7215414.1 | 2024896 | g2244 | i0 | 34.6 | 0.544843049327354 | 81 | 48 | 53.8 | 2 | 160 | 399 | 922 | 998 | MEP7215414.1 PKD domain-containing protein [Anaerolineaceae bacterium] | diamond | 243 | 48.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 29972945 | 29972945 | PRJNA1108487_P_NODE_5691_length_299_cov_1.035398_g5625_i0 | PRJNA1108487 | 5691 | 299 | 1.035398 | 3.09584002 | Ardenticatenia bacterium | 2099665 | Bacteria | Bacteria | 94.7 | 5.6900000000000005e-21 | NR | MDQ7029270.1 | 2099665 | g5625 | i0 | 53 | 2.02675585284281 | 100 | 42 | 97.3 | 2 | 291 | 1 | 60 | 157 | MDQ7029270.1 CoA ester lyase [Ardenticatenia bacterium] | diamond | 606 | 94.7 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Ardenticatenia bacterium | |||||
| 30510021 | 30510021 | PRJNA1108487_P_NODE_10073_length_246_cov_0.901734_g10007_i0 | PRJNA1108487 | 10073 | 246 | 0.901734 | 2.21826564 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 48.1 | 4.91e-4 | NR | MBN1642547.1 | 2052143 | g10007 | i0 | 52.4 | 1.07317073170732 | 42 | 20 | 51.2 | 0 | 246 | 121 | 257 | 298 | MBN1642547.1 nucleoside kinase [Anaerolineae bacterium] | diamond | 264 | 48.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30731183 | 30731183 | PRJNA1108487_P_NODE_1874_length_494_cov_3.555819_g1808_i0 | PRJNA1108487 | 1874 | 494 | 3.555819 | 17.56574586 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 65.1 | 4.06e-10 | NR | MCW5848612.1 | 2052143 | g1808 | i0 | 40.2 | 0.771255060728745 | 127 | 72 | 76.5 | 4 | 460 | 83 | 1 | 124 | MCW5848612.1 profilin [Anaerolineae bacterium] | diamond | 381 | 65.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30731189 | 30731189 | PRJNA1108487_P_NODE_894_length_689_cov_2.889610_g832_i0 | PRJNA1108487 | 894 | 689 | 2.88961 | 19.9094129 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 67.8 | 3.38e-9 | NR | MCZ2112159.1 | 2026734 | g832 | i0 | 31.3 | 0.975326560232221 | 224 | 134 | 96.2 | 8 | 18 | 680 | 31 | 237 | MCZ2112159.1 hypothetical protein [Dehalococcoidia bacterium] | diamond | 672 | 67.8 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 30920999 | 30920999 | PRJNA1108487_P_NODE_3434_length_369_cov_1.581081_g3368_i0 | PRJNA1108487 | 3434 | 369 | 1.581081 | 5.83418889 | Chloroflexales bacterium | 2725990 | Bacteria | Bacteria | 47.4 | 9.7e-4 | NR | MBC8076631.1 | 2725990 | g3368 | i0 | 40.4 | 0.463414634146341 | 57 | 33 | 46.3 | 1 | 1 | 171 | 21 | 76 | MBC8076631.1 response regulator [Chloroflexales bacterium] | diamond | 171 | 47.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexales bacterium | ||||
| 31765717 | 31765717 | PRJNA1108487_P_NODE_1877_length_494_cov_1.852732_g1811_i0 | PRJNA1108487 | 1877 | 494 | 1.852732 | 9.15249608 | Bacteria | 2 | Bacteria | Bacteria | 99 | 7.74e-22 | NR | NOZ05588.1 | 2026724 | g1811 | i0 | 46.7 | 2.72064777327935 | 107 | 53 | 65 | 1 | 321 | 1 | 15 | 117 | NOZ05588.1 enoyl-CoA hydratase [Chloroflexota bacterium] | diamond | 1344 | 99 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31901018 | 31901018 | PRJNA1108487_P_NODE_11137_length_242_cov_1.698225_g11071_i0 | PRJNA1108487 | 11137 | 242 | 1.698225 | 4.1097045 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 59.7 | 1.18e-8 | NR | RIK46929.1 | 2026724 | g11071 | i0 | 50 | 0.84297520661157 | 68 | 28 | 81.8 | 2 | 2 | 199 | 124 | 187 | RIK46929.1 MAG: NUDIX hydrolase [Chloroflexota bacterium] | diamond | 204 | 59.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31955453 | 31955453 | PRJNA1108487_P_NODE_4377_length_333_cov_1.800000_g4311_i0 | PRJNA1108487 | 4377 | 333 | 1.8 | 5.994 | Bacteria | 2 | Bacteria | Bacteria | 43.9 | 0.0364 | NR | MBI3158969.1 | 2026724 | g4311 | i0 | 39 | 2.15315315315315 | 77 | 26 | 69.4 | 4 | 329 | 99 | 111 | 166 | MBI3158969.1 metallophosphoesterase [Chloroflexota bacterium] | diamond | 717 | 44.3 | 0.99097065462754 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32880303 | 32880303 | PRJNA1108487_P_NODE_11360_length_242_cov_0.923077_g11294_i0 | PRJNA1108487 | 11360 | 242 | 0.923077 | 2.23384634 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 47.8 | 2.76e-4 | NR | MBC7869695.1 | 2052143 | g11294 | i0 | 35.9 | 0.793388429752066 | 64 | 38 | 79.3 | 1 | 194 | 3 | 3 | 63 | MBC7869695.1 cyclic nucleotide-binding domain-containing protein [Anaerolineae bacterium] | diamond | 192 | 47.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae 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);;