contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA656952" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 621882 | 621882 | PRJNA656952_P_NODE_10341_length_388_cov_1.222222_g10154_i0 | PRJNA656952 | 10341 | 388 | 1.222222 | 4.74222136 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 532 | 1.09e-146 | NTclustered | gi|2226399|emb|Z75956.1| | 6239 | g10154 | i0 | 100 | 6.44845360824742 | 288 | 0 | 74 | 0 | 1 | 288 | 19701 | 19414 | Caenorhabditis elegans Cosmid R31, complete sequence | blastn | 2502 | 532 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 3172948 | 3172948 | PRJNA656952_P_NODE_18703_length_313_cov_0.962500_g18516_i0 | PRJNA656952 | 18703 | 313 | 0.9625 | 3.012625 | Radopholus similis | 46012 | Nematoda | Nematoda | 562 | 1.09e-155 | NTclustered | gi|1537069153|gb|MH499258.1| | 46012 | g18516 | i0 | 99.355 | 0.990415335463259 | 310 | 2 | 99 | 0 | 4 | 313 | 312 | 3 | Radopholus similis eukaryotic translation initiation factor 5A (eIF5A) mRNA, partial cds | blastn | 310 | 562 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Radopholus | Radopholus similis | |
| 3711680 | 3711680 | PRJNA656952_P_NODE_19103_length_310_cov_1.299578_g18916_i0 | PRJNA656952 | 19103 | 310 | 1.299578 | 4.0286918 | Caenorhabditis | 6237 | Nematoda | Nematoda | 161 | 4.6099999999999995e-35 | NTclustered | gi|268563830|ref|XM_002646977.1| | 6238 | g18916 | i0 | 77.907 | 3.78387096774194 | 258 | 57 | 83 | 0 | 7 | 264 | 284 | 27 | Caenorhabditis briggsae Protein CBR-MLC-3 (Cbr-mlc-3), partial mRNA | blastn | 1173 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 4450012 | 4450012 | PRJNA656952_P_NODE_21364_length_296_cov_1.461883_g21177_i0 | PRJNA656952 | 21364 | 296 | 1.461883 | 4.32717368 | Ditylenchus destructor | 166010 | Nematoda | Nematoda | 320 | 6.82e-83 | NTclustered | gi|347723361|gb|HQ386232.1| | 166010 | g21177 | i0 | 86.149 | 102.540540540541 | 296 | 41 | 100 | 0 | 1 | 296 | 1551 | 1256 | Ditylenchus destructor HSP70-1 mRNA, complete cds | blastn | 30352 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 4450134 | 4450134 | PRJNA656952_P_NODE_26764_length_270_cov_1.563452_g26577_i0 | PRJNA656952 | 26764 | 270 | 1.563452 | 4.2213204 | Radopholus similis | 46012 | Nematoda | Nematoda | 486 | 5.7199999999999984e-133 | NTclustered | gi|197258085|gb|EU659125.1| | 46012 | g26577 | i0 | 100 | 3.55925925925926 | 263 | 0 | 97 | 0 | 8 | 270 | 1106 | 844 | Radopholus similis cathepsin S-like cysteine proteinase mRNA, complete cds | blastn | 961 | 486 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Radopholus | Radopholus similis | |
| 7000634 | 7000634 | PRJNA656952_P_NODE_16306_length_329_cov_1.203125_g16119_i0 | PRJNA656952 | 16306 | 329 | 1.203125 | 3.95828125 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 204 | 8.08e-48 | NTclustered | gi|1972295142|ref|NM_073664.7| | 6239 | g16119 | i0 | 78.438 | 66.1793313069909 | 320 | 63 | 96 | 6 | 3 | 319 | 4781 | 5097 | Caenorhabditis elegans Myosin-3 (myo-3), mRNA | blastn | 21773 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 9550686 | 9550686 | PRJNA656952_P_NODE_1888_length_715_cov_1.635514_g1745_i0 | PRJNA656952 | 1888 | 715 | 1.635514 | 11.6939251 | Ditylenchus destructor | 166010 | Nematoda | Nematoda | 597 | 7.319999999999998e-166 | NTclustered | gi|321173528|gb|HQ123250.1| | 166010 | g1745 | i0 | 85.54 | 68.1748251748252 | 574 | 79 | 80 | 4 | 139 | 710 | 834 | 263 | Ditylenchus destructor 14-3-3 (14-3-3a) mRNA, complete cds | blastn | 48745 | 597 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 9551262 | 9551262 | PRJNA656952_P_NODE_5808_length_479_cov_1.317734_g5621_i0 | PRJNA656952 | 5808 | 479 | 1.317734 | 6.31194586 | Radopholus similis | 46012 | Nematoda | Nematoda | 863 | 0 | NTclustered | gi|300952941|gb|GU360972.1| | 46012 | g5621 | i0 | 99.165 | 6.19832985386221 | 479 | 4 | 100 | 0 | 1 | 479 | 684 | 1162 | Radopholus similis cathepsin B mRNA, complete cds | blastn | 2969 | 863 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Radopholus | Radopholus similis | |
| 10826480 | 10826480 | PRJNA656952_P_NODE_26109_length_273_cov_1.355000_g25922_i0 | PRJNA656952 | 26109 | 273 | 1.355 | 3.69915 | Radopholus similis | 46012 | Nematoda | Nematoda | 209 | 1.41e-49 | NTclustered | gi|1048075091|gb|KT948899.1| | 46012 | g25922 | i0 | 100 | 0.413919413919414 | 113 | 0 | 41 | 0 | 1 | 113 | 120 | 8 | Radopholus similis isolate R01 serine/threonine protein phosphatase mRNA, partial cds | blastn | 113 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Radopholus | Radopholus similis | |
| 12101860 | 12101860 | PRJNA656952_P_NODE_34630_length_248_cov_1.594286_g34443_i0 | PRJNA656952 | 34630 | 248 | 1.594286 | 3.95382928 | Radopholus similis | 46012 | Nematoda | Nematoda | 453 | 5.2600000000000005e-123 | NTclustered | gi|1048075093|gb|KT948900.1| | 46012 | g34443 | i0 | 99.597 | 1 | 248 | 1 | 100 | 0 | 1 | 248 | 283 | 530 | Radopholus similis isolate R01 copper/zinc superoxide dismutase mRNA, partial cds | blastn | 248 | 453 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Radopholus | Radopholus similis | |
| 14651035 | 14651035 | PRJNA656952_P_NODE_18712_length_313_cov_0.950000_g18525_i0 | PRJNA656952 | 18712 | 313 | 0.95 | 2.9735 | Radopholus similis | 46012 | Nematoda | Nematoda | 573 | 5.049999999999998e-159 | NTclustered | gi|157411572|gb|EF693942.1| | 46012 | g18525 | i0 | 99.681 | 2.68051118210863 | 313 | 1 | 100 | 0 | 1 | 313 | 960 | 1272 | Radopholus similis GHF5 endo-1,4-beta-glucanase precursor (eng2) gene, complete cds | blastn | 839 | 573 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Radopholus | Radopholus similis | |
| 14651334 | 14651334 | PRJNA656952_P_NODE_332_length_1336_cov_4.270784_g254_i0 | PRJNA656952 | 332 | 1336 | 4.270784 | 57.05767424 | Pristionchus pacificus | 54126 | Nematoda | Nematoda | 1064 | 0 | NTclustered | gi|199600269|tpg|BK006064.1| | 54126 | g254 | i0 | 83.333 | 77.6002994011976 | 1158 | 187 | 86 | 4 | 2 | 1154 | 321 | 1477 | TPA_inf: Pristionchus pacificus eukaryotic translation elongation factor 1A (eft-1) mRNA, complete cds | blastn | 103674 | 1064 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 14651549 | 14651549 | PRJNA656952_P_NODE_43292_length_241_cov_0.916667_g43105_i0 | PRJNA656952 | 43292 | 241 | 0.916667 | 2.20916747 | Radopholus similis | 46012 | Nematoda | Nematoda | 440 | 3.959999999999999e-119 | NTclustered | gi|197258083|gb|EU659124.1| | 46012 | g43105 | i0 | 99.585 | 1 | 241 | 1 | 100 | 0 | 1 | 241 | 440 | 680 | Radopholus similis cathepsin L-like cysteine proteinase mRNA, complete cds | blastn | 241 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Radopholus | Radopholus similis | |
| 17200324 | 17200324 | PRJNA656952_P_NODE_32014_length_251_cov_0.865169_g31827_i0 | PRJNA656952 | 32014 | 251 | 0.865169 | 2.17157419 | Radopholus similis | 46012 | Nematoda | Nematoda | 407 | 4.2099999999999995e-109 | NTclustered | gi|300952941|gb|GU360972.1| | 46012 | g31827 | i0 | 96.386 | 0.99203187250996006 | 249 | 5 | 99 | 3 | 3 | 251 | 2 | 246 | Radopholus similis cathepsin B mRNA, complete cds | blastn | 249 | 407 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Radopholus | Radopholus similis | |
| 18474175 | 18474175 | PRJNA656952_P_NODE_11875_length_369_cov_1.168919_g11688_i0 | PRJNA656952 | 11875 | 369 | 1.168919 | 4.31331111 | Radopholus similis | 46012 | Nematoda | Nematoda | 671 | 0 | NTclustered | gi|651209571|gb|KJ617041.1| | 46012 | g11688 | i0 | 99.458 | 1 | 369 | 2 | 100 | 0 | 1 | 369 | 806 | 1174 | Radopholus similis serine carboxypeptidases mRNA, complete cds | blastn | 369 | 671 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Radopholus | Radopholus similis | |
| 18474339 | 18474339 | PRJNA656952_P_NODE_1895_length_714_cov_2.536661_g1752_i0 | PRJNA656952 | 1895 | 714 | 2.536661 | 18.11175954 | Radopholus similis | 46012 | Nematoda | Nematoda | 1282 | 0 | NTclustered | gi|385843185|gb|JN968974.1| | 46012 | g1752 | i0 | 99.157 | 0.997198879551821 | 712 | 6 | 99 | 0 | 3 | 714 | 769 | 58 | Radopholus similis fatty acid and retinol binding protein (far-1) mRNA, complete cds | blastn | 712 | 1282 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Radopholus | Radopholus similis | |
| 18474378 | 18474378 | PRJNA656952_P_NODE_20835_length_299_cov_1.942478_g20648_i0 | PRJNA656952 | 20835 | 299 | 1.942478 | 5.80800922 | Radopholus similis | 46012 | Nematoda | Nematoda | 545 | 1.0499999999999999e-150 | NTclustered | gi|145279866|emb|AM691120.1| | 46012 | g20648 | i0 | 99.666 | 1 | 299 | 0 | 100 | 1 | 1 | 299 | 379 | 82 | Radopholus similis partial mRNA for transthyretin-like protein 4 (ttl-4 gene) | blastn | 299 | 545 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Radopholus | Radopholus similis | |
| 19011380 | 19011380 | PRJNA656952_P_NODE_15995_length_331_cov_1.790698_g15808_i0 | PRJNA656952 | 15995 | 331 | 1.790698 | 5.92721038 | Pristionchus | 54125 | Nematoda | Nematoda | 261 | 4.76e-65 | NTclustered | gi|150984647|gb|EF634985.1| | 452809 | g15808 | i0 | 87.336 | 54.1027190332326 | 229 | 27 | 69 | 2 | 60 | 287 | 253 | 26 | Pristionchus sp. 15 RS5229 small subunit ribosomal protein 27 (rps-27) mRNA, complete cds | blastn | 17908 | 261 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 15 RS5229 | |
| 19749559 | 19749559 | PRJNA656952_P_NODE_476_length_1153_cov_2.322222_g384_i0 | PRJNA656952 | 476 | 1153 | 2.322222 | 26.77521966 | Heterodera glycines | 51029 | Nematoda | Nematoda | 917 | 0 | NTclustered | gi|33333844|gb|AF546757.1| | 51029 | g384 | i0 | 85.6 | 62.9470945359931 | 875 | 124 | 76 | 2 | 241 | 1114 | 912 | 39 | Heterodera glycines tropomyosin (trp1) mRNA, complete cds | blastn | 72578 | 917 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera glycines | |
| 20286670 | 20286670 | PRJNA656952_P_NODE_43076_length_241_cov_2.261905_g42889_i0 | PRJNA656952 | 43076 | 241 | 2.261905 | 5.45119105 | Caenorhabditis | 6237 | Nematoda | Nematoda | 193 | 1.23e-44 | NTclustered | gi|66473315|gb|DQ029116.1| | 31234 | g42889 | i0 | 89.933 | 3.00414937759336 | 149 | 15 | 62 | 0 | 26 | 174 | 349 | 201 | Caenorhabditis remanei small subunit ribosomal protein 30 mRNA, partial cds | blastn | 724 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 21024530 | 21024530 | PRJNA656952_P_NODE_16417_length_328_cov_1.431373_g16230_i0 | PRJNA656952 | 16417 | 328 | 1.431373 | 4.69490344 | Heterodera glycines | 51029 | Nematoda | Nematoda | 222 | 2.22e-53 | NTclustered | gi|50086702|gb|AY672636.1| | 51029 | g16230 | i0 | 88.889 | 1.09756097560976 | 180 | 20 | 55 | 0 | 2 | 181 | 1045 | 1224 | Heterodera glycines unc-87 (unc87) mRNA, complete cds | blastn | 360 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera glycines | |
| 24848486 | 24848486 | PRJNA656952_P_NODE_23000_length_287_cov_1.439252_g22813_i0 | PRJNA656952 | 23000 | 287 | 1.439252 | 4.13065324 | Heterodera avenae | 34510 | Nematoda | Nematoda | 250 | 8.77e-62 | NTclustered | gi|1341121474|gb|MG525187.1| | 34510 | g22813 | i0 | 83.333 | 2.85017421602787 | 270 | 45 | 94 | 0 | 9 | 278 | 471 | 740 | Heterodera avenae isolate isotig09722 putative effector protein gene, complete cds | blastn | 818 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera avenae |
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);;