contig_metadata
18 rows where bioproject = "PRJNA340009", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 392083 | 392083 | PRJNA340009_P_NODE_28401_length_232_cov_3.655738_g28094_i0 | PRJNA340009 | 28401 | 232 | 3.655738 | 8.48131216 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.021 | NTclustered | gi|690018453|emb|LM525691.1| | 174720 | g28094 | i0 | 100 | 0.120689655172414 | 28 | 0 | 12 | 0 | 7 | 34 | 71051 | 71078 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000088 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 392595 | 392595 | PRJNA340009_P_NODE_74961_length_162_cov_0.902655_g74654_i0 | PRJNA340009 | 74961 | 162 | 0.902655 | 1.4623011 | Ficotylus congestae | 458166 | Nematoda | Nematoda | 65.8 | 1.73e-6 | NTclustered | gi|154819873|gb|EU018047.1| | 458166 | g74654 | i0 | 97.368 | 19.1604938271605 | 38 | 1 | 23 | 0 | 120 | 157 | 586 | 623 | Ficotylus congestae isolate 460 28S ribosomal RNA gene, partial sequence | blastn | 3104 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neotylenchidae | Ficotylus | Ficotylus congestae | |
| 5495940 | 5495940 | PRJNA340009_P_NODE_51425_length_181_cov_2.303030_g51118_i0 | PRJNA340009 | 51425 | 181 | 2.30303 | 4.1684843 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 52.8 | 0.015 | NTclustered | gi|1376157323|ref|XM_024646105.1| | 34506 | g51118 | i0 | 100 | 0.154696132596685 | 28 | 0 | 15 | 0 | 21 | 48 | 285 | 312 | Strongyloides ratti 7TM GPCR, serpentine receptor class v (Srv) family-containing protein (SRAE_0000024200), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 11273333 | 11273333 | PRJNA340009_P_NODE_66149_length_165_cov_1.672414_g65842_i0 | PRJNA340009 | 66149 | 165 | 1.672414 | 2.7594831 | Metazoa | 33208 | Nematoda | Nematoda | 58.4 | 2.97e-4 | NTclustered | gi|2082287883|ref|XM_043081596.1| | 6279 | g65842 | i0 | 92.683 | 2.65454545454545 | 41 | 2 | 24 | 1 | 24 | 63 | 281 | 321 | Brugia malayi Uncharacterized protein (Bm10604), partial mRNA | blastn | 438 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 18243939 | 18243939 | PRJNA340009_P_NODE_55275_length_175_cov_4.047619_g54968_i0 | PRJNA340009 | 55275 | 175 | 4.047619 | 7.08333325 | Trichinella spiralis | 6334 | Nematoda | Nematoda | 52.8 | 0.015 | NTclustered | gi|120407193|gb|AC196187.1| | 6334 | g54968 | i0 | 100 | 0.16 | 28 | 0 | 16 | 0 | 87 | 114 | 117734 | 117761 | Trichinella spiralis BAC clone TS195-17H12 from chromosome unknown, complete sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 26648568 | 26648568 | PRJNA340009_P_NODE_28821_length_231_cov_1.587912_g28514_i0 | PRJNA340009 | 28821 | 231 | 1.587912 | 3.66807672 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 82 | 3.99e-16 | NR | KJH52848.1 | 29172 | g28514 | i0 | 50.7 | 8.28571428571429 | 71 | 33 | 89.6 | 1 | 223 | 17 | 338 | 408 | KJH52848.1 u-box domain protein [Dictyocaulus viviparus] | diamond | 1914 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Dictyocaulus | Dictyocaulus viviparus | |
| 27106141 | 27106141 | PRJNA340009_P_NODE_22082_length_258_cov_56.033493_g21775_i0 | PRJNA340009 | 22082 | 258 | 56.033493 | 144.56641194 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 48.5 | 3.23e-4 | NR | CAJ0579586.1 | 96644 | g21775 | i0 | 79.3 | 0.662790697674419 | 29 | 6 | 33.7 | 0 | 181 | 95 | 214 | 242 | CAJ0579586.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 171 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 27629217 | 27629217 | PRJNA340009_P_NODE_41664_length_198_cov_1.302013_g41357_i0 | PRJNA340009 | 41664 | 198 | 1.302013 | 2.57798574 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 66.6 | 5.99e-11 | NR | VDP03494.1 | 241478 | g41357 | i0 | 71.1 | 6.74242424242424 | 45 | 12 | 68.2 | 1 | 22 | 156 | 114 | 157 | VDP03494.1 unnamed protein product [Soboliphyme baturini] | diamond | 1335 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 28653784 | 28653784 | PRJNA340009_P_NODE_53047_length_179_cov_1.176923_g52740_i0 | PRJNA340009 | 53047 | 179 | 1.176923 | 2.10669217 | Aphelenchoides avenae | 70226 | Nematoda | Nematoda | 73.9 | 1.5700000000000001e-13 | NR | KAH7729468.1 | 70226 | g52740 | i0 | 63.8 | 0.972067039106145 | 58 | 18 | 97.2 | 1 | 3 | 176 | 658 | 712 | KAH7729468.1 isoleucyl-tRNA synthetase [Aphelenchoides avenae] | diamond | 174 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 28685489 | 28685489 | PRJNA340009_P_NODE_17947_length_283_cov_1.547009_g17640_i0 | PRJNA340009 | 17947 | 283 | 1.547009 | 4.37803547 | Wuchereria bancrofti | 6293 | Nematoda | Nematoda | 48.5 | 9.27e-5 | NR | VDM17700.1 | 6293 | g17640 | i0 | 32.8 | 0.614840989399293 | 58 | 35 | 57.2 | 1 | 268 | 107 | 36 | 93 | VDM17700.1 unnamed protein product [Wuchereria bancrofti] | diamond | 174 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 30296305 | 30296305 | PRJNA340009_P_NODE_29572_length_228_cov_4.586592_g29265_i0 | PRJNA340009 | 29572 | 228 | 4.586592 | 10.45742976 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 67.4 | 5.89e-11 | NR | GMT24589.1 | 1538716 | g29265 | i0 | 50.9 | 2.71052631578947 | 57 | 28 | 75 | 0 | 226 | 56 | 306 | 362 | GMT24589.1 hypothetical protein PFISCL1PPCAC_15886, partial [Pristionchus fissidentatus] | diamond | 618 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 30674937 | 30674937 | PRJNA340009_P_NODE_71073_length_163_cov_0.894737_g70766_i0 | PRJNA340009 | 71073 | 163 | 0.894737 | 1.45842131 | Soboliphyme baturini | 241478 | Nematoda | Nematoda | 42 | 0.0231 | NR | VDP31214.1 | 241478 | g70766 | i0 | 51.4 | 0.644171779141104 | 35 | 17 | 64.4 | 0 | 34 | 138 | 186 | 220 | VDP31214.1 unnamed protein product [Soboliphyme baturini] | diamond | 105 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 31275372 | 31275372 | PRJNA340009_P_NODE_69095_length_164_cov_0.886957_g68788_i0 | PRJNA340009 | 69095 | 164 | 0.886957 | 1.45460948 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 41.2 | 0.0459 | NR | NP_509658.1 | 6239 | g68788 | i0 | 46.7 | 0.823170731707317 | 45 | 24 | 82.3 | 0 | 135 | 1 | 1049 | 1093 | NP_509658.1 Multidrug resistance-associated protein 1 [Caenorhabditis elegans] | diamond | 135 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 31402119 | 31402119 | PRJNA340009_P_NODE_5336_length_466_cov_2.110312_g5029_i0 | PRJNA340009 | 5336 | 466 | 2.110312 | 9.83405392 | Steinernema carpocapsae | 34508 | Nematoda | Nematoda | 71.6 | 6.36e-12 | NR | TKR89800.1 | 34508 | g5029 | i0 | 35.4 | 1.23605150214592 | 96 | 61 | 61.8 | 1 | 38 | 325 | 123 | 217 | TKR89800.1 hypothetical protein L596_013847 [Steinernema carpocapsae] | diamond | 576 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 32382637 | 32382637 | PRJNA340009_P_NODE_56159_length_174_cov_2.448000_g55852_i0 | PRJNA340009 | 56159 | 174 | 2.448 | 4.25952 | Wuchereria bancrofti | 6293 | Nematoda | Nematoda | 97.8 | 3.2799999999999995e-23 | NR | VDM09058.1 | 6293 | g55852 | i0 | 80.7 | 0.982758620689655 | 57 | 11 | 98.3 | 0 | 3 | 173 | 147 | 203 | VDM09058.1 unnamed protein product [Wuchereria bancrofti] | diamond | 171 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 32509485 | 32509485 | PRJNA340009_P_NODE_59199_length_170_cov_2.190083_g58892_i0 | PRJNA340009 | 59199 | 170 | 2.190083 | 3.7231411 | Gnathostoma spinigerum | 75299 | Nematoda | Nematoda | 96.7 | 8.65e-25 | NR | MFH4985130.1 | 75299 | g58892 | i0 | 89.1 | 0.811764705882353 | 46 | 5 | 81.2 | 0 | 32 | 169 | 1 | 46 | MFH4985130.1 hypothetical protein [Gnathostoma spinigerum] | diamond | 138 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gnathostomatidae | Gnathostoma | Gnathostoma spinigerum | |
| 32603955 | 32603955 | PRJNA340009_P_NODE_56520_length_174_cov_1.392000_g56213_i0 | PRJNA340009 | 56520 | 174 | 1.392 | 2.42208 | Gnathostoma spinigerum | 75299 | Nematoda | Nematoda | 71.6 | 7.44e-15 | NR | MFH4985130.1 | 75299 | g56213 | i0 | 100 | 0.517241379310345 | 30 | 0 | 51.7 | 0 | 173 | 84 | 38 | 67 | MFH4985130.1 hypothetical protein [Gnathostoma spinigerum] | diamond | 90 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gnathostomatidae | Gnathostoma | Gnathostoma spinigerum | |
| 32872902 | 32872902 | PRJNA340009_P_NODE_26380_length_240_cov_1.848168_g26073_i0 | PRJNA340009 | 26380 | 240 | 1.848168 | 4.4356032 | root | 1 | Root_unresolved | Root_unresolved | 40.8 | 0.0364 | NR | KAK6054055.1 | 27828 | g26073 | i0 | 48.6 | 0.875 | 35 | 18 | 43.8 | 0 | 211 | 107 | 35 | 69 | KAK6054055.1 hypothetical protein COOONC_08439 [Cooperia oncophora] | diamond | 210 | 41.2 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Cooperia | Cooperia oncophora |
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);;