contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA283169" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26979160 | 26979160 | PRJNA283169_P_NODE_4302_length_203_cov_1.012987_g4239_i0 | PRJNA283169 | 4302 | 203 | 1.012987 | 2.05636361 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 129 | 1.28e-34 | NR | MFN0122001.1 | 2052146 | g4239 | i0 | 95.5 | 0.990147783251232 | 67 | 3 | 99 | 0 | 2 | 202 | 206 | 272 | MFN0122001.1 RraA family protein [Blastocatellia bacterium] | diamond | 201 | 129 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 27737838 | 27737838 | PRJNA283169_P_NODE_2164_length_278_cov_1.576419_g2102_i0 | PRJNA283169 | 2164 | 278 | 1.576419 | 4.38244482 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 55.8 | 1.22e-6 | NR | HSS95488.1 | 2282142 | g2102 | i0 | 39.7 | 0.733812949640288 | 68 | 41 | 73.4 | 0 | 75 | 278 | 22 | 89 | HSS95488.1 hypothetical protein [Terriglobales bacterium] | diamond | 204 | 55.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 27895273 | 27895273 | PRJNA283169_S_NODE_605_length_328_cov_0.154122_g591_i0 | PRJNA283169 | 605 | 328 | 0.154122 | 0.50552016 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 208 | 6.68e-61 | NR | MBL8241321.1 | 2026791 | g591 | i0 | 95.4 | 1.97560975609756 | 108 | 5 | 98.8 | 0 | 326 | 3 | 205 | 312 | MBL8241321.1 DUF1592 domain-containing protein [Bryobacterales bacterium] | diamond | 648 | 208 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 29000836 | 29000836 | PRJNA283169_P_NODE_7908_length_163_cov_0.885965_g7845_i0 | PRJNA283169 | 7908 | 163 | 0.885965 | 1.44412295 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 63.9 | 1.41e-10 | NR | MFN7932550.1 | 2212468 | g7845 | i0 | 66.7 | 4.96932515337423 | 54 | 18 | 99.4 | 0 | 163 | 2 | 1 | 54 | MFN7932550.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 810 | 63.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29032296 | 29032296 | PRJNA283169_S_NODE_1528_length_222_cov_0.132948_g1514_i0 | PRJNA283169 | 1528 | 222 | 0.132948 | 0.29514456 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 62.8 | 2.56e-9 | NR | HVM92728.1 | 2282142 | g1514 | i0 | 80.6 | 2.06756756756757 | 36 | 7 | 48.6 | 0 | 100 | 207 | 929 | 964 | HVM92728.1 hypothetical protein [Terriglobales bacterium] | diamond | 459 | 62.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 29221677 | 29221677 | PRJNA283169_P_NODE_4409_length_201_cov_1.019737_g4346_i0 | PRJNA283169 | 4409 | 201 | 1.019737 | 2.04967137 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 57.8 | 1.05e-7 | NR | MBV9926145.1 | 1978231 | g4346 | i0 | 43.5 | 2.77611940298507 | 62 | 35 | 92.5 | 0 | 14 | 199 | 515 | 576 | MBV9926145.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 558 | 57.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29712372 | 29712372 | PRJNA283169_S_NODE_2850_length_172_cov_0.065041_g2836_i0 | PRJNA283169 | 2850 | 172 | 0.065041 | 0.11187052 | Bacteria | 2 | Bacteria | Bacteria | 112 | 5.599999999999998e-29 | NR | MBU6380127.1 | 1978231 | g2836 | i0 | 93 | 10.9360465116279 | 57 | 4 | 99.4 | 0 | 2 | 172 | 146 | 202 | MBU6380127.1 bifunctional 1-(5-phosphoribosyl)-5-((5-phosphoribosylamino)methylideneamino)imidazole-4-carboxamide isomerase/phosphoribosylanthranilate isomerase PriA [Acidobacteriota bacterium] | diamond | 1881 | 113 | 0.991150442477876 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29979336 | 29979336 | PRJNA283169_P_NODE_7251_length_165_cov_0.896552_g7188_i0 | PRJNA283169 | 7251 | 165 | 0.896552 | 1.4793108 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 43.9 | 4.98e-4 | NR | MBZ5616208.1 | 2081523 | g7188 | i0 | 48.8 | 0.781818181818182 | 43 | 21 | 78.2 | 1 | 2 | 130 | 10 | 51 | MBZ5616208.1 hypothetical protein [Terriglobia bacterium] | diamond | 129 | 43.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 30484922 | 30484922 | PRJNA283169_P_NODE_2433_length_264_cov_1.441860_g2371_i0 | PRJNA283169 | 2433 | 264 | 1.44186 | 3.8065104 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 44.3 | 0.0056 | NR | MDE2977639.1 | 1978231 | g2371 | i0 | 45.8 | 0.545454545454545 | 48 | 22 | 50 | 1 | 206 | 75 | 63 | 110 | MDE2977639.1 tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex ATPase subunit type 1 TsaE [Acidobacteriota bacterium] | diamond | 144 | 44.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30628681 | 30628681 | PRJNA283169_S_NODE_553_length_339_cov_0.124138_g539_i0 | PRJNA283169 | 553 | 339 | 0.124138 | 0.42082782 | Bacteria | 2 | Bacteria | Bacteria | 117 | 2.84e-29 | NR | MBI3651549.1 | 1978231 | g539 | i0 | 53.3 | 6.47787610619469 | 105 | 49 | 92.9 | 0 | 316 | 2 | 164 | 268 | MBI3651549.1 protein-glutamate O-methyltransferase [Acidobacteriota bacterium] | diamond | 2196 | 118 | 0.991525423728814 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30660498 | 30660498 | PRJNA283169_P_NODE_7253_length_165_cov_0.896552_g7190_i0 | PRJNA283169 | 7253 | 165 | 0.896552 | 1.4793108 | Bacteria | 2 | Bacteria | Bacteria | 83.6 | 4.99e-18 | NR | MBS1806651.1 | 1978231 | g7190 | i0 | 82.7 | 2.83636363636364 | 52 | 9 | 94.5 | 0 | 163 | 8 | 72 | 123 | MBS1806651.1 class I SAM-dependent methyltransferase [Acidobacteriota bacterium] | diamond | 468 | 84 | 0.995238095238095 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31008084 | 31008084 | PRJNA283169_P_NODE_2854_length_246_cov_0.979695_g2791_i0 | PRJNA283169 | 2854 | 246 | 0.979695 | 2.4100497 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 80.9 | 1.33e-15 | NR | HYR88515.1 | 2081523 | g2791 | i0 | 51.7 | 2.24390243902439 | 60 | 29 | 73.2 | 0 | 7 | 186 | 26 | 85 | HYR88515.1 site-specific DNA-methyltransferase [Terriglobia bacterium] | diamond | 552 | 80.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 31102687 | 31102687 | PRJNA283169_S_NODE_2195_length_192_cov_0.188811_g2181_i0 | PRJNA283169 | 2195 | 192 | 0.188811 | 0.36251712 | FCB group | 1783270 | Bacteria | Bacteria | 58.5 | 4.69e-8 | NR | HTR25258.1 | 2282142 | g2181 | i0 | 47.2 | 3.828125 | 53 | 28 | 82.8 | 0 | 1 | 159 | 162 | 214 | HTR25258.1 Gfo/Idh/MocA family oxidoreductase [Terriglobales bacterium] | diamond | 735 | 58.9 | 0.99320882852292 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 31116523 | 31116523 | PRJNA283169_P_NODE_6775_length_167_cov_0.881356_g6712_i0 | PRJNA283169 | 6775 | 167 | 0.881356 | 1.47186452 | Candidatus Angelobacter sp. | 2976921 | Bacteria | Bacteria | 45.8 | 9.05e-4 | NR | HET9285655.1 | 2976921 | g6712 | i0 | 45.7 | 0.826347305389222 | 46 | 25 | 82.6 | 0 | 14 | 151 | 168 | 213 | HET9285655.1 NUMOD3 domain-containing DNA-binding protein [Candidatus Angelobacter sp.] | diamond | 138 | 45.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Angelobacter | Candidatus Angelobacter sp. | ||||
| 31229009 | 31229009 | PRJNA283169_P_NODE_6635_length_168_cov_0.865546_g6572_i0 | PRJNA283169 | 6635 | 168 | 0.865546 | 1.45411728 | Bacteria | 2 | Bacteria | Bacteria | 71.2 | 1.04e-12 | NR | NOT60191.1 | 1978231 | g6572 | i0 | 75.6 | 2.39285714285714 | 45 | 11 | 80.4 | 0 | 17 | 151 | 56 | 100 | NOT60191.1 glycosyl transferase [Acidobacteriota bacterium] | diamond | 402 | 71.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31717624 | 31717624 | PRJNA283169_P_NODE_2957_length_241_cov_1.557292_g2894_i0 | PRJNA283169 | 2957 | 241 | 1.557292 | 3.75307372 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 128 | 6.480000000000001e-33 | NR | HJS97855.1 | 2282142 | g2894 | i0 | 70.1 | 0.95850622406639 | 77 | 23 | 95.9 | 0 | 1 | 231 | 171 | 247 | HJS97855.1 hypothetical protein [Terriglobales bacterium] | diamond | 231 | 128 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 31749131 | 31749131 | PRJNA283169_P_NODE_5297_length_186_cov_1.065693_g5234_i0 | PRJNA283169 | 5297 | 186 | 1.065693 | 1.98218898 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 61.2 | 5.15e-9 | NR | HWP55425.1 | 2283092 | g5234 | i0 | 56.5 | 1.70967741935484 | 46 | 20 | 74.2 | 0 | 176 | 39 | 565 | 610 | HWP55425.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 318 | 61.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31875643 | 31875643 | PRJNA283169_P_NODE_2557_length_258_cov_0.995215_g2495_i0 | PRJNA283169 | 2557 | 258 | 0.995215 | 2.5676547 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 79.3 | 2.98e-15 | NR | MCI0664367.1 | 1978231 | g2495 | i0 | 52.4 | 1.93023255813953 | 82 | 39 | 95.3 | 0 | 7 | 252 | 148 | 229 | MCI0664367.1 SGNH/GDSL hydrolase family protein [Acidobacteriota bacterium] | diamond | 498 | 79.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32192285 | 32192285 | PRJNA283169_P_NODE_4958_length_191_cov_2.140845_g4895_i0 | PRJNA283169 | 4958 | 191 | 2.140845 | 4.08901395 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 105 | 1.49e-24 | NR | MFN7928126.1 | 2052146 | g4895 | i0 | 76.2 | 0.989528795811518 | 63 | 15 | 99 | 0 | 191 | 3 | 683 | 745 | MFN7928126.1 two-component regulator propeller domain-containing protein [Blastocatellia bacterium] | diamond | 189 | 105 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 32255873 | 32255873 | PRJNA283169_P_NODE_3058_length_237_cov_1.106383_g2995_i0 | PRJNA283169 | 3058 | 237 | 1.106383 | 2.62212771 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 70.5 | 4.17e-12 | NR | MFN0119228.1 | 2052146 | g2995 | i0 | 74 | 0.632911392405063 | 50 | 12 | 62 | 1 | 193 | 47 | 274 | 323 | MFN0119228.1 hypothetical protein [Blastocatellia bacterium] | diamond | 150 | 70.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 32855155 | 32855155 | PRJNA283169_S_NODE_1980_length_200_cov_0.119205_g1966_i0 | PRJNA283169 | 1980 | 200 | 0.119205 | 0.23841 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 61.6 | 4.58e-9 | NR | PWT88243.1 | 1978231 | g1966 | i0 | 57.4 | 0.705 | 47 | 20 | 70.5 | 0 | 5 | 145 | 412 | 458 | PWT88243.1 MAG: hypothetical protein C5B54_10925 [Acidobacteriota bacterium] | diamond | 141 | 61.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota 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);;