contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA1105232" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 212579 | 212579 | PRJNA1105232_S_NODE_4961_length_266_cov_1.299539_g4745_i0 | PRJNA1105232 | 4961 | 266 | 1.299539 | 3.45677374 | Mesorhabditis belari | 2138241 | Nematoda | Nematoda | 90.5 | 1.43e-20 | NR | CAJ0963925.1 | 2138241 | g4745 | i0 | 83.3 | 3.23684210526316 | 48 | 8 | 54.1 | 0 | 2 | 145 | 125 | 172 | CAJ0963925.1 unnamed protein product, partial [Mesorhabditis belari] | diamond | 861 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis belari | |
| 15515210 | 15515210 | PRJNA1105232_S_NODE_1833_length_387_cov_5.798817_g1617_i0 | PRJNA1105232 | 1833 | 387 | 5.798817 | 22.44142179 | Trichinella | 6333 | Nematoda | Nematoda | 151 | 6.24e-44 | NR | KAL1284361.1 | 6337 | g1617 | i0 | 56.7 | 10.2015503875969 | 120 | 51 | 92.2 | 1 | 26 | 382 | 38 | 157 | KAL1284361.1 Eukaryotic translation initiation factor [Trichinella pseudospiralis] | diamond | 3948 | 151 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella pseudospiralis | |
| 15515215 | 15515215 | PRJNA1105232_S_NODE_2233_length_361_cov_1.823718_g2017_i0 | PRJNA1105232 | 2233 | 361 | 1.823718 | 6.58362198 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 181 | 1.01e-51 | NR | NP_498263.2 | 6239 | g2017 | i0 | 81.9 | 4.38781163434903 | 105 | 19 | 87.3 | 0 | 359 | 45 | 426 | 530 | NP_498263.2 Putative aldehyde dehydrogenase family 7 member A1 homolog [Caenorhabditis elegans] | diamond | 1584 | 181 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 27596239 | 27596239 | PRJNA1105232_S_NODE_13944_length_175_cov_1.682540_g13728_i0 | PRJNA1105232 | 13944 | 175 | 1.68254 | 2.944445 | Metazoa | 33208 | Nematoda | Nematoda | 89.4 | 5.74e-19 | NR | GMR41334.1 | 1317129 | g13728 | i0 | 70.7 | 11.9142857142857 | 58 | 17 | 99.4 | 0 | 174 | 1 | 425 | 482 | GMR41334.1 hypothetical protein PMAYCL1PPCAC_11529, partial [Pristionchus mayeri] | diamond | 2085 | 90.1 | 0.992230854605993 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus mayeri | |
| 27699846 | 27699846 | PRJNA1105232_S_NODE_1544_length_413_cov_2.571429_g1329_i0 | PRJNA1105232 | 1544 | 413 | 2.571429 | 10.62000177 | Trichuris suis | 68888 | Nematoda | Nematoda | 61.2 | 7.27e-8 | NR | KHJ42158.1 | 68888 | g1329 | i0 | 29.9 | 5.94188861985472 | 134 | 86 | 91.5 | 2 | 383 | 6 | 126 | 259 | KHJ42158.1 Filamin/ABP280 repeat protein [Trichuris suis] | diamond | 2454 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 27825926 | 27825926 | PRJNA1105232_S_NODE_15604_length_168_cov_0.873950_g15388_i0 | PRJNA1105232 | 15604 | 168 | 0.87395 | 1.468236 | Trichinella papuae | 268474 | Nematoda | Nematoda | 77.4 | 7.71e-15 | NR | KRZ77476.1 | 268474 | g15388 | i0 | 68.9 | 12.8571428571429 | 45 | 14 | 80.4 | 0 | 1 | 135 | 398 | 442 | KRZ77476.1 Cysteine desulfurase, mitochondrial [Trichinella papuae] | diamond | 2160 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella papuae | |
| 29901156 | 29901156 | PRJNA1105232_S_NODE_15711_length_167_cov_1.940678_g15495_i0 | PRJNA1105232 | 15711 | 167 | 1.940678 | 3.24093226 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 44.3 | 0.00385 | NR | VBB27759.1 | 6277 | g15495 | i0 | 39.2 | 3.53892215568862 | 51 | 31 | 91.6 | 0 | 155 | 3 | 724 | 774 | VBB27759.1 unnamed protein product [Acanthocheilonema viteae] | diamond | 591 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Acanthocheilonema | Acanthocheilonema viteae | |
| 31173223 | 31173223 | PRJNA1105232_S_NODE_16675_length_164_cov_1.313043_g16459_i0 | PRJNA1105232 | 16675 | 164 | 1.313043 | 2.15339052 | Bursaphelenchus okinawaensis | 465554 | Nematoda | Nematoda | 72.4 | 4.38e-13 | NR | CAD5229356.1 | 465554 | g16459 | i0 | 54.7 | 2.90853658536585 | 53 | 24 | 97 | 0 | 1 | 159 | 169 | 221 | CAD5229356.1 unnamed protein product [Bursaphelenchus okinawaensis] | diamond | 477 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus okinawaensis | |
| 31544465 | 31544465 | PRJNA1105232_S_NODE_6676_length_237_cov_1.106383_g6460_i0 | PRJNA1105232 | 6676 | 237 | 1.106383 | 2.62212771 | Rhabditida | 6236 | Nematoda | Nematoda | 103 | 1.05e-24 | NR | BAB63947.1 | 6239 | g6460 | i0 | 62.8 | 9.87341772151899 | 78 | 29 | 98.7 | 0 | 236 | 3 | 196 | 273 | BAB63947.1 Ser/Thr protein phosphatase [Caenorhabditis elegans] | diamond | 2340 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 31955439 | 31955439 | PRJNA1105232_S_NODE_11957_length_187_cov_1.659420_g11741_i0 | PRJNA1105232 | 11957 | 187 | 1.65942 | 3.1031154 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 75.1 | 6.99e-14 | NR | MFH4974294.1 | 75299 | g11741 | i0 | 48.4 | 5.90374331550802 | 62 | 32 | 99.5 | 0 | 187 | 2 | 793 | 854 | MFH4974294.1 hypothetical protein [Gnathostoma spinigerum] | diamond | 1104 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gnathostomatidae | Gnathostoma | Gnathostoma spinigerum | |
| 32439164 | 32439164 | PRJNA1105232_S_NODE_11419_length_191_cov_1.098592_g11203_i0 | PRJNA1105232 | 11419 | 191 | 1.098592 | 2.09831072 | Soboliphyme baturini | 241478 | Nematoda | Nematoda | 48.9 | 1.25e-4 | NR | VDO95965.1 | 241478 | g11203 | i0 | 58.3 | 2.76439790575916 | 36 | 15 | 56.5 | 0 | 145 | 38 | 510 | 545 | VDO95965.1 unnamed protein product [Soboliphyme baturini] | diamond | 528 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini |
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);;