contig_metadata
20 rows where bioproject = "PRJNA1156092" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11781591 | 11781591 | PRJNA1156092_P_NODE_31650_length_242_cov_0.911243_g31520_i0 | PRJNA1156092 | 31650 | 242 | 0.911243 | 2.20520806 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 60.2 | 1.3e-4 | NTclustered | gi|2874253710|emb|OY969475.1| | 2283092 | g31520 | i0 | 94.737 | 0.301652892561983 | 38 | 2 | 16 | 0 | 154 | 191 | 2761285 | 2761322 | MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1 | blastn | 73 | 60.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 14331797 | 14331797 | PRJNA1156092_P_NODE_22512_length_251_cov_0.865169_g22382_i0 | PRJNA1156092 | 22512 | 251 | 0.865169 | 2.17157419 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 311 | 3.4e-80 | NTclustered | gi|76574290|gb|DQ139438.1| | 171953 | g22382 | i0 | 90.456 | 100.330677290837 | 241 | 16 | 95 | 6 | 12 | 250 | 464 | 699 | Uncultured Acidobacteria bacterium clone CAL10 23S ribosomal RNA gene, partial sequence | blastn | 25183 | 311 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 27229895 | 27229895 | PRJNA1156092_P_NODE_30143_length_243_cov_0.905882_g30013_i0 | PRJNA1156092 | 30143 | 243 | 0.905882 | 2.20129326 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 115 | 2.75e-28 | NR | MDH3815151.1 | 1978231 | g30013 | i0 | 77.5 | 1.97530864197531 | 80 | 18 | 98.8 | 0 | 2 | 241 | 32 | 111 | MDH3815151.1 YihY family inner membrane protein [Acidobacteriota bacterium] | diamond | 480 | 115 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27767094 | 27767094 | PRJNA1156092_P_NODE_26624_length_247_cov_0.885057_g26494_i0 | PRJNA1156092 | 26624 | 247 | 0.885057 | 2.18609079 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 120 | 4.5000000000000004e-30 | NR | MCG6927167.1 | 1978231 | g26494 | i0 | 78.6 | 0.850202429149798 | 70 | 15 | 85 | 0 | 210 | 1 | 29 | 98 | MCG6927167.1 PQQ-binding-like beta-propeller repeat protein [Acidobacteriota bacterium] | diamond | 210 | 120 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28587977 | 28587977 | PRJNA1156092_P_NODE_28347_length_245_cov_0.895349_g28217_i0 | PRJNA1156092 | 28347 | 245 | 0.895349 | 2.19360505 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 123 | 7.62e-31 | NR | TDI49030.1 | 1978231 | g28217 | i0 | 67.9 | 3.97959183673469 | 81 | 25 | 99.2 | 1 | 1 | 243 | 64 | 143 | TDI49030.1 MAG: GWxTD domain-containing protein [Acidobacteriota bacterium] | diamond | 975 | 123 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28998603 | 28998603 | PRJNA1156092_P_NODE_26268_length_247_cov_0.885057_g26138_i0 | PRJNA1156092 | 26268 | 247 | 0.885057 | 2.18609079 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 167 | 1.11e-48 | NR | MDH3814055.1 | 1978231 | g26138 | i0 | 95.1 | 0.995951417004049 | 82 | 4 | 99.6 | 0 | 2 | 247 | 154 | 235 | MDH3814055.1 phytase [Acidobacteriota bacterium] | diamond | 246 | 167 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29030088 | 29030088 | PRJNA1156092_P_NODE_28368_length_245_cov_0.895349_g28238_i0 | PRJNA1156092 | 28368 | 245 | 0.895349 | 2.19360505 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 73.2 | 7.48e-13 | NR | UCF81106.1 | 1978231 | g28238 | i0 | 44 | 1.02857142857143 | 84 | 42 | 96.7 | 1 | 237 | 1 | 23 | 106 | UCF81106.1 MAG: hypothetical protein JSV08_01400 [Acidobacteriota bacterium] | diamond | 252 | 73.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29187930 | 29187930 | PRJNA1156092_P_NODE_25889_length_247_cov_0.885057_g25759_i0 | PRJNA1156092 | 25889 | 247 | 0.885057 | 2.18609079 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 84.7 | 6.09e-17 | NR | HUR99363.1 | 2283092 | g25759 | i0 | 51.9 | 2.89068825910931 | 79 | 37 | 96 | 1 | 239 | 3 | 103 | 180 | HUR99363.1 FG-GAP-like repeat-containing protein [Pyrinomonadaceae bacterium] | diamond | 714 | 84.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29345639 | 29345639 | PRJNA1156092_P_NODE_31189_length_242_cov_0.911243_g31059_i0 | PRJNA1156092 | 31189 | 242 | 0.911243 | 2.20520806 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 135 | 9.139999999999999e-35 | NR | HEX4948950.1 | 2052146 | g31059 | i0 | 75.9 | 2.91322314049587 | 79 | 19 | 97.9 | 0 | 6 | 242 | 1998 | 2076 | HEX4948950.1 LamG-like jellyroll fold domain-containing protein [Blastocatellia bacterium] | diamond | 705 | 135 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 29648727 | 29648727 | PRJNA1156092_P_NODE_25010_length_248_cov_0.880000_g24880_i0 | PRJNA1156092 | 25010 | 248 | 0.88 | 2.1824 | delta/epsilon subdivisions | 68525 | Bacteria | Bacteria | 102 | 3.179999999999999e-23 | NR | TDI46249.1 | 1978231 | g24880 | i0 | 67.1 | 9.31451612903226 | 70 | 23 | 84.7 | 0 | 38 | 247 | 320 | 389 | TDI46249.1 MAG: 4-coumarate--CoA ligase family protein [Acidobacteriota bacterium] | diamond | 2310 | 102 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29724176 | 29724176 | PRJNA1156092_P_NODE_28510_length_245_cov_0.895349_g28380_i0 | PRJNA1156092 | 28510 | 245 | 0.895349 | 2.19360505 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 43.1 | 0.0274 | NR | MCZ6694927.1 | 1978231 | g28380 | i0 | 38.1 | 0.771428571428571 | 63 | 39 | 77.1 | 0 | 227 | 39 | 158 | 220 | MCZ6694927.1 M24 family metallopeptidase [Acidobacteriota bacterium] | diamond | 189 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29977084 | 29977084 | PRJNA1156092_P_NODE_22811_length_250_cov_1.305085_g22681_i0 | PRJNA1156092 | 22811 | 250 | 1.305085 | 3.2627125 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 151 | 1.2499999999999997e-42 | NR | HEU4927226.1 | 2910147 | g22681 | i0 | 87.8 | 0.984 | 82 | 10 | 98.4 | 0 | 248 | 3 | 157 | 238 | HEU4927226.1 acetylxylan esterase [Vicinamibacterales bacterium] | diamond | 246 | 151 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 30071784 | 30071784 | PRJNA1156092_P_NODE_25872_length_247_cov_0.885057_g25742_i0 | PRJNA1156092 | 25872 | 247 | 0.885057 | 2.18609079 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 45.1 | 0.00611 | NR | HZS08614.1 | 2052146 | g25742 | i0 | 45.8 | 0.582995951417004 | 48 | 26 | 58.3 | 0 | 195 | 52 | 382 | 429 | HZS08614.1 ABC transporter permease [Blastocatellia bacterium] | diamond | 144 | 45.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 31177481 | 31177481 | PRJNA1156092_P_NODE_27095_length_246_cov_0.890173_g26965_i0 | PRJNA1156092 | 27095 | 246 | 0.890173 | 2.18982558 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 63.9 | 1.31e-9 | NR | MEM7249671.1 | 1978231 | g26965 | i0 | 40 | 1.03658536585366 | 85 | 44 | 96.3 | 2 | 3 | 239 | 482 | 565 | MEM7249671.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 255 | 63.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31291884 | 31291884 | PRJNA1156092_P_NODE_26035_length_247_cov_0.885057_g25905_i0 | PRJNA1156092 | 26035 | 247 | 0.885057 | 2.18609079 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 80.1 | 2.62e-15 | NR | MEM9557358.1 | 1978231 | g25905 | i0 | 48.7 | 5.73279352226721 | 76 | 39 | 92.3 | 0 | 237 | 10 | 10 | 85 | MEM9557358.1 sulfatase [Acidobacteriota bacterium] | diamond | 1416 | 80.5 | 0.995031055900621 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31335748 | 31335748 | PRJNA1156092_P_NODE_25576_length_248_cov_0.880000_g25446_i0 | PRJNA1156092 | 25576 | 248 | 0.88 | 2.1824 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 118 | 1.17e-28 | NR | MDH3815530.1 | 1978231 | g25446 | i0 | 65.9 | 1.98387096774194 | 82 | 28 | 99.2 | 0 | 247 | 2 | 755 | 836 | MDH3815530.1 alpha-amylase family glycosyl hydrolase [Acidobacteriota bacterium] | diamond | 492 | 118 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31430686 | 31430686 | PRJNA1156092_P_NODE_24696_length_249_cov_0.875000_g24566_i0 | PRJNA1156092 | 24696 | 249 | 0.875 | 2.17875 | Vicinamibacteria bacterium | 2793154 | Bacteria | Bacteria | 131 | 2.02e-35 | NR | HEX9724601.1 | 2793154 | g24566 | i0 | 77.8 | 4.87951807228916 | 81 | 18 | 97.6 | 0 | 3 | 245 | 190 | 270 | HEX9724601.1 XdhC family protein [Vicinamibacteria bacterium] | diamond | 1215 | 131 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria bacterium | |||||
| 32494370 | 32494370 | PRJNA1156092_P_NODE_32319_length_241_cov_0.916667_g32189_i0 | PRJNA1156092 | 32319 | 241 | 0.916667 | 2.20916747 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 70.5 | 9.1e-13 | NR | MBP1642451.1 | 1978231 | g32189 | i0 | 64.9 | 1.41908713692946 | 57 | 20 | 71 | 0 | 239 | 69 | 121 | 177 | MBP1642451.1 FMN-binding domain protein [Acidobacteriota bacterium] | diamond | 342 | 70.9 | 0.994358251057828 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32538243 | 32538243 | PRJNA1156092_P_NODE_29119_length_244_cov_0.900585_g28989_i0 | PRJNA1156092 | 29119 | 244 | 0.900585 | 2.1974274 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 132 | 8e-35 | NR | TDI35159.1 | 1978231 | g28989 | i0 | 78.5 | 1.9672131147541 | 79 | 17 | 97.1 | 0 | 244 | 8 | 249 | 327 | TDI35159.1 MAG: cation:proton antiporter [Acidobacteriota bacterium] | diamond | 480 | 132 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32695494 | 32695494 | PRJNA1156092_P_NODE_27740_length_246_cov_0.884393_g27610_i0 | PRJNA1156092 | 27740 | 246 | 0.884393 | 2.17560678 | Candidatus Polarisedimenticolia bacterium | 3069555 | Bacteria | Bacteria | 120 | 2.34e-29 | NR | HKY31798.1 | 3069555 | g27610 | i0 | 73.5 | 4.89024390243902 | 83 | 20 | 98.8 | 1 | 244 | 2 | 476 | 558 | HKY31798.1 metallophosphoesterase [Candidatus Polarisedimenticolia bacterium] | diamond | 1203 | 120 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Candidatus Polarisedimenticolia | Candidatus Polarisedimenticolia 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);;