contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1035005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 168863 | 168863 | PRJNA1035005_P_NODE_46001_length_262_cov_1.317460_g45595_i0 | PRJNA1035005 | 46001 | 262 | 1.31746 | 3.4517452 | Opisthokonta | 33154 | Nematoda | Nematoda | 84.3 | 1.09e-16 | NR | KJH53698.1 | 29172 | g45595 | i0 | 54.5 | 12.8702290076336 | 77 | 35 | 88.2 | 0 | 233 | 3 | 1686 | 1762 | KJH53698.1 CTP synthase [Dictyocaulus viviparus] | diamond | 3372 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Dictyocaulus | Dictyocaulus viviparus | |
| 1443410 | 1443410 | PRJNA1035005_P_NODE_18322_length_308_cov_1.323404_g17916_i0 | PRJNA1035005 | 18322 | 308 | 1.323404 | 4.07608432 | Pristionchus mayeri | 1317129 | Nematoda | Nematoda | 108 | 4.33e-25 | NR | GMR45422.1 | 1317129 | g17916 | i0 | 63.2 | 2.45454545454545 | 87 | 32 | 84.7 | 0 | 263 | 3 | 9 | 95 | GMR45422.1 hypothetical protein PMAYCL1PPCAC_15617, partial [Pristionchus mayeri] | diamond | 756 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus mayeri | |
| 2283113 | 2283113 | PRJNA1035005_P_NODE_58962_length_251_cov_1.185393_g58556_i0 | PRJNA1035005 | 58962 | 251 | 1.185393 | 2.97533643 | Opisthokonta | 33154 | Nematoda | Nematoda | 131 | 1.92e-35 | NR | KAF8385892.1 | 54126 | g58556 | i0 | 80.7 | 20.8326693227092 | 83 | 16 | 99.2 | 0 | 249 | 1 | 5 | 87 | KAF8385892.1 rpl-5 [Pristionchus pacificus] | diamond | 5229 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 6546705 | 6546705 | PRJNA1035005_P_NODE_13626_length_332_cov_1.505792_g13220_i0 | PRJNA1035005 | 13626 | 332 | 1.505792 | 4.99922944 | Rhabditida | 6236 | Nematoda | Nematoda | 179 | 2.17e-50 | NR | VDO71113.1 | 6339 | g13220 | i0 | 84.4 | 42.3614457831325 | 109 | 17 | 98.5 | 0 | 329 | 3 | 316 | 424 | VDO71113.1 unnamed protein product [Heligmosomoides polygyrus] | diamond | 14064 | 179 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heligmosomidae | Heligmosomoides | Heligmosomoides polygyrus | |
| 12486621 | 12486621 | PRJNA1035005_P_NODE_18150_length_309_cov_0.991525_g17744_i0 | PRJNA1035005 | 18150 | 309 | 0.991525 | 3.06381225 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 132 | 4.13e-34 | NR | XP_024506008.1 | 34506 | g17744 | i0 | 60 | 6.85436893203883 | 100 | 40 | 97.1 | 0 | 9 | 308 | 166 | 265 | XP_024506008.1 Homogentisate 1,2-dioxygenase [Strongyloides ratti] | diamond | 2118 | 133 | 0.992481203007519 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 28361528 | 28361528 | PRJNA1035005_P_NODE_53606_length_253_cov_0.866667_g53200_i0 | PRJNA1035005 | 53606 | 253 | 0.866667 | 2.19266751 | Oscheius tipulae | 141969 | Nematoda | Nematoda | 114 | 3.36e-28 | NR | AFO72898.1 | 141969 | g53200 | i0 | 76.4 | 0.853754940711462 | 72 | 17 | 85.4 | 0 | 5 | 220 | 288 | 359 | AFO72898.1 vitellogenin 1, partial [Oscheius tipulae] | diamond | 216 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Oscheius | Oscheius tipulae | |
| 28614238 | 28614238 | PRJNA1035005_P_NODE_11427_length_350_cov_1.043321_g11022_i0 | PRJNA1035005 | 11427 | 350 | 1.043321 | 3.6516235 | Anisakis simplex | 6269 | Nematoda | Nematoda | 50.8 | 9.95e-5 | NR | VDK45428.1 | 6269 | g11022 | i0 | 34.8 | 1.63714285714286 | 66 | 43 | 56.6 | 0 | 238 | 41 | 138 | 203 | VDK45428.1 unnamed protein product [Anisakis simplex] | diamond | 573 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anisakidae | Anisakis | Anisakis simplex | |
| 30193041 | 30193041 | PRJNA1035005_P_NODE_3252_length_608_cov_2.256075_g2862_i0 | PRJNA1035005 | 3252 | 608 | 2.256075 | 13.716936 | Pristionchus pacificus | 54126 | Nematoda | Nematoda | 46.6 | 0.0428 | NR | KAF8359571.1 | 54126 | g2862 | i0 | 36.8 | 0.335526315789474 | 68 | 35 | 33.6 | 2 | 275 | 72 | 969 | 1028 | KAF8359571.1 hypothetical protein PRIPAC_94566 [Pristionchus pacificus] | diamond | 204 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 30280367 | 30280367 | PRJNA1035005_P_NODE_90432_length_206_cov_4.248120_g90025_i0 | PRJNA1035005 | 90432 | 206 | 4.24812 | 8.7511272 | Rhabditida | 6236 | Nematoda | Nematoda | 90.5 | 8.53e-20 | NR | VDM46117.1 | 6265 | g90025 | i0 | 69.1 | 8.9126213592233 | 68 | 17 | 99 | 2 | 204 | 1 | 88 | 151 | VDM46117.1 unnamed protein product [Toxocara canis] | diamond | 1836 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 30603773 | 30603773 | PRJNA1035005_P_NODE_32533_length_279_cov_1.514563_g32127_i0 | PRJNA1035005 | 32533 | 279 | 1.514563 | 4.22563077 | Nippostrongylus brasiliensis | 27835 | Nematoda | Nematoda | 50.8 | 1.92e-5 | NR | WKY01110.1 | 27835 | g32127 | i0 | 37.1 | 1.90322580645161 | 62 | 39 | 66.7 | 0 | 188 | 3 | 29 | 90 | WKY01110.1 hypothetical protein Q1695_015258 [Nippostrongylus brasiliensis] | diamond | 531 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heligmosomidae | Nippostrongylus | Nippostrongylus brasiliensis | |
| 30761954 | 30761954 | PRJNA1035005_P_NODE_8994_length_376_cov_1.587459_g8591_i0 | PRJNA1035005 | 8994 | 376 | 1.587459 | 5.96884584 | Parelaphostrongylus tenuis | 148309 | Nematoda | Nematoda | 46.2 | 0.00906 | NR | KAJ1366417.1 | 148309 | g8591 | i0 | 30.8 | 0.853723404255319 | 107 | 54 | 75 | 5 | 327 | 46 | 99 | 198 | KAJ1366417.1 hypothetical protein KIN20_027073 [Parelaphostrongylus tenuis] | diamond | 321 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Parelaphostrongylus | Parelaphostrongylus tenuis | |
| 30975154 | 30975154 | PRJNA1035005_P_NODE_11734_length_347_cov_1.138686_g11329_i0 | PRJNA1035005 | 11734 | 347 | 1.138686 | 3.95124042 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 127 | 1.21e-35 | NR | CAD5208042.1 | 6326 | g11329 | i0 | 69.3 | 9.95965417867435 | 88 | 27 | 76.1 | 0 | 307 | 44 | 1 | 88 | CAD5208042.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 3456 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 31552345 | 31552345 | PRJNA1035005_P_NODE_1616_length_972_cov_3.438265_g1289_i0 | PRJNA1035005 | 1616 | 972 | 3.438265 | 33.4199358 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 119 | 1.7700000000000002e-27 | NR | AVZ46778.1 | 189291 | g1289 | i0 | 52.2 | 0.41358024691358 | 134 | 61 | 41 | 2 | 313 | 711 | 117 | 248 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 402 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 31702265 | 31702265 | PRJNA1035005_P_NODE_76237_length_245_cov_0.906977_g75831_i0 | PRJNA1035005 | 76237 | 245 | 0.906977 | 2.22209365 | Rhabditida | 6236 | Nematoda | Nematoda | 83.2 | 2.21e-16 | NR | VDM39802.1 | 6265 | g75831 | i0 | 52.5 | 8.81632653061224 | 80 | 38 | 98 | 0 | 244 | 5 | 41 | 120 | VDM39802.1 unnamed protein product [Toxocara canis] | diamond | 2160 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 32784809 | 32784809 | PRJNA1035005_P_NODE_14560_length_326_cov_1.233202_g14154_i0 | PRJNA1035005 | 14560 | 326 | 1.233202 | 4.02023852 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 100 | 5.57e-22 | NR | CAJ0585849.1 | 96644 | g14154 | i0 | 46.7 | 0.846625766871166 | 92 | 49 | 84.7 | 0 | 278 | 3 | 1319 | 1410 | CAJ0585849.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 276 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 32879342 | 32879342 | PRJNA1035005_P_NODE_78860_length_244_cov_0.912281_g78454_i0 | PRJNA1035005 | 78860 | 244 | 0.912281 | 2.22596564 | Caenorhabditis brenneri | 135651 | Nematoda | Nematoda | 86.3 | 1.23e-17 | NR | EGT37515.1 | 135651 | g78454 | i0 | 45.7 | 4.81967213114754 | 81 | 43 | 98.4 | 1 | 242 | 3 | 184 | 264 | EGT37515.1 hypothetical protein CAEBREN_16632 [Caenorhabditis brenneri] | diamond | 1176 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis brenneri |
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);;