contig_metadata
14 rows where bioproject = "PRJNA724011" and tax_phylum = "Fidelibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17288835 | 17288835 | PRJNA724011_P_NODE_71434_length_297_cov_1.133929_g70411_i0 | PRJNA724011 | 71434 | 297 | 1.133929 | 3.36776913 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 127 | 7.879999999999999e-32 | NR | MED5474657.1 | 2026760 | g70411 | i0 | 60.8 | 3.91919191919192 | 97 | 38 | 98 | 0 | 7 | 297 | 177 | 273 | MED5474657.1 M14 family zinc carboxypeptidase [Fidelibacterota bacterium] | diamond | 1164 | 127 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 27946984 | 27946984 | PRJNA724011_P_NODE_37505_length_440_cov_1.046322_g36482_i0 | PRJNA724011 | 37505 | 440 | 1.046322 | 4.6038168 | FCB group | 1783270 | Bacteria | Bacteria | 55.8 | 1.48e-6 | NR | MBT3518510.1 | 2026760 | g36482 | i0 | 30.3 | 2.72045454545455 | 119 | 75 | 80.5 | 3 | 82 | 435 | 2 | 113 | MBT3518510.1 GAF domain-containing protein [Fidelibacterota bacterium] | diamond | 1197 | 56.2 | 0.99288256227758 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28378627 | 28378627 | PRJNA724011_P_NODE_89306_length_259_cov_1.241935_g88283_i0 | PRJNA724011 | 89306 | 259 | 1.241935 | 3.21661165 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 131 | 3.18e-36 | NR | MCJ7801096.1 | 2026760 | g88283 | i0 | 75.9 | 1.86486486486486 | 79 | 19 | 91.5 | 0 | 254 | 18 | 124 | 202 | MCJ7801096.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 483 | 131 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29546737 | 29546737 | PRJNA724011_P_NODE_9890_length_1003_cov_2.263441_g9090_i0 | PRJNA724011 | 9890 | 1003 | 2.263441 | 22.70231323 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 248 | 2.39e-77 | NR | MCJ7802071.1 | 2026760 | g9090 | i0 | 49.8 | 0.708873379860419 | 237 | 117 | 70.3 | 2 | 1001 | 297 | 35 | 271 | MCJ7802071.1 lipase family protein [Fidelibacterota bacterium] | diamond | 711 | 248 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29578154 | 29578154 | PRJNA724011_P_NODE_2950_length_1740_cov_3.230954_g2582_i0 | PRJNA724011 | 2950 | 1740 | 3.230954 | 56.2185996 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 164 | 7.33e-39 | NR | MED5474963.1 | 2026760 | g2582 | i0 | 26 | 1.80172413793103 | 511 | 303 | 87.6 | 17 | 1681 | 158 | 15 | 453 | MED5474963.1 aminopeptidase N [Fidelibacterota bacterium] | diamond | 3135 | 164 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30020669 | 30020669 | PRJNA724011_P_NODE_107271_length_242_cov_2.112426_g106248_i0 | PRJNA724011 | 107271 | 242 | 2.112426 | 5.11207092 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 45.8 | 0.00281 | NR | MAV58816.1 | 2026760 | g106248 | i0 | 56.8 | 0.545454545454545 | 44 | 14 | 54.5 | 1 | 133 | 2 | 2 | 40 | MAV58816.1 methionyl-tRNA formyltransferase [Fidelibacterota bacterium] | diamond | 132 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31031861 | 31031861 | PRJNA724011_P_NODE_50335_length_365_cov_1.565068_g49312_i0 | PRJNA724011 | 50335 | 365 | 1.565068 | 5.7124982 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 45.4 | 0.0139 | NR | MEL1223175.1 | 2026760 | g49312 | i0 | 43.1 | 0.953424657534247 | 51 | 29 | 41.9 | 0 | 336 | 184 | 135 | 185 | MEL1223175.1 diacylglycerol kinase family protein [Fidelibacterota bacterium] | diamond | 348 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31105051 | 31105051 | PRJNA724011_P_NODE_39255_length_427_cov_1.305085_g38232_i0 | PRJNA724011 | 39255 | 427 | 1.305085 | 5.57271295 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 46.6 | 0.0111 | NR | MCD6205441.1 | 2026760 | g38232 | i0 | 30.3 | 1.00468384074941 | 76 | 33 | 51.3 | 3 | 425 | 207 | 604 | 662 | MCD6205441.1 glycoside hydrolase family 97 protein [Fidelibacterota bacterium] | diamond | 429 | 46.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31569408 | 31569408 | PRJNA724011_P_NODE_5796_length_1305_cov_5.957792_g5224_i0 | PRJNA724011 | 5796 | 1305 | 5.957792 | 77.7491856 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 319 | 4.09e-97 | NR | MBC8197595.1 | 2026760 | g5224 | i0 | 39.3 | 3.8735632183908 | 433 | 241 | 95.6 | 9 | 1279 | 32 | 1 | 428 | MBC8197595.1 trypsin-like peptidase domain-containing protein [Fidelibacterota bacterium] | diamond | 5055 | 319 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31895804 | 31895804 | PRJNA724011_P_NODE_28277_length_524_cov_4.359202_g27260_i0 | PRJNA724011 | 28277 | 524 | 4.359202 | 22.84221848 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 55.1 | 1.39e-5 | NR | PJA51979.1 | 1975523 | g27260 | i0 | 48.6 | 1.21946564885496 | 74 | 36 | 42.4 | 2 | 1 | 222 | 135 | 206 | PJA51979.1 MAG: oxidoreductase [Fidelibacterota bacterium CG_4_9_14_3_um_filter_48_9] | diamond | 639 | 55.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium CG_4_9_14_3_um_filter_48_9 | |||||
| 32043604 | 32043604 | PRJNA724011_P_NODE_24458_length_575_cov_1.286853_g23442_i0 | PRJNA724011 | 24458 | 575 | 1.286853 | 7.39940475 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 147 | 7.08e-40 | NR | MCJ7802071.1 | 2026760 | g23442 | i0 | 47.7 | 0.798260869565217 | 153 | 78 | 78.8 | 2 | 4 | 456 | 117 | 269 | MCJ7802071.1 lipase family protein [Fidelibacterota bacterium] | diamond | 459 | 147 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32201842 | 32201842 | PRJNA724011_P_NODE_12118_length_892_cov_2.415140_g11235_i0 | PRJNA724011 | 12118 | 892 | 2.41514 | 21.5430488 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 50.1 | 0.00139 | NR | MEC7902415.1 | 2026760 | g11235 | i0 | 26.9 | 1.3957399103139 | 119 | 80 | 40 | 3 | 602 | 246 | 28 | 139 | MEC7902415.1 GAF domain-containing protein [Fidelibacterota bacterium] | diamond | 1245 | 50.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32423378 | 32423378 | PRJNA724011_P_NODE_6139_length_1270_cov_1.697577_g5539_i0 | PRJNA724011 | 6139 | 1270 | 1.697577 | 21.5592279 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 94.4 | 1.59e-16 | NR | MDC0235026.1 | 2026760 | g5539 | i0 | 26.6 | 1.77874015748031 | 376 | 248 | 87.6 | 12 | 1268 | 156 | 76 | 428 | MDC0235026.1 Ig-like domain-containing protein [Fidelibacterota bacterium] | diamond | 2259 | 94.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32623233 | 32623233 | PRJNA724011_P_NODE_92460_length_253_cov_1.283333_g91437_i0 | PRJNA724011 | 92460 | 253 | 1.283333 | 3.24683249 | Bacteria | 2 | Bacteria | Bacteria | 111 | 1.15e-26 | NR | MCH7498020.1 | 2026760 | g91437 | i0 | 61.9 | 4.05533596837945 | 84 | 31 | 99.6 | 1 | 252 | 1 | 38 | 120 | MCH7498020.1 glutamate--tRNA ligase [Fidelibacterota bacterium] | diamond | 1026 | 112 | 0.991071428571429 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota 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);;