contig_metadata
11 rows where bioproject = "PRJNA454503", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 442031 | 442031 | PRJNA454503_P_NODE_14201_length_305_cov_1.065574_g13872_i0 | PRJNA454503 | 14201 | 305 | 1.065574 | 3.2500007 | Rhabditida | 6236 | Nematoda | Nematoda | 71.2 | 2.39e-12 | NR | KHN75984.1 | 6265 | g13872 | i0 | 68.5 | 5.81311475409836 | 54 | 17 | 53.1 | 0 | 1 | 162 | 143 | 196 | KHN75984.1 60S ribosomal protein L19 [Toxocara canis] | diamond | 1773 | 71.6 | 0.994413407821229 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 2993209 | 2993209 | PRJNA454503_P_NODE_50723_length_215_cov_1.266234_g50394_i0 | PRJNA454503 | 50723 | 215 | 1.266234 | 2.7224031 | Micoletzkya masseyi | 1250333 | Nematoda | Nematoda | 148 | 2.35e-31 | NTclustered | gi|410992313|gb|JX163985.1| | 1250333 | g50394 | i0 | 81.667 | 2.49302325581395 | 180 | 31 | 83 | 2 | 4 | 182 | 188 | 10 | Micoletzkya masseyi large subunit ribosomal protein 9 (rpl-9) mRNA, partial cds | blastn | 536 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Micoletzkya | Micoletzkya masseyi | |
| 10646704 | 10646704 | PRJNA454503_P_NODE_75069_length_205_cov_0.902778_g74740_i0 | PRJNA454503 | 75069 | 205 | 0.902778 | 1.8506949 | Plectus | 49353 | Nematoda | Nematoda | 106 | 5.16e-25 | NR | AOW68740.1 | 70689 | g74740 | i0 | 91.2 | 2.98536585365854 | 68 | 6 | 99.5 | 0 | 2 | 205 | 147 | 214 | AOW68740.1 cytochrome c oxidase subunit I [Plectus acuminatus] | diamond | 612 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Plectida | Plectidae | Plectus | Plectus acuminatus | |
| 11921673 | 11921673 | PRJNA454503_P_NODE_82950_length_203_cov_0.915493_g82621_i0 | PRJNA454503 | 82950 | 203 | 0.915493 | 1.85845079 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 99 | 1.53e-22 | NR | NP_001021254.1 | 6239 | g82621 | i0 | 72.3 | 58.6256157635468 | 65 | 16 | 96.1 | 1 | 5 | 199 | 1 | 63 | NP_001021254.1 Large ribosomal subunit protein uL3 [Caenorhabditis elegans] | diamond | 11901 | 100 | 0.99 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 15744726 | 15744726 | PRJNA454503_P_NODE_17873_length_279_cov_1.706422_g17544_i0 | PRJNA454503 | 17873 | 279 | 1.706422 | 4.76091738 | Nematoda | 6231 | Nematoda | Nematoda | 82.4 | 3.99e-17 | NR | TKR94882.1 | 34508 | g17544 | i0 | 64.4 | 6.38709677419355 | 59 | 21 | 63.4 | 0 | 279 | 103 | 125 | 183 | TKR94882.1 hypothetical protein L596_009114 [Steinernema carpocapsae] | diamond | 1782 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 18293692 | 18293692 | PRJNA454503_P_NODE_14075_length_306_cov_1.379592_g13746_i0 | PRJNA454503 | 14075 | 306 | 1.379592 | 4.22155152 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 220 | 7.39e-53 | NTclustered | gi|1376152387|ref|XM_024644732.1| | 34506 | g13746 | i0 | 79.933 | 7.61437908496732 | 299 | 60 | 98 | 0 | 8 | 306 | 428 | 130 | Strongyloides ratti Peptidyl-prolyl cis-trans isomerase B (SRAE_X000039200), partial mRNA | blastn | 2330 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 24669013 | 24669013 | PRJNA454503_P_NODE_77660_length_204_cov_0.909091_g77331_i0 | PRJNA454503 | 77660 | 204 | 0.909091 | 1.85454564 | Toxocara canis | 6265 | Nematoda | Nematoda | 120 | 4.87e-33 | NR | KHN88886.1 | 6265 | g77331 | i0 | 92.5 | 0.985294117647059 | 67 | 5 | 98.5 | 0 | 202 | 2 | 42 | 108 | KHN88886.1 40S ribosomal protein S17 [Toxocara canis] | diamond | 201 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 28766004 | 28766004 | PRJNA454503_P_NODE_55907_length_211_cov_0.866667_g55578_i0 | PRJNA454503 | 55907 | 211 | 0.866667 | 1.82866737 | Rhabditida | 6236 | Nematoda | Nematoda | 71.6 | 3.53e-14 | NR | VDD96816.1 | 51028 | g55578 | i0 | 84.6 | 2.72985781990521 | 39 | 6 | 55.5 | 0 | 210 | 94 | 67 | 105 | VDD96816.1 unnamed protein product [Enterobius vermicularis] | diamond | 576 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Oxyuridae | Enterobius | Enterobius vermicularis | |
| 28955779 | 28955779 | PRJNA454503_P_NODE_44288_length_222_cov_1.211180_g43959_i0 | PRJNA454503 | 44288 | 222 | 1.21118 | 2.6888196 | Opisthokonta | 33154 | Nematoda | Nematoda | 55.5 | 1.38e-7 | NR | VDM96114.1 | 103827 | g43959 | i0 | 66 | 4.10810810810811 | 47 | 16 | 63.5 | 0 | 158 | 18 | 37 | 83 | VDM96114.1 unnamed protein product [Thelazia callipaeda] | diamond | 912 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Thelaziidae | Thelazia | Thelazia callipaeda | |
| 29823194 | 29823194 | PRJNA454503_P_NODE_55751_length_211_cov_0.866667_g55422_i0 | PRJNA454503 | 55751 | 211 | 0.866667 | 1.82866737 | Toxocara canis | 6265 | Nematoda | Nematoda | 59.7 | 2.59e-8 | NR | KHN84466.1 | 6265 | g55422 | i0 | 50.7 | 2.01895734597156 | 71 | 32 | 99.5 | 2 | 2 | 211 | 72 | 140 | KHN84466.1 DnaJ -like protein subfamily A member 2 [Toxocara canis] | diamond | 426 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 31530050 | 31530050 | PRJNA454503_P_NODE_64236_length_208_cov_0.884354_g63907_i0 | PRJNA454503 | 64236 | 208 | 0.884354 | 1.83945632 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 78.2 | 8.7e-16 | NR | PAV60058.1 | 2018661 | g63907 | i0 | 59.6 | 0.822115384615385 | 57 | 23 | 82.2 | 0 | 36 | 206 | 31 | 87 | PAV60058.1 hypothetical protein WR25_19544 [Diploscapter pachys] | diamond | 171 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys |
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);;