contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJEB39269" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15359200 | 15359200 | PRJEB39269_P_NODE_29993_length_253_cov_2.074766_g29588_i0 | PRJEB39269 | 29993 | 253 | 2.074766 | 5.24915798 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 79.3 | 1.9e-15 | NR | HUK21556.1 | 2448054 | g29588 | i0 | 65 | 0.711462450592885 | 60 | 21 | 71.1 | 0 | 216 | 37 | 100 | 159 | HUK21556.1 FAD:protein FMN transferase [Gemmatimonadales bacterium] | diamond | 180 | 79.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 26716410 | 26716410 | PRJEB39269_P_NODE_86741_length_153_cov_3.201754_g86336_i0 | PRJEB39269 | 86741 | 153 | 3.201754 | 4.89868362 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 68.6 | 8.35e-12 | NR | HEU4561124.1 | 2029185 | g86336 | i0 | 74.5 | 2.80392156862745 | 47 | 12 | 92.2 | 0 | 2 | 142 | 297 | 343 | HEU4561124.1 ATP-dependent DNA ligase [Longimicrobium sp.] | diamond | 429 | 68.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 26875434 | 26875434 | PRJEB39269_P_NODE_64721_length_172_cov_1.233083_g64316_i0 | PRJEB39269 | 64721 | 172 | 1.233083 | 2.12090276 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 97.8 | 2.47e-22 | NR | HTR21421.1 | 2448054 | g64316 | i0 | 89.5 | 0.994186046511628 | 57 | 6 | 99.4 | 0 | 172 | 2 | 249 | 305 | HTR21421.1 acyl-CoA dehydrogenase [Gemmatimonadales bacterium] | diamond | 171 | 97.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 27444495 | 27444495 | PRJEB39269_P_NODE_58463_length_180_cov_1.879433_g58058_i0 | PRJEB39269 | 58463 | 180 | 1.879433 | 3.3829794 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 79.3 | 1.57e-15 | NR | MCI0435378.1 | 2026742 | g58058 | i0 | 67.2 | 2.9 | 58 | 19 | 96.7 | 0 | 2 | 175 | 42 | 99 | MCI0435378.1 enoyl-CoA hydratase-related protein [Gemmatimonadota bacterium] | diamond | 522 | 79.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27910970 | 27910970 | PRJEB39269_P_NODE_45225_length_204_cov_1.351515_g44820_i0 | PRJEB39269 | 45225 | 204 | 1.351515 | 2.7570906 | Bacteria | 2 | Bacteria | Bacteria | 94.7 | 1.08e-20 | NR | HEY7529619.1 | 2026742 | g44820 | i0 | 78.1 | 3.48529411764706 | 64 | 14 | 94.1 | 0 | 3 | 194 | 771 | 834 | HEY7529619.1 heavy metal translocating P-type ATPase [Gemmatimonadota bacterium] | diamond | 711 | 95.5 | 0.991623036649215 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30886453 | 30886453 | PRJEB39269_P_NODE_47874_length_198_cov_1.849057_g47469_i0 | PRJEB39269 | 47874 | 198 | 1.849057 | 3.66113286 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 120 | 3.34e-33 | NR | MDQ3556373.1 | 2026742 | g47469 | i0 | 84.6 | 5.90909090909091 | 65 | 10 | 98.5 | 0 | 196 | 2 | 41 | 105 | MDQ3556373.1 cupredoxin domain-containing protein [Gemmatimonadota bacterium] | diamond | 1170 | 120 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30981418 | 30981418 | PRJEB39269_P_NODE_82534_length_157_cov_1.211864_g82129_i0 | PRJEB39269 | 82534 | 157 | 1.211864 | 1.90262648 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 91.3 | 1.56e-20 | NR | HEY9515683.1 | 2026741 | g82129 | i0 | 74.5 | 2.92356687898089 | 51 | 13 | 97.5 | 0 | 155 | 3 | 209 | 259 | HEY9515683.1 methyltransferase domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 459 | 91.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31803201 | 31803201 | PRJEB39269_P_NODE_88737_length_152_cov_1.380531_g88332_i0 | PRJEB39269 | 88737 | 152 | 1.380531 | 2.09840712 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 83.6 | 1.97e-18 | NR | HEX7595213.1 | 2026741 | g88332 | i0 | 88 | 0.986842105263158 | 50 | 6 | 98.7 | 0 | 150 | 1 | 76 | 125 | HEX7595213.1 plasmid mobilization relaxosome protein MobC [Gemmatimonadaceae bacterium] | diamond | 150 | 83.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31954858 | 31954858 | PRJEB39269_P_NODE_66857_length_170_cov_3.000000_g66452_i0 | PRJEB39269 | 66857 | 170 | 3 | 5.1 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 48.5 | 1.15e-4 | NR | HKV71433.1 | 2448054 | g66452 | i0 | 55 | 8.43529411764706 | 40 | 18 | 70.6 | 0 | 4 | 123 | 158 | 197 | HKV71433.1 ABC transporter ATP-binding protein [Gemmatimonadales bacterium] | diamond | 1434 | 48.9 | 0.991820040899796 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32113243 | 32113243 | PRJEB39269_P_NODE_83598_length_156_cov_1.401709_g83193_i0 | PRJEB39269 | 83598 | 156 | 1.401709 | 2.18666604 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 55.1 | 5.09e-7 | NR | HZF67855.1 | 2510638 | g83193 | i0 | 81.5 | 4.55769230769231 | 27 | 5 | 51.9 | 0 | 156 | 76 | 344 | 370 | HZF67855.1 UDP-N-acetylglucosamine 2-epimerase (non-hydrolyzing) [Gemmatirosa sp.] | diamond | 711 | 55.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa sp. | |
| 32214732 | 32214732 | PRJEB39269_P_NODE_62338_length_175_cov_1.301471_g61933_i0 | PRJEB39269 | 62338 | 175 | 1.301471 | 2.27757425 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 77.4 | 3.22e-15 | NR | HVD62548.1 | 2026741 | g61933 | i0 | 64.9 | 2.93142857142857 | 57 | 20 | 97.7 | 0 | 3 | 173 | 64 | 120 | HVD62548.1 methyltransferase domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 513 | 77.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae 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);;