contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA853194" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 839943 | 839943 | PRJNA853194_S_NODE_21781_length_433_cov_1.386111_g20690_i0 | PRJNA853194 | 21781 | 433 | 1.386111 | 6.00186063 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 54.7 | 0.012 | NTclustered | gi|690018546|emb|LM525784.1| | 174720 | g20690 | i0 | 96.875 | 0.0739030023094688 | 32 | 1 | 7 | 0 | 74 | 105 | 7910 | 7879 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000170 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 2115995 | 2115995 | PRJNA853194_S_NODE_52402_length_301_cov_1.083333_g51311_i0 | PRJNA853194 | 52402 | 301 | 1.083333 | 3.26083233 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 54.7 | 0.008 | NTclustered | gi|687023049|emb|LM526711.1| | 174720 | g51311 | i0 | 100 | 0.478405315614618 | 29 | 0 | 10 | 0 | 168 | 196 | 4390 | 4418 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0001053 | blastn | 144 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 2116167 | 2116167 | PRJNA853194_S_NODE_61002_length_280_cov_4.333333_g59911_i0 | PRJNA853194 | 61002 | 280 | 4.333333 | 12.1333324 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.007 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g59911 | i0 | 100 | 0.103571428571429 | 29 | 0 | 10 | 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 | |
| 2116615 | 2116615 | PRJNA853194_S_NODE_86102_length_238_cov_3.272727_g85011_i0 | PRJNA853194 | 86102 | 238 | 3.272727 | 7.78909026 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|687022784|emb|LM525896.1| | 174720 | g85011 | i0 | 100 | 0.121848739495798 | 29 | 0 | 12 | 0 | 192 | 220 | 23280 | 23252 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000270 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 5942920 | 5942920 | PRJNA853194_S_NODE_11465_length_562_cov_1086.098160_g701_i1 | PRJNA853194 | 11465 | 562 | 1086.09816 | 6103.8716592 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 202 | 5.199999999999998e-47 | NTclustered | gi|690018840|emb|LM526136.1| | 174720 | g701 | i1 | 79.649 | 4.79181494661922 | 285 | 54 | 50 | 4 | 112 | 394 | 7759 | 8041 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000493 | blastn | 2693 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 5943601 | 5943601 | PRJNA853194_S_NODE_41745_length_333_cov_1.103846_g40654_i0 | PRJNA853194 | 41745 | 333 | 1.103846 | 3.67580718 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 56.5 | 0.002 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g40654 | i0 | 100 | 0.0900900900900901 | 30 | 0 | 9 | 0 | 304 | 333 | 52 | 23 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 8494128 | 8494128 | PRJNA853194_S_NODE_85827_length_240_cov_2.730539_g84736_i0 | PRJNA853194 | 85827 | 240 | 2.730539 | 6.5532936 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g84736 | i0 | 100 | 0.120833333333333 | 29 | 0 | 12 | 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 | |
| 9768595 | 9768595 | PRJNA853194_S_NODE_49768_length_308_cov_1.387234_g48677_i0 | PRJNA853194 | 49768 | 308 | 1.387234 | 4.27268072 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.008 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g48677 | i0 | 100 | 0.0941558441558442 | 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 | |
| 11044856 | 11044856 | PRJNA853194_S_NODE_84669_length_242_cov_0.911243_g83578_i0 | PRJNA853194 | 84669 | 242 | 0.911243 | 2.20520806 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.022 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g83578 | i0 | 100 | 0.115702479338843 | 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 | |
| 12319106 | 12319106 | PRJNA853194_S_NODE_17810_length_469_cov_0.936869_g16721_i0 | PRJNA853194 | 17810 | 469 | 0.936869 | 4.39391561 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 54.7 | 0.013 | NTclustered | gi|687865596|emb|LK927677.1| | 6239 | g16721 | i0 | 92.308 | 0.181236673773987 | 39 | 2 | 8 | 1 | 431 | 469 | 95397 | 95360 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000129 | blastn | 85 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 13593782 | 13593782 | PRJNA853194_S_NODE_24771_length_412_cov_1.212389_g23680_i0 | PRJNA853194 | 24771 | 412 | 1.212389 | 4.99504268 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.04 | NTclustered | gi|687865958|emb|LK928038.1| | 6239 | g23680 | i0 | 100 | 0.203883495145631 | 28 | 0 | 7 | 0 | 195 | 222 | 60775 | 60802 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000427 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 13594215 | 13594215 | PRJNA853194_S_NODE_46131_length_318_cov_7.914286_g45040_i0 | PRJNA853194 | 46131 | 318 | 7.914286 | 25.16742948 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 56.5 | 0.002 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g45040 | i0 | 100 | 0.0943396226415094 | 30 | 0 | 9 | 0 | 1 | 30 | 23 | 52 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 14868243 | 14868243 | PRJNA853194_S_NODE_3672_length_911_cov_6.051313_g2953_i0 | PRJNA853194 | 3672 | 911 | 6.051313 | 55.12746143 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 54.7 | 0.026 | NTclustered | gi|687022656|emb|LM525570.1| | 174720 | g2953 | i0 | 96.97 | 0.0362239297475302 | 33 | 0 | 4 | 1 | 128 | 159 | 435638 | 435670 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000005 | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 16143206 | 16143206 | PRJNA853194_S_NODE_43573_length_326_cov_14.667984_g42482_i0 | PRJNA853194 | 43573 | 326 | 14.667984 | 47.81762784 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.031 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g42482 | i0 | 100 | 0.0858895705521472 | 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 | |
| 17418074 | 17418074 | PRJNA853194_S_NODE_17654_length_470_cov_7.010076_g16565_i0 | PRJNA853194 | 17654 | 470 | 7.010076 | 32.9473572 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 65.8 | 5.87e-6 | NTclustered | gi|1734331700|ref|NM_001322777.2| | 6239 | g16565 | i0 | 91.489 | 7.69574468085106 | 47 | 4 | 10 | 0 | 1 | 47 | 1243 | 1197 | Caenorhabditis elegans Ig-like domain-containing protein (spe-45), partial mRNA | blastn | 3617 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 17418134 | 17418134 | PRJNA853194_S_NODE_20494_length_443_cov_3.656757_g19403_i0 | PRJNA853194 | 20494 | 443 | 3.656757 | 16.19943351 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.043 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g19403 | i0 | 100 | 0.0632054176072235 | 28 | 0 | 6 | 0 | 416 | 443 | 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 | |
| 19967835 | 19967835 | PRJNA853194_S_NODE_956_length_1482_cov_382.024840_g701_i0 | PRJNA853194 | 956 | 1482 | 382.02484 | 5661.6081288 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 202 | 1.4299999999999999e-46 | NTclustered | gi|690018840|emb|LM526136.1| | 174720 | g701 | i0 | 79.649 | 1.81713900134953 | 285 | 54 | 19 | 4 | 112 | 394 | 7759 | 8041 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000493 | blastn | 2693 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 21241957 | 21241957 | PRJNA853194_S_NODE_19177_length_455_cov_2.277487_g18087_i0 | PRJNA853194 | 19177 | 455 | 2.277487 | 10.36256585 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.044 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g18087 | i0 | 100 | 0.0615384615384615 | 28 | 0 | 6 | 0 | 428 | 455 | 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 | |
| 22516914 | 22516914 | PRJNA853194_S_NODE_32038_length_371_cov_2.798658_g30947_i0 | PRJNA853194 | 32038 | 371 | 2.798658 | 10.38302118 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.01 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g30947 | i0 | 100 | 0.078167115902965 | 29 | 0 | 8 | 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 | |
| 23793211 | 23793211 | PRJNA853194_S_NODE_72819_length_257_cov_2.081522_g71728_i0 | PRJNA853194 | 72819 | 257 | 2.081522 | 5.34951154 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.023 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g71728 | i0 | 100 | 0.108949416342412 | 28 | 0 | 11 | 0 | 230 | 257 | 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 | |
| 23793340 | 23793340 | PRJNA853194_S_NODE_79519_length_248_cov_0.862857_g78428_i0 | PRJNA853194 | 79519 | 248 | 0.862857 | 2.13988536 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 58.4 | 4.82e-4 | NTclustered | gi|690018459|emb|LM525697.1| | 174720 | g78428 | i0 | 100 | 0.125 | 31 | 0 | 13 | 0 | 35 | 65 | 23216 | 23186 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000094 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus |
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);;