contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA738523" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 719556 | 719556 | PRJNA738523_P_NODE_541_length_814_cov_69.141700_g484_i0 | PRJNA738523 | 541 | 814 | 69.1417 | 562.813438 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1483 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g484 | i0 | 99.753 | 56.0307125307125 | 809 | 2 | 99 | 0 | 1 | 809 | 2469 | 3277 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 45609 | 1483 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 719559 | 719559 | PRJNA738523_P_NODE_5821_length_301_cov_1.039474_g5750_i0 | PRJNA738523 | 5821 | 301 | 1.039474 | 3.12881674 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 213 | 1.21e-50 | NTclustered | gi|339246888|ref|XM_003375030.1| | 6334 | g5750 | i0 | 87.234 | 0.624584717607973 | 188 | 23 | 62 | 1 | 1 | 187 | 710 | 897 | Trichinella spiralis putative LIM domain protein (Tsp_04264) mRNA, complete cds | blastn | 188 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 719560 | 719560 | PRJNA738523_P_NODE_601_length_786_cov_2.692847_g542_i0 | PRJNA738523 | 601 | 786 | 2.692847 | 21.16577742 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1408 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g542 | i0 | 98.982 | 1.37150127226463 | 786 | 8 | 100 | 0 | 1 | 786 | 8053 | 8838 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 1078 | 1408 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 1995600 | 1995600 | PRJNA738523_P_NODE_3162_length_377_cov_1.013158_g3091_i0 | PRJNA738523 | 3162 | 377 | 1.013158 | 3.81960566 | Trichinella pseudospiralis | 6337 | Nematoda | Nematoda | 287 | 9.04e-73 | NTclustered | gi|17646750|gb|AF453521.1|AF453521 | 6337 | g3091 | i0 | 81.556 | 5.39787798408488 | 347 | 64 | 92 | 0 | 31 | 377 | 1 | 347 | Trichinella pseudospiralis tropomyosin mRNA, complete cds | blastn | 2035 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella pseudospiralis | |
| 3270827 | 3270827 | PRJNA738523_P_NODE_103_length_1532_cov_10.379027_g84_i0 | PRJNA738523 | 103 | 1532 | 10.379027 | 159.00669364 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 2663 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g84 | i0 | 98.042 | 61.3087467362924 | 1532 | 30 | 100 | 0 | 1 | 1532 | 5654 | 7185 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 93925 | 2663 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 4548034 | 4548034 | PRJNA738523_P_NODE_16544_length_229_cov_3.583333_g16473_i0 | PRJNA738523 | 16544 | 229 | 3.583333 | 8.20583257 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 231 | 2.44e-56 | NTclustered | gi|339253539|ref|XM_003371945.1| | 6334 | g16473 | i0 | 85.022 | 0.991266375545852 | 227 | 34 | 99 | 0 | 3 | 229 | 2159 | 1933 | Trichinella spiralis 6-phosphofructokinase (Tsp_05639) mRNA, complete cds | blastn | 227 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 5823139 | 5823139 | PRJNA738523_P_NODE_2525_length_413_cov_1.214706_g2454_i0 | PRJNA738523 | 2525 | 413 | 1.214706 | 5.01673578 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 202 | 3.72e-47 | NTclustered | gi|690018840|emb|LM526136.1| | 174720 | g2454 | i0 | 79.649 | 6.41646489104116 | 285 | 54 | 69 | 4 | 49 | 331 | 7759 | 8041 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000493 | blastn | 2650 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 7098253 | 7098253 | PRJNA738523_P_NODE_4666_length_327_cov_2.354331_g4595_i0 | PRJNA738523 | 4666 | 327 | 2.354331 | 7.69866237 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 604 | 1.8799999999999993e-168 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g4595 | i0 | 100 | 1.25382262996942 | 327 | 0 | 100 | 0 | 1 | 327 | 2253 | 1927 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 410 | 604 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 7098258 | 7098258 | PRJNA738523_P_NODE_5346_length_311_cov_0.970588_g5275_i0 | PRJNA738523 | 5346 | 311 | 0.970588 | 3.01852868 | Ancylostoma caninum | 29170 | Nematoda | Nematoda | 154 | 7.75e-33 | NTclustered | gi|86160923|gb|DQ358106.1| | 29170 | g5275 | i0 | 77.481 | 0.842443729903537 | 262 | 55 | 84 | 4 | 6 | 265 | 1628 | 1369 | Ancylostoma caninum paramyosin mRNA, complete cds | blastn | 262 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma caninum | |
| 8372806 | 8372806 | PRJNA738523_P_NODE_1407_length_536_cov_3.939525_g1337_i0 | PRJNA738523 | 1407 | 536 | 3.939525 | 21.115854 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 935 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g1337 | i0 | 98.138 | 54.8059701492537 | 537 | 9 | 100 | 1 | 1 | 536 | 984 | 448 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 29376 | 935 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 8372853 | 8372853 | PRJNA738523_P_NODE_6047_length_296_cov_1.381166_g5976_i0 | PRJNA738523 | 6047 | 296 | 1.381166 | 4.08825136 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 508 | 1.36e-139 | NTclustered | gi|1070586637|gb|KU987805.1| | 1904821 | g5976 | i0 | 99.288 | 82.8108108108108 | 281 | 2 | 95 | 0 | 16 | 296 | 1 | 281 | Pseudocapillaria tomentosa 18S ribosomal RNA gene, partial sequence | blastn | 24512 | 508 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 8372855 | 8372855 | PRJNA738523_P_NODE_6307_length_291_cov_2.119266_g6236_i0 | PRJNA738523 | 6307 | 291 | 2.119266 | 6.16706406 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 193 | 1.52e-44 | NTclustered | gi|1376138619|ref|XM_024649534.1| | 34506 | g6236 | i0 | 82.096 | 1.38487972508591 | 229 | 37 | 78 | 4 | 59 | 285 | 1376 | 1150 | Strongyloides ratti Transitional endoplasmic reticulum ATPase (SRAE_1000245600), partial mRNA | blastn | 403 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 9647977 | 9647977 | PRJNA738523_P_NODE_3548_length_360_cov_3.045296_g3477_i0 | PRJNA738523 | 3548 | 360 | 3.045296 | 10.9630656 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 638 | 2.06e-178 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g3477 | i0 | 98.611 | 6.53333333333333 | 360 | 5 | 100 | 0 | 1 | 360 | 12588 | 12229 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 2352 | 638 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 12198913 | 12198913 | PRJNA738523_P_NODE_15950_length_241_cov_0.916667_g15879_i0 | PRJNA738523 | 15950 | 241 | 0.916667 | 2.20916747 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 204 | 5.66e-48 | NTclustered | gi|1376157149|ref|XM_024646005.1| | 34506 | g15879 | i0 | 82.008 | 34.7634854771784 | 239 | 43 | 99 | 0 | 3 | 241 | 800 | 1038 | Strongyloides ratti 26S protease regulatory subunit 4 (SRAE_0000015400), partial mRNA | blastn | 8378 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 12198948 | 12198948 | PRJNA738523_P_NODE_6510_length_289_cov_1.300926_g6439_i0 | PRJNA738523 | 6510 | 289 | 1.300926 | 3.75967614 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 484 | 2.2299999999999998e-132 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g6439 | i0 | 97.527 | 0.97923875432526 | 283 | 7 | 98 | 0 | 1 | 283 | 9417 | 9699 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 283 | 484 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 16022178 | 16022178 | PRJNA738523_P_NODE_793_length_691_cov_3.601942_g728_i0 | PRJNA738523 | 793 | 691 | 3.601942 | 24.88941922 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1171 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g728 | i0 | 97.25 | 2.18523878437048 | 691 | 19 | 100 | 0 | 1 | 691 | 11437 | 10747 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 1510 | 1171 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 17297608 | 17297608 | PRJNA738523_P_NODE_1594_length_508_cov_4.655172_g1524_i0 | PRJNA738523 | 1594 | 508 | 4.655172 | 23.64827376 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 883 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g1524 | i0 | 98.031 | 8.67125984251969 | 508 | 10 | 100 | 0 | 1 | 508 | 972 | 1479 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 4405 | 883 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 17297636 | 17297636 | PRJNA738523_P_NODE_574_length_798_cov_5.855172_g516_i0 | PRJNA738523 | 574 | 798 | 5.855172 | 46.72427256 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1345 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g516 | i0 | 97.114 | 24.5200501253133 | 797 | 23 | 99 | 0 | 1 | 797 | 4142 | 4938 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 19567 | 1345 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 21122124 | 21122124 | PRJNA738523_P_NODE_3597_length_359_cov_1.076923_g3526_i0 | PRJNA738523 | 3597 | 359 | 1.076923 | 3.86615357 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 608 | 1.609999999999999e-169 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g3526 | i0 | 97.214 | 1 | 359 | 10 | 100 | 0 | 1 | 359 | 9754 | 10112 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 359 | 608 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 21122155 | 21122155 | PRJNA738523_P_NODE_757_length_704_cov_8.068146_g693_i0 | PRJNA738523 | 757 | 704 | 8.068146 | 56.79974784 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 1240 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g693 | i0 | 98.44 | 2.33238636363636 | 705 | 10 | 100 | 1 | 1 | 704 | 7909 | 7205 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 1642 | 1240 | 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);;