contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA951810" and tax_phylum = "Candidatus Eiseniibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2213009 | 2213009 | PRJNA951810_P_NODE_64822_length_310_cov_2.869198_g64479_i0 | PRJNA951810 | 64822 | 310 | 2.869198 | 8.8945138 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 83.6 | 3.02e-16 | NR | HTL70667.1 | 2212470 | g64479 | i0 | 62.5 | 0.987096774193548 | 56 | 21 | 54.2 | 0 | 170 | 3 | 27 | 82 | HTL70667.1 DUF255 domain-containing protein [Candidatus Eiseniibacteriota bacterium] | diamond | 306 | 83.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 16238728 | 16238728 | PRJNA951810_P_NODE_135273_length_269_cov_3.632653_g134928_i0 | PRJNA951810 | 135273 | 269 | 3.632653 | 9.77183657 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 86.7 | 6.95e-18 | NR | HEX5029989.1 | 2212470 | g134928 | i0 | 74.1 | 8.7546468401487 | 54 | 14 | 60.2 | 0 | 164 | 3 | 1 | 54 | HEX5029989.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium] | diamond | 2355 | 87 | 0.996551724137931 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 26899163 | 26899163 | PRJNA951810_P_NODE_14641_length_504_cov_5.930394_g14308_i0 | PRJNA951810 | 14641 | 504 | 5.930394 | 29.88918576 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 91.7 | 5.19e-18 | NR | MCA9730089.1 | 2212470 | g14308 | i0 | 43.2 | 1.625 | 169 | 73 | 98.8 | 9 | 498 | 1 | 217 | 365 | MCA9730089.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium] | diamond | 819 | 91.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 26968792 | 26968792 | PRJNA951810_P_NODE_150062_length_258_cov_2.286486_g149717_i0 | PRJNA951810 | 150062 | 258 | 2.286486 | 5.89913388 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 56.2 | 7.75e-7 | NR | OGF16533.1 | 1817856 | g149717 | i0 | 36.5 | 2.01162790697674 | 85 | 53 | 98.8 | 1 | 2 | 256 | 468 | 551 | OGF16533.1 MAG: hypothetical protein A2W00_13265 [Candidatus Eisenbacteria bacterium RBG_16_71_46] | diamond | 519 | 56.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eisenbacteria bacterium RBG_16_71_46 | ||||||
| 29110020 | 29110020 | PRJNA951810_P_NODE_138948_length_266_cov_5.357513_g138603_i0 | PRJNA951810 | 138948 | 266 | 5.357513 | 14.25098458 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 140 | 6.98e-39 | NR | MFB3908827.1 | 2212470 | g138603 | i0 | 74.2 | 1.00375939849624 | 89 | 22 | 99.2 | 1 | 264 | 1 | 137 | 225 | MFB3908827.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium] | diamond | 267 | 140 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 29267596 | 29267596 | PRJNA951810_P_NODE_168449_length_243_cov_6.652941_g168104_i0 | PRJNA951810 | 168449 | 243 | 6.652941 | 16.16664663 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 65.9 | 1.1e-10 | NR | MEQ1833439.1 | 2212470 | g168104 | i0 | 58.5 | 0.654320987654321 | 53 | 19 | 65.4 | 1 | 241 | 83 | 188 | 237 | MEQ1833439.1 cytochrome C oxidase subunit II [Candidatus Eiseniibacteriota bacterium] | diamond | 159 | 65.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 29267650 | 29267650 | PRJNA951810_P_NODE_40609_length_310_cov_13.345992_g40266_i0 | PRJNA951810 | 40609 | 310 | 13.345992 | 41.3725752 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 49.3 | 4.16e-4 | NR | MBD3235990.1 | 2212470 | g40266 | i0 | 53.3 | 0.435483870967742 | 45 | 21 | 43.5 | 0 | 306 | 172 | 689 | 733 | MBD3235990.1 sulfatase-like hydrolase/transferase [Candidatus Eiseniibacteriota bacterium] | diamond | 135 | 49.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 29741177 | 29741177 | PRJNA951810_P_NODE_41710_length_310_cov_10.063291_g41367_i0 | PRJNA951810 | 41710 | 310 | 10.063291 | 31.1962021 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 89.7 | 2.75e-18 | NR | HEY6196178.1 | 2212470 | g41367 | i0 | 46.8 | 1.2 | 124 | 44 | 99.7 | 3 | 310 | 2 | 45 | 167 | HEY6196178.1 Ig-like domain repeat protein [Candidatus Eiseniibacteriota bacterium] | diamond | 372 | 89.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 30310633 | 30310633 | PRJNA951810_P_NODE_75632_length_299_cov_6.442478_g75288_i0 | PRJNA951810 | 75632 | 299 | 6.442478 | 19.26300922 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 69.3 | 1.98e-11 | NR | MEO5617055.1 | 2212470 | g75288 | i0 | 59.2 | 0.491638795986622 | 49 | 20 | 49.2 | 0 | 153 | 299 | 108 | 156 | MEO5617055.1 GNAT family N-acetyltransferase [Candidatus Eiseniibacteriota bacterium] | diamond | 147 | 69.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 30436804 | 30436804 | PRJNA951810_P_NODE_89793_length_297_cov_6.665179_g89449_i0 | PRJNA951810 | 89793 | 297 | 6.665179 | 19.79558163 | Candidatus Eisenbacteria bacterium | 2212470 | Bacteria | Bacteria | 84.3 | 2.7e-17 | NR | TMQ55455.1 | 2212470 | g89449 | i0 | 72 | 1.01010101010101 | 50 | 14 | 50.5 | 0 | 2 | 151 | 87 | 136 | TMQ55455.1 MAG: S9 family peptidase [Candidatus Eiseniibacteriota bacterium] | diamond | 300 | 84.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 30531115 | 30531115 | PRJNA951810_P_NODE_165513_length_246_cov_0.890173_g165168_i0 | PRJNA951810 | 165513 | 246 | 0.890173 | 2.18982558 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 139 | 9.29e-37 | NR | HXJ36925.1 | 2212470 | g165168 | i0 | 81.5 | 1.97560975609756 | 81 | 15 | 98.8 | 0 | 2 | 244 | 425 | 505 | HXJ36925.1 AMP-binding protein [Candidatus Eiseniibacteriota bacterium] | diamond | 486 | 139 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 32206945 | 32206945 | PRJNA951810_P_NODE_102338_length_291_cov_8.133028_g101994_i0 | PRJNA951810 | 102338 | 291 | 8.133028 | 23.66711148 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 47.4 | 0.00147 | NR | MBN1827162.1 | 2212470 | g101994 | i0 | 51.1 | 0.484536082474227 | 47 | 23 | 48.5 | 0 | 147 | 287 | 329 | 375 | MBN1827162.1 PDZ domain-containing protein [Candidatus Eiseniibacteriota bacterium] | diamond | 141 | 47.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota 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);;