contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA690124" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 669054 | 669054 | PRJNA690124_P_NODE_23361_length_338_cov_1.935849_g22995_i0 | PRJNA690124 | 23361 | 338 | 1.935849 | 6.54316962 | Ancylostoma caninum | 29170 | Nematoda | Nematoda | 326 | 1.6999999999999999e-84 | NTclustered | gi|199584093|tpg|BK006069.1| | 29170 | g22995 | i0 | 84.179 | 98.3254437869822 | 335 | 53 | 99 | 0 | 3 | 337 | 399 | 733 | TPA_inf: Ancylostoma caninum eukaryotic translation elongation factor 1A (eft-2) mRNA, partial cds | blastn | 33234 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma caninum | |
| 5772769 | 5772769 | PRJNA690124_P_NODE_29505_length_304_cov_2.116883_g29139_i0 | PRJNA690124 | 29505 | 304 | 2.116883 | 6.43532432 | Oscheius sp. JU1917 | 2879411 | Nematoda | Nematoda | 562 | 1.06e-155 | NTclustered | gi|2804588271|emb|OZ182419.1| | 2879411 | g29139 | i0 | 100 | 19.8618421052632 | 304 | 0 | 100 | 0 | 1 | 304 | 1329 | 1632 | Oscheius sp. JU1917 genome assembly, organelle: mitochondrion | blastn | 6038 | 562 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Oscheius | Oscheius sp. JU1917 | |
| 7047962 | 7047962 | PRJNA690124_P_NODE_37846_length_270_cov_1.583756_g37480_i0 | PRJNA690124 | 37846 | 270 | 1.583756 | 4.2761412 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 231 | 2.96e-56 | NTclustered | gi|1831509458|ref|NM_064556.7| | 6239 | g37480 | i0 | 85.022 | 9.01111111111111 | 227 | 34 | 84 | 0 | 1 | 227 | 4 | 230 | Caenorhabditis elegans Large ribosomal subunit protein eL43 (rpl-37A), partial mRNA | blastn | 2433 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 8322203 | 8322203 | PRJNA690124_P_NODE_24547_length_331_cov_1.209302_g24181_i0 | PRJNA690124 | 24547 | 331 | 1.209302 | 4.00278962 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 612 | 1.14e-170 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g24181 | i0 | 100 | 7.5226586102719 | 331 | 0 | 100 | 0 | 1 | 331 | 12267 | 12597 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 2490 | 612 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 8322734 | 8322734 | PRJNA690124_P_NODE_49667_length_247_cov_1.344828_g49301_i0 | PRJNA690124 | 49667 | 247 | 1.344828 | 3.32172516 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 455 | 1.4600000000000002e-123 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g49301 | i0 | 100 | 0.995951417004049 | 246 | 0 | 99 | 0 | 1 | 246 | 851 | 1096 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 246 | 455 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 8322746 | 8322746 | PRJNA690124_P_NODE_50047_length_247_cov_0.896552_g49681_i0 | PRJNA690124 | 50047 | 247 | 0.896552 | 2.21448344 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 451 | 1.88e-122 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g49681 | i0 | 99.595 | 1 | 247 | 1 | 100 | 0 | 1 | 247 | 4278 | 4524 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 247 | 451 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 9598255 | 9598255 | PRJNA690124_P_NODE_55188_length_243_cov_0.882353_g54822_i0 | PRJNA690124 | 55188 | 243 | 0.882353 | 2.14411779 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.022 | NTclustered | gi|1831506197|ref|NM_001026702.3| | 6239 | g54822 | i0 | 96.875 | 1.44855967078189 | 32 | 0 | 13 | 1 | 18 | 48 | 1632 | 1601 | Caenorhabditis elegans Phorbol ester/diacylglycerol-binding protein unc-13 (unc-13), partial mRNA | blastn | 352 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 10873101 | 10873101 | PRJNA690124_P_NODE_24209_length_333_cov_1.476923_g23843_i0 | PRJNA690124 | 24209 | 333 | 1.476923 | 4.91815359 | Panagrellus redivivus | 6233 | Nematoda | Nematoda | 616 | 8.87e-172 | NTclustered | gi|158821922|gb|EU195986.1| | 6233 | g23843 | i0 | 100 | 2.3033033033033 | 333 | 0 | 100 | 0 | 1 | 333 | 3154 | 3486 | Panagrellus redivivus strain PS1163 28S ribosomal RNA gene, partial sequence | blastn | 767 | 616 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Panagrellus | Panagrellus redivivus | |
| 13422953 | 13422953 | PRJNA690124_P_NODE_25011_length_328_cov_1.537255_g24645_i0 | PRJNA690124 | 25011 | 328 | 1.537255 | 5.0421964 | Pristionchus sp. 11 RS5228 | 452806 | Nematoda | Nematoda | 215 | 3.72e-51 | NTclustered | gi|150983329|gb|EF634753.1| | 452806 | g24645 | i0 | 81.181 | 4.30487804878049 | 271 | 47 | 82 | 4 | 7 | 275 | 281 | 13 | Pristionchus sp. 11 RS5228 large subunit ribosomal protein 32 (rpl-32) mRNA, partial cds | blastn | 1412 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 11 RS5228 | |
| 13423461 | 13423461 | PRJNA690124_P_NODE_48371_length_248_cov_1.782857_g48005_i0 | PRJNA690124 | 48371 | 248 | 1.782857 | 4.42148536 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 124 | 4.6899999999999996e-24 | NTclustered | gi|1938390596|gb|MW302146.1| | 6334 | g48005 | i0 | 89.691 | 37.1370967741936 | 97 | 10 | 39 | 0 | 146 | 242 | 6239 | 6335 | 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 | 9210 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 14698635 | 14698635 | PRJNA690124_P_NODE_53072_length_244_cov_1.649123_g52706_i0 | PRJNA690124 | 53072 | 244 | 1.649123 | 4.02386012 | Steinernema carpocapsae | 34508 | Nematoda | Nematoda | 263 | 9.34e-66 | NTclustered | gi|296940219|gb|HM067752.1| | 34508 | g52706 | i0 | 86.122 | 99.4672131147541 | 245 | 32 | 100 | 2 | 1 | 244 | 1009 | 1252 | Steinernema carpocapsae enolase mRNA, complete cds | blastn | 24270 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 15971905 | 15971905 | PRJNA690124_P_NODE_30573_length_299_cov_2.092920_g30207_i0 | PRJNA690124 | 30573 | 299 | 2.09292 | 6.2578308 | Pristionchus pacificus | 54126 | Nematoda | Nematoda | 324 | 5.34e-84 | NTclustered | gi|199600269|tpg|BK006064.1| | 54126 | g30207 | i0 | 86.242 | 96.7759197324415 | 298 | 41 | 99 | 0 | 2 | 299 | 1322 | 1025 | TPA_inf: Pristionchus pacificus eukaryotic translation elongation factor 1A (eft-1) mRNA, complete cds | blastn | 28936 | 324 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 17247695 | 17247695 | PRJNA690124_P_NODE_56974_length_230_cov_3.140127_g56608_i0 | PRJNA690124 | 56974 | 230 | 3.140127 | 7.2222921 | Aphelenchoides besseyi | 269767 | Nematoda | Nematoda | 99 | 2.6e-16 | NTclustered | gi|748447428|gb|KP190141.1| | 269767 | g56608 | i0 | 83.333 | 3.67826086956522 | 108 | 17 | 47 | 1 | 1 | 108 | 178 | 72 | Aphelenchoides besseyi isolate Nanjing 14-3-3 protein mRNA, complete cds | blastn | 846 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 19795823 | 19795823 | PRJNA690124_P_NODE_16336_length_400_cov_2.293578_g15970_i0 | PRJNA690124 | 16336 | 400 | 2.293578 | 9.174312 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 202 | 3.6e-47 | NTclustered | gi|690018840|emb|LM526136.1| | 174720 | g15970 | i0 | 79.649 | 6.66 | 285 | 54 | 71 | 4 | 63 | 345 | 7759 | 8041 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000493 | blastn | 2664 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 20304631 | 20304631 | PRJNA690124_P_NODE_15396_length_411_cov_2.254438_g15030_i0 | PRJNA690124 | 15396 | 411 | 2.254438 | 9.26574018 | Panagrellus | 6232 | Nematoda | Nematoda | 760 | 0 | NTclustered | gi|1824634693|gb|MT246664.1| | 6233 | g15030 | i0 | 100 | 78.0267639902676 | 411 | 0 | 100 | 0 | 1 | 411 | 60 | 470 | Panagrellus redivivus isolate 191205_Prediv_ON_purPCR small subunit ribosomal RNA gene, partial sequence | blastn | 32069 | 760 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Panagrellus | Panagrellus redivivus | |
| 21071371 | 21071371 | PRJNA690124_P_NODE_18677_length_375_cov_1.781457_g18311_i0 | PRJNA690124 | 18677 | 375 | 1.781457 | 6.68046375 | Capillaria sp. ALS-2019 | 2651741 | Nematoda | Nematoda | 263 | 1.51e-65 | NTclustered | gi|1811126246|gb|MN526255.1| | 2651741 | g18311 | i0 | 99.31 | 39.2533333333333 | 145 | 1 | 56 | 0 | 3 | 147 | 1188 | 1044 | Capillaria sp. ALS-2019 large subunit ribosomal RNA gene, partial sequence | blastn | 14720 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Capillaria | Capillaria sp. ALS-2019 | |
| 23621823 | 23621823 | PRJNA690124_P_NODE_18859_length_373_cov_5.386667_g18493_i0 | PRJNA690124 | 18859 | 373 | 5.386667 | 20.09226791 | Pseudocapillaria tomentosa | 1904821 | Nematoda | Nematoda | 689 | 0 | NTclustered | gi|2095998828|gb|MZ708958.1| | 1904821 | g18493 | i0 | 100 | 43.573726541555 | 373 | 0 | 100 | 0 | 1 | 373 | 2959 | 2587 | Pseudocapillaria tomentosa mitochondrion, complete genome | blastn | 16253 | 689 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Capillariidae | Pseudocapillaria | Pseudocapillaria tomentosa | |
| 24895912 | 24895912 | PRJNA690124_P_NODE_52160_length_245_cov_0.906977_g51794_i0 | PRJNA690124 | 52160 | 245 | 0.906977 | 2.22209365 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 206 | 1.6e-48 | NTclustered | gi|1845976051|ref|NM_001268463.4| | 6239 | g51794 | i0 | 83.636 | 6.24897959183673 | 220 | 35 | 89 | 1 | 1 | 219 | 514 | 295 | Caenorhabditis elegans Isocitrate dehydrogenase [NADP] (idh-1), mRNA | blastn | 1531 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans |
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);;