contig_metadata
3 rows where bioproject = "PRJNA637219", tax_kingdom = "Metazoa" and tax_phylum = "Nematoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30554746 | 30554746 | PRJNA637219_S_NODE_6253_length_203_cov_0.993506_g6208_i0 | PRJNA637219 | 6253 | 203 | 0.993506 | 2.01681718 | Bursaphelenchus okinawaensis | 465554 | Nematoda | Nematoda | 57.4 | 1.45e-7 | NR | CAD5210568.1 | 465554 | g6208 | i0 | 45.2 | 0.916256157635468 | 62 | 34 | 91.6 | 0 | 12 | 197 | 10 | 71 | CAD5210568.1 unnamed protein product [Bursaphelenchus okinawaensis] | diamond | 186 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus okinawaensis | |
| 31724429 | 31724429 | PRJNA637219_S_NODE_9877_length_171_cov_1.196721_g9832_i0 | PRJNA637219 | 9877 | 171 | 1.196721 | 2.04639291 | Trichinella sp. T6 | 92179 | Nematoda | Nematoda | 38.9 | 0.0442 | NR | KRX30208.1 | 92179 | g9832 | i0 | 67.9 | 0.491228070175439 | 28 | 9 | 49.1 | 0 | 81 | 164 | 4 | 31 | KRX30208.1 hypothetical protein T06_7420, partial [Trichinella sp. T6] | diamond | 84 | 38.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella sp. T6 | |
| 31800052 | 31800052 | PRJNA637219_S_NODE_6337_length_202_cov_1.000000_g6292_i0 | PRJNA637219 | 6337 | 202 | 1 | 2.02 | Opisthokonta | 33154 | Nematoda | Nematoda | 85.9 | 9.6e-18 | NR | KAI6189471.1 | 293665 | g6292 | i0 | 57.6 | 3.6831683168316798 | 66 | 28 | 98 | 0 | 3 | 200 | 110 | 175 | KAI6189471.1 Notchless-like protein 1 [Aphelenchoides bicaudatus] | diamond | 744 | 86.7 | 0.990772779700115 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides bicaudatus |
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);;