contig_metadata
14 rows where bioproject = "PRJNA857857", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3787536 | 3787536 | PRJNA857857_P_NODE_28323_length_290_cov_1.903226_g27874_i0 | PRJNA857857 | 28323 | 290 | 1.903226 | 5.5193554 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 433 | 8.21e-117 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g27874 | i0 | 93.793 | 275.610344827586 | 290 | 14 | 99 | 4 | 1 | 288 | 28816 | 29103 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 79927 | 433 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 16538168 | 16538168 | PRJNA857857_P_NODE_22353_length_330_cov_2.252918_g21904_i0 | PRJNA857857 | 22353 | 330 | 2.252918 | 7.4346294 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 566 | 8.97e-157 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g21904 | i0 | 97.576 | 199.281818181818 | 330 | 8 | 100 | 0 | 1 | 330 | 27399 | 27070 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 65763 | 566 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 26611725 | 26611725 | PRJNA857857_P_NODE_40121_length_249_cov_0.875000_g39672_i0 | PRJNA857857 | 40121 | 249 | 0.875 | 2.17875 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 90.1 | 8.43e-19 | NR | MBV9850127.1 | 2033014 | g39672 | i0 | 57.5 | 0.963855421686747 | 80 | 29 | 96.4 | 1 | 6 | 245 | 550 | 624 | MBV9850127.1 hypothetical protein [Armatimonadota bacterium] | diamond | 240 | 90.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26833650 | 26833650 | PRJNA857857_P_NODE_24141_length_318_cov_0.942857_g23692_i0 | PRJNA857857 | 24141 | 318 | 0.942857 | 2.99828526 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 47.4 | 0.00118 | NR | MBI2246800.1 | 2033014 | g23692 | i0 | 41 | 1.45283018867925 | 61 | 36 | 57.5 | 0 | 4 | 186 | 64 | 124 | MBI2246800.1 ankyrin repeat domain-containing protein [Armatimonadota bacterium] | diamond | 462 | 47.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26968264 | 26968264 | PRJNA857857_P_NODE_5022_length_693_cov_2.091935_g4615_i0 | PRJNA857857 | 5022 | 693 | 2.091935 | 14.49710955 | PVC group | 1783257 | Bacteria | Bacteria | 258 | 1.94e-77 | NR | HET6384180.1 | 2033014 | g4615 | i0 | 59.3 | 4.7012987012987 | 209 | 84 | 90.5 | 1 | 628 | 2 | 36 | 243 | HET6384180.1 cellulase family glycosylhydrolase [Armatimonadota bacterium] | diamond | 3258 | 259 | 0.996138996138996 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28570899 | 28570899 | PRJNA857857_P_NODE_25967_length_305_cov_0.995690_g25518_i0 | PRJNA857857 | 25967 | 305 | 0.99569 | 3.0368545 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 47 | 0.00223 | NR | MBA3727350.1 | 2033014 | g25518 | i0 | 36 | 0.737704918032787 | 75 | 47 | 72.8 | 1 | 301 | 80 | 35 | 109 | MBA3727350.1 hypothetical protein [Armatimonadota bacterium] | diamond | 225 | 47 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28823310 | 28823310 | PRJNA857857_P_NODE_7828_length_555_cov_1.275934_g7400_i0 | PRJNA857857 | 7828 | 555 | 1.275934 | 7.0814337 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 56.6 | 1.16e-5 | NR | HET6384180.1 | 2033014 | g7400 | i0 | 33.3 | 0.697297297297297 | 129 | 80 | 69.2 | 5 | 553 | 170 | 350 | 473 | HET6384180.1 cellulase family glycosylhydrolase [Armatimonadota bacterium] | diamond | 387 | 56.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29549585 | 29549585 | PRJNA857857_P_NODE_24630_length_314_cov_1.344398_g24181_i0 | PRJNA857857 | 24630 | 314 | 1.344398 | 4.22140972 | Capsulimonadaceae bacterium | 2953755 | Bacteria | Bacteria | 127 | 1.2e-31 | NR | MDR3709708.1 | 2953755 | g24181 | i0 | 58.3 | 3.93630573248408 | 103 | 43 | 98.4 | 0 | 311 | 3 | 395 | 497 | MDR3709708.1 beta-galactosidase GalA [Capsulimonadaceae bacterium] | diamond | 1236 | 127 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonadaceae bacterium | |||
| 29707194 | 29707194 | PRJNA857857_P_NODE_14610_length_412_cov_0.908555_g14163_i0 | PRJNA857857 | 14610 | 412 | 0.908555 | 3.7432466 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 107 | 5.94e-24 | NR | HLK55891.1 | 2739509 | g14163 | i0 | 45.7 | 1.79126213592233 | 105 | 57 | 76.5 | 0 | 402 | 88 | 712 | 816 | HLK55891.1 DUF5695 domain-containing protein [Chthonomonadaceae bacterium] | diamond | 738 | 107 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 30253020 | 30253020 | PRJNA857857_P_NODE_23612_length_321_cov_1.516129_g23163_i0 | PRJNA857857 | 23612 | 321 | 1.516129 | 4.86677409 | Bacteria | 2 | Bacteria | Bacteria | 60.5 | 5.52e-8 | NR | HET6384180.1 | 2033014 | g23163 | i0 | 35.8 | 3.5607476635514 | 95 | 59 | 87.9 | 2 | 319 | 38 | 332 | 425 | HET6384180.1 cellulase family glycosylhydrolase [Armatimonadota bacterium] | diamond | 1143 | 60.8 | 0.995065789473684 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30466113 | 30466113 | PRJNA857857_P_NODE_24613_length_314_cov_1.721992_g24164_i0 | PRJNA857857 | 24613 | 314 | 1.721992 | 5.40705488 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 82.8 | 7.11e-16 | NR | NSW54790.1 | 2033014 | g24164 | i0 | 47.3 | 0.888535031847134 | 93 | 47 | 88.9 | 1 | 297 | 19 | 40 | 130 | NSW54790.1 cellulase family glycosylhydrolase [Armatimonadota bacterium] | diamond | 279 | 82.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31192136 | 31192136 | PRJNA857857_P_NODE_20695_length_344_cov_1.129151_g20246_i0 | PRJNA857857 | 20695 | 344 | 1.129151 | 3.88427944 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 137 | 4.38e-35 | NR | MBI1332023.1 | 2033014 | g20246 | i0 | 57 | 0.994186046511628 | 114 | 48 | 99.4 | 1 | 1 | 342 | 366 | 478 | MBI1332023.1 carbohydrate-binding protein [Armatimonadota bacterium] | diamond | 342 | 137 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32402859 | 32402859 | PRJNA857857_P_NODE_5599_length_656_cov_2.051458_g5184_i0 | PRJNA857857 | 5599 | 656 | 2.051458 | 13.45756448 | Bacillati | 1783272 | Bacteria | Bacteria | 246 | 3.6e-72 | NR | WP_075165619.1 | 454171 | g5184 | i0 | 52 | 3.07774390243902 | 221 | 99 | 99.7 | 5 | 2 | 655 | 563 | 779 | WP_075165619.1 beta-galactosidase GalA [Chthonomonas calidirosea] | diamond | 2019 | 246 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 32646997 | 32646997 | PRJNA857857_P_NODE_580_length_1627_cov_2.703990_g438_i0 | PRJNA857857 | 580 | 1627 | 2.70399 | 43.9939173 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 108 | 7.290000000000001e-22 | NR | NLI01589.1 | 2282151 | g438 | i0 | 31.5 | 0.833435771358328 | 216 | 145 | 39.8 | 3 | 241 | 888 | 62 | 274 | NLI01589.1 cell wall anchor protein [Chthonomonadales bacterium] | diamond | 1356 | 108 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales 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);;