contig_metadata
15 rows where bioproject = "PRJNA635874", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15182908 | 15182908 | PRJNA635874_P_NODE_36412_length_280_cov_1.256039_g36265_i0 | PRJNA635874 | 36412 | 280 | 1.256039 | 3.5169092 | Pristionchus | 54125 | Nematoda | Nematoda | 106 | 1.95e-18 | NTclustered | gi|150984424|gb|EF634854.1| | 54126 | g36265 | i0 | 91.026 | 9.56071428571429 | 78 | 7 | 28 | 0 | 137 | 214 | 495 | 572 | Pristionchus pacificus small subunit ribosomal protein 8 (rps-8) mRNA, partial cds | blastn | 2677 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 22831584 | 22831584 | PRJNA635874_P_NODE_17298_length_372_cov_2.434783_g17151_i0 | PRJNA635874 | 17298 | 372 | 2.434783 | 9.05739276 | Trichuris trichiura | 36087 | Nematoda | Nematoda | 172 | 1.44e-52 | NR | CDW60131.1 | 36087 | g17151 | i0 | 63.9 | 6.91129032258065 | 122 | 44 | 98.4 | 0 | 368 | 3 | 6 | 127 | CDW60131.1 60S ribosomal protein L27a [Trichuris trichiura] | diamond | 2571 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 23559943 | 23559943 | PRJNA635874_P_NODE_33279_length_290_cov_1.341014_g33132_i0 | PRJNA635874 | 33279 | 290 | 1.341014 | 3.8889406 | Opisthokonta | 33154 | Nematoda | Nematoda | 123 | 3.5e-30 | NR | KRY59418.1 | 45882 | g33132 | i0 | 65 | 8.96896551724138 | 100 | 29 | 97.2 | 2 | 283 | 2 | 76 | 175 | KRY59418.1 putative pre-mRNA-splicing factor ATP-dependent RNA helicase DHX15, partial [Trichinella britovi] | diamond | 2601 | 124 | 0.991935483870968 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella britovi | |
| 26637730 | 26637730 | PRJNA635874_P_NODE_1141_length_1051_cov_2.864008_g1040_i0 | PRJNA635874 | 1141 | 1051 | 2.864008 | 30.10072408 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 112 | 1.15e-24 | NR | AVZ46778.1 | 189291 | g1040 | i0 | 51.5 | 0.371075166508088 | 130 | 62 | 36.8 | 1 | 343 | 729 | 117 | 246 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 390 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 27143767 | 27143767 | PRJNA635874_P_NODE_41662_length_264_cov_1.183246_g41515_i0 | PRJNA635874 | 41662 | 264 | 1.183246 | 3.12376944 | Dracunculus medinensis | 318479 | Nematoda | Nematoda | 119 | 1.1e-31 | NR | VDN51048.1 | 318479 | g41515 | i0 | 69 | 0.954545454545455 | 84 | 25 | 95.5 | 1 | 4 | 255 | 51 | 133 | VDN51048.1 unnamed protein product [Dracunculus medinensis] | diamond | 252 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Dracunculidae | Dracunculus | Dracunculus medinensis | |
| 29291431 | 29291431 | PRJNA635874_P_NODE_19629_length_355_cov_1.198582_g19482_i0 | PRJNA635874 | 19629 | 355 | 1.198582 | 4.2549661 | Dracunculus medinensis | 318479 | Nematoda | Nematoda | 79.7 | 1.13e-14 | NR | VDN52825.1 | 318479 | g19482 | i0 | 38.9 | 1.83380281690141 | 108 | 59 | 89.6 | 2 | 330 | 13 | 40 | 142 | VDN52825.1 unnamed protein product [Dracunculus medinensis] | diamond | 651 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Dracunculidae | Dracunculus | Dracunculus medinensis | |
| 29512336 | 29512336 | PRJNA635874_P_NODE_28970_length_307_cov_0.807692_g28823_i0 | PRJNA635874 | 28970 | 307 | 0.807692 | 2.47961444 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 55.5 | 2.73e-6 | NR | CAD2154976.1 | 390850 | g28823 | i0 | 36.1 | 0.947882736156352 | 97 | 58 | 91.9 | 2 | 17 | 298 | 134 | 229 | CAD2154976.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 291 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 29606837 | 29606837 | PRJNA635874_P_NODE_16950_length_375_cov_1.784768_g16803_i0 | PRJNA635874 | 16950 | 375 | 1.784768 | 6.69288 | Wuchereria bancrofti | 6293 | Nematoda | Nematoda | 44.7 | 0.0305 | NR | VDM16675.1 | 6293 | g16803 | i0 | 52.4 | 0.336 | 42 | 20 | 33.6 | 0 | 148 | 23 | 173 | 214 | VDM16675.1 unnamed protein product [Wuchereria bancrofti] | diamond | 126 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 29701590 | 29701590 | PRJNA635874_P_NODE_690_length_1249_cov_1.091837_g619_i0 | PRJNA635874 | 690 | 1249 | 1.091837 | 13.63704413 | Wuchereria bancrofti | 6293 | Nematoda | Nematoda | 188 | 1.69e-51 | NR | VDM16675.1 | 6293 | g619 | i0 | 44.6 | 0.576461168935148 | 240 | 133 | 57.6 | 0 | 1235 | 516 | 172 | 411 | VDM16675.1 unnamed protein product [Wuchereria bancrofti] | diamond | 720 | 188 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 29859785 | 29859785 | PRJNA635874_P_NODE_49031_length_250_cov_0.870056_g48884_i0 | PRJNA635874 | 49031 | 250 | 0.870056 | 2.17514 | Dictyocaulus viviparus | 29172 | Nematoda | Nematoda | 57.4 | 2.83e-7 | NR | KJH40125.1 | 29172 | g48884 | i0 | 65.9 | 0.492 | 41 | 14 | 49.2 | 0 | 219 | 97 | 188 | 228 | KJH40125.1 homeobox domain protein [Dictyocaulus viviparus] | diamond | 123 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Dictyocaulus | Dictyocaulus viviparus | |
| 29998828 | 29998828 | PRJNA635874_P_NODE_20131_length_352_cov_0.949821_g19984_i0 | PRJNA635874 | 20131 | 352 | 0.949821 | 3.34336992 | Rhabditida | 6236 | Nematoda | Nematoda | 144 | 2.33e-41 | NR | XGW27839.1 | 6289 | g19984 | i0 | 56.4 | 6.98011363636364 | 117 | 51 | 99.7 | 0 | 1 | 351 | 30 | 146 | XGW27839.1 hypothetical protein V3C99_007992, partial [Haemonchus contortus] | diamond | 2457 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Haemonchus | Haemonchus contortus | |
| 30598850 | 30598850 | PRJNA635874_P_NODE_62993_length_245_cov_0.895349_g62846_i0 | PRJNA635874 | 62993 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 114 | 1.84e-27 | NR | KHN81895.1 | 6265 | g62846 | i0 | 64.2 | 8.90204081632653 | 81 | 29 | 99.2 | 0 | 2 | 244 | 913 | 993 | KHN81895.1 putative coatomer subunit beta' [Toxocara canis] | diamond | 2181 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 31534919 | 31534919 | PRJNA635874_P_NODE_72796_length_241_cov_0.916667_g72649_i0 | PRJNA635874 | 72796 | 241 | 0.916667 | 2.20916747 | Auanema sp. JU1783 | 2878363 | Nematoda | Nematoda | 54.7 | 2.33e-6 | NR | CAI4220994.1 | 2878363 | g72649 | i0 | 42.4 | 1.29460580912863 | 59 | 30 | 68.5 | 2 | 168 | 4 | 373 | 431 | CAI4220994.1 unnamed protein product [Auanema sp. JU1783] | diamond | 312 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Auanema | Auanema sp. JU1783 | |
| 32021746 | 32021746 | PRJNA635874_P_NODE_33558_length_289_cov_1.425926_g33411_i0 | PRJNA635874 | 33558 | 289 | 1.425926 | 4.12092614 | Opisthokonta | 33154 | Nematoda | Nematoda | 123 | 8.53e-32 | NR | XP_024509313.1 | 34506 | g33411 | i0 | 63.8 | 45.19723183391 | 94 | 34 | 97.6 | 0 | 6 | 287 | 28 | 121 | XP_024509313.1 60S acidic ribosomal protein P0 [Strongyloides ratti] | diamond | 13062 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 32515732 | 32515732 | PRJNA635874_P_NODE_1559_length_945_cov_2.647936_g1452_i0 | PRJNA635874 | 1559 | 945 | 2.647936 | 25.0229952 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 60.1 | 2.82e-6 | NR | AVZ46778.1 | 189291 | g1452 | i0 | 32.3 | 0.412698412698413 | 130 | 88 | 41.3 | 0 | 152 | 541 | 117 | 246 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 390 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola |
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);;