contig_metadata
3 rows where bioproject = "PRJEB28062", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Parcubacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29559389 | 29559389 | PRJEB28062_P_NODE_64250_length_433_cov_31.561111_g61889_i0 | PRJEB28062 | 64250 | 433 | 31.561111 | 136.65961063 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 185 | 3.73e-51 | NR | MEN9407862.1 | 2762014 | g61889 | i0 | 67.4 | 0.914549653579677 | 132 | 43 | 91.5 | 0 | 417 | 22 | 824 | 955 | MEN9407862.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 396 | 185 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 32309745 | 32309745 | PRJEB28062_P_NODE_21219_length_813_cov_4.747297_g19109_i0 | PRJEB28062 | 21219 | 813 | 4.747297 | 38.59552461 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 121 | 2.71e-28 | NR | RJR08382.1 | 2762014 | g19109 | i0 | 41.4 | 0.490774907749078 | 133 | 78 | 49.1 | 0 | 504 | 106 | 1 | 133 | RJR08382.1 MAG: hypothetical protein C4588_05625 [Candidatus Parcubacteria bacterium] | diamond | 399 | 121 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 32404430 | 32404430 | PRJEB28062_P_NODE_10819_length_1172_cov_161.275705_g9164_i0 | PRJEB28062 | 10819 | 1172 | 161.275705 | 1890.1512626 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 297 | 8.5e-96 | NR | RJQ25177.1 | 2762014 | g9164 | i0 | 58.8 | 2.62627986348123 | 257 | 104 | 65.3 | 1 | 13 | 777 | 12 | 268 | RJQ25177.1 MAG: undecaprenyl-diphosphate phosphatase [Candidatus Parcubacteria bacterium] | diamond | 3078 | 297 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria 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);;