contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA1087264" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26909374 | 26909374 | PRJNA1087264_P_NODE_3962_length_327_cov_2.233813_g3880_i0 | PRJNA1087264 | 3962 | 327 | 2.233813 | 7.30456851 | Acanthocheilonema viteae | 6277 | Nematoda | Nematoda | 93.6 | 1.52e-19 | NR | VBB29199.1 | 6277 | g3880 | i0 | 73.2 | 4.47706422018349 | 56 | 15 | 51.4 | 0 | 49 | 216 | 65 | 120 | VBB29199.1 unnamed protein product [Acanthocheilonema viteae] | diamond | 1464 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Acanthocheilonema | Acanthocheilonema viteae | |
| 27130323 | 27130323 | PRJNA1087264_P_NODE_20722_length_162_cov_0.902655_g20640_i0 | PRJNA1087264 | 20722 | 162 | 0.902655 | 1.4623011 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 63.9 | 4.04e-10 | NR | CAJ0580161.1 | 96644 | g20640 | i0 | 52.9 | 1.87037037037037 | 51 | 23 | 92.6 | 1 | 12 | 161 | 145 | 195 | CAJ0580161.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 303 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 27469876 | 27469876 | PRJNA1087264_P_NODE_7503_length_230_cov_1.127072_g7421_i0 | PRJNA1087264 | 7503 | 230 | 1.127072 | 2.5922656 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 91.7 | 5.25e-22 | NR | XGW25713.1 | 6289 | g7421 | i0 | 70 | 2.68695652173913 | 60 | 18 | 78.3 | 0 | 49 | 228 | 30 | 89 | XGW25713.1 hypothetical protein V3C99_006822 [Haemonchus contortus] | diamond | 618 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Haemonchus | Haemonchus contortus | |
| 27596191 | 27596191 | PRJNA1087264_P_NODE_4724_length_297_cov_2.100806_g4642_i0 | PRJNA1087264 | 4724 | 297 | 2.100806 | 6.23939382 | Trichinella | 6333 | Nematoda | Nematoda | 47 | 0.00223 | NR | KAL1241498.1 | 6334 | g4642 | i0 | 37.9 | 2.65656565656566 | 87 | 42 | 77.8 | 4 | 255 | 25 | 93 | 177 | KAL1241498.1 SCO-spondin [Trichinella spiralis] | diamond | 789 | 47.4 | 0.991561181434599 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 27974906 | 27974906 | PRJNA1087264_P_NODE_14385_length_167_cov_0.864407_g14303_i0 | PRJNA1087264 | 14385 | 167 | 0.864407 | 1.44355969 | Metazoa | 33208 | Nematoda | Nematoda | 42.7 | 0.0134 | NR | CDW56653.1 | 36087 | g14303 | i0 | 38.9 | 1.9940119760479 | 54 | 32 | 95.2 | 1 | 167 | 9 | 254 | 307 | CDW56653.1 desert hedgehog protein [Trichuris trichiura] | diamond | 333 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 28511662 | 28511662 | PRJNA1087264_P_NODE_9227_length_207_cov_1.936709_g9145_i0 | PRJNA1087264 | 9227 | 207 | 1.936709 | 4.00898763 | Trichinella | 6333 | Nematoda | Nematoda | 48.5 | 2.04e-4 | NR | KRZ67201.1 | 268474 | g9145 | i0 | 48 | 3.79710144927536 | 50 | 26 | 72.5 | 0 | 170 | 21 | 59 | 108 | KRZ67201.1 Cathepsin B-like cysteine proteinase, partial [Trichinella papuae] | diamond | 786 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella papuae | |
| 29364329 | 29364329 | PRJNA1087264_P_NODE_9969_length_200_cov_0.920530_g9887_i0 | PRJNA1087264 | 9969 | 200 | 0.92053 | 1.84106 | Trichinella | 6333 | Nematoda | Nematoda | 65.5 | 2.02e-10 | NR | KRY29802.1 | 6334 | g9887 | i0 | 48.4 | 6.72 | 64 | 33 | 96 | 0 | 8 | 199 | 533 | 596 | KRY29802.1 Mitochondrial import inner membrane translocase subunit TIM50-C [Trichinella spiralis] | diamond | 1344 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 30541418 | 30541418 | PRJNA1087264_P_NODE_2673_length_407_cov_2.036313_g2592_i0 | PRJNA1087264 | 2673 | 407 | 2.036313 | 8.28779391 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 48.9 | 8.02e-4 | NR | XP_053582573.1 | 31234 | g2592 | i0 | 56.6 | 0.390663390663391 | 53 | 21 | 37.6 | 1 | 255 | 407 | 112 | 164 | XP_053582573.1 hypothetical protein GCK72_020574 [Caenorhabditis remanei] | diamond | 159 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 30604573 | 30604573 | PRJNA1087264_P_NODE_9753_length_202_cov_0.921569_g9671_i0 | PRJNA1087264 | 9753 | 202 | 0.921569 | 1.86156938 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 62 | 3.5e-9 | NR | UMM41932.1 | 6238 | g9671 | i0 | 58.6 | 0.861386138613861 | 58 | 23 | 86.1 | 1 | 201 | 28 | 588 | 644 | UMM41932.1 hypothetical protein L5515_017967 [Caenorhabditis briggsae] | diamond | 174 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 31386296 | 31386296 | PRJNA1087264_P_NODE_20236_length_162_cov_0.902655_g20154_i0 | PRJNA1087264 | 20236 | 162 | 0.902655 | 1.4623011 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 82.8 | 2.18e-17 | NR | CAJ0602780.1 | 53992 | g20154 | i0 | 74.1 | 22.6111111111111 | 54 | 14 | 100 | 0 | 162 | 1 | 46 | 99 | CAJ0602780.1 unnamed protein product [Cylicocyclus nassatus] | diamond | 3663 | 83.2 | 0.995192307692308 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Cylicocyclus | Cylicocyclus nassatus | |
| 31774185 | 31774185 | PRJNA1087264_P_NODE_13617_length_170_cov_1.685950_g13535_i0 | PRJNA1087264 | 13617 | 170 | 1.68595 | 2.866115 | Koerneria luziae | 912562 | Nematoda | Nematoda | 60.5 | 2.24e-9 | NR | AIL48340.1 | 912562 | g13535 | i0 | 64.4 | 2.38235294117647 | 45 | 16 | 79.4 | 0 | 30 | 164 | 1 | 45 | AIL48340.1 large subunit ribosomal protein 9, partial [Koerneria luziae] | diamond | 405 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Koerneria | Koerneria luziae | |
| 31932361 | 31932361 | PRJNA1087264_P_NODE_14937_length_167_cov_0.864407_g14855_i0 | PRJNA1087264 | 14937 | 167 | 0.864407 | 1.44355969 | Cooperia oncophora | 27828 | Nematoda | Nematoda | 45.8 | 9.45e-4 | NR | KAK6056884.1 | 27828 | g14855 | i0 | 43.5 | 2.44311377245509 | 46 | 26 | 82.6 | 0 | 140 | 3 | 184 | 229 | KAK6056884.1 f-actin capping protein alpha subunit [Cooperia oncophora] | diamond | 408 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Cooperia | Cooperia oncophora | |
| 32208668 | 32208668 | PRJNA1087264_P_NODE_19198_length_163_cov_0.894737_g19116_i0 | PRJNA1087264 | 19198 | 163 | 0.894737 | 1.45842131 | Trichinella | 6333 | Nematoda | Nematoda | 47.4 | 2.99e-4 | NR | OUC40586.1 | 6335 | g19116 | i0 | 51.2 | 8.30061349693251 | 41 | 18 | 75.5 | 1 | 163 | 41 | 786 | 824 | OUC40586.1 MA3 domain protein [Trichinella nativa] | diamond | 1353 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella nativa | |
| 32745742 | 32745742 | PRJNA1087264_P_NODE_18580_length_164_cov_0.886957_g18498_i0 | PRJNA1087264 | 18580 | 164 | 0.886957 | 1.45460948 | Rhabditida | 6236 | Nematoda | Nematoda | 63.5 | 4.27e-10 | NR | VBB26108.1 | 6277 | g18498 | i0 | 69 | 4.60975609756098 | 42 | 13 | 76.8 | 0 | 3 | 128 | 227 | 268 | VBB26108.1 unnamed protein product [Acanthocheilonema viteae] | diamond | 756 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Acanthocheilonema | Acanthocheilonema viteae |
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);;