contig_metadata
16 rows where bioproject = "PRJNA758088", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3288831 | 3288831 | PRJNA758088_P_NODE_330563_length_245_cov_0.895349_g323592_i0 | PRJNA758088 | 330563 | 245 | 0.895349 | 2.19360505 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 448 | 2.41e-121 | NTclustered | gi|687865712|emb|LK927652.1| | 6239 | g323592 | i0 | 99.592 | 3.15918367346939 | 245 | 1 | 100 | 0 | 1 | 245 | 96053 | 96297 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000108 | blastn | 774 | 448 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 16039968 | 16039968 | PRJNA758088_P_NODE_316153_length_247_cov_0.885057_g309182_i0 | PRJNA758088 | 316153 | 247 | 0.885057 | 2.18609079 | Aphelenchoides besseyi | 269767 | Nematoda | Nematoda | 62.4 | 4.52e-9 | NR | KAI6213189.1 | 269767 | g309182 | i0 | 86.7 | 0.364372469635628 | 30 | 4 | 36.4 | 0 | 182 | 93 | 164 | 193 | KAI6213189.1 Peptidase S8 S53 and Proprotein convertase domain containing protein [Aphelenchoides besseyi] | diamond | 90 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 21138346 | 21138346 | PRJNA758088_P_NODE_214377_length_291_cov_1.059633_g207406_i0 | PRJNA758088 | 214377 | 291 | 1.059633 | 3.08353203 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 532 | 7.9e-147 | NTclustered | gi|1972266968|ref|NM_069112.7| | 6239 | g207406 | i0 | 99.656 | 3 | 291 | 1 | 100 | 0 | 1 | 291 | 1120 | 830 | Caenorhabditis elegans ELKS/RAB6-interacting/CAST family member 2 (F20C5.6), mRNA | blastn | 873 | 532 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 27242577 | 27242577 | PRJNA758088_P_NODE_231023_length_280_cov_1.487923_g224052_i0 | PRJNA758088 | 231023 | 280 | 1.487923 | 4.1661844 | Parelaphostrongylus tenuis | 148309 | Nematoda | Nematoda | 61.2 | 6.67e-9 | NR | KAJ1358478.1 | 148309 | g224052 | i0 | 43.1 | 1.58571428571429 | 58 | 29 | 62.1 | 1 | 6 | 179 | 17 | 70 | KAJ1358478.1 hypothetical protein KIN20_016909 [Parelaphostrongylus tenuis] | diamond | 444 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Parelaphostrongylus | Parelaphostrongylus tenuis | |
| 27315815 | 27315815 | PRJNA758088_P_NODE_352863_length_242_cov_1.242604_g345892_i0 | PRJNA758088 | 352863 | 242 | 1.242604 | 3.00710168 | root | 1 | Root_unresolved | Root_unresolved | 62 | 1.9e-10 | NR | KRY44571.1 | 6337 | g345892 | i0 | 41.6 | 11.9380165289256 | 77 | 42 | 91.7 | 2 | 21 | 242 | 4 | 80 | KRY44571.1 26S protease regulatory subunit 6A-A, partial [Trichinella pseudospiralis] | diamond | 2889 | 62.4 | 0.993589743589744 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella pseudospiralis | |
| 28610316 | 28610316 | PRJNA758088_P_NODE_307887_length_248_cov_0.880000_g300916_i0 | PRJNA758088 | 307887 | 248 | 0.88 | 2.1824 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.0289 | NR | VDP48748.1 | 6339 | g300916 | i0 | 32.4 | 3.52016129032258 | 68 | 41 | 76.2 | 1 | 7 | 195 | 332 | 399 | VDP48748.1 unnamed protein product [Heligmosomoides polygyrus] | diamond | 873 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heligmosomidae | Heligmosomoides | Heligmosomoides polygyrus | |
| 28821172 | 28821172 | PRJNA758088_P_NODE_292348_length_250_cov_0.870056_g285377_i0 | PRJNA758088 | 292348 | 250 | 0.870056 | 2.17514 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 165 | 5.129999999999999e-47 | NR | CAD5226652.1 | 6326 | g285377 | i0 | 100 | 0.996 | 83 | 0 | 99.6 | 0 | 250 | 2 | 245 | 327 | CAD5226652.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 249 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 29105826 | 29105826 | PRJNA758088_P_NODE_73088_length_500_cov_1.182670_g66126_i0 | PRJNA758088 | 73088 | 500 | 1.18267 | 5.91335 | Trichuris suis | 68888 | Nematoda | Nematoda | 111 | 7.78e-25 | NR | KFD60188.1 | 68888 | g66126 | i0 | 52.9 | 0.612 | 102 | 48 | 61.2 | 0 | 194 | 499 | 343 | 444 | KFD60188.1 hypothetical protein M514_27632 [Trichuris suis] | diamond | 306 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 29683436 | 29683436 | PRJNA758088_P_NODE_218790_length_288_cov_1.172093_g211819_i0 | PRJNA758088 | 218790 | 288 | 1.172093 | 3.37562784 | Opisthokonta | 33154 | Nematoda | Nematoda | 122 | 6.54e-30 | NR | CAJ0587205.1 | 96644 | g211819 | i0 | 58.9 | 31.6666666666667 | 95 | 39 | 99 | 0 | 286 | 2 | 92 | 186 | CAJ0587205.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 9120 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 29800148 | 29800148 | PRJNA758088_P_NODE_144131_length_350_cov_3.779783_g137160_i0 | PRJNA758088 | 144131 | 350 | 3.779783 | 13.2292405 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 127 | 1.09e-35 | NR | GMT14341.1 | 1538716 | g137160 | i0 | 65.6 | 1.58571428571429 | 93 | 31 | 79.7 | 1 | 293 | 15 | 7 | 98 | GMT14341.1 hypothetical protein PFISCL1PPCAC_5638, partial [Pristionchus fissidentatus] | diamond | 555 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 30684749 | 30684749 | PRJNA758088_P_NODE_205313_length_297_cov_1.321429_g198342_i0 | PRJNA758088 | 205313 | 297 | 1.321429 | 3.92464413 | Aphelenchoides bicaudatus | 293665 | Nematoda | Nematoda | 80.5 | 3.91e-15 | NR | KAI6184773.1 | 293665 | g198342 | i0 | 39.4 | 1 | 99 | 59 | 100 | 1 | 297 | 1 | 62 | 159 | KAI6184773.1 hypothetical protein M3Y97_00632300 [Aphelenchoides bicaudatus] | diamond | 297 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides bicaudatus | |
| 30779666 | 30779666 | PRJNA758088_P_NODE_124134_length_377_cov_0.950658_g117163_i0 | PRJNA758088 | 124134 | 377 | 0.950658 | 3.58398066 | Heligmosomoides polygyrus | 6339 | Nematoda | Nematoda | 45.8 | 0.0132 | NR | VDP48748.1 | 6339 | g117163 | i0 | 31.9 | 0.549071618037135 | 69 | 42 | 50.9 | 1 | 198 | 7 | 331 | 399 | VDP48748.1 unnamed protein product [Heligmosomoides polygyrus] | diamond | 207 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heligmosomidae | Heligmosomoides | Heligmosomoides polygyrus | |
| 31253635 | 31253635 | PRJNA758088_P_NODE_324295_length_246_cov_0.890173_g317324_i0 | PRJNA758088 | 324295 | 246 | 0.890173 | 2.18982558 | Ditylenchus destructor | 166010 | Nematoda | Nematoda | 99.4 | 1.24e-22 | NR | KAI1722968.1 | 166010 | g317324 | i0 | 59.2 | 13.1341463414634 | 76 | 31 | 92.7 | 0 | 244 | 17 | 133 | 208 | KAI1722968.1 enoyl-CoA hydratase/isomerase domain-containing protein [Ditylenchus destructor] | diamond | 3231 | 99.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 32139444 | 32139444 | PRJNA758088_P_NODE_288718_length_250_cov_0.870056_g281747_i0 | PRJNA758088 | 288718 | 250 | 0.870056 | 2.17514 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 98.6 | 9.32e-25 | NR | CAD2207035.1 | 390850 | g281747 | i0 | 72.4 | 0.696 | 58 | 16 | 69.6 | 0 | 249 | 76 | 6 | 63 | CAD2207035.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 174 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 32392514 | 32392514 | PRJNA758088_P_NODE_305919_length_248_cov_0.880000_g298948_i0 | PRJNA758088 | 305919 | 248 | 0.88 | 2.1824 | Trichuris suis | 68888 | Nematoda | Nematoda | 60.8 | 6.48e-9 | NR | KFD48208.1 | 68888 | g298948 | i0 | 41.5 | 2.96370967741935 | 82 | 44 | 96.8 | 3 | 1 | 240 | 56 | 135 | KFD48208.1 hypothetical protein M513_10922 [Trichuris suis] | diamond | 735 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 32771092 | 32771092 | PRJNA758088_P_NODE_326560_length_246_cov_0.890173_g319589_i0 | PRJNA758088 | 326560 | 246 | 0.890173 | 2.18982558 | Trichinella sp. T6 | 92179 | Nematoda | Nematoda | 40.8 | 0.0147 | NR | KRX29138.1 | 92179 | g319589 | i0 | 72 | 0.304878048780488 | 25 | 7 | 30.5 | 0 | 42 | 116 | 13 | 37 | KRX29138.1 hypothetical protein T06_9644 [Trichinella sp. T6] | diamond | 75 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella sp. T6 |
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);;