contig_metadata
11 rows where bioproject = "PRJNA1196384" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 322661 | 322661 | PRJNA1196384_S_NODE_1641_length_306_cov_2.918216_g1577_i0 | PRJNA1196384 | 1641 | 306 | 2.918216 | 8.92974096 | Metazoa | 33208 | Nematoda | Nematoda | 93.2 | 3.25e-22 | NR | VDO16994.1 | 42155 | g1577 | i0 | 65.6 | 9.53921568627451 | 64 | 22 | 62.7 | 0 | 305 | 114 | 33 | 96 | VDO16994.1 unnamed protein product [Brugia timori] | diamond | 2919 | 94 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia timori | |
| 5425828 | 5425828 | PRJNA1196384_S_NODE_1645_length_306_cov_1.702602_g1581_i0 | PRJNA1196384 | 1645 | 306 | 1.702602 | 5.20996212 | Nematoda | 6231 | Nematoda | Nematoda | 135 | 1.14e-35 | NR | KAF8355513.1 | 54126 | g1581 | i0 | 55 | 2.96078431372549 | 100 | 45 | 98 | 0 | 1 | 300 | 301 | 400 | KAF8355513.1 asp-3, partial [Pristionchus pacificus] | diamond | 906 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 13076312 | 13076312 | PRJNA1196384_S_NODE_4971_length_182_cov_1.806897_g4907_i0 | PRJNA1196384 | 4971 | 182 | 1.806897 | 3.28855254 | Bursaphelenchus | 6324 | Nematoda | Nematoda | 94 | 5.6100000000000005e-22 | NR | CAD5212188.1 | 6326 | g4907 | i0 | 68.3 | 2.96703296703297 | 60 | 19 | 98.9 | 0 | 181 | 2 | 34 | 93 | CAD5212188.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 540 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 18174361 | 18174361 | PRJNA1196384_S_NODE_7195_length_159_cov_0.950820_g7131_i0 | PRJNA1196384 | 7195 | 159 | 0.95082 | 1.5118038 | Bursaphelenchus okinawaensis | 465554 | Nematoda | Nematoda | 95.5 | 2.9700000000000003e-21 | NR | CAD5214912.1 | 465554 | g7131 | i0 | 80.8 | 2.94339622641509 | 52 | 10 | 98.1 | 0 | 3 | 158 | 157 | 208 | CAD5214912.1 unnamed protein product [Bursaphelenchus okinawaensis] | diamond | 468 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus okinawaensis | |
| 19448710 | 19448710 | PRJNA1196384_S_NODE_2736_length_234_cov_6.340102_g2672_i0 | PRJNA1196384 | 2736 | 234 | 6.340102 | 14.83583868 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 86.3 | 3.04e-20 | NR | KAK6031511.1 | 6317 | g2672 | i0 | 80.9 | 12.0512820512821 | 47 | 9 | 60.3 | 0 | 231 | 91 | 23 | 69 | KAK6031511.1 ribosomal protein S14p/S29e [Ostertagia ostertagi] | diamond | 2820 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Ostertagia | Ostertagia ostertagi | |
| 23274922 | 23274922 | PRJNA1196384_S_NODE_3419_length_212_cov_2.051429_g3355_i0 | PRJNA1196384 | 3419 | 212 | 2.051429 | 4.34902948 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 101 | 6.149999999999999e-23 | NR | KAF7639314.1 | 189291 | g3355 | i0 | 69.6 | 4.91037735849057 | 69 | 21 | 97.6 | 0 | 1 | 207 | 565 | 633 | KAF7639314.1 Tr-type G domain-containing protein [Meloidogyne graminicola] | diamond | 1041 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 26692555 | 26692555 | PRJNA1196384_S_NODE_1221_length_349_cov_4.516026_g1157_i0 | PRJNA1196384 | 1221 | 349 | 4.516026 | 15.76093074 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 52.4 | 5.29e-5 | NR | KAE9547610.1 | 2598192 | g1157 | i0 | 42 | 1.16905444126075 | 50 | 29 | 43 | 0 | 4 | 153 | 444 | 493 | KAE9547610.1 hypothetical protein FO519_009180 [Halicephalobus sp. NKZ332] | diamond | 408 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 | |
| 29365166 | 29365166 | PRJNA1196384_S_NODE_7709_length_155_cov_1.322034_g7645_i0 | PRJNA1196384 | 7709 | 155 | 1.322034 | 2.0491527 | Metazoa | 33208 | Nematoda | Nematoda | 72.4 | 3.82e-13 | NR | CAK18211.1 | 6253 | g7645 | i0 | 67.9 | 14.2064516129032 | 53 | 15 | 98.7 | 1 | 154 | 2 | 57 | 109 | CAK18211.1 putative disulphide isomerase [Ascaris suum] | diamond | 2202 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ascarididae | Ascaris | Ascaris suum | |
| 31810887 | 31810887 | PRJNA1196384_S_NODE_7117_length_159_cov_2.204918_g7053_i0 | PRJNA1196384 | 7117 | 159 | 2.204918 | 3.50581962 | Prionchulus punctatus | 293874 | Nematoda | Nematoda | 65.5 | 2.13e-11 | NR | ADK34019.1 | 293874 | g7053 | i0 | 59.6 | 9.52830188679245 | 47 | 19 | 88.7 | 0 | 157 | 17 | 114 | 160 | ADK34019.1 ubiquitin-Like family 1 [Prionchulus punctatus] | diamond | 1515 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Mononchida | Mononchidae | Prionchulus | Prionchulus punctatus | |
| 32209575 | 32209575 | PRJNA1196384_S_NODE_2418_length_249_cov_4.089623_g2354_i0 | PRJNA1196384 | 2418 | 249 | 4.089623 | 10.18316127 | Rhabditida | 6236 | Nematoda | Nematoda | 124 | 7.55e-33 | NR | KAF8357535.1 | 54126 | g2354 | i0 | 68.3 | 15.8192771084337 | 82 | 26 | 98.8 | 0 | 3 | 248 | 17 | 98 | KAF8357535.1 rps-1 [Pristionchus pacificus] | diamond | 3939 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 32273009 | 32273009 | PRJNA1196384_S_NODE_6558_length_164_cov_1.220472_g6494_i0 | PRJNA1196384 | 6558 | 164 | 1.220472 | 2.00157408 | Trichuris | 36086 | Nematoda | Nematoda | 82 | 1.68e-16 | NR | CDW58081.1 | 36087 | g6494 | i0 | 72.2 | 6.8780487804878 | 54 | 15 | 98.8 | 0 | 164 | 3 | 344 | 397 | CDW58081.1 vacuolar protein sorting associated protein 4A [Trichuris trichiura] | diamond | 1128 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura |
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);;