contig_metadata
5 rows where bioproject = "PRJNA352610", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26662965 | 26662965 | PRJNA352610_P_NODE_22481_length_265_cov_1.604167_g22420_i0 | PRJNA352610 | 22481 | 265 | 1.604167 | 4.25104255 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 103 | 4.68e-24 | NR | MEI7985897.1 | 2033014 | g22420 | i0 | 59.8 | 0.984905660377358 | 87 | 34 | 98.5 | 1 | 5 | 265 | 138 | 223 | MEI7985897.1 glycoside hydrolase family 5 protein [Armatimonadota bacterium] | diamond | 261 | 103 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27422682 | 27422682 | PRJNA352610_P_NODE_32103_length_241_cov_0.863095_g32042_i0 | PRJNA352610 | 32103 | 241 | 0.863095 | 2.08005895 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 74.3 | 6.62e-14 | NR | GDX40226.1 | 2033014 | g32042 | i0 | 52.6 | 1.61825726141079 | 76 | 33 | 92.1 | 2 | 228 | 7 | 159 | 233 | GDX40226.1 hypothetical protein LBMAG21_05180 [Armatimonadota bacterium] | diamond | 390 | 74.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28369591 | 28369591 | PRJNA352610_P_NODE_3046_length_577_cov_1.990079_g2985_i0 | PRJNA352610 | 3046 | 577 | 1.990079 | 11.48275583 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 125 | 4.65e-32 | NR | GDX40226.1 | 2033014 | g2985 | i0 | 48.9 | 0.733102253032929 | 141 | 67 | 71.8 | 4 | 2 | 415 | 96 | 234 | GDX40226.1 hypothetical protein LBMAG21_05180 [Armatimonadota bacterium] | diamond | 423 | 125 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28401248 | 28401248 | PRJNA352610_P_NODE_9806_length_372_cov_0.832776_g9745_i0 | PRJNA352610 | 9806 | 372 | 0.832776 | 3.09792672 | Capsulimonas sp. | 2494211 | Bacteria | Bacteria | 91.7 | 1.07e-18 | NR | MCW3061757.1 | 2494211 | g9745 | i0 | 49.5 | 2.20161290322581 | 91 | 39 | 73.4 | 3 | 96 | 368 | 384 | 467 | MCW3061757.1 putative glycosyl hydrolase [Capsulimonas sp.] | diamond | 819 | 91.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas sp. | ||
| 31387740 | 31387740 | PRJNA352610_P_NODE_236_length_1376_cov_1.535687_g223_i0 | PRJNA352610 | 236 | 1376 | 1.535687 | 21.13105312 | PVC group | 1783257 | Bacteria | Bacteria | 359 | 2.3499999999999998e-112 | NR | HET6386082.1 | 2033014 | g223 | i0 | 46.2 | 2.71656976744186 | 411 | 207 | 88.1 | 5 | 1348 | 137 | 40 | 443 | HET6386082.1 pectinesterase family protein [Armatimonadota bacterium] | diamond | 3738 | 359 | 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);;