contig_metadata
21 rows where bioproject = "PRJNA857857", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4673293 | 4673293 | PRJNA857857_P_NODE_22264_length_331_cov_1.488372_g21815_i0 | PRJNA857857 | 22264 | 331 | 1.488372 | 4.92651132 | Rhabditida | 6236 | Nematoda | Nematoda | 139 | 1.88e-35 | NR | KAH7704060.1 | 70226 | g21815 | i0 | 62.7 | 13.8036253776435 | 110 | 40 | 98.8 | 1 | 327 | 1 | 576 | 685 | KAH7704060.1 MRP-1 protein [Aphelenchoides avenae] | diamond | 4569 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 8498378 | 8498378 | PRJNA857857_P_NODE_5547_length_659_cov_3.278157_g5133_i0 | PRJNA857857 | 5547 | 659 | 3.278157 | 21.60305463 | Enterobius vermicularis | 51028 | Nematoda | Nematoda | 231 | 1.62e-73 | NR | VDD87543.1 | 51028 | g5133 | i0 | 70.9 | 7.53869499241275 | 165 | 48 | 75.1 | 0 | 12 | 506 | 12 | 176 | VDD87543.1 unnamed protein product, partial [Enterobius vermicularis] | diamond | 4968 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Oxyuridae | Enterobius | Enterobius vermicularis | |
| 8498421 | 8498421 | PRJNA857857_P_NODE_7987_length_549_cov_7.077731_g7558_i0 | PRJNA857857 | 7987 | 549 | 7.077731 | 38.85674319 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 284 | 3.68e-95 | NR | KAI6184284.1 | 293665 | g7558 | i0 | 78.1 | 4.66666666666667 | 169 | 37 | 92.3 | 0 | 42 | 548 | 16 | 184 | KAI6184284.1 Peptidyl-prolyl cis-trans isomerase [Aphelenchoides bicaudatus] | diamond | 2562 | 284 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides bicaudatus | |
| 11439643 | 11439643 | PRJNA857857_P_NODE_6449_length_610_cov_5.754190_g6025_i0 | PRJNA857857 | 6449 | 610 | 5.75419 | 35.100559 | Rhabditida | 6236 | Nematoda | Nematoda | 174 | 1.08e-46 | NR | CDJ91769.1 | 6289 | g6025 | i0 | 63.8 | 9.95901639344262 | 149 | 54 | 73.3 | 0 | 125 | 571 | 612 | 760 | CDJ91769.1 Carboxylesterase and Ribosomal protein L23 L25 and Ribosomal protein L25 L23 domain containing protein [Haemonchus contortus] | diamond | 6075 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Haemonchus | Haemonchus contortus | |
| 13599070 | 13599070 | PRJNA857857_P_NODE_47831_length_244_cov_0.807018_g47382_i0 | PRJNA857857 | 47831 | 244 | 0.807018 | 1.96912392 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|690018501|emb|LM525739.1| | 174720 | g47382 | i0 | 100 | 0.118852459016393 | 29 | 0 | 12 | 0 | 33 | 61 | 35663 | 35691 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000132 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 25070784 | 25070784 | PRJNA857857_P_NODE_12640_length_443_cov_1.040541_g12196_i0 | PRJNA857857 | 12640 | 443 | 1.040541 | 4.60959663 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 155 | 1.08e-42 | NR | TKR89185.1 | 34508 | g12196 | i0 | 52.8 | 26.9322799097065 | 144 | 68 | 97.5 | 0 | 8 | 439 | 37 | 180 | TKR89185.1 hypothetical protein L596_013325 [Steinernema carpocapsae] | diamond | 11931 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 26801826 | 26801826 | PRJNA857857_P_NODE_33341_length_265_cov_1.697917_g32892_i0 | PRJNA857857 | 33341 | 265 | 1.697917 | 4.49948005 | Strongylus vulgaris | 40348 | Nematoda | Nematoda | 142 | 1.61e-39 | NR | VDM68585.1 | 40348 | g32892 | i0 | 68.2 | 6.84905660377358 | 88 | 28 | 99.6 | 0 | 2 | 265 | 110 | 197 | VDM68585.1 unnamed protein product, partial [Strongylus vulgaris] | diamond | 1815 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Strongylus | Strongylus vulgaris | |
| 26936603 | 26936603 | PRJNA857857_P_NODE_6702_length_598_cov_4.104762_g6276_i0 | PRJNA857857 | 6702 | 598 | 4.104762 | 24.54647676 | Rhabditida | 6236 | Nematoda | Nematoda | 79 | 7.49e-15 | NR | CAD5224984.1 | 6326 | g6276 | i0 | 38.2 | 2.11705685618729 | 144 | 80 | 72.2 | 4 | 537 | 106 | 1 | 135 | CAD5224984.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 1266 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 27023425 | 27023425 | PRJNA857857_P_NODE_22242_length_331_cov_2.193798_g21793_i0 | PRJNA857857 | 22242 | 331 | 2.193798 | 7.26147138 | Ditylenchus destructor | 166010 | Nematoda | Nematoda | 45.1 | 0.0161 | NR | KAI1728196.1 | 166010 | g21793 | i0 | 34.3 | 0.634441087613293 | 70 | 39 | 63.4 | 2 | 318 | 109 | 19 | 81 | KAI1728196.1 innexin domain-containing protein [Ditylenchus destructor] | diamond | 210 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 27687297 | 27687297 | PRJNA857857_P_NODE_42464_length_247_cov_0.885057_g42015_i0 | PRJNA857857 | 42464 | 247 | 0.885057 | 2.18609079 | Heterodera schachtii | 97005 | Nematoda | Nematoda | 129 | 4.33e-35 | NR | KAL3070918.1 | 97005 | g42015 | i0 | 85.7 | 3.40080971659919 | 70 | 10 | 85 | 0 | 211 | 2 | 96 | 165 | KAL3070918.1 hypothetical protein niasHS_017043 [Heterodera schachtii] | diamond | 840 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera schachtii | |
| 27781764 | 27781764 | PRJNA857857_P_NODE_51264_length_241_cov_0.916667_g50815_i0 | PRJNA857857 | 51264 | 241 | 0.916667 | 2.20916747 | Pristionchus pacificus | 54126 | Nematoda | Nematoda | 72.8 | 2.91e-13 | NR | KAF8366744.1 | 54126 | g50815 | i0 | 51.6 | 4.04564315352697 | 62 | 30 | 77.2 | 0 | 199 | 14 | 184 | 245 | KAF8366744.1 scrm-1 [Pristionchus pacificus] | diamond | 975 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 28539651 | 28539651 | PRJNA857857_P_NODE_41027_length_248_cov_0.880000_g40578_i0 | PRJNA857857 | 41027 | 248 | 0.88 | 2.1824 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 155 | 2.8499999999999993e-42 | NR | CAD5235409.1 | 6326 | g40578 | i0 | 87.7 | 8.81854838709677 | 81 | 10 | 98 | 0 | 3 | 245 | 392 | 472 | CAD5235409.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 2187 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 29242239 | 29242239 | PRJNA857857_P_NODE_31209_length_276_cov_1.137931_g30760_i0 | PRJNA857857 | 31209 | 276 | 1.137931 | 3.14068956 | Rhabditida | 6236 | Nematoda | Nematoda | 59.7 | 5.94e-8 | NR | CAJ0587152.1 | 96644 | g30760 | i0 | 37.2 | 2.94565217391304 | 94 | 56 | 98.9 | 2 | 274 | 2 | 595 | 688 | CAJ0587152.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 813 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 29368533 | 29368533 | PRJNA857857_P_NODE_19649_length_353_cov_1.917857_g19200_i0 | PRJNA857857 | 19649 | 353 | 1.917857 | 6.77003521 | Metazoa | 33208 | Nematoda | Nematoda | 102 | 3.36e-23 | NR | KHN84763.1 | 6265 | g19200 | i0 | 42.2 | 22.3597733711048 | 109 | 61 | 90.9 | 2 | 8 | 328 | 199 | 307 | KHN84763.1 Paxillin -like protein 1, partial [Toxocara canis] | diamond | 7893 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 30403081 | 30403081 | PRJNA857857_P_NODE_43833_length_246_cov_0.890173_g43384_i0 | PRJNA857857 | 43833 | 246 | 0.890173 | 2.18982558 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 92 | 1.72e-19 | NR | CAK5025246.1 | 390850 | g43384 | i0 | 82.3 | 1.92682926829268 | 79 | 14 | 96.3 | 0 | 238 | 2 | 884 | 962 | CAK5025246.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 474 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 30592120 | 30592120 | PRJNA857857_P_NODE_11013_length_473_cov_2.905000_g10573_i0 | PRJNA857857 | 11013 | 473 | 2.905 | 13.74065 | Pristionchus pacificus | 54126 | Nematoda | Nematoda | 114 | 2.57e-29 | NR | KAF8361249.1 | 54126 | g10573 | i0 | 46.5 | 1.80126849894292 | 142 | 72 | 88.8 | 3 | 443 | 24 | 4 | 143 | KAF8361249.1 hypothetical protein PRIPAC_88172 [Pristionchus pacificus] | diamond | 852 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 30916502 | 30916502 | PRJNA857857_P_NODE_31954_length_272_cov_1.296482_g31505_i0 | PRJNA857857 | 31954 | 272 | 1.296482 | 3.52643104 | Metazoa | 33208 | Nematoda | Nematoda | 78.6 | 1.35e-14 | NR | VBB31818.1 | 6277 | g31505 | i0 | 48.3 | 4.81985294117647 | 89 | 43 | 98.2 | 1 | 267 | 1 | 1112 | 1197 | VBB31818.1 unnamed protein product [Acanthocheilonema viteae] | diamond | 1311 | 79 | 0.994936708860759 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Acanthocheilonema | Acanthocheilonema viteae | |
| 31232104 | 31232104 | PRJNA857857_P_NODE_38595_length_250_cov_0.870056_g38146_i0 | PRJNA857857 | 38595 | 250 | 0.870056 | 2.17514 | Metazoa | 33208 | Nematoda | Nematoda | 59.3 | 2.71e-8 | NR | VDO37866.1 | 387005 | g38146 | i0 | 40.8 | 12.612 | 71 | 40 | 82.8 | 1 | 42 | 248 | 141 | 211 | VDO37866.1 unnamed protein product [Onchocerca flexuosa] | diamond | 3153 | 59.7 | 0.993299832495812 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Onchocerca | Onchocerca flexuosa | |
| 31445560 | 31445560 | PRJNA857857_P_NODE_8036_length_548_cov_2.002105_g7607_i0 | PRJNA857857 | 8036 | 548 | 2.002105 | 10.9715354 | Steinernema carpocapsae | 34508 | Nematoda | Nematoda | 115 | 4.31e-29 | NR | TKR89804.1 | 34508 | g7607 | i0 | 45.9 | 0.81021897810219 | 148 | 74 | 79.9 | 4 | 493 | 56 | 1 | 144 | TKR89804.1 hypothetical protein L596_013851 [Steinernema carpocapsae] | diamond | 444 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 31801442 | 31801442 | PRJNA857857_P_NODE_7397_length_572_cov_1.200401_g6969_i0 | PRJNA857857 | 7397 | 572 | 1.200401 | 6.86629372 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 251 | 1.55e-77 | NR | KRY40019.1 | 6334 | g6969 | i0 | 62 | 238.395104895105 | 179 | 68 | 93.9 | 0 | 30 | 566 | 367 | 545 | KRY40019.1 ADP-ribosylation factor 1-like 2 [Trichinella spiralis] | diamond | 136362 | 252 | 0.996031746031746 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 32204852 | 32204852 | PRJNA857857_P_NODE_8238_length_541_cov_3.271368_g7809_i0 | PRJNA857857 | 8238 | 541 | 3.271368 | 17.69810088 | Gongylonema pulchrum | 637853 | Nematoda | Nematoda | 125 | 3.52e-33 | NR | VDN19050.1 | 637853 | g7809 | i0 | 53.6 | 3.65988909426987 | 110 | 48 | 61 | 1 | 372 | 43 | 39 | 145 | VDN19050.1 unnamed protein product [Gongylonema pulchrum] | diamond | 1980 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gongylonematidae | Gongylonema | Gongylonema pulchrum |
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);;