contig_metadata
20 rows where bioproject = "PRJNA1108487", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11223986 | 11223986 | PRJNA1108487_P_NODE_6429_length_283_cov_1.485714_g6363_i0 | PRJNA1108487 | 6429 | 283 | 1.485714 | 4.20457062 | Caenorhabditis | 6237 | Nematoda | Nematoda | 161 | 4.159999999999999e-35 | NTclustered | gi|268577906|ref|XM_002643890.1| | 6238 | g6363 | i0 | 86.806 | 13.3710247349823 | 144 | 19 | 51 | 0 | 140 | 283 | 692 | 549 | Caenorhabditis briggsae Protein CBR-FTT-2 (Cbr-ftt-2), partial mRNA | blastn | 3784 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 11692125 | 11692125 | PRJNA1108487_P_NODE_7350_length_267_cov_1.608247_g7284_i0 | PRJNA1108487 | 7350 | 267 | 1.608247 | 4.29401949 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 102 | 2.39e-17 | NTclustered | gi|268579136|ref|XM_002644505.1| | 6238 | g7284 | i0 | 80.137 | 20.7640449438202 | 146 | 21 | 53 | 7 | 63 | 204 | 199 | 58 | Caenorhabditis briggsae Protein CBR-PDI-2 (Cbr-pdi-2), partial mRNA | blastn | 5544 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 13773865 | 13773865 | PRJNA1108487_P_NODE_6511_length_281_cov_1.903846_g6445_i0 | PRJNA1108487 | 6511 | 281 | 1.903846 | 5.34980726 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|1376141561|ref|XM_024651035.1| | 34506 | g6445 | i0 | 96.875 | 10.3451957295374 | 32 | 1 | 11 | 0 | 136 | 167 | 771 | 802 | Strongyloides ratti BTB/POZ-like domain and BTB/POZ fold domain and BTB/POZ domain-containing protein (SRAE_2000023100), partial mRNA | blastn | 2907 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 15516030 | 15516030 | PRJNA1108487_P_NODE_3533_length_365_cov_1.065068_g3467_i0 | PRJNA1108487 | 3533 | 365 | 1.065068 | 3.8874982 | Caenorhabditis brenneri | 135651 | Nematoda | Nematoda | 250 | 1.14e-61 | NTclustered | gi|241017545|gb|GQ169498.1| | 135651 | g3467 | i0 | 79.942 | 111.427397260274 | 344 | 65 | 94 | 4 | 24 | 365 | 342 | 1 | Caenorhabditis brenneri clone T4AA06.09 putative ubiquitin family protein mRNA, partial cds | blastn | 40671 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis brenneri | |
| 17598254 | 17598254 | PRJNA1108487_P_NODE_2594_length_420_cov_7.397695_g2528_i0 | PRJNA1108487 | 2594 | 420 | 7.397695 | 31.070319 | root | 1 | Root_unresolved | Root_unresolved | 185 | 1.81e-57 | NR | CDW60131.1 | 36087 | g2528 | i0 | 62.5 | 2.91428571428571 | 136 | 51 | 97.1 | 0 | 409 | 2 | 1 | 136 | CDW60131.1 60S ribosomal protein L27a [Trichuris trichiura] | diamond | 1224 | 186 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 26805800 | 26805800 | PRJNA1108487_P_NODE_2721_length_412_cov_1.197640_g2655_i0 | PRJNA1108487 | 2721 | 412 | 1.19764 | 4.9342768 | Opisthokonta | 33154 | Nematoda | Nematoda | 47.8 | 0.00378 | NR | KAF8383616.1 | 54126 | g2655 | i0 | 42.9 | 0.837378640776699 | 63 | 36 | 45.9 | 0 | 11 | 199 | 4 | 66 | KAF8383616.1 hypothetical protein PRIPAC_72758 [Pristionchus pacificus] | diamond | 345 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 26869398 | 26869398 | PRJNA1108487_P_NODE_6441_length_283_cov_1.485714_g6375_i0 | PRJNA1108487 | 6441 | 283 | 1.485714 | 4.20457062 | Opisthokonta | 33154 | Nematoda | Nematoda | 63.9 | 1.38e-9 | NR | VDD91361.1 | 51028 | g6375 | i0 | 44.4 | 8.56537102473498 | 72 | 40 | 76.3 | 0 | 68 | 283 | 50 | 121 | VDD91361.1 unnamed protein product [Enterobius vermicularis] | diamond | 2424 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Oxyuridae | Enterobius | Enterobius vermicularis | |
| 27162338 | 27162338 | PRJNA1108487_P_NODE_9002_length_250_cov_2.644068_g8936_i0 | PRJNA1108487 | 9002 | 250 | 2.644068 | 6.61017 | Soboliphyme baturini | 241478 | Nematoda | Nematoda | 50.4 | 5.33e-5 | NR | VDP42323.1 | 241478 | g8936 | i0 | 37 | 0.876 | 73 | 43 | 87.6 | 1 | 239 | 21 | 1 | 70 | VDP42323.1 unnamed protein product [Soboliphyme baturini] | diamond | 219 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 27352443 | 27352443 | PRJNA1108487_P_NODE_1543_length_537_cov_2.165948_g1477_i0 | PRJNA1108487 | 1543 | 537 | 2.165948 | 11.63114076 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 45.8 | 0.0364 | NR | AVZ46778.1 | 189291 | g1477 | i0 | 39.3 | 0.340782122905028 | 61 | 37 | 34.1 | 0 | 234 | 52 | 117 | 177 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 183 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 27510222 | 27510222 | PRJNA1108487_P_NODE_6463_length_282_cov_2.105263_g6397_i0 | PRJNA1108487 | 6463 | 282 | 2.105263 | 5.93684166 | Heterodera trifolii | 157864 | Nematoda | Nematoda | 58.2 | 1.9e-7 | NR | KAL3073343.1 | 157864 | g6397 | i0 | 48.4 | 2.58510638297872 | 62 | 32 | 66 | 0 | 3 | 188 | 205 | 266 | KAL3073343.1 hypothetical protein niasHT_038700 [Heterodera trifolii] | diamond | 729 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera trifolii | |
| 27604989 | 27604989 | PRJNA1108487_P_NODE_3704_length_357_cov_2.619718_g3638_i0 | PRJNA1108487 | 3704 | 357 | 2.619718 | 9.35239326 | Gnathostoma spinigerum | 75299 | Nematoda | Nematoda | 135 | 1.91e-35 | NR | MFH4975591.1 | 75299 | g3638 | i0 | 66.7 | 6.35294117647059 | 84 | 28 | 70.6 | 0 | 252 | 1 | 7 | 90 | MFH4975591.1 hypothetical protein [Gnathostoma spinigerum] | diamond | 2268 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gnathostomatidae | Gnathostoma | Gnathostoma spinigerum | |
| 27880275 | 27880275 | PRJNA1108487_P_NODE_8925_length_251_cov_0.876404_g8859_i0 | PRJNA1108487 | 8925 | 251 | 0.876404 | 2.19977404 | Nematoda | 6231 | Nematoda | Nematoda | 82.4 | 1.23e-16 | NR | KAI1720621.1 | 166010 | g8859 | i0 | 46.2 | 3.82470119521912 | 78 | 42 | 93.2 | 0 | 17 | 250 | 1 | 78 | KAI1720621.1 sel1 repeat domain-containing protein [Ditylenchus destructor] | diamond | 960 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 28164486 | 28164486 | PRJNA1108487_P_NODE_7345_length_267_cov_1.608247_g7279_i0 | PRJNA1108487 | 7345 | 267 | 1.608247 | 4.29401949 | root | 1 | Root_unresolved | Root_unresolved | 83.2 | 2.58e-17 | NR | RCN42395.1 | 29170 | g7279 | i0 | 53.5 | 2.35955056179775 | 71 | 33 | 79.8 | 0 | 32 | 244 | 38 | 108 | RCN42395.1 Ser/Thr phosphatase family protein [Ancylostoma caninum] | diamond | 630 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma caninum | |
| 28899178 | 28899178 | PRJNA1108487_P_NODE_5648_length_299_cov_4.668142_g5582_i0 | PRJNA1108487 | 5648 | 299 | 4.668142 | 13.95774458 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 57 | 8.42e-8 | NR | GMT18625.1 | 1538716 | g5582 | i0 | 36 | 1.00334448160535 | 100 | 58 | 99.3 | 3 | 298 | 2 | 2 | 96 | GMT18625.1 hypothetical protein PFISCL1PPCAC_9922 [Pristionchus fissidentatus] | diamond | 300 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 29120600 | 29120600 | PRJNA1108487_P_NODE_11089_length_243_cov_0.917647_g11023_i0 | PRJNA1108487 | 11089 | 243 | 0.917647 | 2.22988221 | Ditylenchus destructor | 166010 | Nematoda | Nematoda | 69.3 | 2.77e-12 | NR | KAI1729755.1 | 166010 | g11023 | i0 | 70.2 | 3.49382716049383 | 47 | 14 | 58 | 0 | 12 | 152 | 140 | 186 | KAI1729755.1 ras family domain-containing protein [Ditylenchus destructor] | diamond | 849 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 29774589 | 29774589 | PRJNA1108487_P_NODE_8671_length_252_cov_0.871508_g8605_i0 | PRJNA1108487 | 8671 | 252 | 0.871508 | 2.19620016 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 159 | 4.52e-48 | NR | VDO44227.1 | 6290 | g8605 | i0 | 96.2 | 187.571428571429 | 78 | 3 | 92.9 | 0 | 250 | 17 | 62 | 139 | VDO44227.1 unnamed protein product [Haemonchus placei] | diamond | 47268 | 160 | 0.99375 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Haemonchus | Haemonchus placei | |
| 29837776 | 29837776 | PRJNA1108487_P_NODE_11271_length_242_cov_0.923077_g11205_i0 | PRJNA1108487 | 11271 | 242 | 0.923077 | 2.23384634 | Rhabditida | 6236 | Nematoda | Nematoda | 47 | 0.00111 | NR | VBB33759.1 | 6277 | g11205 | i0 | 78.6 | 3.81818181818182 | 28 | 6 | 34.7 | 0 | 84 | 1 | 43 | 70 | VBB33759.1 unnamed protein product [Acanthocheilonema viteae] | diamond | 924 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Acanthocheilonema | Acanthocheilonema viteae | |
| 29941525 | 29941525 | PRJNA1108487_P_NODE_471_length_921_cov_3.086085_g420_i0 | PRJNA1108487 | 471 | 921 | 3.086085 | 28.42284285 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 62.4 | 4.37e-7 | NR | AVZ46778.1 | 189291 | g420 | i0 | 28 | 0.407166123778502 | 125 | 90 | 40.7 | 0 | 285 | 659 | 117 | 241 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 375 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 31110184 | 31110184 | PRJNA1108487_P_NODE_375_length_997_cov_19.247835_g329_i0 | PRJNA1108487 | 375 | 997 | 19.247835 | 191.90091495 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 110 | 5.8599999999999996e-24 | NR | AVZ46778.1 | 189291 | g329 | i0 | 50 | 0.391173520561685 | 130 | 65 | 39.1 | 0 | 280 | 669 | 117 | 246 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 390 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 31141599 | 31141599 | PRJNA1108487_P_NODE_10355_length_245_cov_0.906977_g10289_i0 | PRJNA1108487 | 10355 | 245 | 0.906977 | 2.22209365 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 75.5 | 9.94e-14 | NR | CAD2185339.1 | 390850 | g10289 | i0 | 43.9 | 4.77551020408163 | 82 | 40 | 98 | 3 | 5 | 244 | 46 | 123 | CAD2185339.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 1170 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii |
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);;