contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA897077" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 873716 | 873716 | PRJNA897077_P_NODE_301_length_1536_cov_18.421053_g265_i0 | PRJNA897077 | 301 | 1536 | 18.421053 | 282.94737408 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 2682 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g265 | i0 | 98.177 | 47.3678385416667 | 1536 | 28 | 100 | 0 | 1 | 1536 | 7181 | 5646 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 72757 | 2682 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 2148884 | 2148884 | PRJNA897077_P_NODE_1502_length_778_cov_2.642553_g1391_i0 | PRJNA897077 | 1502 | 778 | 2.642553 | 20.55906234 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 353 | 1.91e-92 | NTclustered | gi|339252409|ref|XM_003371380.1| | 6334 | g1391 | i0 | 80.519 | 2.93573264781491 | 462 | 88 | 59 | 2 | 232 | 692 | 461 | 1 | Trichinella spiralis troponin C, isoform 2 (Tsp_11636) mRNA, complete cds | blastn | 2284 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 3424474 | 3424474 | PRJNA897077_P_NODE_2883_length_567_cov_9.321862_g2756_i0 | PRJNA897077 | 2883 | 567 | 9.321862 | 52.85495754 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 948 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g2756 | i0 | 96.825 | 30.8712522045855 | 567 | 18 | 100 | 0 | 1 | 567 | 4920 | 4354 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 17504 | 948 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 7251854 | 7251854 | PRJNA897077_P_NODE_46_length_2673_cov_2.703846_g38_i0 | PRJNA897077 | 46 | 2673 | 2.703846 | 72.27380358 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 697 | 0 | NTclustered | gi|339247610|ref|XM_003375391.1| | 6334 | g38 | i0 | 75.251 | 3.28133183688739 | 1495 | 354 | 76 | 14 | 1180 | 2666 | 2551 | 4037 | Trichinella spiralis putative myosin head (Tsp_08431) mRNA, complete cds | blastn | 8771 | 697 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 7251916 | 7251916 | PRJNA897077_P_NODE_8186_length_342_cov_1.486989_g8059_i0 | PRJNA897077 | 8186 | 342 | 1.486989 | 5.08550238 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 604 | 1.979999999999999e-168 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g8059 | i0 | 98.538 | 9.13157894736842 | 342 | 5 | 100 | 0 | 1 | 342 | 12621 | 12280 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 3123 | 604 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 8526337 | 8526337 | PRJNA897077_P_NODE_12687_length_278_cov_2.278049_g12560_i0 | PRJNA897077 | 12687 | 278 | 2.278049 | 6.33297622 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 496 | 9.84e-136 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g12560 | i0 | 99.27 | 1.57553956834532 | 274 | 2 | 99 | 0 | 1 | 274 | 8437 | 8710 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 438 | 496 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 9801330 | 9801330 | PRJNA897077_P_NODE_10368_length_306_cov_4.828326_g10241_i0 | PRJNA897077 | 10368 | 306 | 4.828326 | 14.77467756 | Pearsonema plica | 2025202 | Nematoda | Nematoda | 243 | 1.58e-59 | NTclustered | gi|585724675|gb|KF836607.1| | 2025202 | g10241 | i0 | 92.398 | 24.6732026143791 | 171 | 11 | 56 | 2 | 97 | 266 | 1997 | 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 | 7550 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pearsonema | Pearsonema plica | |
| 9801443 | 9801443 | PRJNA897077_P_NODE_16188_length_251_cov_0.876404_g16061_i0 | PRJNA897077 | 16188 | 251 | 0.876404 | 2.19977404 | Meloidogyne incognita | 6306 | Nematoda | Nematoda | 422 | 1.4999999999999998e-113 | NTclustered | gi|1235720138|gb|MF510388.1| | 6306 | g16061 | i0 | 97.189 | 4.65737051792829 | 249 | 7 | 99 | 0 | 3 | 251 | 495 | 247 | Meloidogyne incognita fatty acid and retinol binding protein-1 mRNA, complete cds | blastn | 1169 | 422 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne incognita | |
| 9801535 | 9801535 | PRJNA897077_P_NODE_2708_length_583_cov_1.476471_g2581_i0 | PRJNA897077 | 2708 | 583 | 1.476471 | 8.60782593 | Pearsonema plica | 2025202 | Nematoda | Nematoda | 95.3 | 9.44e-15 | NTclustered | gi|585724675|gb|KF836607.1| | 2025202 | g2581 | i0 | 93.75 | 9.07547169811321 | 64 | 3 | 11 | 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 | |
| 13627445 | 13627445 | PRJNA897077_P_NODE_2331_length_627_cov_14.792419_g2204_i0 | PRJNA897077 | 2331 | 627 | 14.792419 | 92.74846713 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1118 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g2204 | i0 | 98.882 | 2.49282296650718 | 626 | 7 | 99 | 0 | 2 | 627 | 7819 | 7194 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 1563 | 1118 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 13627486 | 13627486 | PRJNA897077_P_NODE_471_length_1283_cov_3.707438_g416_i0 | PRJNA897077 | 471 | 1283 | 3.707438 | 47.56642954 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 715 | 0 | NTclustered | gi|339254855|ref|XM_003372603.1| | 6334 | g416 | i0 | 82.045 | 16.784099766173 | 841 | 149 | 65 | 2 | 129 | 968 | 1 | 840 | Trichinella spiralis tropomyosin (Tsp_11392) mRNA, complete cds | blastn | 21534 | 715 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 13627559 | 13627559 | PRJNA897077_P_NODE_891_length_985_cov_4.403509_g797_i0 | PRJNA897077 | 891 | 985 | 4.403509 | 43.37456365 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1711 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g797 | i0 | 98.067 | 50.0162436548223 | 983 | 19 | 99 | 0 | 3 | 985 | 482 | 1464 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 49266 | 1711 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 16176195 | 16176195 | PRJNA897077_P_NODE_1013_length_925_cov_50.951878_g915_i0 | PRJNA897077 | 1013 | 925 | 50.951878 | 471.3048715 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1650 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g915 | i0 | 99.778 | 49.6421621621622 | 899 | 2 | 97 | 0 | 1 | 899 | 2379 | 3277 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 45919 | 1650 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 17451705 | 17451705 | PRJNA897077_P_NODE_12134_length_284_cov_6.753555_g12007_i0 | PRJNA897077 | 12134 | 284 | 6.753555 | 19.1800962 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 503 | 6.02e-138 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g12007 | i0 | 98.592 | 1 | 284 | 4 | 100 | 0 | 1 | 284 | 8042 | 8325 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 284 | 503 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 17451854 | 17451854 | PRJNA897077_P_NODE_2034_length_670_cov_8.867672_g1908_i0 | PRJNA897077 | 2034 | 670 | 8.867672 | 59.4134024 | Capillaria sp. ALS-2019 | 2651741 | Nematoda | Nematoda | 185 | 6.31e-42 | NTclustered | gi|1811126246|gb|MN526255.1| | 2651741 | g1908 | i0 | 91.791 | 14.710447761194 | 134 | 10 | 20 | 1 | 1 | 133 | 210 | 343 | Capillaria sp. ALS-2019 large subunit ribosomal RNA gene, partial sequence | blastn | 9856 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Capillaria | Capillaria sp. ALS-2019 | |
| 17451977 | 17451977 | PRJNA897077_P_NODE_7974_length_346_cov_2.285714_g7847_i0 | PRJNA897077 | 7974 | 346 | 2.285714 | 7.90857044 | Pristionchus sp. 13 RS5231 | 452807 | Nematoda | Nematoda | 104 | 8.91e-18 | NTclustered | gi|150982219|gb|EF634698.1| | 452807 | g7847 | i0 | 82.645 | 0.780346820809249 | 121 | 17 | 34 | 3 | 197 | 315 | 119 | 1 | Pristionchus sp. 13 RS5231 large subunit ribosomal protein 29 (rpl-29) mRNA, complete cds | blastn | 270 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 13 RS5231 | |
| 18725017 | 18725017 | PRJNA897077_P_NODE_1355_length_816_cov_1.244953_g1248_i0 | PRJNA897077 | 1355 | 816 | 1.244953 | 10.15881648 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 532 | 2.3999999999999993e-146 | NTclustered | gi|339233103|ref|XM_003381621.1| | 6334 | g1248 | i0 | 80.826 | 56.8075980392157 | 678 | 130 | 83 | 0 | 137 | 814 | 795 | 118 | Trichinella spiralis syntaxin-1A (Tsp_07354) mRNA, complete cds | blastn | 46355 | 532 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 18725229 | 18725229 | PRJNA897077_P_NODE_8455_length_337_cov_17.295455_g8328_i0 | PRJNA897077 | 8455 | 337 | 17.295455 | 58.28568335 | Aonchotheca paranalis | 2025203 | Nematoda | Nematoda | 453 | 7.46e-123 | NTclustered | gi|1279640587|gb|MF621021.1| | 2025203 | g8328 | i0 | 91.045 | 31.9436201780415 | 335 | 30 | 99 | 0 | 1 | 335 | 3889 | 3555 | 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 | 10765 | 453 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Aonchotheca | Aonchotheca paranalis | |
| 18725238 | 18725238 | PRJNA897077_P_NODE_875_length_996_cov_1.737811_g782_i0 | PRJNA897077 | 875 | 996 | 1.737811 | 17.30859756 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 579 | 3.749999999999999e-160 | NTclustered | gi|339254111|ref|XM_003372231.1| | 6334 | g782 | i0 | 81.612 | 70.8112449799197 | 707 | 122 | 71 | 7 | 294 | 996 | 1031 | 329 | Trichinella spiralis moesin/ezrin/radixin protein (Tsp_10541) mRNA, complete cds | blastn | 70528 | 579 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 21275450 | 21275450 | PRJNA897077_P_NODE_11197_length_295_cov_3.563063_g11070_i0 | PRJNA897077 | 11197 | 295 | 3.563063 | 10.51103585 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 545 | 1.03e-150 | NTclustered | gi|1070586637|gb|KU987805.1| | 1904821 | g11070 | i0 | 100 | 98.7016949152542 | 295 | 0 | 100 | 0 | 1 | 295 | 575 | 869 | Pseudocapillaria tomentosa 18S ribosomal RNA gene, partial sequence | blastn | 29117 | 545 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 21275669 | 21275669 | PRJNA897077_P_NODE_4757_length_443_cov_11.627027_g4630_i0 | PRJNA897077 | 4757 | 443 | 11.627027 | 51.50772961 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 158 | 8.83e-34 | NTclustered | gi|1938390596|gb|MW302146.1| | 6334 | g4630 | i0 | 90.678 | 24.8600451467269 | 118 | 11 | 27 | 0 | 1 | 118 | 6356 | 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 | 11013 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 22550488 | 22550488 | PRJNA897077_P_NODE_19578_length_243_cov_0.917647_g19451_i0 | PRJNA897077 | 19578 | 243 | 0.917647 | 2.22988221 | Trichuris muris | 70415 | Nematoda | Nematoda | 219 | 2.0399999999999998e-52 | NTclustered | gi|806642205|gb|KP719115.1| | 70415 | g19451 | i0 | 85.047 | 3.52263374485597 | 214 | 32 | 88 | 0 | 1 | 214 | 717 | 504 | Trichuris muris clone slo-1.2c Slo-1 mRNA, complete cds, alternatively spliced | blastn | 856 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris muris | |
| 22550546 | 22550546 | PRJNA897077_P_NODE_4858_length_439_cov_8.177596_g4731_i0 | PRJNA897077 | 4858 | 439 | 8.177596 | 35.89964644 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 765 | 0 | NTclustered | gi|1070586637|gb|KU987805.1| | 1904821 | g4731 | i0 | 99.524 | 87.371298405467 | 420 | 2 | 96 | 0 | 2 | 421 | 420 | 1 | Pseudocapillaria tomentosa 18S ribosomal RNA gene, partial sequence | blastn | 38356 | 765 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 23825715 | 23825715 | PRJNA897077_P_NODE_139_length_1953_cov_2.737234_g121_i0 | PRJNA897077 | 139 | 1953 | 2.737234 | 53.45818002 | Ancylostoma caninum | 29170 | Nematoda | Nematoda | 669 | 0 | NTclustered | gi|86160923|gb|DQ358106.1| | 29170 | g121 | i0 | 74.357 | 0.836661546338966 | 1634 | 389 | 83 | 27 | 335 | 1953 | 2708 | 1090 | Ancylostoma caninum paramyosin mRNA, complete cds | blastn | 1634 | 669 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma caninum | |
| 23825900 | 23825900 | PRJNA897077_P_NODE_6679_length_376_cov_10.554455_g6552_i0 | PRJNA897077 | 6679 | 376 | 10.554455 | 39.6847508 | Capillaria sp. ALS-2019 | 2651741 | Nematoda | Nematoda | 268 | 3.27e-67 | NTclustered | gi|1811126246|gb|MN526255.1| | 2651741 | g6552 | i0 | 99.324 | 39.7340425531915 | 148 | 1 | 57 | 0 | 229 | 376 | 1044 | 1191 | Capillaria sp. ALS-2019 large subunit ribosomal RNA gene, partial sequence | blastn | 14940 | 268 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Capillaria | Capillaria sp. ALS-2019 |
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);;