contig_metadata
8 rows where bioproject = "PRJEB64798" and tax_phylum = "Candidatus Dormiibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6508036 | 6508036 | PRJEB64798_P_NODE_92426_length_212_cov_5.368098_g90660_i0 | PRJEB64798 | 92426 | 212 | 5.368098 | 11.38036776 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 66.6 | 3.65e-11 | NR | MDQ6637931.1 | 2052315 | g90660 | i0 | 93.8 | 4.07547169811321 | 32 | 2 | 45.3 | 0 | 6 | 101 | 76 | 107 | MDQ6637931.1 ABC transporter ATP-binding protein [Candidatus Dormiibacterota bacterium] | diamond | 864 | 66.6 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 9056428 | 9056428 | PRJEB64798_P_NODE_56068_length_260_cov_13.672986_g54303_i0 | PRJEB64798 | 56068 | 260 | 13.672986 | 35.5497636 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 182 | 2.9e-41 | NTclustered | gi|2874253735|emb|OY969577.1| | 2052315 | g54303 | i0 | 81.9 | 104.961538461538 | 221 | 34 | 84 | 6 | 8 | 226 | 940950 | 941166 | MAG: Candidatus Dormibacteraeota bacterium isolate MFD10064.bin.c.3 genome assembly, chromosome: 1 | blastn | 27290 | 182 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 24354286 | 24354286 | PRJEB64798_P_NODE_244080_length_154_cov_2.076190_g242314_i0 | PRJEB64798 | 244080 | 154 | 2.07619 | 3.1973326 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 65.8 | 1.62e-6 | NTclustered | gi|2874253982|emb|OY970307.1| | 2052315 | g242314 | i0 | 95.122 | 0.487012987012987 | 41 | 2 | 27 | 0 | 110 | 150 | 1090032 | 1089992 | MAG: Candidatus Dormibacteraeota bacterium isolate MFD04463.bin.c.11 genome assembly, chromosome: 1 | blastn | 75 | 65.8 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 29174441 | 29174441 | PRJEB64798_P_NODE_70929_length_229_cov_12.472222_g69164_i0 | PRJEB64798 | 70929 | 229 | 12.472222 | 28.56138838 | FCB group | 1783270 | Bacteria | Bacteria | 83.6 | 1.28e-16 | NR | HXL23784.1 | 2052315 | g69164 | i0 | 54.9 | 5.73799126637555 | 71 | 31 | 93 | 1 | 227 | 15 | 1076 | 1145 | HXL23784.1 M1 family aminopeptidase [Candidatus Dormiibacterota bacterium] | diamond | 1314 | 83.6 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 29812444 | 29812444 | PRJEB64798_P_NODE_143571_length_191_cov_13.978873_g141805_i0 | PRJEB64798 | 143571 | 191 | 13.978873 | 26.69964743 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 72.8 | 5.34e-14 | NR | HEY6379118.1 | 2052315 | g141805 | i0 | 53.1 | 2.01047120418848 | 64 | 29 | 99 | 1 | 1 | 189 | 62 | 125 | HEY6379118.1 MBL fold metallo-hydrolase [Candidatus Dormiibacterota bacterium] | diamond | 384 | 72.8 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 30381598 | 30381598 | PRJEB64798_P_NODE_104953_length_211_cov_21.487654_g103187_i0 | PRJEB64798 | 104953 | 211 | 21.487654 | 45.33894994 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 47 | 5.63e-4 | NR | HUZ50412.1 | 2052315 | g103187 | i0 | 70 | 0.42654028436019 | 30 | 9 | 42.7 | 0 | 3 | 92 | 147 | 176 | HUZ50412.1 thiamine phosphate synthase [Candidatus Dormiibacterota bacterium] | diamond | 90 | 47 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 30911694 | 30911694 | PRJEB64798_P_NODE_82214_length_213_cov_13.189024_g80448_i0 | PRJEB64798 | 82214 | 213 | 13.189024 | 28.09262112 | Bacillati | 1783272 | Bacteria | Bacteria | 72 | 9.47e-13 | NR | MDQ6877191.1 | 2052315 | g80448 | i0 | 90.9 | 0.929577464788732 | 33 | 3 | 46.5 | 0 | 115 | 213 | 111 | 143 | MDQ6877191.1 BREX system Lon protease-like protein BrxL [Candidatus Dormiibacterota bacterium] | diamond | 198 | 72 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 32215224 | 32215224 | PRJEB64798_P_NODE_31398_length_351_cov_12.043046_g29641_i0 | PRJEB64798 | 31398 | 351 | 12.043046 | 42.27109146 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 44.3 | 0.0323 | NR | MDA8330264.1 | 2052315 | g29641 | i0 | 30.9 | 0.692307692307692 | 81 | 51 | 66.7 | 3 | 235 | 2 | 13 | 91 | MDA8330264.1 peptidoglycan bridge formation glycyltransferase FemA/FemB family protein [Candidatus Dormiibacterota bacterium] | diamond | 243 | 44.3 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota 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);;