contig_metadata
13 rows where bioproject = "PRJNA638138", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26618653 | 26618653 | PRJNA638138_P_NODE_28681_length_245_cov_0.895349_g28466_i0 | PRJNA638138 | 28681 | 245 | 0.895349 | 2.19360505 | PVC group | 1783257 | Bacteria | Bacteria | 43.5 | 0.0199 | NR | TME73673.1 | 2026724 | g28466 | i0 | 42.6 | 1.64081632653061 | 47 | 27 | 57.6 | 0 | 4 | 144 | 375 | 421 | TME73673.1 MAG: hypothetical protein E6I46_11715 [Chloroflexota bacterium] | diamond | 402 | 43.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27080966 | 27080966 | PRJNA638138_P_NODE_16582_length_270_cov_1.000000_g16367_i0 | PRJNA638138 | 16582 | 270 | 1 | 2.7 | Herpetosiphonaceae bacterium | 2720503 | Bacteria | Bacteria | 132 | 6.9e-35 | NR | HSH79606.1 | 2720503 | g16367 | i0 | 68.5 | 0.988888888888889 | 89 | 28 | 98.9 | 0 | 2 | 268 | 233 | 321 | HSH79606.1 homoserine O-acetyltransferase [Herpetosiphonaceae bacterium] | diamond | 267 | 132 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 27694010 | 27694010 | PRJNA638138_P_NODE_19684_length_251_cov_0.865169_g19469_i0 | PRJNA638138 | 19684 | 251 | 0.865169 | 2.17157419 | Bacillati | 1783272 | Bacteria | Bacteria | 145 | 4.6099999999999996e-42 | NR | HUP26346.1 | 2952938 | g19469 | i0 | 81.7 | 4.92430278884462 | 82 | 15 | 98 | 0 | 250 | 5 | 56 | 137 | HUP26346.1 hypothetical protein [Candidatus Limnocylindrales bacterium] | diamond | 1236 | 146 | 0.993150684931507 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 27914570 | 27914570 | PRJNA638138_P_NODE_34805_length_241_cov_0.916667_g34590_i0 | PRJNA638138 | 34805 | 241 | 0.916667 | 2.20916747 | Bacteria | 2 | Bacteria | Bacteria | 124 | 1.5199999999999998e-31 | NR | RIK42195.1 | 2026724 | g34590 | i0 | 78.2 | 6.84647302904564 | 78 | 17 | 97.1 | 0 | 6 | 239 | 233 | 310 | RIK42195.1 MAG: dihydroorotase [Chloroflexota bacterium] | diamond | 1650 | 124 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28880939 | 28880939 | PRJNA638138_P_NODE_28168_length_246_cov_0.890173_g27953_i0 | PRJNA638138 | 28168 | 246 | 0.890173 | 2.18982558 | Ktedonobacteraceae bacterium | 2740538 | Bacteria | Bacteria | 65.9 | 2.7e-10 | NR | HET8846456.1 | 2740538 | g27953 | i0 | 64.3 | 1.04878048780488 | 42 | 15 | 51.2 | 0 | 134 | 9 | 2 | 43 | HET8846456.1 M3 family oligoendopeptidase [Ktedonobacteraceae bacterium] | diamond | 258 | 65.9 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacteraceae bacterium | |||
| 29606882 | 29606882 | PRJNA638138_P_NODE_20410_length_251_cov_0.865169_g20195_i0 | PRJNA638138 | 20410 | 251 | 0.865169 | 2.17157419 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 42.4 | 0.0368 | NR | MPZ49624.1 | 2026734 | g20195 | i0 | 29.5 | 0.932270916334661 | 78 | 40 | 80.1 | 2 | 248 | 48 | 90 | 163 | MPZ49624.1 DUF2243 domain-containing protein [Dehalococcoidia bacterium] | diamond | 234 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 29701610 | 29701610 | PRJNA638138_P_NODE_21750_length_250_cov_0.870056_g21535_i0 | PRJNA638138 | 21750 | 250 | 0.870056 | 2.17514 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 90.1 | 4.64e-19 | NR | MBL8134202.1 | 2052143 | g21535 | i0 | 76.9 | 1.248 | 52 | 12 | 62.4 | 0 | 157 | 2 | 266 | 317 | MBL8134202.1 transposase [Anaerolineae bacterium] | diamond | 312 | 90.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30523292 | 30523292 | PRJNA638138_P_NODE_5933_length_406_cov_3.246246_g5718_i0 | PRJNA638138 | 5933 | 406 | 3.246246 | 13.17975876 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 45.1 | 0.0193 | NR | HJW22528.1 | 2952938 | g5718 | i0 | 39.6 | 0.391625615763547 | 53 | 32 | 39.2 | 0 | 238 | 80 | 6 | 58 | HJW22528.1 GNAT family N-acetyltransferase [Candidatus Limnocylindrales bacterium] | diamond | 159 | 45.1 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 31345055 | 31345055 | PRJNA638138_P_NODE_36096_length_241_cov_0.886905_g35881_i0 | PRJNA638138 | 36096 | 241 | 0.886905 | 2.13744105 | Chloroflexaceae bacterium | 2562117 | Bacteria | Bacteria | 113 | 1.75e-27 | NR | HMQ35813.1 | 2562117 | g35881 | i0 | 74.7 | 0.983402489626556 | 79 | 20 | 98.3 | 0 | 238 | 2 | 213 | 291 | HMQ35813.1 AI-2E family transporter [Chloroflexaceae bacterium] | diamond | 237 | 113 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexaceae | Chloroflexaceae bacterium | |||
| 32294384 | 32294384 | PRJNA638138_P_NODE_17239_length_265_cov_0.932292_g17024_i0 | PRJNA638138 | 17239 | 265 | 0.932292 | 2.4705738 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 46.6 | 0.00203 | NR | MBI4498881.1 | 2026724 | g17024 | i0 | 41.3 | 0.713207547169811 | 63 | 31 | 71.3 | 1 | 251 | 63 | 367 | 423 | MBI4498881.1 ammonium transporter [Chloroflexota bacterium] | diamond | 189 | 46.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32357553 | 32357553 | PRJNA638138_P_NODE_25999_length_247_cov_0.885057_g25784_i0 | PRJNA638138 | 25999 | 247 | 0.885057 | 2.18609079 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 100 | 2.4199999999999998e-23 | NR | HEX5590111.1 | 2952938 | g25784 | i0 | 65.8 | 0.923076923076923 | 76 | 26 | 92.3 | 0 | 246 | 19 | 252 | 327 | HEX5590111.1 alpha/beta hydrolase [Candidatus Limnocylindrales bacterium] | diamond | 228 | 100 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 32483982 | 32483982 | PRJNA638138_P_NODE_27899_length_246_cov_0.890173_g27684_i0 | PRJNA638138 | 27899 | 246 | 0.890173 | 2.18982558 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 130 | 5.31e-33 | NR | MCB0179546.1 | 2052143 | g27684 | i0 | 74.1 | 2.9390243902439 | 81 | 21 | 98.8 | 0 | 245 | 3 | 77 | 157 | MCB0179546.1 DUF2207 domain-containing protein [Anaerolineae bacterium] | diamond | 723 | 130 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 32610218 | 32610218 | PRJNA638138_P_NODE_17140_length_265_cov_1.604167_g16925_i0 | PRJNA638138 | 17140 | 265 | 1.604167 | 4.25104255 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 144 | 1.7899999999999996e-38 | NR | MCW5854014.1 | 2052143 | g16925 | i0 | 72.4 | 18.7018867924528 | 87 | 24 | 98.5 | 0 | 2 | 262 | 145 | 231 | MCW5854014.1 carboxypeptidase regulatory-like domain-containing protein [Anaerolineae bacterium] | diamond | 4956 | 144 | 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);;