contig_metadata
20 rows where bioproject = "PRJEB76780", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3547012 | 3547012 | PRJEB76780_P_NODE_3283_length_451_cov_1.211640_g3183_i0 | PRJEB76780 | 3283 | 451 | 1.21164 | 5.4644964 | Metazoa | 33208 | Nematoda | Nematoda | 295 | 3.32e-98 | NR | KHN74890.1 | 6265 | g3183 | i0 | 88 | 229.483370288248 | 150 | 18 | 99.8 | 0 | 450 | 1 | 89 | 238 | KHN74890.1 Serine/threonine-protein phosphatase PP2A [Toxocara canis] | diamond | 103497 | 296 | 0.996621621621622 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 6099589 | 6099589 | PRJEB76780_P_NODE_2465_length_522_cov_4.881960_g2365_i0 | PRJEB76780 | 2465 | 522 | 4.88196 | 25.4838312 | Pristionchus | 54125 | Nematoda | Nematoda | 154 | 1.36e-32 | NTclustered | gi|524845312|gb|KC819366.1| | 1355913 | g2365 | i0 | 80.18 | 22.2816091954023 | 222 | 30 | 41 | 11 | 89 | 303 | 49 | 263 | Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds | blastn | 11631 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus hoplostomus | |
| 6516939 | 6516939 | PRJEB76780_P_NODE_666_length_998_cov_5.457297_g596_i0 | PRJEB76780 | 666 | 998 | 5.457297 | 54.46382406 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 377 | 1.4699999999999999e-99 | NTclustered | gi|1377671584|gb|MF166622.1| | 189291 | g596 | i0 | 80.903 | 0.487975951903808 | 487 | 85 | 48 | 5 | 348 | 827 | 271 | 756 | Meloidogyne graminicola clone Mg4610 hypothetical protein mRNA, complete cds | blastn | 487 | 377 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 6516947 | 6516947 | PRJEB76780_P_NODE_7706_length_291_cov_1.357798_g7606_i0 | PRJEB76780 | 7706 | 291 | 1.357798 | 3.95119218 | Metazoa | 33208 | Nematoda | Nematoda | 124 | 1.02e-30 | NR | KRX98865.1 | 6337 | g7606 | i0 | 70.5 | 8.6701030927835 | 95 | 25 | 96.9 | 3 | 3 | 284 | 31 | 123 | KRX98865.1 putative aconitate hydratase, mitochondrial [Trichinella pseudospiralis] | diamond | 2523 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella pseudospiralis | |
| 11617276 | 11617276 | PRJEB76780_P_NODE_2370_length_536_cov_5.717063_g2270_i0 | PRJEB76780 | 2370 | 536 | 5.717063 | 30.64345768 | Opisthokonta | 33154 | Nematoda | Nematoda | 216 | 1.9999999999999993e-68 | NR | KFD50978.1 | 68888 | g2270 | i0 | 71.6 | 16.8973880597015 | 148 | 42 | 82.8 | 0 | 526 | 83 | 51 | 198 | KFD50978.1 hypothetical protein M513_08161, partial [Trichuris suis] | diamond | 9057 | 216 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 11617304 | 11617304 | PRJEB76780_P_NODE_5430_length_347_cov_1.671533_g5330_i0 | PRJEB76780 | 5430 | 347 | 1.671533 | 5.80021951 | Metazoa | 33208 | Nematoda | Nematoda | 159 | 1.1099999999999998e-47 | NR | ULT99372.1 | 6238 | g5330 | i0 | 86 | 170.740634005764 | 86 | 12 | 74.4 | 0 | 27 | 284 | 41 | 126 | ULT99372.1 hypothetical protein L3Y34_000603 [Caenorhabditis briggsae] | diamond | 59247 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 16715463 | 16715463 | PRJEB76780_P_NODE_3074_length_467_cov_6.741117_g2974_i0 | PRJEB76780 | 3074 | 467 | 6.741117 | 31.48101639 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 281 | 5.32e-71 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g2974 | i0 | 80.939 | 4.34903640256959 | 362 | 63 | 77 | 6 | 63 | 421 | 37 | 395 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 2031 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 26773808 | 26773808 | PRJEB76780_P_NODE_10501_length_252_cov_1.430168_g10401_i0 | PRJEB76780 | 10501 | 252 | 1.430168 | 3.60402336 | Opisthokonta | 33154 | Nematoda | Nematoda | 62.4 | 1.88e-9 | NR | TMS36011.1 | 34508 | g10401 | i0 | 61.7 | 7.59523809523809 | 47 | 17 | 56 | 1 | 6 | 146 | 173 | 218 | TMS36011.1 hypothetical protein L596_003282 [Steinernema carpocapsae] | diamond | 1914 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 27445349 | 27445349 | PRJEB76780_P_NODE_1843_length_613_cov_1.311111_g1744_i0 | PRJEB76780 | 1843 | 613 | 1.311111 | 8.03711043 | Trichostrongylus colubriformis | 6319 | Nematoda | Nematoda | 145 | 3.83e-38 | NR | KAK5974013.1 | 6319 | g1744 | i0 | 41 | 6.24959216965742 | 212 | 113 | 99.8 | 4 | 613 | 2 | 162 | 369 | KAK5974013.1 3-hydroxyisobutyryl-CoA hydrolase mitochondrial [Trichostrongylus colubriformis] | diamond | 3831 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Trichostrongylus | Trichostrongylus colubriformis | |
| 27476624 | 27476624 | PRJEB76780_P_NODE_10643_length_252_cov_0.871508_g10543_i0 | PRJEB76780 | 10643 | 252 | 0.871508 | 2.19620016 | Pristionchus mayeri | 1317129 | Nematoda | Nematoda | 50.4 | 7.87e-5 | NR | GMR36589.1 | 1317129 | g10543 | i0 | 41.9 | 0.738095238095238 | 62 | 33 | 70.2 | 1 | 184 | 8 | 354 | 415 | GMR36589.1 hypothetical protein PMAYCL1PPCAC_06784, partial [Pristionchus mayeri] | diamond | 186 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus mayeri | |
| 27887035 | 27887035 | PRJEB76780_P_NODE_665_length_999_cov_2.077754_g595_i0 | PRJEB76780 | 665 | 999 | 2.077754 | 20.75676246 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 78.2 | 2.08e-12 | NR | AVZ46778.1 | 189291 | g595 | i0 | 37.9 | 0.396396396396396 | 132 | 82 | 39.6 | 0 | 424 | 29 | 110 | 241 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 396 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 28826837 | 28826837 | PRJEB76780_P_NODE_9808_length_259_cov_1.672043_g9708_i0 | PRJEB76780 | 9808 | 259 | 1.672043 | 4.33059137 | Aphelenchoides | 90723 | Nematoda | Nematoda | 67 | 1.33e-10 | NR | KAI6171470.1 | 293665 | g9708 | i0 | 52.9 | 1.42471042471042 | 68 | 26 | 71.8 | 1 | 196 | 11 | 4 | 71 | KAI6171470.1 hypothetical protein M3Y97_01048000 [Aphelenchoides bicaudatus] | diamond | 369 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides bicaudatus | |
| 30002809 | 30002809 | PRJEB76780_P_NODE_10231_length_253_cov_1.388889_g10131_i0 | PRJEB76780 | 10231 | 253 | 1.388889 | 3.51388917 | Mesorhabditis belari | 2138241 | Nematoda | Nematoda | 58.5 | 1.15e-7 | NR | CAJ0950752.1 | 2138241 | g10131 | i0 | 50 | 2.15810276679842 | 56 | 28 | 66.4 | 0 | 184 | 17 | 21 | 76 | CAJ0950752.1 unnamed protein product, partial [Mesorhabditis belari] | diamond | 546 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis belari | |
| 30027091 | 30027091 | PRJEB76780_P_NODE_11411_length_249_cov_0.886364_g11311_i0 | PRJEB76780 | 11411 | 249 | 0.886364 | 2.20704636 | Rhabditida | 6236 | Nematoda | Nematoda | 62 | 6.66e-9 | NR | XP_020305783.1 | 7209 | g11311 | i0 | 50.9 | 1.96385542168675 | 57 | 28 | 68.7 | 0 | 171 | 1 | 139 | 195 | XP_020305783.1 La domain-containing protein [Loa loa] | diamond | 489 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Loa | Loa loa | |
| 30255744 | 30255744 | PRJEB76780_P_NODE_9672_length_261_cov_1.244681_g9572_i0 | PRJEB76780 | 9672 | 261 | 1.244681 | 3.24861741 | Heterodera schachtii | 97005 | Nematoda | Nematoda | 65.9 | 2.64e-10 | NR | KAL3068799.1 | 97005 | g9572 | i0 | 41.8 | 1.1264367816092 | 98 | 43 | 97.7 | 3 | 259 | 5 | 151 | 247 | KAL3068799.1 hypothetical protein niasHS_017365 [Heterodera schachtii] | diamond | 294 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera schachtii | |
| 30666087 | 30666087 | PRJEB76780_P_NODE_8913_length_272_cov_1.175879_g8813_i0 | PRJEB76780 | 8913 | 272 | 1.175879 | 3.19839088 | Auanema sp. JU1783 | 2878363 | Nematoda | Nematoda | 95.9 | 1.06e-20 | NR | CAI4231966.1 | 2878363 | g8813 | i0 | 59.3 | 3.86029411764706 | 91 | 34 | 98.2 | 2 | 269 | 3 | 141 | 230 | CAI4231966.1 unnamed protein product [Auanema sp. JU1783] | diamond | 1050 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Auanema | Auanema sp. JU1783 | |
| 30761017 | 30761017 | PRJEB76780_P_NODE_10114_length_255_cov_1.285714_g10014_i0 | PRJEB76780 | 10114 | 255 | 1.285714 | 3.2785707 | Ditylenchus destructor | 166010 | Nematoda | Nematoda | 95.1 | 1.56e-20 | NR | KAI1722464.1 | 166010 | g10014 | i0 | 65.6 | 2.91764705882353 | 64 | 22 | 75.3 | 0 | 196 | 5 | 470 | 533 | KAI1722464.1 histone deacetylase domain-containing protein [Ditylenchus destructor] | diamond | 744 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 31733517 | 31733517 | PRJEB76780_P_NODE_1717_length_632_cov_2.085868_g1620_i0 | PRJEB76780 | 1717 | 632 | 2.085868 | 13.18268576 | Metazoa | 33208 | Nematoda | Nematoda | 232 | 4.56e-74 | NR | AXS78234.1 | 6269 | g1620 | i0 | 96.5 | 61.2199367088608 | 115 | 4 | 54.6 | 0 | 346 | 2 | 1 | 115 | AXS78234.1 ras-related protein rab-1a [Anisakis simplex] | diamond | 38691 | 234 | 0.991452991452991 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anisakidae | Anisakis | Anisakis simplex | |
| 31994051 | 31994051 | PRJEB76780_P_NODE_11478_length_249_cov_0.886364_g11378_i0 | PRJEB76780 | 11478 | 249 | 0.886364 | 2.20704636 | Auanema sp. JU1783 | 2878363 | Nematoda | Nematoda | 48.9 | 2.69e-4 | NR | CAI4223838.1 | 2878363 | g11378 | i0 | 32.3 | 0.783132530120482 | 65 | 40 | 73.5 | 1 | 27 | 209 | 311 | 375 | CAI4223838.1 unnamed protein product [Auanema sp. JU1783] | diamond | 195 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Auanema | Auanema sp. JU1783 | |
| 32184008 | 32184008 | PRJEB76780_P_NODE_4058_length_405_cov_1.644578_g3958_i0 | PRJEB76780 | 4058 | 405 | 1.644578 | 6.6605409 | Loa loa | 7209 | Nematoda | Nematoda | 45.1 | 0.0207 | NR | XP_020301776.1 | 7209 | g3958 | i0 | 39.6 | 0.392592592592593 | 53 | 29 | 37 | 1 | 256 | 405 | 108 | 160 | XP_020301776.1 hypothetical protein LOAG_09909 [Loa loa] | diamond | 159 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Loa | Loa loa |
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);;