contig_metadata
15 rows where bioproject = "PRJNA643700", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1894303 | 1894303 | PRJNA643700_P_NODE_227442_length_255_cov_4.199029_g225886_i0 | PRJNA643700 | 227442 | 255 | 4.199029 | 10.70752395 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 52.8 | 0.023 | NTclustered | gi|1376134401|ref|XM_024647160.1| | 34506 | g225886 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 221 | 248 | 141 | 168 | Strongyloides ratti N-alpha-acetyltransferase 35, NatC auxiliary subunit (SRAE_1000033900), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 4445766 | 4445766 | PRJNA643700_P_NODE_205224_length_274_cov_1.155556_g203668_i0 | PRJNA643700 | 205224 | 274 | 1.155556 | 3.16622344 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.025 | NTclustered | gi|687865582|emb|LK927621.1| | 6239 | g203668 | i0 | 100 | 0.204379562043796 | 28 | 0 | 10 | 0 | 15 | 42 | 136086 | 136059 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000084 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 15920883 | 15920883 | PRJNA643700_P_NODE_111733_length_393_cov_2.485465_g110179_i0 | PRJNA643700 | 111733 | 393 | 2.485465 | 9.76787745 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.038 | NTclustered | gi|690020008|emb|LM527523.1| | 174720 | g110179 | i0 | 100 | 0.0712468193384224 | 28 | 0 | 7 | 0 | 121 | 148 | 328 | 301 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000112 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 15920966 | 15920966 | PRJNA643700_P_NODE_234053_length_251_cov_1.029703_g232497_i0 | PRJNA643700 | 234053 | 251 | 1.029703 | 2.58455453 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.023 | NTclustered | gi|687022698|emb|LM525612.1| | 174720 | g232497 | i0 | 92.105 | 0.151394422310757 | 38 | 2 | 15 | 1 | 37 | 74 | 40236 | 40200 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000022 | blastn | 38 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 17196138 | 17196138 | PRJNA643700_P_NODE_38234_length_660_cov_2.746318_g36885_i0 | PRJNA643700 | 38234 | 660 | 2.746318 | 18.1256988 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 54.7 | 0.018 | NTclustered | gi|351061203|emb|FO081081.1| | 6239 | g36885 | i0 | 100 | 0.0878787878787879 | 29 | 0 | 4 | 0 | 203 | 231 | 36070 | 36042 | Caenorhabditis elegans Cosmid F54D7, complete sequence | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 24844535 | 24844535 | PRJNA643700_P_NODE_331940_length_194_cov_1.075862_g330384_i0 | PRJNA643700 | 331940 | 194 | 1.075862 | 2.08717228 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.017 | NTclustered | gi|690018472|emb|LM525710.1| | 174720 | g330384 | i0 | 100 | 0.288659793814433 | 28 | 0 | 14 | 0 | 93 | 120 | 77094 | 77067 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000106 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 26923117 | 26923117 | PRJNA643700_P_NODE_249102_length_240_cov_1.633508_g247546_i0 | PRJNA643700 | 249102 | 240 | 1.633508 | 3.9204192 | Anisakis simplex | 6269 | Nematoda | Nematoda | 42.4 | 0.0091 | NR | VDK78339.1 | 6269 | g247546 | i0 | 64.1 | 0.4875 | 39 | 13 | 47.5 | 1 | 1 | 114 | 44 | 82 | VDK78339.1 unnamed protein product [Anisakis simplex] | diamond | 117 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anisakidae | Anisakis | Anisakis simplex | |
| 27061911 | 27061911 | PRJNA643700_P_NODE_387422_length_169_cov_0.866667_g385866_i0 | PRJNA643700 | 387422 | 169 | 0.866667 | 1.46466723 | Onchocercidae | 6296 | Nematoda | Nematoda | 45.8 | 0.00114 | NR | CDQ02964.2 | 6279 | g385866 | i0 | 48.7 | 5.53846153846154 | 39 | 18 | 69.2 | 1 | 17 | 133 | 425 | 461 | CDQ02964.2 Bm7449, isoform b [Brugia malayi] | diamond | 936 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 27207475 | 27207475 | PRJNA643700_P_NODE_424402_length_162_cov_0.920354_g422846_i0 | PRJNA643700 | 424402 | 162 | 0.920354 | 1.49097348 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 47.4 | 2.86e-4 | NR | XP_002635469.2 | 6238 | g422846 | i0 | 85.7 | 2.57407407407407 | 21 | 3 | 38.9 | 0 | 99 | 161 | 745 | 765 | XP_002635469.2 Protein CBG08763 [Caenorhabditis briggsae] | diamond | 417 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 27788611 | 27788611 | PRJNA643700_P_NODE_101304_length_414_cov_3.389041_g99751_i0 | PRJNA643700 | 101304 | 414 | 3.389041 | 14.03062974 | Trichostrongylidae | 6315 | Nematoda | Nematoda | 57.8 | 1.24e-6 | NR | CDJ94991.1 | 6289 | g99751 | i0 | 42.9 | 4.3768115942029 | 70 | 34 | 46.4 | 2 | 146 | 337 | 409 | 478 | CDJ94991.1 RNA-directed DNA polymerase (reverse transcriptase) domain containing protein [Haemonchus contortus] | diamond | 1812 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Haemonchus | Haemonchus contortus | |
| 28344526 | 28344526 | PRJNA643700_P_NODE_411306_length_164_cov_2.260870_g409750_i0 | PRJNA643700 | 411306 | 164 | 2.26087 | 3.7078268 | Aphelenchoides besseyi | 269767 | Nematoda | Nematoda | 53.5 | 1.98e-6 | NR | KAI6180585.1 | 269767 | g409750 | i0 | 41.5 | 0.969512195121951 | 53 | 31 | 97 | 0 | 160 | 2 | 557 | 609 | KAI6180585.1 Alpha-galactosidase [Aphelenchoides besseyi] | diamond | 159 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 30049499 | 30049499 | PRJNA643700_P_NODE_372411_length_175_cov_1.380952_g370855_i0 | PRJNA643700 | 372411 | 175 | 1.380952 | 2.416666 | Ancylostoma ceylanicum | 53326 | Nematoda | Nematoda | 40.4 | 0.0477 | NR | EYC22546.1 | 53326 | g370855 | i0 | 46.2 | 0.668571428571429 | 39 | 19 | 63.4 | 1 | 47 | 157 | 60 | 98 | EYC22546.1 hypothetical protein Y032_0017g3413 [Ancylostoma ceylanicum] | diamond | 117 | 40.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma ceylanicum | |
| 31250296 | 31250296 | PRJNA643700_P_NODE_199095_length_279_cov_2.134783_g197539_i0 | PRJNA643700 | 199095 | 279 | 2.134783 | 5.95604457 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 43.9 | 0.0202 | NR | UMM34810.1 | 6238 | g197539 | i0 | 34.4 | 1.37634408602151 | 64 | 42 | 68.8 | 0 | 210 | 19 | 65 | 128 | UMM34810.1 hypothetical protein L5515_007713 [Caenorhabditis briggsae] | diamond | 384 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 32306880 | 32306880 | PRJNA643700_P_NODE_140979_length_345_cov_1.756757_g139424_i0 | PRJNA643700 | 140979 | 345 | 1.756757 | 6.06081165 | root | 1 | Root_unresolved | Root_unresolved | 218 | 1.79e-67 | NR | UMM35145.1 | 6238 | g139424 | i0 | 91.2 | 492.321739130435 | 114 | 10 | 99.1 | 0 | 3 | 344 | 206 | 319 | UMM35145.1 hypothetical protein L5515_007902 [Caenorhabditis briggsae] | diamond | 169851 | 220 | 0.990909090909091 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 32370048 | 32370048 | PRJNA643700_P_NODE_284079_length_218_cov_2.124260_g282523_i0 | PRJNA643700 | 284079 | 218 | 2.12426 | 4.6308868 | Opisthokonta | 33154 | Nematoda | Nematoda | 65.1 | 3.09e-10 | NR | EFP04527.1 | 31234 | g282523 | i0 | 55.3 | 3.6743119266055 | 47 | 21 | 64.7 | 0 | 214 | 74 | 207 | 253 | EFP04527.1 hypothetical protein CRE_31234 [Caenorhabditis remanei] | diamond | 801 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei |
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);;