contig_metadata
14 rows where bioproject = "PRJNA883229", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8512806 | 8512806 | PRJNA883229_P_NODE_12547_length_248_cov_0.891429_g12501_i0 | PRJNA883229 | 12547 | 248 | 0.891429 | 2.21074392 | Aphelenchoides avenae | 70226 | Nematoda | Nematoda | 166 | 2.19e-45 | NR | KAH7729562.1 | 70226 | g12501 | i0 | 92.7 | 9.91935483870968 | 82 | 6 | 99.2 | 0 | 247 | 2 | 2604 | 2685 | KAH7729562.1 HECTUBA and WWE domain containing 1 [Aphelenchoides avenae] | diamond | 2460 | 166 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 8512923 | 8512923 | PRJNA883229_P_NODE_7767_length_263_cov_2.047368_g7721_i0 | PRJNA883229 | 7767 | 263 | 2.047368 | 5.38457784 | Teratorhabditis mariannae | 466949 | Nematoda | Nematoda | 187 | 6.309999999999998e-43 | NTclustered | gi|156915107|gb|EF990721.1| | 466949 | g7721 | i0 | 84.896 | 56.8250950570342 | 192 | 21 | 71 | 7 | 1 | 187 | 2966 | 3154 | Teratorhabditis mariannae strain SB170 28S large subunit ribosomal RNA gene, partial sequence | blastn | 14945 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Teratorhabditis | Teratorhabditis mariannae | |
| 8512930 | 8512930 | PRJNA883229_P_NODE_8507_length_253_cov_1.733333_g8461_i0 | PRJNA883229 | 8507 | 253 | 1.733333 | 4.38533249 | Rhabditida | 6236 | Nematoda | Nematoda | 140 | 5.81e-41 | NR | VDN50060.1 | 318479 | g8461 | i0 | 82.1 | 1.87351778656126 | 78 | 14 | 92.5 | 0 | 235 | 2 | 1 | 78 | VDN50060.1 unnamed protein product [Dracunculus medinensis] | diamond | 474 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Dracunculidae | Dracunculus | Dracunculus medinensis | |
| 21643343 | 21643343 | PRJNA883229_P_NODE_9997_length_251_cov_0.876404_g9951_i0 | PRJNA883229 | 9997 | 251 | 0.876404 | 2.19977404 | Aphelenchoides avenae | 70226 | Nematoda | Nematoda | 106 | 1.49e-26 | NR | KAH7728507.1 | 70226 | g9951 | i0 | 71.1 | 0.908366533864542 | 76 | 22 | 90.8 | 0 | 15 | 242 | 136 | 211 | KAH7728507.1 50S ribosomal protein L13e [Aphelenchoides avenae] | diamond | 228 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 26833937 | 26833937 | PRJNA883229_P_NODE_10961_length_250_cov_0.881356_g10915_i0 | PRJNA883229 | 10961 | 250 | 0.881356 | 2.20339 | Caenorhabditis brenneri | 135651 | Nematoda | Nematoda | 74.7 | 4.49e-14 | NR | ACD12696.1 | 135651 | g10915 | i0 | 48.5 | 5.412 | 66 | 33 | 79.2 | 1 | 204 | 7 | 39 | 103 | ACD12696.1 initiation factor, partial [Caenorhabditis brenneri] | diamond | 1353 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis brenneri | |
| 27213232 | 27213232 | PRJNA883229_P_NODE_8882_length_253_cov_0.866667_g8836_i0 | PRJNA883229 | 8882 | 253 | 0.866667 | 2.19266751 | Aphelenchoides avenae | 70226 | Nematoda | Nematoda | 90.1 | 2.85e-21 | NR | KAH7706254.1 | 70226 | g8836 | i0 | 55 | 1.93280632411067 | 80 | 33 | 94.9 | 2 | 252 | 13 | 8 | 84 | KAH7706254.1 Protein SUP-1 [Aphelenchoides avenae] | diamond | 489 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 27600606 | 27600606 | PRJNA883229_P_NODE_10504_length_250_cov_1.762712_g10458_i0 | PRJNA883229 | 10504 | 250 | 1.762712 | 4.40678 | Meloidogyne | 189290 | Nematoda | Nematoda | 150 | 1.25e-41 | NR | KAF7637933.1 | 189291 | g10458 | i0 | 84.3 | 8.916 | 83 | 13 | 99.6 | 0 | 250 | 2 | 271 | 353 | KAF7637933.1 hypothetical protein Mgra_00002636 [Meloidogyne graminicola] | diamond | 2229 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 27813725 | 27813725 | PRJNA883229_P_NODE_10644_length_250_cov_0.881356_g10598_i0 | PRJNA883229 | 10644 | 250 | 0.881356 | 2.20339 | Ditylenchus destructor | 166010 | Nematoda | Nematoda | 85.1 | 2.67e-17 | NR | KAI1732175.1 | 166010 | g10598 | i0 | 57.8 | 0.768 | 64 | 27 | 76.8 | 0 | 193 | 2 | 1 | 64 | KAI1732175.1 ras association domain-containing protein 7 [Ditylenchus destructor] | diamond | 192 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 28042498 | 28042498 | PRJNA883229_P_NODE_10985_length_250_cov_0.881356_g10939_i0 | PRJNA883229 | 10985 | 250 | 0.881356 | 2.20339 | Rhabditida | 6236 | Nematoda | Nematoda | 99 | 1.98e-22 | NR | VDK57056.1 | 6269 | g10939 | i0 | 90.4 | 8.88 | 52 | 5 | 62.4 | 0 | 3 | 158 | 63 | 114 | VDK57056.1 unnamed protein product [Anisakis simplex] | diamond | 2220 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anisakidae | Anisakis | Anisakis simplex | |
| 29431470 | 29431470 | PRJNA883229_P_NODE_4629_length_317_cov_0.959016_g4583_i0 | PRJNA883229 | 4629 | 317 | 0.959016 | 3.04008072 | Angiostrongylus | 6312 | Nematoda | Nematoda | 118 | 1.03e-28 | NR | KAE9419430.1 | 6313 | g4583 | i0 | 66.7 | 1.9211356466877 | 102 | 31 | 93.7 | 2 | 3 | 299 | 409 | 510 | KAE9419430.1 hypothetical protein Angca_007565, partial [Angiostrongylus cantonensis] | diamond | 609 | 119 | 0.991596638655462 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Angiostrongylus | Angiostrongylus cantonensis | |
| 29778986 | 29778986 | PRJNA883229_P_NODE_13551_length_246_cov_0.901734_g13505_i0 | PRJNA883229 | 13551 | 246 | 0.901734 | 2.21826564 | Caenorhabditis | 6237 | Nematoda | Nematoda | 124 | 4.42e-33 | NR | CAB3403121.1 | 2654633 | g13505 | i0 | 71.3 | 2.9390243902439 | 80 | 23 | 97.6 | 0 | 7 | 246 | 152 | 231 | CAB3403121.1 unnamed protein product [Caenorhabditis bovis] | diamond | 723 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis bovis | |
| 30316602 | 30316602 | PRJNA883229_P_NODE_9932_length_251_cov_0.876404_g9886_i0 | PRJNA883229 | 9932 | 251 | 0.876404 | 2.19977404 | Rhabditida | 6236 | Nematoda | Nematoda | 113 | 3.07e-29 | NR | KAI1723810.1 | 166010 | g9886 | i0 | 66.7 | 3.72908366533865 | 78 | 26 | 93.2 | 0 | 18 | 251 | 1 | 78 | KAI1723810.1 ATP synthase subunit C domain-containing protein [Ditylenchus destructor] | diamond | 936 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 30537240 | 30537240 | PRJNA883229_P_NODE_11173_length_250_cov_0.881356_g11127_i0 | PRJNA883229 | 11173 | 250 | 0.881356 | 2.20339 | Rhabditida | 6236 | Nematoda | Nematoda | 135 | 8.139999999999998e-35 | NR | KAH7721995.1 | 70226 | g11127 | i0 | 74.4 | 9.84 | 82 | 21 | 98.4 | 0 | 248 | 3 | 570 | 651 | KAH7721995.1 Glycine cleavage T-protein [Aphelenchoides avenae] | diamond | 2460 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 30560655 | 30560655 | PRJNA883229_P_NODE_14333_length_245_cov_0.906977_g14287_i0 | PRJNA883229 | 14333 | 245 | 0.906977 | 2.22209365 | Aphelenchoides avenae | 70226 | Nematoda | Nematoda | 59.7 | 8.52e-9 | NR | KAH7727609.1 | 70226 | g14287 | i0 | 56.5 | 1.1265306122449 | 46 | 20 | 56.3 | 0 | 240 | 103 | 118 | 163 | KAH7727609.1 Protein Y48A6B.3 [Aphelenchoides avenae] | diamond | 276 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae |
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);;