contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJEB14175" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32922518 | 32922518 | PRJEB14175_P_NODE_249441_length_203_cov_2.746479_g247173_i0 | PRJEB14175 | 249441 | 203 | 2.746479 | 5.57535237 | Opisthokonta | 33154 | Nematoda | Nematoda | 43.9 | 0.00769 | NR | TKR65468.1 | 34508 | g247173 | i0 | 37.5 | 2.03940886699507 | 48 | 29 | 70.9 | 1 | 9 | 152 | 188 | 234 | TKR65468.1 hypothetical protein L596_025871 [Steinernema carpocapsae] | diamond | 414 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 32925498 | 32925498 | PRJEB14175_P_NODE_128185_length_306_cov_15.538776_g125918_i0 | PRJEB14175 | 128185 | 306 | 15.538776 | 47.54865456 | Pristionchus pacificus | 54126 | Nematoda | Nematoda | 43.9 | 0.0301 | NR | KAF8361731.1 | 54126 | g125918 | i0 | 31.7 | 0.803921568627451 | 82 | 49 | 75.5 | 2 | 75 | 305 | 278 | 357 | KAF8361731.1 hypothetical protein PRIPAC_88654, partial [Pristionchus pacificus] | diamond | 246 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 32939921 | 32939921 | PRJEB14175_P_NODE_98993_length_360_cov_1.842809_g96727_i0 | PRJEB14175 | 98993 | 360 | 1.842809 | 6.6341124 | Rhabditida | 6236 | Nematoda | Nematoda | 62 | 2.34e-8 | NR | ETN82032.1 | 51031 | g96727 | i0 | 38.4 | 4.06666666666667 | 99 | 45 | 82.5 | 1 | 53 | 349 | 305 | 387 | ETN82032.1 Gaa1-like, GPI transamidase component [Necator americanus] | diamond | 1464 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 32944589 | 32944589 | PRJEB14175_P_NODE_96514_length_365_cov_14.608553_g94248_i0 | PRJEB14175 | 96514 | 365 | 14.608553 | 53.32121845 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 73.2 | 1.67e-12 | NR | GMT20911.1 | 1538716 | g94248 | i0 | 64.7 | 2.12054794520548 | 51 | 18 | 41.9 | 0 | 344 | 192 | 245 | 295 | GMT20911.1 hypothetical protein PFISCL1PPCAC_12208, partial [Pristionchus fissidentatus] | diamond | 774 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 32956743 | 32956743 | PRJEB14175_P_NODE_132514_length_300_cov_3.368201_g130247_i0 | PRJEB14175 | 132514 | 300 | 3.368201 | 10.104603 | Rhabditida | 6236 | Nematoda | Nematoda | 56.6 | 9.42e-7 | NR | KAH7714618.1 | 70226 | g130247 | i0 | 34.5 | 3.5 | 87 | 50 | 83 | 3 | 25 | 273 | 317 | 400 | KAH7714618.1 Protein CLEC-62 a [Aphelenchoides avenae] | diamond | 1050 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 32991091 | 32991091 | PRJEB14175_P_NODE_209003_length_221_cov_3.206250_g206736_i0 | PRJEB14175 | 209003 | 221 | 3.20625 | 7.0858125 | Trichinella | 6333 | Nematoda | Nematoda | 60.5 | 1.58e-8 | NR | XP_003380888.1 | 6334 | g206736 | i0 | 55.1 | 4.00452488687783 | 49 | 22 | 66.5 | 0 | 3 | 149 | 762 | 810 | XP_003380888.1 Sly1 protein-like protein [Trichinella spiralis] | diamond | 885 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 32994277 | 32994277 | PRJEB14175_P_NODE_166507_length_258_cov_2.045685_g164240_i0 | PRJEB14175 | 166507 | 258 | 2.045685 | 5.2778673 | Mesorhabditis belari | 2138241 | Nematoda | Nematoda | 54.7 | 2.72e-6 | NR | CAJ0938908.1 | 2138241 | g164240 | i0 | 84.8 | 0.383720930232558 | 33 | 4 | 37.2 | 1 | 23 | 118 | 622 | 654 | CAJ0938908.1 unnamed protein product, partial [Mesorhabditis belari] | diamond | 99 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis belari | |
| 33007823 | 33007823 | PRJEB14175_P_NODE_133787_length_298_cov_4.666667_g131520_i0 | PRJEB14175 | 133787 | 298 | 4.666667 | 13.90666766 | root | 1 | Root_unresolved | Root_unresolved | 77 | 6.27e-14 | NR | NP_503467.2 | 6239 | g131520 | i0 | 75.6 | 11.7785234899329 | 45 | 11 | 45.3 | 0 | 22 | 156 | 447 | 491 | NP_503467.2 Aldehyde dehydrogenase domain-containing protein [Caenorhabditis elegans] | diamond | 3510 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 33007949 | 33007949 | PRJEB14175_P_NODE_210195_length_220_cov_5.572327_g207928_i0 | PRJEB14175 | 210195 | 220 | 5.572327 | 12.2591194 | Caenorhabditis | 6237 | Nematoda | Nematoda | 67.8 | 3.36e-12 | NR | UMM29526.1 | 6238 | g207928 | i0 | 81.1 | 1.51363636363636 | 37 | 7 | 50.5 | 0 | 112 | 2 | 100 | 136 | UMM29526.1 hypothetical protein L5515_011840 [Caenorhabditis briggsae] | diamond | 333 | 68.2 | 0.994134897360704 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 33025009 | 33025009 | PRJEB14175_P_NODE_138548_length_291_cov_9.556522_g136281_i0 | PRJEB14175 | 138548 | 291 | 9.556522 | 27.80947902 | Metazoa | 33208 | Nematoda | Nematoda | 53.9 | 8.01e-6 | NR | OUC48404.1 | 6335 | g136281 | i0 | 35.7 | 5.29896907216495 | 84 | 51 | 86.6 | 2 | 258 | 7 | 720 | 800 | OUC48404.1 hypothetical protein D917_06179 [Trichinella nativa] | diamond | 1542 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella nativa | |
| 33028423 | 33028423 | PRJEB14175_P_NODE_166668_length_258_cov_1.360406_g164401_i0 | PRJEB14175 | 166668 | 258 | 1.360406 | 3.50984748 | Bursaphelenchus okinawaensis | 465554 | Nematoda | Nematoda | 42.4 | 0.0452 | NR | CAD5205317.1 | 465554 | g164401 | i0 | 50 | 0.418604651162791 | 36 | 18 | 41.9 | 0 | 258 | 151 | 121 | 156 | CAD5205317.1 unnamed protein product [Bursaphelenchus okinawaensis] | diamond | 108 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus okinawaensis | |
| 33028775 | 33028775 | PRJEB14175_P_NODE_203740_length_225_cov_3.371951_g201473_i0 | PRJEB14175 | 203740 | 225 | 3.371951 | 7.58688975 | Wuchereria bancrofti | 6293 | Nematoda | Nematoda | 95.5 | 9.96e-22 | NR | EJW77387.1 | 6293 | g201473 | i0 | 76 | 1 | 75 | 14 | 96 | 2 | 3 | 218 | 49 | 122 | EJW77387.1 hypothetical protein WUBG_11700 [Wuchereria bancrofti] | diamond | 225 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 33029736 | 33029736 | PRJEB14175_P_NODE_68468_length_446_cov_5.732468_g66210_i0 | PRJEB14175 | 68468 | 446 | 5.732468 | 25.56680728 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 180 | 4.7799999999999986e-55 | NR | PAV58449.1 | 2018661 | g66210 | i0 | 98.9 | 0.632286995515695 | 94 | 1 | 63.2 | 0 | 430 | 149 | 65 | 158 | PAV58449.1 hypothetical protein WR25_12382 [Diploscapter pachys] | diamond | 282 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 33063737 | 33063737 | PRJEB14175_P_NODE_67805_length_448_cov_21.914729_g65547_i0 | PRJEB14175 | 67805 | 448 | 21.914729 | 98.17798592 | Toxocara canis | 6265 | Nematoda | Nematoda | 45.4 | 0.0322 | NR | KHN84969.1 | 6265 | g65547 | i0 | 32.9 | 1.01785714285714 | 76 | 43 | 50.9 | 2 | 54 | 281 | 471 | 538 | KHN84969.1 Histone acetyltransferase Tip60 [Toxocara canis] | diamond | 456 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 33113386 | 33113386 | PRJEB14175_P_NODE_142343_length_286_cov_5.213333_g140076_i0 | PRJEB14175 | 142343 | 286 | 5.213333 | 14.91013238 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 60.5 | 3.37e-8 | NR | PAV70813.1 | 2018661 | g140076 | i0 | 46.5 | 0.744755244755245 | 71 | 33 | 72.4 | 3 | 229 | 23 | 3 | 70 | PAV70813.1 hypothetical protein WR25_23028 [Diploscapter pachys] | diamond | 213 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 33115056 | 33115056 | PRJEB14175_P_NODE_80967_length_405_cov_17.008721_g78705_i0 | PRJEB14175 | 80967 | 405 | 17.008721 | 68.88532005 | Auanema sp. JU1783 | 2878363 | Nematoda | Nematoda | 66.2 | 7.34e-10 | NR | CAI4225152.1 | 2878363 | g78705 | i0 | 37.1 | 0.659259259259259 | 89 | 55 | 65.9 | 1 | 380 | 114 | 179 | 266 | CAI4225152.1 unnamed protein product [Auanema sp. JU1783] | diamond | 267 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Auanema | Auanema sp. JU1783 | |
| 33127339 | 33127339 | PRJEB14175_P_NODE_176215_length_248_cov_4.962567_g173948_i0 | PRJEB14175 | 176215 | 248 | 4.962567 | 12.30716616 | Rhabditida | 6236 | Nematoda | Nematoda | 76.3 | 5.69e-14 | NR | KIH55343.1 | 51022 | g173948 | i0 | 73.1 | 3.10887096774194 | 52 | 14 | 62.9 | 0 | 1 | 156 | 382 | 433 | KIH55343.1 D-family protein [Ancylostoma duodenale] | diamond | 771 | 77 | 0.990909090909091 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma duodenale | |
| 33130788 | 33130788 | PRJEB14175_P_NODE_165807_length_259_cov_1.000000_g163540_i0 | PRJEB14175 | 165807 | 259 | 1 | 2.59 | Necator americanus | 51031 | Nematoda | Nematoda | 97.4 | 9.4e-22 | NR | ETN73472.1 | 51031 | g163540 | i0 | 55.7 | 1.01930501930502 | 88 | 36 | 99.6 | 2 | 1 | 258 | 164 | 250 | ETN73472.1 replication initiation factor, partial [Necator americanus] | diamond | 264 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 33131108 | 33131108 | PRJEB14175_P_NODE_200879_length_227_cov_6.493976_g198612_i0 | PRJEB14175 | 200879 | 227 | 6.493976 | 14.74132552 | Ditylenchus destructor | 166010 | Nematoda | Nematoda | 41.6 | 0.0136 | NR | KAI1731006.1 | 166010 | g198612 | i0 | 43.2 | 0.581497797356828 | 44 | 20 | 51.5 | 1 | 161 | 45 | 6 | 49 | KAI1731006.1 hypothetical protein Ddc_03729 [Ditylenchus destructor] | diamond | 132 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 33131620 | 33131620 | PRJEB14175_P_NODE_260471_length_201_cov_0.914286_g258203_i0 | PRJEB14175 | 260471 | 201 | 0.914286 | 1.83771486 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 100 | 6.5e-23 | NR | NP_506055.2 | 6239 | g258203 | i0 | 72.3 | 3.88059701492537 | 65 | 18 | 97 | 0 | 1 | 195 | 478 | 542 | NP_506055.2 Elongator complex protein 3 [Caenorhabditis elegans] | diamond | 780 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 33161481 | 33161481 | PRJEB14175_P_NODE_237752_length_206_cov_2.896552_g235484_i0 | PRJEB14175 | 237752 | 206 | 2.896552 | 5.96689712 | Metazoa | 33208 | Nematoda | Nematoda | 46.2 | 0.00137 | NR | UMM41932.1 | 6238 | g235484 | i0 | 67.6 | 2.8252427184466 | 37 | 10 | 51 | 1 | 26 | 130 | 601 | 637 | UMM41932.1 hypothetical protein L5515_017967 [Caenorhabditis briggsae] | diamond | 582 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 33161653 | 33161653 | PRJEB14175_P_NODE_83672_length_398_cov_1.848665_g81408_i0 | PRJEB14175 | 83672 | 398 | 1.848665 | 7.3576867 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 44.7 | 0.0413 | NR | KAF8361780.1 | 54126 | g81408 | i0 | 46.7 | 1.57537688442211 | 45 | 18 | 29.4 | 1 | 1 | 117 | 87 | 131 | KAF8361780.1 hypothetical protein PRIPAC_88703, partial [Pristionchus pacificus] | diamond | 627 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 33164290 | 33164290 | PRJEB14175_P_NODE_115552_length_327_cov_7.312030_g113286_i0 | PRJEB14175 | 115552 | 327 | 7.31203 | 23.9103381 | Trichinella nativa | 6335 | Nematoda | Nematoda | 77 | 8.81e-14 | NR | KRZ47762.1 | 6335 | g113286 | i0 | 48.1 | 0.743119266055046 | 81 | 42 | 74.3 | 0 | 305 | 63 | 446 | 526 | KRZ47762.1 hypothetical protein T02_15875 [Trichinella nativa] | diamond | 243 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella nativa |
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);;