contig_metadata
11 rows where bioproject = "PRJNA550047", tax_clade = "PVC group" and tax_phylum = "Candidatus Omnitrophota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 518284 | 518284 | PRJNA550047_P_NODE_60201_length_345_cov_14.900735_g58241_i0 | PRJNA550047 | 60201 | 345 | 14.900735 | 51.40753575 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 92.4 | 4.74e-19 | NR | MBI5149160.1 | 2035772 | g58241 | i0 | 76 | 1.7304347826087 | 50 | 11 | 42.6 | 1 | 342 | 196 | 327 | 376 | MBI5149160.1 DUF3536 domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 597 | 92.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 26983117 | 26983117 | PRJNA550047_P_NODE_391502_length_268_cov_8.794872_g389530_i0 | PRJNA550047 | 391502 | 268 | 8.794872 | 23.57025696 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 66.6 | 2.01e-10 | NR | MBU4311117.1 | 2035772 | g389530 | i0 | 47.4 | 0.638059701492537 | 57 | 30 | 63.8 | 0 | 8 | 178 | 731 | 787 | MBU4311117.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 171 | 66.6 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28088792 | 28088792 | PRJNA550047_P_NODE_86385_length_345_cov_9.871324_g84425_i0 | PRJNA550047 | 86385 | 345 | 9.871324 | 34.0560678 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 94.7 | 6.53e-20 | NR | HOW43150.1 | 2035772 | g84425 | i0 | 95.8 | 0.417391304347826 | 48 | 2 | 41.7 | 0 | 200 | 343 | 247 | 294 | HOW43150.1 recombinase family protein [Candidatus Omnitrophota bacterium] | diamond | 144 | 94.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28152156 | 28152156 | PRJNA550047_P_NODE_460065_length_244_cov_0.912281_g458092_i0 | PRJNA550047 | 460065 | 244 | 0.912281 | 2.22596564 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 95.5 | 2.9700000000000003e-21 | NR | MFH1594235.1 | 2035772 | g458092 | i0 | 56.4 | 0.959016393442623 | 78 | 32 | 93.4 | 1 | 230 | 3 | 1 | 78 | MFH1594235.1 tRNA preQ1(34) S-adenosylmethionine ribosyltransferase-isomerase QueA [Candidatus Omnitrophota bacterium] | diamond | 234 | 95.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28152207 | 28152207 | PRJNA550047_P_NODE_55965_length_345_cov_16.790441_g54005_i0 | PRJNA550047 | 55965 | 345 | 16.790441 | 57.92702145 | Candidatus Omnitrophica bacterium CG | 2035772 | Bacteria | Bacteria | 52.8 | 3.64e-5 | NR | PIU40630.1 | 1974742 | g54005 | i0 | 60.5 | 0.373913043478261 | 43 | 17 | 37.4 | 0 | 150 | 22 | 466 | 508 | PIU40630.1 MAG: hypothetical protein COT00_00710, partial [Candidatus Omnitrophica bacterium CG07_land_8_20_14_0_80_50_8] | diamond | 129 | 52.8 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophica bacterium CG07_land_8_20_14_0_80_50_8 | |||||
| 29067815 | 29067815 | PRJNA550047_P_NODE_603808_length_197_cov_5.225806_g601835_i0 | PRJNA550047 | 603808 | 197 | 5.225806 | 10.29483782 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 76.6 | 2.28e-14 | NR | MFH0855267.1 | 2035772 | g601835 | i0 | 64.4 | 0.898477157360406 | 59 | 21 | 89.8 | 0 | 13 | 189 | 17 | 75 | MFH0855267.1 glycoside hydrolase family 2 TIM barrel-domain containing protein [Candidatus Omnitrophota bacterium] | diamond | 177 | 76.6 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30172783 | 30172783 | PRJNA550047_P_NODE_387532_length_270_cov_3.390863_g385560_i0 | PRJNA550047 | 387532 | 270 | 3.390863 | 9.1553301 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 176 | 3.57e-51 | NR | MDP3704181.1 | 2035772 | g385560 | i0 | 95.6 | 3 | 90 | 4 | 100 | 0 | 270 | 1 | 80 | 169 | MDP3704181.1 recombinase family protein [Candidatus Omnitrophota bacterium] | diamond | 810 | 176 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30236004 | 30236004 | PRJNA550047_P_NODE_282212_length_299_cov_2.491150_g280243_i0 | PRJNA550047 | 282212 | 299 | 2.49115 | 7.4485385 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 45.1 | 0.0108 | NR | MCB9746782.1 | 2035772 | g280243 | i0 | 33 | 1.06354515050167 | 106 | 47 | 99.3 | 2 | 3 | 299 | 189 | 277 | MCB9746782.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 318 | 45.1 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30236150 | 30236150 | PRJNA550047_P_NODE_64532_length_345_cov_13.617647_g62572_i0 | PRJNA550047 | 64532 | 345 | 13.617647 | 46.98088215 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 59.3 | 1.92e-7 | NR | MBU2102352.1 | 2035772 | g62572 | i0 | 56 | 0.434782608695652 | 50 | 22 | 43.5 | 0 | 1 | 150 | 687 | 736 | MBU2102352.1 ATP-binding protein [Candidatus Omnitrophota bacterium] | diamond | 150 | 59.3 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32133018 | 32133018 | PRJNA550047_P_NODE_406798_length_262_cov_9.835979_g404826_i0 | PRJNA550047 | 406798 | 262 | 9.835979 | 25.77026498 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 91.7 | 3.59e-20 | NR | MCL5096915.1 | 2035772 | g404826 | i0 | 57.3 | 0.938931297709924 | 82 | 35 | 93.9 | 0 | 3 | 248 | 41 | 122 | MCL5096915.1 PfkB family carbohydrate kinase [Candidatus Omnitrophota bacterium] | diamond | 246 | 91.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32764605 | 32764605 | PRJNA550047_P_NODE_290300_length_298_cov_7.111111_g288331_i0 | PRJNA550047 | 290300 | 298 | 7.111111 | 21.19111078 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 92 | 3.54e-19 | NR | HAZ10859.1 | 2035772 | g288331 | i0 | 76.6 | 0.644295302013423 | 64 | 10 | 64.4 | 1 | 296 | 105 | 6493 | 6551 | HAZ10859.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 192 | 92 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota 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);;