contig_metadata
18 rows where bioproject = "PRJNA674308", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1920881 | 1920881 | PRJNA674308_P_NODE_36122_length_169_cov_0.866667_g35887_i0 | PRJNA674308 | 36122 | 169 | 0.866667 | 1.46466723 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 54.7 | 0.004 | NTclustered | gi|687022642|emb|LM525556.1| | 174720 | g35887 | i0 | 100 | 0.171597633136095 | 29 | 0 | 17 | 0 | 2 | 30 | 256364 | 256336 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000002 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 14673677 | 14673677 | PRJNA674308_P_NODE_21072_length_215_cov_1.518072_g20837_i0 | PRJNA674308 | 21072 | 215 | 1.518072 | 3.2638548 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 102 | 1.86e-17 | NTclustered | gi|1376146209|ref|XM_024653666.1| | 34506 | g20837 | i0 | 84.466 | 0.92093023255814 | 103 | 16 | 48 | 0 | 1 | 103 | 1139 | 1241 | Strongyloides ratti AP-47 (SRAE_2000258100), partial mRNA | blastn | 198 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 15947288 | 15947288 | PRJNA674308_P_NODE_19073_length_224_cov_1.782857_g18838_i0 | PRJNA674308 | 19073 | 224 | 1.782857 | 3.99359968 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 220 | 5.16e-53 | NTclustered | gi|2158424922|ref|XM_045237347.1| | 6238 | g18838 | i0 | 84.444 | 4.12053571428571 | 225 | 33 | 100 | 2 | 1 | 224 | 1930 | 2153 | Caenorhabditis briggsae Protein CBR-EFT-2 (Cbr-eft-2), partial mRNA | blastn | 923 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 15947372 | 15947372 | PRJNA674308_P_NODE_28013_length_190_cov_1.475177_g27778_i0 | PRJNA674308 | 28013 | 190 | 1.475177 | 2.8028363 | Pristionchus sp. 15 RS5229 | 452809 | Nematoda | Nematoda | 100 | 5.75e-17 | NTclustered | gi|150982147|gb|EF634662.1| | 452809 | g27778 | i0 | 85 | 30.7947368421053 | 100 | 13 | 52 | 2 | 55 | 153 | 300 | 398 | Pristionchus sp. 15 RS5229 large subunit ribosomal protein 27a (rpl-27a) mRNA, partial cds | blastn | 5851 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 15 RS5229 | |
| 18497022 | 18497022 | PRJNA674308_P_NODE_21235_length_214_cov_1.890909_g21000_i0 | PRJNA674308 | 21235 | 214 | 1.890909 | 4.04654526 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.019 | NTclustered | gi|687865626|emb|LK927781.1| | 6239 | g21000 | i0 | 100 | 0.261682242990654 | 28 | 0 | 13 | 0 | 49 | 76 | 107754 | 107781 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000221 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 26638544 | 26638544 | PRJNA674308_P_NODE_27961_length_190_cov_1.475177_g27726_i0 | PRJNA674308 | 27961 | 190 | 1.475177 | 2.8028363 | Bursaphelenchus okinawaensis | 465554 | Nematoda | Nematoda | 67.4 | 3.71e-11 | NR | CAD5207711.1 | 465554 | g27726 | i0 | 54.5 | 8.49473684210526 | 66 | 21 | 96.3 | 2 | 1 | 183 | 364 | 425 | CAD5207711.1 unnamed protein product [Bursaphelenchus okinawaensis] | diamond | 1614 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus okinawaensis | |
| 26701757 | 26701757 | PRJNA674308_P_NODE_28941_length_187_cov_2.137681_g28706_i0 | PRJNA674308 | 28941 | 187 | 2.137681 | 3.99746347 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 43.5 | 0.00907 | NR | CAD5212124.1 | 6326 | g28706 | i0 | 51.3 | 2.06951871657754 | 39 | 19 | 62.6 | 0 | 146 | 30 | 37 | 75 | CAD5212124.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 387 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 27745426 | 27745426 | PRJNA674308_P_NODE_33484_length_175_cov_1.579365_g33249_i0 | PRJNA674308 | 33484 | 175 | 1.579365 | 2.76388875 | Enterobius vermicularis | 51028 | Nematoda | Nematoda | 42.7 | 0.0153 | NR | VDD88118.1 | 51028 | g33249 | i0 | 48.7 | 0.668571428571429 | 39 | 19 | 65.1 | 1 | 135 | 22 | 487 | 525 | VDD88118.1 unnamed protein product [Enterobius vermicularis] | diamond | 117 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Oxyuridae | Enterobius | Enterobius vermicularis | |
| 27902854 | 27902854 | PRJNA674308_P_NODE_33745_length_174_cov_1.664000_g33510_i0 | PRJNA674308 | 33745 | 174 | 1.664 | 2.89536 | Caenorhabditis auriculariae | 2777116 | Nematoda | Nematoda | 55.1 | 6.03e-7 | NR | CAD6186662.1 | 2777116 | g33510 | i0 | 69.4 | 0.620689655172414 | 36 | 11 | 62.1 | 0 | 37 | 144 | 114 | 149 | CAD6186662.1 unnamed protein product [Caenorhabditis auriculariae] | diamond | 108 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis auriculariae | |
| 29702372 | 29702372 | PRJNA674308_P_NODE_17350_length_234_cov_0.935135_g17115_i0 | PRJNA674308 | 17350 | 234 | 0.935135 | 2.1882159 | Heterodera trifolii | 157864 | Nematoda | Nematoda | 42.7 | 0.0318 | NR | KAL3105606.1 | 157864 | g17115 | i0 | 40.4 | 0.730769230769231 | 57 | 29 | 73.1 | 2 | 193 | 23 | 21 | 72 | KAL3105606.1 hypothetical protein niasHT_021709 [Heterodera trifolii] | diamond | 171 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera trifolii | |
| 29987037 | 29987037 | PRJNA674308_P_NODE_54091_length_162_cov_0.911504_g53856_i0 | PRJNA674308 | 54091 | 162 | 0.911504 | 1.47663648 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 46.6 | 5.36e-4 | NR | CAD2176895.1 | 390850 | g53856 | i0 | 63.9 | 1.96296296296296 | 36 | 12 | 66.7 | 1 | 109 | 2 | 152 | 186 | CAD2176895.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 318 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 30050037 | 30050037 | PRJNA674308_P_NODE_45491_length_165_cov_0.896552_g45256_i0 | PRJNA674308 | 45491 | 165 | 0.896552 | 1.4793108 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 64.3 | 3.05e-10 | NR | KAE9554736.1 | 2598192 | g45256 | i0 | 51.9 | 1.96363636363636 | 54 | 26 | 98.2 | 0 | 164 | 3 | 48 | 101 | KAE9554736.1 hypothetical protein FO519_002064 [Halicephalobus sp. NKZ332] | diamond | 324 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 | |
| 30176487 | 30176487 | PRJNA674308_P_NODE_34132_length_173_cov_1.677419_g33897_i0 | PRJNA674308 | 34132 | 173 | 1.677419 | 2.90193487 | Dracunculus medinensis | 318479 | Nematoda | Nematoda | 42 | 0.0268 | NR | VDN60194.1 | 318479 | g33897 | i0 | 34 | 0.919075144508671 | 53 | 35 | 91.9 | 0 | 172 | 14 | 146 | 198 | VDN60194.1 unnamed protein product [Dracunculus medinensis] | diamond | 159 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Dracunculidae | Dracunculus | Dracunculus medinensis | |
| 30239809 | 30239809 | PRJNA674308_P_NODE_7692_length_343_cov_1.557823_g7457_i0 | PRJNA674308 | 7692 | 343 | 1.557823 | 5.34333289 | Caenorhabditis brenneri | 135651 | Nematoda | Nematoda | 110 | 2.82e-25 | NR | EGT51377.1 | 135651 | g7457 | i0 | 48.2 | 4.89795918367347 | 112 | 50 | 98 | 3 | 3 | 338 | 967 | 1070 | EGT51377.1 hypothetical protein CAEBREN_01368 [Caenorhabditis brenneri] | diamond | 1680 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis brenneri | |
| 30410000 | 30410000 | PRJNA674308_P_NODE_32253_length_178_cov_1.612403_g32018_i0 | PRJNA674308 | 32253 | 178 | 1.612403 | 2.87007734 | Metazoa | 33208 | Nematoda | Nematoda | 45.4 | 0.00167 | NR | PIC39561.1 | 1611254 | g32018 | i0 | 36.1 | 7.23033707865169 | 61 | 33 | 94.4 | 2 | 170 | 3 | 53 | 112 | PIC39561.1 hypothetical protein B9Z55_011211 [Caenorhabditis nigoni] | diamond | 1287 | 45.8 | 0.991266375545852 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis nigoni | |
| 31294337 | 31294337 | PRJNA674308_P_NODE_21255_length_214_cov_1.842424_g21020_i0 | PRJNA674308 | 21255 | 214 | 1.842424 | 3.94278736 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.2 | 1.41e-9 | NR | EPB80284.1 | 53326 | g21020 | i0 | 46.4 | 5.81775700934579 | 69 | 35 | 96.7 | 1 | 2 | 208 | 157 | 223 | EPB80284.1 hypothetical protein ANCCEY_00686 [Ancylostoma ceylanicum] | diamond | 1245 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma ceylanicum | |
| 31895359 | 31895359 | PRJNA674308_P_NODE_41357_length_167_cov_0.881356_g41122_i0 | PRJNA674308 | 41357 | 167 | 0.881356 | 1.47186452 | Metazoa | 33208 | Nematoda | Nematoda | 80.5 | 6.55e-16 | NR | EFO82428.1 | 31234 | g41122 | i0 | 79.6 | 20.3712574850299 | 54 | 11 | 97 | 0 | 2 | 163 | 410 | 463 | EFO82428.1 CRE-HSP-3 protein [Caenorhabditis remanei] | diamond | 3402 | 80.9 | 0.995055624227441 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 32874707 | 32874707 | PRJNA674308_P_NODE_22120_length_211_cov_1.277778_g21885_i0 | PRJNA674308 | 22120 | 211 | 1.277778 | 2.69611158 | Metazoa | 33208 | Nematoda | Nematoda | 43.1 | 0.018 | NR | KAK0396201.1 | 289476 | g21885 | i0 | 81.8 | 0.938388625592417 | 22 | 4 | 31.3 | 0 | 1 | 66 | 422 | 443 | KAK0396201.1 hypothetical protein QR680_001619 [Steinernema hermaphroditum] | diamond | 198 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema hermaphroditum |
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);;