contig_metadata
8 rows where bioproject = "PRJNA675331", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27410026 | 27410026 | PRJNA675331_P_NODE_7203_length_362_cov_1.065744_g7031_i0 | PRJNA675331 | 7203 | 362 | 1.065744 | 3.85799328 | Bacteria | 2 | Bacteria | Bacteria | 134 | 1.07e-36 | NR | MCY4063112.1 | 2026724 | g7031 | i0 | 53.7 | 6.01657458563536 | 121 | 53 | 99.4 | 2 | 2 | 361 | 76 | 194 | MCY4063112.1 glutamine synthetase [Chloroflexota bacterium] | diamond | 2178 | 134 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27694249 | 27694249 | PRJNA675331_P_NODE_18184_length_251_cov_0.865169_g18012_i0 | PRJNA675331 | 18184 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 138 | 6.69e-37 | NR | NOX61252.1 | 2026724 | g18012 | i0 | 71.3 | 3.82470119521912 | 80 | 23 | 95.6 | 0 | 250 | 11 | 332 | 411 | NOX61252.1 fumarylacetoacetase [Chloroflexota bacterium] | diamond | 960 | 139 | 0.992805755395683 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29166348 | 29166348 | PRJNA675331_P_NODE_19709_length_248_cov_1.108571_g19537_i0 | PRJNA675331 | 19709 | 248 | 1.108571 | 2.74925608 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 56.2 | 7.09e-7 | NR | HEU4918094.1 | 2952938 | g19537 | i0 | 42.9 | 3.15725806451613 | 84 | 44 | 98 | 2 | 248 | 6 | 983 | 1065 | HEU4918094.1 hypothetical protein [Candidatus Limnocylindrales bacterium] | diamond | 783 | 56.2 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 30871765 | 30871765 | PRJNA675331_P_NODE_6394_length_381_cov_1.292208_g6222_i0 | PRJNA675331 | 6394 | 381 | 1.292208 | 4.92331248 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 68.9 | 8.22e-11 | NR | MCA1552742.1 | 2026724 | g6222 | i0 | 38.3 | 2.55905511811024 | 107 | 59 | 84.3 | 2 | 381 | 61 | 98 | 197 | MCA1552742.1 LysM peptidoglycan-binding domain-containing protein [Chloroflexota bacterium] | diamond | 975 | 68.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31092990 | 31092990 | PRJNA675331_P_NODE_8315_length_340_cov_0.865169_g8143_i0 | PRJNA675331 | 8315 | 340 | 0.865169 | 2.9415746 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 110 | 1.26e-25 | NR | HEY7589993.1 | 2952938 | g8143 | i0 | 53.8 | 3.72352941176471 | 106 | 44 | 93.5 | 1 | 320 | 3 | 345 | 445 | HEY7589993.1 acyl-CoA synthetase FdrA [Candidatus Limnocylindrales bacterium] | diamond | 1266 | 110 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 31895409 | 31895409 | PRJNA675331_P_NODE_19197_length_249_cov_0.875000_g19025_i0 | PRJNA675331 | 19197 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 107 | 4.15e-25 | NR | RMF47385.1 | 2052143 | g19025 | i0 | 61.7 | 5.90361445783132 | 81 | 31 | 97.6 | 0 | 7 | 249 | 16 | 96 | RMF47385.1 MAG: IMP dehydrogenase [Anaerolineae bacterium] | diamond | 1470 | 107 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 32168584 | 32168584 | PRJNA675331_P_NODE_13478_length_279_cov_1.412621_g13306_i0 | PRJNA675331 | 13478 | 279 | 1.412621 | 3.94121259 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 95.1 | 5.9e-21 | NR | NJN96198.1 | 2073117 | g13306 | i0 | 41.4 | 3.19354838709677 | 99 | 51 | 98.9 | 1 | 278 | 3 | 97 | 195 | NJN96198.1 ABC transporter substrate-binding protein [Anaerolineales bacterium] | diamond | 891 | 95.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32705440 | 32705440 | PRJNA675331_P_NODE_1620_length_715_cov_1.319315_g1460_i0 | PRJNA675331 | 1620 | 715 | 1.319315 | 9.43310225 | Bellilinea sp. | 2838785 | Bacteria | Bacteria | 85.5 | 5.06e-15 | NR | HEY4691950.1 | 2838785 | g1460 | i0 | 38.3 | 0.625174825174825 | 149 | 79 | 60.4 | 6 | 252 | 683 | 25 | 165 | HEY4691950.1 hypothetical protein [Bellilinea sp.] | diamond | 447 | 85.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Bellilinea | Bellilinea sp. |
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);;