contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1245487" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4178370 | 4178370 | PRJNA1245487_P_NODE_21344_length_244_cov_1.754386_g21006_i0 | PRJNA1245487 | 21344 | 244 | 1.754386 | 4.28070184 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 133 | 6.02e-34 | NR | HET9530953.1 | 2052146 | g21006 | i0 | 72.2 | 5.76639344262295 | 79 | 22 | 97.1 | 0 | 1 | 237 | 813 | 891 | HET9530953.1 PIG-L family deacetylase [Blastocatellia bacterium] | diamond | 1407 | 133 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 29662591 | 29662591 | PRJNA1245487_P_NODE_15470_length_287_cov_1.308411_g15132_i0 | PRJNA1245487 | 15470 | 287 | 1.308411 | 3.75513957 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 75.9 | 1.23e-13 | NR | MEO8679489.1 | 2910147 | g15132 | i0 | 47.3 | 0.773519163763066 | 74 | 36 | 77.4 | 1 | 231 | 10 | 32 | 102 | MEO8679489.1 thrombospondin type-1 domain-containing protein [Vicinamibacterales bacterium] | diamond | 222 | 75.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 29662595 | 29662595 | PRJNA1245487_P_NODE_21470_length_244_cov_0.912281_g21132_i0 | PRJNA1245487 | 21470 | 244 | 0.912281 | 2.22596564 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 80.9 | 8.08e-17 | NR | PYS87729.1 | 1978231 | g21132 | i0 | 58.7 | 0.922131147540984 | 75 | 31 | 92.2 | 0 | 242 | 18 | 111 | 185 | PYS87729.1 MAG: hypothetical protein DMF62_11470 [Acidobacteriota bacterium] | diamond | 225 | 80.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31228901 | 31228901 | PRJNA1245487_P_NODE_20475_length_248_cov_0.891429_g20137_i0 | PRJNA1245487 | 20475 | 248 | 0.891429 | 2.21074392 | Bacteria | 2 | Bacteria | Bacteria | 98.2 | 1.2300000000000002e-21 | NR | MBK6587192.1 | 1978231 | g20137 | i0 | 67.9 | 1.88709677419355 | 78 | 23 | 91.9 | 1 | 230 | 3 | 875 | 952 | MBK6587192.1 LamG domain-containing protein [Acidobacteriota bacterium] | diamond | 468 | 98.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31292283 | 31292283 | PRJNA1245487_P_NODE_22035_length_242_cov_0.923077_g21697_i0 | PRJNA1245487 | 22035 | 242 | 0.923077 | 2.23384634 | Bacteria | 2 | Bacteria | Bacteria | 152 | 1.04e-40 | NR | MEP7149289.1 | 1978231 | g21697 | i0 | 93.8 | 1.98347107438017 | 80 | 5 | 99.2 | 0 | 242 | 3 | 102 | 181 | MEP7149289.1 efflux RND transporter permease subunit [Acidobacteriota bacterium] | diamond | 480 | 152 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31938366 | 31938366 | PRJNA1245487_P_NODE_19957_length_250_cov_0.881356_g19619_i0 | PRJNA1245487 | 19957 | 250 | 0.881356 | 2.20339 | Candidatus Angelobacter sp. | 2976921 | Bacteria | Bacteria | 56.2 | 5.39e-7 | NR | HXA27752.1 | 2976921 | g19619 | i0 | 47.2 | 1.692 | 53 | 28 | 63.6 | 0 | 161 | 3 | 4 | 56 | HXA27752.1 thioesterase family protein [Candidatus Angelobacter sp.] | diamond | 423 | 56.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Angelobacter | Candidatus Angelobacter sp. | ||||
| 32413258 | 32413258 | PRJNA1245487_P_NODE_15819_length_283_cov_1.485714_g15481_i0 | PRJNA1245487 | 15819 | 283 | 1.485714 | 4.20457062 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 74.3 | 4.2e-13 | NR | MEW6732442.1 | 1978231 | g15481 | i0 | 63 | 0.975265017667845 | 92 | 29 | 93.3 | 2 | 9 | 272 | 208 | 298 | MEW6732442.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 276 | 74.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota 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);;