contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA758088" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13490903 | 13490903 | PRJNA758088_P_NODE_303891_length_248_cov_1.314286_g296920_i0 | PRJNA758088 | 303891 | 248 | 1.314286 | 3.25942928 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 77.8 | 2.75e-16 | NR | CAA9234008.1 | 1672391 | g296920 | i0 | 50 | 0.991935483870968 | 82 | 41 | 99.2 | 0 | 3 | 248 | 13 | 94 | CAA9234008.1 MAG: hypothetical protein AVDCRST_MAG93-1013 [uncultured Chloroflexia bacterium] | diamond | 246 | 77.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 26641425 | 26641425 | PRJNA758088_P_NODE_307481_length_248_cov_0.880000_g300510_i0 | PRJNA758088 | 307481 | 248 | 0.88 | 2.1824 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 43.1 | 0.0279 | NR | MDQ3808761.1 | 2026724 | g300510 | i0 | 32.2 | 1.05241935483871 | 87 | 52 | 98 | 4 | 5 | 247 | 227 | 312 | MDQ3808761.1 MFS transporter [Chloroflexota bacterium] | diamond | 261 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26768144 | 26768144 | PRJNA758088_P_NODE_324101_length_246_cov_0.890173_g317130_i0 | PRJNA758088 | 324101 | 246 | 0.890173 | 2.18982558 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 90.5 | 1.9e-20 | NR | RLC88692.1 | 2026724 | g317130 | i0 | 47.5 | 3.90243902439024 | 80 | 42 | 97.6 | 0 | 2 | 241 | 42 | 121 | RLC88692.1 MAG: hypothetical protein DRJ03_02110 [Chloroflexota bacterium] | diamond | 960 | 90.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27189058 | 27189058 | PRJNA758088_P_NODE_355402_length_242_cov_0.911243_g348431_i0 | PRJNA758088 | 355402 | 242 | 0.911243 | 2.20520806 | Bacteria | 2 | Bacteria | Bacteria | 101 | 4.449999999999999e-23 | NR | MEL7626971.1 | 2024896 | g348431 | i0 | 67.1 | 2.92561983471074 | 76 | 25 | 94.2 | 0 | 3 | 230 | 60 | 135 | MEL7626971.1 PBSX family phage terminase large subunit [Anaerolineaceae bacterium] | diamond | 708 | 102 | 0.990196078431373 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 28032244 | 28032244 | PRJNA758088_P_NODE_284625_length_251_cov_0.865169_g277654_i0 | PRJNA758088 | 284625 | 251 | 0.865169 | 2.17157419 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 66.6 | 1.44e-10 | NR | MFA5872768.1 | 2073117 | g277654 | i0 | 38.6 | 4.94820717131474 | 83 | 50 | 99.2 | 1 | 250 | 2 | 44 | 125 | MFA5872768.1 UDP-N-acetylglucosamine 2-epimerase [Anaerolineales bacterium] | diamond | 1242 | 66.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28126949 | 28126949 | PRJNA758088_P_NODE_295045_length_249_cov_1.732955_g288074_i0 | PRJNA758088 | 295045 | 249 | 1.732955 | 4.31505795 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 46.6 | 0.00163 | NR | MCJ7677324.1 | 2073117 | g288074 | i0 | 36.4 | 0.795180722891566 | 66 | 34 | 69.9 | 2 | 209 | 36 | 143 | 208 | MCJ7677324.1 flippase-like domain-containing protein [Anaerolineales bacterium] | diamond | 198 | 46.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28189775 | 28189775 | PRJNA758088_P_NODE_358046_length_242_cov_0.911243_g351075_i0 | PRJNA758088 | 358046 | 242 | 0.911243 | 2.20520806 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 86.3 | 3.3e-18 | NR | MBM4425290.1 | 2026724 | g351075 | i0 | 71.7 | 2.90082644628099 | 46 | 13 | 57 | 0 | 143 | 6 | 3 | 48 | MBM4425290.1 site-specific DNA-methyltransferase [Chloroflexota bacterium] | diamond | 702 | 86.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28632252 | 28632252 | PRJNA758088_P_NODE_285767_length_251_cov_0.865169_g278796_i0 | PRJNA758088 | 285767 | 251 | 0.865169 | 2.17157419 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 42.7 | 0.0396 | NR | MFN8484828.1 | 2052143 | g278796 | i0 | 35.3 | 0.812749003984064 | 68 | 35 | 75.3 | 3 | 249 | 61 | 145 | 208 | MFN8484828.1 glycosyltransferase [Anaerolineae bacterium] | diamond | 204 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28915946 | 28915946 | PRJNA758088_P_NODE_284528_length_251_cov_0.865169_g277557_i0 | PRJNA758088 | 284528 | 251 | 0.865169 | 2.17157419 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 120 | 1.87e-29 | NR | MEP7158197.1 | 2026724 | g277557 | i0 | 75.9 | 0.99203187250996006 | 83 | 20 | 99.2 | 0 | 251 | 3 | 100 | 182 | MEP7158197.1 DUF11 domain-containing protein [Chloroflexota bacterium] | diamond | 249 | 120 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29042669 | 29042669 | PRJNA758088_P_NODE_315328_length_247_cov_0.885057_g308357_i0 | PRJNA758088 | 315328 | 247 | 0.885057 | 2.18609079 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42.4 | 0.0495 | NR | TMC19485.1 | 2026724 | g308357 | i0 | 40 | 0.607287449392713 | 50 | 26 | 60.7 | 1 | 68 | 217 | 219 | 264 | TMC19485.1 MAG: hypothetical protein E6J34_15275 [Chloroflexota bacterium] | diamond | 150 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29736900 | 29736900 | PRJNA758088_P_NODE_312590_length_247_cov_0.885057_g305619_i0 | PRJNA758088 | 312590 | 247 | 0.885057 | 2.18609079 | Kouleothrix aurantiaca | 186479 | Bacteria | Bacteria | 57.4 | 7.13e-8 | NR | KPV52449.1 | 186479 | g305619 | i0 | 39.2 | 0.959514170040486 | 79 | 48 | 96 | 0 | 2 | 238 | 41 | 119 | KPV52449.1 hypothetical protein SE17_15440 [Kouleothrix aurantiaca] | diamond | 237 | 57.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Kouleothrix | Kouleothrix aurantiaca | ||
| 29926766 | 29926766 | PRJNA758088_P_NODE_324191_length_246_cov_0.890173_g317220_i0 | PRJNA758088 | 324191 | 246 | 0.890173 | 2.18982558 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 48.1 | 3.94e-4 | NR | MBV6393836.1 | 2073117 | g317220 | i0 | 46.9 | 0.597560975609756 | 49 | 23 | 59.8 | 1 | 243 | 97 | 80 | 125 | MBV6393836.1 hypothetical protein [Anaerolineales bacterium] | diamond | 147 | 48.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 30369420 | 30369420 | PRJNA758088_P_NODE_366792_length_241_cov_0.916667_g359821_i0 | PRJNA758088 | 366792 | 241 | 0.916667 | 2.20916747 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 152 | 1.8699999999999998e-42 | NR | RLT21584.1 | 2026724 | g359821 | i0 | 98.8 | 0.995850622406639 | 80 | 1 | 99.6 | 0 | 241 | 2 | 139 | 218 | RLT21584.1 MAG: 3-phosphoshikimate 1-carboxyvinyltransferase [Chloroflexota bacterium] | diamond | 240 | 152 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31032723 | 31032723 | PRJNA758088_P_NODE_312595_length_247_cov_0.885057_g305624_i0 | PRJNA758088 | 312595 | 247 | 0.885057 | 2.18609079 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 78.2 | 1.31e-14 | NR | RJQ07450.1 | 2026734 | g305624 | i0 | 62.1 | 0.704453441295547 | 58 | 22 | 70.4 | 0 | 178 | 5 | 15 | 72 | RJQ07450.1 MAG: type I DNA topoisomerase, partial [Dehalococcoidia bacterium] | diamond | 174 | 78.2 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 31664731 | 31664731 | PRJNA758088_P_NODE_349777_length_243_cov_0.905882_g342806_i0 | PRJNA758088 | 349777 | 243 | 0.905882 | 2.20129326 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 140 | 3.25e-39 | NR | NJM41390.1 | 2052143 | g342806 | i0 | 82.5 | 0.987654320987654 | 80 | 14 | 98.8 | 0 | 241 | 2 | 24 | 103 | NJM41390.1 phytanoyl-CoA dioxygenase family protein [Anaerolineae bacterium] | diamond | 240 | 140 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 32202723 | 32202723 | PRJNA758088_P_NODE_293998_length_250_cov_0.870056_g287027_i0 | PRJNA758088 | 293998 | 250 | 0.870056 | 2.17514 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 135 | 9.779999999999996e-35 | NR | HEX5943821.1 | 2073117 | g287027 | i0 | 80.5 | 0.984 | 82 | 16 | 98.4 | 0 | 248 | 3 | 863 | 944 | HEX5943821.1 AAA family ATPase [Anaerolineales bacterium] | diamond | 246 | 135 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32275989 | 32275989 | PRJNA758088_P_NODE_342318_length_244_cov_0.900585_g335347_i0 | PRJNA758088 | 342318 | 244 | 0.900585 | 2.1974274 | Bacillati | 1783272 | Bacteria | Bacteria | 136 | 2.6499999999999996e-37 | NR | MEX2184102.1 | 2026724 | g335347 | i0 | 90.1 | 3.98360655737705 | 81 | 8 | 99.6 | 0 | 243 | 1 | 168 | 248 | MEX2184102.1 bifunctional 5,10-methylenetetrahydrofolate dehydrogenase/5,10-methenyltetrahydrofolate cyclohydrolase [Chloroflexota bacterium] | diamond | 972 | 136 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota 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);;