contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Vogeliibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15596194 | 15596194 | PRJNA1148190_P_NODE_277773_length_330_cov_0.898833_g266602_i0 | PRJNA1148190 | 277773 | 330 | 0.898833 | 2.9661489 | Bacteria | 2 | Bacteria | Bacteria | 103 | 2.13e-23 | NR | MCE9628788.1 | 2053638 | g266602 | i0 | 68.5 | 1.96363636363636 | 108 | 31 | 98.2 | 1 | 325 | 2 | 286 | 390 | MCE9628788.1 hypothetical protein [Candidatus Vogelbacteria bacterium] | diamond | 648 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium | ||||||
| 27387522 | 27387522 | PRJNA1148190_P_NODE_484003_length_270_cov_1.116751_g472830_i0 | PRJNA1148190 | 484003 | 270 | 1.116751 | 3.0152277 | Candidatus Vogelbacteria bacterium | 2053638 | Bacteria | Bacteria | 178 | 7.23e-50 | NR | MCE9628792.1 | 2053638 | g472830 | i0 | 96.6 | 0.988888888888889 | 89 | 3 | 98.9 | 0 | 268 | 2 | 274 | 362 | MCE9628792.1 hypothetical protein [Candidatus Vogelbacteria bacterium] | diamond | 267 | 178 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium | ||||||
| 27608540 | 27608540 | PRJNA1148190_P_NODE_508384_length_265_cov_1.322917_g497211_i0 | PRJNA1148190 | 508384 | 265 | 1.322917 | 3.50573005 | Candidatus Vogelbacteria bacterium | 2053638 | Bacteria | Bacteria | 125 | 4.369999999999999e-31 | NR | MCE9628405.1 | 2053638 | g497211 | i0 | 75.9 | 0.984905660377358 | 87 | 21 | 98.5 | 0 | 3 | 263 | 322 | 408 | MCE9628405.1 peptidoglycan-binding protein [Candidatus Vogelbacteria bacterium] | diamond | 261 | 125 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium | ||||||
| 27797609 | 27797609 | PRJNA1148190_P_NODE_252124_length_342_cov_1.628253_g240954_i0 | PRJNA1148190 | 252124 | 342 | 1.628253 | 5.56862526 | Candidatus Vogelbacteria bacterium | 2053638 | Bacteria | Bacteria | 223 | 2.01e-65 | NR | MCE9628794.1 | 2053638 | g240954 | i0 | 93.9 | 1 | 114 | 7 | 100 | 0 | 1 | 342 | 692 | 805 | MCE9628794.1 hypothetical protein [Candidatus Vogelbacteria bacterium] | diamond | 342 | 223 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium | ||||||
| 27880789 | 27880789 | PRJNA1148190_P_NODE_380225_length_290_cov_1.419355_g369052_i0 | PRJNA1148190 | 380225 | 290 | 1.419355 | 4.1161295 | Bacteria | 2 | Bacteria | Bacteria | 60.8 | 2.86e-8 | NR | MBI3633399.1 | 2053638 | g369052 | i0 | 37.5 | 1.87241379310345 | 96 | 59 | 98.3 | 1 | 3 | 287 | 400 | 495 | MBI3633399.1 hypothetical protein [Candidatus Vogelbacteria bacterium] | diamond | 543 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium | ||||||
| 28239080 | 28239080 | PRJNA1148190_P_NODE_150326_length_429_cov_1.297753_g139159_i0 | PRJNA1148190 | 150326 | 429 | 1.297753 | 5.56736037 | Candidatus Vogelbacteria bacterium CG1 | 2053638 | Bacteria | Bacteria | 93.6 | 2.77e-20 | NR | PIR46576.1 | 1975042 | g139159 | i0 | 44.1 | 3.06993006993007 | 111 | 62 | 77.6 | 0 | 334 | 2 | 1 | 111 | PIR46576.1 MAG: hypothetical protein COV07_03535, partial [Candidatus Vogelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_45_14] | diamond | 1317 | 93.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_45_14 | ||||||
| 29313931 | 29313931 | PRJNA1148190_P_NODE_804569_length_228_cov_2.483871_g793396_i0 | PRJNA1148190 | 804569 | 228 | 2.483871 | 5.66322588 | Candidatus Vogelbacteria bacterium RIFOXYB1_FULL_42_16 | 1802436 | Bacteria | Bacteria | 60.5 | 1.78e-8 | NR | OHA57792.1 | 1802436 | g793396 | i0 | 69.7 | 0.434210526315789 | 33 | 10 | 43.4 | 0 | 228 | 130 | 672 | 704 | OHA57792.1 MAG: hypothetical protein A2370_02635 [Candidatus Vogelbacteria bacterium RIFOXYB1_FULL_42_16] | diamond | 99 | 60.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium RIFOXYB1_FULL_42_16 | ||||||
| 29723867 | 29723867 | PRJNA1148190_P_NODE_671830_length_247_cov_0.885057_g660657_i0 | PRJNA1148190 | 671830 | 247 | 0.885057 | 2.18609079 | Candidatus Vogelbacteria bacterium | 2053638 | Bacteria | Bacteria | 107 | 9.17e-25 | NR | MCE9628792.1 | 2053638 | g660657 | i0 | 86.4 | 0.983805668016194 | 81 | 11 | 98.4 | 0 | 245 | 3 | 382 | 462 | MCE9628792.1 hypothetical protein [Candidatus Vogelbacteria bacterium] | diamond | 243 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium | ||||||
| 30576329 | 30576329 | PRJNA1148190_P_NODE_354893_length_299_cov_0.893805_g343720_i0 | PRJNA1148190 | 354893 | 299 | 0.893805 | 2.67247695 | Candidatus Vogelbacteria bacterium | 2053638 | Bacteria | Bacteria | 113 | 2.68e-28 | NR | MCE9628650.1 | 2053638 | g343720 | i0 | 73.6 | 0.722408026755853 | 72 | 19 | 72.2 | 0 | 297 | 82 | 182 | 253 | MCE9628650.1 ZIP family metal transporter [Candidatus Vogelbacteria bacterium] | diamond | 216 | 113 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium | ||||||
| 30797765 | 30797765 | PRJNA1148190_P_NODE_402794_length_286_cov_1.084507_g391621_i0 | PRJNA1148190 | 402794 | 286 | 1.084507 | 3.10169002 | Candidatus Vogelbacteria bacterium CG1 | 2053638 | Bacteria | Bacteria | 108 | 1.03e-25 | NR | PIR44957.1 | 1975045 | g391621 | i0 | 59.8 | 0.965034965034965 | 92 | 37 | 96.5 | 0 | 6 | 281 | 160 | 251 | PIR44957.1 MAG: hypothetical protein COV10_01995 [Candidatus Vogelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_51_16] | diamond | 276 | 108 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_51_16 | ||||||
| 31177369 | 31177369 | PRJNA1148190_P_NODE_783995_length_241_cov_0.916667_g772822_i0 | PRJNA1148190 | 783995 | 241 | 0.916667 | 2.20916747 | Candidatus Vogelbacteria bacterium | 2053638 | Bacteria | Bacteria | 117 | 4.81e-30 | NR | MCE9628549.1 | 2053638 | g772822 | i0 | 98.2 | 0.697095435684647 | 56 | 1 | 69.7 | 0 | 3 | 170 | 253 | 308 | MCE9628549.1 FAD-dependent oxidoreductase [Candidatus Vogelbacteria bacterium] | diamond | 168 | 117 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium | ||||||
| 31682798 | 31682798 | PRJNA1148190_P_NODE_390017_length_288_cov_1.432558_g378844_i0 | PRJNA1148190 | 390017 | 288 | 1.432558 | 4.12576704 | Candidatus Vogelbacteria bacterium | 2053638 | Bacteria | Bacteria | 181 | 1.38e-50 | NR | MCE9628792.1 | 2053638 | g378844 | i0 | 98.9 | 0.989583333333333 | 95 | 1 | 99 | 0 | 3 | 287 | 166 | 260 | MCE9628792.1 hypothetical protein [Candidatus Vogelbacteria bacterium] | diamond | 285 | 181 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium | ||||||
| 31968369 | 31968369 | PRJNA1148190_P_NODE_96398_length_546_cov_1.295983_g85247_i0 | PRJNA1148190 | 96398 | 546 | 1.295983 | 7.07606718 | Candidatus Vogelbacteria bacterium | 2053638 | Bacteria | Bacteria | 351 | 1.11e-113 | NR | MCE9628793.1 | 2053638 | g85247 | i0 | 95.1 | 1 | 182 | 9 | 100 | 0 | 546 | 1 | 521 | 702 | MCE9628793.1 hypothetical protein [Candidatus Vogelbacteria bacterium] | diamond | 546 | 351 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium | ||||||
| 32062251 | 32062251 | PRJNA1148190_P_NODE_216298_length_364_cov_1.494845_g205128_i0 | PRJNA1148190 | 216298 | 364 | 1.494845 | 5.4412358 | Candidatus Vogelbacteria bacterium | 2053638 | Bacteria | Bacteria | 232 | 8.269999999999998e-69 | NR | MCE9628792.1 | 2053638 | g205128 | i0 | 91.7 | 0.997252747252747 | 121 | 10 | 99.7 | 0 | 364 | 2 | 762 | 882 | MCE9628792.1 hypothetical protein [Candidatus Vogelbacteria bacterium] | diamond | 363 | 232 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium | ||||||
| 32348327 | 32348327 | PRJNA1148190_P_NODE_784419_length_241_cov_0.916667_g773246_i0 | PRJNA1148190 | 784419 | 241 | 0.916667 | 2.20916747 | Candidatus Vogelbacteria bacterium CG1 | 2053638 | Bacteria | Bacteria | 117 | 7.34e-31 | NR | PIR45645.1 | 1975044 | g773246 | i0 | 74.7 | 0.983402489626556 | 79 | 20 | 98.3 | 0 | 3 | 239 | 13 | 91 | PIR45645.1 MAG: hypothetical protein COV09_00280 [Candidatus Vogelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_50_13] | diamond | 237 | 117 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Vogeliibacteriota | Candidatus Vogelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_50_13 |
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);;