contig_metadata
27 rows where bioproject = "PRJEB39643", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15360611 | 15360611 | PRJEB39643_P_NODE_78153_length_271_cov_6.090909_g77960_i0 | PRJEB39643 | 78153 | 271 | 6.090909 | 16.50636339 | Anaerolinea thermolimosa | 229919 | Bacteria | Bacteria | 117 | 4.1e-28 | NR | WP_062191565.1 | 229919 | g77960 | i0 | 64 | 6.91881918819188 | 89 | 31 | 98.5 | 1 | 4 | 270 | 499 | 586 | WP_062191565.1 alpha-L-rhamnosidase [Anaerolinea thermolimosa] | diamond | 1875 | 117 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolinea | Anaerolinea thermolimosa | ||
| 26685084 | 26685084 | PRJEB39643_P_NODE_39601_length_298_cov_2.737778_g39408_i0 | PRJEB39643 | 39601 | 298 | 2.737778 | 8.15857844 | Chloroflexi bacterium OLB15 | 1617416 | Bacteria | Bacteria | 51.2 | 7.19e-5 | NR | KXK24678.1 | 1617416 | g39408 | i0 | 31.8 | 0.855704697986577 | 85 | 58 | 85.6 | 0 | 264 | 10 | 288 | 372 | KXK24678.1 MAG: major facilitator superfamily MFS_1 [Chloroflexi bacterium OLB15] | diamond | 255 | 51.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium OLB15 | ||||||
| 27033313 | 27033313 | PRJEB39643_P_NODE_123982_length_250_cov_2.112994_g123789_i0 | PRJEB39643 | 123982 | 250 | 2.112994 | 5.282485 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 43.9 | 0.00823 | NR | HEX3265800.1 | 2952938 | g123789 | i0 | 35.1 | 1.788 | 77 | 44 | 85.2 | 1 | 8 | 220 | 37 | 113 | HEX3265800.1 alpha/beta family hydrolase [Candidatus Limnocylindrales bacterium] | diamond | 447 | 43.9 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 27318032 | 27318032 | PRJEB39643_P_NODE_22683_length_383_cov_1.987097_g22490_i0 | PRJEB39643 | 22683 | 383 | 1.987097 | 7.61058151 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 151 | 2.38e-41 | NR | MCS6834470.1 | 2052143 | g22490 | i0 | 55.6 | 0.971279373368146 | 124 | 55 | 97.1 | 0 | 373 | 2 | 114 | 237 | MCS6834470.1 diaminopimelate decarboxylase [Anaerolineae bacterium] | diamond | 372 | 151 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 27633781 | 27633781 | PRJEB39643_P_NODE_16464_length_453_cov_2.984211_g16271_i0 | PRJEB39643 | 16464 | 453 | 2.984211 | 13.51847583 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 45.4 | 0.0345 | NR | MCP5097020.1 | 2026724 | g16271 | i0 | 28.1 | 0.589403973509934 | 89 | 58 | 58.3 | 3 | 286 | 23 | 27 | 110 | MCP5097020.1 hypothetical protein [Chloroflexota bacterium] | diamond | 267 | 45.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28044137 | 28044137 | PRJEB39643_P_NODE_31465_length_330_cov_1.587549_g31272_i0 | PRJEB39643 | 31465 | 330 | 1.587549 | 5.2389117 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 199 | 6.48e-63 | NR | HXI17456.1 | 2026724 | g31272 | i0 | 100 | 0.854545454545454 | 94 | 0 | 85.5 | 0 | 48 | 329 | 1 | 94 | HXI17456.1 exosortase/archaeosortase family protein [Chloroflexota bacterium] | diamond | 282 | 199 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28069058 | 28069058 | PRJEB39643_P_NODE_133985_length_247_cov_1.327586_g133792_i0 | PRJEB39643 | 133985 | 247 | 1.327586 | 3.27913742 | Chloroflexota | 200795 | Bacteria | Bacteria | 103 | 2.6699999999999998e-24 | NR | HOQ98570.1 | 2052143 | g133792 | i0 | 62.7 | 5.45344129554656 | 75 | 28 | 91.1 | 0 | 245 | 21 | 270 | 344 | HOQ98570.1 NADPH dehydrogenase NamA [Anaerolineae bacterium] | diamond | 1347 | 103 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28580992 | 28580992 | PRJEB39643_P_NODE_121547_length_251_cov_1.730337_g121354_i0 | PRJEB39643 | 121547 | 251 | 1.730337 | 4.34314587 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 52.8 | 1.2e-5 | NR | HDN80822.1 | 2026724 | g121354 | i0 | 39.2 | 1.76892430278884 | 74 | 40 | 87.3 | 2 | 11 | 229 | 12 | 81 | HDN80822.1 molecular chaperone DnaK [Chloroflexota bacterium] | diamond | 444 | 52.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28612528 | 28612528 | PRJEB39643_P_NODE_43947_length_289_cov_2.407407_g43754_i0 | PRJEB39643 | 43947 | 289 | 2.407407 | 6.95740623 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 91.7 | 4.28e-19 | NR | MCU0520278.1 | 2052143 | g43754 | i0 | 49.5 | 1.00692041522491 | 97 | 47 | 98.6 | 1 | 285 | 1 | 3 | 99 | MCU0520278.1 glycoside hydrolase family 78 protein [Anaerolineae bacterium] | diamond | 291 | 91.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28637650 | 28637650 | PRJEB39643_P_NODE_85227_length_268_cov_1.579487_g85034_i0 | PRJEB39643 | 85227 | 268 | 1.579487 | 4.23302516 | Chloroflexales | 32064 | Bacteria | Bacteria | 83.6 | 1.8e-16 | NR | WP_097653398.1 | 1579476 | g85034 | i0 | 64.6 | 2.94402985074627 | 65 | 16 | 64.9 | 1 | 94 | 267 | 3 | 67 | WP_097653398.1 MULTISPECIES: citrate synthase [Candidatus Chloroploca] | diamond | 789 | 83.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Oscillochloridaceae | Candidatus Chloroploca | |||
| 28896545 | 28896545 | PRJEB39643_P_NODE_71228_length_275_cov_1.524752_g71035_i0 | PRJEB39643 | 71228 | 275 | 1.524752 | 4.193068 | Caldilinea sp. | 2293560 | Bacteria | Bacteria | 52 | 3.06e-5 | NR | MCX6041194.1 | 2293560 | g71035 | i0 | 35.2 | 6.90545454545455 | 91 | 54 | 99.3 | 4 | 2 | 274 | 450 | 535 | MCX6041194.1 cyclic nucleotide-binding domain-containing protein [Caldilinea sp.] | diamond | 1899 | 52 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilinea | Caldilinea sp. | ||
| 29332066 | 29332066 | PRJEB39643_P_NODE_55249_length_283_cov_1.466667_g55056_i0 | PRJEB39643 | 55249 | 283 | 1.466667 | 4.15066761 | Chloroflexota | 200795 | Bacteria | Bacteria | 122 | 4.92e-31 | NR | MFO7540588.1 | 2026724 | g55056 | i0 | 66.3 | 11.904593639576 | 86 | 29 | 91.2 | 0 | 25 | 282 | 12 | 97 | MFO7540588.1 PLP-dependent aminotransferase family protein [Chloroflexota bacterium] | diamond | 3369 | 122 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29843881 | 29843881 | PRJEB39643_P_NODE_43051_length_290_cov_1.419355_g42858_i0 | PRJEB39643 | 43051 | 290 | 1.419355 | 4.1161295 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 91.3 | 1.46e-20 | NR | MDP9352490.1 | 2026724 | g42858 | i0 | 48.4 | 0.982758620689655 | 95 | 49 | 98.3 | 0 | 288 | 4 | 20 | 114 | MDP9352490.1 hypothetical protein [Chloroflexota bacterium] | diamond | 285 | 91.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29970194 | 29970194 | PRJEB39643_P_NODE_23611_length_375_cov_2.887417_g23418_i0 | PRJEB39643 | 23611 | 375 | 2.887417 | 10.82781375 | Ktedonobacterales bacterium | 2306968 | Bacteria | Bacteria | 47.8 | 0.00211 | NR | HEX8032285.1 | 2306968 | g23418 | i0 | 25.6 | 0.936 | 117 | 80 | 91.2 | 3 | 26 | 367 | 47 | 159 | HEX8032285.1 DUF6585 family protein [Ktedonobacterales bacterium] | diamond | 351 | 47.8 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacterales bacterium | ||||
| 30349919 | 30349919 | PRJEB39643_P_NODE_44072_length_289_cov_1.782407_g43879_i0 | PRJEB39643 | 44072 | 289 | 1.782407 | 5.15115623 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 45.4 | 0.00681 | NR | MDY7080095.1 | 2026724 | g43879 | i0 | 33.3 | 0.965397923875433 | 93 | 58 | 95.5 | 2 | 282 | 7 | 229 | 318 | MDY7080095.1 carboxymuconolactone decarboxylase family protein [Chloroflexota bacterium] | diamond | 279 | 45.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30412876 | 30412876 | PRJEB39643_P_NODE_50153_length_286_cov_1.446009_g49960_i0 | PRJEB39643 | 50153 | 286 | 1.446009 | 4.13558574 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 50.4 | 6.07e-5 | NR | CAG0973558.1 | 2073117 | g49960 | i0 | 37 | 1.04895104895105 | 100 | 41 | 83.9 | 5 | 284 | 45 | 57 | 154 | CAG0973558.1 partial Autolysin, partial [Anaerolineales bacterium] | diamond | 300 | 50.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 30507383 | 30507383 | PRJEB39643_P_NODE_23393_length_377_cov_2.019737_g23200_i0 | PRJEB39643 | 23393 | 377 | 2.019737 | 7.61440849 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 178 | 5.58e-51 | NR | MCX6031372.1 | 2026724 | g23200 | i0 | 64 | 5.96021220159151 | 125 | 45 | 99.5 | 0 | 376 | 2 | 232 | 356 | MCX6031372.1 aspartate aminotransferase family protein [Chloroflexota bacterium] | diamond | 2247 | 178 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30633562 | 30633562 | PRJEB39643_P_NODE_97193_length_262_cov_3.079365_g97000_i0 | PRJEB39643 | 97193 | 262 | 3.079365 | 8.0679363 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 57.8 | 1.86e-7 | NR | MEL7591096.1 | 2024896 | g97000 | i0 | 51 | 3.26335877862595 | 51 | 21 | 58.4 | 1 | 20 | 172 | 118 | 164 | MEL7591096.1 pirin family protein [Anaerolineaceae bacterium] | diamond | 855 | 57.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 30791629 | 30791629 | PRJEB39643_P_NODE_111254_length_256_cov_1.683060_g111061_i0 | PRJEB39643 | 111254 | 256 | 1.68306 | 4.3086336 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 43.1 | 0.0192 | NR | HYM80956.1 | 3047546 | g111061 | i0 | 33.3 | 0.73828125 | 63 | 35 | 65.6 | 1 | 220 | 53 | 65 | 127 | HYM80956.1 hypothetical protein [Candidatus Limnocylindria bacterium] | diamond | 189 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria bacterium | |||||
| 30949853 | 30949853 | PRJEB39643_P_NODE_64154_length_279_cov_1.495146_g63961_i0 | PRJEB39643 | 64154 | 279 | 1.495146 | 4.17145734 | Chloroflexi bacterium HGW-Chloroflexi-5 | 2013728 | Bacteria | Bacteria | 155 | 7.27e-43 | NR | PKN97172.1 | 2013728 | g63961 | i0 | 78.3 | 0.989247311827957 | 92 | 20 | 98.9 | 0 | 277 | 2 | 289 | 380 | PKN97172.1 MAG: hypothetical protein CVU43_17665 [Chloroflexi bacterium HGW-Chloroflexi-5] | diamond | 276 | 155 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium HGW-Chloroflexi-5 | ||||||
| 31012858 | 31012858 | PRJEB39643_P_NODE_43715_length_290_cov_1.419355_g43522_i0 | PRJEB39643 | 43715 | 290 | 1.419355 | 4.1161295 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 194 | 4.619999999999998e-56 | NR | NWG06702.1 | 2026724 | g43522 | i0 | 93.8 | 4.96551724137931 | 96 | 6 | 99.3 | 0 | 289 | 2 | 424 | 519 | NWG06702.1 right-handed parallel beta-helix repeat-containing protein [Chloroflexota bacterium] | diamond | 1440 | 194 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31733347 | 31733347 | PRJEB39643_P_NODE_28797_length_343_cov_1.711111_g28604_i0 | PRJEB39643 | 28797 | 343 | 1.711111 | 5.86911073 | Bacteria | 2 | Bacteria | Bacteria | 127 | 8.18e-33 | NR | NJD58483.1 | 2052143 | g28604 | i0 | 69.6 | 2.62390670553936 | 92 | 28 | 80.5 | 0 | 4 | 279 | 238 | 329 | NJD58483.1 aspartate carbamoyltransferase [Anaerolineae bacterium] | diamond | 900 | 127 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31803245 | 31803245 | PRJEB39643_P_NODE_25577_length_362_cov_1.598616_g25384_i0 | PRJEB39643 | 25577 | 362 | 1.598616 | 5.78698992 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 138 | 2.32e-37 | NR | MCL6509822.1 | 2052143 | g25384 | i0 | 56.7 | 0.994475138121547 | 120 | 52 | 99.4 | 0 | 2 | 361 | 128 | 247 | MCL6509822.1 zeta toxin family protein [Anaerolineae bacterium] | diamond | 360 | 138 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 32024905 | 32024905 | PRJEB39643_P_NODE_15618_length_468_cov_2.349367_g15426_i0 | PRJEB39643 | 15618 | 468 | 2.349367 | 10.99503756 | Ktedonobacteraceae bacterium | 2740538 | Bacteria | Bacteria | 52 | 2.09e-4 | NR | HYU74800.1 | 2740538 | g15426 | i0 | 49 | 0.314102564102564 | 49 | 25 | 31.4 | 0 | 192 | 46 | 299 | 347 | HYU74800.1 protein kinase [Ktedonobacteraceae bacterium] | diamond | 147 | 52 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacteraceae bacterium | |||
| 32246731 | 32246731 | PRJEB39643_P_NODE_69358_length_276_cov_1.517241_g69165_i0 | PRJEB39643 | 69358 | 276 | 1.517241 | 4.18758516 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 85.5 | 3.94e-18 | NR | MCA9973017.1 | 2073117 | g69165 | i0 | 43.2 | 0.956521739130435 | 88 | 50 | 95.7 | 0 | 10 | 273 | 124 | 211 | MCA9973017.1 sulfotransferase [Anaerolineales bacterium] | diamond | 264 | 85.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32278200 | 32278200 | PRJEB39643_P_NODE_33659_length_320_cov_2.493927_g33466_i0 | PRJEB39643 | 33659 | 320 | 2.493927 | 7.9805664 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 126 | 7.3699999999999995e-34 | NR | MQC25993.1 | 2026724 | g33466 | i0 | 59.2 | 4.734375 | 98 | 40 | 91.9 | 0 | 319 | 26 | 26 | 123 | MQC25993.1 uracil phosphoribosyltransferase [Chloroflexota bacterium] | diamond | 1515 | 126 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32846108 | 32846108 | PRJEB39643_P_NODE_41040_length_293_cov_3.300000_g40847_i0 | PRJEB39643 | 41040 | 293 | 3.3 | 9.669 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 43.1 | 0.048 | NR | HIQ06362.1 | 2052143 | g40847 | i0 | 39 | 0.604095563139932 | 59 | 36 | 60.4 | 0 | 277 | 101 | 163 | 221 | HIQ06362.1 hypothetical protein [Anaerolineae bacterium] | diamond | 177 | 43.1 | 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);;