contig_metadata
6 rows where bioproject = "PRJNA966993" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3492602 | 3492602 | PRJNA966993_P_NODE_14803_length_544_cov_3.055202_g14362_i0 | PRJNA966993 | 14803 | 544 | 3.055202 | 16.62029888 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 58.4 | 0.001 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g14362 | i0 | 90.909 | 0.314338235294118 | 44 | 2 | 8 | 2 | 452 | 493 | 2441084 | 2441127 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 171 | 58.4 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 26899417 | 26899417 | PRJNA966993_P_NODE_98281_length_241_cov_1.833333_g97829_i0 | PRJNA966993 | 98281 | 241 | 1.833333 | 4.41833253 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 63.5 | 1.6e-9 | NR | MCW5937656.1 | 2682144 | g97829 | i0 | 48 | 2.82572614107884 | 75 | 36 | 89.6 | 3 | 221 | 6 | 108 | 182 | MCW5937656.1 HDIG domain-containing protein [Fimbriimonadaceae bacterium] | diamond | 681 | 63.5 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 27594706 | 27594706 | PRJNA966993_P_NODE_39224_length_343_cov_2.314815_g38772_i0 | PRJNA966993 | 39224 | 343 | 2.314815 | 7.93981545 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 48.1 | 0.00138 | NR | MCL5103533.1 | 2033014 | g38772 | i0 | 56.1 | 0.673469387755102 | 41 | 18 | 35.9 | 0 | 161 | 39 | 138 | 178 | MCL5103533.1 2-oxo acid dehydrogenase subunit E2 [Armatimonadota bacterium] | diamond | 231 | 48.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28005289 | 28005289 | PRJNA966993_P_NODE_58205_length_287_cov_1.799065_g57753_i0 | PRJNA966993 | 58205 | 287 | 1.799065 | 5.16331655 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 65.1 | 8.29e-10 | NR | MEI6915611.1 | 2033014 | g57753 | i0 | 45.8 | 4.46341463414634 | 72 | 39 | 75.3 | 0 | 269 | 54 | 46 | 117 | MEI6915611.1 ankyrin repeat domain-containing protein [Armatimonadota bacterium] | diamond | 1281 | 65.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30342417 | 30342417 | PRJNA966993_P_NODE_8212_length_730_cov_2.318113_g7811_i0 | PRJNA966993 | 8212 | 730 | 2.318113 | 16.9222249 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 65.5 | 3.84e-8 | NR | MBS1718040.1 | 2033014 | g7811 | i0 | 51.3 | 0.312328767123288 | 76 | 35 | 30.8 | 2 | 723 | 499 | 24 | 98 | MBS1718040.1 hypothetical protein [Armatimonadota bacterium] | diamond | 228 | 65.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30373851 | 30373851 | PRJNA966993_P_NODE_73792_length_264_cov_2.015707_g73340_i0 | PRJNA966993 | 73792 | 264 | 2.015707 | 5.32146648 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 43.5 | 0.0255 | NR | CAA9240315.1 | 157466 | g73340 | i0 | 44.1 | 0.670454545454545 | 59 | 26 | 65.9 | 3 | 238 | 65 | 602 | 654 | CAA9240315.1 hypothetical protein AVDCRST_MAG63-1504, partial [uncultured Armatimonadetes bacterium] | diamond | 177 | 43.5 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes 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);;