contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA896554" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3422929 | 3422929 | PRJNA896554_P_NODE_72843_length_438_cov_1.054795_g65303_i0 | PRJNA896554 | 72843 | 438 | 1.054795 | 4.6200021 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 270 | 6.449999999999999e-90 | NR | AXS78234.1 | 6269 | g65303 | i0 | 89.7 | 113 | 146 | 15 | 100 | 0 | 1 | 438 | 19 | 164 | AXS78234.1 ras-related protein rab-1a [Anisakis simplex] | diamond | 49494 | 272 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anisakidae | Anisakis | Anisakis simplex | |
| 12351665 | 12351665 | PRJNA896554_P_NODE_97470_length_338_cov_2.898113_g89930_i0 | PRJNA896554 | 97470 | 338 | 2.898113 | 9.79562194 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 96.3 | 6.92e-21 | NR | KAF7633204.1 | 189291 | g89930 | i0 | 66.3 | 0.710059171597633 | 80 | 24 | 71 | 3 | 97 | 336 | 21 | 97 | KAF7633204.1 Aconitate hydratase, mitochondrial [Meloidogyne graminicola] | diamond | 240 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 15271725 | 15271725 | PRJNA896554_P_NODE_35312_length_1033_cov_6.054167_g28824_i0 | PRJNA896554 | 35312 | 1033 | 6.054167 | 62.53954511 | Bursaphelenchus okinawaensis | 465554 | Nematoda | Nematoda | 148 | 1.23e-38 | NR | CAD5214079.1 | 465554 | g28824 | i0 | 40.3 | 1.40851887705712 | 248 | 137 | 70.3 | 6 | 1029 | 304 | 7 | 249 | CAD5214079.1 unnamed protein product [Bursaphelenchus okinawaensis] | diamond | 1455 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus okinawaensis | |
| 25470487 | 25470487 | PRJNA896554_P_NODE_160460_length_247_cov_0.885057_g152920_i0 | PRJNA896554 | 160460 | 247 | 0.885057 | 2.18609079 | Anisakis simplex | 6269 | Nematoda | Nematoda | 121 | 1.73e-32 | NR | VDK59751.1 | 6269 | g152920 | i0 | 79.7 | 1.88259109311741 | 74 | 15 | 89.9 | 0 | 25 | 246 | 1 | 74 | VDK59751.1 unnamed protein product [Anisakis simplex] | diamond | 465 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anisakidae | Anisakis | Anisakis simplex | |
| 26992193 | 26992193 | PRJNA896554_P_NODE_30522_length_1220_cov_2.327812_g24671_i0 | PRJNA896554 | 30522 | 1220 | 2.327812 | 28.3993064 | Ditylenchus destructor | 166010 | Nematoda | Nematoda | 71.2 | 3.82e-10 | NR | KAI1714886.1 | 166010 | g24671 | i0 | 27.4 | 0.909836065573771 | 186 | 118 | 44.8 | 5 | 64 | 609 | 48 | 220 | KAI1714886.1 glycosyl hydrolases family 25 domain-containing protein [Ditylenchus destructor] | diamond | 1110 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 27213503 | 27213503 | PRJNA896554_P_NODE_55082_length_596_cov_1.535373_g47605_i0 | PRJNA896554 | 55082 | 596 | 1.535373 | 9.15082308 | Aphelenchoides avenae | 70226 | Nematoda | Nematoda | 121 | 1.88e-30 | NR | KAH7727115.1 | 70226 | g47605 | i0 | 57.6 | 0.463087248322148 | 92 | 39 | 46.3 | 0 | 279 | 4 | 123 | 214 | KAH7727115.1 glutaredoxin 2 [Aphelenchoides avenae] | diamond | 276 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 27466611 | 27466611 | PRJNA896554_P_NODE_164403_length_245_cov_0.895349_g156863_i0 | PRJNA896554 | 164403 | 245 | 0.895349 | 2.19360505 | Aphelenchoides besseyi | 269767 | Nematoda | Nematoda | 105 | 4.74e-26 | NR | KAI6205443.1 | 269767 | g156863 | i0 | 65.8 | 0.96734693877551 | 79 | 26 | 96.7 | 1 | 8 | 244 | 6 | 83 | KAI6205443.1 Maleylacetoacetate isomerase [Aphelenchoides besseyi] | diamond | 237 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 27560971 | 27560971 | PRJNA896554_P_NODE_113344_length_303_cov_1.052174_g105804_i0 | PRJNA896554 | 113344 | 303 | 1.052174 | 3.18808722 | Nippostrongylus brasiliensis | 27835 | Nematoda | Nematoda | 52 | 4.33e-5 | NR | VDL71397.1 | 27835 | g105804 | i0 | 51.2 | 1.1584158415841601 | 41 | 19 | 39.6 | 1 | 290 | 171 | 303 | 343 | VDL71397.1 unnamed protein product, partial [Nippostrongylus brasiliensis] | diamond | 351 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heligmosomidae | Nippostrongylus | Nippostrongylus brasiliensis | |
| 27656079 | 27656079 | PRJNA896554_P_NODE_27544_length_1358_cov_5.831907_g22138_i0 | PRJNA896554 | 27544 | 1358 | 5.831907 | 79.19729706 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 61.6 | 1.82e-6 | NR | AVZ46778.1 | 189291 | g22138 | i0 | 33.1 | 0.287187039764359 | 130 | 87 | 28.7 | 0 | 433 | 822 | 117 | 246 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 390 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 27782342 | 27782342 | PRJNA896554_P_NODE_119584_length_292_cov_1.054795_g112044_i0 | PRJNA896554 | 119584 | 292 | 1.054795 | 3.0800014 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 61.2 | 2.04e-8 | NR | NP_491324.1 | 6239 | g112044 | i0 | 34.9 | 3.67808219178082 | 86 | 53 | 87.3 | 3 | 258 | 4 | 117 | 200 | NP_491324.1 C-CAP/cofactor C-like domain-containing protein [Caenorhabditis elegans] | diamond | 1074 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 28674055 | 28674055 | PRJNA896554_P_NODE_141027_length_261_cov_1.952128_g133487_i0 | PRJNA896554 | 141027 | 261 | 1.952128 | 5.09505408 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 161 | 2.0399999999999998e-47 | NR | VDN07322.1 | 103827 | g133487 | i0 | 84.9 | 1.97701149425287 | 86 | 13 | 98.9 | 0 | 259 | 2 | 78 | 163 | VDN07322.1 unnamed protein product [Thelazia callipaeda] | diamond | 516 | 162 | 0.993827160493827 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Thelaziidae | Thelazia | Thelazia callipaeda | |
| 28800077 | 28800077 | PRJNA896554_P_NODE_162887_length_246_cov_0.890173_g155347_i0 | PRJNA896554 | 162887 | 246 | 0.890173 | 2.18982558 | Rhabditida | 6236 | Nematoda | Nematoda | 55.5 | 1.29e-6 | NR | KHN77764.1 | 6265 | g155347 | i0 | 50 | 10.5609756097561 | 48 | 24 | 58.5 | 0 | 144 | 1 | 184 | 231 | KHN77764.1 Polypyrimidine tract-binding protein 1 [Toxocara canis] | diamond | 2598 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 29392589 | 29392589 | PRJNA896554_P_NODE_157469_length_248_cov_0.880000_g149929_i0 | PRJNA896554 | 157469 | 248 | 0.88 | 2.1824 | Dirofilaria immitis | 6287 | Nematoda | Nematoda | 43.1 | 0.0212 | NR | MCP9262700.1 | 6287 | g149929 | i0 | 37.8 | 0.991935483870968 | 82 | 36 | 91.9 | 4 | 21 | 248 | 67 | 139 | MCP9262700.1 hypothetical protein [Dirofilaria immitis] | diamond | 246 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Dirofilaria | Dirofilaria immitis | |
| 29455239 | 29455239 | PRJNA896554_P_NODE_146190_length_255_cov_1.269231_g138650_i0 | PRJNA896554 | 146190 | 255 | 1.269231 | 3.23653905 | Necator americanus | 51031 | Nematoda | Nematoda | 60.1 | 3.25e-8 | NR | ETN81849.1 | 51031 | g138650 | i0 | 41.1 | 4.14117647058824 | 90 | 47 | 98.8 | 2 | 2 | 253 | 227 | 316 | ETN81849.1 HEAT repeat protein [Necator americanus] | diamond | 1056 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 29747231 | 29747231 | PRJNA896554_P_NODE_127390_length_280_cov_1.222222_g119850_i0 | PRJNA896554 | 127390 | 280 | 1.222222 | 3.4222216 | Nematoda | 6231 | Nematoda | Nematoda | 84 | 7.14e-17 | NR | KAF7640410.1 | 189291 | g119850 | i0 | 39.1 | 10.5428571428571 | 87 | 52 | 92.1 | 1 | 273 | 16 | 201 | 287 | KAF7640410.1 Autophagy-related protein 3 [Meloidogyne graminicola] | diamond | 2952 | 84.7 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 30568622 | 30568622 | PRJNA896554_P_NODE_65553_length_488_cov_1.963855_g58015_i0 | PRJNA896554 | 65553 | 488 | 1.963855 | 9.5836124 | root | 1 | Root_unresolved | Root_unresolved | 80.5 | 1.03e-15 | NR | CAD2192714.1 | 390850 | g58015 | i0 | 45.3 | 1.18647540983607 | 95 | 52 | 58.4 | 0 | 94 | 378 | 22 | 116 | CAD2192714.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 579 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 32015496 | 32015496 | PRJNA896554_P_NODE_30578_length_1217_cov_6.164336_g24716_i0 | PRJNA896554 | 30578 | 1217 | 6.164336 | 75.01996912 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 112 | 2.9e-24 | NR | AVZ46778.1 | 189291 | g24716 | i0 | 51.5 | 0.320460147904684 | 130 | 62 | 31.8 | 1 | 351 | 737 | 117 | 246 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 390 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola |
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);;