contig_metadata
8 rows where bioproject = "PRJNA382357" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4229781 | 4229781 | PRJNA382357_P_NODE_120324_length_223_cov_1.197531_g119585_i0 | PRJNA382357 | 120324 | 223 | 1.197531 | 2.67049413 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 107 | 5.089999999999999e-28 | NR | HUL34514.1 | 2212470 | g119585 | i0 | 88.3 | 1.61434977578475 | 60 | 7 | 80.7 | 0 | 5 | 184 | 52 | 111 | HUL34514.1 RidA family protein [Candidatus Eiseniibacteriota bacterium] | diamond | 360 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 26965430 | 26965430 | PRJNA382357_P_NODE_118322_length_224_cov_12.447853_g117583_i0 | PRJNA382357 | 118322 | 224 | 12.447853 | 27.88319072 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 103 | 1.5099999999999998e-23 | NR | HUL33899.1 | 2212470 | g117583 | i0 | 93.6 | 1.88839285714286 | 47 | 3 | 62.9 | 0 | 222 | 82 | 141 | 187 | HUL33899.1 methionine--tRNA ligase [Candidatus Eiseniibacteriota bacterium] | diamond | 423 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 28828809 | 28828809 | PRJNA382357_P_NODE_59868_length_303_cov_1.661157_g59129_i0 | PRJNA382357 | 59868 | 303 | 1.661157 | 5.03330571 | Bacteria candidate phyla | 1783234 | Bacteria | Bacteria | 116 | 4.17e-28 | NR | HUL32535.1 | 2212470 | g59129 | i0 | 80.6 | 4.51485148514851 | 72 | 14 | 71.3 | 0 | 3 | 218 | 195 | 266 | HUL32535.1 TldD/PmbA family protein [Candidatus Eiseniibacteriota bacterium] | diamond | 1368 | 117 | 0.991452991452991 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 29380360 | 29380360 | PRJNA382357_P_NODE_75409_length_274_cov_1.539906_g74670_i0 | PRJNA382357 | 75409 | 274 | 1.539906 | 4.21934244 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 103 | 8.07e-25 | NR | HKA24594.1 | 2212470 | g74670 | i0 | 67.7 | 0.711678832116788 | 65 | 21 | 71.2 | 0 | 274 | 80 | 87 | 151 | HKA24594.1 glycosyltransferase [Candidatus Eiseniibacteriota bacterium] | diamond | 195 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 31040190 | 31040190 | PRJNA382357_P_NODE_72615_length_278_cov_4.156682_g71876_i0 | PRJNA382357 | 72615 | 278 | 4.156682 | 11.55557596 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 70.9 | 1.51e-12 | NR | HUL33098.1 | 2212470 | g71876 | i0 | 76.7 | 1.86690647482014 | 43 | 10 | 46.4 | 0 | 185 | 57 | 169 | 211 | HUL33098.1 response regulator transcription factor [Candidatus Eiseniibacteriota bacterium] | diamond | 519 | 70.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 32066553 | 32066553 | PRJNA382357_P_NODE_85078_length_260_cov_1.195980_g84339_i0 | PRJNA382357 | 85078 | 260 | 1.19598 | 3.109548 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 109 | 7.45e-27 | NR | HUL33690.1 | 2212470 | g84339 | i0 | 81.5 | 2.25 | 65 | 12 | 75 | 0 | 255 | 61 | 127 | 191 | HUL33690.1 TIGR01777 family oxidoreductase [Candidatus Eiseniibacteriota bacterium] | diamond | 585 | 109 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 32761779 | 32761779 | PRJNA382357_P_NODE_96900_length_245_cov_6.744565_g96161_i0 | PRJNA382357 | 96900 | 245 | 6.744565 | 16.52418425 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 104 | 8.710000000000001e-26 | NR | HUL33196.1 | 2212470 | g96161 | i0 | 80 | 2.11836734693878 | 60 | 12 | 73.5 | 0 | 244 | 65 | 24 | 83 | HUL33196.1 pyridoxamine 5'-phosphate oxidase family protein [Candidatus Eiseniibacteriota bacterium] | diamond | 519 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 32873019 | 32873019 | PRJNA382357_P_NODE_60460_length_302_cov_1.070539_g59721_i0 | PRJNA382357 | 60460 | 302 | 1.070539 | 3.23302778 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 85.9 | 5.33e-17 | NR | HUL33109.1 | 2212470 | g59721 | i0 | 78.3 | 1.37086092715232 | 46 | 10 | 45.7 | 0 | 223 | 86 | 392 | 437 | HUL33109.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium] | diamond | 414 | 86.3 | 0.995365005793743 | 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);;