contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA529241" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27077509 | 27077509 | PRJNA529241_P_NODE_425062_length_166_cov_2.085271_g422740_i0 | PRJNA529241 | 425062 | 166 | 2.085271 | 3.46154986 | Ostertagia ostertagi | 6317 | Nematoda | Nematoda | 79 | 4.1e-16 | NR | KAK6031660.1 | 6317 | g422740 | i0 | 63.6 | 4.89759036144578 | 55 | 20 | 99.4 | 0 | 2 | 166 | 106 | 160 | KAK6031660.1 DNA (cytosine-5-)-methyltransferase [Ostertagia ostertagi] | diamond | 813 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Ostertagia | Ostertagia ostertagi | |
| 27898553 | 27898553 | PRJNA529241_P_NODE_265425_length_173_cov_4.110294_g263103_i0 | PRJNA529241 | 265425 | 173 | 4.110294 | 7.11080862 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 43.9 | 0.00569 | NR | PAV84478.1 | 2018661 | g263103 | i0 | 90 | 0.346820809248555 | 20 | 2 | 34.7 | 0 | 60 | 1 | 342 | 361 | PAV84478.1 hypothetical protein WR25_18286 [Diploscapter pachys] | diamond | 60 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 29004312 | 29004312 | PRJNA529241_P_NODE_449208_length_157_cov_1.233333_g446886_i0 | PRJNA529241 | 449208 | 157 | 1.233333 | 1.93633281 | Trichinella pseudospiralis | 6337 | Nematoda | Nematoda | 40 | 0.0173 | NR | KRY87651.1 | 6337 | g446886 | i0 | 44.2 | 0.821656050955414 | 43 | 24 | 82.2 | 0 | 157 | 29 | 17 | 59 | KRY87651.1 hypothetical protein T4D_50 [Trichinella pseudospiralis] | diamond | 129 | 40 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella pseudospiralis | |
| 29303134 | 29303134 | PRJNA529241_P_NODE_519889_length_151_cov_3.956140_g517567_i0 | PRJNA529241 | 519889 | 151 | 3.95614 | 5.9737714 | Trichuris | 36086 | Nematoda | Nematoda | 46.2 | 6.45e-4 | NR | CDW54946.1 | 36087 | g517567 | i0 | 76 | 2.48344370860927 | 25 | 6 | 49.7 | 0 | 150 | 76 | 37 | 61 | CDW54946.1 laminin subunit beta 1 [Trichuris trichiura] | diamond | 375 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 29382799 | 29382799 | PRJNA529241_P_NODE_419429_length_168_cov_2.977099_g417107_i0 | PRJNA529241 | 419429 | 168 | 2.977099 | 5.00152632 | Ditylenchus destructor | 166010 | Nematoda | Nematoda | 41.6 | 0.0313 | NR | KAI1698213.1 | 166010 | g417107 | i0 | 33.3 | 0.803571428571429 | 45 | 22 | 66.1 | 1 | 20 | 130 | 134 | 178 | KAI1698213.1 hypothetical protein Ddc_19234 [Ditylenchus destructor] | diamond | 135 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 29982696 | 29982696 | PRJNA529241_P_NODE_314491_length_173_cov_3.323529_g312169_i0 | PRJNA529241 | 314491 | 173 | 3.323529 | 5.74970517 | Cylicocyclus nassatus | 53992 | Nematoda | Nematoda | 53.1 | 3.1e-6 | NR | CAJ0600676.1 | 53992 | g312169 | i0 | 70.6 | 0.589595375722543 | 34 | 10 | 59 | 0 | 103 | 2 | 86 | 119 | CAJ0600676.1 unnamed protein product [Cylicocyclus nassatus] | diamond | 102 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Cylicocyclus | Cylicocyclus nassatus | |
| 30614431 | 30614431 | PRJNA529241_P_NODE_196173_length_173_cov_6.507353_g193851_i0 | PRJNA529241 | 196173 | 173 | 6.507353 | 11.25772069 | Ancylostoma duodenale | 51022 | Nematoda | Nematoda | 45.1 | 0.00129 | NR | KIH55903.1 | 51022 | g193851 | i0 | 81 | 2.1849710982659 | 21 | 4 | 36.4 | 0 | 63 | 1 | 73 | 93 | KIH55903.1 putative phospholipid hydroperoxide glutathione peroxidase [Ancylostoma duodenale] | diamond | 378 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma duodenale | |
| 31025451 | 31025451 | PRJNA529241_P_NODE_415015_length_170_cov_1.187970_g412693_i0 | PRJNA529241 | 415015 | 170 | 1.18797 | 2.019549 | Necator americanus | 51031 | Nematoda | Nematoda | 67.4 | 4.4e-12 | NR | ETN72287.1 | 51031 | g412693 | i0 | 54.9 | 2.71764705882353 | 51 | 23 | 90 | 0 | 164 | 12 | 21 | 71 | ETN72287.1 hypothetical protein NECAME_18912 [Necator americanus] | diamond | 462 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 31483387 | 31483387 | PRJNA529241_P_NODE_517056_length_151_cov_4.096491_g514734_i0 | PRJNA529241 | 517056 | 151 | 4.096491 | 6.18570141 | Rhabditida | 6236 | Nematoda | Nematoda | 43.9 | 6.97e-4 | NR | KAK5967996.1 | 6319 | g514734 | i0 | 64.7 | 5.3841059602649 | 34 | 11 | 65.6 | 1 | 51 | 149 | 36 | 69 | KAK5967996.1 hypothetical protein GCK32_012980 [Trichostrongylus colubriformis] | diamond | 813 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Trichostrongylus | Trichostrongylus colubriformis |
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);;