contig_metadata
16 rows where bioproject = "PRJNA782551", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9692047 | 9692047 | PRJNA782551_P_NODE_16448_length_250_cov_1.644068_g16326_i0 | PRJNA782551 | 16448 | 250 | 1.644068 | 4.11017 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 112 | 1.13e-26 | NR | MDQ4044375.1 | 2026724 | g16326 | i0 | 87.9 | 0.696 | 58 | 7 | 69.6 | 0 | 250 | 77 | 558 | 615 | MDQ4044375.1 hypothetical protein [Chloroflexota bacterium] | diamond | 174 | 112 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 13966419 | 13966419 | PRJNA782551_P_NODE_20811_length_245_cov_0.895349_g20689_i0 | PRJNA782551 | 20811 | 245 | 0.895349 | 2.19360505 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 163 | 3.5499999999999996e-47 | NR | TMF89266.1 | 2026724 | g20689 | i0 | 91.4 | 0.991836734693878 | 81 | 7 | 99.2 | 0 | 245 | 3 | 163 | 243 | TMF89266.1 MAG: hypothetical protein E6I08_05125 [Chloroflexota bacterium] | diamond | 243 | 163 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 23716414 | 23716414 | PRJNA782551_P_NODE_14419_length_260_cov_1.486631_g14297_i0 | PRJNA782551 | 14419 | 260 | 1.486631 | 3.8652406 | FCB group | 1783270 | Bacteria | Bacteria | 68.6 | 3.82e-11 | NR | HEY7065186.1 | 2026724 | g14297 | i0 | 39.5 | 6.66923076923077 | 86 | 50 | 98.1 | 2 | 3 | 257 | 738 | 822 | HEY7065186.1 PAS domain S-box protein [Chloroflexota bacterium] | diamond | 1734 | 68.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 25439328 | 25439328 | PRJNA782551_P_NODE_25040_length_241_cov_0.916667_g24918_i0 | PRJNA782551 | 25040 | 241 | 0.916667 | 2.20916747 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 87.8 | 5e-18 | NR | MBA3275159.1 | 2448782 | g24918 | i0 | 66.7 | 0.933609958506224 | 75 | 24 | 92.1 | 1 | 240 | 19 | 597 | 671 | MBA3275159.1 hypothetical protein [Chloroflexia bacterium] | diamond | 225 | 87.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 26714405 | 26714405 | PRJNA782551_P_NODE_19861_length_246_cov_1.734104_g19739_i0 | PRJNA782551 | 19861 | 246 | 1.734104 | 4.26589584 | Bacteria | 2 | Bacteria | Bacteria | 127 | 2.62e-32 | NR | HVN53312.1 | 2024896 | g19739 | i0 | 82.6 | 1.68292682926829 | 69 | 12 | 84.1 | 0 | 3 | 209 | 428 | 496 | HVN53312.1 sugar ABC transporter ATP-binding protein [Anaerolineaceae bacterium] | diamond | 414 | 127 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 27464567 | 27464567 | PRJNA782551_P_NODE_20283_length_246_cov_0.890173_g20161_i0 | PRJNA782551 | 20283 | 246 | 0.890173 | 2.18982558 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 144 | 2.55e-41 | NR | MCC7370892.1 | 2026724 | g20161 | i0 | 84.1 | 1 | 82 | 13 | 100 | 0 | 1 | 246 | 74 | 155 | MCC7370892.1 HAD family hydrolase [Chloroflexota bacterium] | diamond | 246 | 144 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28001367 | 28001367 | PRJNA782551_P_NODE_18845_length_248_cov_0.880000_g18723_i0 | PRJNA782551 | 18845 | 248 | 0.88 | 2.1824 | Ktedonobacterales bacterium | 2306968 | Bacteria | Bacteria | 80.1 | 7.18e-16 | NR | HEU5439596.1 | 2306968 | g18723 | i0 | 70.8 | 0.870967741935484 | 72 | 20 | 85.9 | 1 | 221 | 9 | 93 | 164 | HEU5439596.1 hypothetical protein [Ktedonobacterales bacterium] | diamond | 216 | 80.1 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacterales bacterium | ||||
| 28222015 | 28222015 | PRJNA782551_P_NODE_15726_length_251_cov_0.865169_g15604_i0 | PRJNA782551 | 15726 | 251 | 0.865169 | 2.17157419 | Anaerolinea sp. | 1872519 | Bacteria | Bacteria | 90.9 | 2.59e-19 | NR | MBE2201569.1 | 1872519 | g15604 | i0 | 57.8 | 2.95219123505976 | 83 | 34 | 99.2 | 1 | 3 | 251 | 172 | 253 | MBE2201569.1 restriction endonuclease subunit S [Anaerolinea sp.] | diamond | 741 | 90.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolinea | Anaerolinea sp. | ||
| 29453238 | 29453238 | PRJNA782551_P_NODE_22570_length_243_cov_0.905882_g22448_i0 | PRJNA782551 | 22570 | 243 | 0.905882 | 2.20129326 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 115 | 3.41e-28 | NR | HEY5434583.1 | 2952938 | g22448 | i0 | 67.9 | 3 | 81 | 26 | 100 | 0 | 243 | 1 | 66 | 146 | HEY5434583.1 hypothetical protein [Candidatus Limnocylindrales bacterium] | diamond | 729 | 115 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 29611157 | 29611157 | PRJNA782551_P_NODE_23430_length_242_cov_0.911243_g23308_i0 | PRJNA782551 | 23430 | 242 | 0.911243 | 2.20520806 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 130 | 6.58e-34 | NR | HEX5415541.1 | 2026724 | g23308 | i0 | 78.5 | 0.979338842975207 | 79 | 17 | 97.9 | 0 | 4 | 240 | 325 | 403 | HEX5415541.1 hypothetical protein [Chloroflexota bacterium] | diamond | 237 | 130 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29674267 | 29674267 | PRJNA782551_P_NODE_25230_length_233_cov_2.881250_g25108_i0 | PRJNA782551 | 25230 | 233 | 2.88125 | 6.7133125 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 147 | 3.4199999999999993e-40 | NR | HXI19073.1 | 2026724 | g25108 | i0 | 88.3 | 1.98283261802575 | 77 | 9 | 99.1 | 0 | 232 | 2 | 226 | 302 | HXI19073.1 sugar ABC transporter substrate-binding protein [Chloroflexota bacterium] | diamond | 462 | 147 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30094360 | 30094360 | PRJNA782551_P_NODE_14372_length_260_cov_1.647059_g14250_i0 | PRJNA782551 | 14372 | 260 | 1.647059 | 4.2823534 | Bacteria | 2 | Bacteria | Bacteria | 123 | 1.4799999999999998e-31 | NR | MBA3415222.1 | 2448782 | g14250 | i0 | 65.5 | 4.00384615384615 | 87 | 29 | 99.2 | 1 | 260 | 3 | 85 | 171 | MBA3415222.1 flippase-like domain-containing protein [Chloroflexia bacterium] | diamond | 1041 | 123 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 30243301 | 30243301 | PRJNA782551_P_NODE_14952_length_256_cov_1.333333_g14830_i0 | PRJNA782551 | 14952 | 256 | 1.333333 | 3.41333248 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 150 | 5.0099999999999996e-40 | NR | MDP9362765.1 | 2026724 | g14830 | i0 | 86.9 | 0.984375 | 84 | 11 | 98.4 | 0 | 3 | 254 | 570 | 653 | MDP9362765.1 molybdopterin-dependent oxidoreductase [Chloroflexota bacterium] | diamond | 252 | 150 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30379246 | 30379246 | PRJNA782551_P_NODE_17872_length_249_cov_0.875000_g17750_i0 | PRJNA782551 | 17872 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 121 | 2.0899999999999998e-32 | NR | MER3485428.1 | 2026724 | g17750 | i0 | 81.7 | 1.97590361445783 | 82 | 15 | 98.8 | 0 | 3 | 248 | 42 | 123 | MER3485428.1 peptide ABC transporter permease [Chloroflexota bacterium] | diamond | 492 | 122 | 0.991803278688525 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31159086 | 31159086 | PRJNA782551_P_NODE_24635_length_241_cov_0.916667_g24513_i0 | PRJNA782551 | 24635 | 241 | 0.916667 | 2.20916747 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 147 | 7.2e-44 | NR | QLQ08804.1 | 2052143 | g24513 | i0 | 85 | 1.9792531120332 | 80 | 12 | 99.6 | 0 | 240 | 1 | 23 | 102 | QLQ08804.1 MAG: PPOX class F420-dependent oxidoreductase [Anaerolineae bacterium] | diamond | 477 | 147 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31475834 | 31475834 | PRJNA782551_P_NODE_14996_length_255_cov_2.230769_g14874_i0 | PRJNA782551 | 14996 | 255 | 2.230769 | 5.68846095 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 50.1 | 1.15e-4 | NR | MCC6616784.1 | 2052143 | g14874 | i0 | 42.4 | 0.776470588235294 | 66 | 31 | 77.6 | 2 | 200 | 3 | 1390 | 1448 | MCC6616784.1 DNA polymerase III subunit alpha [Anaerolineae bacterium] | diamond | 198 | 50.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae 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);;