contig_metadata
13 rows where bioproject = "PRJNA795983", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27536955 | 27536955 | PRJNA795983_S_NODE_41163_length_243_cov_1.535294_g41038_i0 | PRJNA795983 | 41163 | 243 | 1.535294 | 3.73076442 | Bacillati | 1783272 | Bacteria | Bacteria | 99.8 | 4.3299999999999996e-23 | NR | MBV9135068.1 | 2026724 | g41038 | i0 | 60 | 17.7777777777778 | 80 | 32 | 98.8 | 0 | 241 | 2 | 72 | 151 | MBV9135068.1 Hsp70 family protein [Chloroflexota bacterium] | diamond | 4320 | 99.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27654248 | 27654248 | PRJNA795983_S_NODE_17644_length_320_cov_1.789474_g17519_i0 | PRJNA795983 | 17644 | 320 | 1.789474 | 5.7263168 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 68.9 | 5.5e-11 | NR | MEP7293183.1 | 2026724 | g17519 | i0 | 35.3 | 0.95625 | 102 | 60 | 90 | 2 | 318 | 31 | 246 | 347 | MEP7293183.1 ice-binding family protein [Chloroflexota bacterium] | diamond | 306 | 68.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28222242 | 28222242 | PRJNA795983_S_NODE_32666_length_259_cov_2.290323_g32541_i0 | PRJNA795983 | 32666 | 259 | 2.290323 | 5.93193657 | Chloroflexi bacterium RBG_13_54_8 | 1797630 | Bacteria | Bacteria | 67 | 7.07e-11 | NR | OGO04966.1 | 1797630 | g32541 | i0 | 43 | 2.95366795366795 | 86 | 47 | 99.6 | 1 | 259 | 2 | 153 | 236 | OGO04966.1 MAG: hypothetical protein A2Y91_04580 [Chloroflexi bacterium RBG_13_54_8] | diamond | 765 | 67 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium RBG_13_54_8 | ||||||
| 28348691 | 28348691 | PRJNA795983_S_NODE_28926_length_271_cov_1.671717_g28801_i0 | PRJNA795983 | 28926 | 271 | 1.671717 | 4.53035307 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 43.9 | 0.0199 | NR | HEX6036134.1 | 2073117 | g28801 | i0 | 32 | 0.830258302583026 | 75 | 40 | 83 | 2 | 45 | 269 | 79 | 142 | HEX6036134.1 PQQ-dependent sugar dehydrogenase [Anaerolineales bacterium] | diamond | 225 | 43.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 29304977 | 29304977 | PRJNA795983_S_NODE_35509_length_251_cov_3.887640_g35384_i0 | PRJNA795983 | 35509 | 251 | 3.88764 | 9.7579764 | Bacteria | 2 | Bacteria | Bacteria | 120 | 8.48e-30 | NR | MEP6808165.1 | 2026724 | g35384 | i0 | 71.3 | 4.85258964143426 | 80 | 23 | 95.6 | 0 | 3 | 242 | 178 | 257 | MEP6808165.1 DUF1116 domain-containing protein [Chloroflexota bacterium] | diamond | 1218 | 120 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29453456 | 29453456 | PRJNA795983_S_NODE_27370_length_276_cov_1.896552_g27245_i0 | PRJNA795983 | 27370 | 276 | 1.896552 | 5.23448352 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 61.2 | 1.6e-8 | NR | MBN1579730.1 | 2052143 | g27245 | i0 | 45.1 | 0.891304347826087 | 82 | 40 | 89.1 | 2 | 7 | 252 | 270 | 346 | MBN1579730.1 1,4-alpha-glucan branching protein [Anaerolineae bacterium] | diamond | 246 | 61.2 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29548334 | 29548334 | PRJNA795983_S_NODE_39870_length_245_cov_0.895349_g39745_i0 | PRJNA795983 | 39870 | 245 | 0.895349 | 2.19360505 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 90.5 | 5.92e-19 | NR | MBP1693891.1 | 2026724 | g39745 | i0 | 46.8 | 9.73469387755102 | 79 | 42 | 96.7 | 0 | 239 | 3 | 473 | 551 | MBP1693891.1 6-phosphofructokinase [Chloroflexota bacterium] | diamond | 2385 | 90.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29959015 | 29959015 | PRJNA795983_S_NODE_1011_length_939_cov_3.122402_g935_i0 | PRJNA795983 | 1011 | 939 | 3.122402 | 29.31935478 | Anaerolinea thermophila | 167964 | Bacteria | Bacteria | 77 | 2.19e-11 | NR | WP_013559229.1 | 167964 | g935 | i0 | 31.3 | 0.846645367412141 | 265 | 147 | 78.3 | 14 | 4 | 738 | 2545 | 2794 | WP_013559229.1 sortase [Anaerolinea thermophila] | diamond | 795 | 77 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolinea | Anaerolinea thermophila | ||
| 29990698 | 29990698 | PRJNA795983_S_NODE_16291_length_328_cov_2.784314_g16166_i0 | PRJNA795983 | 16291 | 328 | 2.784314 | 9.13254992 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 44.3 | 0.0277 | NR | MBI3967261.1 | 2026724 | g16166 | i0 | 38.7 | 0.685975609756098 | 75 | 40 | 63.1 | 2 | 4 | 210 | 346 | 420 | MBI3967261.1 cellulose-binding protein [Chloroflexota bacterium] | diamond | 225 | 44.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29990720 | 29990720 | PRJNA795983_S_NODE_9011_length_403_cov_1.527273_g8886_i0 | PRJNA795983 | 9011 | 403 | 1.527273 | 6.15491019 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 90.5 | 5.3e-19 | NR | MEZ4671869.1 | 2052143 | g8886 | i0 | 39.6 | 0.997518610421836 | 134 | 67 | 92.3 | 3 | 402 | 31 | 70 | 199 | MEZ4671869.1 carbonic anhydrase family protein [Anaerolineae bacterium] | diamond | 402 | 90.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31033573 | 31033573 | PRJNA795983_S_NODE_26195_length_280_cov_3.570048_g26070_i0 | PRJNA795983 | 26195 | 280 | 3.570048 | 9.9961344 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 58.2 | 2.18e-7 | NR | MEZ4731472.1 | 2614250 | g26070 | i0 | 35.6 | 3.76071428571429 | 87 | 54 | 91.1 | 1 | 264 | 10 | 439 | 525 | MEZ4731472.1 interleukin-like EMT inducer domain-containing protein [Caldilineaceae bacterium] | diamond | 1053 | 58.2 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 31168583 | 31168583 | PRJNA795983_S_NODE_35335_length_252_cov_1.513966_g35210_i0 | PRJNA795983 | 35335 | 252 | 1.513966 | 3.81519432 | PVC group | 1783257 | Bacteria | Bacteria | 73.9 | 4.18e-13 | NR | MCP4138866.1 | 2026724 | g35210 | i0 | 54.8 | 2.66666666666667 | 73 | 30 | 86.9 | 1 | 236 | 18 | 267 | 336 | MCP4138866.1 peroxidase [Chloroflexota bacterium] | diamond | 672 | 74.3 | 0.994616419919246 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31792004 | 31792004 | PRJNA795983_S_NODE_41457_length_243_cov_0.905882_g41332_i0 | PRJNA795983 | 41457 | 243 | 0.905882 | 2.20129326 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 140 | 9.829999999999998e-37 | NR | HLF89965.1 | 2073117 | g41332 | i0 | 82.5 | 2.96296296296296 | 80 | 14 | 98.8 | 0 | 241 | 2 | 127 | 206 | HLF89965.1 amidohydrolase family protein [Anaerolineales bacterium] | diamond | 720 | 140 | 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);;