contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA792582" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2052836 | 2052836 | PRJNA792582_P_NODE_31922_length_306_cov_1.725322_g31108_i0 | PRJNA792582 | 31922 | 306 | 1.725322 | 5.27948532 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 67.6 | 1.02e-6 | NTclustered | gi|339244456|ref|XM_003378106.1| | 6334 | g31108 | i0 | 90.566 | 0.173202614379085 | 53 | 2 | 17 | 3 | 250 | 301 | 794 | 844 | Trichinella spiralis ribosome production factor 1 (Tsp_02353) mRNA, complete cds | blastn | 53 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 2053074 | 2053074 | PRJNA792582_P_NODE_5442_length_707_cov_21.668770_g4703_i0 | PRJNA792582 | 5442 | 707 | 21.66877 | 153.1982039 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1245 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g4703 | i0 | 98.446 | 2.32673267326733 | 708 | 10 | 100 | 1 | 1 | 707 | 7922 | 7215 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 1645 | 1245 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 3328395 | 3328395 | PRJNA792582_P_NODE_7263_length_621_cov_4.100365_g6477_i0 | PRJNA792582 | 7263 | 621 | 4.100365 | 25.46326665 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1051 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g6477 | i0 | 97.258 | 2.19806763285024 | 620 | 17 | 99 | 0 | 2 | 621 | 11439 | 10820 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 1365 | 1051 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 4605555 | 4605555 | PRJNA792582_P_NODE_5744_length_690_cov_4.016207_g4990_i0 | PRJNA792582 | 5744 | 690 | 4.016207 | 27.7118283 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 564 | 7.15e-156 | NTclustered | gi|339254111|ref|XM_003372231.1| | 6334 | g4990 | i0 | 81.53 | 89.9608695652174 | 693 | 120 | 99 | 7 | 1 | 689 | 337 | 1025 | Trichinella spiralis moesin/ezrin/radixin protein (Tsp_10541) mRNA, complete cds | blastn | 62073 | 564 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 5880745 | 5880745 | PRJNA792582_P_NODE_725_length_1666_cov_297.755807_g497_i0 | PRJNA792582 | 725 | 1666 | 297.755807 | 4960.61174462 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 765 | 0 | NTclustered | gi|1070586637|gb|KU987805.1| | 1904821 | g497 | i0 | 99.524 | 23.0228091236495 | 420 | 2 | 25 | 0 | 1244 | 1663 | 1 | 420 | Pseudocapillaria tomentosa 18S ribosomal RNA gene, partial sequence | blastn | 38356 | 765 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 5880751 | 5880751 | PRJNA792582_P_NODE_8585_length_576_cov_5.654076_g7789_i0 | PRJNA792582 | 8585 | 576 | 5.654076 | 32.56747776 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1064 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g7789 | i0 | 100 | 16.3784722222222 | 576 | 0 | 100 | 0 | 1 | 576 | 2477 | 1902 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 9434 | 1064 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 7155193 | 7155193 | PRJNA792582_P_NODE_18766_length_397_cov_2.324074_g17952_i0 | PRJNA792582 | 18766 | 397 | 2.324074 | 9.22657378 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 682 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g17952 | i0 | 97.727 | 39.0352644836272 | 396 | 9 | 99 | 0 | 2 | 397 | 1233 | 838 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 15497 | 682 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 7155313 | 7155313 | PRJNA792582_P_NODE_32886_length_301_cov_1.052632_g32072_i0 | PRJNA792582 | 32886 | 301 | 1.052632 | 3.16842232 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 231 | 3.35e-56 | NTclustered | gi|339242972|ref|XM_003377364.1| | 6334 | g32072 | i0 | 80.795 | 4.91694352159468 | 302 | 52 | 100 | 4 | 1 | 301 | 3320 | 3024 | Trichinella spiralis ATP-dependent RNA helicase DHX8 (Tsp_01590) mRNA, complete cds | blastn | 1480 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 8429997 | 8429997 | PRJNA792582_P_NODE_2767_length_967_cov_8.189038_g2198_i0 | PRJNA792582 | 2767 | 967 | 8.189038 | 79.18799746 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1676 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g2198 | i0 | 98.526 | 1.28438469493278 | 950 | 12 | 98 | 2 | 1 | 950 | 8024 | 8971 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 1242 | 1676 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 12256517 | 12256517 | PRJNA792582_P_NODE_34930_length_291_cov_1.944954_g34116_i0 | PRJNA792582 | 34930 | 291 | 1.944954 | 5.65981614 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 248 | 3.2e-61 | NTclustered | gi|339233103|ref|XM_003381621.1| | 6334 | g34116 | i0 | 83.65 | 64.4845360824742 | 263 | 43 | 90 | 0 | 29 | 291 | 795 | 533 | Trichinella spiralis syntaxin-1A (Tsp_07354) mRNA, complete cds | blastn | 18765 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 14805373 | 14805373 | PRJNA792582_P_NODE_18532_length_399_cov_7.407975_g17718_i0 | PRJNA792582 | 18532 | 399 | 7.407975 | 29.55782025 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 726 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g17718 | i0 | 99.499 | 40.5664160401003 | 399 | 2 | 100 | 0 | 1 | 399 | 2561 | 2959 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 16186 | 726 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 14805428 | 14805428 | PRJNA792582_P_NODE_26552_length_335_cov_1.652672_g25738_i0 | PRJNA792582 | 26552 | 335 | 1.652672 | 5.5364512 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 130 | 1.4199999999999999e-25 | NTclustered | gi|339247788|ref|XM_003375480.1| | 6334 | g25738 | i0 | 81.935 | 0.91044776119403 | 155 | 26 | 46 | 2 | 1 | 154 | 3362 | 3515 | Trichinella spiralis putative IPT/TIG domain protein (Tsp_08514) mRNA, partial cds | blastn | 305 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 14805819 | 14805819 | PRJNA792582_P_NODE_8672_length_574_cov_1.616766_g7876_i0 | PRJNA792582 | 8672 | 574 | 1.616766 | 9.28023684 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 989 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g7876 | i0 | 97.735 | 5.86062717770035 | 574 | 13 | 100 | 0 | 1 | 574 | 12805 | 12232 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 3364 | 989 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 16079315 | 16079315 | PRJNA792582_P_NODE_20013_length_384_cov_18.713826_g19199_i0 | PRJNA792582 | 20013 | 384 | 18.713826 | 71.86109184 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 710 | 0 | NTclustered | gi|1070586637|gb|KU987805.1| | 1904821 | g19199 | i0 | 100 | 95.140625 | 384 | 0 | 100 | 0 | 1 | 384 | 566 | 949 | Pseudocapillaria tomentosa 18S ribosomal RNA gene, partial sequence | blastn | 36534 | 710 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 16079339 | 16079339 | PRJNA792582_P_NODE_23753_length_354_cov_0.804270_g22939_i0 | PRJNA792582 | 23753 | 354 | 0.80427 | 2.8471158 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 62.1 | 5.56e-5 | NTclustered | gi|339244456|ref|XM_003378106.1| | 6334 | g22939 | i0 | 91.304 | 0.129943502824859 | 46 | 3 | 13 | 1 | 193 | 237 | 799 | 844 | Trichinella spiralis ribosome production factor 1 (Tsp_02353) mRNA, complete cds | blastn | 46 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 17355154 | 17355154 | PRJNA792582_P_NODE_27734_length_328_cov_1.207843_g26920_i0 | PRJNA792582 | 27734 | 328 | 1.207843 | 3.96172504 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 287 | 7.77e-73 | NTclustered | gi|339248356|ref|XM_003373118.1| | 6334 | g26920 | i0 | 82.965 | 0.966463414634146 | 317 | 54 | 97 | 0 | 2 | 318 | 393 | 77 | Trichinella spiralis neuronal calcium sensor 2 (Tsp_10012) mRNA, complete cds | blastn | 317 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 18628383 | 18628383 | PRJNA792582_P_NODE_215_length_2573_cov_190.748800_g132_i0 | PRJNA792582 | 215 | 2573 | 190.7488 | 4907.966624 | Aonchotheca paranalis | 2025203 | Nematoda | Nematoda | 508 | 1.32e-138 | NTclustered | gi|1279640587|gb|MF621021.1| | 2025203 | g132 | i0 | 90.981 | 4.76525456665371 | 377 | 34 | 21 | 0 | 2197 | 2573 | 3532 | 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 | 12261 | 508 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Aonchotheca | Aonchotheca paranalis | |
| 22454533 | 22454533 | PRJNA792582_P_NODE_918_length_1530_cov_41.117364_g648_i0 | PRJNA792582 | 918 | 1530 | 41.117364 | 629.0956692 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 2676 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g648 | i0 | 98.235 | 43.3522875816993 | 1530 | 27 | 100 | 0 | 1 | 1530 | 5656 | 7185 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 66329 | 2676 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 23730147 | 23730147 | PRJNA792582_P_NODE_8999_length_564_cov_5.606925_g8201_i0 | PRJNA792582 | 8999 | 564 | 5.606925 | 31.623057 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 920 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g8201 | i0 | 96.099 | 28.8705673758865 | 564 | 22 | 100 | 0 | 1 | 564 | 4878 | 4315 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 16283 | 920 | 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);;