contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA891846" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4696045 | 4696045 | PRJNA891846_P_NODE_644_length_1512_cov_2.022238_g575_i0 | PRJNA891846 | 644 | 1512 | 2.022238 | 30.57623856 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 785 | 0 | NTclustered | gi|339254111|ref|XM_003372231.1| | 6334 | g575 | i0 | 77.106 | 71.8690476190476 | 1389 | 298 | 91 | 17 | 2 | 1380 | 1379 | 1 | Trichinella spiralis moesin/ezrin/radixin protein (Tsp_10541) mRNA, complete cds | blastn | 108666 | 785 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 5970066 | 5970066 | PRJNA891846_P_NODE_17765_length_361_cov_0.934028_g17546_i0 | PRJNA891846 | 17765 | 361 | 0.934028 | 3.37184108 | Xiphinema brevicolle | 243734 | Nematoda | Nematoda | 311 | 5.11e-80 | NTclustered | gi|406362781|dbj|AB675673.1| | 243734 | g17546 | i0 | 82.808 | 58.5013850415512 | 349 | 58 | 96 | 2 | 7 | 354 | 673 | 326 | Xiphinema brevicolle mitochondrial COI gene for cytochrome oxidase subunit I, partial cds, DNA Extraction No. 149 | blastn | 21119 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dorylaimida | Longidoridae | Xiphinema | Xiphinema brevicolle | |
| 5970215 | 5970215 | PRJNA891846_P_NODE_2385_length_902_cov_21.697226_g2224_i0 | PRJNA891846 | 2385 | 902 | 21.697226 | 195.70897852 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1655 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g2224 | i0 | 99.889 | 51.1607538802661 | 899 | 1 | 99 | 0 | 4 | 902 | 3277 | 2379 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 46147 | 1655 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 7244869 | 7244869 | PRJNA891846_P_NODE_14666_length_395_cov_3.850932_g14447_i0 | PRJNA891846 | 14666 | 395 | 3.850932 | 15.2111814 | Pearsonema plica | 2025202 | Nematoda | Nematoda | 235 | 3.5e-57 | NTclustered | gi|585724675|gb|KF836607.1| | 2025202 | g14447 | i0 | 93.168 | 17.5443037974684 | 161 | 10 | 41 | 1 | 1 | 160 | 2006 | 2166 | Capillaria plica 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 | 6930 | 235 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pearsonema | Pearsonema plica | |
| 7245509 | 7245509 | PRJNA891846_P_NODE_40466_length_247_cov_1.729885_g40246_i0 | PRJNA891846 | 40466 | 247 | 1.729885 | 4.27281595 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 176 | 1.27e-39 | NTclustered | gi|339259677|ref|XM_003368738.1| | 6334 | g40246 | i0 | 80.258 | 13.2793522267206 | 233 | 46 | 94 | 0 | 5 | 237 | 381 | 149 | Trichinella spiralis sodium/potassium-transporting ATPase subunit alpha (Tsp_14317) mRNA, partial cds | blastn | 3280 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 7245768 | 7245768 | PRJNA891846_P_NODE_8246_length_514_cov_1.868481_g8031_i0 | PRJNA891846 | 8246 | 514 | 1.868481 | 9.60399234 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 209 | 2.82e-49 | NTclustered | gi|339246888|ref|XM_003375030.1| | 6334 | g8031 | i0 | 80.989 | 2.88132295719844 | 263 | 50 | 51 | 0 | 249 | 511 | 55 | 317 | Trichinella spiralis putative LIM domain protein (Tsp_04264) mRNA, complete cds | blastn | 1481 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 9794745 | 9794745 | PRJNA891846_P_NODE_18968_length_349_cov_12.054348_g18749_i0 | PRJNA891846 | 18968 | 349 | 12.054348 | 42.06967452 | Aonchotheca paranalis | 2025203 | Nematoda | Nematoda | 470 | 7.68e-128 | NTclustered | gi|1279640587|gb|MF621021.1| | 2025203 | g18749 | i0 | 91.066 | 31.8767908309456 | 347 | 31 | 99 | 0 | 3 | 349 | 3552 | 3898 | 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 | 11125 | 470 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Aonchotheca | Aonchotheca paranalis | |
| 9795488 | 9795488 | PRJNA891846_P_NODE_6108_length_588_cov_4.464078_g5898_i0 | PRJNA891846 | 6108 | 588 | 4.464078 | 26.24877864 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1081 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g5898 | i0 | 99.83 | 1.98639455782313 | 588 | 1 | 100 | 0 | 1 | 588 | 8550 | 7963 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 1168 | 1081 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 10171706 | 10171706 | PRJNA891846_P_NODE_4428_length_684_cov_3.235679_g4230_i0 | PRJNA891846 | 4428 | 684 | 3.235679 | 22.13204436 | Trichinella | 6333 | Nematoda | Nematoda | 420 | 1.6199999999999999e-112 | NTclustered | gi|339254855|ref|XM_003372603.1| | 6334 | g4230 | i0 | 81.984 | 4.30847953216374 | 494 | 89 | 72 | 0 | 189 | 682 | 1 | 494 | Trichinella spiralis tropomyosin (Tsp_11392) mRNA, complete cds | blastn | 2947 | 420 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 11070806 | 11070806 | PRJNA891846_P_NODE_35629_length_254_cov_2.436464_g35409_i0 | PRJNA891846 | 35629 | 254 | 2.436464 | 6.18861856 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 464 | 2.4999999999999994e-126 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g35409 | i0 | 99.606 | 11.4566929133858 | 254 | 1 | 100 | 0 | 1 | 254 | 12453 | 12706 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 2910 | 464 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 11071148 | 11071148 | PRJNA891846_P_NODE_669_length_1492_cov_26.472163_g597_i0 | PRJNA891846 | 669 | 1492 | 26.472163 | 394.96467196 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 2706 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g597 | i0 | 99.397 | 54.5630026809651 | 1492 | 9 | 100 | 0 | 1 | 1492 | 5645 | 7136 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 81408 | 2706 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 12345813 | 12345813 | PRJNA891846_P_NODE_1610_length_1068_cov_5.280402_g1484_i0 | PRJNA891846 | 1610 | 1068 | 5.280402 | 56.39469336 | Capillaria sp. ALS-2019 | 2651741 | Nematoda | Nematoda | 285 | 9.83e-72 | NTclustered | gi|1811126246|gb|MN526255.1| | 2651741 | g1484 | i0 | 99.363 | 24.2144194756554 | 157 | 1 | 85 | 0 | 1 | 157 | 1200 | 1044 | Capillaria sp. ALS-2019 large subunit ribosomal RNA gene, partial sequence | blastn | 25861 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Capillaria | Capillaria sp. ALS-2019 | |
| 14895261 | 14895261 | PRJNA891846_P_NODE_35852_length_253_cov_2.138889_g35632_i0 | PRJNA891846 | 35852 | 253 | 2.138889 | 5.41138917 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 254 | 5.86e-63 | NTclustered | gi|339246888|ref|XM_003375030.1| | 6334 | g35632 | i0 | 87.963 | 0.853754940711462 | 216 | 25 | 85 | 1 | 39 | 253 | 897 | 682 | Trichinella spiralis putative LIM domain protein (Tsp_04264) mRNA, complete cds | blastn | 216 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 16169972 | 16169972 | PRJNA891846_P_NODE_3613_length_752_cov_2.365243_g3424_i0 | PRJNA891846 | 3613 | 752 | 2.365243 | 17.78662736 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 200 | 2.54e-46 | NTclustered | gi|339243348|ref|XM_003377552.1| | 6334 | g3424 | i0 | 73.814 | 24.1077127659574 | 485 | 116 | 63 | 11 | 1 | 477 | 760 | 279 | Trichinella spiralis 6-phosphofructokinase (Tsp_01783) mRNA, complete cds | blastn | 18129 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 16170303 | 16170303 | PRJNA891846_P_NODE_7193_length_545_cov_8.269068_g6979_i0 | PRJNA891846 | 7193 | 545 | 8.269068 | 45.0664206 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 974 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g6979 | i0 | 98.899 | 1.57064220183486 | 545 | 6 | 100 | 0 | 1 | 545 | 7747 | 7203 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 856 | 974 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 18719026 | 18719026 | PRJNA891846_P_NODE_5675_length_611_cov_15.730483_g5465_i0 | PRJNA891846 | 5675 | 611 | 15.730483 | 96.11325113 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1107 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g5465 | i0 | 99.345 | 2.2847790507365 | 611 | 4 | 100 | 0 | 1 | 611 | 7203 | 7813 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 1396 | 1107 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 22544032 | 22544032 | PRJNA891846_P_NODE_33758_length_263_cov_1.221053_g33538_i0 | PRJNA891846 | 33758 | 263 | 1.221053 | 3.21136939 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 479 | 9.29e-131 | NTclustered | gi|1070586637|gb|KU987805.1| | 1904821 | g33538 | i0 | 99.62 | 98.7110266159696 | 263 | 0 | 100 | 1 | 1 | 263 | 864 | 603 | Pseudocapillaria tomentosa 18S ribosomal RNA gene, partial sequence | blastn | 25961 | 479 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 23819007 | 23819007 | PRJNA891846_P_NODE_19439_length_345_cov_2.018382_g19220_i0 | PRJNA891846 | 19439 | 345 | 2.018382 | 6.9634179 | Pearsonema plica | 2025202 | Nematoda | Nematoda | 95.3 | 5.35e-15 | NTclustered | gi|585724675|gb|KF836607.1| | 2025202 | g19220 | i0 | 93.75 | 15.336231884058 | 64 | 3 | 19 | 1 | 1 | 64 | 3099 | 3037 | Capillaria plica 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 | 5291 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pearsonema | Pearsonema plica | |
| 23819008 | 23819008 | PRJNA891846_P_NODE_19479_length_345_cov_1.389706_g19260_i0 | PRJNA891846 | 19479 | 345 | 1.389706 | 4.7944857 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 632 | 9.17e-177 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g19260 | i0 | 99.71 | 1 | 345 | 1 | 100 | 0 | 1 | 345 | 13102 | 12758 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 345 | 632 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 23819011 | 23819011 | PRJNA891846_P_NODE_19679_length_343_cov_3.066667_g19460_i0 | PRJNA891846 | 19679 | 343 | 3.066667 | 10.51866781 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 139 | 2.42e-28 | NTclustered | gi|339235336|ref|XM_003379175.1| | 6334 | g19460 | i0 | 82.692 | 14.9387755102041 | 156 | 27 | 45 | 0 | 186 | 341 | 65 | 220 | Trichinella spiralis ubiquitin-conjugating enzyme E2-21 protein (Tsp_02891) mRNA, complete cds | blastn | 5124 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 23819157 | 23819157 | PRJNA891846_P_NODE_2599_length_869_cov_1.562814_g2432_i0 | PRJNA891846 | 2599 | 869 | 1.562814 | 13.58085366 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1537 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g2432 | i0 | 98.618 | 20.7295742232451 | 868 | 12 | 99 | 0 | 1 | 868 | 482 | 1349 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 18014 | 1537 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 23819740 | 23819740 | PRJNA891846_P_NODE_539_length_1601_cov_3.653141_g476_i0 | PRJNA891846 | 539 | 1601 | 3.653141 | 58.48678741 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 797 | 0 | NTclustered | gi|339247610|ref|XM_003375391.1| | 6334 | g476 | i0 | 75.828 | 1.02810743285447 | 1601 | 364 | 99 | 14 | 8 | 1600 | 4313 | 2728 | Trichinella spiralis putative myosin head (Tsp_08431) mRNA, complete cds | blastn | 1646 | 797 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 23819779 | 23819779 | PRJNA891846_P_NODE_6759_length_561_cov_3.807377_g6547_i0 | PRJNA891846 | 6759 | 561 | 3.807377 | 21.35938497 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 977 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g6547 | i0 | 98.05 | 5.86096256684492 | 564 | 8 | 100 | 1 | 1 | 561 | 4873 | 4310 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 3288 | 977 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 25092665 | 25092665 | PRJNA891846_P_NODE_11260_length_447_cov_3.933155_g11043_i0 | PRJNA891846 | 11260 | 447 | 3.933155 | 17.58120285 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 150 | 1.4899999999999998e-31 | NTclustered | gi|1938390596|gb|MW302146.1| | 6334 | g11043 | i0 | 90.351 | 23.7404921700224 | 114 | 11 | 26 | 0 | 1 | 114 | 6352 | 6239 | 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 | 10612 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 25092940 | 25092940 | PRJNA891846_P_NODE_22400_length_322_cov_1.714859_g22181_i0 | PRJNA891846 | 22400 | 322 | 1.714859 | 5.52184598 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 230 | 1.3e-55 | NTclustered | gi|339249266|ref|XM_003373573.1| | 6334 | g22181 | i0 | 80.263 | 2.22360248447205 | 304 | 60 | 94 | 0 | 7 | 310 | 304 | 1 | Trichinella spiralis zinc finger protein (Tsp_08212) mRNA, complete cds | blastn | 716 | 230 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis |
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);;