contig_metadata
13 rows where bioproject = "PRJNA674048", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1919177 | 1919177 | PRJNA674048_P_NODE_10562_length_288_cov_2.343096_g10359_i0 | PRJNA674048 | 10562 | 288 | 2.343096 | 6.74811648 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 532 | 7.8e-147 | NTclustered | gi|1972267169|ref|NM_069484.3| | 6239 | g10359 | i0 | 100 | 3 | 288 | 0 | 100 | 0 | 1 | 288 | 482 | 195 | Caenorhabditis elegans Uncharacterized protein (Y43C5A.4), mRNA | blastn | 864 | 532 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 3193942 | 3193942 | PRJNA674048_P_NODE_17163_length_214_cov_3.018182_g16960_i0 | PRJNA674048 | 17163 | 214 | 3.018182 | 6.45890948 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 390 | 3.519999999999999e-104 | NTclustered | gi|687865476|emb|LK927750.1| | 6239 | g16960 | i0 | 99.533 | 2 | 214 | 1 | 100 | 0 | 1 | 214 | 64875 | 64662 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000194 | blastn | 428 | 390 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 4471108 | 4471108 | PRJNA674048_P_NODE_29744_length_165_cov_2.637931_g29541_i0 | PRJNA674048 | 29744 | 165 | 2.637931 | 4.35258615 | Micoletzkya japonica | 1250332 | Nematoda | Nematoda | 147 | 6.149999999999999e-31 | NTclustered | gi|410992323|gb|JX163990.1| | 1250332 | g29541 | i0 | 83.439 | 18.2545454545455 | 157 | 26 | 95 | 0 | 7 | 163 | 190 | 34 | Micoletzkya japonica large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 3012 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Micoletzkya | Micoletzkya japonica | |
| 7021762 | 7021762 | PRJNA674048_P_NODE_28846_length_167_cov_0.881356_g28643_i0 | PRJNA674048 | 28846 | 167 | 0.881356 | 1.47186452 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 309 | 7.53e-80 | NTclustered | gi|687865476|emb|LK927750.1| | 6239 | g28643 | i0 | 100 | 2 | 167 | 0 | 100 | 0 | 1 | 167 | 60812 | 60646 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000194 | blastn | 334 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 8296496 | 8296496 | PRJNA674048_P_NODE_3927_length_552_cov_2.019881_g3731_i0 | PRJNA674048 | 3927 | 552 | 2.019881 | 11.14974312 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 289 | 1.3299999999999993e-87 | NR | VBB30983.1 | 6277 | g3731 | i0 | 76.8 | 21.0760869565217 | 185 | 42 | 100 | 1 | 1 | 552 | 677 | 861 | VBB30983.1 unnamed protein product [Acanthocheilonema viteae] | diamond | 11634 | 291 | 0.993127147766323 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Acanthocheilonema | Acanthocheilonema viteae | |
| 17221252 | 17221252 | PRJNA674048_P_NODE_6774_length_384_cov_2.695522_g6571_i0 | PRJNA674048 | 6774 | 384 | 2.695522 | 10.35080448 | Sachsia zurstrasseni | 1538730 | Nematoda | Nematoda | 106 | 2.77e-18 | NTclustered | gi|675118987|gb|KJ877373.1| | 1538730 | g6571 | i0 | 95.455 | 1.59114583333333 | 66 | 3 | 17 | 0 | 319 | 384 | 410 | 345 | Sachsia zurstrasseni large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 611 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Sachsia | Sachsia zurstrasseni | |
| 18495523 | 18495523 | PRJNA674048_P_NODE_30595_length_164_cov_1.808696_g30392_i0 | PRJNA674048 | 30595 | 164 | 1.808696 | 2.96626144 | Loa loa | 7209 | Nematoda | Nematoda | 110 | 8.01e-20 | NTclustered | gi|1158592910|ref|XM_003138156.2| | 7209 | g30392 | i0 | 84.211 | 61.5243902439024 | 114 | 17 | 69 | 1 | 45 | 157 | 1499 | 1386 | Loa loa pre-mRNA-splicing factor ATP-dependent RNA helicase mRNA | blastn | 10090 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Loa | Loa loa | |
| 19770036 | 19770036 | PRJNA674048_P_NODE_31816_length_163_cov_0.912281_g31613_i0 | PRJNA674048 | 31816 | 163 | 0.912281 | 1.48701803 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 158 | 2.8e-34 | NTclustered | gi|1376143403|ref|XM_024652078.1| | 34506 | g31613 | i0 | 84.146 | 84.361963190184 | 164 | 24 | 100 | 2 | 1 | 163 | 842 | 680 | Strongyloides ratti Elongation factor 1-alpha (SRAE_2000115900), partial mRNA | blastn | 13751 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 21045706 | 21045706 | PRJNA674048_P_NODE_30997_length_164_cov_0.904348_g30794_i0 | PRJNA674048 | 30997 | 164 | 0.904348 | 1.48313072 | Opisthokonta | 33154 | Nematoda | Nematoda | 86.7 | 2.92e-19 | NR | VDP19351.1 | 241478 | g30794 | i0 | 77.8 | 1.97560975609756 | 54 | 12 | 98.8 | 0 | 162 | 1 | 124 | 177 | VDP19351.1 unnamed protein product [Soboliphyme baturini] | diamond | 324 | 87.4 | 0.991990846681922 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 27536131 | 27536131 | PRJNA674048_P_NODE_24563_length_177_cov_2.000000_g24360_i0 | PRJNA674048 | 24563 | 177 | 2 | 3.54 | Rhabditida | 6236 | Nematoda | Nematoda | 63.9 | 5.02e-11 | NR | KAK6039252.1 | 27828 | g24360 | i0 | 68.2 | 5.22033898305085 | 44 | 14 | 74.6 | 0 | 39 | 170 | 18 | 61 | KAK6039252.1 hypothetical protein COOONC_23244 [Cooperia oncophora] | diamond | 924 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Cooperia | Cooperia oncophora | |
| 27694212 | 27694212 | PRJNA674048_P_NODE_27864_length_168_cov_0.873950_g27661_i0 | PRJNA674048 | 27864 | 168 | 0.87395 | 1.468236 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 50.8 | 1.81e-5 | NR | MCP9257320.1 | 6287 | g27661 | i0 | 51.1 | 2.60714285714286 | 47 | 22 | 83.9 | 1 | 2 | 142 | 278 | 323 | MCP9257320.1 Protein phosphatase 1L [Dirofilaria immitis] | diamond | 438 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Dirofilaria | Dirofilaria immitis | |
| 31946527 | 31946527 | PRJNA674048_P_NODE_24437_length_178_cov_1.209302_g24234_i0 | PRJNA674048 | 24437 | 178 | 1.209302 | 2.15255756 | Trichinella britovi | 45882 | Nematoda | Nematoda | 53.1 | 1.79e-6 | NR | KRY44720.1 | 45882 | g24234 | i0 | 47.5 | 1.98876404494382 | 59 | 31 | 99.4 | 0 | 177 | 1 | 138 | 196 | KRY44720.1 Retrovirus-related Pol polyprotein from transposon 17.6 [Trichinella britovi] | diamond | 354 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella britovi | |
| 32053525 | 32053525 | PRJNA674048_P_NODE_25098_length_175_cov_1.650794_g24895_i0 | PRJNA674048 | 25098 | 175 | 1.650794 | 2.8888895 | Rhabditida | 6236 | Nematoda | Nematoda | 45.4 | 0.00169 | NR | KAI1720537.1 | 166010 | g24895 | i0 | 38.2 | 2.82857142857143 | 55 | 32 | 90.9 | 1 | 166 | 8 | 139 | 193 | KAI1720537.1 papain family cysteine protease domain-containing protein [Ditylenchus destructor] | diamond | 495 | 45.8 | 0.991266375545852 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor |
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);;