contig_metadata
21 rows where bioproject = "PRJNA1214993", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10534107 | 10534107 | PRJNA1214993_P_NODE_12449_length_312_cov_2.861925_g12263_i0 | PRJNA1214993 | 12449 | 312 | 2.861925 | 8.929206 | Occallatibacter riparius | 1002689 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2304899767|gb|CP093313.1| | 1002689 | g12263 | i0 | 97.059 | 0.108974358974359 | 34 | 0 | 11 | 1 | 266 | 299 | 6537294 | 6537262 | Occallatibacter riparius strain DSM 25168 chromosome, complete genome | blastn | 34 | 56.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Occallatibacter | Occallatibacter riparius | ||
| 23282481 | 23282481 | PRJNA1214993_P_NODE_22279_length_248_cov_0.891429_g22093_i0 | PRJNA1214993 | 22279 | 248 | 0.891429 | 2.21074392 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 52.8 | 0.022 | NTclustered | gi|2874253802|emb|OY969786.1| | 194844 | g22093 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 159 | 186 | 3433033 | 3433006 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD09671.bin.c.1 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 26819683 | 26819683 | PRJNA1214993_P_NODE_19641_length_253_cov_0.866667_g19455_i0 | PRJNA1214993 | 19641 | 253 | 0.866667 | 2.19266751 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 43.1 | 0.0312 | NR | HYL36525.1 | 2212468 | g19455 | i0 | 35.1 | 0.91304347826087 | 77 | 47 | 87.7 | 1 | 32 | 253 | 153 | 229 | HYL36525.1 pyruvate, phosphate dikinase [Bryobacteraceae bacterium] | diamond | 231 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 26851395 | 26851395 | PRJNA1214993_P_NODE_20641_length_251_cov_0.876404_g20455_i0 | PRJNA1214993 | 20641 | 251 | 0.876404 | 2.19977404 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 42.7 | 0.0403 | NR | MCU1330432.1 | 2026791 | g20455 | i0 | 37.5 | 0.669322709163347 | 56 | 35 | 66.9 | 0 | 250 | 83 | 105 | 160 | MCU1330432.1 lipopolysaccharide biosynthesis protein [Bryobacterales bacterium] | diamond | 168 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 27357290 | 27357290 | PRJNA1214993_P_NODE_18563_length_260_cov_1.315508_g18377_i0 | PRJNA1214993 | 18563 | 260 | 1.315508 | 3.4203208 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 139 | 3.91e-36 | NR | HQU82441.1 | 2283092 | g18377 | i0 | 86.1 | 0.830769230769231 | 72 | 10 | 83.1 | 0 | 1 | 216 | 622 | 693 | HQU82441.1 DUF4365 domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 216 | 139 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27830719 | 27830719 | PRJNA1214993_P_NODE_18124_length_263_cov_1.431579_g17938_i0 | PRJNA1214993 | 18124 | 263 | 1.431579 | 3.76505277 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 43.1 | 0.0331 | NR | MDA1313252.1 | 1978231 | g17938 | i0 | 44.7 | 0.433460076045627 | 38 | 17 | 43.3 | 1 | 128 | 15 | 299 | 332 | MDA1313252.1 glycosyltransferase [Acidobacteriota bacterium] | diamond | 114 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28114814 | 28114814 | PRJNA1214993_P_NODE_21985_length_249_cov_0.875000_g21799_i0 | PRJNA1214993 | 21985 | 249 | 0.875 | 2.17875 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 71.2 | 2.67e-12 | NR | MDA1236654.1 | 1978231 | g21799 | i0 | 43.6 | 0.939759036144578 | 78 | 41 | 90.4 | 2 | 233 | 9 | 182 | 259 | MDA1236654.1 peptidyl-alpha-hydroxyglycine alpha-amidating lyase family protein [Acidobacteriota bacterium] | diamond | 234 | 71.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28430782 | 28430782 | PRJNA1214993_P_NODE_13526_length_300_cov_1.374449_g13340_i0 | PRJNA1214993 | 13526 | 300 | 1.374449 | 4.123347 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 80.1 | 1.46e-16 | NR | HMF01194.1 | 2081523 | g13340 | i0 | 50.6 | 1.74 | 81 | 40 | 81 | 0 | 1 | 243 | 41 | 121 | HMF01194.1 50S ribosomal protein L17 [Terriglobia bacterium] | diamond | 522 | 80.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 28683435 | 28683435 | PRJNA1214993_P_NODE_16387_length_276_cov_1.418719_g16201_i0 | PRJNA1214993 | 16387 | 276 | 1.418719 | 3.91566444 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 152 | 1.84e-42 | NR | HYE75320.1 | 2052146 | g16201 | i0 | 84.6 | 0.989130434782609 | 91 | 14 | 98.9 | 0 | 3 | 275 | 164 | 254 | HYE75320.1 nicotinate phosphoribosyltransferase [Blastocatellia bacterium] | diamond | 273 | 152 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 29522993 | 29522993 | PRJNA1214993_P_NODE_2390_length_678_cov_3.527273_g2216_i0 | PRJNA1214993 | 2390 | 678 | 3.527273 | 23.91491094 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 50.1 | 0.00203 | NR | HEV8435252.1 | 2651171 | g2216 | i0 | 36.7 | 1.58849557522124 | 128 | 64 | 53.5 | 7 | 619 | 257 | 32 | 149 | HEV8435252.1 CVNH domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 1077 | 50.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 29756667 | 29756667 | PRJNA1214993_P_NODE_24291_length_245_cov_0.906977_g24105_i0 | PRJNA1214993 | 24291 | 245 | 0.906977 | 2.22209365 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 87 | 9.57e-18 | NR | HEX8155628.1 | 2651171 | g24105 | i0 | 50 | 4.99591836734694 | 82 | 39 | 98 | 2 | 3 | 242 | 165 | 246 | HEX8155628.1 sulfatase-like hydrolase/transferase [Thermoanaerobaculia bacterium] | diamond | 1224 | 87 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 30262528 | 30262528 | PRJNA1214993_P_NODE_7352_length_398_cov_1.418462_g7166_i0 | PRJNA1214993 | 7352 | 398 | 1.418462 | 5.64547876 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 49.3 | 8.78e-4 | NR | PYQ53668.1 | 1978231 | g7166 | i0 | 50 | 0.731155778894472 | 50 | 25 | 37.7 | 0 | 396 | 247 | 277 | 326 | PYQ53668.1 MAG: hypothetical protein DMF59_01215 [Acidobacteriota bacterium] | diamond | 291 | 49.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30862521 | 30862521 | PRJNA1214993_P_NODE_26074_length_242_cov_0.923077_g25888_i0 | PRJNA1214993 | 26074 | 242 | 0.923077 | 2.23384634 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 88.2 | 1.4e-20 | NR | HEX4593628.1 | 2212468 | g25888 | i0 | 59.5 | 4.73553719008264 | 74 | 30 | 91.7 | 0 | 21 | 242 | 9 | 82 | HEX4593628.1 enoyl-CoA hydratase-related protein [Bryobacteraceae bacterium] | diamond | 1146 | 88.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30894322 | 30894322 | PRJNA1214993_P_NODE_7094_length_405_cov_1.388554_g6909_i0 | PRJNA1214993 | 7094 | 405 | 1.388554 | 5.6236437 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 79.3 | 3.65e-14 | NR | HEY1499184.1 | 2052142 | g6909 | i0 | 32.9 | 1.03703703703704 | 140 | 85 | 97.8 | 3 | 405 | 10 | 442 | 580 | HEY1499184.1 multicopper oxidase domain-containing protein [Acidobacteriaceae bacterium] | diamond | 420 | 79.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 32064089 | 32064089 | PRJNA1214993_P_NODE_7018_length_407_cov_2.574850_g6833_i0 | PRJNA1214993 | 7018 | 407 | 2.57485 | 10.4796395 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 94.4 | 2.2e-19 | NR | HEY3383501.1 | 2910147 | g6833 | i0 | 50.9 | 3.36117936117936 | 106 | 42 | 71.5 | 4 | 15 | 305 | 160 | 264 | HEY3383501.1 NBR1-Ig-like domain-containing protein [Vicinamibacterales bacterium] | diamond | 1368 | 94.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 32159282 | 32159282 | PRJNA1214993_P_NODE_7938_length_384_cov_2.073955_g7752_i0 | PRJNA1214993 | 7938 | 384 | 2.073955 | 7.9639872 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 80.9 | 3.87e-15 | NR | MDR3737318.1 | 2052142 | g7752 | i0 | 41.3 | 0.9453125 | 121 | 68 | 92.2 | 2 | 377 | 24 | 188 | 308 | MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] | diamond | 363 | 80.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 32273067 | 32273067 | PRJNA1214993_P_NODE_21478_length_250_cov_0.870056_g21292_i0 | PRJNA1214993 | 21478 | 250 | 0.870056 | 2.17514 | Bryobacter | 911113 | Bacteria | Bacteria | 77 | 1.03e-14 | NR | WP_155121361.1 | 360054 | g21292 | i0 | 50 | 1.824 | 76 | 38 | 91.2 | 0 | 14 | 241 | 189 | 264 | WP_155121361.1 biotin/lipoyl-containing protein [Bryobacter aggregatus] | diamond | 456 | 77 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacter | Bryobacter aggregatus | ||
| 32412350 | 32412350 | PRJNA1214993_P_NODE_23759_length_246_cov_0.890173_g23573_i0 | PRJNA1214993 | 23759 | 246 | 0.890173 | 2.18982558 | Chloracidobacterium sp. | 2099375 | Bacteria | Bacteria | 135 | 4.4e-37 | NR | MBK9155994.1 | 2099375 | g23573 | i0 | 87.8 | 4.96341463414634 | 82 | 9 | 98.8 | 1 | 244 | 2 | 189 | 270 | MBK9155994.1 GTPase Era [Chloracidobacterium sp.] | diamond | 1221 | 135 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Chloracidobacterium | Chloracidobacterium sp. | ||
| 32539014 | 32539014 | PRJNA1214993_P_NODE_25179_length_243_cov_1.800000_g24993_i0 | PRJNA1214993 | 25179 | 243 | 1.8 | 4.374 | Edaphobacter aggregans | 570835 | Bacteria | Bacteria | 65.5 | 3.68e-10 | NR | WP_125485100.1 | 570835 | g24993 | i0 | 43.6 | 1.8641975308642 | 78 | 42 | 93.8 | 1 | 241 | 14 | 1184 | 1261 | WP_125485100.1 FG-GAP-like repeat-containing protein [Edaphobacter aggregans] | diamond | 453 | 65.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter aggregans | ||
| 32570676 | 32570676 | PRJNA1214993_P_NODE_12079_length_317_cov_1.278689_g11893_i0 | PRJNA1214993 | 12079 | 317 | 1.278689 | 4.05344413 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 70.1 | 8.51e-12 | NR | MEK7723144.1 | 1978231 | g11893 | i0 | 37.9 | 1.88328075709779 | 95 | 59 | 89.9 | 0 | 20 | 304 | 78 | 172 | MEK7723144.1 CAP domain-containing protein [Acidobacteriota bacterium] | diamond | 597 | 70.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32759326 | 32759326 | PRJNA1214993_P_NODE_17520_length_268_cov_0.923077_g17334_i0 | PRJNA1214993 | 17520 | 268 | 0.923077 | 2.47384636 | Vicinamibacteria bacterium | 2793154 | Bacteria | Bacteria | 42.4 | 0.0454 | NR | HJS74420.1 | 2793154 | g17334 | i0 | 35.9 | 0.873134328358209 | 78 | 44 | 81.7 | 4 | 11 | 229 | 40 | 116 | HJS74420.1 rhomboid family intramembrane serine protease [Vicinamibacteria bacterium] | diamond | 234 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria 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);;