contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA450343" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4266100 | 4266100 | PRJNA450343_P_NODE_7384_length_198_cov_1.711409_g7316_i0 | PRJNA450343 | 7384 | 198 | 1.711409 | 3.38858982 | Rhabditida | 6236 | Nematoda | Nematoda | 105 | 2.05e-26 | NR | VDK24207.1 | 6269 | g7316 | i0 | 73.8 | 18.7424242424242 | 65 | 17 | 98.5 | 0 | 196 | 2 | 109 | 173 | VDK24207.1 unnamed protein product, partial [Anisakis simplex] | diamond | 3711 | 106 | 0.990566037735849 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anisakidae | Anisakis | Anisakis simplex | |
| 6816806 | 6816806 | PRJNA450343_P_NODE_2786_length_324_cov_0.949091_g2718_i0 | PRJNA450343 | 2786 | 324 | 0.949091 | 3.07505484 | Rhabditida | 6236 | Nematoda | Nematoda | 134 | 7.3299999999999985e-34 | NR | VDO70396.1 | 6339 | g2718 | i0 | 67.6 | 10.9074074074074 | 108 | 35 | 100 | 0 | 324 | 1 | 1043 | 1150 | VDO70396.1 unnamed protein product [Heligmosomoides polygyrus] | diamond | 3534 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heligmosomidae | Heligmosomoides | Heligmosomoides polygyrus | |
| 15120291 | 15120291 | PRJNA450343_P_NODE_11212_length_166_cov_0.871795_g11144_i0 | PRJNA450343 | 11212 | 166 | 0.871795 | 1.4471797 | Toxocara canis | 6265 | Nematoda | Nematoda | 94 | 3.58e-21 | NR | KHN89029.1 | 6265 | g11144 | i0 | 83.6 | 2.98192771084337 | 55 | 9 | 99.4 | 0 | 2 | 166 | 249 | 303 | KHN89029.1 Glyceraldehyde-3-phosphate dehydrogenase 3 [Toxocara canis] | diamond | 495 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 23391285 | 23391285 | PRJNA450343_P_NODE_4419_length_253_cov_1.500000_g4351_i0 | PRJNA450343 | 4419 | 253 | 1.5 | 3.795 | Metazoa | 33208 | Nematoda | Nematoda | 75.1 | 9.78e-16 | NR | KRX72555.1 | 6337 | g4351 | i0 | 80 | 10.8853754940711 | 45 | 9 | 53.4 | 0 | 253 | 119 | 20 | 64 | KRX72555.1 ADP,ATP carrier protein 3, mitochondrial [Trichinella pseudospiralis] | diamond | 2754 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella pseudospiralis | |
| 27170704 | 27170704 | PRJNA450343_P_NODE_3122_length_304_cov_2.180392_g3054_i0 | PRJNA450343 | 3122 | 304 | 2.180392 | 6.62839168 | Ancylostoma caninum | 29170 | Nematoda | Nematoda | 66.2 | 2.21e-10 | NR | RCN28425.1 | 29170 | g3054 | i0 | 45.6 | 2.64473684210526 | 90 | 34 | 76 | 5 | 234 | 4 | 29 | 116 | RCN28425.1 shTK domain protein, partial [Ancylostoma caninum] | diamond | 804 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma caninum | |
| 27218499 | 27218499 | PRJNA450343_P_NODE_10482_length_168_cov_1.285714_g10414_i0 | PRJNA450343 | 10482 | 168 | 1.285714 | 2.15999952 | Metastrongylidae | 55271 | Nematoda | Nematoda | 57.8 | 5.24e-8 | NR | KAE9418629.1 | 6313 | g10414 | i0 | 52.1 | 2.51785714285714 | 48 | 23 | 85.7 | 0 | 156 | 13 | 173 | 220 | KAE9418629.1 hypothetical protein Angca_008814 [Angiostrongylus cantonensis] | diamond | 423 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Angiostrongylus | Angiostrongylus cantonensis | |
| 27218500 | 27218500 | PRJNA450343_P_NODE_7722_length_194_cov_1.737931_g7654_i0 | PRJNA450343 | 7722 | 194 | 1.737931 | 3.37158614 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 46.6 | 5.39e-4 | NR | MCP9266083.1 | 6287 | g7654 | i0 | 76.9 | 5.38144329896907 | 26 | 6 | 40.2 | 0 | 80 | 3 | 37 | 62 | MCP9266083.1 Ubiquitin-conjugating enzyme E2-17 kDa [Dirofilaria immitis] | diamond | 1044 | 47 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Dirofilaria | Dirofilaria immitis | |
| 27471665 | 27471665 | PRJNA450343_P_NODE_8443_length_187_cov_1.108696_g8375_i0 | PRJNA450343 | 8443 | 187 | 1.108696 | 2.07326152 | Metazoa | 33208 | Nematoda | Nematoda | 116 | 2.36e-30 | NR | EJW80512.1 | 6293 | g8375 | i0 | 88.5 | 23.4866310160428 | 61 | 7 | 97.9 | 0 | 3 | 185 | 22 | 82 | EJW80512.1 T-complex protein 1 subunit beta [Wuchereria bancrofti] | diamond | 4392 | 117 | 0.991452991452991 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 27755974 | 27755974 | PRJNA450343_P_NODE_11404_length_166_cov_0.871795_g11336_i0 | PRJNA450343 | 11404 | 166 | 0.871795 | 1.4471797 | Rhabditida | 6236 | Nematoda | Nematoda | 47.8 | 1.72e-4 | NR | XP_024500215.1 | 34506 | g11336 | i0 | 41.5 | 7.80722891566265 | 53 | 31 | 95.8 | 0 | 2 | 160 | 46 | 98 | XP_024500215.1 GOLD domain-containing protein [Strongyloides ratti] | diamond | 1296 | 48.1 | 0.993762993762994 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 27881989 | 27881989 | PRJNA450343_P_NODE_1825_length_408_cov_1.885794_g1757_i0 | PRJNA450343 | 1825 | 408 | 1.885794 | 7.69403952 | Rhabditida | 6236 | Nematoda | Nematoda | 52.4 | 9.78e-5 | NR | EFO97153.1 | 31234 | g1757 | i0 | 36.6 | 2.36029411764706 | 82 | 43 | 58.8 | 5 | 20 | 259 | 1042 | 1116 | EFO97153.1 hypothetical protein CRE_30195 [Caenorhabditis remanei] | diamond | 963 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 28339390 | 28339390 | PRJNA450343_P_NODE_4446_length_252_cov_1.980296_g4378_i0 | PRJNA450343 | 4446 | 252 | 1.980296 | 4.99034592 | Ancylostoma ceylanicum | 53326 | Nematoda | Nematoda | 59.3 | 5.83e-8 | NR | EYC13182.1 | 53326 | g4378 | i0 | 66.7 | 1.48809523809524 | 39 | 13 | 46.4 | 0 | 104 | 220 | 36 | 74 | EYC13182.1 hypothetical protein Y032_0044g1017 [Ancylostoma ceylanicum] | diamond | 375 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma ceylanicum | |
| 29381328 | 29381328 | PRJNA450343_P_NODE_8989_length_182_cov_1.150376_g8921_i0 | PRJNA450343 | 8989 | 182 | 1.150376 | 2.09368432 | Dirofilaria immitis | 6287 | Nematoda | Nematoda | 94.4 | 2.8400000000000003e-21 | NR | MCP9263221.1 | 6287 | g8921 | i0 | 78.3 | 4.94505494505495 | 60 | 13 | 98.9 | 0 | 181 | 2 | 41 | 100 | MCP9263221.1 60S acidic ribosomal protein P0 [Dirofilaria immitis] | diamond | 900 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Dirofilaria | Dirofilaria immitis | |
| 31008619 | 31008619 | PRJNA450343_P_NODE_5014_length_237_cov_1.079787_g4946_i0 | PRJNA450343 | 5014 | 237 | 1.079787 | 2.55909519 | Metazoa | 33208 | Nematoda | Nematoda | 93.6 | 3.15e-20 | NR | XP_024506889.1 | 34506 | g4946 | i0 | 59.5 | 24.4556962025316 | 74 | 30 | 93.7 | 0 | 230 | 9 | 372 | 445 | XP_024506889.1 Alpha tubulin-like protein [Strongyloides ratti] | diamond | 5796 | 94 | 0.995744680851064 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 31134659 | 31134659 | PRJNA450343_P_NODE_7455_length_198_cov_1.026846_g7387_i0 | PRJNA450343 | 7455 | 198 | 1.026846 | 2.03315508 | Metazoa | 33208 | Nematoda | Nematoda | 86.3 | 9.36e-18 | NR | KAH7726681.1 | 70226 | g7387 | i0 | 66.2 | 22.4090909090909 | 65 | 22 | 98.5 | 0 | 2 | 196 | 491 | 555 | KAH7726681.1 heat shock protein HSP 90-beta [Aphelenchoides avenae] | diamond | 4437 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 31292958 | 31292958 | PRJNA450343_P_NODE_12755_length_163_cov_0.894737_g12687_i0 | PRJNA450343 | 12755 | 163 | 0.894737 | 1.45842131 | Metazoa | 33208 | Nematoda | Nematoda | 44.7 | 0.00143 | NR | VDK79768.1 | 6269 | g12687 | i0 | 67.9 | 2.06134969325153 | 28 | 9 | 51.5 | 0 | 86 | 3 | 86 | 113 | VDK79768.1 unnamed protein product, partial [Anisakis simplex] | diamond | 336 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anisakidae | Anisakis | Anisakis simplex | |
| 32747418 | 32747418 | PRJNA450343_P_NODE_4900_length_240_cov_1.068063_g4832_i0 | PRJNA450343 | 4900 | 240 | 1.068063 | 2.5633512 | Opisthokonta | 33154 | Nematoda | Nematoda | 76.3 | 1.08e-14 | NR | GMS85744.1 | 358040 | g4832 | i0 | 43.1 | 3.55 | 72 | 41 | 90 | 0 | 216 | 1 | 109 | 180 | GMS85744.1 hypothetical protein PENTCL1PPCAC_7919, partial [Pristionchus entomophagus] | diamond | 852 | 77 | 0.990909090909091 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus entomophagus | |
| 32904780 | 32904780 | PRJNA450343_P_NODE_7020_length_203_cov_0.974026_g6952_i0 | PRJNA450343 | 7020 | 203 | 0.974026 | 1.97727278 | Opisthokonta | 33154 | Nematoda | Nematoda | 130 | 1.6e-34 | NR | UMM40069.1 | 6238 | g6952 | i0 | 97 | 575.039408866995 | 67 | 2 | 99 | 0 | 202 | 2 | 179 | 245 | UMM40069.1 hypothetical protein L5515_016845 [Caenorhabditis briggsae] | diamond | 116733 | 131 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae |
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);;