contig_metadata
14 rows where bioproject = "PRJNA345071" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2943930 | 2943930 | PRJNA345071_P_NODE_11303_length_227_cov_2.084416_g11263_i0 | PRJNA345071 | 11303 | 227 | 2.084416 | 4.73162432 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 78.7 | 3.34e-10 | NTclustered | gi|2445352248|ref|XM_053723719.1| | 31234 | g11263 | i0 | 89.231 | 0.850220264317181 | 65 | 4 | 28 | 3 | 155 | 217 | 282 | 219 | Caenorhabditis remanei uncharacterized protein (GCK72_002963), partial mRNA | blastn | 193 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 4220544 | 4220544 | PRJNA345071_P_NODE_1464_length_455_cov_3.510471_g1424_i0 | PRJNA345071 | 1464 | 455 | 3.510471 | 15.97264305 | Metazoa | 33208 | Nematoda | Nematoda | 98.6 | 5.759999999999999e-23 | NR | VDK78877.1 | 42156 | g1424 | i0 | 78.5 | 6.41538461538462 | 65 | 14 | 42.9 | 0 | 453 | 259 | 88 | 152 | VDK78877.1 unnamed protein product [Litomosoides sigmodontis] | diamond | 2919 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Litomosoides | Litomosoides sigmodontis | |
| 11871978 | 11871978 | PRJNA345071_P_NODE_4270_length_305_cov_2.689655_g4230_i0 | PRJNA345071 | 4270 | 305 | 2.689655 | 8.20344775 | Angiostrongylus cantonensis | 6313 | Nematoda | Nematoda | 119 | 6.14e-29 | NR | KAE9418459.1 | 6313 | g4230 | i0 | 64.6 | 10.0131147540984 | 96 | 33 | 94.4 | 1 | 16 | 303 | 187 | 281 | KAE9418459.1 hypothetical protein Angca_009785 [Angiostrongylus cantonensis] | diamond | 3054 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Angiostrongylus | Angiostrongylus cantonensis | |
| 15098209 | 15098209 | PRJNA345071_P_NODE_9812_length_245_cov_0.906977_g9772_i0 | PRJNA345071 | 9812 | 245 | 0.906977 | 2.22209365 | Onchocercidae | 6296 | Nematoda | Nematoda | 136 | 1.09e-39 | NR | CDQ08417.1 | 6279 | g9772 | i0 | 75.3 | 18.8448979591837 | 81 | 20 | 99.2 | 0 | 245 | 3 | 1 | 81 | CDQ08417.1 Bm12763, partial [Brugia malayi] | diamond | 4617 | 137 | 0.992700729927007 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 22747298 | 22747298 | PRJNA345071_P_NODE_2138_length_389_cov_2.060127_g2098_i0 | PRJNA345071 | 2138 | 389 | 2.060127 | 8.01389403 | Dracunculus medinensis | 318479 | Nematoda | Nematoda | 206 | 1.48e-65 | NR | VDN59360.1 | 318479 | g2098 | i0 | 83.2 | 9.57840616966581 | 125 | 21 | 96.4 | 0 | 14 | 388 | 18 | 142 | VDN59360.1 unnamed protein product [Dracunculus medinensis] | diamond | 3726 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Dracunculidae | Dracunculus | Dracunculus medinensis | |
| 24619603 | 24619603 | PRJNA345071_P_NODE_7720_length_253_cov_0.866667_g7680_i0 | PRJNA345071 | 7720 | 253 | 0.866667 | 2.19266751 | Dirofilaria immitis | 6287 | Nematoda | Nematoda | 80.5 | 1.05e-10 | NTclustered | gi|1774710611|gb|MK820661.1| | 6287 | g7680 | i0 | 90.164 | 1.8102766798419 | 61 | 6 | 24 | 0 | 183 | 243 | 92 | 32 | Dirofilaria immitis nuclear hormone receptor DAF-12a mRNA, complete cds | blastn | 458 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Dirofilaria | Dirofilaria immitis | |
| 27043151 | 27043151 | PRJNA345071_P_NODE_10742_length_242_cov_0.923077_g10702_i0 | PRJNA345071 | 10742 | 242 | 0.923077 | 2.23384634 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 64.3 | 9.08e-10 | NR | CAD5234749.1 | 6326 | g10702 | i0 | 46.9 | 4.47520661157025 | 49 | 26 | 60.7 | 0 | 188 | 42 | 368 | 416 | CAD5234749.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 1083 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 27502909 | 27502909 | PRJNA345071_P_NODE_10623_length_242_cov_1.810651_g10583_i0 | PRJNA345071 | 10623 | 242 | 1.810651 | 4.38177542 | Steinernema | 34507 | Nematoda | Nematoda | 129 | 9.62e-33 | NR | TMS36883.1 | 34508 | g10583 | i0 | 81.3 | 22.797520661157 | 80 | 15 | 99.2 | 0 | 2 | 241 | 409 | 488 | TMS36883.1 hypothetical protein L596_003949 [Steinernema carpocapsae] | diamond | 5517 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 29807546 | 29807546 | PRJNA345071_P_NODE_3731_length_321_cov_1.217742_g3691_i0 | PRJNA345071 | 3731 | 321 | 1.217742 | 3.90895182 | Metazoa | 33208 | Nematoda | Nematoda | 113 | 6.09e-29 | NR | CDJ81780.1 | 6289 | g3691 | i0 | 64.3 | 9.25233644859813 | 84 | 30 | 78.5 | 0 | 57 | 308 | 1 | 84 | CDJ81780.1 Glutathione S-transferase domain containing protein [Haemonchus contortus] | diamond | 2970 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Haemonchus | Haemonchus contortus | |
| 31623345 | 31623345 | PRJNA345071_P_NODE_9916_length_245_cov_0.906977_g9876_i0 | PRJNA345071 | 9916 | 245 | 0.906977 | 2.22209365 | Wuchereria bancrofti | 6293 | Nematoda | Nematoda | 50.4 | 7.33e-5 | NR | VDM20661.1 | 6293 | g9876 | i0 | 36.3 | 0.979591836734694 | 80 | 49 | 98 | 1 | 4 | 243 | 68 | 145 | VDM20661.1 unnamed protein product [Wuchereria bancrofti] | diamond | 240 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 31798521 | 31798521 | PRJNA345071_P_NODE_7737_length_253_cov_0.866667_g7697_i0 | PRJNA345071 | 7737 | 253 | 0.866667 | 2.19266751 | Metazoa | 33208 | Nematoda | Nematoda | 59.3 | 6.01e-8 | NR | CAL2031754.1 | 135651 | g7697 | i0 | 48 | 5.47826086956522 | 50 | 25 | 59.3 | 1 | 99 | 248 | 16 | 64 | CAL2031754.1 unnamed protein product [Caenorhabditis brenneri] | diamond | 1386 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis brenneri | |
| 31988477 | 31988477 | PRJNA345071_P_NODE_5818_length_277_cov_1.397059_g5778_i0 | PRJNA345071 | 5818 | 277 | 1.397059 | 3.86985343 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 78.6 | 1.41e-14 | NR | KHN85536.1 | 6265 | g5778 | i0 | 63.6 | 4.11552346570397 | 55 | 20 | 59.6 | 0 | 167 | 3 | 3 | 57 | KHN85536.1 Dynactin subunit 1 [Toxocara canis] | diamond | 1140 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 32210061 | 32210061 | PRJNA345071_P_NODE_5498_length_282_cov_1.492823_g5458_i0 | PRJNA345071 | 5498 | 282 | 1.492823 | 4.20976086 | Trichinella | 6333 | Nematoda | Nematoda | 128 | 3.9699999999999996e-32 | NR | KAL1245750.1 | 6334 | g5458 | i0 | 71.1 | 1.91489361702128 | 90 | 26 | 95.7 | 0 | 3 | 272 | 597 | 686 | KAL1245750.1 NAD(P) transhydrogenase [Trichinella spiralis] | diamond | 540 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 32572733 | 32572733 | PRJNA345071_P_NODE_9839_length_245_cov_0.906977_g9799_i0 | PRJNA345071 | 9839 | 245 | 0.906977 | 2.22209365 | Aphelenchoides avenae | 70226 | Nematoda | Nematoda | 110 | 4.12e-26 | NR | KAH7724663.1 | 70226 | g9799 | i0 | 65.9 | 1.00408163265306 | 82 | 27 | 99.2 | 1 | 3 | 245 | 321 | 402 | KAH7724663.1 splicing factor 3B subunit 1 [Aphelenchoides avenae] | diamond | 246 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae |
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);;