contig_metadata
26 rows where bioproject = "PRJNA788929", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 769694 | 769694 | PRJNA788929_P_NODE_6921_length_721_cov_122.435185_g6290_i0 | PRJNA788929 | 6921 | 721 | 122.435185 | 882.75768385 | Metazoa | 33208 | Nematoda | Nematoda | 216 | 2.44e-67 | NR | CAJ0602523.1 | 53992 | g6290 | i0 | 61.1 | 16.1317614424411 | 162 | 63 | 67.4 | 0 | 649 | 164 | 40 | 201 | CAJ0602523.1 unnamed protein product, partial [Cylicocyclus nassatus] | diamond | 11631 | 216 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Cylicocyclus | Cylicocyclus nassatus | |
| 2045030 | 2045030 | PRJNA788929_P_NODE_14782_length_439_cov_62.363388_g14123_i0 | PRJNA788929 | 14782 | 439 | 62.363388 | 273.77527332 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.012 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g14123 | i0 | 100 | 0.0660592255125285 | 29 | 0 | 7 | 0 | 1 | 29 | 23 | 51 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 3320611 | 3320611 | PRJNA788929_P_NODE_30483_length_285_cov_23.245283_g29822_i0 | PRJNA788929 | 30483 | 285 | 23.245283 | 66.24905655 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.026 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g29822 | i0 | 100 | 0.0982456140350877 | 28 | 0 | 10 | 0 | 1 | 28 | 25 | 52 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 3765816 | 3765816 | PRJNA788929_P_NODE_10223_length_558_cov_33.868041_g9570_i0 | PRJNA788929 | 10223 | 558 | 33.868041 | 188.98366878 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.5 | 0.004 | NTclustered | gi|1376138789|ref|XM_024649631.1| | 34506 | g9570 | i0 | 94.595 | 0.489247311827957 | 37 | 0 | 6 | 2 | 154 | 188 | 1706 | 1670 | Strongyloides ratti Voltage-dependent calcium channel type A subunit alpha-1 (SRAE_1000254200), partial mRNA | blastn | 273 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 4597391 | 4597391 | PRJNA788929_P_NODE_16384_length_412_cov_57.598820_g15725_i0 | PRJNA788929 | 16384 | 412 | 57.59882 | 237.3071384 | Aphelenchoides sp. 2 HMM2018 | 2109771 | Nematoda | Nematoda | 69.4 | 3.93e-7 | NTclustered | gi|1359463253|gb|KY750851.1| | 2109771 | g15725 | i0 | 87.097 | 0.684466019417476 | 62 | 7 | 15 | 1 | 1 | 61 | 257 | 196 | Aphelenchoides sp. 2 HMM2018 isolate HMM716 28S ribosomal RNA gene, partial sequence | blastn | 282 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides sp. 2 HMM2018 | |
| 6318217 | 6318217 | PRJNA788929_P_NODE_21925_length_347_cov_8.839416_g21264_i0 | PRJNA788929 | 21925 | 347 | 8.839416 | 30.67277352 | Panagrolaimus | 55784 | Nematoda | Nematoda | 512 | 1.25e-140 | NTclustered | gi|166014126|gb|EU253569.1| | 55785 | g21264 | i0 | 95.077 | 96.1556195965418 | 325 | 16 | 94 | 0 | 23 | 347 | 2496 | 2820 | Panagrolaimus sp. PS1159 28S large subunit ribosomal RNA gene, partial sequence | blastn | 33366 | 512 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Panagrolaimus | Panagrolaimus sp. PS1159 | |
| 7147682 | 7147682 | PRJNA788929_P_NODE_18806_length_379_cov_45.758170_g18146_i0 | PRJNA788929 | 18806 | 379 | 45.75817 | 173.4234643 | Oscheius dolichura | 473156 | Nematoda | Nematoda | 582 | 1.04e-161 | NTclustered | gi|158821907|gb|EU195971.1| | 473156 | g18146 | i0 | 97.376 | 91.2321899736148 | 343 | 8 | 91 | 1 | 25 | 367 | 1886 | 2227 | Oscheius dolichura strain JU460 28S ribosomal RNA gene, partial sequence | blastn | 34577 | 582 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Oscheius | Oscheius dolichura | |
| 8422215 | 8422215 | PRJNA788929_P_NODE_12607_length_487_cov_7.236715_g11950_i0 | PRJNA788929 | 12607 | 487 | 7.236715 | 35.24280205 | Mecistocirrus digitatus | 237660 | Nematoda | Nematoda | 178 | 7.51e-40 | NTclustered | gi|288904190|ref|NC_013848.1| | 237660 | g11950 | i0 | 77.204 | 56.9794661190965 | 329 | 59 | 66 | 14 | 83 | 402 | 13885 | 13564 | Mecistocirrus digitatus mitochondrion, complete genome | blastn | 27749 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Mecistocirrus | Mecistocirrus digitatus | |
| 8422805 | 8422805 | PRJNA788929_P_NODE_50007_length_198_cov_6.992000_g49346_i0 | PRJNA788929 | 50007 | 198 | 6.992 | 13.84416 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.017 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g49346 | i0 | 100 | 0.141414141414141 | 28 | 0 | 14 | 0 | 171 | 198 | 52 | 25 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 12249000 | 12249000 | PRJNA788929_P_NODE_36630_length_255_cov_15.428571_g35969_i0 | PRJNA788929 | 36630 | 255 | 15.428571 | 39.34285605 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.023 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g35969 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 228 | 255 | 52 | 25 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 12249186 | 12249186 | PRJNA788929_P_NODE_49370_length_202_cov_8.604651_g48709_i0 | PRJNA788929 | 49370 | 202 | 8.604651 | 17.38139502 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.018 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g48709 | i0 | 100 | 0.138613861386139 | 28 | 0 | 14 | 0 | 1 | 28 | 25 | 52 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 13968316 | 13968316 | PRJNA788929_P_NODE_46791_length_219_cov_4.095890_g46130_i0 | PRJNA788929 | 46791 | 219 | 4.09589 | 8.9699991 | Metazoa | 33208 | Nematoda | Nematoda | 340 | 3.69e-89 | NTclustered | gi|1174020828|gb|KY887583.1| | 6293 | g46130 | i0 | 100 | 84.027397260274 | 184 | 0 | 84 | 0 | 22 | 205 | 1530 | 1713 | Wuchereria bancrofti isolate AP10 small subunit ribosomal RNA gene, partial sequence | blastn | 18402 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 14798232 | 14798232 | PRJNA788929_P_NODE_46392_length_221_cov_8.439189_g45731_i0 | PRJNA788929 | 46392 | 221 | 8.439189 | 18.65060769 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.02 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g45731 | i0 | 100 | 0.126696832579186 | 28 | 0 | 13 | 0 | 1 | 28 | 25 | 52 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 24995947 | 24995947 | PRJNA788929_P_NODE_34980_length_263_cov_1.857895_g34319_i0 | PRJNA788929 | 34980 | 263 | 1.857895 | 4.88626385 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.024 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g34319 | i0 | 100 | 0.106463878326996 | 28 | 0 | 11 | 0 | 236 | 263 | 50 | 23 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 26778239 | 26778239 | PRJNA788929_P_NODE_7601_length_677_cov_85.793046_g6960_i0 | PRJNA788929 | 7601 | 677 | 85.793046 | 580.81892142 | Rhabditida | 6236 | Nematoda | Nematoda | 133 | 6.970000000000001e-36 | NR | KHN79676.1 | 6265 | g6960 | i0 | 51.2 | 4.98966026587888 | 125 | 60 | 55.4 | 1 | 582 | 208 | 9 | 132 | KHN79676.1 40S ribosomal protein S12 [Toxocara canis] | diamond | 3378 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 27306704 | 27306704 | PRJNA788929_P_NODE_8383_length_635_cov_190.258007_g7735_i0 | PRJNA788929 | 8383 | 635 | 190.258007 | 1208.13834445 | Dracunculus medinensis | 318479 | Nematoda | Nematoda | 122 | 8.04e-32 | NR | VDN56922.1 | 318479 | g7735 | i0 | 56.2 | 1.72913385826772 | 121 | 53 | 57.2 | 0 | 558 | 196 | 3 | 123 | VDN56922.1 unnamed protein product [Dracunculus medinensis] | diamond | 1098 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Dracunculidae | Dracunculus | Dracunculus medinensis | |
| 27874912 | 27874912 | PRJNA788929_P_NODE_20885_length_357_cov_2.580986_g20225_i0 | PRJNA788929 | 20885 | 357 | 2.580986 | 9.21412002 | Caenorhabditis auriculariae | 2777116 | Nematoda | Nematoda | 167 | 2.28e-45 | NR | CAD6185005.1 | 2777116 | g20225 | i0 | 78.5 | 1.79831932773109 | 107 | 22 | 89.1 | 1 | 24 | 341 | 654 | 760 | CAD6185005.1 unnamed protein product [Caenorhabditis auriculariae] | diamond | 642 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis auriculariae | |
| 28853570 | 28853570 | PRJNA788929_P_NODE_12788_length_483_cov_1.765854_g12131_i0 | PRJNA788929 | 12788 | 483 | 1.765854 | 8.52907482 | Caenorhabditis auriculariae | 2777116 | Nematoda | Nematoda | 69.7 | 1.48e-10 | NR | CAD6193562.1 | 2777116 | g12131 | i0 | 38.9 | 0.559006211180124 | 90 | 54 | 55.9 | 1 | 63 | 332 | 264 | 352 | CAD6193562.1 unnamed protein product [Caenorhabditis auriculariae] | diamond | 270 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis auriculariae | |
| 29516697 | 29516697 | PRJNA788929_P_NODE_49250_length_203_cov_6.461538_g48589_i0 | PRJNA788929 | 49250 | 203 | 6.461538 | 13.11692214 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 70.9 | 1.39e-13 | NR | KAE9549433.1 | 2598192 | g48589 | i0 | 64.2 | 3.22167487684729 | 53 | 19 | 78.3 | 0 | 11 | 169 | 88 | 140 | KAE9549433.1 hypothetical protein FO519_007346, partial [Halicephalobus sp. NKZ332] | diamond | 654 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 | |
| 30653875 | 30653875 | PRJNA788929_P_NODE_15553_length_425_cov_35.622159_g14894_i0 | PRJNA788929 | 15553 | 425 | 35.622159 | 151.39417575 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 50.4 | 5.19e-4 | NR | CAJ0575544.1 | 96644 | g14894 | i0 | 39.8 | 0.585882352941177 | 83 | 46 | 57.9 | 3 | 18 | 263 | 210 | 289 | CAJ0575544.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 249 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 30852787 | 30852787 | PRJNA788929_P_NODE_26934_length_307_cov_1.316239_g26273_i0 | PRJNA788929 | 26934 | 307 | 1.316239 | 4.04085373 | root | 1 | Root_unresolved | Root_unresolved | 186 | 8.79e-57 | NR | ETN71555.1 | 51031 | g26273 | i0 | 86.3 | 1.99348534201954 | 102 | 14 | 99.7 | 0 | 2 | 307 | 30 | 131 | ETN71555.1 Replication protein [Necator americanus] | diamond | 612 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 31136894 | 31136894 | PRJNA788929_P_NODE_45535_length_226_cov_10.633987_g44874_i0 | PRJNA788929 | 45535 | 226 | 10.633987 | 24.03281062 | root | 1 | Root_unresolved | Root_unresolved | 47.8 | 4.94e-4 | NR | XP_024510682.1 | 34506 | g44874 | i0 | 84.6 | 4.65929203539823 | 26 | 4 | 34.5 | 0 | 136 | 213 | 10 | 35 | XP_024510682.1 Pyruvate dehydrogenase E1 component subunit beta, mitochondrial [Strongyloides ratti] | diamond | 1053 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 31390321 | 31390321 | PRJNA788929_P_NODE_7796_length_668_cov_41.258824_g7154_i0 | PRJNA788929 | 7796 | 668 | 41.258824 | 275.60894432 | Rhabditida | 6236 | Nematoda | Nematoda | 134 | 4.48e-36 | NR | KHN79676.1 | 6265 | g7154 | i0 | 51.2 | 5.16017964071856 | 125 | 60 | 56.1 | 1 | 104 | 478 | 9 | 132 | KHN79676.1 40S ribosomal protein S12 [Toxocara canis] | diamond | 3447 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 31475943 | 31475943 | PRJNA788929_P_NODE_43396_length_237_cov_9.615854_g42735_i0 | PRJNA788929 | 43396 | 237 | 9.615854 | 22.78957398 | Pristionchus entomophagus | 358040 | Nematoda | Nematoda | 42.7 | 0.0351 | NR | GMS92544.1 | 358040 | g42735 | i0 | 45.7 | 0.582278481012658 | 46 | 25 | 58.2 | 0 | 161 | 24 | 147 | 192 | GMS92544.1 hypothetical protein PENTCL1PPCAC_14719, partial [Pristionchus entomophagus] | diamond | 138 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus entomophagus | |
| 32361871 | 32361871 | PRJNA788929_P_NODE_44659_length_231_cov_2.481013_g43998_i0 | PRJNA788929 | 44659 | 231 | 2.481013 | 5.73114003 | Caenorhabditis bovis | 2654633 | Nematoda | Nematoda | 85.9 | 1.93e-17 | NR | CAB3406122.1 | 2654633 | g43998 | i0 | 57.4 | 1.58441558441558 | 61 | 26 | 79.2 | 0 | 49 | 231 | 1 | 61 | CAB3406122.1 unnamed protein product [Caenorhabditis bovis] | diamond | 366 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis bovis | |
| 32371022 | 32371022 | PRJNA788929_P_NODE_15819_length_421_cov_22.204023_g15160_i0 | PRJNA788929 | 15819 | 421 | 22.204023 | 93.47893683 | Metazoa | 33208 | Nematoda | Nematoda | 146 | 9.48e-41 | NR | KHN80245.1 | 6265 | g15160 | i0 | 85.5 | 66.2850356294537 | 76 | 11 | 54.2 | 0 | 398 | 171 | 168 | 243 | KHN80245.1 ADP-ribosylation factor 1-like 2 [Toxocara canis] | diamond | 27906 | 147 | 0.993197278911565 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis |
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);;