contig_metadata
17 rows where bioproject = "PRJEB12237", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20659 | 20659 | PRJEB12237_P_NODE_11741_length_153_cov_1.355932_g11545_i0 | PRJEB12237 | 11741 | 153 | 1.355932 | 2.07457596 | Diplogasteroides magnus | 560213 | Nematoda | Nematoda | 106 | 9.49e-19 | NTclustered | gi|256709249|gb|GQ422277.1| | 560213 | g11545 | i0 | 84.906 | 7.64705882352941 | 106 | 14 | 69 | 2 | 46 | 150 | 45 | 149 | Diplogasteroides magnus small subunit ribosomal protein 14 (rps-14) mRNA, partial cds | blastn | 1170 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteroididae | Diplogasteroides | Diplogasteroides magnus | |
| 5123074 | 5123074 | PRJEB12237_P_NODE_4905_length_279_cov_4.717213_g4709_i0 | PRJEB12237 | 4905 | 279 | 4.717213 | 13.16102427 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 87.4 | 1.23e-18 | NR | TKR80874.1 | 34508 | g4709 | i0 | 58.2 | 5.35483870967742 | 67 | 28 | 72 | 0 | 276 | 76 | 177 | 243 | TKR80874.1 hypothetical protein L596_014863 [Steinernema carpocapsae] | diamond | 1494 | 88.2 | 0.99092970521542 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 22972672 | 22972672 | PRJEB12237_P_NODE_5079_length_272_cov_1.468354_g4883_i0 | PRJEB12237 | 5079 | 272 | 1.468354 | 3.99392288 | Terschellingia longicaudata | 319962 | Nematoda | Nematoda | 117 | 8.73e-22 | NTclustered | gi|1172206953|emb|LT703373.1| | 319962 | g4883 | i0 | 80.625 | 58.7573529411765 | 160 | 22 | 58 | 7 | 113 | 271 | 696 | 847 | Terschellingia longicaudata partial 18S rRNA gene, isolate 1620_Amon_V | blastn | 15982 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Monhysterida | Linhomoeidae | Terschellingia | Terschellingia longicaudata | |
| 26684671 | 26684671 | PRJEB12237_P_NODE_3861_length_331_cov_1.486486_g3665_i0 | PRJEB12237 | 3861 | 331 | 1.486486 | 4.92026866 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 51.2 | 9.14e-5 | NR | AVZ46778.1 | 189291 | g3665 | i0 | 29.5 | 0.797583081570997 | 88 | 62 | 79.8 | 0 | 271 | 8 | 117 | 204 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 264 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 27222423 | 27222423 | PRJEB12237_P_NODE_1463_length_596_cov_3.647059_g1289_i0 | PRJEB12237 | 1463 | 596 | 3.647059 | 21.73647164 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 70.9 | 8.79e-11 | NR | AVZ46778.1 | 189291 | g1289 | i0 | 53.2 | 0.38758389261745 | 77 | 36 | 38.8 | 0 | 20 | 250 | 170 | 246 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 231 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 27317642 | 27317642 | PRJEB12237_P_NODE_9083_length_180_cov_0.937931_g8887_i0 | PRJEB12237 | 9083 | 180 | 0.937931 | 1.6882758 | Soboliphyme baturini | 241478 | Nematoda | Nematoda | 54.3 | 7.65e-8 | NR | VDP11718.1 | 241478 | g8887 | i0 | 51.4 | 1.16666666666667 | 37 | 18 | 61.7 | 0 | 28 | 138 | 41 | 77 | VDP11718.1 unnamed protein product [Soboliphyme baturini] | diamond | 210 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 27753461 | 27753461 | PRJEB12237_P_NODE_10224_length_166_cov_1.473282_g10028_i0 | PRJEB12237 | 10224 | 166 | 1.473282 | 2.44564812 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 86.7 | 6.6e-19 | NR | NP_507940.1 | 6239 | g10028 | i0 | 72.2 | 14.6204819277108 | 54 | 15 | 97.6 | 0 | 3 | 164 | 139 | 192 | NP_507940.1 Large ribosomal subunit protein uL2 [Caenorhabditis elegans] | diamond | 2427 | 87.4 | 0.991990846681922 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 27917321 | 27917321 | PRJEB12237_P_NODE_9225_length_178_cov_1.118881_g9029_i0 | PRJEB12237 | 9225 | 178 | 1.118881 | 1.99160818 | Trichuris trichiura | 36087 | Nematoda | Nematoda | 50.4 | 2.76e-5 | NR | CDW59512.1 | 36087 | g9029 | i0 | 41.4 | 0.97752808988764 | 58 | 32 | 94.4 | 1 | 170 | 3 | 7 | 64 | CDW59512.1 Peptidase C1 domain containing protein [Trichuris trichiura] | diamond | 174 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 28043746 | 28043746 | PRJEB12237_P_NODE_9845_length_170_cov_1.903704_g9649_i0 | PRJEB12237 | 9845 | 170 | 1.903704 | 3.2362968 | Oesophagostomum dentatum | 61180 | Nematoda | Nematoda | 47.4 | 7.15e-5 | NR | KHJ81150.1 | 61180 | g9649 | i0 | 67.9 | 1.00588235294118 | 28 | 9 | 49.4 | 0 | 128 | 45 | 5 | 32 | KHJ81150.1 zinc knuckle [Oesophagostomum dentatum] | diamond | 171 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Oesophagostomum | Oesophagostomum dentatum | |
| 28327766 | 28327766 | PRJEB12237_P_NODE_6946_length_216_cov_1.265193_g6750_i0 | PRJEB12237 | 6946 | 216 | 1.265193 | 2.73281688 | Auanema sp. JU1783 | 2878363 | Nematoda | Nematoda | 48.5 | 1.61e-4 | NR | CAI4233146.1 | 2878363 | g6750 | i0 | 42.9 | 0.680555555555556 | 49 | 28 | 68.1 | 0 | 172 | 26 | 146 | 194 | CAI4233146.1 unnamed protein product [Auanema sp. JU1783] | diamond | 147 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Auanema | Auanema sp. JU1783 | |
| 28612117 | 28612117 | PRJEB12237_P_NODE_8847_length_183_cov_1.074324_g8651_i0 | PRJEB12237 | 8847 | 183 | 1.074324 | 1.96601292 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 72 | 7.81e-13 | NR | CAD5225918.1 | 6326 | g8651 | i0 | 61.5 | 1.75409836065574 | 52 | 20 | 85.2 | 0 | 182 | 27 | 980 | 1031 | CAD5225918.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 321 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 28991275 | 28991275 | PRJEB12237_P_NODE_3268_length_371_cov_2.214286_g3072_i0 | PRJEB12237 | 3268 | 371 | 2.214286 | 8.21500106 | Acanthocheilonema viteae | 6277 | Nematoda | Nematoda | 97.1 | 1.58e-20 | NR | VBB29199.1 | 6277 | g3072 | i0 | 64.5 | 0.501347708894879 | 62 | 22 | 50.1 | 0 | 356 | 171 | 59 | 120 | VBB29199.1 unnamed protein product [Acanthocheilonema viteae] | diamond | 186 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Acanthocheilonema | Acanthocheilonema viteae | |
| 30127508 | 30127508 | PRJEB12237_P_NODE_3372_length_363_cov_3.460366_g3176_i0 | PRJEB12237 | 3372 | 363 | 3.460366 | 12.56112858 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 128 | 9.3e-36 | NR | GMT14341.1 | 1538716 | g3176 | i0 | 65.6 | 1.52892561983471 | 93 | 31 | 76.9 | 1 | 345 | 67 | 7 | 98 | GMT14341.1 hypothetical protein PFISCL1PPCAC_5638, partial [Pristionchus fissidentatus] | diamond | 555 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 30254461 | 30254461 | PRJEB12237_P_NODE_9072_length_180_cov_1.103448_g8876_i0 | PRJEB12237 | 9072 | 180 | 1.103448 | 1.9862064 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 50.8 | 2.17e-5 | NR | 6K00_A | 6239 | g8876 | i0 | 53.1 | 0.816666666666667 | 49 | 23 | 81.7 | 0 | 7 | 153 | 259 | 307 | 6K00_A Chain A, Nucleosome Assembly Protein [Caenorhabditis elegans] | diamond | 147 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 31296870 | 31296870 | PRJEB12237_P_NODE_10235_length_166_cov_1.221374_g10039_i0 | PRJEB12237 | 10235 | 166 | 1.221374 | 2.02748084 | Haemonchus contortus | 6289 | Nematoda | Nematoda | 77.8 | 2.63e-15 | NR | XGW26292.1 | 6289 | g10039 | i0 | 57.1 | 32.9819277108434 | 63 | 19 | 99.4 | 1 | 166 | 2 | 37 | 99 | XGW26292.1 hypothetical protein V3C99_007145 [Haemonchus contortus] | diamond | 5475 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Haemonchus | Haemonchus contortus | |
| 32246288 | 32246288 | PRJEB12237_P_NODE_6038_length_238_cov_2.147783_g5842_i0 | PRJEB12237 | 6038 | 238 | 2.147783 | 5.11172354 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 47.4 | 7.56e-4 | NR | AVZ46778.1 | 189291 | g5842 | i0 | 52.3 | 0.554621848739496 | 44 | 21 | 55.5 | 0 | 100 | 231 | 117 | 160 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 132 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 32650225 | 32650225 | PRJEB12237_P_NODE_4260_length_310_cov_2.003636_g4064_i0 | PRJEB12237 | 4260 | 310 | 2.003636 | 6.2112716 | Metazoa | 33208 | Nematoda | Nematoda | 143 | 3.28e-37 | NR | TKR77856.1 | 34508 | g4064 | i0 | 74.3 | 51 | 101 | 26 | 97.7 | 0 | 305 | 3 | 766 | 866 | TKR77856.1 hypothetical protein L596_018757 [Steinernema carpocapsae] | diamond | 15810 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae |
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);;