contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJEB66218" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 133843 | 133843 | PRJEB66218_P_NODE_57921_length_435_cov_1.529412_g55501_i0 | PRJEB66218 | 57921 | 435 | 1.529412 | 6.6529422 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 96.7 | 3.3700000000000003e-22 | NR | MDH7482967.1 | 2033014 | g55501 | i0 | 67.6 | 1.87586206896552 | 68 | 22 | 46.9 | 0 | 232 | 435 | 1 | 68 | MDH7482967.1 GNAT family N-acetyltransferase [Armatimonadota bacterium] | diamond | 816 | 96.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 15434919 | 15434919 | PRJEB66218_P_NODE_213373_length_208_cov_0.884354_g210943_i0 | PRJEB66218 | 213373 | 208 | 0.884354 | 1.83945632 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 147 | 8.13e-43 | NR | MFN3690895.1 | 2682145 | g210943 | i0 | 100 | 0.980769230769231 | 68 | 0 | 98.1 | 0 | 206 | 3 | 3 | 70 | MFN3690895.1 cysteine hydrolase family protein [Fimbriimonadales bacterium] | diamond | 204 | 147 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 16711527 | 16711527 | PRJEB66218_P_NODE_99874_length_307_cov_1.414634_g97446_i0 | PRJEB66218 | 99874 | 307 | 1.414634 | 4.34292638 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 173 | 5.32e-50 | NR | MBI3926320.1 | 2033014 | g97446 | i0 | 85.1 | 3.94788273615635 | 101 | 15 | 98.7 | 0 | 305 | 3 | 268 | 368 | MBI3926320.1 ATP-dependent Clp protease ATP-binding subunit ClpX [Armatimonadota bacterium] | diamond | 1212 | 173 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26717071 | 26717071 | PRJEB66218_P_NODE_222841_length_206_cov_0.896552_g220411_i0 | PRJEB66218 | 222841 | 206 | 0.896552 | 1.84689712 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 145 | 3.52e-40 | NR | MCL6531677.1 | 2033014 | g220411 | i0 | 100 | 0.990291262135922 | 68 | 0 | 99 | 0 | 205 | 2 | 225 | 292 | MCL6531677.1 lipid-A-disaccharide synthase [Armatimonadota bacterium] | diamond | 204 | 145 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26812562 | 26812562 | PRJEB66218_P_NODE_221_length_8282_cov_10.627418_g161_i0 | PRJEB66218 | 221 | 8282 | 10.627418 | 880.16275876 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 139 | 7.79e-33 | NR | NOG38506.1 | 2033014 | g161 | i0 | 42.7 | 0.0670127988408597 | 185 | 95 | 6.5 | 4 | 56 | 592 | 17 | 196 | NOG38506.1 hypothetical protein [Armatimonadota bacterium] | diamond | 555 | 139 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26970617 | 26970617 | PRJEB66218_P_NODE_198582_length_211_cov_0.866667_g196152_i0 | PRJEB66218 | 198582 | 211 | 0.866667 | 1.82866737 | Armatimonas sp. | 1872638 | Bacteria | Bacteria | 72.4 | 6.34e-13 | NR | WP_309718863.1 | 1872638 | g196152 | i0 | 52.2 | 2.94312796208531 | 69 | 31 | 98.1 | 2 | 1 | 207 | 162 | 228 | WP_309718863.1 RNA ligase (ATP) [Armatimonas sp.] | diamond | 621 | 72.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas sp. | ||
| 30476525 | 30476525 | PRJEB66218_P_NODE_207233_length_209_cov_0.878378_g204803_i0 | PRJEB66218 | 207233 | 209 | 0.878378 | 1.83581002 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 75.1 | 8.81e-14 | NR | MCC7439593.1 | 2033014 | g204803 | i0 | 64.5 | 0.889952153110048 | 62 | 21 | 87.6 | 1 | 188 | 6 | 21 | 82 | MCC7439593.1 FAD-dependent monooxygenase [Armatimonadota bacterium] | diamond | 186 | 75.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30539488 | 30539488 | PRJEB66218_P_NODE_145133_length_246_cov_1.135135_g142704_i0 | PRJEB66218 | 145133 | 246 | 1.135135 | 2.7924321 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 43.1 | 0.0276 | NR | HET6645382.1 | 2682145 | g142704 | i0 | 35.6 | 0.719512195121951 | 59 | 31 | 63.4 | 1 | 209 | 54 | 14 | 72 | HET6645382.1 phospholipase D-like domain-containing protein [Fimbriimonadales bacterium] | diamond | 177 | 43.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 30792257 | 30792257 | PRJEB66218_P_NODE_153054_length_239_cov_1.674157_g150625_i0 | PRJEB66218 | 153054 | 239 | 1.674157 | 4.00123523 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 124 | 2.9699999999999997e-35 | NR | MFN3690896.1 | 2682145 | g150625 | i0 | 96.8 | 0.790794979079498 | 63 | 2 | 79.1 | 0 | 233 | 45 | 1 | 63 | MFN3690896.1 hypothetical protein [Fimbriimonadales bacterium] | diamond | 189 | 124 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 31670324 | 31670324 | PRJEB66218_P_NODE_135297_length_256_cov_1.333333_g132868_i0 | PRJEB66218 | 135297 | 256 | 1.333333 | 3.41333248 | Bacteria | 2 | Bacteria | Bacteria | 53.9 | 4e-6 | NR | GDX39766.1 | 2033014 | g132868 | i0 | 43 | 3.515625 | 79 | 38 | 91.4 | 3 | 5 | 238 | 63 | 135 | GDX39766.1 nucleotide pyrophosphatase [Armatimonadota bacterium] | diamond | 900 | 53.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32682023 | 32682023 | PRJEB66218_P_NODE_80360_length_352_cov_2.006873_g77934_i0 | PRJEB66218 | 80360 | 352 | 2.006873 | 7.06419296 | PVC group | 1783257 | Bacteria | Bacteria | 45.8 | 0.0111 | NR | HEY3378350.1 | 2033014 | g77934 | i0 | 36.7 | 3.40909090909091 | 98 | 58 | 81.8 | 4 | 37 | 324 | 999 | 1094 | HEY3378350.1 fibronectin type III domain-containing protein [Armatimonadota bacterium] | diamond | 1200 | 46.2 | 0.991341991341991 | Bacteria | Bacillati | Armatimonadota | Armatimonadota 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);;