contig_metadata
19 rows where bioproject = "PRJNA849172", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3385510 | 3385510 | PRJNA849172_P_NODE_125483_length_227_cov_5.623377_g125123_i0 | PRJNA849172 | 125483 | 227 | 5.623377 | 12.76506579 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 62.1 | 3.36e-5 | NTclustered | gi|687865708|emb|LK927636.1| | 6239 | g125123 | i0 | 89.583 | 1.60352422907489 | 48 | 5 | 21 | 0 | 79 | 126 | 146701 | 146748 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000096 | blastn | 364 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 14865009 | 14865009 | PRJNA849172_P_NODE_67172_length_272_cov_20.417085_g66812_i0 | PRJNA849172 | 67172 | 272 | 20.417085 | 55.5344712 | Necator americanus | 51031 | Nematoda | Nematoda | 80.5 | 1.14e-10 | NTclustered | gi|2707542684|ref|XM_013436844.2| | 51031 | g66812 | i0 | 84.337 | 0.580882352941177 | 83 | 12 | 30 | 1 | 57 | 138 | 439 | 521 | Necator americanus uncharacterized protein (RB195_005447), partial mRNA | blastn | 158 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 18687067 | 18687067 | PRJNA849172_P_NODE_26435_length_399_cov_16.092025_g26076_i0 | PRJNA849172 | 26435 | 399 | 16.092025 | 64.20717975 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 137 | 2e-34 | NR | CAD5216646.1 | 6326 | g26076 | i0 | 57.3 | 13.2556390977444 | 131 | 40 | 88.7 | 3 | 397 | 44 | 686 | 813 | CAD5216646.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 5289 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 19083465 | 19083465 | PRJNA849172_P_NODE_117895_length_233_cov_9.512500_g117535_i0 | PRJNA849172 | 117895 | 233 | 9.5125 | 22.164125 | Oscheius | 42476 | Nematoda | Nematoda | 429 | 8.239999999999998e-116 | NTclustered | gi|158827543|gb|EU196009.1| | 141969 | g117535 | i0 | 100 | 98.3261802575107 | 232 | 0 | 99 | 0 | 1 | 232 | 501 | 732 | Oscheius tipulae strain CEW1 18S ribosomal RNA gene, partial sequence | blastn | 22910 | 429 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Oscheius | Oscheius tipulae | |
| 26810071 | 26810071 | PRJNA849172_P_NODE_18861_length_476_cov_26.657568_g18502_i0 | PRJNA849172 | 18861 | 476 | 26.657568 | 126.89002368 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 45.4 | 0.00574 | NR | CDW51882.1 | 36087 | g18502 | i0 | 32.9 | 1.89075630252101 | 76 | 40 | 41 | 3 | 75 | 269 | 10 | 85 | CDW51882.1 hypothetical protein TTRE_0000014101 [Trichuris trichiura] | diamond | 900 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 26991336 | 26991336 | PRJNA849172_P_NODE_6002_length_897_cov_32.117718_g5705_i0 | PRJNA849172 | 6002 | 897 | 32.117718000000004 | 288.09593046 | Auanema sp. JU1783 | 2878363 | Nematoda | Nematoda | 191 | 1.9e-55 | NR | CAI4232085.1 | 2878363 | g5705 | i0 | 70.7 | 0.468227424749164 | 140 | 40 | 46.5 | 1 | 469 | 53 | 138 | 277 | CAI4232085.1 unnamed protein product [Auanema sp. JU1783] | diamond | 420 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Auanema | Auanema sp. JU1783 | |
| 27244512 | 27244512 | PRJNA849172_P_NODE_96763_length_248_cov_0.891429_g96403_i0 | PRJNA849172 | 96763 | 248 | 0.891429 | 2.21074392 | Wuchereria bancrofti | 6293 | Nematoda | Nematoda | 134 | 3.39e-34 | NR | VDM09255.1 | 6293 | g96403 | i0 | 97.1 | 0.846774193548387 | 70 | 2 | 84.7 | 0 | 211 | 2 | 772 | 841 | VDM09255.1 unnamed protein product [Wuchereria bancrofti] | diamond | 210 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 27655334 | 27655334 | PRJNA849172_P_NODE_72964_length_266_cov_4.787565_g72604_i0 | PRJNA849172 | 72964 | 266 | 4.787565 | 12.7349229 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 72.4 | 1.75e-12 | NR | PAV77616.1 | 2018661 | g72604 | i0 | 79.1 | 0.484962406015038 | 43 | 9 | 48.5 | 0 | 264 | 136 | 345 | 387 | PAV77616.1 hypothetical protein WR25_25479 [Diploscapter pachys] | diamond | 129 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 28570667 | 28570667 | PRJNA849172_P_NODE_5807_length_913_cov_27.445238_g5512_i0 | PRJNA849172 | 5807 | 913 | 27.445238 | 250.57502294 | Brugia timori | 42155 | Nematoda | Nematoda | 233 | 5.15e-69 | NR | VDO07297.1 | 42155 | g5512 | i0 | 51.7 | 0.762322015334064 | 232 | 111 | 76.2 | 1 | 216 | 911 | 29 | 259 | VDO07297.1 unnamed protein product [Brugia timori] | diamond | 696 | 233 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia timori | |
| 28863134 | 28863134 | PRJNA849172_P_NODE_85668_length_254_cov_17.016575_g85308_i0 | PRJNA849172 | 85668 | 254 | 17.016575 | 43.2221005 | Rhabditida | 6236 | Nematoda | Nematoda | 100 | 1.5100000000000001e-22 | NR | XP_045094528.1 | 6238 | g85308 | i0 | 74.2 | 6.59055118110236 | 62 | 16 | 73.2 | 0 | 30 | 215 | 807 | 868 | XP_045094528.1 Protein CBG11440 [Caenorhabditis briggsae] | diamond | 1674 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 29021471 | 29021471 | PRJNA849172_P_NODE_68068_length_271_cov_16.505051_g67708_i0 | PRJNA849172 | 68068 | 271 | 16.505051 | 44.72868821 | root | 1 | Root_unresolved | Root_unresolved | 84.3 | 9.73e-17 | NR | VDO07293.1 | 42155 | g67708 | i0 | 59.7 | 1.38376383763838 | 62 | 25 | 68.6 | 0 | 191 | 6 | 2 | 63 | VDO07293.1 unnamed protein product [Brugia timori] | diamond | 375 | 84.7 | 0.995277449822904 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia timori | |
| 29265167 | 29265167 | PRJNA849172_P_NODE_26969_length_395_cov_8.757764_g26610_i0 | PRJNA849172 | 26969 | 395 | 8.757764 | 34.5931678 | Steinernema hermaphroditum | 289476 | Nematoda | Nematoda | 120 | 1.8399999999999998e-31 | NR | KAK0400363.1 | 289476 | g26610 | i0 | 58.6 | 1.70126582278481 | 116 | 45 | 86.6 | 2 | 380 | 39 | 72 | 186 | KAK0400363.1 hypothetical protein QR680_003462 [Steinernema hermaphroditum] | diamond | 672 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema hermaphroditum | |
| 30939725 | 30939725 | PRJNA849172_P_NODE_89934_length_251_cov_13.292135_g89574_i0 | PRJNA849172 | 89934 | 251 | 13.292135 | 33.36325885 | Toxocara canis | 6265 | Nematoda | Nematoda | 95.5 | 1.91e-22 | NR | KHN80588.1 | 6265 | g89574 | i0 | 52.1 | 4.31474103585657 | 73 | 35 | 87.3 | 0 | 228 | 10 | 115 | 187 | KHN80588.1 Lipopolysaccharide-induced tumor necrosis factor-alpha factor -like protein [Toxocara canis] | diamond | 1083 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 31034667 | 31034667 | PRJNA849172_P_NODE_98095_length_247_cov_2.143678_g97735_i0 | PRJNA849172 | 98095 | 247 | 2.143678 | 5.29488466 | Brugia timori | 42155 | Nematoda | Nematoda | 78.6 | 8.25e-15 | NR | VDO07293.1 | 42155 | g97735 | i0 | 50 | 0.97165991902834 | 80 | 39 | 97.2 | 1 | 3 | 242 | 53 | 131 | VDO07293.1 unnamed protein product [Brugia timori] | diamond | 240 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia timori | |
| 31382180 | 31382180 | PRJNA849172_P_NODE_6116_length_889_cov_30.985294_g5815_i0 | PRJNA849172 | 6116 | 889 | 30.985294 | 275.45926366 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 243 | 6.300000000000002e-78 | NR | PAV75779.1 | 2018661 | g5815 | i0 | 89.6 | 0.455568053993251 | 135 | 14 | 45.6 | 0 | 782 | 378 | 1 | 135 | PAV75779.1 hypothetical protein WR25_11724 [Diploscapter pachys] | diamond | 405 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 31833040 | 31833040 | PRJNA849172_P_NODE_50977_length_293_cov_10.563636_g50617_i0 | PRJNA849172 | 50977 | 293 | 10.563636 | 30.95145348 | Metazoa | 33208 | Nematoda | Nematoda | 73.2 | 9.66e-13 | NR | CDW51849.1 | 36087 | g50617 | i0 | 58.2 | 8.43686006825939 | 55 | 23 | 56.3 | 0 | 204 | 40 | 159 | 213 | CDW51849.1 gephyrin [Trichuris trichiura] | diamond | 2472 | 73.9 | 0.990527740189445 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 31888061 | 31888061 | PRJNA849172_P_NODE_87277_length_253_cov_3.216667_g86917_i0 | PRJNA849172 | 87277 | 253 | 3.216667 | 8.13816751 | Auanema sp. JU1783 | 2878363 | Nematoda | Nematoda | 65.1 | 5.26e-10 | NR | CAI4229567.1 | 2878363 | g86917 | i0 | 34.4 | 1.13833992094862 | 96 | 49 | 97.2 | 2 | 4 | 249 | 81 | 176 | CAI4229567.1 unnamed protein product [Auanema sp. JU1783] | diamond | 288 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Auanema | Auanema sp. JU1783 | |
| 32552892 | 32552892 | PRJNA849172_P_NODE_5799_length_914_cov_16.525565_g5504_i0 | PRJNA849172 | 5799 | 914 | 16.525565 | 151.0436641 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 322 | 4.03e-108 | NR | PAV74583.1 | 2018661 | g5504 | i0 | 96.3 | 0.62691466083151 | 191 | 7 | 62.7 | 0 | 680 | 108 | 1 | 191 | PAV74583.1 hypothetical protein WR25_26826 [Diploscapter pachys] | diamond | 573 | 322 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 32592549 | 32592549 | PRJNA849172_P_NODE_82519_length_257_cov_3.945652_g82159_i0 | PRJNA849172 | 82519 | 257 | 3.945652 | 10.14032564 | Rhabditida | 6236 | Nematoda | Nematoda | 78.2 | 1.5e-14 | NR | VDM24620.1 | 6265 | g82159 | i0 | 71.2 | 3.2568093385214 | 52 | 15 | 60.7 | 0 | 158 | 3 | 323 | 374 | VDM24620.1 unnamed protein product [Toxocara canis] | diamond | 837 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis |
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);;