contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA879314" and tax_phylum = "Lentisphaerota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12336974 | 12336974 | PRJNA879314_P_NODE_5610_length_251_cov_0.876404_g5560_i0 | PRJNA879314 | 5610 | 251 | 0.876404 | 2.19977404 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 178 | 3.1199999999999998e-52 | NR | MBE6383171.1 | 1932692 | g5560 | i0 | 96.4 | 3.9681274900398402 | 83 | 3 | 99.2 | 0 | 2 | 250 | 210 | 292 | MBE6383171.1 aspartate--tRNA ligase [Lentisphaerota bacterium] | diamond | 996 | 179 | 0.994413407821229 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 13611548 | 13611548 | PRJNA879314_P_NODE_8191_length_247_cov_0.896552_g8141_i0 | PRJNA879314 | 8191 | 247 | 0.896552 | 2.21448344 | Victivallales bacterium | 2212475 | Bacteria | Bacteria | 165 | 2.13e-47 | NR | MBQ6470632.1 | 2212475 | g8141 | i0 | 97.6 | 0.995951417004049 | 82 | 2 | 99.6 | 0 | 1 | 246 | 7 | 88 | MBQ6470632.1 argininosuccinate synthase [Victivallales bacterium] | diamond | 246 | 165 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Victivallales | Victivallales bacterium | |||
| 27181547 | 27181547 | PRJNA879314_P_NODE_4362_length_253_cov_0.866667_g4312_i0 | PRJNA879314 | 4362 | 253 | 0.866667 | 2.19266751 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 70.1 | 1e-11 | NR | NLF22604.1 | 1932692 | g4312 | i0 | 41.3 | 0.948616600790514 | 80 | 47 | 94.9 | 0 | 252 | 13 | 26 | 105 | NLF22604.1 hypothetical protein [Lentisphaerota bacterium] | diamond | 240 | 70.1 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 27221071 | 27221071 | PRJNA879314_P_NODE_6142_length_250_cov_0.881356_g6092_i0 | PRJNA879314 | 6142 | 250 | 0.881356 | 2.20339 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 164 | 5.68e-45 | NR | MBP5586274.1 | 2053569 | g6092 | i0 | 90.4 | 2.988 | 83 | 8 | 99.6 | 0 | 250 | 2 | 467 | 549 | MBP5586274.1 hypothetical protein [Lentisphaeria bacterium] | diamond | 747 | 164 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 27276686 | 27276686 | PRJNA879314_P_NODE_9023_length_246_cov_0.895954_g8973_i0 | PRJNA879314 | 9023 | 246 | 0.895954 | 2.20404684 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 166 | 1.08e-45 | NR | MDD6338214.1 | 2053569 | g8973 | i0 | 98.8 | 2.96341463414634 | 81 | 1 | 98.8 | 0 | 245 | 3 | 692 | 772 | MDD6338214.1 glycoside hydrolase N-terminal domain-containing protein [Lentisphaeria bacterium] | diamond | 729 | 166 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 27403067 | 27403067 | PRJNA879314_P_NODE_10963_length_242_cov_0.923077_g10913_i0 | PRJNA879314 | 10963 | 242 | 0.923077 | 2.23384634 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 164 | 4.14e-46 | NR | MBR4716542.1 | 2053569 | g10913 | i0 | 97.5 | 0.991735537190083 | 80 | 2 | 99.2 | 0 | 3 | 242 | 273 | 352 | MBR4716542.1 hypothetical protein [Lentisphaeria bacterium] | diamond | 240 | 164 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 27719134 | 27719134 | PRJNA879314_P_NODE_4584_length_253_cov_0.866667_g4534_i0 | PRJNA879314 | 4584 | 253 | 0.866667 | 2.19266751 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 160 | 1.6e-47 | NR | MBR2962817.1 | 2053569 | g4534 | i0 | 95.2 | 0.984189723320158 | 83 | 4 | 98.4 | 0 | 251 | 3 | 9 | 91 | MBR2962817.1 16S rRNA (uracil(1498)-N(3))-methyltransferase [Lentisphaeria bacterium] | diamond | 249 | 160 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 27789983 | 27789983 | PRJNA879314_P_NODE_6364_length_250_cov_0.881356_g6314_i0 | PRJNA879314 | 6364 | 250 | 0.881356 | 2.20339 | Bacteria | 2 | Bacteria | Bacteria | 156 | 1.06e-45 | NR | MBE6408494.1 | 1932692 | g6314 | i0 | 90.4 | 11.952 | 83 | 8 | 99.6 | 0 | 249 | 1 | 124 | 206 | MBE6408494.1 sugar isomerase domain-containing protein [Lentisphaerota bacterium] | diamond | 2988 | 157 | 0.993630573248408 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 27844834 | 27844834 | PRJNA879314_P_NODE_6204_length_250_cov_0.881356_g6154_i0 | PRJNA879314 | 6204 | 250 | 0.881356 | 2.20339 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 63.5 | 1.98e-9 | NR | MBR4717680.1 | 2053569 | g6154 | i0 | 42.5 | 1.044 | 87 | 43 | 98.4 | 3 | 250 | 5 | 1770 | 1854 | MBR4717680.1 AIDA repeat-containing protein [Lentisphaeria bacterium] | diamond | 261 | 63.5 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 27844838 | 27844838 | PRJNA879314_P_NODE_7264_length_248_cov_0.891429_g7214_i0 | PRJNA879314 | 7264 | 248 | 0.891429 | 2.21074392 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 82.8 | 3.24e-16 | NR | MBP5584721.1 | 2053569 | g7214 | i0 | 57.3 | 0.991935483870968 | 82 | 31 | 94.4 | 1 | 240 | 7 | 2800 | 2881 | MBP5584721.1 hypothetical protein [Lentisphaeria bacterium] | diamond | 246 | 82.8 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 28539869 | 28539869 | PRJNA879314_P_NODE_7367_length_248_cov_0.891429_g7317_i0 | PRJNA879314 | 7367 | 248 | 0.891429 | 2.21074392 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 151 | 2.85e-40 | NR | MBE6382308.1 | 1932692 | g7317 | i0 | 85.2 | 0.979838709677419 | 81 | 12 | 98 | 0 | 3 | 245 | 633 | 713 | MBE6382308.1 hypothetical protein [Lentisphaerota bacterium] | diamond | 243 | 151 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 28666063 | 28666063 | PRJNA879314_P_NODE_9407_length_245_cov_0.906977_g9357_i0 | PRJNA879314 | 9407 | 245 | 0.906977 | 2.22209365 | Victivallales bacterium | 2212475 | Bacteria | Bacteria | 140 | 1.15e-38 | NR | MDD5729238.1 | 2212475 | g9357 | i0 | 85.2 | 0.991836734693878 | 81 | 12 | 99.2 | 0 | 244 | 2 | 53 | 133 | MDD5729238.1 carbohydrate kinase family protein [Victivallales bacterium] | diamond | 243 | 140 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Victivallales | Victivallales bacterium | |||
| 29202813 | 29202813 | PRJNA879314_P_NODE_4709_length_253_cov_0.866667_g4659_i0 | PRJNA879314 | 4709 | 253 | 0.866667 | 2.19266751 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 136 | 6.33e-36 | NR | MBR2963128.1 | 2053569 | g4659 | i0 | 82.6 | 1.9802371541502 | 86 | 13 | 99.6 | 1 | 252 | 1 | 388 | 473 | MBR2963128.1 hypothetical protein [Lentisphaeria bacterium] | diamond | 501 | 136 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 29210846 | 29210846 | PRJNA879314_P_NODE_6349_length_250_cov_0.881356_g6299_i0 | PRJNA879314 | 6349 | 250 | 0.881356 | 2.20339 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 125 | 3.8999999999999997e-31 | NR | MBE6397043.1 | 1932692 | g6299 | i0 | 61.9 | 4.02 | 84 | 31 | 99.6 | 1 | 2 | 250 | 336 | 419 | MBE6397043.1 hypothetical protein [Lentisphaerota bacterium] | diamond | 1005 | 125 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 29265634 | 29265634 | PRJNA879314_P_NODE_3109_length_284_cov_0.862559_g3059_i0 | PRJNA879314 | 3109 | 284 | 0.862559 | 2.44966756 | Victivallales bacterium | 2212475 | Bacteria | Bacteria | 167 | 1.8e-46 | NR | MBQ7650475.1 | 2212475 | g3059 | i0 | 95.2 | 0.876760563380282 | 83 | 4 | 87.7 | 0 | 2 | 250 | 580 | 662 | MBQ7650475.1 beta-galactosidase trimerization domain-containing protein [Victivallales bacterium] | diamond | 249 | 167 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Victivallales | Victivallales bacterium | |||
| 29360590 | 29360590 | PRJNA879314_P_NODE_10249_length_244_cov_0.883041_g10199_i0 | PRJNA879314 | 10249 | 244 | 0.883041 | 2.15462004 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 163 | 1.7199999999999998e-45 | NR | MBE6382495.1 | 1932692 | g10199 | i0 | 97.5 | 0.995901639344262 | 81 | 2 | 99.6 | 0 | 2 | 244 | 139 | 219 | MBE6382495.1 hypothetical protein [Lentisphaerota bacterium] | diamond | 243 | 163 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 29423490 | 29423490 | PRJNA879314_P_NODE_8169_length_247_cov_0.896552_g8119_i0 | PRJNA879314 | 8169 | 247 | 0.896552 | 2.21448344 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 165 | 3.81e-46 | NR | MBE6384004.1 | 1932692 | g8119 | i0 | 100 | 0.995951417004049 | 82 | 0 | 99.6 | 0 | 2 | 247 | 180 | 261 | MBE6384004.1 hypothetical protein [Lentisphaerota bacterium] | diamond | 246 | 165 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 29802511 | 29802511 | PRJNA879314_P_NODE_5251_length_252_cov_0.871508_g5201_i0 | PRJNA879314 | 5251 | 252 | 0.871508 | 2.19620016 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 132 | 2.7e-37 | NR | MBP5531509.1 | 2053569 | g5201 | i0 | 74.1 | 0.964285714285714 | 81 | 21 | 96.4 | 0 | 244 | 2 | 68 | 148 | MBP5531509.1 hypothetical protein [Lentisphaeria bacterium] | diamond | 243 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 30245025 | 30245025 | PRJNA879314_P_NODE_4532_length_253_cov_0.866667_g4482_i0 | PRJNA879314 | 4532 | 253 | 0.866667 | 2.19266751 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 61.6 | 8.78e-9 | NR | UKI33507.1 | 2053569 | g4482 | i0 | 41.1 | 0.865612648221344 | 73 | 43 | 86.6 | 0 | 26 | 244 | 2 | 74 | UKI33507.1 MAG: hypothetical protein L6W00_08750 [Lentisphaeria bacterium] | diamond | 219 | 61.6 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 30276800 | 30276800 | PRJNA879314_P_NODE_4952_length_252_cov_0.871508_g4902_i0 | PRJNA879314 | 4952 | 252 | 0.871508 | 2.19620016 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 68.2 | 3.48e-11 | NR | MEI6425278.1 | 1932692 | g4902 | i0 | 64.6 | 0.571428571428571 | 48 | 17 | 57.1 | 0 | 2 | 145 | 286 | 333 | MEI6425278.1 prolyl oligopeptidase family serine peptidase [Lentisphaerota bacterium] | diamond | 144 | 68.2 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 30466354 | 30466354 | PRJNA879314_P_NODE_10813_length_243_cov_0.888235_g10763_i0 | PRJNA879314 | 10813 | 243 | 0.888235 | 2.15841105 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 149 | 1.25e-39 | NR | MBP5586808.1 | 2053569 | g10763 | i0 | 84 | 1 | 81 | 12 | 98.8 | 1 | 2 | 241 | 558 | 638 | MBP5586808.1 hypothetical protein [Lentisphaeria bacterium] | diamond | 243 | 149 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 31003246 | 31003246 | PRJNA879314_P_NODE_9314_length_245_cov_0.906977_g9264_i0 | PRJNA879314 | 9314 | 245 | 0.906977 | 2.22209365 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 52 | 2.14e-5 | NR | NLN02541.1 | 1932692 | g9264 | i0 | 37.5 | 1.07755102040816 | 88 | 48 | 99.2 | 2 | 244 | 2 | 1269 | 1356 | NLN02541.1 hypothetical protein [Lentisphaerota bacterium] | diamond | 264 | 52 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 31129190 | 31129190 | PRJNA879314_P_NODE_7015_length_249_cov_0.886364_g6965_i0 | PRJNA879314 | 7015 | 249 | 0.886364 | 2.20704636 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 139 | 1.28e-37 | NR | MBP5585889.1 | 2053569 | g6965 | i0 | 89 | 0.987951807228916 | 82 | 9 | 98.8 | 0 | 2 | 247 | 123 | 204 | MBP5585889.1 efflux RND transporter periplasmic adaptor subunit [Lentisphaeria bacterium] | diamond | 246 | 139 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 31168922 | 31168922 | PRJNA879314_P_NODE_10175_length_244_cov_0.912281_g10125_i0 | PRJNA879314 | 10175 | 244 | 0.912281 | 2.22596564 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 140 | 2.989999999999999e-38 | NR | MBE6397515.1 | 1932692 | g10125 | i0 | 88.9 | 2.98770491803279 | 81 | 9 | 99.6 | 0 | 244 | 2 | 279 | 359 | MBE6397515.1 rod shape-determining protein RodA [Lentisphaerota bacterium] | diamond | 729 | 141 | 0.99290780141844 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 31888490 | 31888490 | PRJNA879314_P_NODE_6677_length_249_cov_0.886364_g6627_i0 | PRJNA879314 | 6677 | 249 | 0.886364 | 2.20704636 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 166 | 1.22e-45 | NR | MBE6382140.1 | 1932692 | g6627 | i0 | 92.8 | 1 | 83 | 6 | 100 | 0 | 249 | 1 | 423 | 505 | MBE6382140.1 hypothetical protein [Lentisphaerota bacterium] | diamond | 249 | 166 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 32553340 | 32553340 | PRJNA879314_P_NODE_10379_length_243_cov_0.917647_g10329_i0 | PRJNA879314 | 10379 | 243 | 0.917647 | 2.22988221 | Victivallales bacterium | 2212475 | Bacteria | Bacteria | 150 | 2.929999999999999e-41 | NR | MBO7093208.1 | 2212475 | g10329 | i0 | 96.2 | 0.975308641975309 | 79 | 3 | 97.5 | 0 | 6 | 242 | 22 | 100 | MBO7093208.1 MBOAT family protein [Victivallales bacterium] | diamond | 237 | 150 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Victivallales | Victivallales bacterium | |||
| 32875896 | 32875896 | PRJNA879314_P_NODE_5180_length_252_cov_0.871508_g5130_i0 | PRJNA879314 | 5180 | 252 | 0.871508 | 2.19620016 | Bacteria | 2 | Bacteria | Bacteria | 110 | 4.44e-26 | NR | MBE6378109.1 | 1932692 | g5130 | i0 | 67.1 | 1.9047619047619 | 79 | 26 | 94 | 0 | 14 | 250 | 99 | 177 | MBE6378109.1 peptidase domain-containing ABC transporter [Lentisphaerota bacterium] | diamond | 480 | 110 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota 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);;