contig_metadata
9 rows where bioproject = "PRJNA1032461" and tax_phylum = "Abditibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26654986 | 26654986 | PRJNA1032461_S_NODE_20141_length_163_cov_0.912281_g20043_i0 | PRJNA1032461 | 20141 | 163 | 0.912281 | 1.48701803 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 61.6 | 2.78e-9 | NR | BCM93840.1 | 2783868 | g20043 | i0 | 64.8 | 1.98773006134969 | 54 | 19 | 99.4 | 0 | 162 | 1 | 1204 | 1257 | BCM93840.1 hypothetical protein IAD21_05731 [Abditibacteriota bacterium] | diamond | 324 | 61.6 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 28456476 | 28456476 | PRJNA1032461_S_NODE_6786_length_228_cov_1.162011_g6688_i0 | PRJNA1032461 | 6786 | 228 | 1.162011 | 2.64938508 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 53.5 | 4.05e-6 | NR | MBV9868971.1 | 2800791 | g6688 | i0 | 36.2 | 2.64473684210526 | 69 | 44 | 90.8 | 0 | 5 | 211 | 154 | 222 | MBV9868971.1 hypothetical protein [Abditibacteriaceae bacterium] | diamond | 603 | 53.5 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 28929967 | 28929967 | PRJNA1032461_S_NODE_21088_length_162_cov_1.141593_g20990_i0 | PRJNA1032461 | 21088 | 162 | 1.141593 | 1.84938066 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 89.7 | 8.3e-20 | NR | HEY0076363.1 | 2800791 | g20990 | i0 | 81.1 | 0.981481481481482 | 53 | 10 | 98.1 | 0 | 3 | 161 | 146 | 198 | HEY0076363.1 exopolyphosphatase [Abditibacteriaceae bacterium] | diamond | 159 | 89.7 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 29056379 | 29056379 | PRJNA1032461_S_NODE_19648_length_164_cov_0.904348_g19550_i0 | PRJNA1032461 | 19648 | 164 | 0.904348 | 1.48313072 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 73.6 | 1.52e-13 | NR | HEX8464969.1 | 2109264 | g19550 | i0 | 68.5 | 1.97560975609756 | 54 | 17 | 98.8 | 0 | 1 | 162 | 113 | 166 | HEX8464969.1 aminomethyl-transferring glycine dehydrogenase subunit GcvPA [Abditibacterium sp.] | diamond | 324 | 73.6 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 29403593 | 29403593 | PRJNA1032461_S_NODE_21489_length_162_cov_0.920354_g21391_i0 | PRJNA1032461 | 21489 | 162 | 0.920354 | 1.49097348 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 64.7 | 2.27e-10 | NR | BCM92614.1 | 2783868 | g21391 | i0 | 54.7 | 0.981481481481482 | 53 | 24 | 98.1 | 0 | 162 | 4 | 246 | 298 | BCM92614.1 hypothetical protein IAD21_04496 [Abditibacteriota bacterium] | diamond | 159 | 64.7 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 30066659 | 30066659 | PRJNA1032461_S_NODE_17972_length_165_cov_1.215517_g17874_i0 | PRJNA1032461 | 17972 | 165 | 1.215517 | 2.00560305 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 82.4 | 1.13e-17 | NR | HVF11090.1 | 2800791 | g17874 | i0 | 69.1 | 1 | 55 | 17 | 100 | 0 | 1 | 165 | 82 | 136 | HVF11090.1 hypothetical protein [Abditibacteriaceae bacterium] | diamond | 165 | 82.4 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 30320061 | 30320061 | PRJNA1032461_S_NODE_8872_length_205_cov_1.000000_g8774_i0 | PRJNA1032461 | 8872 | 205 | 1 | 2.05 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 66.2 | 2.9e-11 | NR | BCM88335.1 | 2783868 | g8774 | i0 | 91.4 | 0.51219512195122 | 35 | 3 | 51.2 | 0 | 57 | 161 | 13 | 47 | BCM88335.1 hypothetical protein IAD21_00166 [Abditibacteriota bacterium] | diamond | 105 | 66.2 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 31520604 | 31520604 | PRJNA1032461_S_NODE_18676_length_165_cov_0.896552_g18578_i0 | PRJNA1032461 | 18676 | 165 | 0.896552 | 1.4793108 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 108 | 1.02e-25 | NR | BCM91240.1 | 2783868 | g18578 | i0 | 85.2 | 0.981818181818182 | 54 | 8 | 98.2 | 0 | 3 | 164 | 46 | 99 | BCM91240.1 cellulose synthase catalytic subunit [UDP-forming] [Abditibacteriota bacterium] | diamond | 162 | 108 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 31678482 | 31678482 | PRJNA1032461_S_NODE_21597_length_162_cov_0.920354_g21499_i0 | PRJNA1032461 | 21597 | 162 | 0.920354 | 1.49097348 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 61.6 | 2.64e-9 | NR | BCM91818.1 | 2783868 | g21499 | i0 | 52.9 | 0.944444444444444 | 51 | 24 | 94.4 | 0 | 155 | 3 | 303 | 353 | BCM91818.1 hypothetical protein IAD21_03694 [Abditibacteriota bacterium] | diamond | 153 | 61.6 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota 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);;