contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA781427" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 759833 | 759833 | PRJNA781427_P_NODE_11921_length_755_cov_42.329912_g11150_i0 | PRJNA781427 | 11921 | 755 | 42.329912 | 319.5908356 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1345 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g11150 | i0 | 98.808 | 4.84635761589404 | 755 | 9 | 100 | 0 | 1 | 755 | 4124 | 4878 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 3659 | 1345 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 2037507 | 2037507 | PRJNA781427_P_NODE_7382_length_1015_cov_12.863057_g6777_i0 | PRJNA781427 | 7382 | 1015 | 12.863057 | 130.56002855 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1770 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g6777 | i0 | 98.128 | 1.99113300492611 | 1015 | 19 | 100 | 0 | 1 | 1015 | 11733 | 10719 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 2021 | 1770 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 4589851 | 4589851 | PRJNA781427_P_NODE_7664_length_992_cov_16.791077_g7046_i0 | PRJNA781427 | 7664 | 992 | 16.791077 | 166.56748384 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1760 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g7046 | i0 | 98.69 | 4.85685483870968 | 992 | 13 | 100 | 0 | 1 | 992 | 13100 | 12109 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 4818 | 1760 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 5863653 | 5863653 | PRJNA781427_P_NODE_25405_length_469_cov_4.530303_g24525_i0 | PRJNA781427 | 25405 | 469 | 4.530303 | 21.24712107 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 837 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g24525 | i0 | 98.932 | 0.997867803837953 | 468 | 5 | 99 | 0 | 1 | 468 | 10140 | 9673 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 468 | 837 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 5863713 | 5863713 | PRJNA781427_P_NODE_27525_length_447_cov_1.925134_g26644_i0 | PRJNA781427 | 27525 | 447 | 1.925134 | 8.60534898 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 278 | 6.56e-70 | NTclustered | gi|339246942|ref|XM_003375057.1| | 6334 | g26644 | i0 | 78.788 | 0.959731543624161 | 429 | 79 | 95 | 10 | 8 | 430 | 668 | 1090 | Trichinella spiralis transmembrane anterior posterior transformation protein 1 (Tsp_04290) mRNA, complete cds | blastn | 429 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 5863958 | 5863958 | PRJNA781427_P_NODE_36745_length_378_cov_6.777049_g35863_i0 | PRJNA781427 | 36745 | 378 | 6.777049 | 25.61724522 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 699 | 0 | NTclustered | gi|1070586637|gb|KU987805.1| | 1904821 | g35863 | i0 | 100 | 95.489417989418 | 378 | 0 | 100 | 0 | 1 | 378 | 567 | 944 | Pseudocapillaria tomentosa 18S ribosomal RNA gene, partial sequence | blastn | 36095 | 699 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 5864340 | 5864340 | PRJNA781427_P_NODE_5065_length_1254_cov_1.577477_g4594_i0 | PRJNA781427 | 5065 | 1254 | 1.577477 | 19.78156158 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 233 | 4.26e-56 | NTclustered | gi|339250219|ref|XM_003374047.1| | 6334 | g4594 | i0 | 79.518 | 0.470494417862839 | 332 | 64 | 26 | 4 | 268 | 597 | 640 | 311 | Trichinella spiralis zinc finger protein 423-like protein (Tsp_08822) mRNA, complete cds | blastn | 590 | 233 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 8412957 | 8412957 | PRJNA781427_P_NODE_11867_length_758_cov_2.651095_g11096_i0 | PRJNA781427 | 11867 | 758 | 2.651095 | 20.0953001 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 442 | 3.8599999999999986e-119 | NTclustered | gi|339248356|ref|XM_003373118.1| | 6334 | g11096 | i0 | 80.736 | 0.753298153034301 | 571 | 106 | 75 | 4 | 164 | 732 | 645 | 77 | Trichinella spiralis neuronal calcium sensor 2 (Tsp_10012) mRNA, complete cds | blastn | 571 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 9688438 | 9688438 | PRJNA781427_P_NODE_16048_length_626_cov_3.591320_g15209_i0 | PRJNA781427 | 16048 | 626 | 3.59132 | 22.4816632 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1146 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g15209 | i0 | 99.681 | 4.16453674121406 | 626 | 2 | 100 | 0 | 1 | 626 | 1655 | 2280 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 2607 | 1146 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 9689494 | 9689494 | PRJNA781427_P_NODE_5668_length_1178_cov_8.619005_g5164_i0 | PRJNA781427 | 5668 | 1178 | 8.619005 | 101.5318789 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 569 | 2.679999999999999e-157 | NTclustered | gi|339233103|ref|XM_003381621.1| | 6334 | g5164 | i0 | 80.597 | 45.9490662139219 | 737 | 143 | 63 | 0 | 268 | 1004 | 795 | 59 | Trichinella spiralis syntaxin-1A (Tsp_07354) mRNA, complete cds | blastn | 54128 | 569 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 9690495 | 9690495 | PRJNA781427_P_NODE_9888_length_848_cov_18.068387_g9179_i0 | PRJNA781427 | 9888 | 848 | 18.068387 | 153.21992176 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 359 | 4.49e-94 | NTclustered | gi|339252409|ref|XM_003371380.1| | 6334 | g9179 | i0 | 80.736 | 2.44693396226415 | 462 | 87 | 54 | 2 | 160 | 620 | 1 | 461 | Trichinella spiralis troponin C, isoform 2 (Tsp_11636) mRNA, complete cds | blastn | 2075 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 10964116 | 10964116 | PRJNA781427_P_NODE_16189_length_622_cov_157.484517_g15347_i0 | PRJNA781427 | 16189 | 622 | 157.484517 | 979.55369574 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1110 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g15347 | i0 | 98.875 | 2.5064308681672 | 622 | 7 | 100 | 0 | 1 | 622 | 7198 | 7819 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 1559 | 1110 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 14789604 | 14789604 | PRJNA781427_P_NODE_5552_length_1193_cov_66.890179_g5053_i0 | PRJNA781427 | 5552 | 1193 | 66.890179 | 797.99983547 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 2104 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g5053 | i0 | 98.491 | 38.5674769488684 | 1193 | 18 | 100 | 0 | 1 | 1193 | 379 | 1571 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 46011 | 2104 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 16063926 | 16063926 | PRJNA781427_P_NODE_71593_length_257_cov_1.255435_g70709_i0 | PRJNA781427 | 71593 | 257 | 1.255435 | 3.22646795 | Pristionchus microcercus | 3308705 | Nematoda | Nematoda | 137 | 6.27e-28 | NTclustered | gi|675118931|gb|KJ877345.1| | 3308705 | g70709 | i0 | 81.503 | 7.06614785992218 | 173 | 26 | 66 | 6 | 2 | 171 | 357 | 526 | Paroigolaimella micrura large subunit ribosomal protein 10 (rpl-10) mRNA, partial cds | blastn | 1816 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus microcercus | |
| 19886673 | 19886673 | PRJNA781427_P_NODE_10476_length_821_cov_80.378342_g9747_i0 | PRJNA781427 | 10476 | 821 | 80.378342 | 659.90618782 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1395 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g9747 | i0 | 97.32 | 23.8989037758831 | 821 | 22 | 100 | 0 | 1 | 821 | 4124 | 4944 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 19621 | 1395 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 19887274 | 19887274 | PRJNA781427_P_NODE_33276_length_400_cov_1.412844_g32395_i0 | PRJNA781427 | 33276 | 400 | 1.412844 | 5.651376 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 75 | 8.18e-9 | NTclustered | gi|339239566|ref|XM_003381290.1| | 6334 | g32395 | i0 | 84.211 | 0.19 | 76 | 12 | 19 | 0 | 262 | 337 | 1346 | 1421 | Trichinella spiralis putative calcium binding EGF domain protein (Tsp_07869) mRNA, complete cds | blastn | 76 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 19887291 | 19887291 | PRJNA781427_P_NODE_3376_length_1536_cov_261.201640_g3047_i0 | PRJNA781427 | 3376 | 1536 | 261.20164 | 4012.0571904 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 2704 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g3047 | i0 | 98.438 | 43.232421875 | 1536 | 24 | 100 | 0 | 1 | 1536 | 7177 | 5642 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 66405 | 2704 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 19887445 | 19887445 | PRJNA781427_P_NODE_396_length_3332_cov_21.605707_g355_i0 | PRJNA781427 | 396 | 3332 | 21.605707 | 719.90215724 | Ancylostoma caninum | 29170 | Nematoda | Nematoda | 996 | 0 | NTclustered | gi|86160923|gb|DQ358106.1| | 29170 | g355 | i0 | 74.166 | 0.746998799519808 | 2489 | 601 | 74 | 37 | 621 | 3088 | 2708 | 241 | Ancylostoma caninum paramyosin mRNA, complete cds | blastn | 2489 | 996 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma caninum | |
| 21162753 | 21162753 | PRJNA781427_P_NODE_2337_length_1789_cov_9.567599_g2101_i0 | PRJNA781427 | 2337 | 1789 | 9.567599 | 171.16434611 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 763 | 0 | NTclustered | gi|339246888|ref|XM_003375030.1| | 6334 | g2101 | i0 | 83.057 | 3.18725544997205 | 844 | 140 | 47 | 3 | 371 | 1212 | 55 | 897 | Trichinella spiralis putative LIM domain protein (Tsp_04264) mRNA, complete cds | blastn | 5702 | 763 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 22439354 | 22439354 | PRJNA781427_P_NODE_9578_length_864_cov_26.628319_g8879_i0 | PRJNA781427 | 9578 | 864 | 26.628319 | 230.06867616 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1563 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g8879 | i0 | 99.306 | 1.33796296296296 | 864 | 6 | 100 | 0 | 1 | 864 | 7973 | 8836 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 1156 | 1563 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 23713427 | 23713427 | PRJNA781427_P_NODE_4059_length_1407_cov_25.200900_g3683_i0 | PRJNA781427 | 4059 | 1407 | 25.2009 | 354.576663 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 715 | 0 | NTclustered | gi|339254855|ref|XM_003372603.1| | 6334 | g3683 | i0 | 82.045 | 15.3049040511727 | 841 | 149 | 60 | 2 | 219 | 1058 | 1 | 840 | Trichinella spiralis tropomyosin (Tsp_11392) mRNA, complete cds | blastn | 21534 | 715 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 23714480 | 23714480 | PRJNA781427_P_NODE_8199_length_951_cov_521.100228_g7560_i0 | PRJNA781427 | 8199 | 951 | 521.100228 | 4955.66316828 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1674 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g7560 | i0 | 99.781 | 48.2986330178759 | 912 | 2 | 96 | 0 | 9 | 920 | 3277 | 2366 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 45932 | 1674 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa |
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);;