contig_metadata
9 rows where bioproject = "PRJNA560932" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27078998 | 27078998 | PRJNA560932_P_NODE_19142_length_402_cov_1.905775_g18786_i0 | PRJNA560932 | 19142 | 402 | 1.905775 | 7.6612155 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 83.6 | 1.58e-16 | NR | MBI2264303.1 | 2033014 | g18786 | i0 | 46.2 | 3.02238805970149 | 93 | 49 | 69.4 | 1 | 280 | 2 | 56 | 147 | MBI2264303.1 C39 family peptidase [Armatimonadota bacterium] | diamond | 1215 | 83.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27805757 | 27805757 | PRJNA560932_P_NODE_45264_length_272_cov_0.944724_g44908_i0 | PRJNA560932 | 45264 | 272 | 0.944724 | 2.56964928 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 120 | 1.53e-29 | NR | MBS1726118.1 | 2033014 | g44908 | i0 | 65.2 | 0.981617647058823 | 89 | 28 | 98.2 | 1 | 3 | 269 | 352 | 437 | MBS1726118.1 MmgE/PrpD family protein [Armatimonadota bacterium] | diamond | 267 | 120 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28310859 | 28310859 | PRJNA560932_P_NODE_52046_length_251_cov_0.865169_g51690_i0 | PRJNA560932 | 52046 | 251 | 0.865169 | 2.17157419 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 42.7 | 0.0373 | NR | MBW7926855.1 | 2682144 | g51690 | i0 | 40.7 | 0.645418326693227 | 54 | 31 | 63.3 | 1 | 34 | 192 | 144 | 197 | MBW7926855.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 162 | 42.7 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 28595058 | 28595058 | PRJNA560932_P_NODE_42447_length_280_cov_1.487923_g42091_i0 | PRJNA560932 | 42447 | 280 | 1.487923 | 4.1661844 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 83.2 | 2.83e-17 | NR | MCW5939043.1 | 2682144 | g42091 | i0 | 46.2 | 1.98214285714286 | 93 | 47 | 99.6 | 1 | 279 | 1 | 41 | 130 | MCW5939043.1 aquaporin [Fimbriimonadaceae bacterium] | diamond | 555 | 83.2 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 30616029 | 30616029 | PRJNA560932_P_NODE_27733_length_341_cov_0.955224_g27377_i0 | PRJNA560932 | 27733 | 341 | 0.955224 | 3.25731384 | Chthonomonas sp. | 2282153 | Bacteria | Bacteria | 63.2 | 5.25e-9 | NR | MBL8049453.1 | 2282153 | g27377 | i0 | 36.3 | 0.703812316715543 | 80 | 49 | 70.4 | 1 | 261 | 22 | 208 | 285 | MBL8049453.1 FHA domain-containing protein [Chthonomonas sp.] | diamond | 240 | 63.2 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas sp. | ||
| 30742520 | 30742520 | PRJNA560932_P_NODE_42774_length_279_cov_1.495146_g42418_i0 | PRJNA560932 | 42774 | 279 | 1.495146 | 4.17145734 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 47.8 | 7.7e-4 | NR | MEO7453820.1 | 2682145 | g42418 | i0 | 36.8 | 1.56989247311828 | 68 | 41 | 71 | 1 | 5 | 202 | 167 | 234 | MEO7453820.1 MIP/aquaporin family protein [Fimbriimonadales bacterium] | diamond | 438 | 47.8 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 31248090 | 31248090 | PRJNA560932_P_NODE_50615_length_255_cov_1.181319_g50259_i0 | PRJNA560932 | 50615 | 255 | 1.181319 | 3.01236345 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 69.7 | 1.12e-11 | NR | MCL6532940.1 | 2033014 | g50259 | i0 | 50 | 1.36470588235294 | 58 | 29 | 68.2 | 0 | 239 | 66 | 286 | 343 | MCL6532940.1 3-phosphoserine/phosphohydroxythreonine transaminase [Armatimonadota bacterium] | diamond | 348 | 69.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31483701 | 31483701 | PRJNA560932_P_NODE_35396_length_305_cov_1.987069_g35040_i0 | PRJNA560932 | 35396 | 305 | 1.987069 | 6.06056045 | FCB group | 1783270 | Bacteria | Bacteria | 48.1 | 4.1e-4 | NR | HAY12875.1 | 2033014 | g35040 | i0 | 25.6 | 1.93770491803279 | 82 | 54 | 73.8 | 2 | 80 | 304 | 17 | 98 | HAY12875.1 hypothetical protein [Armatimonadota bacterium] | diamond | 591 | 48.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31501323 | 31501323 | PRJNA560932_P_NODE_43156_length_278_cov_1.390244_g42800_i0 | PRJNA560932 | 43156 | 278 | 1.390244 | 3.86487832 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 53.5 | 7.3e-6 | NR | MBI3911273.1 | 2033014 | g42800 | i0 | 38.4 | 0.928057553956835 | 86 | 45 | 92.8 | 3 | 6 | 263 | 59 | 136 | MBI3911273.1 hypothetical protein [Armatimonadota bacterium] | diamond | 258 | 53.5 | 1 | 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);;