contig_metadata
8 rows where bioproject = "PRJNA1200128" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10530992 | 10530992 | PRJNA1200128_S_NODE_7089_length_282_cov_0.983264_g6980_i0 | PRJNA1200128 | 7089 | 282 | 0.983264 | 2.77280448 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 468 | 2.18e-127 | NTclustered | gi|76574295|gb|DQ139443.1| | 171953 | g6980 | i0 | 96.479 | 107.460992907801 | 284 | 8 | 100 | 2 | 1 | 282 | 596 | 879 | Uncultured Acidobacteria bacterium clone CAL2 23S ribosomal RNA gene, partial sequence | blastn | 30304 | 468 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 27293824 | 27293824 | PRJNA1200128_S_NODE_16683_length_215_cov_1.651163_g16574_i0 | PRJNA1200128 | 16683 | 215 | 1.651163 | 3.55000045 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 42.4 | 0.026 | NR | HEY0169517.1 | 2283092 | g16574 | i0 | 35.3 | 0.948837209302326 | 68 | 41 | 90.7 | 1 | 20 | 214 | 27 | 94 | HEY0169517.1 DUF2085 domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 204 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29377831 | 29377831 | PRJNA1200128_S_NODE_19989_length_204_cov_1.142857_g19880_i0 | PRJNA1200128 | 19989 | 204 | 1.142857 | 2.33142828 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 43.5 | 0.0121 | NR | HSE32976.1 | 2283092 | g19880 | i0 | 40 | 0.808823529411765 | 55 | 23 | 80.9 | 1 | 179 | 15 | 1033 | 1077 | HSE32976.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 165 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29661538 | 29661538 | PRJNA1200128_S_NODE_45950_length_154_cov_1.639640_g45841_i0 | PRJNA1200128 | 45950 | 154 | 1.63964 | 2.5250456 | Terracidiphilus sp. | 1964191 | Bacteria | Bacteria | 41.6 | 0.0293 | NR | MDR3772683.1 | 1964191 | g45841 | i0 | 40.5 | 2.45454545454545 | 42 | 25 | 81.8 | 0 | 138 | 13 | 670 | 711 | MDR3772683.1 FG-GAP-like repeat-containing protein [Terracidiphilus sp.] | diamond | 378 | 41.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 30262415 | 30262415 | PRJNA1200128_S_NODE_37972_length_165_cov_1.073770_g37863_i0 | PRJNA1200128 | 37972 | 165 | 1.07377 | 1.7717205 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 41.6 | 0.0332 | NR | MCA1816235.1 | 1978231 | g37863 | i0 | 48.3 | 0.527272727272727 | 29 | 15 | 52.7 | 0 | 70 | 156 | 114 | 142 | MCA1816235.1 3-oxoacyl-ACP reductase FabG [Acidobacteriota bacterium] | diamond | 87 | 41.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31652627 | 31652627 | PRJNA1200128_S_NODE_20897_length_201_cov_1.487342_g20788_i0 | PRJNA1200128 | 20897 | 201 | 1.487342 | 2.98955742 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42 | 0.0408 | NR | MCZ6670803.1 | 1978231 | g20788 | i0 | 60.7 | 0.417910447761194 | 28 | 11 | 41.8 | 0 | 40 | 123 | 245 | 272 | MCZ6670803.1 helix-turn-helix transcriptional regulator [Acidobacteriota bacterium] | diamond | 84 | 42 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32127566 | 32127566 | PRJNA1200128_S_NODE_12878_length_233_cov_1.978947_g12769_i0 | PRJNA1200128 | 12878 | 233 | 1.978947 | 4.61094651 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42.4 | 0.0437 | NR | MBV9494258.1 | 1978231 | g12769 | i0 | 38.3 | 0.772532188841202 | 60 | 37 | 77.3 | 0 | 219 | 40 | 24 | 83 | MBV9494258.1 O-antigen ligase family protein [Acidobacteriota bacterium] | diamond | 180 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32159175 | 32159175 | PRJNA1200128_S_NODE_32258_length_174_cov_2.938931_g32149_i0 | PRJNA1200128 | 32258 | 174 | 2.938931 | 5.11373994 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 40.8 | 0.0313 | NR | MAW62365.1 | 1978231 | g32149 | i0 | 37.5 | 0.827586206896552 | 48 | 29 | 82.8 | 1 | 8 | 151 | 67 | 113 | MAW62365.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 144 | 40.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota 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);;