contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA944406" and tax_phylum = "Fibrobacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 924675 | 924675 | PRJNA944406_P_NODE_55141_length_258_cov_1.664865_g54182_i0 | PRJNA944406 | 55141 | 258 | 1.664865 | 4.2953517 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 126 | 4.939999999999998e-35 | NR | MCD6023900.1 | 2725311 | g54182 | i0 | 91.5 | 0.825581395348837 | 71 | 6 | 82.6 | 0 | 44 | 256 | 1 | 71 | MCD6023900.1 transcription elongation factor GreA [Fibrobacteria bacterium] | diamond | 213 | 126 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 2200016 | 2200016 | PRJNA944406_P_NODE_51142_length_262_cov_1.560847_g50183_i0 | PRJNA944406 | 51142 | 262 | 1.560847 | 4.08941914 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 163 | 1.41e-48 | NR | MCD6024501.1 | 2725311 | g50183 | i0 | 95.3 | 0.984732824427481 | 86 | 4 | 98.5 | 0 | 260 | 3 | 125 | 210 | MCD6024501.1 MotA/TolQ/ExbB proton channel [Fibrobacteria bacterium] | diamond | 258 | 163 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 3475306 | 3475306 | PRJNA944406_P_NODE_44383_length_268_cov_1.620513_g43424_i0 | PRJNA944406 | 44383 | 268 | 1.620513 | 4.34297484 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 163 | 9.55e-49 | NR | MCD6024029.1 | 2725311 | g43424 | i0 | 84.1 | 0.985074626865672 | 88 | 14 | 98.5 | 0 | 266 | 3 | 6 | 93 | MCD6024029.1 Redoxin domain protein [Fibrobacteria bacterium] | diamond | 264 | 163 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 27183194 | 27183194 | PRJNA944406_P_NODE_42222_length_270_cov_1.954315_g41263_i0 | PRJNA944406 | 42222 | 270 | 1.954315 | 5.2766505 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 71.2 | 2.62e-12 | NR | MCD6023125.1 | 2725311 | g41263 | i0 | 40.9 | 1.03333333333333 | 93 | 49 | 96.7 | 2 | 269 | 9 | 83 | 175 | MCD6023125.1 hypothetical protein [Fibrobacteria bacterium] | diamond | 279 | 71.2 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 27689139 | 27689139 | PRJNA944406_P_NODE_34444_length_278_cov_1.185366_g33485_i0 | PRJNA944406 | 34444 | 278 | 1.185366 | 3.29531748 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 143 | 8.09e-40 | NR | MCD6024679.1 | 2725311 | g33485 | i0 | 84.1 | 0.884892086330935 | 82 | 13 | 88.5 | 0 | 33 | 278 | 61 | 142 | MCD6024679.1 scpB [Fibrobacteria bacterium] | diamond | 246 | 143 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 27815280 | 27815280 | PRJNA944406_P_NODE_59984_length_254_cov_1.303867_g59025_i0 | PRJNA944406 | 59984 | 254 | 1.303867 | 3.31182218 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 156 | 3.15e-42 | NR | MEO6094526.1 | 2725311 | g59025 | i0 | 92.9 | 0.992125984251969 | 84 | 6 | 99.2 | 0 | 254 | 3 | 644 | 727 | MEO6094526.1 response regulator [Fibrobacteria bacterium] | diamond | 252 | 156 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 30183313 | 30183313 | PRJNA944406_P_NODE_78712_length_248_cov_0.880000_g77753_i0 | PRJNA944406 | 78712 | 248 | 0.88 | 2.1824 | Fibrobacterota bacterium | 2052160 | Bacteria | Bacteria | 124 | 3.4299999999999996e-31 | NR | MEK7392898.1 | 2052160 | g77753 | i0 | 70 | 3.91935483870968 | 80 | 24 | 96.8 | 0 | 8 | 247 | 166 | 245 | MEK7392898.1 class I adenylate-forming enzyme family protein [Fibrobacterota bacterium] | diamond | 972 | 124 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacterota bacterium | |||||
| 31162472 | 31162472 | PRJNA944406_P_NODE_22215_length_289_cov_2.314815_g21256_i0 | PRJNA944406 | 22215 | 289 | 2.314815 | 6.68981535 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 109 | 1.94e-25 | NR | HQF56504.1 | 2725311 | g21256 | i0 | 98 | 0.519031141868512 | 50 | 1 | 51.9 | 0 | 1 | 150 | 643 | 692 | HQF56504.1 ATP-dependent RNA helicase HrpA [Fibrobacteria bacterium] | diamond | 150 | 109 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 31574072 | 31574072 | PRJNA944406_P_NODE_49836_length_263_cov_1.621053_g48877_i0 | PRJNA944406 | 49836 | 263 | 1.621053 | 4.26336939 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 145 | 3.52e-42 | NR | HEX2613169.1 | 2725311 | g48877 | i0 | 77 | 1.98479087452471 | 87 | 20 | 99.2 | 0 | 262 | 2 | 38 | 124 | HEX2613169.1 elongation factor P [Fibrobacteria bacterium] | diamond | 522 | 145 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 32333553 | 32333553 | PRJNA944406_P_NODE_93699_length_244_cov_1.467836_g92740_i0 | PRJNA944406 | 93699 | 244 | 1.467836 | 3.58151984 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 132 | 2.5e-34 | NR | MCD6024489.1 | 2725311 | g92740 | i0 | 84.1 | 1.00819672131148 | 82 | 12 | 99.6 | 1 | 1 | 243 | 71 | 152 | MCD6024489.1 microcin-processing peptidase 2 [Fibrobacteria bacterium] | diamond | 246 | 132 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria bacterium | ||||
| 32554996 | 32554996 | PRJNA944406_P_NODE_28959_length_283_cov_1.309524_g28000_i0 | PRJNA944406 | 28959 | 283 | 1.309524 | 3.70595292 | Fibrobacteria bacterium | 2725311 | Bacteria | Bacteria | 173 | 2.9499999999999995e-48 | NR | MEO6096566.1 | 2725311 | g28000 | i0 | 80.6 | 0.985865724381625 | 93 | 18 | 98.6 | 0 | 3 | 281 | 557 | 649 | MEO6096566.1 bi-domain-containing oxidoreductase [Fibrobacteria bacterium] | diamond | 279 | 173 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacteria 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);;