contig_metadata
3 rows where analysis = "diamond", bioproject = "PRJNA1237347" and tax_phylum = "Candidatus Walliibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28336723 | 28336723 | PRJNA1237347_P_NODE_93386_length_712_cov_1.935837_g87083_i0 | PRJNA1237347 | 93386 | 712 | 1.935837 | 13.78315944 | Candidatus Wallbacteria bacterium | 2053640 | Bacteria | Bacteria | 162 | 2.51e-43 | NR | MBI4869439.1 | 2053640 | g87083 | i0 | 54.5 | 4.3061797752809 | 145 | 62 | 59.4 | 1 | 693 | 271 | 36 | 180 | MBI4869439.1 CHAP domain-containing protein [Candidatus Wallbacteria bacterium] | diamond | 3066 | 162 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Walliibacteriota | Candidatus Wallbacteria bacterium | ||||||
| 28765230 | 28765230 | PRJNA1237347_P_NODE_399847_length_279_cov_10.776699_g393274_i0 | PRJNA1237347 | 399847 | 279 | 10.776699 | 30.06699021 | Bacteria | 2 | Bacteria | Bacteria | 48.1 | 7.68e-4 | NR | MBI3892509.1 | 2053640 | g393274 | i0 | 39 | 1.61290322580645 | 82 | 44 | 87.1 | 3 | 4 | 246 | 611 | 687 | MBI3892509.1 hypothetical protein [Candidatus Wallbacteria bacterium] | diamond | 450 | 48.5 | 0.991752577319588 | Bacteria | Bacteria candidate phyla | Candidatus Walliibacteriota | Candidatus Wallbacteria bacterium | ||||||
| 32317834 | 32317834 | PRJNA1237347_P_NODE_177799_length_469_cov_0.972222_g171228_i0 | PRJNA1237347 | 177799 | 469 | 0.972222 | 4.55972118 | Candidatus Wallbacteria bacterium | 2053640 | Bacteria | Bacteria | 65.9 | 3.45e-9 | NR | HPG58547.1 | 2053640 | g171228 | i0 | 29 | 2.37953091684435 | 124 | 87 | 78.7 | 1 | 93 | 461 | 181 | 304 | HPG58547.1 NAD-glutamate dehydrogenase [Candidatus Wallbacteria bacterium] | diamond | 1116 | 65.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Walliibacteriota | Candidatus Wallbacteria 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);;