contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1025141" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2279388 | 2279388 | PRJNA1025141_P_NODE_9042_length_257_cov_1.114130_g8981_i0 | PRJNA1025141 | 9042 | 257 | 1.11413 | 2.8633141 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 67.4 | 9.06e-11 | NR | KAE9553376.1 | 2598192 | g8981 | i0 | 39.3 | 0.980544747081712 | 84 | 37 | 84 | 2 | 3 | 218 | 457 | 538 | KAE9553376.1 hypothetical protein FO519_003439 [Halicephalobus sp. NKZ332] | diamond | 252 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 | |
| 12916495 | 12916495 | PRJNA1025141_P_NODE_2031_length_577_cov_1.339286_g1971_i0 | PRJNA1025141 | 2031 | 577 | 1.339286 | 7.72768022 | Pristionchus pacificus | 54126 | Nematoda | Nematoda | 241 | 8.759999999999999e-72 | NR | KAF8357382.1 | 54126 | g1971 | i0 | 75.5 | 12.3119584055459 | 155 | 38 | 80.6 | 0 | 466 | 2 | 30 | 184 | KAF8357382.1 aco-2 [Pristionchus pacificus] | diamond | 7104 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 13757534 | 13757534 | PRJNA1025141_P_NODE_2291_length_539_cov_3.826180_g2230_i0 | PRJNA1025141 | 2291 | 539 | 3.82618 | 20.6231102 | Opisthokonta | 33154 | Nematoda | Nematoda | 215 | 5.949999999999999e-68 | NR | KFD50978.1 | 68888 | g2230 | i0 | 71.6 | 19.8701298701299 | 148 | 42 | 82.4 | 0 | 533 | 90 | 51 | 198 | KFD50978.1 hypothetical protein M513_08161, partial [Trichuris suis] | diamond | 10710 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 16739721 | 16739721 | PRJNA1025141_P_NODE_2754_length_493_cov_1.857143_g2693_i0 | PRJNA1025141 | 2754 | 493 | 1.857143 | 9.15571499 | Metazoa | 33208 | Nematoda | Nematoda | 143 | 6.079999999999999e-37 | NR | KAH7732279.1 | 70226 | g2693 | i0 | 58.3 | 3.05476673427992 | 120 | 43 | 68.8 | 1 | 374 | 36 | 26 | 145 | KAH7732279.1 procollagen-proline dioxygenase beta subunit [Aphelenchoides avenae] | diamond | 1506 | 144 | 0.993055555555556 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 27919382 | 27919382 | PRJNA1025141_P_NODE_10085_length_249_cov_0.875000_g10024_i0 | PRJNA1025141 | 10085 | 249 | 0.875 | 2.17875 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 58.9 | 7.31e-8 | NR | GMT10917.1 | 1538716 | g10024 | i0 | 58.8 | 0.819277108433735 | 68 | 28 | 81.9 | 0 | 14 | 217 | 73 | 140 | GMT10917.1 hypothetical protein PFISCL1PPCAC_2214, partial [Pristionchus fissidentatus] | diamond | 204 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 28140739 | 28140739 | PRJNA1025141_P_NODE_505_length_1103_cov_22.432039_g473_i0 | PRJNA1025141 | 505 | 1103 | 22.432039 | 247.42539016999999 | Ditylenchus destructor | 166010 | Nematoda | Nematoda | 191 | 8.5e-54 | NR | KAI1709910.1 | 166010 | g473 | i0 | 37.4 | 0.908431550317316 | 334 | 166 | 88.4 | 12 | 81 | 1055 | 39 | 338 | KAI1709910.1 papain family cysteine protease domain-containing protein [Ditylenchus destructor] | diamond | 1002 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 28582641 | 28582641 | PRJNA1025141_P_NODE_9607_length_251_cov_0.865169_g9546_i0 | PRJNA1025141 | 9607 | 251 | 0.865169 | 2.17157419 | Steinernema carpocapsae | 34508 | Nematoda | Nematoda | 62.4 | 4.83e-9 | NR | TKR64459.1 | 34508 | g9546 | i0 | 37.3 | 1.92430278884462 | 83 | 52 | 99.2 | 0 | 3 | 251 | 138 | 220 | TKR64459.1 hypothetical protein L596_024986 [Steinernema carpocapsae] | diamond | 483 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 28771900 | 28771900 | PRJNA1025141_P_NODE_10747_length_247_cov_1.563218_g10686_i0 | PRJNA1025141 | 10747 | 247 | 1.563218 | 3.86114846 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 105 | 4.38e-24 | NR | NP_001366774.1 | 6239 | g10686 | i0 | 59.3 | 4.91902834008097 | 81 | 33 | 98.4 | 0 | 245 | 3 | 599 | 679 | NP_001366774.1 Isoleucine--tRNA ligase, cytoplasmic [Caenorhabditis elegans] | diamond | 1215 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 29561165 | 29561165 | PRJNA1025141_P_NODE_12390_length_243_cov_0.905882_g12329_i0 | PRJNA1025141 | 12390 | 243 | 0.905882 | 2.20129326 | Anisakis simplex | 6269 | Nematoda | Nematoda | 44.7 | 0.00767 | NR | VDK55644.1 | 6269 | g12329 | i0 | 32.4 | 0.876543209876543 | 71 | 47 | 86.4 | 1 | 14 | 223 | 552 | 622 | VDK55644.1 unnamed protein product [Anisakis simplex] | diamond | 213 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anisakidae | Anisakis | Anisakis simplex | |
| 29687274 | 29687274 | PRJNA1025141_P_NODE_5290_length_350_cov_2.184116_g5229_i0 | PRJNA1025141 | 5290 | 350 | 2.184116 | 7.644406 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 115 | 5.15e-28 | NR | KAF7639490.1 | 189291 | g5229 | i0 | 53.2 | 5.18571428571429 | 94 | 44 | 80.6 | 0 | 68 | 349 | 249 | 342 | KAF7639490.1 hypothetical protein Mgra_00001167 [Meloidogyne graminicola] | diamond | 1815 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 31203586 | 31203586 | PRJNA1025141_P_NODE_5295_length_350_cov_1.487365_g5234_i0 | PRJNA1025141 | 5295 | 350 | 1.487365 | 5.2057775 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 52.4 | 4.78e-5 | NR | GMT10917.1 | 1538716 | g5234 | i0 | 36.6 | 0.96 | 112 | 70 | 95.1 | 1 | 344 | 12 | 198 | 309 | GMT10917.1 hypothetical protein PFISCL1PPCAC_2214, partial [Pristionchus fissidentatus] | diamond | 336 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 31773279 | 31773279 | PRJNA1025141_P_NODE_1617_length_654_cov_1.130809_g1558_i0 | PRJNA1025141 | 1617 | 654 | 1.130809 | 7.39549086 | Oigolaimella attenuata | 669116 | Nematoda | Nematoda | 63.9 | 7.17e-10 | NR | ACV20956.1 | 669116 | g1558 | i0 | 70.7 | 1.31651376146789 | 41 | 12 | 18.8 | 0 | 653 | 531 | 19 | 59 | ACV20956.1 large subunit ribosomal protein 29 [Oigolaimella attenuata] | diamond | 861 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Oigolaimella | Oigolaimella attenuata | |
| 32658503 | 32658503 | PRJNA1025141_P_NODE_8980_length_258_cov_1.232432_g8919_i0 | PRJNA1025141 | 8980 | 258 | 1.232432 | 3.17967456 | Trichuris suis | 68888 | Nematoda | Nematoda | 104 | 1.0099999999999999e-23 | NR | KFD72333.1 | 68888 | g8919 | i0 | 59.5 | 2.93023255813953 | 84 | 34 | 97.7 | 0 | 1 | 252 | 290 | 373 | KFD72333.1 hypothetical protein M514_11620 [Trichuris suis] | diamond | 756 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis |
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);;