contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA591000" and tax_phylum = "Candidatus Kaiseribacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19691326 | 19691326 | PRJNA591000_P_NODE_3996_length_724_cov_1.565468_g3141_i0 | PRJNA591000 | 3996 | 724 | 1.565468 | 11.33398832 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 113 | 1.68e-25 | NR | MBI5004205.1 | 2030810 | g3141 | i0 | 44.4 | 0.588397790055249 | 142 | 71 | 58.8 | 3 | 23 | 448 | 126 | 259 | MBI5004205.1 hypothetical protein [Candidatus Kaiserbacteria bacterium] | diamond | 426 | 113 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 28374476 | 28374476 | PRJNA591000_P_NODE_6086_length_580_cov_11.490018_g4806_i0 | PRJNA591000 | 6086 | 580 | 11.490018 | 66.6421044 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 74.7 | 5.88e-14 | NR | MCA9368581.1 | 2030810 | g4806 | i0 | 43.8 | 0.413793103448276 | 80 | 42 | 41.4 | 1 | 32 | 271 | 4 | 80 | MCA9368581.1 hypothetical protein [Candidatus Kaiserbacteria bacterium] | diamond | 240 | 74.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 28437826 | 28437826 | PRJNA591000_P_NODE_9286_length_459_cov_1.111628_g7735_i0 | PRJNA591000 | 9286 | 459 | 1.111628 | 5.10237252 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 60.8 | 1.84e-7 | NR | MCA9353946.1 | 2030810 | g7735 | i0 | 59.2 | 0.320261437908497 | 49 | 19 | 31.4 | 1 | 13 | 156 | 855 | 903 | MCA9353946.1 hypothetical protein [Candidatus Kaiserbacteria bacterium] | diamond | 147 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 28500942 | 28500942 | PRJNA591000_P_NODE_15587_length_255_cov_3.278761_g13981_i0 | PRJNA591000 | 15587 | 255 | 3.278761 | 8.36084055 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 58.5 | 1.17e-7 | NR | MCA9366760.1 | 2030810 | g13981 | i0 | 38 | 1.55294117647059 | 71 | 38 | 83.5 | 2 | 227 | 15 | 154 | 218 | MCA9366760.1 hypothetical protein [Candidatus Kaiserbacteria bacterium] | diamond | 396 | 58.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 29100830 | 29100830 | PRJNA591000_P_NODE_6728_length_543_cov_1.457198_g5350_i0 | PRJNA591000 | 6728 | 543 | 1.457198 | 7.91258514 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 63.5 | 3.5e-8 | NR | MBI5004205.1 | 2030810 | g5350 | i0 | 45.6 | 0.43646408839779 | 79 | 41 | 43.6 | 2 | 23 | 259 | 126 | 202 | MBI5004205.1 hypothetical protein [Candidatus Kaiserbacteria bacterium] | diamond | 237 | 63.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 30427680 | 30427680 | PRJNA591000_P_NODE_6893_length_535_cov_1.511858_g5494_i0 | PRJNA591000 | 6893 | 535 | 1.511858 | 8.0884403 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 63.5 | 3.34e-8 | NR | MBI5004205.1 | 2030810 | g5494 | i0 | 45.6 | 0.442990654205607 | 79 | 41 | 44.3 | 2 | 23 | 259 | 126 | 202 | MBI5004205.1 hypothetical protein [Candidatus Kaiserbacteria bacterium] | diamond | 237 | 63.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 32779625 | 32779625 | PRJNA591000_P_NODE_15580_length_258_cov_8.157205_g13974_i0 | PRJNA591000 | 15580 | 258 | 8.157205 | 21.0455889 | Bacteria | 2 | Bacteria | Bacteria | 45.8 | 0.00121 | NR | KKW22869.1 | 1618671 | g13974 | i0 | 42 | 1.12790697674419 | 50 | 29 | 58.1 | 0 | 241 | 92 | 85 | 134 | KKW22869.1 MAG: hypothetical protein UY67_C0034G0006 [Candidatus Kaiserbacteria bacterium GW2011_GWA2_52_12] | diamond | 291 | 45.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium GW2011_GWA2_52_12 |
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);;