contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJDB9741" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26614862 | 26614862 | PRJDB9741_P_NODE_39221_length_161_cov_1.642857_g38904_i0 | PRJDB9741 | 39221 | 161 | 1.642857 | 2.64499977 | Opisthokonta | 33154 | Nematoda | Nematoda | 94 | 1.09e-20 | NR | KAI3422602.1 | 36090 | g38904 | i0 | 76.9 | 74.6273291925466 | 52 | 12 | 96.9 | 0 | 160 | 5 | 285 | 336 | KAI3422602.1 ATP-binding cassette sub- E member 1 [Globodera pallida] | diamond | 12015 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Globodera | Globodera pallida | |
| 27064096 | 27064096 | PRJDB9741_P_NODE_2182_length_508_cov_0.991285_g1870_i0 | PRJDB9741 | 2182 | 508 | 0.991285 | 5.0357278 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 54.3 | 3.51e-5 | NR | AVZ46778.1 | 189291 | g1870 | i0 | 40.7 | 0.478346456692913 | 81 | 48 | 47.8 | 0 | 244 | 2 | 117 | 197 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 243 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 27221950 | 27221950 | PRJDB9741_P_NODE_32243_length_165_cov_0.879310_g31926_i0 | PRJDB9741 | 32243 | 165 | 0.87931 | 1.4508615 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 94 | 7.85e-22 | NR | PAV77790.1 | 2018661 | g31926 | i0 | 88.9 | 0.981818181818182 | 54 | 6 | 98.2 | 0 | 2 | 163 | 176 | 229 | PAV77790.1 hypothetical protein WR25_10987 [Diploscapter pachys] | diamond | 162 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 27412042 | 27412042 | PRJDB9741_P_NODE_1023_length_854_cov_2.592547_g786_i0 | PRJDB9741 | 1023 | 854 | 2.592547 | 22.14035138 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 114 | 7.480000000000001e-26 | NR | AVZ46778.1 | 189291 | g786 | i0 | 51.5 | 0.470725995316159 | 134 | 62 | 46.7 | 2 | 616 | 218 | 117 | 248 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 402 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 28295768 | 28295768 | PRJDB9741_P_NODE_30426_length_166_cov_0.871795_g30109_i0 | PRJDB9741 | 30426 | 166 | 0.871795 | 1.4471797 | Prionchulus punctatus | 293874 | Nematoda | Nematoda | 61.2 | 1.02e-9 | NR | ADK34019.1 | 293874 | g30109 | i0 | 65 | 2.80120481927711 | 40 | 14 | 72.3 | 0 | 166 | 47 | 115 | 154 | ADK34019.1 ubiquitin-Like family 1 [Prionchulus punctatus] | diamond | 465 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Mononchida | Mononchidae | Prionchulus | Prionchulus punctatus | |
| 28321412 | 28321412 | PRJDB9741_P_NODE_36386_length_163_cov_0.894737_g36069_i0 | PRJDB9741 | 36386 | 163 | 0.894737 | 1.45842131 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 81.6 | 2.21e-16 | NR | TMS38419.1 | 34508 | g36069 | i0 | 67.9 | 23.4110429447853 | 53 | 17 | 97.5 | 0 | 161 | 3 | 66 | 118 | TMS38419.1 hypothetical protein L596_005149 [Steinernema carpocapsae] | diamond | 3816 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 28921221 | 28921221 | PRJDB9741_P_NODE_18188_length_181_cov_1.537879_g17871_i0 | PRJDB9741 | 18188 | 181 | 1.537879 | 2.78356099 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.9 | 1.06e-4 | NR | GMR59931.1 | 1317129 | g17871 | i0 | 43.2 | 2.1878453038674 | 44 | 25 | 72.9 | 0 | 29 | 160 | 275 | 318 | GMR59931.1 hypothetical protein PMAYCL1PPCAC_30126, partial [Pristionchus mayeri] | diamond | 396 | 49.3 | 0.991886409736308 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus mayeri | |
| 29022442 | 29022442 | PRJDB9741_P_NODE_10848_length_200_cov_2.192053_g10531_i0 | PRJDB9741 | 10848 | 200 | 2.192053 | 4.384106 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 52.8 | 1.46e-6 | NR | PAV88325.1 | 2018661 | g10531 | i0 | 42.4 | 4.5 | 66 | 38 | 99 | 0 | 200 | 3 | 68 | 133 | PAV88325.1 hypothetical protein WR25_07571 [Diploscapter pachys] | diamond | 900 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 29243144 | 29243144 | PRJDB9741_P_NODE_37409_length_162_cov_1.353982_g37092_i0 | PRJDB9741 | 37409 | 162 | 1.353982 | 2.19345084 | Angiostrongylus cantonensis | 6313 | Nematoda | Nematoda | 73.6 | 1.11e-13 | NR | KAE9415342.1 | 6313 | g37092 | i0 | 58.5 | 1.96296296296296 | 53 | 20 | 98.1 | 1 | 161 | 3 | 159 | 209 | KAE9415342.1 hypothetical protein Angca_010209, partial [Angiostrongylus cantonensis] | diamond | 318 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Angiostrongylus | Angiostrongylus cantonensis | |
| 29363531 | 29363531 | PRJDB9741_P_NODE_18969_length_180_cov_1.167939_g18652_i0 | PRJDB9741 | 18969 | 180 | 1.167939 | 2.1022902 | Caenorhabditis | 6237 | Nematoda | Nematoda | 69.3 | 6.62e-12 | NR | CAI5445746.1 | 860376 | g18652 | i0 | 73.3 | 10.2333333333333 | 45 | 12 | 75 | 0 | 136 | 2 | 544 | 588 | CAI5445746.1 unnamed protein product [Caenorhabditis angaria] | diamond | 1842 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis angaria | |
| 30121206 | 30121206 | PRJDB9741_P_NODE_5092_length_282_cov_1.304721_g4776_i0 | PRJDB9741 | 5092 | 282 | 1.304721 | 3.67931322 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 172 | 8.29e-51 | NR | NP_001256250.1 | 6239 | g4776 | i0 | 80.6 | 143.436170212766 | 93 | 18 | 98.9 | 0 | 3 | 281 | 182 | 274 | NP_001256250.1 Serine/threonine-protein phosphatase PP1-alpha [Caenorhabditis elegans] | diamond | 40449 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 30790805 | 30790805 | PRJDB9741_P_NODE_24574_length_171_cov_1.262295_g24257_i0 | PRJDB9741 | 24574 | 171 | 1.262295 | 2.15852445 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 67 | 9.13e-12 | NR | NP_001379064.1 | 6239 | g24257 | i0 | 81.8 | 0.771929824561403 | 44 | 8 | 77.2 | 0 | 169 | 38 | 159 | 202 | NP_001379064.1 Large ribosomal subunit protein uL13 [Caenorhabditis elegans] | diamond | 132 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 31669985 | 31669985 | PRJDB9741_P_NODE_17157_length_183_cov_1.231343_g16840_i0 | PRJDB9741 | 17157 | 183 | 1.231343 | 2.25335769 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 111 | 1.97e-30 | NR | CDW60316.1 | 36087 | g16840 | i0 | 83.1 | 18.5901639344262 | 59 | 10 | 96.7 | 0 | 3 | 179 | 10 | 68 | CDW60316.1 Ribosomal protein L37 [Trichuris trichiura] | diamond | 3402 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 31764891 | 31764891 | PRJDB9741_P_NODE_897_length_917_cov_2.013825_g682_i0 | PRJDB9741 | 897 | 917 | 2.013825 | 18.46677525 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 248 | 3.06e-77 | NR | CAD5210754.1 | 465554 | g682 | i0 | 54.9 | 1.4721919302072 | 226 | 101 | 73.9 | 1 | 916 | 239 | 55 | 279 | CAD5210754.1 unnamed protein product [Bursaphelenchus okinawaensis] | diamond | 1350 | 250 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus okinawaensis |
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);;