contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Atribacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26659996 | 26659996 | PRJNA1148190_P_NODE_767641_length_242_cov_0.911243_g756468_i0 | PRJNA1148190 | 767641 | 242 | 0.911243 | 2.20520806 | Atribacterota bacterium | 2952890 | Bacteria | Bacteria | 57.4 | 2.44e-7 | NR | MDD4362818.1 | 2952890 | g756468 | i0 | 40 | 5.13223140495868 | 55 | 33 | 68.2 | 0 | 241 | 77 | 305 | 359 | MDD4362818.1 patatin-like phospholipase family protein [Atribacterota bacterium] | diamond | 1242 | 57.4 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacterota bacterium | ||||||
| 26691681 | 26691681 | PRJNA1148190_P_NODE_644801_length_248_cov_0.880000_g633628_i0 | PRJNA1148190 | 644801 | 248 | 0.88 | 2.1824 | Atribacterota bacterium | 2952890 | Bacteria | Bacteria | 82.4 | 4.08e-16 | NR | HNR65325.1 | 2952890 | g633628 | i0 | 74.2 | 0.798387096774194 | 66 | 17 | 79.8 | 0 | 199 | 2 | 76 | 141 | HNR65325.1 hypothetical protein [Atribacterota bacterium] | diamond | 198 | 82.4 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacterota bacterium | ||||||
| 27134505 | 27134505 | PRJNA1148190_P_NODE_705662_length_245_cov_0.895349_g694489_i0 | PRJNA1148190 | 705662 | 245 | 0.895349 | 2.19360505 | Candidatus Atribacteria bacterium | 2053509 | Bacteria | Bacteria | 71.2 | 3.42e-12 | NR | NSW76053.1 | 2053509 | g694489 | i0 | 44.3 | 2.77959183673469 | 79 | 42 | 94.3 | 1 | 4 | 234 | 47 | 125 | NSW76053.1 hypothetical protein [Candidatus Atribacteria bacterium] | diamond | 681 | 71.2 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacteria | Candidatus Atribacteria bacterium | |||||
| 27165573 | 27165573 | PRJNA1148190_P_NODE_264862_length_336_cov_1.083650_g253691_i0 | PRJNA1148190 | 264862 | 336 | 1.08365 | 3.641064 | Atribacterota bacterium | 2952890 | Bacteria | Bacteria | 75.5 | 2.16e-13 | NR | MEI6157688.1 | 2952890 | g253691 | i0 | 36.2 | 2.61607142857143 | 94 | 59 | 83.9 | 1 | 286 | 5 | 202 | 294 | MEI6157688.1 recombinase RecA [Atribacterota bacterium] | diamond | 879 | 75.5 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacterota bacterium | ||||||
| 27734424 | 27734424 | PRJNA1148190_P_NODE_170204_length_404_cov_1.734139_g159035_i0 | PRJNA1148190 | 170204 | 404 | 1.734139 | 7.00592156 | Atribacterota bacterium | 2952890 | Bacteria | Bacteria | 116 | 1.1300000000000002e-27 | NR | MDD5013550.1 | 2952890 | g159035 | i0 | 45.3 | 1.01732673267327 | 137 | 60 | 96.5 | 4 | 1 | 390 | 61 | 189 | MDD5013550.1 hypothetical protein [Atribacterota bacterium] | diamond | 411 | 116 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacterota bacterium | ||||||
| 28081258 | 28081258 | PRJNA1148190_P_NODE_127865_length_466_cov_1.567430_g116702_i0 | PRJNA1148190 | 127865 | 466 | 1.56743 | 7.3042238 | Candidatus Atribacteria bacterium | 2053509 | Bacteria | Bacteria | 66.6 | 1.57e-9 | NR | HEC92924.1 | 2053509 | g116702 | i0 | 34.5 | 2.05364806866953 | 113 | 66 | 72.1 | 3 | 466 | 131 | 16 | 121 | HEC92924.1 glycosyltransferase family 2 protein [Candidatus Atribacteria bacterium] | diamond | 957 | 66.6 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacteria | Candidatus Atribacteria bacterium | |||||
| 28871065 | 28871065 | PRJNA1148190_P_NODE_38528_length_1045_cov_1.860082_g28213_i0 | PRJNA1148190 | 38528 | 1045 | 1.860082 | 19.4378569 | Candidatus Atribacteria bacterium | 2053509 | Bacteria | Bacteria | 77 | 4.02e-12 | NR | MBE3037003.1 | 2053509 | g28213 | i0 | 41.3 | 0.264114832535885 | 92 | 49 | 25 | 2 | 1 | 261 | 140 | 231 | MBE3037003.1 alpha-1,2-fucosyltransferase [Candidatus Atribacteria bacterium] | diamond | 276 | 77 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacteria | Candidatus Atribacteria bacterium | |||||
| 29060865 | 29060865 | PRJNA1148190_P_NODE_454908_length_275_cov_1.752475_g443735_i0 | PRJNA1148190 | 454908 | 275 | 1.752475 | 4.81930625 | Atribacterota bacterium | 2952890 | Bacteria | Bacteria | 69.7 | 1.63e-13 | NR | MDD5015780.1 | 2952890 | g443735 | i0 | 46.6 | 1.17818181818182 | 58 | 31 | 63.3 | 0 | 220 | 47 | 8 | 65 | MDD5015780.1 hypothetical protein [Atribacterota bacterium] | diamond | 324 | 69.7 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacterota bacterium | ||||||
| 29408219 | 29408219 | PRJNA1148190_P_NODE_59349_length_747_cov_2.661721_g48365_i0 | PRJNA1148190 | 59349 | 747 | 2.661721 | 19.88305587 | Candidatus Atribacteria bacterium | 2053509 | Bacteria | Bacteria | 141 | 1.0399999999999998e-37 | NR | MBE3117320.1 | 2053509 | g48365 | i0 | 50.9 | 0.694779116465863 | 173 | 77 | 67.5 | 4 | 227 | 730 | 1 | 170 | MBE3117320.1 hypothetical protein [Candidatus Atribacteria bacterium] | diamond | 519 | 141 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacteria | Candidatus Atribacteria bacterium | |||||
| 29787259 | 29787259 | PRJNA1148190_P_NODE_73511_length_646_cov_1.249564_g62410_i0 | PRJNA1148190 | 73511 | 646 | 1.249564 | 8.07218344 | Candidatus Atribacteria bacterium | 2053509 | Bacteria | Bacteria | 78.2 | 1.88e-13 | NR | MBE3037003.1 | 2053509 | g62410 | i0 | 28.9 | 0.770897832817337 | 166 | 99 | 72 | 6 | 480 | 16 | 1 | 158 | MBE3037003.1 alpha-1,2-fucosyltransferase [Candidatus Atribacteria bacterium] | diamond | 498 | 78.2 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacteria | Candidatus Atribacteria bacterium | |||||
| 30070898 | 30070898 | PRJNA1148190_P_NODE_34612_length_1145_cov_4.167910_g24557_i0 | PRJNA1148190 | 34612 | 1145 | 4.16791 | 47.7225695 | Candidatus Atribacter allofermentans | 1852833 | Bacteria | Bacteria | 71.6 | 1.74e-9 | NR | OQA61619.1 | 1852833 | g24557 | i0 | 26.2 | 0.720524017467249 | 275 | 182 | 67.9 | 6 | 1138 | 362 | 190 | 459 | OQA61619.1 MAG: hypothetical protein BWY41_00046 [Candidatus Atribacter allofermentans] | diamond | 825 | 71.6 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacteria | Atribacterales | Atribacteraceae | Atribacter | Candidatus Atribacter allofermentans | ||
| 30071682 | 30071682 | PRJNA1148190_P_NODE_789032_length_241_cov_0.916667_g777859_i0 | PRJNA1148190 | 789032 | 241 | 0.916667 | 2.20916747 | Candidatus Atribacteria bacterium HGW-Atribacteria-1 | 2013676 | Bacteria | Bacteria | 84.7 | 1.21e-19 | NR | PKP58027.1 | 2013676 | g777859 | i0 | 75 | 0.697095435684647 | 56 | 14 | 69.7 | 0 | 74 | 241 | 1 | 56 | PKP58027.1 MAG: hypothetical protein CVT91_09390 [Candidatus Atribacteria bacterium HGW-Atribacteria-1] | diamond | 168 | 84.7 | 1 | Bacteria | Pseudomonadati | Atribacterota | Candidatus Atribacteria bacterium HGW-Atribacteria-1 | ||||||
| 30122586 | 30122586 | PRJNA1148190_P_NODE_190092_length_385_cov_0.987179_g178922_i0 | PRJNA1148190 | 190092 | 385 | 0.987179 | 3.80063915 | Bacteria | 2 | Bacteria | Bacteria | 48.5 | 6.13e-4 | NR | MCX6089950.1 | 2053509 | g178922 | i0 | 31.4 | 2.57922077922078 | 86 | 54 | 63.1 | 2 | 89 | 331 | 72 | 157 | MCX6089950.1 hypothetical protein [Candidatus Atribacteria bacterium] | diamond | 993 | 48.5 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacteria | Candidatus Atribacteria bacterium | |||||
| 30671047 | 30671047 | PRJNA1148190_P_NODE_227733_length_356_cov_1.964664_g216563_i0 | PRJNA1148190 | 227733 | 356 | 1.964664 | 6.99420384 | Candidatus Infernicultor aquiphilus | 1805029 | Bacteria | Bacteria | 102 | 2.4699999999999994e-23 | NR | WP_406608253.1 | 1805029 | g216563 | i0 | 48 | 1.8876404494382 | 102 | 51 | 85.1 | 2 | 51 | 353 | 149 | 249 | WP_406608253.1 exostosin domain-containing protein, partial [Candidatus Infernicultor aquiphilus] | diamond | 672 | 102 | 1 | Bacteria | Pseudomonadati | Atribacterota | Candidatus Phoenicimicrobiia | Candidatus Pheonicimicrobiales | Candidatus Phoenicimicrobiaceae | Candidatus Infernicultor | Candidatus Infernicultor aquiphilus | ||
| 30924562 | 30924562 | PRJNA1148190_P_NODE_469774_length_272_cov_2.040201_g458601_i0 | PRJNA1148190 | 469774 | 272 | 2.040201 | 5.54934672 | Candidatus Atribacteria bacterium | 2053509 | Bacteria | Bacteria | 121 | 7.99e-32 | NR | MBE3120152.1 | 2053509 | g458601 | i0 | 60.5 | 2.95588235294118 | 86 | 33 | 93.8 | 1 | 272 | 18 | 105 | 190 | MBE3120152.1 site-specific DNA-methyltransferase [Candidatus Atribacteria bacterium] | diamond | 804 | 121 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacteria | Candidatus Atribacteria bacterium | |||||
| 31050764 | 31050764 | PRJNA1148190_P_NODE_332095_length_307_cov_1.316239_g320922_i0 | PRJNA1148190 | 332095 | 307 | 1.316239 | 4.04085373 | Candidatus Atribacteria bacterium 1244-E1 | 2053509 | Bacteria | Bacteria | 141 | 6.68e-39 | NR | RXG65587.1 | 2019525 | g320922 | i0 | 69.3 | 5.92182410423453 | 101 | 31 | 98.7 | 0 | 305 | 3 | 186 | 286 | RXG65587.1 MAG: site-specific integrase [Candidatus Atribacteria bacterium 1244-E10-H5-B2] | diamond | 1818 | 141 | 1 | Bacteria | Pseudomonadati | Atribacterota | Candidatus Atribacteria bacterium 1244-E10-H5-B2 | ||||||
| 31114033 | 31114033 | PRJNA1148190_P_NODE_669515_length_247_cov_0.885057_g658342_i0 | PRJNA1148190 | 669515 | 247 | 0.885057 | 2.18609079 | Atribacterota bacterium | 2952890 | Bacteria | Bacteria | 129 | 1.29e-33 | NR | MDY0134218.1 | 2952890 | g658342 | i0 | 89.3 | 0.910931174089069 | 75 | 8 | 91.1 | 0 | 225 | 1 | 23 | 97 | MDY0134218.1 SIR2 family protein [Atribacterota bacterium] | diamond | 225 | 129 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacterota bacterium | ||||||
| 31334437 | 31334437 | PRJNA1148190_P_NODE_108176_length_511_cov_1.550228_g97017_i0 | PRJNA1148190 | 108176 | 511 | 1.550228 | 7.92166508 | Candidatus Atribacteria bacterium | 2053509 | Bacteria | Bacteria | 52 | 3.65e-5 | NR | MBE3117660.1 | 2053509 | g97017 | i0 | 37.1 | 0.410958904109589 | 70 | 42 | 39.9 | 1 | 334 | 131 | 5 | 74 | MBE3117660.1 hypothetical protein [Candidatus Atribacteria bacterium] | diamond | 210 | 52 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacteria | Candidatus Atribacteria bacterium | |||||
| 31398807 | 31398807 | PRJNA1148190_P_NODE_58796_length_752_cov_3.453608_g47825_i0 | PRJNA1148190 | 58796 | 752 | 3.453608 | 25.97113216 | Atribacterota bacterium | 2952890 | Bacteria | Bacteria | 87.8 | 7.46e-16 | NR | MDD5013550.1 | 2952890 | g47825 | i0 | 41.3 | 0.482712765957447 | 121 | 56 | 47.5 | 4 | 750 | 394 | 100 | 207 | MDD5013550.1 hypothetical protein [Atribacterota bacterium] | diamond | 363 | 87.8 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacterota bacterium | ||||||
| 31620460 | 31620460 | PRJNA1148190_P_NODE_99176_length_537_cov_1.846983_g88022_i0 | PRJNA1148190 | 99176 | 537 | 1.846983 | 9.91829871 | Candidatus Infernicultor aquiphilus | 1805029 | Bacteria | Bacteria | 59.3 | 2.14e-8 | NR | WP_406608428.1 | 1805029 | g88022 | i0 | 38.3 | 0.670391061452514 | 60 | 36 | 33 | 1 | 328 | 152 | 4 | 63 | WP_406608428.1 hypothetical protein [Candidatus Infernicultor aquiphilus] | diamond | 360 | 59.3 | 1 | Bacteria | Pseudomonadati | Atribacterota | Candidatus Phoenicimicrobiia | Candidatus Pheonicimicrobiales | Candidatus Phoenicimicrobiaceae | Candidatus Infernicultor | Candidatus Infernicultor aquiphilus | ||
| 32220836 | 32220836 | PRJNA1148190_P_NODE_365858_length_295_cov_1.040541_g354685_i0 | PRJNA1148190 | 365858 | 295 | 1.040541 | 3.06959595 | Candidatus Atribacteria bacterium | 2053509 | Bacteria | Bacteria | 60.8 | 2.09e-9 | NR | MBE3117660.1 | 2053509 | g354685 | i0 | 38.2 | 0.772881355932203 | 76 | 41 | 75.3 | 2 | 291 | 70 | 8 | 79 | MBE3117660.1 hypothetical protein [Candidatus Atribacteria bacterium] | diamond | 228 | 60.8 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacteria | Candidatus Atribacteria bacterium | |||||
| 32272817 | 32272817 | PRJNA1148190_P_NODE_607858_length_250_cov_0.870056_g596685_i0 | PRJNA1148190 | 607858 | 250 | 0.870056 | 2.17514 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 53.5 | 1.41e-6 | NR | WP_406608421.1 | 1805029 | g596685 | i0 | 46.6 | 1.344 | 58 | 31 | 69.6 | 0 | 247 | 74 | 83 | 140 | WP_406608421.1 hypothetical protein, partial [Candidatus Infernicultor aquiphilus] | diamond | 336 | 53.9 | 0.992578849721707 | Bacteria | Pseudomonadati | Atribacterota | Candidatus Phoenicimicrobiia | Candidatus Pheonicimicrobiales | Candidatus Phoenicimicrobiaceae | Candidatus Infernicultor | Candidatus Infernicultor aquiphilus | ||
| 32726718 | 32726718 | PRJNA1148190_P_NODE_599780_length_250_cov_1.502825_g588607_i0 | PRJNA1148190 | 599780 | 250 | 1.502825 | 3.7570625 | Candidatus Atribacteria bacterium | 2053509 | Bacteria | Bacteria | 70.5 | 1.39e-12 | NR | MBP8612464.1 | 2053509 | g588607 | i0 | 51.6 | 0.744 | 62 | 30 | 74.4 | 0 | 187 | 2 | 97 | 158 | MBP8612464.1 deoxynucleoside kinase [Candidatus Atribacteria bacterium] | diamond | 186 | 70.5 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacteria | Candidatus Atribacteria 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);;