contig_metadata
17 rows where bioproject = "PRJEB55122", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2267035 | 2267035 | PRJEB55122_P_NODE_6562_length_550_cov_2.069860_g6176_i0 | PRJEB55122 | 6562 | 550 | 2.06986 | 11.38423 | Metazoa | 33208 | Nematoda | Nematoda | 1016 | 0 | NTclustered | gi|158821895|gb|EU195959.1| | 479134 | g6176 | i0 | 100 | 74.6472727272727 | 550 | 0 | 100 | 0 | 1 | 550 | 1349 | 1898 | Diploscapter sp. JU359 28S ribosomal RNA gene, partial sequence | blastn | 41056 | 1016 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter sp. JU359 | |
| 9048633 | 9048633 | PRJEB55122_P_NODE_44008_length_159_cov_2.263636_g43611_i0 | PRJEB55122 | 44008 | 159 | 2.263636 | 3.59918124 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 215 | 1.59e-51 | NTclustered | gi|1972264646|ref|NM_066119.9| | 6239 | g43611 | i0 | 91.139 | 89.8993710691824 | 158 | 14 | 99 | 0 | 1 | 158 | 369 | 526 | Caenorhabditis elegans Elongation factor 1-alpha (eef-1A.1), mRNA | blastn | 14294 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 10324263 | 10324263 | PRJEB55122_P_NODE_38389_length_167_cov_0.881356_g37992_i0 | PRJEB55122 | 38389 | 167 | 0.881356 | 1.47186452 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 86.3 | 2.4e-18 | NR | PAV77129.1 | 2018661 | g37992 | i0 | 100 | 1.94011976047904 | 36 | 0 | 64.7 | 0 | 167 | 60 | 71 | 106 | PAV77129.1 hypothetical protein WR25_14227 [Diploscapter pachys] | diamond | 324 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 19246851 | 19246851 | PRJEB55122_P_NODE_39856_length_166_cov_0.888889_g39459_i0 | PRJEB55122 | 39856 | 166 | 0.888889 | 1.47555574 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 113 | 2.799999999999999e-29 | NR | PAV77213.1 | 2018661 | g39459 | i0 | 100 | 0.993975903614458 | 55 | 0 | 99.4 | 0 | 2 | 166 | 204 | 258 | PAV77213.1 hypothetical protein WR25_12777 [Diploscapter pachys] | diamond | 165 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 23073551 | 23073551 | PRJEB55122_P_NODE_7959_length_478_cov_1.312354_g7567_i0 | PRJEB55122 | 7959 | 478 | 1.312354 | 6.27305212 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 182 | 5.69e-41 | NTclustered | gi|1972261274|ref|NM_001384026.2| | 6239 | g7567 | i0 | 80.591 | 17.907949790795 | 237 | 44 | 49 | 2 | 221 | 456 | 138 | 373 | Caenorhabditis elegans ATP synthase c subunit (Y82E9BR.3), mRNA | blastn | 8560 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 26748228 | 26748228 | PRJEB55122_P_NODE_39621_length_166_cov_0.888889_g39224_i0 | PRJEB55122 | 39621 | 166 | 0.888889 | 1.47555574 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 115 | 2.37e-28 | NR | PAV57811.1 | 2018661 | g39224 | i0 | 100 | 0.993975903614458 | 55 | 0 | 99.4 | 0 | 165 | 1 | 1416 | 1470 | PAV57811.1 hypothetical protein WR25_20143 [Diploscapter pachys] | diamond | 165 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 27343138 | 27343138 | PRJEB55122_P_NODE_28103_length_200_cov_0.960265_g27706_i0 | PRJEB55122 | 28103 | 200 | 0.960265 | 1.92053 | Opisthokonta | 33154 | Nematoda | Nematoda | 98.2 | 6.29e-22 | NR | MCP9264969.1 | 6287 | g27706 | i0 | 69.7 | 15.84 | 66 | 20 | 99 | 0 | 200 | 3 | 827 | 892 | MCP9264969.1 60S ribosomal protein L10 [Dirofilaria immitis] | diamond | 3168 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Dirofilaria | Dirofilaria immitis | |
| 28290002 | 28290002 | PRJEB55122_P_NODE_42306_length_163_cov_0.912281_g41909_i0 | PRJEB55122 | 42306 | 163 | 0.912281 | 1.48701803 | Caenorhabditis | 6237 | Nematoda | Nematoda | 45.4 | 0.00136 | NR | NP_001366874.1 | 6239 | g41909 | i0 | 48 | 1.84049079754601 | 50 | 26 | 92 | 0 | 10 | 159 | 158 | 207 | NP_001366874.1 START domain-containing protein [Caenorhabditis elegans] | diamond | 300 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 28707479 | 28707479 | PRJEB55122_P_NODE_37127_length_169_cov_0.866667_g36730_i0 | PRJEB55122 | 37127 | 169 | 0.866667 | 1.46466723 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 71.6 | 2.1e-13 | NR | PAV65475.1 | 2018661 | g36730 | i0 | 94.3 | 1.24260355029586 | 35 | 2 | 62.1 | 0 | 1 | 105 | 187 | 221 | PAV65475.1 hypothetical protein WR25_26935 [Diploscapter pachys] | diamond | 210 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 29749012 | 29749012 | PRJEB55122_P_NODE_39411_length_166_cov_0.888889_g39014_i0 | PRJEB55122 | 39411 | 166 | 0.888889 | 1.47555574 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 107 | 2.53e-26 | NR | PAV58625.1 | 2018661 | g39014 | i0 | 98.2 | 0.993975903614458 | 55 | 1 | 99.4 | 0 | 166 | 2 | 257 | 311 | PAV58625.1 hypothetical protein WR25_06144 [Diploscapter pachys] | diamond | 165 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 30033675 | 30033675 | PRJEB55122_P_NODE_34411_length_176_cov_1.228346_g34014_i0 | PRJEB55122 | 34411 | 176 | 1.228346 | 2.16188896 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 62.4 | 7.77e-11 | NR | GMT14341.1 | 1538716 | g34014 | i0 | 65.2 | 0.784090909090909 | 46 | 16 | 78.4 | 0 | 8 | 145 | 53 | 98 | GMT14341.1 hypothetical protein PFISCL1PPCAC_5638, partial [Pristionchus fissidentatus] | diamond | 138 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 30223075 | 30223075 | PRJEB55122_P_NODE_41812_length_164_cov_0.904348_g41415_i0 | PRJEB55122 | 41812 | 164 | 0.904348 | 1.48313072 | Caenorhabditis angaria | 860376 | Nematoda | Nematoda | 70.1 | 6.02e-13 | NR | CAI5438963.1 | 860376 | g41415 | i0 | 69.8 | 1.9390243902439 | 53 | 16 | 97 | 0 | 6 | 164 | 154 | 206 | CAI5438963.1 unnamed protein product [Caenorhabditis angaria] | diamond | 318 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis angaria | |
| 31076348 | 31076348 | PRJEB55122_P_NODE_43435_length_162_cov_0.920354_g43038_i0 | PRJEB55122 | 43435 | 162 | 0.920354 | 1.49097348 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 89 | 1.38e-19 | NR | PAV58996.1 | 2018661 | g43038 | i0 | 100 | 1.51851851851852 | 41 | 0 | 75.9 | 0 | 161 | 39 | 60 | 100 | PAV58996.1 hypothetical protein WR25_12840 isoform B [Diploscapter pachys] | diamond | 246 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 31170761 | 31170761 | PRJEB55122_P_NODE_28575_length_197_cov_2.540541_g28178_i0 | PRJEB55122 | 28575 | 197 | 2.540541 | 5.00486577 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 44.3 | 0.00107 | NR | XP_024500773.1 | 34506 | g28178 | i0 | 64.3 | 2.74111675126904 | 28 | 10 | 42.6 | 0 | 98 | 181 | 42 | 69 | XP_024500773.1 Hypothetical protein SRAE_0000068266 [Strongyloides ratti] | diamond | 540 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 31582287 | 31582287 | PRJEB55122_P_NODE_24156_length_219_cov_2.205882_g23759_i0 | PRJEB55122 | 24156 | 219 | 2.205882 | 4.83088158 | Dracunculus medinensis | 318479 | Nematoda | Nematoda | 42.4 | 0.00573 | NR | VDN50396.1 | 318479 | g23759 | i0 | 35.7 | 0.958904109589041 | 70 | 45 | 95.9 | 0 | 3 | 212 | 2 | 71 | VDN50396.1 unnamed protein product [Dracunculus medinensis] | diamond | 210 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Dracunculidae | Dracunculus | Dracunculus medinensis | |
| 32278364 | 32278364 | PRJEB55122_P_NODE_41059_length_164_cov_1.460870_g40662_i0 | PRJEB55122 | 41059 | 164 | 1.46087 | 2.3958268 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 64.7 | 2.27e-10 | NR | PAV59389.1 | 2018661 | g40662 | i0 | 93.3 | 1.09756097560976 | 30 | 2 | 54.9 | 0 | 164 | 75 | 103 | 132 | PAV59389.1 hypothetical protein WR25_03514 [Diploscapter pachys] | diamond | 180 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 32657067 | 32657067 | PRJEB55122_P_NODE_21280_length_238_cov_2.407407_g20883_i0 | PRJEB55122 | 21280 | 238 | 2.407407 | 5.72962866 | Aphelenchoides avenae | 70226 | Nematoda | Nematoda | 43.5 | 0.0124 | NR | KAH7731325.1 | 70226 | g20883 | i0 | 33.3 | 0.831932773109244 | 66 | 39 | 76.9 | 1 | 36 | 218 | 16 | 81 | KAH7731325.1 CBN-GOS-28 protein [Aphelenchoides avenae] | diamond | 198 | 43.5 | 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);;