contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1215813" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27546650 | 27546650 | PRJNA1215813_P_NODE_1444_length_615_cov_1.763838_g1367_i0 | PRJNA1215813 | 1444 | 615 | 1.763838 | 10.8476037 | Ktedonobacteraceae bacterium | 2740538 | Bacteria | Bacteria | 52.8 | 2.79e-4 | NR | MBA2677386.1 | 2740538 | g1367 | i0 | 26.6 | 1.56585365853659 | 169 | 111 | 80.5 | 5 | 614 | 120 | 196 | 355 | MBA2677386.1 FAD-dependent monooxygenase [Ktedonobacteraceae bacterium] | diamond | 963 | 52.8 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacteraceae bacterium | |||
| 27818225 | 27818225 | PRJNA1215813_P_NODE_12344_length_242_cov_1.781065_g12264_i0 | PRJNA1215813 | 12344 | 242 | 1.781065 | 4.3101773 | Bacteria | 2 | Bacteria | Bacteria | 121 | 7.61e-30 | NR | MCI0393528.1 | 2026724 | g12264 | i0 | 67.5 | 3.96694214876033 | 80 | 26 | 99.2 | 0 | 240 | 1 | 287 | 366 | MCI0393528.1 lamin tail domain-containing protein [Chloroflexota bacterium] | diamond | 960 | 122 | 0.991803278688525 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27830763 | 27830763 | PRJNA1215813_P_NODE_3324_length_417_cov_1.133721_g3244_i0 | PRJNA1215813 | 3324 | 417 | 1.133721 | 4.72761657 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 127 | 1.6899999999999998e-32 | NR | MBI2872824.1 | 2026724 | g3244 | i0 | 48.2 | 1.97122302158273 | 137 | 70 | 97.8 | 1 | 5 | 412 | 156 | 292 | MBI2872824.1 multicopper oxidase domain-containing protein [Chloroflexota bacterium] | diamond | 822 | 127 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27925548 | 27925548 | PRJNA1215813_P_NODE_7345_length_289_cov_1.444444_g7265_i0 | PRJNA1215813 | 7345 | 289 | 1.444444 | 4.17444316 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 124 | 2.0899999999999996e-31 | NR | MBN1811782.1 | 2052143 | g7265 | i0 | 60.2 | 1.85813148788927 | 88 | 35 | 91.3 | 0 | 6 | 269 | 312 | 399 | MBN1811782.1 pyridoxal phosphate-dependent aminotransferase [Anaerolineae bacterium] | diamond | 537 | 124 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28241069 | 28241069 | PRJNA1215813_P_NODE_3406_length_411_cov_2.994083_g3326_i0 | PRJNA1215813 | 3406 | 411 | 2.994083 | 12.30568113 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 65.9 | 2.12e-9 | NR | HET7077369.1 | 2448782 | g3326 | i0 | 42.4 | 2.67883211678832 | 92 | 48 | 64.2 | 3 | 52 | 315 | 1232 | 1322 | HET7077369.1 choice-of-anchor A family protein [Chloroflexia bacterium] | diamond | 1101 | 65.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 28967633 | 28967633 | PRJNA1215813_P_NODE_3208_length_424_cov_1.170940_g3128_i0 | PRJNA1215813 | 3208 | 424 | 1.17094 | 4.9647856 | Candidatus Flexifilum breve | 3140694 | Bacteria | Bacteria | 65.1 | 4.4e-9 | NR | WP_343422072.1 | 3140694 | g3128 | i0 | 33.1 | 1.86792452830189 | 142 | 93 | 99.1 | 1 | 3 | 422 | 1299 | 1440 | WP_343422072.1 protein kinase domain-containing protein [Candidatus Flexifilum breve] | diamond | 792 | 65.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Aggregatilineales | Candidatus Flexifilaceae | Candidatus Flexifilum | Candidatus Flexifilum breve | ||
| 30217804 | 30217804 | PRJNA1215813_P_NODE_4132_length_376_cov_0.897690_g4052_i0 | PRJNA1215813 | 4132 | 376 | 0.89769 | 3.3753144 | Bacteria | 2 | Bacteria | Bacteria | 144 | 9.3e-40 | NR | MDB5079400.1 | 2026724 | g4052 | i0 | 57.1 | 2.89627659574468 | 119 | 51 | 94.9 | 0 | 364 | 8 | 162 | 280 | MDB5079400.1 hypothetical protein [Chloroflexota bacterium] | diamond | 1089 | 145 | 0.993103448275862 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30483487 | 30483487 | PRJNA1215813_P_NODE_3753_length_393_cov_1.725000_g3673_i0 | PRJNA1215813 | 3753 | 393 | 1.725 | 6.77925 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 174 | 1.18e-49 | NR | MBI4322620.1 | 2026724 | g3673 | i0 | 61.1 | 3.03053435114504 | 131 | 51 | 100 | 0 | 393 | 1 | 142 | 272 | MBI4322620.1 aspartate aminotransferase family protein [Chloroflexota bacterium] | diamond | 1191 | 174 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31052432 | 31052432 | PRJNA1215813_P_NODE_1715_length_568_cov_2.935354_g1637_i0 | PRJNA1215813 | 1715 | 568 | 2.935354 | 16.67281072 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 87 | 4.53e-16 | NR | MCG3209027.1 | 2052143 | g1637 | i0 | 39.3 | 0.644366197183099 | 122 | 67 | 61.3 | 4 | 524 | 177 | 1249 | 1369 | MCG3209027.1 hypothetical protein [Anaerolineae bacterium] | diamond | 366 | 87 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31336521 | 31336521 | PRJNA1215813_P_NODE_5176_length_339_cov_1.172932_g5096_i0 | PRJNA1215813 | 5176 | 339 | 1.172932 | 3.97623948 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 58.9 | 2.51e-8 | NR | MBI4185944.1 | 2026724 | g5096 | i0 | 47.8 | 1.63716814159292 | 69 | 34 | 59.3 | 1 | 206 | 6 | 26 | 94 | MBI4185944.1 SRPBCC domain-containing protein [Chloroflexota bacterium] | diamond | 555 | 58.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31779317 | 31779317 | PRJNA1215813_P_NODE_11857_length_244_cov_0.912281_g11777_i0 | PRJNA1215813 | 11857 | 244 | 0.912281 | 2.22596564 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 45.8 | 0.00318 | NR | MAO89332.1 | 2026734 | g11777 | i0 | 29.1 | 1.79508196721311 | 79 | 53 | 97.1 | 1 | 237 | 1 | 401 | 476 | MAO89332.1 hypothetical protein [Dehalococcoidia bacterium] | diamond | 438 | 45.8 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 32032613 | 32032613 | PRJNA1215813_P_NODE_9258_length_253_cov_1.300000_g9178_i0 | PRJNA1215813 | 9258 | 253 | 1.3 | 3.289 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 49.7 | 1.51e-4 | NR | MDQ4078497.1 | 2026724 | g9178 | i0 | 38.1 | 1.99209486166008 | 84 | 48 | 96 | 2 | 8 | 250 | 137 | 219 | MDQ4078497.1 CHRD domain-containing protein [Chloroflexota bacterium] | diamond | 504 | 49.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32872471 | 32872471 | PRJNA1215813_P_NODE_12700_length_228_cov_2.012903_g12620_i0 | PRJNA1215813 | 12700 | 228 | 2.012903 | 4.5894188400000004 | root | 1 | Root_unresolved | Root_unresolved | 72.4 | 1.1e-12 | NR | KPL24759.1 | 1703388 | g12620 | i0 | 50 | 4.89473684210526 | 76 | 38 | 100 | 0 | 1 | 228 | 279 | 354 | KPL24759.1 MAG: ATP citrate synthase [Anaerolineae bacterium SM23_84] | diamond | 1116 | 72.8 | 0.994505494505495 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium SM23_84 |
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);;