contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA453111" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1092868 | 1092868 | PRJNA453111_P_NODE_5601_length_342_cov_0.825279_g5509_i0 | PRJNA453111 | 5601 | 342 | 0.825279 | 2.82245418 | Capillaria | 119095 | Nematoda | Nematoda | 209 | 1.81e-49 | NTclustered | gi|661349435|gb|KJ579531.1| | 1503237 | g5509 | i0 | 94.203 | 32.0672514619883 | 138 | 7 | 40 | 1 | 205 | 341 | 755 | 892 | Capillaria sp. 109CSP_C 28S ribosomal RNA gene, partial sequence | blastn | 10967 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Capillaria | Capillaria sp. 109CSP_C | |
| 2992111 | 2992111 | PRJNA453111_P_NODE_6723_length_313_cov_1.012500_g6631_i0 | PRJNA453111 | 6723 | 313 | 1.0125 | 3.169125 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 579 | 1.0899999999999999e-160 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g6631 | i0 | 100 | 10.1789137380192 | 313 | 0 | 100 | 0 | 1 | 313 | 1138 | 1450 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 3186 | 579 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 5545138 | 5545138 | PRJNA453111_P_NODE_1505_length_672_cov_12.893155_g1417_i0 | PRJNA453111 | 1505 | 672 | 12.893155 | 86.6420016 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1242 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g1417 | i0 | 100 | 67.4464285714286 | 672 | 0 | 100 | 0 | 1 | 672 | 2600 | 3271 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 45324 | 1242 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 6819134 | 6819134 | PRJNA453111_P_NODE_506_length_1120_cov_1.893028_g457_i0 | PRJNA453111 | 506 | 1120 | 1.893028 | 21.2019136 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 656 | 0 | NTclustered | gi|339254111|ref|XM_003372231.1| | 6334 | g457 | i0 | 81.681 | 74.4517857142857 | 797 | 138 | 71 | 7 | 1 | 793 | 239 | 1031 | Trichinella spiralis moesin/ezrin/radixin protein (Tsp_10541) mRNA, complete cds | blastn | 83386 | 656 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 9369292 | 9369292 | PRJNA453111_P_NODE_13228_length_240_cov_3.035928_g13136_i0 | PRJNA453111 | 13228 | 240 | 3.035928 | 7.2862272 | Aonchotheca paranalis | 2025203 | Nematoda | Nematoda | 231 | 2.58e-56 | NTclustered | gi|1279640587|gb|MF621021.1| | 2025203 | g13136 | i0 | 93.548 | 31.1375 | 155 | 10 | 65 | 0 | 84 | 238 | 2689 | 2843 | 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 | 7473 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Aonchotheca | Aonchotheca paranalis | |
| 11920192 | 11920192 | PRJNA453111_P_NODE_1830_length_609_cov_4.208955_g1739_i0 | PRJNA453111 | 1830 | 609 | 4.208955 | 25.63253595 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1109 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g1739 | i0 | 99.507 | 39.5385878489327 | 609 | 3 | 100 | 0 | 1 | 609 | 1096 | 488 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 24079 | 1109 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 11920198 | 11920198 | PRJNA453111_P_NODE_2470_length_523_cov_5.517778_g2378_i0 | PRJNA453111 | 2470 | 523 | 5.517778 | 28.85797894 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 961 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g2378 | i0 | 99.809 | 2.48757170172084 | 523 | 1 | 100 | 0 | 1 | 523 | 7850 | 7328 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 1301 | 961 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 13195030 | 13195030 | PRJNA453111_P_NODE_2111_length_565_cov_2.595528_g2019_i0 | PRJNA453111 | 2111 | 565 | 2.595528 | 14.6647332 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1033 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g2019 | i0 | 99.646 | 5.38230088495575 | 565 | 2 | 100 | 0 | 1 | 565 | 4309 | 4873 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 3041 | 1033 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 14470049 | 14470049 | PRJNA453111_P_NODE_2372_length_533_cov_1.528261_g2280_i0 | PRJNA453111 | 2372 | 533 | 1.528261 | 8.14563113 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 979 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g2280 | i0 | 99.812 | 1.30769230769231 | 533 | 1 | 100 | 0 | 1 | 533 | 8877 | 8345 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 697 | 979 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 15744069 | 15744069 | PRJNA453111_P_NODE_3733_length_420_cov_1.095101_g3641_i0 | PRJNA453111 | 3733 | 420 | 1.095101 | 4.5994242 | Ancylostoma caninum | 29170 | Nematoda | Nematoda | 231 | 4.8399999999999995e-56 | NTclustered | gi|86160923|gb|DQ358106.1| | 29170 | g3641 | i0 | 78.592 | 0.845238095238095 | 355 | 72 | 84 | 4 | 53 | 405 | 1369 | 1721 | Ancylostoma caninum paramyosin mRNA, complete cds | blastn | 355 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma caninum | |
| 15744101 | 15744101 | PRJNA453111_P_NODE_7333_length_299_cov_1.362832_g7241_i0 | PRJNA453111 | 7333 | 299 | 1.362832 | 4.07486768 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 547 | 2.9099999999999987e-151 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g7241 | i0 | 99.666 | 1 | 299 | 1 | 100 | 0 | 1 | 299 | 11530 | 11232 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 299 | 547 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 17018729 | 17018729 | PRJNA453111_P_NODE_234_length_1518_cov_6.740484_g204_i0 | PRJNA453111 | 234 | 1518 | 6.740484 | 102.32054712 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 2793 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g204 | i0 | 99.868 | 55.3965744400527 | 1518 | 2 | 100 | 0 | 1 | 1518 | 5656 | 7173 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 84092 | 2793 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 22117948 | 22117948 | PRJNA453111_P_NODE_3498_length_435_cov_1.055249_g3406_i0 | PRJNA453111 | 3498 | 435 | 1.055249 | 4.59033315 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 281 | 4.92e-71 | NTclustered | gi|339249266|ref|XM_003373573.1| | 6334 | g3406 | i0 | 80.78 | 5.15172413793103 | 359 | 69 | 83 | 0 | 46 | 404 | 1 | 359 | Trichinella spiralis zinc finger protein (Tsp_08212) mRNA, complete cds | blastn | 2241 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 23393627 | 23393627 | PRJNA453111_P_NODE_1719_length_627_cov_2.140794_g1630_i0 | PRJNA453111 | 1719 | 627 | 2.140794 | 13.42277838 | Capillaria sp. ALS-2019 | 2651741 | Nematoda | Nematoda | 152 | 5.96e-32 | NTclustered | gi|1811126246|gb|MN526255.1| | 2651741 | g1630 | i0 | 91.15 | 10.0079744816587 | 113 | 9 | 18 | 1 | 516 | 627 | 343 | 231 | Capillaria sp. ALS-2019 large subunit ribosomal RNA gene, partial sequence | blastn | 6275 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Capillaria | Capillaria sp. ALS-2019 | |
| 24667577 | 24667577 | PRJNA453111_P_NODE_12140_length_244_cov_0.900585_g12048_i0 | PRJNA453111 | 12140 | 244 | 0.900585 | 2.1974274 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 154 | 5.87e-33 | NTclustered | gi|254935130|gb|FJ907417.1| | 6334 | g12048 | i0 | 79.149 | 0.963114754098361 | 235 | 39 | 94 | 8 | 5 | 234 | 442 | 213 | Trichinella spiralis CDC-42 mRNA, complete cds | blastn | 235 | 154 | 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);;