contig_metadata
7 rows where bioproject = "PRJNA283169" and tax_phylum = "Candidatus Staskawicziibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27217954 | 27217954 | PRJNA283169_P_NODE_2802_length_248_cov_1.015075_g2739_i0 | PRJNA283169 | 2802 | 248 | 1.015075 | 2.517386 | Bacteria | 2 | Bacteria | Bacteria | 64.7 | 6.95e-10 | NR | OGZ63704.1 | 1802202 | g2739 | i0 | 87.9 | 1.64516129032258 | 33 | 4 | 39.9 | 0 | 3 | 101 | 351 | 383 | OGZ63704.1 MAG: transcription termination factor NusA [Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_01_FULL_39_25] | diamond | 408 | 64.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_01_FULL_39_25 | ||||||
| 29744068 | 29744068 | PRJNA283169_P_NODE_6130_length_173_cov_1.217742_g6067_i0 | PRJNA283169 | 6130 | 173 | 1.217742 | 2.10669366 | Bacteria | 2 | Bacteria | Bacteria | 110 | 7.07e-27 | NR | OGZ79440.1 | 1802223 | g6067 | i0 | 84.2 | 12.7803468208092 | 57 | 9 | 98.8 | 0 | 1 | 171 | 261 | 317 | OGZ79440.1 MAG: hypothetical protein A2358_00185 [Candidatus Staskawiczbacteria bacterium RIFOXYB1_FULL_37_44] | diamond | 2211 | 111 | 0.990990990990991 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium RIFOXYB1_FULL_37_44 | ||||||
| 30295708 | 30295708 | PRJNA283169_S_NODE_2892_length_171_cov_0.114754_g2878_i0 | PRJNA283169 | 2892 | 171 | 0.114754 | 0.19622934 | Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_ | 2053617 | Bacteria | Bacteria | 102 | 1.37e-23 | NR | OGZ65231.1 | 1802203 | g2878 | i0 | 86 | 2 | 57 | 8 | 100 | 0 | 171 | 1 | 130 | 186 | OGZ65231.1 MAG: hypothetical protein A2822_03720 [Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_01_FULL_41_41] | diamond | 342 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_01_FULL_41_41 | ||||||
| 30534051 | 30534051 | PRJNA283169_P_NODE_7173_length_165_cov_1.318966_g7110_i0 | PRJNA283169 | 7173 | 165 | 1.318966 | 2.1762939 | Bacteria | 2 | Bacteria | Bacteria | 90.5 | 1.85e-19 | NR | OGZ64674.1 | 1802202 | g7110 | i0 | 87 | 2.94545454545455 | 54 | 7 | 98.2 | 0 | 2 | 163 | 475 | 528 | OGZ64674.1 MAG: hypothetical protein A2730_01760 [Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_01_FULL_39_25] | diamond | 486 | 90.9 | 0.995599559955996 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_01_FULL_39_25 | ||||||
| 30597179 | 30597179 | PRJNA283169_P_NODE_5173_length_188_cov_1.100719_g5110_i0 | PRJNA283169 | 5173 | 188 | 1.100719 | 2.06935172 | Bacteria | 2 | Bacteria | Bacteria | 45.4 | 0.00201 | NR | OGZ64252.1 | 1802202 | g5110 | i0 | 95.5 | 2.45744680851064 | 22 | 1 | 35.1 | 0 | 123 | 188 | 1 | 22 | OGZ64252.1 MAG: molecular chaperone DnaK [Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_01_FULL_39_25] | diamond | 462 | 45.8 | 0.991266375545852 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_01_FULL_39_25 | ||||||
| 30863912 | 30863912 | PRJNA283169_P_NODE_4394_length_201_cov_1.355263_g4331_i0 | PRJNA283169 | 4394 | 201 | 1.355263 | 2.72407863 | Candidatus Staskawiczbacteria bacterium | 2053617 | Bacteria | Bacteria | 91.7 | 7.21e-22 | NR | MEI7424540.1 | 2053617 | g4331 | i0 | 73.1 | 2 | 67 | 14 | 100 | 1 | 201 | 1 | 37 | 99 | MEI7424540.1 30S ribosomal protein S8 [Candidatus Staskawiczbacteria bacterium] | diamond | 402 | 91.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium | ||||||
| 32034039 | 32034039 | PRJNA283169_P_NODE_7078_length_166_cov_0.880342_g7015_i0 | PRJNA283169 | 7078 | 166 | 0.880342 | 1.46136772 | Candidatus Staskawiczbacteria bacterium | 2053617 | Bacteria | Bacteria | 94.4 | 6.14e-22 | NR | MSU54341.1 | 2053617 | g7015 | i0 | 83.3 | 0.975903614457831 | 54 | 9 | 97.6 | 0 | 3 | 164 | 157 | 210 | MSU54341.1 class I SAM-dependent methyltransferase [Candidatus Staskawiczbacteria bacterium] | diamond | 162 | 94.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria 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);;