contig_metadata
4 rows where bioproject = "PRJNA635874", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4435751 | 4435751 | PRJNA635874_P_NODE_62264_length_245_cov_0.895349_g62117_i0 | PRJNA635874 | 62264 | 245 | 0.895349 | 2.19360505 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 196 | 9.65e-46 | NTclustered | gi|2076449834|gb|CP075365.1| | 2682144 | g62117 | i0 | 82.251 | 21.8775510204082 | 231 | 37 | 93 | 4 | 13 | 241 | 2367360 | 2367132 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome | blastn | 5360 | 196 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 27914563 | 27914563 | PRJNA635874_P_NODE_71865_length_241_cov_0.916667_g71718_i0 | PRJNA635874 | 71865 | 241 | 0.916667 | 2.20916747 | Bacteria | 2 | Bacteria | Bacteria | 114 | 2.3700000000000003e-27 | NR | MBN9503050.1 | 2033014 | g71718 | i0 | 72 | 2.83817427385892 | 75 | 20 | 93.4 | 1 | 225 | 1 | 500 | 573 | MBN9503050.1 S9 family peptidase [Armatimonadota bacterium] | diamond | 684 | 115 | 0.991304347826087 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29007666 | 29007666 | PRJNA635874_P_NODE_73488_length_241_cov_0.916667_g73341_i0 | PRJNA635874 | 73488 | 241 | 0.916667 | 2.20916747 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 95.9 | 1.1e-21 | NR | HZH99299.1 | 2682144 | g73341 | i0 | 57.5 | 0.995850622406639 | 80 | 29 | 99.6 | 1 | 1 | 240 | 10 | 84 | HZH99299.1 PEP-CTERM sorting domain-containing protein [Fimbriimonadaceae bacterium] | diamond | 240 | 95.9 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 29840748 | 29840748 | PRJNA635874_P_NODE_54631_length_248_cov_0.880000_g54484_i0 | PRJNA635874 | 54631 | 248 | 0.88 | 2.1824 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 141 | 7.109999999999999e-38 | NR | WP_025229348.1 | 1005039 | g54484 | i0 | 89.6 | 1.86290322580645 | 77 | 8 | 93.1 | 0 | 247 | 17 | 376 | 452 | WP_025229348.1 aspartate kinase [Fimbriimonas ginsengisoli] | diamond | 462 | 141 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli |
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);;