contig_metadata
17 rows where bioproject = "PRJNA683902", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1941366 | 1941366 | PRJNA683902_S_NODE_38382_length_153_cov_5.137931_g37938_i0 | PRJNA683902 | 38382 | 153 | 5.137931 | 7.86103443 | Longidorus macrosoma | 188093 | Nematoda | Nematoda | 167 | 4.2899999999999995e-37 | NTclustered | gi|49339465|gb|AY580055.1| | 188093 | g37938 | i0 | 86.164 | 44.7777777777778 | 159 | 16 | 100 | 6 | 1 | 153 | 2499 | 2341 | Longidorus macrosoma 28S ribosomal RNA gene, 28S-18S intergenic spacer, 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence | blastn | 6851 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dorylaimida | Longidoridae | Longidorus | Longidorus macrosoma | |
| 3216238 | 3216238 | PRJNA683902_S_NODE_34703_length_163_cov_1.206349_g34259_i0 | PRJNA683902 | 34703 | 163 | 1.206349 | 1.96634887 | Brugia malayi | 6279 | Nematoda | Nematoda | 193 | 7.669999999999999e-45 | NTclustered | gi|2082298039|ref|XM_043075942.1| | 6279 | g34259 | i0 | 90.411 | 22 | 146 | 14 | 90 | 0 | 15 | 160 | 1 | 146 | Brugia malayi Uncharacterized protein (Bma-tbb-4), partial mRNA | blastn | 3586 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 4493163 | 4493163 | PRJNA683902_S_NODE_18304_length_256_cov_5.461187_g17860_i0 | PRJNA683902 | 18304 | 256 | 5.461187 | 13.98063872 | Xiphinema brevicolle | 243734 | Nematoda | Nematoda | 244 | 3.5799999999999996e-60 | NTclustered | gi|49339471|gb|AY580057.1| | 243734 | g17860 | i0 | 88.725 | 11.39453125 | 204 | 17 | 78 | 5 | 1 | 200 | 3753 | 3552 | Xiphinema brevicollum 28S ribosomal RNA gene, 28S-18S intergenic spacer, 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence | blastn | 2917 | 244 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dorylaimida | Longidoridae | Xiphinema | Xiphinema brevicolle | |
| 5768973 | 5768973 | PRJNA683902_S_NODE_34185_length_164_cov_2.259843_g33741_i0 | PRJNA683902 | 34185 | 164 | 2.259843 | 3.70614252 | Brugia malayi | 6279 | Nematoda | Nematoda | 137 | 3.67e-28 | NTclustered | gi|2082273969|ref|XM_001902266.2| | 6279 | g33741 | i0 | 82.317 | 31.9939024390244 | 164 | 23 | 98 | 6 | 2 | 162 | 160 | 320 | Brugia malayi ubiquitin-like protein, putative (Bma-ubq-2), partial mRNA | blastn | 5247 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 7553298 | 7553298 | PRJNA683902_S_NODE_23766_length_210_cov_2.219653_g23322_i0 | PRJNA683902 | 23766 | 210 | 2.219653 | 4.6612713 | Propanagrolaimus | 1510670 | Nematoda | Nematoda | 200 | 6.22e-47 | NTclustered | gi|662563250|gb|KJ434174.1| | 1519088 | g23322 | i0 | 83.81 | 101.885714285714 | 210 | 32 | 99 | 2 | 2 | 210 | 1658 | 1450 | Propanagrolaimus sp. LC91 28S ribosomal RNA gene, partial sequence | blastn | 21396 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Propanagrolaimus | Propanagrolaimus sp. LC91 | |
| 10869312 | 10869312 | PRJNA683902_S_NODE_31149_length_174_cov_2.277372_g30705_i0 | PRJNA683902 | 31149 | 174 | 2.277372 | 3.96262728 | Panagrolaimus sp. | 2726203 | Nematoda | Nematoda | 213 | 6.35e-51 | NTclustered | gi|2491200846|gb|OQ842736.1| | 2726203 | g30705 | i0 | 89.08 | 73.2068965517241 | 174 | 15 | 99 | 4 | 2 | 173 | 1033 | 862 | Panagrolaimus sp. isolate NJdiseased small subunit ribosomal RNA gene, partial sequence | blastn | 12738 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Panagrolaimus | Panagrolaimus sp. | |
| 13419187 | 13419187 | PRJNA683902_S_NODE_18391_length_255_cov_6.142202_g17947_i0 | PRJNA683902 | 18391 | 255 | 6.142202 | 15.6626151 | Ecumenicus monohystera | 211289 | Nematoda | Nematoda | 370 | 5.63e-98 | NTclustered | gi|51093905|gb|AY593013.1| | 211289 | g17947 | i0 | 95.652 | 89.4078431372549 | 230 | 10 | 90 | 0 | 1 | 230 | 299 | 70 | Ecumenicus monohystera clone EcumMon large subunit ribosomal RNA gene, partial sequence | blastn | 22799 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dorylaimida | Qudsianematidae | Ecumenicus | Ecumenicus monohystera | |
| 18517253 | 18517253 | PRJNA683902_S_NODE_12195_length_372_cov_18.232836_g11751_i0 | PRJNA683902 | 12195 | 372 | 18.232836 | 67.82614992 | Calcaridorylaimus sp. 1 WJW-2018 | 2486831 | Nematoda | Nematoda | 527 | 4.819999999999998e-145 | NTclustered | gi|1512459614|gb|MG921246.1| | 2486831 | g11751 | i0 | 92.225 | 85.4301075268817 | 373 | 28 | 100 | 1 | 1 | 372 | 106 | 478 | Calcaridorylaimus sp. 1 WJW-2018 clone 2 28S ribosomal RNA gene, partial sequence | blastn | 31780 | 527 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dorylaimida | Dorylaimidae | Calcaridorylaimus | Calcaridorylaimus sp. 1 WJW-2018 | |
| 18517430 | 18517430 | PRJNA683902_S_NODE_30475_length_176_cov_7.676259_g30031_i0 | PRJNA683902 | 30475 | 176 | 7.676259 | 13.51021584 | Mesodorylaimus cf. nigritulus AV-2005 | 327447 | Nematoda | Nematoda | 320 | 3.69e-83 | NTclustered | gi|90968496|emb|AJ966490.1| | 327447 | g30031 | i0 | 99.432 | 100.017045454545 | 176 | 1 | 100 | 0 | 1 | 176 | 115 | 290 | Mesodorylaimus cf. nigritulus AV-2005 partial 18S rRNA gene, from Belgium, Ghent | blastn | 17603 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dorylaimida | Dorylaimidae | Mesodorylaimus | Mesodorylaimus cf. nigritulus AV-2005 | |
| 23618073 | 23618073 | PRJNA683902_S_NODE_16079_length_287_cov_7.852000_g15635_i0 | PRJNA683902 | 16079 | 287 | 7.852 | 22.53524 | Longidorus macrosoma | 188093 | Nematoda | Nematoda | 422 | 1.76e-113 | NTclustered | gi|49339465|gb|AY580055.1| | 188093 | g15635 | i0 | 93.426 | 19.390243902439 | 289 | 12 | 98 | 4 | 5 | 286 | 1895 | 2183 | Longidorus macrosoma 28S ribosomal RNA gene, 28S-18S intergenic spacer, 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence | blastn | 5565 | 422 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dorylaimida | Longidoridae | Longidorus | Longidorus macrosoma | |
| 26861028 | 26861028 | PRJNA683902_S_NODE_30301_length_177_cov_2.507143_g29857_i0 | PRJNA683902 | 30301 | 177 | 2.507143 | 4.43764311 | Dirofilaria immitis | 6287 | Nematoda | Nematoda | 50.4 | 1.62e-5 | NR | MCP9259841.1 | 6287 | g29857 | i0 | 51.9 | 0.88135593220339 | 52 | 25 | 88.1 | 0 | 175 | 20 | 2 | 53 | MCP9259841.1 hypothetical protein [Dirofilaria immitis] | diamond | 156 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Dirofilaria | Dirofilaria immitis | |
| 27851774 | 27851774 | PRJNA683902_S_NODE_35644_length_160_cov_1.878049_g35200_i0 | PRJNA683902 | 35644 | 160 | 1.878049 | 3.0048784 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 53.9 | 5.67e-7 | NR | CAK5024798.1 | 390850 | g35200 | i0 | 46.9 | 12.825 | 49 | 26 | 91.9 | 0 | 156 | 10 | 38 | 86 | CAK5024798.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 2052 | 54.3 | 0.992633517495396 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 27903219 | 27903219 | PRJNA683902_S_NODE_37285_length_156_cov_1.966387_g36841_i0 | PRJNA683902 | 37285 | 156 | 1.966387 | 3.06756372 | Longidorus vineacola | 241698 | Nematoda | Nematoda | 63.5 | 2.96e-10 | NR | YP_009346422.1 | 241698 | g36841 | i0 | 54.9 | 0.980769230769231 | 51 | 23 | 98.1 | 0 | 2 | 154 | 181 | 231 | YP_009346422.1 cytochrome c oxidase subunit III [Longidorus vineacola] | diamond | 153 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dorylaimida | Longidoridae | Longidorus | Longidorus vineacola | |
| 29292656 | 29292656 | PRJNA683902_S_NODE_26689_length_193_cov_3.442308_g26245_i0 | PRJNA683902 | 26689 | 193 | 3.442308 | 6.64365444 | Trichuris suis | 68888 | Nematoda | Nematoda | 62 | 2.11e-10 | NR | KFD55927.1 | 68888 | g26245 | i0 | 55.2 | 0.901554404145078 | 58 | 26 | 90.2 | 0 | 18 | 191 | 20 | 77 | KFD55927.1 hypothetical protein M513_03051, partial [Trichuris suis] | diamond | 174 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 30872014 | 30872014 | PRJNA683902_S_NODE_23514_length_211_cov_7.051724_g23070_i0 | PRJNA683902 | 23514 | 211 | 7.051724 | 14.87913764 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 42 | 0.0435 | NR | GMT28504.1 | 1538716 | g23070 | i0 | 51.2 | 0.582938388625592 | 41 | 17 | 55.5 | 2 | 9 | 125 | 123 | 162 | GMT28504.1 hypothetical protein PFISCL1PPCAC_19801, partial [Pristionchus fissidentatus] | diamond | 123 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 32295556 | 32295556 | PRJNA683902_S_NODE_25159_length_202_cov_1.727273_g24715_i0 | PRJNA683902 | 25159 | 202 | 1.727273 | 3.48909146 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 43.5 | 0.0113 | NR | GMT33030.1 | 1538716 | g24715 | i0 | 36.5 | 0.935643564356436 | 63 | 28 | 80.2 | 3 | 166 | 5 | 153 | 212 | GMT33030.1 hypothetical protein PFISCL1PPCAC_24327, partial [Pristionchus fissidentatus] | diamond | 189 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 32611400 | 32611400 | PRJNA683902_S_NODE_24120_length_208_cov_1.894737_g23676_i0 | PRJNA683902 | 24120 | 208 | 1.894737 | 3.94105296 | Oesophagostomum dentatum | 61180 | Nematoda | Nematoda | 59.7 | 2.46e-8 | NR | KHJ98883.1 | 61180 | g23676 | i0 | 40.6 | 1.94711538461538 | 69 | 41 | 99.5 | 0 | 1 | 207 | 154 | 222 | KHJ98883.1 ribosomal protein L10 [Oesophagostomum dentatum] | diamond | 405 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Oesophagostomum | Oesophagostomum dentatum |
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);;