contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA927284" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9829632 | 9829632 | PRJNA927284_P_NODE_488_length_1158_cov_3.288751_g401_i0 | PRJNA927284 | 488 | 1158 | 3.288751 | 38.08373658 | Metazoa | 33208 | Nematoda | Nematoda | 331 | 1.73e-109 | NR | NP_509939.1 | 6239 | g401 | i0 | 72.7 | 14.0440414507772 | 249 | 63 | 64.5 | 2 | 1039 | 293 | 5 | 248 | NP_509939.1 14-3-3-like protein 2 [Caenorhabditis elegans] | diamond | 16263 | 334 | 0.991017964071856 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 11105455 | 11105455 | PRJNA927284_P_NODE_6209_length_215_cov_2.145161_g6002_i0 | PRJNA927284 | 6209 | 215 | 2.145161 | 4.61209615 | Rhabditida | 6236 | Nematoda | Nematoda | 130 | 3.34e-33 | NR | KAF8357382.1 | 54126 | g6002 | i0 | 88.7 | 3.96279069767442 | 71 | 8 | 99.1 | 0 | 213 | 1 | 77 | 147 | KAF8357382.1 aco-2 [Pristionchus pacificus] | diamond | 852 | 131 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 18753415 | 18753415 | PRJNA927284_P_NODE_255_length_1575_cov_24.416559_g184_i3 | PRJNA927284 | 255 | 1575 | 24.416559 | 384.56080425 | Nematoda | 6231 | Nematoda | Nematoda | 247 | 2.3899999999999995e-73 | NR | VDP12492.1 | 241478 | g184 | i3 | 39.8 | 4.26857142857143 | 342 | 174 | 64.6 | 7 | 220 | 1236 | 52 | 364 | VDP12492.1 unnamed protein product [Soboliphyme baturini] | diamond | 6723 | 248 | 0.995967741935484 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 18753464 | 18753464 | PRJNA927284_P_NODE_995_length_768_cov_3.768606_g861_i0 | PRJNA927284 | 995 | 768 | 3.768606 | 28.94289408 | Metazoa | 33208 | Nematoda | Nematoda | 308 | 2.38e-92 | NR | KAL1235837.1 | 6337 | g861 | i0 | 70 | 66.59765625 | 203 | 61 | 79.3 | 0 | 768 | 160 | 650 | 852 | KAL1235837.1 Elongation factor [Trichinella pseudospiralis] | diamond | 51147 | 309 | 0.996763754045307 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella pseudospiralis | |
| 26842280 | 26842280 | PRJNA927284_P_NODE_261_length_1559_cov_24.541176_g184_i4 | PRJNA927284 | 261 | 1559 | 24.541176 | 382.59693384 | Nematoda | 6231 | Nematoda | Nematoda | 247 | 2.04e-73 | NR | VDP12492.1 | 241478 | g184 | i4 | 39.8 | 4.31237973059654 | 342 | 174 | 65.2 | 7 | 1340 | 324 | 52 | 364 | VDP12492.1 unnamed protein product [Soboliphyme baturini] | diamond | 6723 | 248 | 0.995967741935484 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 28074185 | 28074185 | PRJNA927284_P_NODE_225_length_1631_cov_23.654182_g184_i0 | PRJNA927284 | 225 | 1631 | 23.654182 | 385.79970842 | Nematoda | 6231 | Nematoda | Nematoda | 247 | 3.81e-73 | NR | VDP12492.1 | 241478 | g184 | i0 | 39.8 | 3.98773758430411 | 342 | 174 | 62.4 | 7 | 1126 | 110 | 52 | 364 | VDP12492.1 unnamed protein product [Soboliphyme baturini] | diamond | 6504 | 248 | 0.995967741935484 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 28705887 | 28705887 | PRJNA927284_P_NODE_227_length_1627_cov_23.284105_g184_i1 | PRJNA927284 | 227 | 1627 | 23.284105 | 378.83238835 | Nematoda | 6231 | Nematoda | Nematoda | 247 | 3.7200000000000005e-73 | NR | VDP12492.1 | 241478 | g184 | i1 | 39.8 | 3.99754148740012 | 342 | 174 | 62.5 | 7 | 1126 | 110 | 52 | 364 | VDP12492.1 unnamed protein product [Soboliphyme baturini] | diamond | 6504 | 248 | 0.995967741935484 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 29463138 | 29463138 | PRJNA927284_P_NODE_8630_length_163_cov_1.582090_g8423_i0 | PRJNA927284 | 8630 | 163 | 1.58209 | 2.5788067 | Metazoa | 33208 | Nematoda | Nematoda | 88.6 | 8.18e-19 | NR | KHN79434.1 | 6265 | g8423 | i0 | 77.8 | 4.96932515337423 | 54 | 12 | 99.4 | 0 | 2 | 163 | 156 | 209 | KHN79434.1 Nicotinamide phosphoribosyltransferase [Toxocara canis] | diamond | 810 | 89 | 0.995505617977528 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 29874061 | 29874061 | PRJNA927284_P_NODE_1251_length_674_cov_3.308527_g1109_i0 | PRJNA927284 | 1251 | 674 | 3.308527 | 22.29947198 | Rhabditida | 6236 | Nematoda | Nematoda | 104 | 3e-24 | NR | KHN79685.1 | 6265 | g1109 | i0 | 52.9 | 2.95548961424332 | 87 | 41 | 38.7 | 0 | 298 | 558 | 79 | 165 | KHN79685.1 Lipopolysaccharide-induced tumor necrosis factor-alpha factor -like protein [Toxocara canis] | diamond | 1992 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 30568791 | 30568791 | PRJNA927284_P_NODE_9133_length_154_cov_1.304000_g8926_i0 | PRJNA927284 | 9133 | 154 | 1.304 | 2.00816 | Metazoa | 33208 | Nematoda | Nematoda | 47 | 3.57e-4 | NR | EFP03578.1 | 31234 | g8926 | i0 | 41.2 | 2.84415584415584 | 51 | 30 | 99.4 | 0 | 1 | 153 | 367 | 417 | EFP03578.1 CRE-CYP-13B2 protein [Caenorhabditis remanei] | diamond | 438 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 30853417 | 30853417 | PRJNA927284_P_NODE_254_length_1579_cov_23.834194_g184_i2 | PRJNA927284 | 254 | 1579 | 23.834194 | 376.34192326 | Nematoda | 6231 | Nematoda | Nematoda | 247 | 2.45e-73 | NR | VDP12492.1 | 241478 | g184 | i2 | 39.8 | 4.25775807473084 | 342 | 174 | 64.4 | 7 | 1126 | 110 | 52 | 364 | VDP12492.1 unnamed protein product [Soboliphyme baturini] | diamond | 6723 | 248 | 0.995967741935484 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 31067597 | 31067597 | PRJNA927284_P_NODE_2275_length_460_cov_2.733179_g2083_i0 | PRJNA927284 | 2275 | 460 | 2.733179 | 12.5726234 | Aphelenchoides besseyi | 269767 | Nematoda | Nematoda | 44.3 | 0.0322 | NR | KAI6179932.1 | 269767 | g2083 | i0 | 34.2 | 0.723913043478261 | 111 | 46 | 72.4 | 7 | 115 | 447 | 45 | 128 | KAI6179932.1 hypothetical protein M3Y98_00664500 [Aphelenchoides besseyi] | diamond | 333 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 32435063 | 32435063 | PRJNA927284_P_NODE_6859_length_197_cov_2.595238_g6652_i0 | PRJNA927284 | 6859 | 197 | 2.595238 | 5.11261886 | Ancylostomatidae | 33278 | Nematoda | Nematoda | 109 | 3.5e-29 | NR | RCN44164.1 | 29170 | g6652 | i0 | 78.1 | 6.82233502538071 | 64 | 14 | 97.5 | 0 | 6 | 197 | 31 | 94 | RCN44164.1 chaperonin GroS [Ancylostoma caninum] | diamond | 1344 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma caninum | |
| 32490998 | 32490998 | PRJNA927284_P_NODE_3699_length_329_cov_1.940000_g3494_i0 | PRJNA927284 | 3699 | 329 | 1.94 | 6.3826 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 62 | 1.7e-8 | NR | KAE9554159.1 | 2598192 | g3494 | i0 | 34.3 | 1.92401215805471 | 99 | 60 | 87.5 | 4 | 329 | 42 | 112 | 208 | KAE9554159.1 hypothetical protein FO519_002639 [Halicephalobus sp. NKZ332] | diamond | 633 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 | |
| 32869019 | 32869019 | PRJNA927284_P_NODE_5040_length_256_cov_2.651982_g4833_i0 | PRJNA927284 | 5040 | 256 | 2.651982 | 6.78907392 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 61.2 | 1.32e-8 | NR | CAD5226188.1 | 6326 | g4833 | i0 | 37.7 | 2.6484375 | 77 | 48 | 90.2 | 0 | 2 | 232 | 269 | 345 | CAD5226188.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 678 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus |
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);;