contig_metadata
8 rows where bioproject = "PRJNA1241156", tax_phylum = "Planctomycetota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29536680 | 29536680 | PRJNA1241156_S_NODE_76790_length_200_cov_6.535032_g76330_i0 | PRJNA1241156 | 76790 | 200 | 6.535032 | 13.070064 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 42.4 | 0.0296 | NR | HYG74173.1 | 2026780 | g76330 | i0 | 36 | 0.75 | 50 | 31 | 73.5 | 1 | 194 | 48 | 579 | 628 | HYG74173.1 L-glutamate gamma-semialdehyde dehydrogenase [Planctomycetota bacterium] | diamond | 150 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 29631085 | 29631085 | PRJNA1241156_S_NODE_15870_length_384_cov_3.639296_g15410_i0 | PRJNA1241156 | 15870 | 384 | 3.639296 | 13.97489664 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 48.1 | 0.00217 | NR | MBV8129862.1 | 2026779 | g15410 | i0 | 38.8 | 0.6640625 | 85 | 49 | 66.4 | 1 | 302 | 48 | 81 | 162 | MBV8129862.1 iron ABC transporter permease [Planctomycetaceae bacterium] | diamond | 255 | 48.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 29884190 | 29884190 | PRJNA1241156_S_NODE_64071_length_245_cov_2.881188_g63611_i0 | PRJNA1241156 | 64071 | 245 | 2.881188 | 7.0589106 | Candidatus Scalinduaceae bacterium | 3015208 | Bacteria | Bacteria | 42.7 | 0.0374 | NR | MFQ5962738.1 | 3015208 | g63611 | i0 | 32.8 | 0.820408163265306 | 67 | 34 | 68.6 | 2 | 209 | 42 | 74 | 140 | MFQ5962738.1 dihydrolipoyl dehydrogenase family protein [Candidatus Scalinduaceae bacterium] | diamond | 201 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Candidatus Brocadiia | Candidatus Brocadiales | Candidatus Scalinduaceae | Candidatus Scalinduaceae bacterium | ||
| 30199713 | 30199713 | PRJNA1241156_S_NODE_49052_length_278_cov_3.838298_g48592_i0 | PRJNA1241156 | 49052 | 278 | 3.838298 | 10.67046844 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 43.1 | 0.0404 | NR | MDE1890470.1 | 2026780 | g48592 | i0 | 36.1 | 0.658273381294964 | 61 | 33 | 65.8 | 1 | 204 | 22 | 118 | 172 | MDE1890470.1 NAD(P)/FAD-dependent oxidoreductase [Planctomycetota bacterium] | diamond | 183 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 30263420 | 30263420 | PRJNA1241156_S_NODE_30692_length_328_cov_6.301754_g30232_i0 | PRJNA1241156 | 30692 | 328 | 6.301754 | 20.66975312 | Planctomycetes bacterium MalM25 | 2527998 | Bacteria | Bacteria | 43.9 | 0.0348 | NR | QDT68364.1 | 2527998 | g30232 | i0 | 38.6 | 0.640243902439024 | 70 | 40 | 63.1 | 2 | 3 | 209 | 255 | 322 | QDT68364.1 putative murein peptide carboxypeptidase [Planctomycetes bacterium MalM25] | diamond | 210 | 43.9 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetes bacterium MalM25 | |||||
| 30547496 | 30547496 | PRJNA1241156_S_NODE_18253_length_373_cov_2.045455_g17793_i0 | PRJNA1241156 | 18253 | 373 | 2.045455 | 7.62954715 | Gemmataceae bacterium | 2052164 | Bacteria | Bacteria | 47.4 | 0.00394 | NR | MSQ94020.1 | 2052164 | g17793 | i0 | 34.2 | 0.635388739946381 | 79 | 32 | 51.5 | 3 | 64 | 255 | 1088 | 1161 | MSQ94020.1 serine/threonine protein kinase [Gemmataceae bacterium] | diamond | 237 | 47.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Gemmatales | Gemmataceae | Gemmataceae bacterium | ||
| 32381567 | 32381567 | PRJNA1241156_S_NODE_18399_length_372_cov_4.465046_g17939_i0 | PRJNA1241156 | 18399 | 372 | 4.465046 | 16.60997112 | Planctomycetia bacterium | 2052181 | Bacteria | Bacteria | 45.4 | 0.0167 | NR | GDX94692.1 | 2052181 | g17939 | i0 | 38.2 | 0.548387096774194 | 68 | 37 | 54.8 | 2 | 133 | 336 | 246 | 308 | GDX94692.1 hypothetical protein LBMAG47_03550 [Planctomycetia bacterium] | diamond | 204 | 45.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetia bacterium | ||||
| 32602815 | 32602815 | PRJNA1241156_S_NODE_54260_length_266_cov_1.426009_g53800_i0 | PRJNA1241156 | 54260 | 266 | 1.426009 | 3.79318394 | Sedimentisphaerales bacterium | 2813034 | Bacteria | Bacteria | 46.2 | 0.00278 | NR | MBN2376472.1 | 2813034 | g53800 | i0 | 52.4 | 0.473684210526316 | 42 | 18 | 46.2 | 2 | 51 | 173 | 153 | 193 | MBN2376472.1 Gfo/Idh/MocA family oxidoreductase [Sedimentisphaerales bacterium] | diamond | 126 | 46.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Sedimentisphaerales | Sedimentisphaerales 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);;