contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA557895" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9465155 | 9465155 | PRJNA557895_P_NODE_9988_length_288_cov_1.610879_g9633_i0 | PRJNA557895 | 9988 | 288 | 1.610879 | 4.63933152 | Mesorhabditis belari | 2138241 | Nematoda | Nematoda | 161 | 4.1999999999999995e-44 | NR | CAJ0941556.1 | 2138241 | g9633 | i0 | 84.4 | 39.4791666666667 | 90 | 14 | 93.8 | 0 | 11 | 280 | 11 | 100 | CAJ0941556.1 unnamed protein product, partial [Mesorhabditis belari] | diamond | 11370 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis belari | |
| 17114058 | 17114058 | PRJNA557895_P_NODE_3614_length_505_cov_1.989035_g3269_i0 | PRJNA557895 | 3614 | 505 | 1.989035 | 10.04462675 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 234 | 1.07e-75 | NR | NP_001367325.1 | 6239 | g3269 | i0 | 72.8 | 437.952475247525 | 151 | 41 | 89.7 | 0 | 3 | 455 | 31 | 181 | NP_001367325.1 ADP-ribosylation factor 1-like 2 [Caenorhabditis elegans] | diamond | 221166 | 236 | 0.991525423728814 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 18387696 | 18387696 | PRJNA557895_P_NODE_13335_length_253_cov_1.975490_g12980_i0 | PRJNA557895 | 13335 | 253 | 1.97549 | 4.9979897 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 157 | 6.95e-44 | NR | CAD2126524.1 | 390850 | g12980 | i0 | 89.3 | 576.664031620553 | 84 | 9 | 99.6 | 0 | 2 | 253 | 178 | 261 | CAD2126524.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 145896 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 20938531 | 20938531 | PRJNA557895_P_NODE_7897_length_318_cov_1.873606_g7542_i0 | PRJNA557895 | 7897 | 318 | 1.873606 | 5.95806708 | Metazoa | 33208 | Nematoda | Nematoda | 175 | 7.7199999999999995e-53 | NR | VDK67687.1 | 6269 | g7542 | i0 | 80.2 | 61 | 106 | 21 | 100 | 0 | 1 | 318 | 133 | 238 | VDK67687.1 unnamed protein product [Anisakis simplex] | diamond | 19398 | 175 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anisakidae | Anisakis | Anisakis simplex | |
| 28152919 | 28152919 | PRJNA557895_P_NODE_9485_length_294_cov_1.248980_g9130_i0 | PRJNA557895 | 9485 | 294 | 1.24898 | 3.6720012 | Pristionchus entomophagus | 358040 | Nematoda | Nematoda | 77 | 6.78e-15 | NR | GMS98491.1 | 358040 | g9130 | i0 | 41.4 | 2.68367346938776 | 87 | 47 | 84.7 | 2 | 290 | 42 | 117 | 203 | GMS98491.1 hypothetical protein PENTCL1PPCAC_20666, partial [Pristionchus entomophagus] | diamond | 789 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus entomophagus | |
| 28577218 | 28577218 | PRJNA557895_P_NODE_10207_length_286_cov_0.860759_g9852_i0 | PRJNA557895 | 10207 | 286 | 0.860759 | 2.46177074 | Opisthokonta | 33154 | Nematoda | Nematoda | 56.6 | 8.05e-7 | NR | KHJ45755.1 | 68888 | g9852 | i0 | 75.7 | 8.15034965034965 | 37 | 9 | 38.8 | 0 | 258 | 148 | 292 | 328 | KHJ45755.1 26S proteasome subunit P45 family protein [Trichuris suis] | diamond | 2331 | 57 | 0.992982456140351 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 29051028 | 29051028 | PRJNA557895_P_NODE_32688_length_165_cov_0.879310_g32333_i0 | PRJNA557895 | 32688 | 165 | 0.87931 | 1.4508615 | Opisthokonta | 33154 | Nematoda | Nematoda | 42 | 0.0243 | NR | CAD2166874.1 | 390850 | g32333 | i0 | 60.9 | 5.16363636363636 | 23 | 9 | 41.8 | 0 | 95 | 163 | 479 | 501 | CAD2166874.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 852 | 42.4 | 0.990566037735849 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 29257548 | 29257548 | PRJNA557895_P_NODE_13049_length_256_cov_1.251208_g12694_i0 | PRJNA557895 | 13049 | 256 | 1.251208 | 3.20309248 | Trichinella zimbabwensis | 268475 | Nematoda | Nematoda | 49.7 | 8.91e-5 | NR | KRZ00650.1 | 268475 | g12694 | i0 | 38.3 | 1.59375 | 81 | 49 | 94.9 | 1 | 1 | 243 | 111 | 190 | KRZ00650.1 hypothetical protein T11_4116 [Trichinella zimbabwensis] | diamond | 408 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella zimbabwensis | |
| 29366680 | 29366680 | PRJNA557895_P_NODE_38549_length_161_cov_0.910714_g38194_i0 | PRJNA557895 | 38549 | 161 | 0.910714 | 1.46624954 | Trichinella | 6333 | Nematoda | Nematoda | 65.1 | 1.59e-10 | NR | KRZ95624.1 | 92180 | g38194 | i0 | 52.8 | 17.776397515528 | 53 | 25 | 98.8 | 0 | 160 | 2 | 753 | 805 | KRZ95624.1 Retrovirus-related Pol polyprotein from transposon 17.6 [Trichinella sp. T8] | diamond | 2862 | 65.5 | 0.993893129770992 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella sp. T8 | |
| 29541847 | 29541847 | PRJNA557895_P_NODE_1910_length_769_cov_1.554167_g1605_i0 | PRJNA557895 | 1910 | 769 | 1.554167 | 11.95154423 | Trichuris suis | 68888 | Nematoda | Nematoda | 206 | 2.34e-58 | NR | KFD51397.1 | 68888 | g1605 | i0 | 39.8 | 8.98439531859558 | 256 | 154 | 99.9 | 0 | 2 | 769 | 327 | 582 | KFD51397.1 hypothetical protein M513_07802 [Trichuris suis] | diamond | 6909 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 29776947 | 29776947 | PRJNA557895_P_NODE_25291_length_184_cov_1.133333_g24936_i0 | PRJNA557895 | 25291 | 184 | 1.133333 | 2.08533272 | Meloidogyne | 189290 | Nematoda | Nematoda | 53.9 | 1.96e-6 | NR | KAF7633111.1 | 189291 | g24936 | i0 | 38.1 | 6 | 63 | 36 | 99.5 | 2 | 1 | 183 | 444 | 505 | KAF7633111.1 Aminopeptidase [Meloidogyne graminicola] | diamond | 1104 | 54.3 | 0.992633517495396 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 30173559 | 30173559 | PRJNA557895_P_NODE_1852_length_786_cov_1.476255_g1550_i0 | PRJNA557895 | 1852 | 786 | 1.476255 | 11.6033643 | Trichuris suis | 68888 | Nematoda | Nematoda | 73.2 | 1.46e-10 | NR | KHJ39859.1 | 68888 | g1550 | i0 | 47.5 | 1.30152671755725 | 59 | 31 | 22.5 | 0 | 432 | 256 | 666 | 724 | KHJ39859.1 integrase core domain protein [Trichuris suis] | diamond | 1023 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 30236834 | 30236834 | PRJNA557895_P_NODE_30232_length_167_cov_0.864407_g29877_i0 | PRJNA557895 | 30232 | 167 | 0.864407 | 1.44355969 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 79 | 2.29e-15 | NR | KAE9548360.1 | 2598192 | g29877 | i0 | 67.3 | 4.94011976047904 | 55 | 18 | 98.8 | 0 | 165 | 1 | 426 | 480 | KAE9548360.1 hypothetical protein FO519_008427 [Halicephalobus sp. NKZ332] | diamond | 825 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 | |
| 30900482 | 30900482 | PRJNA557895_P_NODE_39314_length_160_cov_3.432432_g38959_i0 | PRJNA557895 | 39314 | 160 | 3.432432 | 5.4918912 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 54.3 | 7.68e-7 | NR | CAD5220209.1 | 6326 | g38959 | i0 | 50 | 0.9375 | 50 | 25 | 93.8 | 0 | 160 | 11 | 40 | 89 | CAD5220209.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 150 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 31279437 | 31279437 | PRJNA557895_P_NODE_24835_length_186_cov_1.014599_g24480_i0 | PRJNA557895 | 24835 | 186 | 1.014599 | 1.88715414 | Gnathostoma spinigerum | 75299 | Nematoda | Nematoda | 63.9 | 5.95e-10 | NR | MFH4974472.1 | 75299 | g24480 | i0 | 61.2 | 0.790322580645161 | 49 | 19 | 79 | 0 | 168 | 22 | 257 | 305 | MFH4974472.1 hypothetical protein [Gnathostoma spinigerum] | diamond | 147 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gnathostomatidae | Gnathostoma | Gnathostoma spinigerum | |
| 32323859 | 32323859 | PRJNA557895_P_NODE_20439_length_205_cov_1.660256_g20084_i0 | PRJNA557895 | 20439 | 205 | 1.660256 | 3.4035248 | Caenorhabditis angaria | 860376 | Nematoda | Nematoda | 63.2 | 1.46e-9 | NR | CAI5455806.1 | 860376 | g20084 | i0 | 44.3 | 1.02439024390244 | 70 | 36 | 99.5 | 2 | 205 | 2 | 19 | 87 | CAI5455806.1 unnamed protein product [Caenorhabditis angaria] | diamond | 210 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis angaria | |
| 32513647 | 32513647 | PRJNA557895_P_NODE_16779_length_225_cov_0.829545_g16424_i0 | PRJNA557895 | 16779 | 225 | 0.829545 | 1.86647625 | Cercopithifilaria johnstoni | 2874296 | Nematoda | Nematoda | 48.1 | 3.84e-4 | NR | CAG9535345.1 | 2874296 | g16424 | i0 | 48.9 | 0.6 | 45 | 22 | 58.7 | 1 | 70 | 201 | 45 | 89 | CAG9535345.1 unnamed protein product [Cercopithifilaria johnstoni] | diamond | 135 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Cercopithifilaria | Cercopithifilaria johnstoni | |
| 32576734 | 32576734 | PRJNA557895_P_NODE_12719_length_259_cov_1.814286_g12364_i0 | PRJNA557895 | 12719 | 259 | 1.814286 | 4.69900074 | Trichuris suis | 68888 | Nematoda | Nematoda | 70.9 | 5.84e-12 | NR | KFD64270.1 | 68888 | g12364 | i0 | 41.3 | 3.70656370656371 | 80 | 47 | 92.7 | 0 | 258 | 19 | 626 | 705 | KFD64270.1 LOW QUALITY PROTEIN: hypothetical protein M514_12712 [Trichuris suis] | diamond | 960 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 32873943 | 32873943 | PRJNA557895_P_NODE_5160_length_399_cov_2.037143_g4805_i0 | PRJNA557895 | 5160 | 399 | 2.037143 | 8.12820057 | Metazoa | 33208 | Nematoda | Nematoda | 124 | 1.31e-33 | NR | CDW53287.1 | 36087 | g4805 | i0 | 59 | 13.3984962406015 | 100 | 41 | 75.2 | 0 | 359 | 60 | 16 | 115 | CDW53287.1 Ribosomal L31e domain containing protein [Trichuris trichiura] | diamond | 5346 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura |
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);;