contig_metadata
14 rows where bioproject = "PRJNA312615" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9305847 | 9305847 | PRJNA312615_P_NODE_15128_length_316_cov_1.576779_g14977_i0 | PRJNA312615 | 15128 | 316 | 1.576779 | 4.98262164 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 54.7 | 0.008 | NTclustered | gi|2874254061|emb|OY970385.1| | 2026791 | g14977 | i0 | 100 | 0.0917721518987342 | 29 | 0 | 9 | 0 | 193 | 221 | 1747555 | 1747583 | MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 10582059 | 10582059 | PRJNA312615_P_NODE_27909_length_231_cov_2.197802_g27758_i0 | PRJNA312615 | 27909 | 231 | 2.197802 | 5.07692262 | Mesoterricola sediminis | 2927980 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2490895851|dbj|AP027081.1| | 2927980 | g27758 | i0 | 96.97 | 0.264069264069264 | 33 | 1 | 14 | 0 | 151 | 183 | 2604290 | 2604258 | Mesoterricola sediminis W786 DNA, complete genome | blastn | 61 | 56.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Mesoterricola | Mesoterricola sediminis | ||
| 26662433 | 26662433 | PRJNA312615_P_NODE_12441_length_350_cov_3.651163_g12291_i0 | PRJNA312615 | 12441 | 350 | 3.651163 | 12.7790705 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 48.5 | 0.00112 | NR | MBX3265733.1 | 1978231 | g12291 | i0 | 32.5 | 0.711428571428571 | 83 | 51 | 68.6 | 3 | 348 | 109 | 152 | 232 | MBX3265733.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 249 | 48.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27453709 | 27453709 | PRJNA312615_P_NODE_18843_length_281_cov_1.297414_g18692_i0 | PRJNA312615 | 18843 | 281 | 1.297414 | 3.64573334 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 69.7 | 9.19e-12 | NR | HYW72085.1 | 2283092 | g18692 | i0 | 38.2 | 0.811387900355872 | 76 | 47 | 81.1 | 0 | 280 | 53 | 153 | 228 | HYW72085.1 CAP domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 228 | 69.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27502813 | 27502813 | PRJNA312615_P_NODE_6923_length_464_cov_3.527711_g6773_i0 | PRJNA312615 | 6923 | 464 | 3.527711 | 16.36857904 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 185 | 2.7499999999999992e-55 | NR | MEW5980043.1 | 1978231 | g6773 | i0 | 59.2 | 13.7586206896552 | 152 | 58 | 98.3 | 1 | 9 | 464 | 6 | 153 | MEW5980043.1 aldolase/citrate lyase family protein [Acidobacteriota bacterium] | diamond | 6384 | 186 | 0.99462365591397806 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28084889 | 28084889 | PRJNA312615_P_NODE_43025_length_186_cov_1.956204_g42874_i0 | PRJNA312615 | 43025 | 186 | 1.956204 | 3.63853944 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 43.5 | 0.00846 | NR | MEP6593608.1 | 1978231 | g42874 | i0 | 45.5 | 1.41935483870968 | 44 | 22 | 67.7 | 1 | 15 | 140 | 90 | 133 | MEP6593608.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 264 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28274294 | 28274294 | PRJNA312615_P_NODE_12106_length_355_cov_3.366013_g11956_i0 | PRJNA312615 | 12106 | 355 | 3.366013 | 11.94934615 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 140 | 2.73e-38 | NR | HEY4362301.1 | 2212468 | g11956 | i0 | 59.3 | 8.65352112676056 | 113 | 46 | 95.5 | 0 | 1 | 339 | 161 | 273 | HEY4362301.1 aldolase/citrate lyase family protein [Bryobacteraceae bacterium] | diamond | 3072 | 140 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28653355 | 28653355 | PRJNA312615_P_NODE_49327_length_170_cov_1.669421_g49176_i0 | PRJNA312615 | 49327 | 170 | 1.669421 | 2.8380157 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 70.1 | 2.66e-12 | NR | MBI2688000.1 | 1978231 | g49176 | i0 | 70 | 1.05882352941176 | 60 | 14 | 98.8 | 1 | 169 | 2 | 37 | 96 | MBI2688000.1 glycosyltransferase [Acidobacteriota bacterium] | diamond | 180 | 70.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28842601 | 28842601 | PRJNA312615_P_NODE_22008_length_260_cov_1.445498_g21857_i0 | PRJNA312615 | 22008 | 260 | 1.445498 | 3.7582948 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 82 | 5.91e-16 | NR | NNE99019.1 | 2283092 | g21857 | i0 | 42.9 | 2.86153846153846 | 84 | 47 | 96.9 | 1 | 253 | 2 | 158 | 240 | NNE99019.1 M24 family metallopeptidase [Pyrinomonadaceae bacterium] | diamond | 744 | 82 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29853196 | 29853196 | PRJNA312615_P_NODE_331_length_1445_cov_4.729943_g285_i0 | PRJNA312615 | 331 | 1445 | 4.729943 | 68.34767635 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 60.1 | 9.09e-6 | NR | MBS1873370.1 | 1978231 | g285 | i0 | 34.4 | 0.259515570934256 | 125 | 60 | 25.3 | 5 | 1010 | 1375 | 112 | 217 | MBS1873370.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 375 | 60.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30154755 | 30154755 | PRJNA312615_P_NODE_46072_length_179_cov_1.176923_g45921_i0 | PRJNA312615 | 46072 | 179 | 1.176923 | 2.10669217 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 116 | 1.38e-30 | NR | HXJ39221.1 | 2212468 | g45921 | i0 | 93.2 | 3.95530726256983 | 59 | 4 | 98.9 | 0 | 1 | 177 | 157 | 215 | HXJ39221.1 ROK family transcriptional regulator [Bryobacteraceae bacterium] | diamond | 708 | 116 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30327539 | 30327539 | PRJNA312615_P_NODE_33992_length_210_cov_1.559006_g33841_i0 | PRJNA312615 | 33992 | 210 | 1.559006 | 3.2739126 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 51.6 | 1.75e-5 | NR | MDR3737288.1 | 2052142 | g33841 | i0 | 38.3 | 0.857142857142857 | 60 | 37 | 85.7 | 0 | 182 | 3 | 200 | 259 | MDR3737288.1 hypothetical protein [Acidobacteriaceae bacterium] | diamond | 180 | 51.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 30408094 | 30408094 | PRJNA312615_P_NODE_39173_length_196_cov_1.238095_g39022_i0 | PRJNA312615 | 39173 | 196 | 1.238095 | 2.4266662 | Bacteria | 2 | Bacteria | Bacteria | 93.6 | 4.500000000000001e-22 | NR | MBI4469680.1 | 1978231 | g39022 | i0 | 65.6 | 10.7602040816327 | 64 | 21 | 98 | 1 | 5 | 196 | 13 | 75 | MBI4469680.1 peptide-methionine (S)-S-oxide reductase MsrA [Acidobacteriota bacterium] | diamond | 2109 | 93.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32129264 | 32129264 | PRJNA312615_P_NODE_55498_length_164_cov_0.886957_g55347_i0 | PRJNA312615 | 55498 | 164 | 0.886957 | 1.45460948 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 49.3 | 6.23e-5 | NR | MEO7539570.1 | 2283092 | g55347 | i0 | 59.3 | 0.98780487804878 | 54 | 16 | 98.8 | 1 | 3 | 164 | 374 | 421 | MEO7539570.1 ATP-binding protein [Pyrinomonadaceae bacterium] | diamond | 162 | 49.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae 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);;