contig_metadata
12 rows where bioproject = "PRJNA1126198", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 281087 | 281087 | PRJNA1126198_P_NODE_12521_length_556_cov_6.766046_g11841_i0 | PRJNA1126198 | 12521 | 556 | 6.766046 | 37.61921576 | Opisthokonta | 33154 | Nematoda | Nematoda | 216 | 2.6199999999999993e-68 | NR | KFD50978.1 | 68888 | g11841 | i0 | 71.6 | 17.0773381294964 | 148 | 42 | 79.9 | 0 | 546 | 103 | 51 | 198 | KFD50978.1 hypothetical protein M513_08161, partial [Trichuris suis] | diamond | 9495 | 216 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 281587 | 281587 | PRJNA1126198_P_NODE_39741_length_418_cov_6.684058_g39027_i0 | PRJNA1126198 | 39741 | 418 | 6.684058 | 27.93936244 | Pristionchus hoplostomus | 1355913 | Nematoda | Nematoda | 167 | 1.38e-36 | NTclustered | gi|524845312|gb|KC819366.1| | 1355913 | g39027 | i0 | 81.166 | 31.9090909090909 | 223 | 28 | 52 | 11 | 133 | 348 | 264 | 49 | Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds | blastn | 13338 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus hoplostomus | |
| 10484623 | 10484623 | PRJNA1126198_P_NODE_16409_length_517_cov_2.693694_g15721_i0 | PRJNA1126198 | 16409 | 517 | 2.693694 | 13.92639798 | Metazoa | 33208 | Nematoda | Nematoda | 139 | 3.2e-35 | NR | KAH7732279.1 | 70226 | g15721 | i0 | 57.5 | 3.63249516441006 | 120 | 44 | 65.6 | 1 | 409 | 71 | 26 | 145 | KAH7732279.1 procollagen-proline dioxygenase beta subunit [Aphelenchoides avenae] | diamond | 1878 | 140 | 0.992857142857143 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 10484685 | 10484685 | PRJNA1126198_P_NODE_195789_length_294_cov_1.398190_g195069_i0 | PRJNA1126198 | 195789 | 294 | 1.39819 | 4.1106786 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 191 | 5.54e-44 | NTclustered | gi|2445372511|ref|XM_053729906.1| | 31234 | g195069 | i0 | 80.315 | 64.8333333333333 | 254 | 48 | 86 | 2 | 42 | 294 | 616 | 868 | Caenorhabditis remanei uncharacterized protein (GCK72_013604), partial mRNA | blastn | 19061 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 10485152 | 10485152 | PRJNA1126198_P_NODE_41649_length_414_cov_1.797654_g40933_i0 | PRJNA1126198 | 41649 | 414 | 1.797654 | 7.44228756 | Pristionchus fukushimae | 1355912 | Nematoda | Nematoda | 202 | 3.73e-47 | NTclustered | gi|524845342|gb|KC819381.1| | 1355912 | g40933 | i0 | 81.154 | 12.3792270531401 | 260 | 41 | 62 | 8 | 110 | 365 | 307 | 52 | Pristionchus fukushimae strain RS5595 subunit ribosomal protein 30 (rpl-30) mRNA, partial cds | blastn | 5125 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fukushimae | |
| 15584197 | 15584197 | PRJNA1126198_P_NODE_25013_length_466_cov_11.269720_g24312_i0 | PRJNA1126198 | 25013 | 466 | 11.26972 | 52.5168952 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 292 | 2.4499999999999994e-74 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g24312 | i0 | 81.492 | 4.8412017167382 | 362 | 61 | 77 | 6 | 42 | 400 | 395 | 37 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 2256 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 27006866 | 27006866 | PRJNA1126198_P_NODE_439142_length_245_cov_0.901163_g438421_i0 | PRJNA1126198 | 439142 | 245 | 0.901163 | 2.20784935 | Onchocerca flexuosa | 387005 | Nematoda | Nematoda | 42.7 | 0.0171 | NR | VDO76253.1 | 387005 | g438421 | i0 | 35.7 | 0.685714285714286 | 56 | 34 | 66.1 | 1 | 172 | 11 | 69 | 124 | VDO76253.1 unnamed protein product [Onchocerca flexuosa] | diamond | 168 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Onchocerca | Onchocerca flexuosa | |
| 27038623 | 27038623 | PRJNA1126198_P_NODE_156862_length_310_cov_1.253165_g156143_i0 | PRJNA1126198 | 156862 | 310 | 1.253165 | 3.8848115 | Gongylonema pulchrum | 637853 | Nematoda | Nematoda | 82.4 | 5.21e-17 | NR | VDN42280.1 | 637853 | g156143 | i0 | 49.3 | 2.05161290322581 | 71 | 36 | 68.7 | 0 | 55 | 267 | 46 | 116 | VDN42280.1 unnamed protein product [Gongylonema pulchrum] | diamond | 636 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gongylonematidae | Gongylonema | Gongylonema pulchrum | |
| 27323181 | 27323181 | PRJNA1126198_P_NODE_392743_length_249_cov_1.653409_g392022_i0 | PRJNA1126198 | 392743 | 249 | 1.653409 | 4.11698841 | Caenorhabditis nigoni | 1611254 | Nematoda | Nematoda | 64.3 | 1.05e-9 | NR | PIC31138.1 | 1611254 | g392022 | i0 | 47.2 | 0.63855421686747 | 53 | 26 | 63.9 | 1 | 88 | 246 | 928 | 978 | PIC31138.1 hypothetical protein B9Z55_022143 [Caenorhabditis nigoni] | diamond | 159 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis nigoni | |
| 27891419 | 27891419 | PRJNA1126198_P_NODE_91805_length_349_cov_1.398551_g91087_i0 | PRJNA1126198 | 91805 | 349 | 1.398551 | 4.88094299 | Pristionchus entomophagus | 358040 | Nematoda | Nematoda | 55.5 | 4.39e-6 | NR | GMS90602.1 | 358040 | g91087 | i0 | 32.3 | 2.13180515759312 | 124 | 73 | 97.1 | 3 | 6 | 344 | 909 | 1032 | GMS90602.1 hypothetical protein PENTCL1PPCAC_12777 [Pristionchus entomophagus] | diamond | 744 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus entomophagus | |
| 31302582 | 31302582 | PRJNA1126198_P_NODE_346095_length_255_cov_4.131868_g345374_i0 | PRJNA1126198 | 346095 | 255 | 4.131868 | 10.5362634 | Trichuris trichiura | 36087 | Nematoda | Nematoda | 57 | 6.1e-8 | NR | CDW57102.1 | 36087 | g345374 | i0 | 39.5 | 3.88235294117647 | 81 | 43 | 95.3 | 1 | 243 | 1 | 16 | 90 | CDW57102.1 leptin receptor protein [Trichuris trichiura] | diamond | 990 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 32662275 | 32662275 | PRJNA1126198_P_NODE_377740_length_251_cov_0.876404_g377019_i0 | PRJNA1126198 | 377740 | 251 | 0.876404 | 2.19977404 | Acanthocheilonema viteae | 6277 | Nematoda | Nematoda | 50.1 | 1.1e-4 | NR | VBB25879.1 | 6277 | g377019 | i0 | 48.1 | 2.53386454183267 | 54 | 24 | 64.5 | 1 | 251 | 90 | 1035 | 1084 | VBB25879.1 unnamed protein product [Acanthocheilonema viteae] | diamond | 636 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Acanthocheilonema | Acanthocheilonema viteae |
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);;