contig_metadata
17 rows where bioproject = "PRJNA533623", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6221637 | 6221637 | PRJNA533623_P_NODE_54385_length_275_cov_40.481308_g52606_i0 | PRJNA533623 | 54385 | 275 | 40.481308 | 111.323597 | Xiphinema | 46002 | Nematoda | Nematoda | 340 | 4.82e-89 | NTclustered | gi|32527557|gb|AY210845.1| | 70223 | g52606 | i0 | 91.235 | 54.2618181818182 | 251 | 21 | 91 | 1 | 1 | 251 | 2816 | 2567 | Xiphinema rivesi 28S ribosomal RNA gene, partial sequence | blastn | 14922 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dorylaimida | Longidoridae | Xiphinema | Xiphinema rivesi | |
| 7496214 | 7496214 | PRJNA533623_P_NODE_64486_length_238_cov_2.033898_g62705_i0 | PRJNA533623 | 64486 | 238 | 2.033898 | 4.84067724 | Longidoridae | 46001 | Nematoda | Nematoda | 132 | 2.67e-26 | NTclustered | gi|32527557|gb|AY210845.1| | 70223 | g62705 | i0 | 94.186 | 36.5672268907563 | 86 | 5 | 36 | 0 | 1 | 86 | 2801 | 2716 | Xiphinema rivesi 28S ribosomal RNA gene, partial sequence | blastn | 8703 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dorylaimida | Longidoridae | Xiphinema | Xiphinema rivesi | |
| 9434351 | 9434351 | PRJNA533623_P_NODE_20908_length_509_cov_15.660714_g19161_i0 | PRJNA533623 | 20908 | 509 | 15.660714 | 79.71303426 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.014 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g19161 | i0 | 94.444 | 0.0707269155206287 | 36 | 1 | 7 | 1 | 1 | 35 | 23 | 58 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 15809967 | 15809967 | PRJNA533623_P_NODE_7453_length_850_cov_5.927757_g6043_i0 | PRJNA533623 | 7453 | 850 | 5.927757 | 50.3859345 | Gongylonema pulchrum | 637853 | Nematoda | Nematoda | 208 | 2.04e-63 | NR | VDN21636.1 | 637853 | g6043 | i0 | 61.8 | 9.40235294117647 | 157 | 59 | 55.4 | 1 | 363 | 833 | 29 | 184 | VDN21636.1 unnamed protein product [Gongylonema pulchrum] | diamond | 7992 | 208 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gongylonematidae | Gongylonema | Gongylonema pulchrum | |
| 23459277 | 23459277 | PRJNA533623_P_NODE_65159_length_235_cov_31.304598_g63378_i0 | PRJNA533623 | 65159 | 235 | 31.304598 | 73.5658053 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.021 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g63378 | i0 | 100 | 0.119148936170213 | 28 | 0 | 12 | 0 | 208 | 235 | 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 | |
| 26856526 | 26856526 | PRJNA533623_P_NODE_36021_length_369_cov_3.896104_g34249_i0 | PRJNA533623 | 36021 | 369 | 3.896104 | 14.37662376 | Ostertagia ostertagi | 6317 | Nematoda | Nematoda | 46.6 | 0.00533 | NR | KAK6013988.1 | 6317 | g34249 | i0 | 33.3 | 0.536585365853659 | 66 | 43 | 52.8 | 1 | 13 | 207 | 122 | 187 | KAK6013988.1 BTB/POZ domain protein, partial [Ostertagia ostertagi] | diamond | 198 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Ostertagia | Ostertagia ostertagi | |
| 27945581 | 27945581 | PRJNA533623_P_NODE_16005_length_589_cov_6.899621_g14291_i0 | PRJNA533623 | 16005 | 589 | 6.899621 | 40.63876769 | Onchocercidae | 6296 | Nematoda | Nematoda | 67.8 | 1.91e-9 | NR | VDK74082.1 | 42156 | g14291 | i0 | 33.3 | 2.10356536502547 | 126 | 78 | 61.1 | 1 | 46 | 405 | 310 | 435 | VDK74082.1 unnamed protein product [Litomosoides sigmodontis] | diamond | 1239 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Litomosoides | Litomosoides sigmodontis | |
| 28734964 | 28734964 | PRJNA533623_P_NODE_49527_length_296_cov_11.080851_g47748_i0 | PRJNA533623 | 49527 | 296 | 11.080851 | 32.79931896 | Metazoa | 33208 | Nematoda | Nematoda | 46.2 | 3.59e-4 | NR | TKR82886.1 | 34508 | g47748 | i0 | 51 | 2.90878378378378 | 51 | 25 | 51.7 | 0 | 228 | 76 | 14 | 64 | TKR82886.1 hypothetical protein L596_016558 [Steinernema carpocapsae] | diamond | 861 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 29540752 | 29540752 | PRJNA533623_P_NODE_25270_length_458_cov_10.241814_g23505_i0 | PRJNA533623 | 25270 | 458 | 10.241814 | 46.90750812 | Cylicocyclus nassatus | 53992 | Nematoda | Nematoda | 53.5 | 6.19e-5 | NR | CAJ0602149.1 | 53992 | g23505 | i0 | 47.1 | 0.825327510917031 | 51 | 26 | 32.8 | 1 | 37 | 186 | 335 | 385 | CAJ0602149.1 unnamed protein product [Cylicocyclus nassatus] | diamond | 378 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Cylicocyclus | Cylicocyclus nassatus | |
| 30046007 | 30046007 | PRJNA533623_P_NODE_51671_length_287_cov_1.429204_g49892_i0 | PRJNA533623 | 51671 | 287 | 1.429204 | 4.10181548 | Auanema sp. JU1783 | 2878363 | Nematoda | Nematoda | 55.5 | 2.18e-6 | NR | CAI4230385.1 | 2878363 | g49892 | i0 | 34.2 | 1.81881533101045 | 79 | 52 | 82.6 | 0 | 277 | 41 | 325 | 403 | CAI4230385.1 unnamed protein product [Auanema sp. JU1783] | diamond | 522 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Auanema | Auanema sp. JU1783 | |
| 30219029 | 30219029 | PRJNA533623_P_NODE_57792_length_262_cov_4.238806_g56012_i0 | PRJNA533623 | 57792 | 262 | 4.238806 | 11.10567172 | Metazoa | 33208 | Nematoda | Nematoda | 47 | 0.00145 | NR | VDP00748.1 | 241478 | g56012 | i0 | 42 | 3.44656488549618 | 50 | 29 | 57.3 | 0 | 252 | 103 | 316 | 365 | VDP00748.1 unnamed protein product [Soboliphyme baturini] | diamond | 903 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 30583087 | 30583087 | PRJNA533623_P_NODE_15953_length_590_cov_8.047259_g14239_i0 | PRJNA533623 | 15953 | 590 | 8.047259 | 47.4788281 | Steinernema carpocapsae | 34508 | Nematoda | Nematoda | 56.6 | 1.19e-5 | NR | TKR61882.1 | 34508 | g14239 | i0 | 38 | 0.777966101694915 | 71 | 39 | 36.1 | 2 | 85 | 297 | 293 | 358 | TKR61882.1 hypothetical protein L596_028934 [Steinernema carpocapsae] | diamond | 459 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 30945951 | 30945951 | PRJNA533623_P_NODE_16894_length_572_cov_7.956947_g15169_i0 | PRJNA533623 | 16894 | 572 | 7.956947 | 45.51373684 | Metazoa | 33208 | Nematoda | Nematoda | 125 | 9.57e-33 | NR | VDK69161.1 | 42157 | g15169 | i0 | 50.4 | 3.83916083916084 | 131 | 59 | 68.7 | 2 | 158 | 550 | 32 | 156 | VDK69161.1 unnamed protein product [Onchocerca ochengi] | diamond | 2196 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Onchocerca | Onchocerca ochengi | |
| 31436575 | 31436575 | PRJNA533623_P_NODE_71516_length_215_cov_4.162338_g69735_i0 | PRJNA533623 | 71516 | 215 | 4.162338 | 8.9490267 | Pristionchus pacificus | 54126 | Nematoda | Nematoda | 48.9 | 1.13e-4 | NR | KAF8362018.1 | 54126 | g69735 | i0 | 67.6 | 0.474418604651163 | 34 | 11 | 47.4 | 0 | 191 | 90 | 154 | 187 | KAF8362018.1 ddl-1 [Pristionchus pacificus] | diamond | 102 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 31784381 | 31784381 | PRJNA533623_P_NODE_23577_length_476_cov_26.734940_g21819_i0 | PRJNA533623 | 23577 | 476 | 26.73494 | 127.2583144 | Caenorhabditis portoensis | 1094334 | Nematoda | Nematoda | 88.6 | 1.13e-18 | NR | AET24964.1 | 1094334 | g21819 | i0 | 69 | 1.45588235294118 | 58 | 17 | 35.9 | 1 | 467 | 297 | 119 | 176 | AET24964.1 U3 small nucleolar ribonucleoprotein (snoRNP) component, partial [Caenorhabditis portoensis] | diamond | 693 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis portoensis | |
| 32306026 | 32306026 | PRJNA533623_P_NODE_20439_length_516_cov_11.615385_g18692_i0 | PRJNA533623 | 20439 | 516 | 11.615385 | 59.9353866 | Metazoa | 33208 | Nematoda | Nematoda | 59.3 | 9.87e-7 | NR | XP_024506430.1 | 34506 | g18692 | i0 | 42.9 | 2.25581395348837 | 70 | 36 | 39.5 | 3 | 292 | 495 | 45 | 112 | XP_024506430.1 GDP-Man:Man(3)GlcNAc(2)-PP-Dol alpha-1,2-mannosyltransferase [Strongyloides ratti] | diamond | 1164 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 32606936 | 32606936 | PRJNA533623_P_NODE_10440_length_726_cov_22.433083_g8869_i0 | PRJNA533623 | 10440 | 726 | 22.433083 | 162.86418258 | Thelazia callipaeda | 103827 | Nematoda | Nematoda | 52.4 | 4.79e-4 | NR | VDN02193.1 | 103827 | g8869 | i0 | 32.7 | 0.772727272727273 | 98 | 64 | 40.1 | 2 | 230 | 520 | 43 | 139 | VDN02193.1 unnamed protein product [Thelazia callipaeda] | diamond | 561 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Thelaziidae | Thelazia | Thelazia callipaeda |
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);;