contig_metadata
15 rows where bioproject = "PRJNA1115053", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 222902 | 222902 | PRJNA1115053_S_NODE_125041_length_237_cov_1.175258_g123224_i0 | PRJNA1115053 | 125041 | 237 | 1.175258 | 2.78536146 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.021 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g123224 | i0 | 100 | 0.118143459915612 | 28 | 0 | 12 | 0 | 1 | 28 | 23 | 50 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 2774335 | 2774335 | PRJNA1115053_S_NODE_154203_length_217_cov_1.379310_g152386_i0 | PRJNA1115053 | 154203 | 217 | 1.37931 | 2.9931027 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.019 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g152386 | i0 | 100 | 0.129032258064516 | 28 | 0 | 13 | 0 | 190 | 217 | 50 | 23 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 4051636 | 4051636 | PRJNA1115053_S_NODE_200524_length_194_cov_0.953642_g198707_i0 | PRJNA1115053 | 200524 | 194 | 0.953642 | 1.85006548 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.017 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g198707 | i0 | 100 | 0.144329896907216 | 28 | 0 | 14 | 0 | 167 | 194 | 50 | 23 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 5328085 | 5328085 | PRJNA1115053_S_NODE_214325_length_188_cov_1.351724_g212508_i0 | PRJNA1115053 | 214325 | 188 | 1.351724 | 2.54124112 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.004 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g212508 | i0 | 96.97 | 0.175531914893617 | 33 | 0 | 18 | 1 | 156 | 188 | 50 | 19 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 11704310 | 11704310 | PRJNA1115053_S_NODE_234190_length_181_cov_1.043478_g232373_i0 | PRJNA1115053 | 234190 | 181 | 1.043478 | 1.88869518 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.004 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g232373 | i0 | 92.308 | 0.215469613259669 | 39 | 1 | 22 | 1 | 143 | 181 | 59 | 23 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 39 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 13777526 | 13777526 | PRJNA1115053_S_NODE_128131_length_234_cov_2.685864_g126314_i0 | PRJNA1115053 | 128131 | 234 | 2.685864 | 6.28492176 | Metazoa | 33208 | Nematoda | Nematoda | 137 | 5.62e-28 | NTclustered | gi|158821894|gb|EU195958.1| | 473172 | g126314 | i0 | 93.478 | 39.542735042735 | 92 | 6 | 39 | 0 | 143 | 234 | 1892 | 1983 | Protorhabditis sp. JB122 28S ribosomal RNA gene, partial sequence | blastn | 9253 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Protorhabditis | Protorhabditis sp. JB122 | |
| 14254319 | 14254319 | PRJNA1115053_S_NODE_223792_length_184_cov_2.531915_g221975_i0 | PRJNA1115053 | 223792 | 184 | 2.531915 | 4.6587236 | Poteriostomum imparidentatum | 54000 | Nematoda | Nematoda | 54.7 | 0.004 | NTclustered | gi|1206251681|ref|NC_035005.1| | 54000 | g221975 | i0 | 94.286 | 0.190217391304348 | 35 | 2 | 19 | 0 | 18 | 52 | 8087 | 8053 | Poteriostomum imparidentatum isolate DQPIM1 mitochondrion, complete genome | blastn | 35 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Poteriostomum | Poteriostomum imparidentatum | |
| 16801627 | 16801627 | PRJNA1115053_S_NODE_188354_length_199_cov_1.416667_g186537_i0 | PRJNA1115053 | 188354 | 199 | 1.416667 | 2.81916733 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.005 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g186537 | i0 | 100 | 0.14572864321608 | 29 | 0 | 15 | 0 | 1 | 29 | 23 | 51 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 18074530 | 18074530 | PRJNA1115053_S_NODE_122675_length_239_cov_0.979592_g120858_i0 | PRJNA1115053 | 122675 | 239 | 0.979592 | 2.34122488 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.021 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g120858 | i0 | 100 | 0.117154811715481 | 28 | 0 | 12 | 0 | 1 | 28 | 23 | 50 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 23178952 | 23178952 | PRJNA1115053_S_NODE_279619_length_167_cov_1.161290_g277802_i0 | PRJNA1115053 | 279619 | 167 | 1.16129 | 1.9393543 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 52.8 | 0.014 | NTclustered | gi|104295119|gb|AC187042.1| | 6334 | g277802 | i0 | 100 | 0.167664670658683 | 28 | 0 | 17 | 0 | 25 | 52 | 103869 | 103896 | Trichinella spiralis chromosome UNK clone TS195-23H12, complete sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 27352736 | 27352736 | PRJNA1115053_S_NODE_67823_length_301_cov_2.046512_g66006_i0 | PRJNA1115053 | 67823 | 301 | 2.046512 | 6.16000112 | Trichuris suis | 68888 | Nematoda | Nematoda | 60.1 | 5.07e-8 | NR | KHJ39930.1 | 68888 | g66006 | i0 | 58 | 1.94352159468439 | 50 | 21 | 49.8 | 0 | 68 | 217 | 244 | 293 | KHJ39930.1 hypothetical protein D918_10017 [Trichuris suis] | diamond | 585 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 30036472 | 30036472 | PRJNA1115053_S_NODE_91951_length_268_cov_1.720000_g90134_i0 | PRJNA1115053 | 91951 | 268 | 1.72 | 4.6096 | Steinernema hermaphroditum | 289476 | Nematoda | Nematoda | 43.1 | 0.0387 | NR | KAK0403860.1 | 289476 | g90134 | i0 | 44.6 | 1.25373134328358 | 56 | 20 | 50.4 | 1 | 178 | 44 | 384 | 439 | KAK0403860.1 hypothetical protein QR680_017162 [Steinernema hermaphroditum] | diamond | 336 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema hermaphroditum | |
| 30605035 | 30605035 | PRJNA1115053_S_NODE_198513_length_194_cov_3.728477_g196696_i0 | PRJNA1115053 | 198513 | 194 | 3.728477 | 7.23324538 | Pristionchus pacificus | 54126 | Nematoda | Nematoda | 42 | 0.025 | NR | KAF8363706.1 | 54126 | g196696 | i0 | 42.9 | 0.649484536082474 | 42 | 24 | 64.9 | 0 | 166 | 41 | 58 | 99 | KAF8363706.1 hypothetical protein PRIPAC_90629 [Pristionchus pacificus] | diamond | 126 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 30826251 | 30826251 | PRJNA1115053_S_NODE_323654_length_155_cov_2.035714_g321837_i0 | PRJNA1115053 | 323654 | 155 | 2.035714 | 3.1553567 | Trichuris suis | 68888 | Nematoda | Nematoda | 50.1 | 2.9e-5 | NR | KFD61048.1 | 68888 | g321837 | i0 | 63.3 | 0.580645161290323 | 30 | 11 | 58.1 | 0 | 35 | 124 | 34 | 63 | KFD61048.1 hypothetical protein M514_08442 [Trichuris suis] | diamond | 90 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 32659978 | 32659978 | PRJNA1115053_S_NODE_263560_length_171_cov_2.250000_g261743_i0 | PRJNA1115053 | 263560 | 171 | 2.25 | 3.8475 | Enterobius vermicularis | 51028 | Nematoda | Nematoda | 42.4 | 0.019 | NR | VDD88179.1 | 51028 | g261743 | i0 | 40.5 | 0.736842105263158 | 42 | 25 | 73.7 | 0 | 3 | 128 | 2 | 43 | VDD88179.1 unnamed protein product [Enterobius vermicularis] | diamond | 126 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Oxyuridae | Enterobius | Enterobius vermicularis |
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);;