contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1137393" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 284826 | 284826 | PRJNA1137393_P_NODE_71221_length_162_cov_0.920354_g70705_i0 | PRJNA1137393 | 71221 | 162 | 0.920354 | 1.49097348 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 71.2 | 7.4e-13 | NR | HEY4954885.1 | 2026741 | g70705 | i0 | 79.1 | 1.68518518518519 | 43 | 9 | 79.6 | 0 | 131 | 3 | 2 | 44 | HEY4954885.1 ring-cleaving dioxygenase [Gemmatimonadaceae bacterium] | diamond | 273 | 71.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27639227 | 27639227 | PRJNA1137393_P_NODE_54044_length_166_cov_0.888889_g53528_i0 | PRJNA1137393 | 54044 | 166 | 0.888889 | 1.47555574 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 41.6 | 0.0348 | NR | MCX5755190.1 | 2026742 | g53528 | i0 | 44.7 | 0.849397590361446 | 47 | 18 | 81.3 | 2 | 14 | 148 | 16 | 56 | MCX5755190.1 UPF0182 family protein [Gemmatimonadota bacterium] | diamond | 141 | 41.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27670820 | 27670820 | PRJNA1137393_P_NODE_8764_length_281_cov_1.810345_g8248_i0 | PRJNA1137393 | 8764 | 281 | 1.810345 | 5.08706945 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 43.1 | 0.0408 | NR | MYH51855.1 | 2026742 | g8248 | i0 | 41.5 | 0.693950177935943 | 65 | 33 | 69.4 | 2 | 54 | 248 | 208 | 267 | MYH51855.1 aminotransferase class V-fold PLP-dependent enzyme [Gemmatimonadota bacterium] | diamond | 195 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28649551 | 28649551 | PRJNA1137393_P_NODE_62867_length_164_cov_0.904348_g62351_i0 | PRJNA1137393 | 62867 | 164 | 0.904348 | 1.48313072 | Gemmatimonadetes bacterium T265 | 2839016 | Bacteria | Bacteria | 98.2 | 4.679999999999999e-23 | NR | GJG89246.1 | 2839016 | g62351 | i0 | 83.3 | 0.98780487804878 | 54 | 9 | 98.8 | 0 | 3 | 164 | 34 | 87 | GJG89246.1 hypothetical protein tb265_44270 [Gemmatimonadetes bacterium T265] | diamond | 162 | 98.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadetes bacterium T265 | |||||
| 29059981 | 29059981 | PRJNA1137393_P_NODE_32088_length_178_cov_1.604651_g31572_i0 | PRJNA1137393 | 32088 | 178 | 1.604651 | 2.85627878 | Gemmatimonas sp. | 1962908 | Bacteria | Bacteria | 46.2 | 8.84e-4 | NR | MQA90362.1 | 1962908 | g31572 | i0 | 70.8 | 0.404494382022472 | 24 | 7 | 40.4 | 0 | 105 | 176 | 2 | 25 | MQA90362.1 hypothetical protein [Gemmatimonas sp.] | diamond | 72 | 46.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. | |
| 29470049 | 29470049 | PRJNA1137393_P_NODE_8010_length_295_cov_5.223577_g7494_i0 | PRJNA1137393 | 8010 | 295 | 5.223577 | 15.40955215 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 45.8 | 0.00556 | NR | HKH82792.1 | 2448054 | g7494 | i0 | 39.4 | 0.671186440677966 | 66 | 35 | 66.1 | 2 | 86 | 280 | 263 | 324 | HKH82792.1 APC family permease [Gemmatimonadales bacterium] | diamond | 198 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29944125 | 29944125 | PRJNA1137393_P_NODE_27151_length_186_cov_1.284672_g26635_i0 | PRJNA1137393 | 27151 | 186 | 1.284672 | 2.38948992 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 100 | 2.66e-25 | NR | HEX8245191.1 | 2029185 | g26635 | i0 | 92.5 | 2.56451612903226 | 53 | 4 | 85.5 | 0 | 27 | 185 | 1 | 53 | HEX8245191.1 TraR/DksA C4-type zinc finger protein [Longimicrobium sp.] | diamond | 477 | 100 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 30481172 | 30481172 | PRJNA1137393_P_NODE_53053_length_166_cov_0.888889_g52537_i0 | PRJNA1137393 | 53053 | 166 | 0.888889 | 1.47555574 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 94.4 | 4.26e-21 | NR | HET9464089.1 | 2448054 | g52537 | i0 | 92.6 | 1.95180722891566 | 54 | 4 | 97.6 | 0 | 163 | 2 | 124 | 177 | HET9464089.1 galactokinase [Gemmatimonadales bacterium] | diamond | 324 | 94.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30722825 | 30722825 | PRJNA1137393_P_NODE_51134_length_167_cov_0.881356_g50618_i0 | PRJNA1137393 | 51134 | 167 | 0.881356 | 1.47186452 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 70.9 | 5.24e-13 | NR | NNG17336.1 | 2448054 | g50618 | i0 | 65.4 | 1.92215568862275 | 52 | 18 | 93.4 | 0 | 161 | 6 | 150 | 201 | NNG17336.1 trehalose-phosphatase [Gemmatimonadales bacterium] | diamond | 321 | 71.6 | 0.990223463687151 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31271128 | 31271128 | PRJNA1137393_P_NODE_5695_length_363_cov_4.133758_g5179_i0 | PRJNA1137393 | 5695 | 363 | 4.133758 | 15.00554154 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 97.8 | 3.88e-21 | NR | HEU5042096.1 | 2448054 | g5179 | i0 | 73.8 | 0.661157024793388 | 80 | 18 | 65.3 | 2 | 7 | 243 | 310 | 387 | HEU5042096.1 HD domain-containing protein [Gemmatimonadales bacterium] | diamond | 240 | 97.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31998623 | 31998623 | PRJNA1137393_P_NODE_61698_length_164_cov_0.904348_g61182_i0 | PRJNA1137393 | 61698 | 164 | 0.904348 | 1.48313072 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 98.6 | 2.45e-22 | NR | WP_325310493.1 | 2029185 | g61182 | i0 | 92.6 | 0.98780487804878 | 54 | 4 | 98.8 | 0 | 163 | 2 | 3 | 56 | WP_325310493.1 malate synthase A [Longimicrobium sp.] | diamond | 162 | 98.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 32630897 | 32630897 | PRJNA1137393_P_NODE_59320_length_165_cov_0.896552_g58804_i0 | PRJNA1137393 | 59320 | 165 | 0.896552 | 1.4793108 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 57.4 | 3.83e-8 | NR | MDX1492957.1 | 2910168 | g58804 | i0 | 50 | 0.836363636363636 | 46 | 23 | 83.6 | 0 | 164 | 27 | 78 | 123 | MDX1492957.1 hypothetical protein [Longimicrobiales bacterium] | diamond | 138 | 57.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 32725602 | 32725602 | PRJNA1137393_P_NODE_7380_length_310_cov_6.068966_g6864_i0 | PRJNA1137393 | 7380 | 310 | 6.068966 | 18.8137946 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 42.7 | 0.044 | NR | MFN0179075.1 | 2448054 | g6864 | i0 | 39.3 | 0.590322580645161 | 61 | 37 | 59 | 0 | 5 | 187 | 89 | 149 | MFN0179075.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 183 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales 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);;