contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA773247" and tax_phylum = "Ignavibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26768458 | 26768458 | PRJNA773247_P_NODE_20661_length_314_cov_7.950207_g20577_i0 | PRJNA773247 | 20661 | 314 | 7.950207 | 24.96364998 | Chlorobi bacterium OLB5 | 1617412 | Bacteria | Bacteria | 82 | 3.54e-16 | NR | KXK53801.1 | 1617412 | g20577 | i0 | 43.2 | 0.907643312101911 | 95 | 41 | 90.8 | 2 | 25 | 309 | 8 | 89 | KXK53801.1 MAG: recombination and repair protein RecT [Chlorobi bacterium OLB5] | diamond | 285 | 82 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Candidatus Tepidiaquacellales | Candidatus Tepidiaquacellales bacterium OLB5 | |||
| 27937837 | 27937837 | PRJNA773247_P_NODE_21765_length_304_cov_8.051948_g21681_i0 | PRJNA773247 | 21765 | 304 | 8.051948 | 24.47792192 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 45.8 | 9.87e-4 | NR | RPI00245.1 | 2026749 | g21681 | i0 | 37.3 | 0.661184210526316 | 67 | 37 | 64.1 | 2 | 27 | 221 | 33 | 96 | RPI00245.1 MAG: hypothetical protein EHM64_17340 [Ignavibacteriota bacterium] | diamond | 201 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 27969271 | 27969271 | PRJNA773247_P_NODE_14965_length_384_cov_8.800643_g14881_i0 | PRJNA773247 | 14965 | 384 | 8.800643 | 33.79446912 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 160 | 6.23e-47 | NR | MBV6513871.1 | 2651163 | g14881 | i0 | 58.1 | 0.96875 | 124 | 52 | 96.9 | 0 | 372 | 1 | 78 | 201 | MBV6513871.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 372 | 160 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 28221720 | 28221720 | PRJNA773247_P_NODE_14866_length_386_cov_3.089457_g14782_i0 | PRJNA773247 | 14866 | 386 | 3.089457 | 11.92530402 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 114 | 1.34e-29 | NR | MFA5405010.1 | 2053306 | g14782 | i0 | 52.9 | 0.792746113989637 | 102 | 38 | 79.3 | 2 | 79 | 384 | 4 | 95 | MFA5405010.1 D-Ala-D-Ala carboxypeptidase family metallohydrolase [Ignavibacteria bacterium] | diamond | 306 | 114 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28916296 | 28916296 | PRJNA773247_P_NODE_14508_length_392_cov_6.924765_g14424_i0 | PRJNA773247 | 14508 | 392 | 6.924765 | 27.1450788 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 48.1 | 0.00243 | NR | MDH3267856.1 | 2053306 | g14424 | i0 | 39.1 | 0.918367346938776 | 87 | 35 | 66.6 | 2 | 128 | 388 | 380 | 448 | MDH3267856.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 360 | 48.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28916304 | 28916304 | PRJNA773247_P_NODE_19648_length_324_cov_3.856574_g19564_i0 | PRJNA773247 | 19648 | 324 | 3.856574 | 12.49529976 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 43.5 | 0.0421 | NR | MBV6514254.1 | 2651163 | g19564 | i0 | 37.5 | 0.518518518518518 | 56 | 35 | 51.9 | 0 | 140 | 307 | 160 | 215 | MBV6514254.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 168 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 29011622 | 29011622 | PRJNA773247_P_NODE_27208_length_267_cov_1.417526_g27124_i0 | PRJNA773247 | 27208 | 267 | 1.417526 | 3.78479442 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 82 | 3.21e-17 | NR | MBV6512552.1 | 2651163 | g27124 | i0 | 49.4 | 0.97752808988764 | 87 | 44 | 97.8 | 0 | 267 | 7 | 54 | 140 | MBV6512552.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 261 | 82 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 29421509 | 29421509 | PRJNA773247_P_NODE_12829_length_424_cov_4.632479_g12746_i0 | PRJNA773247 | 12829 | 424 | 4.632479 | 19.64171096 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 47.4 | 0.00653 | NR | MBV6514043.1 | 2651163 | g12746 | i0 | 32.3 | 0.679245283018868 | 96 | 55 | 60.8 | 1 | 136 | 393 | 815 | 910 | MBV6514043.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 288 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 30084788 | 30084788 | PRJNA773247_P_NODE_26592_length_270_cov_3.842640_g26508_i0 | PRJNA773247 | 26592 | 270 | 3.84264 | 10.375128 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 44.7 | 0.0115 | NR | MBD1210647.1 | 2053306 | g26508 | i0 | 39.7 | 0.866666666666667 | 78 | 40 | 84.4 | 2 | 7 | 234 | 436 | 508 | MBD1210647.1 phage tail tape measure protein [Ignavibacteria bacterium] | diamond | 234 | 44.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30464473 | 30464473 | PRJNA773247_P_NODE_18733_length_334_cov_2.704981_g18649_i0 | PRJNA773247 | 18733 | 334 | 2.704981 | 9.03463654 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 97.8 | 2e-21 | NR | MBV6513851.1 | 2651163 | g18649 | i0 | 50.5 | 0.87125748502994 | 97 | 45 | 87.1 | 1 | 304 | 14 | 11 | 104 | MBV6513851.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 291 | 97.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 30874764 | 30874764 | PRJNA773247_P_NODE_15874_length_370_cov_27.461279_g15790_i0 | PRJNA773247 | 15874 | 370 | 27.461279 | 101.6067323 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 96.3 | 9.62e-21 | NR | MBL7127851.1 | 2053306 | g15790 | i0 | 52.3 | 1.38648648648649 | 86 | 39 | 68.9 | 2 | 5 | 259 | 277 | 361 | MBL7127851.1 beta-mannanase [Ignavibacteria bacterium] | diamond | 513 | 96.3 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30874773 | 30874773 | PRJNA773247_P_NODE_22054_length_302_cov_4.366812_g21970_i0 | PRJNA773247 | 22054 | 302 | 4.366812 | 13.18777224 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 47.8 | 1.74e-4 | NR | GJQ44059.1 | 2651163 | g21970 | i0 | 71.8 | 0.387417218543046 | 39 | 10 | 38.7 | 1 | 301 | 185 | 43 | 80 | GJQ44059.1 MAG: hypothetical protein JETCAE03_35570 [Ignavibacteriaceae bacterium] | diamond | 117 | 47.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 31832694 | 31832694 | PRJNA773247_P_NODE_29257_length_256_cov_1.278689_g29173_i0 | PRJNA773247 | 29257 | 256 | 1.278689 | 3.27344384 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 48.1 | 5.51e-4 | NR | MBV6514139.1 | 2651163 | g29173 | i0 | 34.1 | 2.90625 | 82 | 54 | 96.1 | 0 | 10 | 255 | 98 | 179 | MBV6514139.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 744 | 48.5 | 0.991752577319588 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 32054297 | 32054297 | PRJNA773247_P_NODE_8398_length_558_cov_11.292784_g8315_i0 | PRJNA773247 | 8398 | 558 | 11.292784 | 63.01373472 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 57.8 | 1.15e-6 | NR | HRE41945.1 | 2053306 | g8315 | i0 | 48.4 | 1.02688172043011 | 64 | 24 | 34.4 | 3 | 363 | 554 | 24 | 78 | HRE41945.1 HK97 family phage prohead protease [Ignavibacteria bacterium] | diamond | 573 | 57.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 32361492 | 32361492 | PRJNA773247_P_NODE_36059_length_231_cov_2.784810_g35975_i0 | PRJNA773247 | 36059 | 231 | 2.78481 | 6.4329111 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 62 | 2.32e-9 | NR | MBV6514336.1 | 2651163 | g35975 | i0 | 58.3 | 0.779220779220779 | 60 | 21 | 72.7 | 1 | 61 | 228 | 88 | 147 | MBV6514336.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 180 | 62 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 32487957 | 32487957 | PRJNA773247_P_NODE_36339_length_228_cov_4.651613_g36255_i0 | PRJNA773247 | 36339 | 228 | 4.651613 | 10.60567764 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 151 | 4.109999999999999e-43 | NR | MBK7034687.1 | 2053306 | g36255 | i0 | 98.6 | 0.960526315789474 | 73 | 1 | 96.1 | 0 | 226 | 8 | 150 | 222 | MBK7034687.1 metallophosphoesterase family protein [Ignavibacteria bacterium] | diamond | 219 | 151 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria 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);;