contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA432257" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2980202 | 2980202 | PRJNA432257_S_NODE_33563_length_268_cov_10.346320_g33182_i0 | PRJNA432257 | 33563 | 268 | 10.34632 | 27.7281376 | Rhabditida | 6236 | Nematoda | Nematoda | 79.3 | 6.51e-17 | NR | NP_496375.1 | 6239 | g33182 | i0 | 92.1 | 5.95522388059702 | 38 | 3 | 42.5 | 0 | 235 | 122 | 68 | 105 | NP_496375.1 Large ribosomal subunit protein eL42 [Caenorhabditis elegans] | diamond | 1596 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 11908719 | 11908719 | PRJNA432257_S_NODE_6410_length_478_cov_35.739229_g6113_i0 | PRJNA432257 | 6410 | 478 | 35.739229 | 170.83351462 | Aphelenchoides besseyi | 269767 | Nematoda | Nematoda | 240 | 6.55e-74 | NR | YP_009092396.1 | 269767 | g6113 | i0 | 72.2 | 0.99163179916318 | 158 | 44 | 99.2 | 0 | 478 | 5 | 363 | 520 | YP_009092396.1 cytochrome c oxidase subunit I [Aphelenchoides besseyi] | diamond | 474 | 240 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 26600665 | 26600665 | PRJNA432257_S_NODE_76821_length_196_cov_3.138365_g76440_i0 | PRJNA432257 | 76821 | 196 | 3.138365 | 6.1511954 | Dictyocaulus viviparus | 29172 | Nematoda | Nematoda | 73.6 | 2.49e-14 | NR | KJH46816.1 | 29172 | g76440 | i0 | 62.5 | 0.857142857142857 | 56 | 21 | 85.7 | 0 | 168 | 1 | 18 | 73 | KJH46816.1 ribosomal protein L14p/L23e [Dictyocaulus viviparus] | diamond | 168 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Dictyocaulus | Dictyocaulus viviparus | |
| 26663994 | 26663994 | PRJNA432257_S_NODE_37741_length_257_cov_1.772727_g37360_i0 | PRJNA432257 | 37741 | 257 | 1.772727 | 4.55590839 | Globodera pallida | 36090 | Nematoda | Nematoda | 67.4 | 1.33e-12 | NR | KAI3413774.1 | 36090 | g37360 | i0 | 61.3 | 0.723735408560311 | 62 | 24 | 72.4 | 0 | 198 | 13 | 1 | 62 | KAI3413774.1 hypothetical protein GPALN_011255 [Globodera pallida] | diamond | 186 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Globodera | Globodera pallida | |
| 26997168 | 26997168 | PRJNA432257_S_NODE_113762_length_162_cov_3.008000_g113381_i0 | PRJNA432257 | 113762 | 162 | 3.008 | 4.87296 | Rhabditida | 6236 | Nematoda | Nematoda | 46.6 | 5.38e-4 | NR | RCN33322.1 | 29170 | g113381 | i0 | 59.3 | 3.01851851851852 | 27 | 11 | 50 | 0 | 131 | 51 | 149 | 175 | RCN33322.1 transporter, cation channel family protein [Ancylostoma caninum] | diamond | 489 | 47 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma caninum | |
| 27202021 | 27202021 | PRJNA432257_S_NODE_125222_length_152_cov_2.504348_g124841_i0 | PRJNA432257 | 125222 | 152 | 2.504348 | 3.80660896 | Wuchereria bancrofti | 6293 | Nematoda | Nematoda | 45.1 | 0.00166 | NR | VDM09488.1 | 6293 | g124841 | i0 | 49.1 | 1.04605263157895 | 53 | 23 | 96.7 | 1 | 5 | 151 | 1073 | 1125 | VDM09488.1 unnamed protein product, partial [Wuchereria bancrofti] | diamond | 159 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 27202049 | 27202049 | PRJNA432257_S_NODE_64862_length_209_cov_167.052326_g64481_i0 | PRJNA432257 | 64862 | 209 | 167.052326 | 349.13936134 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 57.4 | 1.62e-7 | NR | PAV84803.1 | 2018661 | g64481 | i0 | 90.6 | 0.45933014354067 | 32 | 3 | 45.9 | 0 | 207 | 112 | 276 | 307 | PAV84803.1 hypothetical protein WR25_13707 [Diploscapter pachys] | diamond | 96 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 27770963 | 27770963 | PRJNA432257_S_NODE_110804_length_165_cov_4.000000_g110423_i0 | PRJNA432257 | 110804 | 165 | 4 | 6.6 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 45.1 | 0.00184 | NR | PAV84662.1 | 2018661 | g110423 | i0 | 100 | 0.345454545454545 | 19 | 0 | 34.5 | 0 | 96 | 40 | 1 | 19 | PAV84662.1 hypothetical protein WR25_00754 [Diploscapter pachys] | diamond | 57 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 28086402 | 28086402 | PRJNA432257_S_NODE_69585_length_204_cov_1.814371_g69204_i0 | PRJNA432257 | 69585 | 204 | 1.814371 | 3.70131684 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 110 | 1.9999999999999998e-26 | NR | KAE9555324.1 | 2598192 | g69204 | i0 | 83.1 | 0.867647058823529 | 59 | 10 | 86.8 | 0 | 177 | 1 | 352 | 410 | KAE9555324.1 hypothetical protein FO519_001483 [Halicephalobus sp. NKZ332] | diamond | 177 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 | |
| 28307554 | 28307554 | PRJNA432257_S_NODE_127846_length_150_cov_2.407080_g127465_i0 | PRJNA432257 | 127846 | 150 | 2.40708 | 3.61062 | Pratylenchus goodeyi | 344392 | Nematoda | Nematoda | 57 | 9.83e-8 | NR | AIW66697.1 | 344392 | g127465 | i0 | 81.1 | 0.74 | 37 | 7 | 74 | 0 | 1 | 111 | 319 | 355 | AIW66697.1 calreticulin [Pratylenchus goodeyi] | diamond | 111 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus goodeyi | |
| 28355443 | 28355443 | PRJNA432257_S_NODE_39646_length_252_cov_2.827907_g39265_i0 | PRJNA432257 | 39646 | 252 | 2.827907 | 7.12632564 | Strongylidae | 27830 | Nematoda | Nematoda | 85.1 | 1.27e-18 | NR | VDM68672.1 | 40348 | g39265 | i0 | 57.1 | 2.25 | 63 | 27 | 75 | 0 | 2 | 190 | 101 | 163 | VDM68672.1 unnamed protein product [Strongylus vulgaris] | diamond | 567 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Strongylus | Strongylus vulgaris | |
| 28450466 | 28450466 | PRJNA432257_S_NODE_94986_length_180_cov_6.020979_g94605_i0 | PRJNA432257 | 94986 | 180 | 6.020979 | 10.8377622 | Metazoa | 33208 | Nematoda | Nematoda | 61.6 | 3.35e-9 | NR | MCP9258597.1 | 6287 | g94605 | i0 | 93.3 | 23 | 30 | 2 | 50 | 0 | 44 | 133 | 379 | 408 | MCP9258597.1 Ribose-phosphate pyrophosphokinase 1 [Dirofilaria immitis] | diamond | 4140 | 62 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Dirofilaria | Dirofilaria immitis | |
| 28591793 | 28591793 | PRJNA432257_S_NODE_29667_length_280_cov_18.341564_g29286_i0 | PRJNA432257 | 29667 | 280 | 18.341564 | 51.3563792 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 43.5 | 0.0135 | NR | CAD2127486.1 | 390850 | g29286 | i0 | 47.8 | 0.492857142857143 | 46 | 23 | 48.2 | 1 | 33 | 167 | 55 | 100 | CAD2127486.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 138 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 28591819 | 28591819 | PRJNA432257_S_NODE_85187_length_188_cov_3.549669_g84806_i0 | PRJNA432257 | 85187 | 188 | 3.549669 | 6.67337772 | Mesorhabditis belari | 2138241 | Nematoda | Nematoda | 75.5 | 5.12e-14 | NR | CAJ0961104.1 | 2138241 | g84806 | i0 | 66.1 | 0.893617021276596 | 56 | 18 | 87.8 | 1 | 187 | 23 | 373 | 428 | CAJ0961104.1 unnamed protein product, partial [Mesorhabditis belari] | diamond | 168 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis belari | |
| 28623440 | 28623440 | PRJNA432257_S_NODE_9267_length_420_cov_3.195822_g8920_i0 | PRJNA432257 | 9267 | 420 | 3.195822 | 13.4224524 | Aphelenchoides fujianensis | 1052528 | Nematoda | Nematoda | 148 | 5.749999999999998e-42 | NR | KAI6228962.1 | 1052528 | g8920 | i0 | 71.1 | 0.642857142857143 | 90 | 26 | 64.3 | 0 | 415 | 146 | 117 | 206 | KAI6228962.1 hypothetical protein M3Y99_01167900 [Aphelenchoides fujianensis] | diamond | 270 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides fujianensis | |
| 29128680 | 29128680 | PRJNA432257_S_NODE_119469_length_157_cov_1.916667_g119088_i0 | PRJNA432257 | 119469 | 157 | 1.916667 | 3.00916719 | Aphelenchoides avenae | 70226 | Nematoda | Nematoda | 63.2 | 6.84e-10 | NR | KAH7723830.1 | 70226 | g119088 | i0 | 60.8 | 0.974522292993631 | 51 | 20 | 97.5 | 0 | 4 | 156 | 36 | 86 | KAH7723830.1 Protein SMD-1 [Aphelenchoides avenae] | diamond | 153 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 29191727 | 29191727 | PRJNA432257_S_NODE_86389_length_187_cov_2.600000_g86008_i0 | PRJNA432257 | 86389 | 187 | 2.6 | 4.862 | Aphelenchoides besseyi | 269767 | Nematoda | Nematoda | 115 | 1.66e-30 | NR | KAI6202925.1 | 269767 | g86008 | i0 | 91.8 | 2.93582887700535 | 61 | 5 | 97.9 | 0 | 185 | 3 | 140 | 200 | KAI6202925.1 Rab-10 [Aphelenchoides besseyi] | diamond | 549 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 29791292 | 29791292 | PRJNA432257_S_NODE_16631_length_342_cov_166.432787_g16250_i0 | PRJNA432257 | 16631 | 342 | 166.432787 | 569.20013154 | Caenorhabditis brenneri | 135651 | Nematoda | Nematoda | 44.3 | 0.0339 | NR | CAL2033722.1 | 135651 | g16250 | i0 | 50 | 0.280701754385965 | 32 | 16 | 28.1 | 0 | 13 | 108 | 321 | 352 | CAL2033722.1 unnamed protein product [Caenorhabditis brenneri] | diamond | 96 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis brenneri | |
| 29839493 | 29839493 | PRJNA432257_S_NODE_125491_length_152_cov_1.826087_g125110_i0 | PRJNA432257 | 125491 | 152 | 1.826087 | 2.77565224 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 6.4e-7 | NR | EJW77388.1 | 6293 | g125110 | i0 | 100 | 1.06578947368421 | 27 | 0 | 53.3 | 0 | 81 | 1 | 1 | 27 | EJW77388.1 replicase [Wuchereria bancrofti] | diamond | 162 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 30029197 | 30029197 | PRJNA432257_S_NODE_76991_length_196_cov_1.955975_g76610_i0 | PRJNA432257 | 76991 | 196 | 1.955975 | 3.833711 | Metazoa | 33208 | Nematoda | Nematoda | 121 | 1.4799999999999998e-32 | NR | KAF8381790.1 | 54126 | g76610 | i0 | 89.2 | 116.40306122449 | 65 | 7 | 99.5 | 0 | 195 | 1 | 89 | 153 | KAF8381790.1 rps-5 [Pristionchus pacificus] | diamond | 22815 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 31339708 | 31339708 | PRJNA432257_S_NODE_6996_length_463_cov_2.990610_g6691_i0 | PRJNA432257 | 6996 | 463 | 2.99061 | 13.8465243 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 219 | 2e-66 | NR | PAV89982.1 | 2018661 | g6691 | i0 | 88.9 | 0.699784017278618 | 108 | 12 | 70 | 0 | 6 | 329 | 386 | 493 | PAV89982.1 hypothetical protein WR25_06617 [Diploscapter pachys] | diamond | 324 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 31940618 | 31940618 | PRJNA432257_S_NODE_98157_length_178_cov_1.106383_g97776_i0 | PRJNA432257 | 98157 | 178 | 1.106383 | 1.96936174 | Enterobius vermicularis | 51028 | Nematoda | Nematoda | 55.8 | 3.8e-7 | NR | VDD86136.1 | 51028 | g97776 | i0 | 100 | 0.421348314606742 | 25 | 0 | 42.1 | 0 | 22 | 96 | 4008 | 4032 | VDD86136.1 unnamed protein product [Enterobius vermicularis] | diamond | 75 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Oxyuridae | Enterobius | Enterobius vermicularis | |
| 32368788 | 32368788 | PRJNA432257_S_NODE_17639_length_336_cov_2.361204_g17258_i0 | PRJNA432257 | 17639 | 336 | 2.361204 | 7.93364544 | Aphelenchoides | 90723 | Nematoda | Nematoda | 186 | 1.52e-57 | NR | KAI6181587.1 | 269767 | g17258 | i0 | 78.4 | 1.875 | 111 | 24 | 99.1 | 0 | 335 | 3 | 13 | 123 | KAI6181587.1 hypothetical protein M3Y98_00844900 [Aphelenchoides besseyi] | diamond | 630 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi |
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);;