contig_metadata
19 rows where bioproject = "PRJEB28062" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23899 | 23899 | PRJEB28062_P_NODE_12421_length_1090_cov_11.895772_g10684_i0 | PRJEB28062 | 12421 | 1090 | 11.895772 | 129.6639148 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 62.1 | 1.84e-4 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g10684 | i0 | 100 | 0.955963302752294 | 33 | 0 | 3 | 0 | 340 | 372 | 49 | 17 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 1042 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 24203 | 24203 | PRJEB28062_P_NODE_17441_length_906_cov_23.708283_g10684_i1 | PRJEB28062 | 17441 | 906 | 23.708283 | 214.79704398 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 62.1 | 1.52e-4 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g10684 | i1 | 100 | 1.15011037527594 | 33 | 0 | 4 | 0 | 535 | 567 | 17 | 49 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 1042 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 25168 | 25168 | PRJEB28062_P_NODE_62861_length_439_cov_22.576503_g60500_i0 | PRJEB28062 | 62861 | 439 | 22.576503 | 99.11084817 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.042 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g60500 | i0 | 100 | 0.0637813211845103 | 28 | 0 | 6 | 0 | 412 | 439 | 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 | |
| 1299289 | 1299289 | PRJEB28062_P_NODE_54842_length_477_cov_5.027228_g52489_i0 | PRJEB28062 | 54842 | 477 | 5.027228 | 23.97987756 | Metazoa | 33208 | Nematoda | Nematoda | 153 | 2.98e-43 | NR | XP_024504124.1 | 34506 | g52489 | i0 | 67.9 | 6.85534591194969 | 109 | 33 | 67.3 | 1 | 384 | 64 | 135 | 243 | XP_024504124.1 Dihydropteridine reductase [Strongyloides ratti] | diamond | 3270 | 154 | 0.993506493506494 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 6401955 | 6401955 | PRJEB28062_P_NODE_121266_length_257_cov_5.521739_g118902_i0 | PRJEB28062 | 121266 | 257 | 5.521739 | 14.19086923 | Ancylostoma caninum | 29170 | Nematoda | Nematoda | 248 | 2.78e-61 | NTclustered | gi|2020645243|gb|MN215971.1| | 29170 | g118902 | i0 | 88.626 | 75.443579766537 | 211 | 14 | 80 | 9 | 11 | 216 | 3145 | 2940 | Ancylostoma caninum mitochondrion, complete genome | blastn | 19389 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma caninum | |
| 6403500 | 6403500 | PRJEB28062_P_NODE_70186_length_411_cov_1.121302_g67825_i0 | PRJEB28062 | 70186 | 411 | 1.121302 | 4.60855122 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.011 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g67825 | i0 | 100 | 0.0705596107055961 | 29 | 0 | 7 | 0 | 383 | 411 | 54 | 26 | 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 | |
| 8951100 | 8951100 | PRJEB28062_P_NODE_135148_length_224_cov_5.423841_g132784_i0 | PRJEB28062 | 135148 | 224 | 5.423841 | 12.14940384 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.02 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g132784 | i0 | 100 | 0.125 | 28 | 0 | 13 | 0 | 1 | 28 | 26 | 53 | 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 | |
| 11502318 | 11502318 | PRJEB28062_P_NODE_21370_length_809_cov_124.355978_g10684_i2 | PRJEB28062 | 21370 | 809 | 124.355978 | 1006.03986202 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 62.1 | 1.35e-4 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g10684 | i2 | 100 | 1.28800988875155 | 33 | 0 | 4 | 0 | 438 | 470 | 17 | 49 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 1042 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 11502961 | 11502961 | PRJEB28062_P_NODE_50650_length_500_cov_104.592506_g48301_i0 | PRJEB28062 | 50650 | 500 | 104.592506 | 522.96253 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.049 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g48301 | i0 | 100 | 0.056 | 28 | 0 | 6 | 0 | 462 | 489 | 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 | |
| 11503441 | 11503441 | PRJEB28062_P_NODE_72830_length_401_cov_5.911585_g70468_i0 | PRJEB28062 | 72830 | 401 | 5.911585 | 23.70545585 | Dictyocaulus viviparus | 29172 | Nematoda | Nematoda | 235 | 4.300000000000001e-71 | NR | KJH40125.1 | 29172 | g70468 | i0 | 100 | 0.800498753117207 | 107 | 0 | 80 | 0 | 341 | 21 | 128 | 234 | KJH40125.1 homeobox domain protein [Dictyocaulus viviparus] | diamond | 321 | 235 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Dictyocaulus | Dictyocaulus viviparus | |
| 12777681 | 12777681 | PRJEB28062_P_NODE_137051_length_207_cov_20.208955_g134687_i0 | PRJEB28062 | 137051 | 207 | 20.208955 | 41.83253685 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.018 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g134687 | i0 | 100 | 0.135265700483092 | 28 | 0 | 14 | 0 | 180 | 207 | 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 | |
| 12779110 | 12779110 | PRJEB28062_P_NODE_82291_length_369_cov_21.364865_g79929_i0 | PRJEB28062 | 82291 | 369 | 21.364865000000002 | 78.83635185 | Oxyuris equi | 132389 | Nematoda | Nematoda | 200 | 1.18e-46 | NTclustered | gi|1360375498|gb|KY990021.1| | 132389 | g79929 | i0 | 93.985 | 35.9891598915989 | 133 | 7 | 36 | 1 | 227 | 359 | 2415 | 2546 | Oxyuris equi isolate SAN-7891 28S ribosomal RNA gene, partial sequence | blastn | 13280 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Oxyuridae | Oxyuris | Oxyuris equi | |
| 17875092 | 17875092 | PRJEB28062_P_NODE_102095_length_308_cov_25.625532_g99732_i0 | PRJEB28062 | 102095 | 308 | 25.625532 | 78.92663856 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.029 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g99732 | i0 | 100 | 0.0909090909090909 | 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 | |
| 17875583 | 17875583 | PRJEB28062_P_NODE_128275_length_244_cov_28.368421_g125911_i0 | PRJEB28062 | 128275 | 244 | 28.368421 | 69.21894724 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.022 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g125911 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 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 | |
| 21700552 | 21700552 | PRJEB28062_P_NODE_121058_length_258_cov_1.572973_g118694_i0 | PRJEB28062 | 121058 | 258 | 1.572973 | 4.05827034 | Oscheius dolichura | 473156 | Nematoda | Nematoda | 429 | 9.29e-116 | NTclustered | gi|158821907|gb|EU195971.1| | 473156 | g118694 | i0 | 97.984 | 78.2248062015504 | 248 | 4 | 96 | 1 | 1 | 248 | 1981 | 2227 | Oscheius dolichura strain JU460 28S ribosomal RNA gene, partial sequence | blastn | 20182 | 429 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Oscheius | Oscheius dolichura | |
| 21702230 | 21702230 | PRJEB28062_P_NODE_77598_length_385_cov_4.041667_g75236_i0 | PRJEB28062 | 77598 | 385 | 4.041667 | 15.56041795 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.037 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g75236 | i0 | 100 | 0.0727272727272727 | 28 | 0 | 7 | 0 | 358 | 385 | 52 | 25 | 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 | |
| 22975701 | 22975701 | PRJEB28062_P_NODE_114799_length_273_cov_7.750000_g112436_i0 | PRJEB28062 | 114799 | 273 | 7.75 | 21.1575 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.007 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g112436 | i0 | 100 | 0.106227106227106 | 29 | 0 | 11 | 0 | 245 | 273 | 54 | 26 | 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 | |
| 25213325 | 25213325 | PRJEB28062_P_NODE_19740_length_846_cov_3.670116_g17700_i0 | PRJEB28062 | 19740 | 846 | 3.670116 | 31.04918136 | Meloidogyne | 189290 | Nematoda | Nematoda | 656 | 0 | NTclustered | gi|18147020|dbj|AB047767.1| | 6304 | g17700 | i0 | 81.159 | 75.725768321513 | 828 | 147 | 98 | 7 | 22 | 846 | 426 | 1247 | Meloidogyne arenaria DNA, polymorphic marker for virulence, isolate:MAMG-AV | blastn | 64064 | 662 | 0.990936555891239 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne arenaria | |
| 32404434 | 32404434 | PRJEB28062_P_NODE_124079_length_251_cov_2.129213_g121715_i0 | PRJEB28062 | 124079 | 251 | 2.129213 | 5.34432463 | Enterobius vermicularis | 51028 | Nematoda | Nematoda | 131 | 6.51e-38 | NR | YP_010133163.1 | 51028 | g121715 | i0 | 96 | 0.896414342629482 | 75 | 3 | 89.6 | 0 | 26 | 250 | 2 | 76 | YP_010133163.1 NADH dehydrogenase subunit 4L [Enterobius vermicularis] | diamond | 225 | 131 | 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);;