contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA1074407" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188727 | 188727 | PRJNA1074407_P_NODE_137401_length_247_cov_1.310345_g133563_i0 | PRJNA1074407 | 137401 | 247 | 1.310345 | 3.23655215 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 159 | 1.28e-34 | NTclustered | gi|339244724|ref|XM_003378240.1| | 6334 | g133563 | i0 | 84.81 | 0.639676113360324 | 158 | 24 | 64 | 0 | 90 | 247 | 1077 | 920 | Trichinella spiralis kinesin heavy chain (Tsp_06224) mRNA, complete cds | blastn | 158 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 2741015 | 2741015 | PRJNA1074407_P_NODE_70203_length_489_cov_3.000000_g66371_i0 | PRJNA1074407 | 70203 | 489 | 3 | 14.67 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 228 | 7.379999999999997e-55 | NTclustered | gi|339252409|ref|XM_003371380.1| | 6334 | g66371 | i0 | 76.574 | 0.811860940695297 | 397 | 83 | 79 | 5 | 102 | 489 | 1 | 396 | Trichinella spiralis troponin C, isoform 2 (Tsp_11636) mRNA, complete cds | blastn | 397 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 2741574 | 2741574 | PRJNA1074407_P_NODE_95603_length_364_cov_1.288660_g91766_i0 | PRJNA1074407 | 95603 | 364 | 1.28866 | 4.6907224 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 311 | 5.16e-80 | NTclustered | gi|339246888|ref|XM_003375030.1| | 6334 | g91766 | i0 | 87.004 | 0.760989010989011 | 277 | 35 | 76 | 1 | 8 | 283 | 621 | 897 | Trichinella spiralis putative LIM domain protein (Tsp_04264) mRNA, complete cds | blastn | 277 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 5292155 | 5292155 | PRJNA1074407_P_NODE_30225_length_1044_cov_4.023687_g27161_i0 | PRJNA1074407 | 30225 | 1044 | 4.023687 | 42.00729228 | Capillaria sp. ALS-2019 | 2651741 | Nematoda | Nematoda | 263 | 4.500000000000001e-65 | NTclustered | gi|1811126246|gb|MN526255.1| | 2651741 | g27161 | i0 | 99.31 | 19.477969348659 | 145 | 1 | 84 | 0 | 1 | 145 | 1188 | 1044 | Capillaria sp. ALS-2019 large subunit ribosomal RNA gene, partial sequence | blastn | 20335 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Capillaria | Capillaria sp. ALS-2019 | |
| 5293774 | 5293774 | PRJNA1074407_P_NODE_97925_length_355_cov_11.031915_g94087_i0 | PRJNA1074407 | 97925 | 355 | 11.031915 | 39.16329825 | Aonchotheca paranalis | 2025203 | Nematoda | Nematoda | 483 | 1.0099999999999998e-131 | NTclustered | gi|1279640587|gb|MF621021.1| | 2025203 | g94087 | i0 | 91.243 | 31.7915492957746 | 354 | 31 | 99 | 0 | 2 | 355 | 3555 | 3908 | Aonchotheca paranalis isolate PL 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 11286 | 483 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Aonchotheca | Aonchotheca paranalis | |
| 6566952 | 6566952 | PRJNA1074407_P_NODE_16806_length_1512_cov_16.585823_g14748_i0 | PRJNA1074407 | 16806 | 1512 | 16.585823 | 250.77764376 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 2737 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g14748 | i0 | 99.339 | 53.8492063492063 | 1512 | 10 | 100 | 0 | 1 | 1512 | 5647 | 7158 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 81420 | 2737 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 6567749 | 6567749 | PRJNA1074407_P_NODE_46966_length_722_cov_11.779661_g43279_i0 | PRJNA1074407 | 46966 | 722 | 11.779661 | 85.04915242 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1323 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g43279 | i0 | 99.723 | 62.8254847645429 | 722 | 2 | 100 | 0 | 1 | 722 | 3245 | 2524 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 45360 | 1323 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 7841197 | 7841197 | PRJNA1074407_P_NODE_127787_length_267_cov_1.077320_g123949_i0 | PRJNA1074407 | 127787 | 267 | 1.07732 | 2.8764444 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 56.5 | 0.002 | NTclustered | gi|687865940|emb|LK928062.1| | 6239 | g123949 | i0 | 100 | 0.224719101123595 | 30 | 0 | 11 | 0 | 230 | 259 | 5809 | 5838 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000088 | blastn | 60 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 9118385 | 9118385 | PRJNA1074407_P_NODE_89268_length_390_cov_1.381703_g85431_i0 | PRJNA1074407 | 89268 | 390 | 1.381703 | 5.3886417 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 710 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g85431 | i0 | 99.487 | 7.95641025641026 | 390 | 2 | 100 | 0 | 1 | 390 | 1178 | 1567 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 3103 | 710 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 10392392 | 10392392 | PRJNA1074407_P_NODE_22249_length_1284_cov_2.150289_g19700_i0 | PRJNA1074407 | 22249 | 1284 | 2.150289 | 27.60971076 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 715 | 0 | NTclustered | gi|339254855|ref|XM_003372603.1| | 6334 | g19700 | i0 | 82.045 | 16.7710280373832 | 841 | 149 | 65 | 2 | 137 | 976 | 1 | 840 | Trichinella spiralis tropomyosin (Tsp_11392) mRNA, complete cds | blastn | 21534 | 715 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 11668580 | 11668580 | PRJNA1074407_P_NODE_51290_length_664_cov_2.147208_g47524_i0 | PRJNA1074407 | 51290 | 664 | 2.147208 | 14.25746112 | Ancylostoma caninum | 29170 | Nematoda | Nematoda | 342 | 3.5e-89 | NTclustered | gi|86160923|gb|DQ358106.1| | 29170 | g47524 | i0 | 76.471 | 0.97289156626506 | 646 | 142 | 97 | 10 | 3 | 643 | 1234 | 1874 | Ancylostoma caninum paramyosin mRNA, complete cds | blastn | 646 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma caninum | |
| 15490902 | 15490902 | PRJNA1074407_P_NODE_111633_length_310_cov_2.725738_g107795_i0 | PRJNA1074407 | 111633 | 310 | 2.725738 | 8.4497878 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 150 | 9.98e-32 | NTclustered | gi|339243730|ref|XM_003377743.1| | 6334 | g107795 | i0 | 84.868 | 0.490322580645161 | 152 | 20 | 48 | 3 | 14 | 162 | 312 | 161 | Trichinella spiralis ADP/ATP translocase 1 (Tsp_01983) mRNA, complete cds | blastn | 152 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 16767169 | 16767169 | PRJNA1074407_P_NODE_63674_length_538_cov_1.369892_g59850_i0 | PRJNA1074407 | 63674 | 538 | 1.369892 | 7.37001896 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 407 | 9.79e-109 | NTclustered | gi|339240906|ref|XM_003376331.1| | 6334 | g59850 | i0 | 83.484 | 79.5799256505576 | 442 | 67 | 82 | 6 | 100 | 538 | 2270 | 1832 | Trichinella spiralis zinc finger protein (Tsp_00587) mRNA, complete cds | blastn | 42814 | 407 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 16767537 | 16767537 | PRJNA1074407_P_NODE_80414_length_431_cov_1.536313_g76578_i0 | PRJNA1074407 | 80414 | 431 | 1.536313 | 6.62150903 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 374 | 7.809999999999997e-99 | NTclustered | gi|339254111|ref|XM_003372231.1| | 6334 | g76578 | i0 | 82.588 | 97.9860788863109 | 425 | 72 | 98 | 2 | 5 | 428 | 599 | 176 | Trichinella spiralis moesin/ezrin/radixin protein (Tsp_10541) mRNA, complete cds | blastn | 42232 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 18039742 | 18039742 | PRJNA1074407_P_NODE_102835_length_338_cov_1.728302_g98997_i0 | PRJNA1074407 | 102835 | 338 | 1.728302 | 5.84166076 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 608 | 1.509999999999999e-169 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g98997 | i0 | 99.112 | 1.48520710059172 | 338 | 3 | 100 | 0 | 1 | 338 | 8373 | 8710 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 502 | 608 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 18041727 | 18041727 | PRJNA1074407_P_NODE_57195_length_597_cov_13.454198_g53392_i0 | PRJNA1074407 | 57195 | 597 | 13.454198 | 80.32156206 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1070 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g53392 | i0 | 98.995 | 2.56951423785595 | 597 | 6 | 100 | 0 | 1 | 597 | 7220 | 7816 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 1534 | 1070 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 18042171 | 18042171 | PRJNA1074407_P_NODE_74295_length_464_cov_1.680307_g70460_i0 | PRJNA1074407 | 74295 | 464 | 1.680307 | 7.79662448 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 852 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g70460 | i0 | 99.784 | 7.14870689655172 | 464 | 1 | 100 | 0 | 1 | 464 | 12234 | 12697 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 3317 | 852 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 19315893 | 19315893 | PRJNA1074407_P_NODE_62796_length_545_cov_1.578390_g58972_i0 | PRJNA1074407 | 62796 | 545 | 1.57839 | 8.6022255 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 134 | 1.86e-26 | NTclustered | gi|339254111|ref|XM_003372231.1| | 6334 | g58972 | i0 | 83.333 | 0.264220183486239 | 144 | 24 | 26 | 0 | 3 | 146 | 1594 | 1737 | Trichinella spiralis moesin/ezrin/radixin protein (Tsp_10541) mRNA, complete cds | blastn | 144 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 19316304 | 19316304 | PRJNA1074407_P_NODE_81556_length_425_cov_6.099432_g77720_i0 | PRJNA1074407 | 81556 | 425 | 6.099432 | 25.922586 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 130 | 1.84e-25 | NTclustered | gi|1938390596|gb|MW302146.1| | 6334 | g77720 | i0 | 89.32 | 22.3623529411765 | 103 | 11 | 24 | 0 | 323 | 425 | 6239 | 6341 | Trichinella spiralis isolate Europe-Poland-22D20-B small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 9504 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 20589312 | 20589312 | PRJNA1074407_P_NODE_114997_length_301_cov_1.052632_g111159_i0 | PRJNA1074407 | 114997 | 301 | 1.052632 | 3.16842232 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 534 | 2.28e-147 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g111159 | i0 | 98.671 | 1.42524916943522 | 301 | 4 | 100 | 0 | 1 | 301 | 11142 | 11442 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 429 | 534 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 21864846 | 21864846 | PRJNA1074407_P_NODE_102058_length_341_cov_1.470149_g98220_i0 | PRJNA1074407 | 102058 | 341 | 1.470149 | 5.01320809 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 630 | 3.2499999999999986e-176 | NTclustered | gi|1070586637|gb|KU987805.1| | 1904821 | g98220 | i0 | 100 | 95.1671554252199 | 341 | 0 | 100 | 0 | 1 | 341 | 946 | 606 | Pseudocapillaria tomentosa 18S ribosomal RNA gene, partial sequence | blastn | 32452 | 630 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 21867375 | 21867375 | PRJNA1074407_P_NODE_79098_length_437_cov_3.656593_g75262_i0 | PRJNA1074407 | 79098 | 437 | 3.656593 | 15.97931141 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 710 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g75262 | i0 | 96.092 | 15.3363844393593 | 435 | 17 | 99 | 0 | 1 | 435 | 4323 | 4757 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 6702 | 710 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 24415802 | 24415802 | PRJNA1074407_P_NODE_50940_length_668_cov_4.905882_g47177_i0 | PRJNA1074407 | 50940 | 668 | 4.905882 | 32.77129176 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1190 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g47177 | i0 | 98.802 | 5.35329341317365 | 668 | 8 | 100 | 0 | 1 | 668 | 4210 | 4877 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 3576 | 1190 | 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);;