contig_metadata
18 rows where bioproject = "PRJNA416866", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8072949 | 8072949 | PRJNA416866_P_NODE_10727_length_205_cov_0.888889_g10583_i0 | PRJNA416866 | 10727 | 205 | 0.888889 | 1.82222245 | Pristionchus sp. 15 RS5229 | 452809 | Nematoda | Nematoda | 174 | 3.66e-39 | NTclustered | gi|150982261|gb|EF634719.1| | 452809 | g10583 | i0 | 88.194 | 10.2048780487805 | 144 | 17 | 70 | 0 | 5 | 148 | 160 | 303 | Pristionchus sp. 15 RS5229 large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds | blastn | 2092 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 15 RS5229 | |
| 24646047 | 24646047 | PRJNA416866_P_NODE_8520_length_221_cov_0.950000_g8376_i0 | PRJNA416866 | 8520 | 221 | 0.95 | 2.0995 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 63.9 | 9.05e-6 | NTclustered | gi|109716042|gb|AC187345.2| | 6334 | g8376 | i0 | 93.182 | 0.597285067873303 | 44 | 1 | 20 | 1 | 12 | 55 | 117976 | 118017 | Trichinella spiralis BAC clone TS195-4H12 from chromosome unknown, complete sequence | blastn | 132 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 26727021 | 26727021 | PRJNA416866_P_NODE_8481_length_221_cov_1.600000_g8337_i0 | PRJNA416866 | 8481 | 221 | 1.6 | 3.536 | Gnathostoma spinigerum | 75299 | Nematoda | Nematoda | 65.5 | 8.01e-11 | NR | MFH4975108.1 | 75299 | g8337 | i0 | 59.7 | 1.710407239819 | 62 | 19 | 84.2 | 1 | 221 | 36 | 103 | 158 | MFH4975108.1 hypothetical protein [Gnathostoma spinigerum] | diamond | 378 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gnathostomatidae | Gnathostoma | Gnathostoma spinigerum | |
| 27138379 | 27138379 | PRJNA416866_P_NODE_7582_length_235_cov_1.126437_g7438_i0 | PRJNA416866 | 7582 | 235 | 1.126437 | 2.64712695 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 99.8 | 1.18e-22 | NR | NP_504575.1 | 6239 | g7438 | i0 | 59 | 2.98723404255319 | 78 | 30 | 99.6 | 1 | 1 | 234 | 33 | 108 | NP_504575.1 Calreticulin [Caenorhabditis elegans] | diamond | 702 | 99.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 27250241 | 27250241 | PRJNA416866_P_NODE_7263_length_240_cov_1.430168_g7119_i0 | PRJNA416866 | 7263 | 240 | 1.430168 | 3.4324032 | Rhabditida | 6236 | Nematoda | Nematoda | 96.3 | 1.16e-22 | NR | CAD2189457.1 | 390850 | g7119 | i0 | 56.4 | 1.95 | 78 | 33 | 97.5 | 1 | 3 | 236 | 8 | 84 | CAD2189457.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 468 | 97.1 | 0.991761071060762 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 27376965 | 27376965 | PRJNA416866_P_NODE_2063_length_477_cov_2.168269_g1920_i0 | PRJNA416866 | 2063 | 477 | 2.168269 | 10.34264313 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.6 | 6.1e-6 | NR | KAL3120152.1 | 157864 | g1920 | i0 | 56.6 | 2.25786163522013 | 53 | 22 | 32.7 | 1 | 472 | 317 | 704 | 756 | KAL3120152.1 hypothetical protein niasHT_008906 [Heterodera trifolii] | diamond | 1077 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera trifolii | |
| 28387027 | 28387027 | PRJNA416866_P_NODE_10766_length_205_cov_0.888889_g10622_i0 | PRJNA416866 | 10766 | 205 | 0.888889 | 1.82222245 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.2 | 2.47e-13 | NR | KAL3117111.1 | 157864 | g10622 | i0 | 48.5 | 6.80487804878049 | 66 | 34 | 96.6 | 0 | 205 | 8 | 148 | 213 | KAL3117111.1 hypothetical protein niasHT_007514 [Heterodera trifolii] | diamond | 1395 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera trifolii | |
| 28875626 | 28875626 | PRJNA416866_P_NODE_8788_length_217_cov_1.525641_g8644_i0 | PRJNA416866 | 8788 | 217 | 1.525641 | 3.31064097 | Gnathostoma spinigerum | 75299 | Nematoda | Nematoda | 69.7 | 8.18e-12 | NR | MFH4975774.1 | 75299 | g8644 | i0 | 45.1 | 3.92626728110599 | 71 | 39 | 98.2 | 0 | 3 | 215 | 702 | 772 | MFH4975774.1 hypothetical protein [Gnathostoma spinigerum] | diamond | 852 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gnathostomatidae | Gnathostoma | Gnathostoma spinigerum | |
| 28923677 | 28923677 | PRJNA416866_P_NODE_6428_length_257_cov_0.969388_g6284_i0 | PRJNA416866 | 6428 | 257 | 0.969388 | 2.49132716 | Rhabditida | 6236 | Nematoda | Nematoda | 109 | 4.03e-27 | NR | VDK52909.1 | 6269 | g6284 | i0 | 75 | 5.96498054474708 | 72 | 18 | 84 | 0 | 222 | 7 | 1 | 72 | VDK52909.1 unnamed protein product [Anisakis simplex] | diamond | 1533 | 110 | 0.990909090909091 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anisakidae | Anisakis | Anisakis simplex | |
| 29412284 | 29412284 | PRJNA416866_P_NODE_4329_length_317_cov_0.937500_g4186_i0 | PRJNA416866 | 4329 | 317 | 0.9375 | 2.971875 | Aphelenchoides avenae | 70226 | Nematoda | Nematoda | 67.4 | 1.93e-10 | NR | KAH7729609.1 | 70226 | g4186 | i0 | 31.4 | 0.993690851735016 | 105 | 71 | 98.4 | 1 | 314 | 3 | 389 | 493 | KAH7729609.1 Acyltransferase ChoActase/COT/CPT [Aphelenchoides avenae] | diamond | 315 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 30075458 | 30075458 | PRJNA416866_P_NODE_10992_length_204_cov_0.895105_g10848_i0 | PRJNA416866 | 10992 | 204 | 0.895105 | 1.8260142 | Acanthocheilonema viteae | 6277 | Nematoda | Nematoda | 47.4 | 3.44e-4 | NR | VBB28430.1 | 6277 | g10848 | i0 | 67.6 | 3.80882352941176 | 37 | 12 | 54.4 | 0 | 204 | 94 | 157 | 193 | VBB28430.1 unnamed protein product [Acanthocheilonema viteae] | diamond | 777 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Acanthocheilonema | Acanthocheilonema viteae | |
| 30155112 | 30155112 | PRJNA416866_P_NODE_6092_length_264_cov_1.261084_g5948_i0 | PRJNA416866 | 6092 | 264 | 1.261084 | 3.32926176 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 7.899999999999999e-24 | NR | AAK54043.1 | 6248 | g5948 | i0 | 52.9 | 14.7613636363636 | 85 | 37 | 96.6 | 1 | 10 | 264 | 144 | 225 | AAK54043.1 G protein alpha subunit 3 [Strongyloides stercoralis] | diamond | 3897 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides stercoralis | |
| 30455092 | 30455092 | PRJNA416866_P_NODE_10573_length_205_cov_0.888889_g10429_i0 | PRJNA416866 | 10573 | 205 | 0.888889 | 1.82222245 | Pristionchus pacificus | 54126 | Nematoda | Nematoda | 125 | 2.13e-31 | NR | KAF8376019.1 | 54126 | g10429 | i0 | 82.4 | 5.97073170731707 | 68 | 12 | 99.5 | 0 | 205 | 2 | 211 | 278 | KAF8376019.1 rack-1 [Pristionchus pacificus] | diamond | 1224 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 31134534 | 31134534 | PRJNA416866_P_NODE_9035_length_214_cov_0.803922_g8891_i0 | PRJNA416866 | 9035 | 214 | 0.803922 | 1.72039308 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.0183 | NR | GMT28504.1 | 1538716 | g8891 | i0 | 48.8 | 2.45327102803738 | 41 | 18 | 54.7 | 2 | 204 | 88 | 123 | 162 | GMT28504.1 hypothetical protein PFISCL1PPCAC_19801, partial [Pristionchus fissidentatus] | diamond | 525 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 31845495 | 31845495 | PRJNA416866_P_NODE_10057_length_207_cov_0.876712_g9913_i0 | PRJNA416866 | 10057 | 207 | 0.876712 | 1.81479384 | Mesorhabditis belari | 2138241 | Nematoda | Nematoda | 43.9 | 0.00275 | NR | CAJ0962865.1 | 2138241 | g9913 | i0 | 42.1 | 1.65217391304348 | 57 | 31 | 81.2 | 2 | 171 | 4 | 21 | 76 | CAJ0962865.1 unnamed protein product, partial [Mesorhabditis belari] | diamond | 342 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis belari | |
| 31845504 | 31845504 | PRJNA416866_P_NODE_4677_length_304_cov_3.053498_g4533_i0 | PRJNA416866 | 4677 | 304 | 3.053498 | 9.28263392 | Gongylonema pulchrum | 637853 | Nematoda | Nematoda | 122 | 2.06e-33 | NR | VDN42325.1 | 637853 | g4533 | i0 | 67 | 4.55921052631579 | 91 | 30 | 89.8 | 0 | 274 | 2 | 4 | 94 | VDN42325.1 unnamed protein product [Gongylonema pulchrum] | diamond | 1386 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gongylonematidae | Gongylonema | Gongylonema pulchrum | |
| 32225424 | 32225424 | PRJNA416866_P_NODE_8698_length_218_cov_2.031847_g8554_i0 | PRJNA416866 | 8698 | 218 | 2.031847 | 4.42942646 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 49.7 | 9.55e-5 | NR | CAD2167694.1 | 390850 | g8554 | i0 | 45.8 | 1.21100917431193 | 48 | 26 | 66.1 | 0 | 169 | 26 | 16 | 63 | CAD2167694.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 264 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 32305522 | 32305522 | PRJNA416866_P_NODE_4079_length_326_cov_2.698113_g3936_i0 | PRJNA416866 | 4079 | 326 | 2.698113 | 8.79584838 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 83.2 | 5.53e-16 | NR | KFD46000.1 | 68888 | g3936 | i0 | 50 | 5.25460122699386 | 76 | 38 | 69.9 | 0 | 93 | 320 | 192 | 267 | KFD46000.1 hypothetical protein M513_13117 [Trichuris suis] | diamond | 1713 | 83.6 | 0.995215311004785 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis |
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);;