contig_metadata
14 rows where bioproject = "PRJNA1248424" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4180357 | 4180357 | PRJNA1248424_P_NODE_67364_length_255_cov_1.824176_g61295_i0 | PRJNA1248424 | 67364 | 255 | 1.824176 | 4.6516488 | root | 1 | Root_unresolved | Root_unresolved | 155 | 8.679999999999999e-45 | NR | HET7828574.1 | 2952938 | g61295 | i0 | 85.7 | 9.85882352941177 | 84 | 12 | 98.8 | 0 | 253 | 2 | 155 | 238 | HET7828574.1 FAD-binding oxidoreductase [Candidatus Limnocylindrales bacterium] | diamond | 2514 | 155 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 10557312 | 10557312 | PRJNA1248424_P_NODE_69069_length_251_cov_0.865169_g63000_i0 | PRJNA1248424 | 69069 | 251 | 0.865169 | 2.17157419 | Bacillati | 1783272 | Bacteria | Bacteria | 143 | 6.829999999999999e-40 | NR | MDQ6793663.1 | 2026724 | g63000 | i0 | 84.3 | 5.9402390438247 | 83 | 13 | 99.2 | 0 | 2 | 250 | 60 | 142 | MDQ6793663.1 aspartate carbamoyltransferase catalytic subunit [Chloroflexota bacterium] | diamond | 1491 | 144 | 0.993055555555556 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 18204723 | 18204723 | PRJNA1248424_P_NODE_60815_length_273_cov_2.130000_g54747_i0 | PRJNA1248424 | 60815 | 273 | 2.13 | 5.8149 | PVC group | 1783257 | Bacteria | Bacteria | 91.3 | 2.52e-20 | NR | MEP7356428.1 | 2073117 | g54747 | i0 | 51.7 | 3.95604395604396 | 89 | 43 | 97.8 | 0 | 3 | 269 | 98 | 186 | MEP7356428.1 4-alpha-glucanotransferase [Anaerolineales bacterium] | diamond | 1080 | 92 | 0.992391304347826 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 26820633 | 26820633 | PRJNA1248424_P_NODE_47541_length_322_cov_2.815261_g41474_i0 | PRJNA1248424 | 47541 | 322 | 2.815261 | 9.06514042 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 89 | 5.93e-20 | NR | HZR98716.1 | 2026724 | g41474 | i0 | 85.7 | 0.91304347826087 | 49 | 7 | 45.7 | 0 | 149 | 3 | 51 | 99 | HZR98716.1 5-methyltetrahydropteroyltriglutamate--homocysteine S-methyltransferase [Chloroflexota bacterium] | diamond | 294 | 89 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26915404 | 26915404 | PRJNA1248424_P_NODE_71302_length_249_cov_0.875000_g65233_i0 | PRJNA1248424 | 71302 | 249 | 0.875 | 2.17875 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42.7 | 0.0375 | NR | MBI2957355.1 | 2026724 | g65233 | i0 | 35.1 | 0.891566265060241 | 74 | 43 | 84.3 | 2 | 244 | 35 | 187 | 259 | MBI2957355.1 PQQ-dependent sugar dehydrogenase [Chloroflexota bacterium] | diamond | 222 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27831666 | 27831666 | PRJNA1248424_P_NODE_45364_length_334_cov_2.061303_g39300_i0 | PRJNA1248424 | 45364 | 334 | 2.061303 | 6.88475202 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 44.7 | 0.0216 | NR | MEJ2599791.1 | 2073117 | g39300 | i0 | 29.3 | 0.826347305389222 | 92 | 53 | 71.9 | 3 | 88 | 327 | 355 | 446 | MEJ2599791.1 hypothetical protein [Anaerolineales bacterium] | diamond | 276 | 44.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28021349 | 28021349 | PRJNA1248424_P_NODE_78885_length_242_cov_0.911243_g72816_i0 | PRJNA1248424 | 78885 | 242 | 0.911243 | 2.20520806 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 116 | 7.21e-32 | NR | MDQ3870499.1 | 2026724 | g72816 | i0 | 75 | 0.991735537190083 | 80 | 20 | 99.2 | 0 | 2 | 241 | 10 | 89 | MDQ3870499.1 tetratricopeptide repeat protein [Chloroflexota bacterium] | diamond | 240 | 116 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28544629 | 28544629 | PRJNA1248424_P_NODE_25627_length_628_cov_3.448649_g19670_i0 | PRJNA1248424 | 25627 | 628 | 3.448649 | 21.65751572 | Bacteria | 2 | Bacteria | Bacteria | 53.9 | 5.24e-5 | NR | MCX6000258.1 | 2026724 | g19670 | i0 | 44.2 | 1.60031847133758 | 52 | 29 | 24.8 | 0 | 469 | 314 | 142 | 193 | MCX6000258.1 ATP-dependent Clp protease proteolytic subunit [Chloroflexota bacterium] | diamond | 1005 | 54.3 | 0.992633517495396 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29599603 | 29599603 | PRJNA1248424_P_NODE_3770_length_3111_cov_21.351547_g2810_i0 | PRJNA1248424 | 3770 | 3111 | 21.351547 | 664.24662717 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 92.4 | 3.82e-15 | NR | MCP4356419.1 | 2026724 | g2810 | i0 | 23.7 | 0.541947926711668 | 562 | 334 | 51.6 | 22 | 718 | 2322 | 53 | 546 | MCP4356419.1 ATP-binding domain-containing protein [Chloroflexota bacterium] | diamond | 1686 | 92.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29789160 | 29789160 | PRJNA1248424_P_NODE_60631_length_274_cov_1.288557_g54563_i0 | PRJNA1248424 | 60631 | 274 | 1.288557 | 3.53064618 | Chloroflexales bacterium | 2725990 | Bacteria | Bacteria | 125 | 3.659999999999999e-31 | NR | MBC8075372.1 | 2725990 | g54563 | i0 | 67.4 | 0.974452554744526 | 89 | 29 | 97.4 | 0 | 269 | 3 | 150 | 238 | MBC8075372.1 alpha-galactosidase [Chloroflexales bacterium] | diamond | 267 | 125 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexales bacterium | ||||
| 30610601 | 30610601 | PRJNA1248424_P_NODE_67933_length_254_cov_0.906077_g61864_i0 | PRJNA1248424 | 67933 | 254 | 0.906077 | 2.30143558 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 42.7 | 0.0418 | NR | HIN06841.1 | 2026734 | g61864 | i0 | 38.9 | 1.2755905511811 | 54 | 33 | 63.8 | 0 | 48 | 209 | 40 | 93 | HIN06841.1 hypothetical protein [Dehalococcoidia bacterium] | diamond | 324 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 30831837 | 30831837 | PRJNA1248424_P_NODE_57454_length_282_cov_1.382775_g51386_i0 | PRJNA1248424 | 57454 | 282 | 1.382775 | 3.8994255 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 162 | 2.06e-46 | NR | HXD10291.1 | 2073117 | g51386 | i0 | 81.5 | 11.7446808510638 | 92 | 17 | 97.9 | 0 | 6 | 281 | 183 | 274 | HXD10291.1 spermidine/putrescine ABC transporter substrate-binding protein [Anaerolineales bacterium] | diamond | 3312 | 162 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32191801 | 32191801 | PRJNA1248424_P_NODE_62098_length_270_cov_1.243655_g56029_i0 | PRJNA1248424 | 62098 | 270 | 1.243655 | 3.3578685 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 161 | 7.49e-49 | NR | MFO7743059.1 | 2052143 | g56029 | i0 | 87.6 | 0.988888888888889 | 89 | 11 | 98.9 | 0 | 2 | 268 | 22 | 110 | MFO7743059.1 reverse transcriptase domain-containing protein [Anaerolineae bacterium] | diamond | 267 | 161 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 32665694 | 32665694 | PRJNA1248424_P_NODE_43100_length_350_cov_1.083032_g37038_i0 | PRJNA1248424 | 43100 | 350 | 1.083032 | 3.790612 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 125 | 4.3e-34 | NR | MFO7743059.1 | 2052143 | g37038 | i0 | 79.7 | 0.677142857142857 | 79 | 14 | 67.7 | 1 | 114 | 350 | 39 | 115 | MFO7743059.1 reverse transcriptase domain-containing protein [Anaerolineae bacterium] | diamond | 237 | 125 | 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);;