contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1199330" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17622337 | 17622337 | PRJNA1199330_P_NODE_93954_length_259_cov_2.279570_g93255_i0 | PRJNA1199330 | 93954 | 259 | 2.27957 | 5.9040863 | root | 1 | Root_unresolved | Root_unresolved | 65.1 | 3.2e-11 | NR | KRY02015.1 | 6337 | g93255 | i0 | 66.7 | 8.97683397683398 | 48 | 15 | 55.6 | 1 | 9 | 152 | 71 | 117 | KRY02015.1 Glutathione peroxidase, partial [Trichinella pseudospiralis] | diamond | 2325 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella pseudospiralis | |
| 27293787 | 27293787 | PRJNA1199330_P_NODE_25863_length_404_cov_3.731118_g25167_i0 | PRJNA1199330 | 25863 | 404 | 3.731118 | 15.07371672 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 45.8 | 0.00369 | NR | CAD5209027.1 | 6326 | g25167 | i0 | 44.4 | 0.334158415841584 | 45 | 24 | 33.4 | 1 | 395 | 261 | 56 | 99 | CAD5209027.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 135 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 27660276 | 27660276 | PRJNA1199330_P_NODE_75724_length_276_cov_3.014778_g75025_i0 | PRJNA1199330 | 75724 | 276 | 3.014778 | 8.32078728 | Rhabditida | 6236 | Nematoda | Nematoda | 43.1 | 0.0336 | NR | KIH56863.1 | 51022 | g75025 | i0 | 48.8 | 0.880434782608696 | 41 | 21 | 44.6 | 0 | 121 | 243 | 135 | 175 | KIH56863.1 tetratricopeptide repeat protein, partial [Ancylostoma duodenale] | diamond | 243 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma duodenale | |
| 28146597 | 28146597 | PRJNA1199330_P_NODE_41445_length_320_cov_2.186235_g40746_i0 | PRJNA1199330 | 41445 | 320 | 2.186235 | 6.995952 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 49.3 | 4.06e-4 | NR | CAJ0573541.1 | 96644 | g40746 | i0 | 39.5 | 0.80625 | 43 | 26 | 40.3 | 0 | 314 | 186 | 26 | 68 | CAJ0573541.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 258 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 28418113 | 28418113 | PRJNA1199330_P_NODE_56266_length_294_cov_1.959276_g55567_i0 | PRJNA1199330 | 56266 | 294 | 1.959276 | 5.76027144 | Strongylidae | 27830 | Nematoda | Nematoda | 74.3 | 1.45e-13 | NR | VDM70366.1 | 40348 | g55567 | i0 | 42.2 | 2.56122448979592 | 83 | 41 | 79.6 | 3 | 286 | 53 | 123 | 203 | VDM70366.1 unnamed protein product, partial [Strongylus vulgaris] | diamond | 753 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Strongylus | Strongylus vulgaris | |
| 31937354 | 31937354 | PRJNA1199330_P_NODE_69197_length_282_cov_2.641148_g68498_i0 | PRJNA1199330 | 69197 | 282 | 2.641148 | 7.44803736 | Auanema sp. JU1783 | 2878363 | Nematoda | Nematoda | 43.1 | 0.0417 | NR | CAI4232656.1 | 2878363 | g68498 | i0 | 36.2 | 0.617021276595745 | 58 | 37 | 61.7 | 0 | 280 | 107 | 407 | 464 | CAI4232656.1 unnamed protein product [Auanema sp. JU1783] | diamond | 174 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Auanema | Auanema sp. JU1783 | |
| 32746594 | 32746594 | PRJNA1199330_P_NODE_41820_length_318_cov_3.457143_g41121_i0 | PRJNA1199330 | 41820 | 318 | 3.457143 | 10.99371474 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.5 | 0.0229 | NR | EJW88476.1 | 6293 | g41121 | i0 | 39.6 | 1 | 48 | 29 | 45.3 | 0 | 11 | 154 | 9 | 56 | EJW88476.1 calcyphosin [Wuchereria bancrofti] | diamond | 318 | 43.9 | 0.990888382687927 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti |
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);;