contig_metadata
14 rows where bioproject = "PRJNA797475", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4609635 | 4609635 | PRJNA797475_P_NODE_1384_length_813_cov_2.054054_g1299_i0 | PRJNA797475 | 1384 | 813 | 2.054054 | 16.69945902 | PVC group | 1783257 | Bacteria | Bacteria | 354 | 2.01e-116 | NR | MEM7115540.1 | 2026724 | g1299 | i0 | 71.6 | 28.6678966789668 | 236 | 67 | 87.1 | 0 | 1 | 708 | 178 | 413 | MEM7115540.1 phosphoenolpyruvate carboxykinase (ATP) [Chloroflexota bacterium] | diamond | 23307 | 357 | 0.991596638655462 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 7159818 | 7159818 | PRJNA797475_P_NODE_25546_length_246_cov_1.780347_g25447_i0 | PRJNA797475 | 25546 | 246 | 1.780347 | 4.37965362 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 96.3 | 5.550000000000001e-21 | NR | MEE4194247.1 | 2052143 | g25447 | i0 | 54.3 | 2.95121951219512 | 81 | 37 | 98.8 | 0 | 3 | 245 | 648 | 728 | MEE4194247.1 ATP-binding protein [Anaerolineae bacterium] | diamond | 726 | 96.3 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 9709586 | 9709586 | PRJNA797475_P_NODE_17108_length_272_cov_2.201005_g17009_i0 | PRJNA797475 | 17108 | 272 | 2.201005 | 5.9867336 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 436 | 5.9e-118 | NTclustered | gi|2874254133|emb|OY970218.1| | 1672391 | g17009 | i0 | 95.604 | 386.117647058824 | 273 | 10 | 100 | 2 | 1 | 272 | 18208 | 17937 | MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1 | blastn | 105024 | 436 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 18632905 | 18632905 | PRJNA797475_P_NODE_22535_length_250_cov_0.870056_g22436_i0 | PRJNA797475 | 22535 | 250 | 0.870056 | 2.17514 | Ktedonosporobacter rubrisoli | 2509675 | Bacteria | Bacteria | 52.8 | 0.023 | NTclustered | gi|1574824432|gb|CP035758.1| | 2509675 | g22436 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 48 | 75 | 1935237 | 1935264 | Ktedonosporobacter rubrisoli strain SCAWS-G2 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonosporobacteraceae | Ktedonosporobacter | Ktedonosporobacter rubrisoli | ||
| 27085578 | 27085578 | PRJNA797475_P_NODE_30402_length_241_cov_0.916667_g30303_i0 | PRJNA797475 | 30402 | 241 | 0.916667 | 2.20916747 | Aggregatilineales bacterium | 2952883 | Bacteria | Bacteria | 105 | 9.37e-26 | NR | MEQ8672017.1 | 2952883 | g30303 | i0 | 75.9 | 2.91286307053942 | 79 | 17 | 98.3 | 1 | 239 | 3 | 152 | 228 | MEQ8672017.1 SDR family oxidoreductase [Aggregatilineales bacterium] | diamond | 702 | 105 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Aggregatilineales | Aggregatilineales bacterium | ||||
| 27717709 | 27717709 | PRJNA797475_P_NODE_11964_length_308_cov_1.310638_g11865_i0 | PRJNA797475 | 11964 | 308 | 1.310638 | 4.03676504 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 129 | 7e-33 | NR | HKZ69802.1 | 2073117 | g11865 | i0 | 65.6 | 3.49675324675325 | 90 | 31 | 87.7 | 0 | 270 | 1 | 4 | 93 | HKZ69802.1 aspartate aminotransferase family protein [Anaerolineales bacterium] | diamond | 1077 | 129 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28673688 | 28673688 | PRJNA797475_P_NODE_26607_length_245_cov_0.895349_g26508_i0 | PRJNA797475 | 26607 | 245 | 0.895349 | 2.19360505 | Bacillati | 1783272 | Bacteria | Bacteria | 92 | 1.01e-19 | NR | MEZ4553328.1 | 2026734 | g26508 | i0 | 53.8 | 4.9469387755102 | 80 | 37 | 98 | 0 | 2 | 241 | 218 | 297 | MEZ4553328.1 NAD(P)/FAD-dependent oxidoreductase [Dehalococcoidia bacterium] | diamond | 1212 | 92.8 | 0.991379310344828 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 28727707 | 28727707 | PRJNA797475_P_NODE_25447_length_247_cov_0.885057_g25348_i0 | PRJNA797475 | 25447 | 247 | 0.885057 | 2.18609079 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 64.3 | 8.2e-10 | NR | HFC08517.1 | 2026724 | g25348 | i0 | 36 | 0.910931174089069 | 75 | 47 | 91.1 | 1 | 19 | 243 | 136 | 209 | HFC08517.1 CPBP family intramembrane metalloprotease [Chloroflexota bacterium] | diamond | 225 | 64.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29642989 | 29642989 | PRJNA797475_P_NODE_24510_length_248_cov_0.880000_g24411_i0 | PRJNA797475 | 24510 | 248 | 0.88 | 2.1824 | Thermoflexia bacterium | 2420334 | Bacteria | Bacteria | 42.4 | 0.049 | NR | HEY89140.1 | 2420334 | g24411 | i0 | 65.2 | 0.278225806451613 | 23 | 8 | 27.8 | 0 | 243 | 175 | 231 | 253 | HEY89140.1 glycerophosphodiester phosphodiesterase [Thermoflexia bacterium] | diamond | 69 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Thermoflexia | Thermoflexia bacterium | |||||
| 29905193 | 29905193 | PRJNA797475_P_NODE_14151_length_288_cov_1.432558_g14052_i0 | PRJNA797475 | 14151 | 288 | 1.432558 | 4.12576704 | Bacteria | 2 | Bacteria | Bacteria | 129 | 6.73e-34 | NR | MBU6362349.1 | 2026724 | g14052 | i0 | 65.3 | 9.625 | 95 | 32 | 97.9 | 1 | 5 | 286 | 92 | 186 | MBU6362349.1 aspartate carbamoyltransferase [Chloroflexota bacterium] | diamond | 2772 | 129 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30180190 | 30180190 | PRJNA797475_P_NODE_28432_length_243_cov_0.905882_g28333_i0 | PRJNA797475 | 28432 | 243 | 0.905882 | 2.20129326 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 57.8 | 1.96e-7 | NR | MCE9646321.1 | 2026724 | g28333 | i0 | 38.1 | 2.09876543209877 | 84 | 49 | 100 | 1 | 1 | 243 | 479 | 562 | MCE9646321.1 AAA family ATPase [Chloroflexota bacterium] | diamond | 510 | 57.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30370303 | 30370303 | PRJNA797475_P_NODE_24772_length_247_cov_1.373563_g24673_i0 | PRJNA797475 | 24772 | 247 | 1.373563 | 3.39270061 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 62.8 | 3.01e-10 | NR | HET7495827.1 | 2952938 | g24673 | i0 | 42.7 | 3.63157894736842 | 75 | 43 | 91.1 | 0 | 227 | 3 | 15 | 89 | HET7495827.1 DUF4332 domain-containing protein [Candidatus Limnocylindrales bacterium] | diamond | 897 | 62.8 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 31801189 | 31801189 | PRJNA797475_P_NODE_28297_length_243_cov_0.905882_g28198_i0 | PRJNA797475 | 28297 | 243 | 0.905882 | 2.20129326 | Bacteria | 2 | Bacteria | Bacteria | 86.3 | 6.61e-19 | NR | NWG08414.1 | 2026724 | g28198 | i0 | 52.5 | 1.97530864197531 | 80 | 38 | 98.8 | 0 | 243 | 4 | 61 | 140 | NWG08414.1 class I SAM-dependent methyltransferase [Chloroflexota bacterium] | diamond | 480 | 86.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32298890 | 32298890 | PRJNA797475_P_NODE_8039_length_363_cov_1.017241_g7940_i0 | PRJNA797475 | 8039 | 363 | 1.017241 | 3.69258483 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 63.5 | 7.45e-9 | NR | MFN8557611.1 | 2026734 | g7940 | i0 | 41.1 | 0.785123966942149 | 95 | 54 | 78.5 | 1 | 296 | 12 | 44 | 136 | MFN8557611.1 VWA domain-containing protein [Dehalococcoidia bacterium] | diamond | 285 | 63.5 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia 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);;