contig_metadata
18 rows where bioproject = "PRJNA1069776" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1459475 | 1459475 | PRJNA1069776_S_NODE_38022_length_177_cov_2.671642_g37708_i0 | PRJNA1069776 | 38022 | 177 | 2.671642 | 4.72880634 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.015 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g37708 | i0 | 100 | 0.15819209039548 | 28 | 0 | 16 | 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 | |
| 2735701 | 2735701 | PRJNA1069776_S_NODE_9963_length_307_cov_7.412879_g9649_i0 | PRJNA1069776 | 9963 | 307 | 7.412879 | 22.75753853 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.008 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g9649 | i0 | 100 | 0.0944625407166124 | 29 | 0 | 9 | 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 | |
| 5287620 | 5287620 | PRJNA1069776_S_NODE_33805_length_187_cov_2.284722_g33491_i0 | PRJNA1069776 | 33805 | 187 | 2.284722 | 4.27243014 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.016 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g33491 | i0 | 100 | 0.149732620320856 | 28 | 0 | 15 | 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 | |
| 6562545 | 6562545 | PRJNA1069776_S_NODE_19106_length_240_cov_2.192893_g18792_i0 | PRJNA1069776 | 19106 | 240 | 2.192893 | 5.2629432 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.022 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g18792 | i0 | 100 | 0.116666666666667 | 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 | |
| 10388068 | 10388068 | PRJNA1069776_S_NODE_34469_length_185_cov_3.042254_g34155_i0 | PRJNA1069776 | 34469 | 185 | 3.042254 | 5.6281699 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.016 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g34155 | i0 | 100 | 0.151351351351351 | 28 | 0 | 15 | 0 | 158 | 185 | 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 | |
| 12938400 | 12938400 | PRJNA1069776_S_NODE_20291_length_234_cov_2.010471_g19977_i0 | PRJNA1069776 | 20291 | 234 | 2.010471 | 4.70450214 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.021 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g19977 | i0 | 100 | 0.11965811965812 | 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 | |
| 15487163 | 15487163 | PRJNA1069776_S_NODE_10613_length_301_cov_3.317829_g10299_i0 | PRJNA1069776 | 10613 | 301 | 3.317829 | 9.98666529 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.028 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g10299 | i0 | 100 | 0.0930232558139535 | 28 | 0 | 9 | 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 | |
| 16761721 | 16761721 | PRJNA1069776_S_NODE_32934_length_189_cov_2.917808_g32620_i0 | PRJNA1069776 | 32934 | 189 | 2.917808 | 5.51465712 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.016 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g32620 | i0 | 100 | 0.148148148148148 | 28 | 0 | 15 | 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 | |
| 19310291 | 19310291 | PRJNA1069776_S_NODE_22076_length_225_cov_4.593407_g21762_i0 | PRJNA1069776 | 22076 | 225 | 4.593407 | 10.33516575 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.02 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g21762 | i0 | 100 | 0.124444444444444 | 28 | 0 | 12 | 0 | 198 | 225 | 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 | |
| 19310434 | 19310434 | PRJNA1069776_S_NODE_33416_length_188_cov_2.268966_g33102_i0 | PRJNA1069776 | 33416 | 188 | 2.268966 | 4.26565608 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.016 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g33102 | i0 | 100 | 0.148936170212766 | 28 | 0 | 15 | 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 | |
| 20585921 | 20585921 | PRJNA1069776_S_NODE_37977_length_177_cov_3.119403_g37663_i0 | PRJNA1069776 | 37977 | 177 | 3.119403 | 5.52134331 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.015 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g37663 | i0 | 100 | 0.15819209039548 | 28 | 0 | 16 | 0 | 150 | 177 | 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 | |
| 23136887 | 23136887 | PRJNA1069776_S_NODE_14279_length_270_cov_2.176211_g13965_i0 | PRJNA1069776 | 14279 | 270 | 2.176211 | 5.8757697 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.025 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g13965 | i0 | 100 | 0.103703703703704 | 28 | 0 | 10 | 0 | 243 | 270 | 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 | |
| 24410724 | 24410724 | PRJNA1069776_S_NODE_34500_length_185_cov_2.704225_g34186_i0 | PRJNA1069776 | 34500 | 185 | 2.704225 | 5.00281625 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.004 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g34186 | i0 | 94.444 | 0.194594594594595 | 36 | 0 | 18 | 1 | 152 | 185 | 58 | 23 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 29941146 | 29941146 | PRJNA1069776_S_NODE_21191_length_229_cov_4.892473_g20877_i0 | PRJNA1069776 | 21191 | 229 | 4.892473 | 11.20376317 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 42.4 | 0.0427 | NR | CAD2183941.1 | 390850 | g20877 | i0 | 41.4 | 1.83406113537118 | 70 | 31 | 81.2 | 3 | 203 | 18 | 1264 | 1331 | CAD2183941.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 420 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 30225301 | 30225301 | PRJNA1069776_S_NODE_53952_length_151_cov_2.768519_g53638_i0 | PRJNA1069776 | 53952 | 151 | 2.768519 | 4.18046369 | Trichinella pseudospiralis | 6337 | Nematoda | Nematoda | 41.6 | 0.0276 | NR | KRY87921.1 | 6337 | g53638 | i0 | 50 | 0.913907284768212 | 46 | 23 | 91.4 | 0 | 151 | 14 | 327 | 372 | KRY87921.1 hypothetical protein T4D_14233 [Trichinella pseudospiralis] | diamond | 138 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella pseudospiralis | |
| 30257291 | 30257291 | PRJNA1069776_S_NODE_28852_length_200_cov_3.974522_g28538_i0 | PRJNA1069776 | 28852 | 200 | 3.974522 | 7.949044 | Ostertagia ostertagi | 6317 | Nematoda | Nematoda | 39.7 | 0.0377 | NR | KAK6026689.1 | 6317 | g28538 | i0 | 55.9 | 0.51 | 34 | 15 | 51 | 0 | 90 | 191 | 9 | 42 | KAK6026689.1 hypothetical protein OSTOST_07329, partial [Ostertagia ostertagi] | diamond | 102 | 39.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Ostertagia | Ostertagia ostertagi | |
| 30888846 | 30888846 | PRJNA1069776_S_NODE_1954_length_504_cov_25.225597_g1652_i0 | PRJNA1069776 | 1954 | 504 | 25.225597 | 127.13700888 | Dictyocaulus viviparus | 29172 | Nematoda | Nematoda | 59.3 | 7.15e-8 | NR | KJH41339.1 | 29172 | g1652 | i0 | 100 | 0.142857142857143 | 24 | 0 | 14.3 | 0 | 382 | 453 | 32 | 55 | KJH41339.1 hypothetical protein DICVIV_12690 [Dictyocaulus viviparus] | diamond | 72 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Dictyocaulus | Dictyocaulus viviparus | |
| 31932174 | 31932174 | PRJNA1069776_S_NODE_3837_length_401_cov_16.413408_g3523_i0 | PRJNA1069776 | 3837 | 401 | 16.413408 | 65.81776608 | Dictyocaulus viviparus | 29172 | Nematoda | Nematoda | 59.3 | 2.94e-8 | NR | KJH41339.1 | 29172 | g3523 | i0 | 100 | 0.179551122194514 | 24 | 0 | 18 | 0 | 279 | 350 | 32 | 55 | KJH41339.1 hypothetical protein DICVIV_12690 [Dictyocaulus viviparus] | diamond | 72 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Dictyocaulus | Dictyocaulus viviparus |
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);;