contig_metadata
23 rows where bioproject = "PRJNA1035005", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 2719588 | 2719588 | PRJNA1035005_P_NODE_83083_length_243_cov_0.917647_g82677_i0 | PRJNA1035005 | 83083 | 243 | 0.917647 | 2.22988221 | Fictor sp. 2 VS-2014 | 1538695 | Nematoda | Nematoda | 104 | 5.96e-18 | NTclustered | gi|675118819|gb|KJ877289.1| | 1538695 | g82677 | i0 | 79.861 | 4.88477366255144 | 144 | 28 | 59 | 1 | 32 | 174 | 198 | 55 | Fictor sp. 2 VS-2014 strain RS9002 large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 1187 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Fictor | Fictor sp. 2 VS-2014 | |
| 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 | |
| 6546952 | 6546952 | PRJNA1035005_P_NODE_4606_length_496_cov_2.014184_g4206_i0 | PRJNA1035005 | 4606 | 496 | 2.014184 | 9.99035264 | Oscheius tipulae | 141969 | Nematoda | Nematoda | 911 | 0 | NTclustered | gi|158821905|gb|EU195969.1| | 141969 | g4206 | i0 | 99.798 | 100.618951612903 | 496 | 1 | 100 | 0 | 1 | 496 | 1895 | 1400 | Oscheius tipulae strain CEW1 28S ribosomal RNA gene, partial sequence | blastn | 49907 | 911 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Oscheius | Oscheius tipulae | |
| 7821479 | 7821479 | PRJNA1035005_P_NODE_4527_length_501_cov_1.406542_g4128_i0 | PRJNA1035005 | 4527 | 501 | 1.406542 | 7.04677542 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 58.4 | 0.001 | NTclustered | gi|413002270|emb|Z50005.2| | 6239 | g4128 | i0 | 100 | 0.12375249500998 | 31 | 0 | 6 | 0 | 139 | 169 | 6337 | 6307 | Caenorhabditis elegans Cosmid F16H9, complete sequence | blastn | 62 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 7821660 | 7821660 | PRJNA1035005_P_NODE_69167_length_247_cov_2.902299_g68761_i0 | PRJNA1035005 | 69167 | 247 | 2.902299 | 7.16867853 | Parastrongyloides trichosuri | 131310 | Nematoda | Nematoda | 134 | 7.750000000000001e-27 | NTclustered | gi|9438175|gb|AF278536.1| | 131310 | g68761 | i0 | 76.829 | 1.51012145748988 | 246 | 52 | 98 | 4 | 3 | 244 | 2699 | 2943 | Parastrongyloides trichosuri heat shock 70 protein gene, complete cds | blastn | 373 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Parastrongyloides | Parastrongyloides trichosuri | |
| 11211286 | 11211286 | PRJNA1035005_P_NODE_8609_length_382_cov_1.003236_g8207_i0 | PRJNA1035005 | 8609 | 382 | 1.003236 | 3.83236152 | Metazoa | 33208 | Nematoda | Nematoda | 228 | 5.639999999999998e-55 | NTclustered | gi|255098668|gb|FJ555023.1| | 6325 | g8207 | i0 | 78.655 | 80.8821989528796 | 342 | 73 | 90 | 0 | 25 | 366 | 958 | 617 | Bursaphelenchus mucronatus heat shock protein 70 (hsp70) mRNA, complete cds | blastn | 30897 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus mucronatus | |
| 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 | |
| 19294497 | 19294497 | PRJNA1035005_P_NODE_21776_length_294_cov_1.411765_g21370_i0 | PRJNA1035005 | 21776 | 294 | 1.411765 | 4.1505891 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 226 | 1.52e-54 | NTclustered | gi|1376136021|ref|XM_024648069.1| | 34506 | g21370 | i0 | 81.034 | 27.9421768707483 | 290 | 50 | 97 | 5 | 9 | 294 | 299 | 11 | Strongyloides ratti Histone H3 (SRAE_1000114900), partial mRNA | blastn | 8215 | 226 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 20569886 | 20569886 | PRJNA1035005_P_NODE_22697_length_292_cov_1.401826_g22291_i0 | PRJNA1035005 | 22697 | 292 | 1.401826 | 4.09333192 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 252 | 2.4899999999999998e-62 | NTclustered | gi|687865697|emb|LK927572.1| | 6239 | g22291 | i0 | 84.17 | 132.325342465753 | 259 | 41 | 95 | 0 | 1 | 259 | 119839 | 120097 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000039 | blastn | 38639 | 252 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 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);;