contig_metadata
13 rows where bioproject = "PRJNA630877", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26859723 | 26859723 | PRJNA630877_S_NODE_98001_length_232_cov_1.842932_g78864_i0 | PRJNA630877 | 98001 | 232 | 1.842932 | 4.2756022400000004 | Caenorhabditis nigoni | 1611254 | Nematoda | Nematoda | 42.7 | 0.00647 | NR | PIC41628.1 | 1611254 | g78864 | i0 | 33.8 | 0.84051724137931 | 65 | 41 | 84.1 | 1 | 36 | 230 | 20 | 82 | PIC41628.1 hypothetical protein B9Z55_008980 [Caenorhabditis nigoni] | diamond | 195 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis nigoni | |
| 27030153 | 27030153 | PRJNA630877_S_NODE_86182_length_268_cov_6.167401_g67045_i0 | PRJNA630877 | 86182 | 268 | 6.167401 | 16.52863468 | Metazoa | 33208 | Nematoda | Nematoda | 96.7 | 1.3700000000000002e-21 | NR | XP_042938937.1 | 6279 | g67045 | i0 | 100 | 7.0410447761194 | 45 | 0 | 50.4 | 0 | 267 | 133 | 218 | 262 | XP_042938937.1 Uncharacterized protein BM_BM8269 [Brugia malayi] | diamond | 1887 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 27112341 | 27112341 | PRJNA630877_S_NODE_106702_length_212_cov_15.584795_g87565_i0 | PRJNA630877 | 106702 | 212 | 15.584795 | 33.0397654 | Loa loa | 7209 | Nematoda | Nematoda | 53.5 | 3.4e-6 | NR | XP_020305707.1 | 7209 | g87565 | i0 | 47.1 | 4.40094339622642 | 51 | 24 | 72.2 | 1 | 10 | 162 | 242 | 289 | XP_020305707.1 hypothetical protein LOAG_17927 [Loa loa] | diamond | 933 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Loa | Loa loa | |
| 27757071 | 27757071 | PRJNA630877_S_NODE_83844_length_277_cov_12.228814_g64707_i0 | PRJNA630877 | 83844 | 277 | 12.228814 | 33.87381478 | Metazoa | 33208 | Nematoda | Nematoda | 179 | 2.6699999999999993e-52 | NR | MCP9266445.1 | 6287 | g64707 | i0 | 96.5 | 377.220216606498 | 86 | 3 | 93.1 | 0 | 276 | 19 | 78 | 163 | MCP9266445.1 Transforming protein RhoA [Dirofilaria immitis] | diamond | 104490 | 180 | 0.994444444444444 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Dirofilaria | Dirofilaria immitis | |
| 28154905 | 28154905 | PRJNA630877_S_NODE_136105_length_171_cov_1.184615_g116968_i0 | PRJNA630877 | 136105 | 171 | 1.184615 | 2.02569165 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 45.1 | 0.00215 | NR | PAV58789.1 | 2018661 | g116968 | i0 | 45.7 | 0.807017543859649 | 46 | 24 | 80.7 | 1 | 166 | 29 | 622 | 666 | PAV58789.1 hypothetical protein WR25_11879 [Diploscapter pachys] | diamond | 138 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 28596871 | 28596871 | PRJNA630877_S_NODE_142127_length_165_cov_1.419355_g122990_i0 | PRJNA630877 | 142127 | 165 | 1.419355 | 2.34193575 | Caenorhabditis brenneri | 135651 | Nematoda | Nematoda | 40.8 | 0.0353 | NR | EGT36957.1 | 135651 | g122990 | i0 | 41.9 | 0.781818181818182 | 43 | 25 | 78.2 | 0 | 164 | 36 | 48 | 90 | EGT36957.1 hypothetical protein CAEBREN_16069 [Caenorhabditis brenneri] | diamond | 129 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis brenneri | |
| 29543821 | 29543821 | PRJNA630877_S_NODE_45490_length_650_cov_9.812808_g17178_i2 | PRJNA630877 | 45490 | 650 | 9.812808 | 63.783252 | Trichinella sp. T9 | 181606 | Nematoda | Nematoda | 104 | 1.16e-24 | NR | KRX32182.1 | 181606 | g17178 | i2 | 96.6 | 0.544615384615385 | 59 | 2 | 27.2 | 0 | 473 | 649 | 67 | 125 | KRX32182.1 Calcium/calmodulin-dependent protein kinase type II subunit gamma, partial [Trichinella sp. T9] | diamond | 354 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella sp. T9 | |
| 29986085 | 29986085 | PRJNA630877_S_NODE_138131_length_169_cov_1.031250_g118994_i0 | PRJNA630877 | 138131 | 169 | 1.03125 | 1.7428125 | Gnathostoma spinigerum | 75299 | Nematoda | Nematoda | 52.8 | 3.82e-6 | NR | MFH4980885.1 | 75299 | g118994 | i0 | 62.8 | 6.28402366863905 | 43 | 16 | 76.3 | 0 | 12 | 140 | 60 | 102 | MFH4980885.1 hypothetical protein [Gnathostoma spinigerum] | diamond | 1062 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gnathostomatidae | Gnathostoma | Gnathostoma spinigerum | |
| 30270696 | 30270696 | PRJNA630877_S_NODE_111632_length_203_cov_1.648148_g92495_i0 | PRJNA630877 | 111632 | 203 | 1.648148 | 3.34574044 | Aphelenchoides besseyi | 269767 | Nematoda | Nematoda | 42.4 | 0.0312 | NR | KAI6216298.1 | 269767 | g92495 | i0 | 37.3 | 0.753694581280788 | 51 | 32 | 75.4 | 0 | 172 | 20 | 1009 | 1059 | KAI6216298.1 hypothetical protein M3Y95_01285700 [Aphelenchoides besseyi] | diamond | 153 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 30270697 | 30270697 | PRJNA630877_S_NODE_128972_length_179_cov_0.956522_g109835_i0 | PRJNA630877 | 128972 | 179 | 0.956522 | 1.71217438 | Trichinella britovi | 45882 | Nematoda | Nematoda | 46.6 | 6.91e-4 | NR | KRY51933.1 | 45882 | g109835 | i0 | 56.7 | 1.91061452513966 | 30 | 13 | 50.3 | 0 | 55 | 144 | 601 | 630 | KRY51933.1 PiggyBac transposable element-derived protein 4, partial [Trichinella britovi] | diamond | 342 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella britovi | |
| 30598831 | 30598831 | PRJNA630877_S_NODE_144133_length_163_cov_1.598361_g124996_i0 | PRJNA630877 | 144133 | 163 | 1.598361 | 2.60532843 | Metazoa | 33208 | Nematoda | Nematoda | 52.4 | 3.34e-6 | NR | VDN25367.1 | 637853 | g124996 | i0 | 50 | 1.98773006134969 | 54 | 22 | 99.4 | 2 | 2 | 163 | 113 | 161 | VDN25367.1 unnamed protein product, partial [Gongylonema pulchrum] | diamond | 324 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gongylonematidae | Gongylonema | Gongylonema pulchrum | |
| 31641931 | 31641931 | PRJNA630877_S_NODE_116216_length_195_cov_9.928571_g97079_i0 | PRJNA630877 | 116216 | 195 | 9.928571 | 19.36071345 | root | 1 | Root_unresolved | Root_unresolved | 135 | 8.46e-39 | NR | NP_503011.1 | 6239 | g97079 | i0 | 98.5 | 199 | 65 | 1 | 100 | 0 | 195 | 1 | 15 | 79 | NP_503011.1 ADP-ribosylation factor 6 [Caenorhabditis elegans] | diamond | 38805 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 31724290 | 31724290 | PRJNA630877_S_NODE_87837_length_262_cov_6.656109_g68700_i0 | PRJNA630877 | 87837 | 262 | 6.656109 | 17.43900558 | Trichinella pseudospiralis | 6337 | Nematoda | Nematoda | 42.4 | 0.0465 | NR | KRY73976.1 | 6337 | g68700 | i0 | 80 | 0.229007633587786 | 20 | 4 | 22.9 | 0 | 2 | 61 | 158 | 177 | KRY73976.1 ADP-ribosylation factor-like protein 8B-A [Trichinella pseudospiralis] | diamond | 60 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella pseudospiralis |
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);;