contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA315399" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22060903 | 22060903 | PRJNA315399_S_NODE_139558_length_164_cov_1.826772_g139357_i0 | PRJNA315399 | 139558 | 164 | 1.826772 | 2.99590608 | Aphelenchoides bicaudatus | 293665 | Nematoda | Nematoda | 106 | 3.97e-25 | NR | KAI6191050.1 | 293665 | g139357 | i0 | 100 | 1.9390243902439 | 53 | 0 | 97 | 0 | 4 | 162 | 574 | 626 | KAI6191050.1 26S proteasome non-ATPase regulatory subunit 2 [Aphelenchoides bicaudatus] | diamond | 318 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides bicaudatus | |
| 26789713 | 26789713 | PRJNA315399_P_NODE_444481_length_157_cov_2.125000_g444033_i0 | PRJNA315399 | 444481 | 157 | 2.125 | 3.33625 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 55.5 | 3.78e-7 | NR | pir|T19605| | 6239 | g444033 | i0 | 56.3 | 0.917197452229299 | 48 | 21 | 91.7 | 0 | 2 | 145 | 186 | 233 | pir|T19605| hypothetical protein C31C9.5 - Caenorhabditis elegans [Caenorhabditis elegans] | diamond | 144 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 27200605 | 27200605 | PRJNA315399_P_NODE_27622_length_276_cov_6.489540_g27177_i0 | PRJNA315399 | 27622 | 276 | 6.48954 | 17.9111304 | Nippostrongylus brasiliensis | 27835 | Nematoda | Nematoda | 51.2 | 3.76e-5 | NR | WKY10318.1 | 27835 | g27177 | i0 | 58.8 | 1.10869565217391 | 34 | 14 | 37 | 0 | 6 | 107 | 189 | 222 | WKY10318.1 hypothetical protein Q1695_002566 [Nippostrongylus brasiliensis] | diamond | 306 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heligmosomidae | Nippostrongylus | Nippostrongylus brasiliensis | |
| 27408150 | 27408150 | PRJNA315399_P_NODE_263983_length_181_cov_2.465278_g263535_i0 | PRJNA315399 | 263983 | 181 | 2.465278 | 4.46215318 | Rhabditida | 6236 | Nematoda | Nematoda | 47 | 4.85e-4 | NR | KAH7710194.1 | 70226 | g263535 | i0 | 62.2 | 1.87292817679558 | 37 | 12 | 61.3 | 1 | 57 | 167 | 35 | 69 | KAH7710194.1 Protein Y45G12B.2 a [Aphelenchoides avenae] | diamond | 339 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 27548307 | 27548307 | PRJNA315399_P_NODE_29484_length_272_cov_6.859574_g29039_i0 | PRJNA315399 | 29484 | 272 | 6.859574 | 18.65804128 | Nippostrongylus brasiliensis | 27835 | Nematoda | Nematoda | 51.2 | 3.63e-5 | NR | WKY10318.1 | 27835 | g29039 | i0 | 58.8 | 1.125 | 34 | 14 | 37.5 | 0 | 6 | 107 | 189 | 222 | WKY10318.1 hypothetical protein Q1695_002566 [Nippostrongylus brasiliensis] | diamond | 306 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heligmosomidae | Nippostrongylus | Nippostrongylus brasiliensis | |
| 27579852 | 27579852 | PRJNA315399_P_NODE_374484_length_164_cov_20.086614_g374036_i0 | PRJNA315399 | 374484 | 164 | 20.086614 | 32.94204696 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 43.9 | 0.00122 | NR | XP_003113641.2 | 31234 | g374036 | i0 | 39.5 | 0.786585365853659 | 43 | 26 | 78.7 | 0 | 161 | 33 | 11 | 53 | XP_003113641.2 hypothetical protein GCK72_006613 [Caenorhabditis remanei] | diamond | 129 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 27629145 | 27629145 | PRJNA315399_P_NODE_509124_length_150_cov_4.557522_g508676_i0 | PRJNA315399 | 509124 | 150 | 4.557522 | 6.836283 | Metazoa | 33208 | Nematoda | Nematoda | 41.2 | 0.0384 | NR | XGW28165.1 | 6289 | g508676 | i0 | 69.6 | 1.96 | 23 | 7 | 46 | 0 | 135 | 67 | 1155 | 1177 | XGW28165.1 hypothetical protein V3C99_008177 [Haemonchus contortus] | diamond | 294 | 41.6 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Haemonchus | Haemonchus contortus | |
| 28179572 | 28179572 | PRJNA315399_P_NODE_24886_length_282_cov_8.069388_g24441_i0 | PRJNA315399 | 24886 | 282 | 8.069388 | 22.75567416 | Nippostrongylus brasiliensis | 27835 | Nematoda | Nematoda | 51.2 | 4.02e-5 | NR | WKY10318.1 | 27835 | g24441 | i0 | 58.8 | 1.08510638297872 | 34 | 14 | 36.2 | 0 | 277 | 176 | 189 | 222 | WKY10318.1 hypothetical protein Q1695_002566 [Nippostrongylus brasiliensis] | diamond | 306 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heligmosomidae | Nippostrongylus | Nippostrongylus brasiliensis | |
| 28558908 | 28558908 | PRJNA315399_P_NODE_387047_length_163_cov_3.531746_g386599_i0 | PRJNA315399 | 387047 | 163 | 3.531746 | 5.75674598 | Trichostrongylus colubriformis | 6319 | Nematoda | Nematoda | 41.2 | 0.0439 | NR | KAK5974675.1 | 6319 | g386599 | i0 | 44.7 | 0.699386503067485 | 38 | 21 | 69.9 | 0 | 125 | 12 | 129 | 166 | KAK5974675.1 hypothetical protein GCK32_006605, partial [Trichostrongylus colubriformis] | diamond | 114 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Trichostrongylus | Trichostrongylus colubriformis | |
| 28716661 | 28716661 | PRJNA315399_P_NODE_188307_length_185_cov_10.641892_g187859_i0 | PRJNA315399 | 188307 | 185 | 10.641892 | 19.6875002 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 52 | 9.16e-6 | NR | KAE9554125.1 | 2598192 | g187859 | i0 | 80.8 | 0.421621621621622 | 26 | 5 | 42.2 | 0 | 93 | 16 | 330 | 355 | KAE9554125.1 hypothetical protein FO519_002662 [Halicephalobus sp. NKZ332] | diamond | 78 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 | |
| 29018524 | 29018524 | PRJNA315399_P_NODE_93508_length_204_cov_4.586826_g93060_i0 | PRJNA315399 | 93508 | 204 | 4.586826 | 9.35712504 | root | 1 | Root_unresolved | Root_unresolved | 53.1 | 4.96e-6 | NR | VDM09056.1 | 6293 | g93060 | i0 | 46.2 | 2.32352941176471 | 65 | 26 | 82.4 | 1 | 186 | 19 | 62 | 126 | VDM09056.1 unnamed protein product [Wuchereria bancrofti] | diamond | 474 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 29032577 | 29032577 | PRJNA315399_P_NODE_427488_length_158_cov_10.322314_g427040_i0 | PRJNA315399 | 427488 | 158 | 10.322314 | 16.30925612 | Steinernema carpocapsae | 34508 | Nematoda | Nematoda | 54.3 | 9.72e-7 | NR | TKR87546.1 | 34508 | g427040 | i0 | 54.5 | 1.68987341772152 | 44 | 19 | 83.5 | 1 | 14 | 145 | 1276 | 1318 | TKR87546.1 hypothetical protein L596_011925 [Steinernema carpocapsae] | diamond | 267 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 29491769 | 29491769 | PRJNA315399_P_NODE_432210_length_158_cov_3.884298_g431762_i0 | PRJNA315399 | 432210 | 158 | 3.884298 | 6.13719084 | Metazoa | 33208 | Nematoda | Nematoda | 43.1 | 0.00872 | NR | KAL3096516.1 | 97005 | g431762 | i0 | 46 | 8.58227848101266 | 50 | 27 | 94.9 | 0 | 156 | 7 | 1145 | 1194 | KAL3096516.1 hypothetical protein niasHS_004176 [Heterodera schachtii] | diamond | 1356 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera schachtii | |
| 29663431 | 29663431 | PRJNA315399_P_NODE_285090_length_179_cov_6.647887_g284642_i0 | PRJNA315399 | 285090 | 179 | 6.647887 | 11.89971773 | Caenorhabditis nigoni | 1611254 | Nematoda | Nematoda | 56.2 | 2.76e-7 | NR | PIC13485.1 | 1611254 | g284642 | i0 | 48.1 | 0.905027932960894 | 54 | 28 | 90.5 | 0 | 10 | 171 | 632 | 685 | PIC13485.1 hypothetical protein B9Z55_027619 [Caenorhabditis nigoni] | diamond | 162 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis nigoni | |
| 30660565 | 30660565 | PRJNA315399_P_NODE_361793_length_167_cov_2.361538_g361345_i0 | PRJNA315399 | 361793 | 167 | 2.361538 | 3.94376846 | Steinernema | 34507 | Nematoda | Nematoda | 42.7 | 0.0137 | NR | TMS39605.1 | 34508 | g361345 | i0 | 46.9 | 1.1497005988024 | 32 | 17 | 57.5 | 0 | 25 | 120 | 1912 | 1943 | TMS39605.1 hypothetical protein L596_006103 [Steinernema carpocapsae] | diamond | 192 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 30737803 | 30737803 | PRJNA315399_P_NODE_333914_length_174_cov_3.518248_g333466_i0 | PRJNA315399 | 333914 | 174 | 3.518248 | 6.12175152 | Trichinella sp. T8 | 92180 | Nematoda | Nematoda | 44.7 | 0.00307 | NR | KRZ97668.1 | 92180 | g333466 | i0 | 70.4 | 1.89655172413793 | 27 | 8 | 46.6 | 0 | 20 | 100 | 182 | 208 | KRZ97668.1 Uncharacterized protein T08_959, partial [Trichinella sp. T8] | diamond | 330 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella sp. T8 | |
| 30881680 | 30881680 | PRJNA315399_P_NODE_244354_length_182_cov_3.634483_g243906_i0 | PRJNA315399 | 244354 | 182 | 3.634483 | 6.61475906 | Metazoa | 33208 | Nematoda | Nematoda | 44.7 | 0.00331 | NR | CDJ94577.1 | 6289 | g243906 | i0 | 85 | 3.85714285714286 | 20 | 3 | 33 | 0 | 120 | 179 | 243 | 262 | CDJ94577.1 Transposase domain containing protein [Haemonchus contortus] | diamond | 702 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Haemonchus | Haemonchus contortus | |
| 31085509 | 31085509 | PRJNA315399_P_NODE_385995_length_163_cov_4.325397_g385547_i0 | PRJNA315399 | 385995 | 163 | 4.325397 | 7.05039711 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 47.8 | 2.15e-4 | NR | KAE9555827.1 | 2598192 | g385547 | i0 | 50 | 0.809815950920245 | 44 | 20 | 77.3 | 1 | 129 | 4 | 15 | 58 | KAE9555827.1 hypothetical protein FO519_001041 [Halicephalobus sp. NKZ332] | diamond | 132 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 | |
| 31338309 | 31338309 | PRJNA315399_P_NODE_77976_length_212_cov_6.331429_g77528_i0 | PRJNA315399 | 77976 | 212 | 6.331429 | 13.42262948 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 58.5 | 6.7e-8 | NR | EFO95576.1 | 31234 | g77528 | i0 | 63.9 | 2.20754716981132 | 36 | 13 | 50.9 | 0 | 127 | 20 | 702 | 737 | EFO95576.1 hypothetical protein CRE_08674 [Caenorhabditis remanei] | diamond | 468 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 31387631 | 31387631 | PRJNA315399_P_NODE_219436_length_183_cov_12.075342_g218988_i0 | PRJNA315399 | 219436 | 183 | 12.075342 | 22.09787586 | Rhabditida | 6236 | Nematoda | Nematoda | 44.7 | 0.00366 | NR | KAH7716702.1 | 70226 | g218988 | i0 | 59.4 | 2.67213114754098 | 32 | 13 | 52.5 | 0 | 165 | 70 | 1272 | 1303 | KAH7716702.1 hypothetical protein AAVH_15884 [Aphelenchoides avenae] | diamond | 489 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 31925126 | 31925126 | PRJNA315399_S_NODE_100817_length_178_cov_3.177305_g100616_i0 | PRJNA315399 | 100817 | 178 | 3.177305 | 5.6556029 | Opisthokonta | 33154 | Nematoda | Nematoda | 49.3 | 2.77e-5 | NR | NP_498572.1 | 6239 | g100616 | i0 | 95.5 | 11.6797752808989 | 22 | 1 | 37.1 | 0 | 176 | 111 | 131 | 152 | NP_498572.1 Small ribosomal subunit protein uS11 [Caenorhabditis elegans] | diamond | 2079 | 49.7 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 32002684 | 32002684 | PRJNA315399_P_NODE_431938_length_158_cov_4.049587_g431490_i0 | PRJNA315399 | 431938 | 158 | 4.049587 | 6.39834746 | Trichuris suis | 68888 | Nematoda | Nematoda | 42 | 0.0198 | NR | KFD47209.1 | 68888 | g431490 | i0 | 71.4 | 5.84810126582278 | 28 | 8 | 53.2 | 0 | 71 | 154 | 83 | 110 | KFD47209.1 hypothetical protein M513_11916 [Trichuris suis] | diamond | 924 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 32319360 | 32319360 | PRJNA315399_P_NODE_387359_length_163_cov_3.317460_g386911_i0 | PRJNA315399 | 387359 | 163 | 3.31746 | 5.4074598 | Trichinella pseudospiralis | 6337 | Nematoda | Nematoda | 63.2 | 1.35e-11 | NR | KRY63622.1 | 6337 | g386911 | i0 | 85.7 | 1.93251533742331 | 35 | 5 | 64.4 | 0 | 40 | 144 | 15 | 49 | KRY63622.1 hypothetical protein T4D_13828 [Trichinella pseudospiralis] | diamond | 315 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella pseudospiralis | |
| 32477414 | 32477414 | PRJNA315399_P_NODE_281239_length_180_cov_1.965035_g280791_i0 | PRJNA315399 | 281239 | 180 | 1.965035 | 3.537063 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 89.7 | 4.4e-19 | NR | KAE9553015.1 | 2598192 | g280791 | i0 | 76.5 | 0.85 | 51 | 12 | 85 | 0 | 163 | 11 | 582 | 632 | KAE9553015.1 hypothetical protein FO519_003776 [Halicephalobus sp. NKZ332] | diamond | 153 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 |
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);;