contig_metadata
6 rows where bioproject = "PRJEB20058", tax_clade = "FCB group" and tax_phylum = "Candidatus Cloacimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25923194 | 25923194 | PRJEB20058_P_NODE_149012_length_315_cov_2.992126_g146190_i0 | PRJEB20058 | 149012 | 315 | 2.992126 | 9.4251969 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 126 | 3.1e-31 | NR | MCB5284153.1 | 2030808 | g146190 | i0 | 98.5 | 1.25714285714286 | 66 | 1 | 62.9 | 0 | 116 | 313 | 301 | 366 | MCB5284153.1 alanine racemase [Candidatus Cloacimonadota bacterium] | diamond | 396 | 126 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 26062042 | 26062042 | PRJEB20058_P_NODE_217933_length_244_cov_1.049180_g215109_i0 | PRJEB20058 | 217933 | 244 | 1.04918 | 2.5599992 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 88.2 | 5.17e-19 | NR | MDD3144465.1 | 2030808 | g215109 | i0 | 91.5 | 1.73360655737705 | 47 | 4 | 57.8 | 0 | 244 | 104 | 40 | 86 | MDD3144465.1 cysteine--tRNA ligase [Candidatus Cloacimonadota bacterium] | diamond | 423 | 88.2 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 26198490 | 26198490 | PRJEB20058_P_NODE_220822_length_242_cov_1.403315_g217997_i0 | PRJEB20058 | 220822 | 242 | 1.403315 | 3.3960223 | Candidatus Syntrophosphaera | 2593013 | Bacteria | Bacteria | 153 | 2.5299999999999993e-42 | NR | MCK9309769.1 | 2030808 | g217997 | i0 | 91.1 | 9.85537190082645 | 79 | 7 | 97.9 | 0 | 240 | 4 | 369 | 447 | MCK9309769.1 [FeFe] hydrogenase H-cluster radical SAM maturase HydG [Candidatus Cloacimonadota bacterium] | diamond | 2385 | 154 | 0.993506493506494 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 33098402 | 33098402 | PRJEB20058_P_NODE_13502_length_1128_cov_194.603561_g11802_i0 | PRJEB20058 | 13502 | 1128 | 194.603561 | 2195.12816808 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 345 | 1.0099999999999997e-110 | NR | MDY6915097.1 | 2030808 | g11802 | i0 | 63.5 | 1.3563829787234 | 255 | 92 | 67.6 | 1 | 1100 | 339 | 133 | 387 | MDY6915097.1 diadenylate cyclase [Candidatus Cloacimonadota bacterium] | diamond | 1530 | 345 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 33149618 | 33149618 | PRJEB20058_P_NODE_143584_length_323_cov_4.213740_g140763_i0 | PRJEB20058 | 143584 | 323 | 4.21374 | 13.6103802 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 184 | 1.32e-53 | NR | HPS39136.1 | 2030808 | g140763 | i0 | 82.7 | 0.96594427244582 | 104 | 18 | 96.6 | 0 | 11 | 322 | 230 | 333 | HPS39136.1 hypothetical protein [Candidatus Cloacimonadota bacterium] | diamond | 312 | 184 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 33150360 | 33150360 | PRJEB20058_P_NODE_49408_length_598_cov_1.886406_g46688_i0 | PRJEB20058 | 49408 | 598 | 1.886406 | 11.28070788 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 369 | 2.8600000000000003e-122 | NR | MCB5284153.1 | 2030808 | g46688 | i0 | 98.4 | 1.89632107023411 | 189 | 3 | 94.8 | 0 | 30 | 596 | 363 | 551 | MCB5284153.1 alanine racemase [Candidatus Cloacimonadota bacterium] | diamond | 1134 | 369 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota 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);;