contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA1264536" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22040561 | 22040561 | PRJNA1264536_P_NODE_3598_length_290_cov_1.078341_g3524_i0 | PRJNA1264536 | 3598 | 290 | 1.078341 | 3.1271889 | Rhabditida | 6236 | Nematoda | Nematoda | 172 | 6.239999999999999e-52 | NR | KHN73182.1 | 6265 | g3524 | i0 | 88 | 9.54827586206897 | 92 | 11 | 95.2 | 0 | 290 | 15 | 152 | 243 | KHN73182.1 Peptidyl-prolyl cis-trans isomerase 3 [Toxocara canis] | diamond | 2769 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 26693984 | 26693984 | PRJNA1264536_P_NODE_4921_length_248_cov_0.891429_g4847_i0 | PRJNA1264536 | 4921 | 248 | 0.891429 | 2.21074392 | Trichuris suis | 68888 | Nematoda | Nematoda | 43.1 | 0.0293 | NR | KHJ47599.1 | 68888 | g4847 | i0 | 42.3 | 1.25806451612903 | 52 | 27 | 60.5 | 2 | 1 | 150 | 284 | 334 | KHJ47599.1 hypothetical protein D918_01754 [Trichuris suis] | diamond | 312 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 26693985 | 26693985 | PRJNA1264536_P_NODE_5121_length_246_cov_0.901734_g5047_i0 | PRJNA1264536 | 5121 | 246 | 0.901734 | 2.21826564 | Soboliphyme baturini | 241478 | Nematoda | Nematoda | 64.7 | 1.14e-10 | NR | VDP53605.1 | 241478 | g5047 | i0 | 40.5 | 0.902439024390244 | 74 | 41 | 90.2 | 2 | 2 | 223 | 70 | 140 | VDP53605.1 unnamed protein product [Soboliphyme baturini] | diamond | 222 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 26965112 | 26965112 | PRJNA1264536_P_NODE_862_length_628_cov_1.372973_g791_i0 | PRJNA1264536 | 862 | 628 | 1.372973 | 8.62227044 | Trichinella | 6333 | Nematoda | Nematoda | 411 | 1.98e-140 | NR | KAL1230678.1 | 6334 | g791 | i0 | 90.9 | 2.99522292993631 | 209 | 19 | 99.8 | 0 | 627 | 1 | 201 | 409 | KAL1230678.1 Elongation factor 1-alpha [Trichinella spiralis] | diamond | 1881 | 412 | 0.997572815533981 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 27042312 | 27042312 | PRJNA1264536_P_NODE_5162_length_245_cov_0.906977_g5088_i0 | PRJNA1264536 | 5162 | 245 | 0.906977 | 2.22209365 | Trichuris trichiura | 36087 | Nematoda | Nematoda | 69.7 | 1.44e-13 | NR | CDW59648.1 | 36087 | g5088 | i0 | 58.2 | 0.820408163265306 | 67 | 27 | 80.8 | 1 | 199 | 2 | 2 | 68 | CDW59648.1 Phospho p8 domain containing protein [Trichuris trichiura] | diamond | 201 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 27453327 | 27453327 | PRJNA1264536_P_NODE_3023_length_322_cov_1.253012_g2949_i0 | PRJNA1264536 | 3023 | 322 | 1.253012 | 4.03469864 | Trichuris suis | 68888 | Nematoda | Nematoda | 120 | 4.12e-32 | NR | KHJ46846.1 | 68888 | g2949 | i0 | 82.4 | 0.633540372670807 | 68 | 12 | 63.4 | 0 | 322 | 119 | 96 | 163 | KHJ46846.1 Ribosomal protein S27a [Trichuris suis] | diamond | 204 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 27611116 | 27611116 | PRJNA1264536_P_NODE_4804_length_249_cov_0.886364_g4730_i0 | PRJNA1264536 | 4804 | 249 | 0.886364 | 2.20704636 | Soboliphyme baturini | 241478 | Nematoda | Nematoda | 131 | 7.31e-38 | NR | VDO99451.1 | 241478 | g4730 | i0 | 74.7 | 12.6385542168675 | 79 | 20 | 95.2 | 0 | 249 | 13 | 3 | 81 | VDO99451.1 unnamed protein product [Soboliphyme baturini] | diamond | 3147 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 27881369 | 27881369 | PRJNA1264536_P_NODE_4205_length_259_cov_1.198925_g4131_i0 | PRJNA1264536 | 4205 | 259 | 1.198925 | 3.10521575 | Metazoa | 33208 | Nematoda | Nematoda | 119 | 7.240000000000001e-29 | NR | CDW58323.1 | 36087 | g4131 | i0 | 67.4 | 8.88416988416988 | 86 | 28 | 99.6 | 0 | 2 | 259 | 524 | 609 | CDW58323.1 carnitine O palmitoyltransferase 1, liver [Trichuris trichiura] | diamond | 2301 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 28305612 | 28305612 | PRJNA1264536_P_NODE_5026_length_247_cov_0.896552_g4952_i0 | PRJNA1264536 | 5026 | 247 | 0.896552 | 2.21448344 | Soboliphyme baturini | 241478 | Nematoda | Nematoda | 84 | 1.17e-16 | NR | VDP45226.1 | 241478 | g4952 | i0 | 46.3 | 0.995951417004049 | 82 | 39 | 97.2 | 2 | 6 | 245 | 272 | 350 | VDP45226.1 unnamed protein product, partial [Soboliphyme baturini] | diamond | 246 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 29081294 | 29081294 | PRJNA1264536_P_NODE_3768_length_281_cov_1.009615_g3694_i0 | PRJNA1264536 | 3768 | 281 | 1.009615 | 2.83701815 | Rhabditida | 6236 | Nematoda | Nematoda | 157 | 1.2099999999999999e-42 | NR | KHN74648.1 | 6265 | g3694 | i0 | 81.5 | 3.9288256227758 | 92 | 17 | 98.2 | 0 | 280 | 5 | 22 | 113 | KHN74648.1 40S ribosomal protein S3a [Toxocara canis] | diamond | 1104 | 158 | 0.993670886075949 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 29505317 | 29505317 | PRJNA1264536_P_NODE_5110_length_246_cov_0.901734_g5036_i0 | PRJNA1264536 | 5110 | 246 | 0.901734 | 2.21826564 | Ancylostoma duodenale | 51022 | Nematoda | Nematoda | 85.5 | 3.09e-17 | NR | KIH61615.1 | 51022 | g5036 | i0 | 72.1 | 3.86585365853659 | 61 | 16 | 74.4 | 1 | 184 | 2 | 91 | 150 | KIH61615.1 pyridine nucleotide-disulfide oxidoreductase [Ancylostoma duodenale] | diamond | 951 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma duodenale | |
| 30218028 | 30218028 | PRJNA1264536_P_NODE_4712_length_250_cov_0.881356_g4638_i0 | PRJNA1264536 | 4712 | 250 | 0.881356 | 2.20339 | Trichinellida | 6329 | Nematoda | Nematoda | 85.9 | 2.58e-17 | NR | KAL1245047.1 | 6334 | g4638 | i0 | 52 | 9.096 | 75 | 35 | 90 | 1 | 245 | 21 | 468 | 541 | KAL1245047.1 Chondroitin proteoglycan [Trichinella spiralis] | diamond | 2274 | 86.3 | 0.995365005793743 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 30818428 | 30818428 | PRJNA1264536_P_NODE_2574_length_351_cov_0.755396_g2500_i0 | PRJNA1264536 | 2574 | 351 | 0.755396 | 2.65143996 | Metazoa | 33208 | Nematoda | Nematoda | 205 | 3.06e-63 | NR | KAL1245728.1 | 6334 | g2500 | i0 | 92.2 | 22.6923076923077 | 116 | 9 | 99.1 | 0 | 350 | 3 | 99 | 214 | KAL1245728.1 14-3-3-like protein [Trichinella spiralis] | diamond | 7965 | 207 | 0.990338164251208 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 31292330 | 31292330 | PRJNA1264536_P_NODE_3375_length_302_cov_1.288210_g3301_i0 | PRJNA1264536 | 3375 | 302 | 1.28821 | 3.8903942 | Rhabditida | 6236 | Nematoda | Nematoda | 103 | 1.53e-23 | NR | VDN91935.1 | 6280 | g3301 | i0 | 66.7 | 10.0331125827815 | 66 | 22 | 65.6 | 0 | 302 | 105 | 76 | 141 | VDN91935.1 unnamed protein product [Brugia pahangi] | diamond | 3030 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia pahangi | |
| 31432698 | 31432698 | PRJNA1264536_P_NODE_3776_length_280_cov_1.507246_g3702_i0 | PRJNA1264536 | 3776 | 280 | 1.507246 | 4.2202888 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 117 | 8.760000000000001e-29 | NR | GMT35204.1 | 1538716 | g3702 | i0 | 66 | 3.02142857142857 | 94 | 26 | 99.6 | 3 | 1 | 279 | 173 | 261 | GMT35204.1 hypothetical protein PFISCL1PPCAC_26501, partial [Pristionchus fissidentatus] | diamond | 846 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 31608730 | 31608730 | PRJNA1264536_P_NODE_5476_length_242_cov_0.923077_g5402_i0 | PRJNA1264536 | 5476 | 242 | 0.923077 | 2.23384634 | Metazoa | 33208 | Nematoda | Nematoda | 60.1 | 4.71e-9 | NR | VDM99998.1 | 103827 | g5402 | i0 | 52.8 | 3.03719008264463 | 53 | 24 | 64.5 | 1 | 87 | 242 | 69 | 121 | VDM99998.1 unnamed protein product [Thelazia callipaeda] | diamond | 735 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Thelaziidae | Thelazia | Thelazia callipaeda | |
| 31861624 | 31861624 | PRJNA1264536_P_NODE_5117_length_246_cov_0.901734_g5043_i0 | PRJNA1264536 | 5117 | 246 | 0.901734 | 2.21826564 | Trichuris | 36086 | Nematoda | Nematoda | 140 | 3.18e-37 | NR | CDW52192.1 | 36087 | g5043 | i0 | 84 | 1.97560975609756 | 81 | 13 | 98.8 | 0 | 245 | 3 | 332 | 412 | CDW52192.1 T complex protein 1 subunit delta [Trichuris trichiura] | diamond | 486 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 31938699 | 31938699 | PRJNA1264536_P_NODE_4937_length_248_cov_0.885714_g4863_i0 | PRJNA1264536 | 4937 | 248 | 0.885714 | 2.19657072 | Soboliphyme baturini | 241478 | Nematoda | Nematoda | 42.7 | 0.0399 | NR | VDP03644.1 | 241478 | g4863 | i0 | 38.5 | 0.629032258064516 | 52 | 32 | 62.9 | 0 | 92 | 247 | 86 | 137 | VDP03644.1 unnamed protein product [Soboliphyme baturini] | diamond | 156 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 32192068 | 32192068 | PRJNA1264536_P_NODE_3378_length_302_cov_1.021834_g3304_i0 | PRJNA1264536 | 3378 | 302 | 1.021834 | 3.08593868 | Soboliphyme baturini | 241478 | Nematoda | Nematoda | 144 | 8.38e-42 | NR | VDO92860.1 | 241478 | g3304 | i0 | 81.5 | 0.804635761589404 | 81 | 15 | 80.5 | 0 | 302 | 60 | 61 | 141 | VDO92860.1 unnamed protein product [Soboliphyme baturini] | diamond | 243 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini |
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);;