contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1115053" 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 |
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);;