contig_metadata
16 rows where bioproject = "PRJNA562549", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1821570 | 1821570 | PRJNA562549_P_NODE_9022_length_383_cov_2.049689_g8789_i0 | PRJNA562549 | 9022 | 383 | 2.049689 | 7.85030887 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 254 | 9.33e-63 | NTclustered | gi|2445394858|ref|XM_053736093.1| | 31234 | g8789 | i0 | 84.556 | 67.8067885117493 | 259 | 36 | 67 | 4 | 109 | 365 | 115 | 371 | Caenorhabditis remanei uncharacterized protein (GCK72_024876), partial mRNA | blastn | 25970 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 5649471 | 5649471 | PRJNA562549_P_NODE_16545_length_284_cov_1.165919_g16312_i0 | PRJNA562549 | 16545 | 284 | 1.165919 | 3.31120996 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 110 | 1.53e-19 | NTclustered | gi|687866011|emb|LK928302.1| | 6239 | g16312 | i0 | 92.208 | 43.3450704225352 | 77 | 6 | 27 | 0 | 1 | 77 | 2471 | 2395 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000180 | blastn | 12310 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 10750005 | 10750005 | PRJNA562549_P_NODE_19329_length_264_cov_1.798030_g19096_i0 | PRJNA562549 | 19329 | 264 | 1.79803 | 4.7467992 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 100 | 5.62e-26 | NR | CAD2132787.1 | 390850 | g19096 | i0 | 82.1 | 1.29545454545455 | 56 | 10 | 63.6 | 0 | 228 | 61 | 1 | 56 | CAD2132787.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 342 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 12024826 | 12024826 | PRJNA562549_P_NODE_26170_length_230_cov_1.100592_g25937_i0 | PRJNA562549 | 26170 | 230 | 1.100592 | 2.5313616 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 231 | 2.4599999999999996e-56 | NTclustered | gi|1376136641|ref|XM_024648415.1| | 34506 | g25937 | i0 | 85.088 | 100.295652173913 | 228 | 32 | 99 | 2 | 3 | 229 | 160 | 386 | Strongyloides ratti Actin, alpha cardiac muscle 1 (SRAE_1000145800), partial mRNA | blastn | 23068 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 12609866 | 12609866 | PRJNA562549_P_NODE_32450_length_209_cov_1.513514_g32217_i0 | PRJNA562549 | 32450 | 209 | 1.513514 | 3.16324426 | Opisthokonta | 33154 | Nematoda | Nematoda | 108 | 1.4e-26 | NR | VBB30565.1 | 6277 | g32217 | i0 | 70.6 | 4.70813397129187 | 68 | 20 | 97.6 | 0 | 5 | 208 | 51 | 118 | VBB30565.1 unnamed protein product [Acanthocheilonema viteae] | diamond | 984 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Acanthocheilonema | Acanthocheilonema viteae | |
| 20947844 | 20947844 | PRJNA562549_P_NODE_22117_length_248_cov_2.262032_g21884_i0 | PRJNA562549 | 22117 | 248 | 2.262032 | 5.60983936 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 130 | 4.97e-33 | NR | PAV91871.1 | 2018661 | g21884 | i0 | 73.2 | 0.991935483870968 | 82 | 16 | 99.2 | 1 | 1 | 246 | 619 | 694 | PAV91871.1 hypothetical protein WR25_15623 isoform B [Diploscapter pachys] | diamond | 246 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 20948008 | 20948008 | PRJNA562549_P_NODE_737_length_1164_cov_10.106074_g675_i0 | PRJNA562549 | 737 | 1164 | 10.106074 | 117.63470136 | Metazoa | 33208 | Nematoda | Nematoda | 611 | 1.0799999999999997e-218 | NR | CAD5220709.1 | 6326 | g675 | i0 | 89.4 | 38.4329896907216 | 321 | 31 | 82 | 1 | 1112 | 159 | 1 | 321 | CAD5220709.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 44736 | 616 | 0.991883116883117 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 27061374 | 27061374 | PRJNA562549_P_NODE_16322_length_286_cov_0.933333_g16089_i0 | PRJNA562549 | 16322 | 286 | 0.933333 | 2.66933238 | Metazoa | 33208 | Nematoda | Nematoda | 116 | 2.23e-29 | NR | VBB30565.1 | 6277 | g16089 | i0 | 62.8 | 48.3146853146853 | 94 | 35 | 98.6 | 0 | 4 | 285 | 97 | 190 | VBB30565.1 unnamed protein product [Acanthocheilonema viteae] | diamond | 13818 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Acanthocheilonema | Acanthocheilonema viteae | |
| 27945871 | 27945871 | PRJNA562549_P_NODE_11405_length_340_cov_1.397849_g11172_i0 | PRJNA562549 | 11405 | 340 | 1.397849 | 4.7526866 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 135 | 2.7199999999999997e-37 | NR | XP_003377959.1 | 6334 | g11172 | i0 | 63.3 | 13.8088235294118 | 98 | 36 | 86.5 | 0 | 339 | 46 | 76 | 173 | XP_003377959.1 60S ribosomal protein L27a [Trichinella spiralis] | diamond | 4695 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 28373959 | 28373959 | PRJNA562549_P_NODE_35866_length_203_cov_0.915493_g35633_i0 | PRJNA562549 | 35866 | 203 | 0.915493 | 1.85845079 | Caenorhabditis auriculariae | 2777116 | Nematoda | Nematoda | 42.4 | 0.0291 | NR | CAD6191633.1 | 2777116 | g35633 | i0 | 35.5 | 0.916256157635468 | 62 | 38 | 91.6 | 1 | 197 | 12 | 109 | 168 | CAD6191633.1 unnamed protein product [Caenorhabditis auriculariae] | diamond | 186 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis auriculariae | |
| 28387817 | 28387817 | PRJNA562549_P_NODE_27586_length_224_cov_2.392638_g27353_i0 | PRJNA562549 | 27586 | 224 | 2.392638 | 5.35950912 | Metazoa | 33208 | Nematoda | Nematoda | 54.3 | 2.45e-6 | NR | KAK6053235.1 | 27828 | g27353 | i0 | 33.3 | 2.93303571428571 | 75 | 49 | 99.1 | 1 | 2 | 223 | 72 | 146 | KAK6053235.1 EGF-like domain protein [Cooperia oncophora] | diamond | 657 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Cooperia | Cooperia oncophora | |
| 30427143 | 30427143 | PRJNA562549_P_NODE_30753_length_213_cov_1.644737_g30520_i0 | PRJNA562549 | 30753 | 213 | 1.644737 | 3.50328981 | Auanema sp. JU1783 | 2878363 | Nematoda | Nematoda | 66.6 | 9.74e-11 | NR | CAI4229175.1 | 2878363 | g30520 | i0 | 46.5 | 3.98591549295775 | 71 | 36 | 100 | 2 | 213 | 1 | 140 | 208 | CAI4229175.1 unnamed protein product [Auanema sp. JU1783] | diamond | 849 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Auanema | Auanema sp. JU1783 | |
| 30584521 | 30584521 | PRJNA562549_P_NODE_33753_length_207_cov_0.890411_g33520_i0 | PRJNA562549 | 33753 | 207 | 0.890411 | 1.84315077 | Aphelenchoides besseyi | 269767 | Nematoda | Nematoda | 48.5 | 1.62e-4 | NR | KAI6211352.1 | 269767 | g33520 | i0 | 54.5 | 2.34782608695652 | 33 | 15 | 47.8 | 0 | 48 | 146 | 108 | 140 | KAI6211352.1 hypothetical protein M3Y96_00425100 [Aphelenchoides besseyi] | diamond | 486 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 30724871 | 30724871 | PRJNA562549_P_NODE_25614_length_232_cov_1.520468_g25381_i0 | PRJNA562549 | 25614 | 232 | 1.520468 | 3.52748576 | Rhabditida | 6236 | Nematoda | Nematoda | 68.9 | 1.92e-11 | NR | EFP01601.1 | 31234 | g25381 | i0 | 67.4 | 2.7801724137931 | 43 | 14 | 55.6 | 0 | 4 | 132 | 718 | 760 | EFP01601.1 hypothetical protein CRE_03500 [Caenorhabditis remanei] | diamond | 645 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 31058941 | 31058941 | PRJNA562549_P_NODE_24655_length_236_cov_1.657143_g24422_i0 | PRJNA562549 | 24655 | 236 | 1.657143 | 3.91085748 | Aphelenchoides besseyi | 269767 | Nematoda | Nematoda | 59.7 | 3.99e-9 | NR | KAI6225682.1 | 269767 | g24422 | i0 | 59.1 | 1.67796610169492 | 44 | 18 | 55.9 | 0 | 134 | 3 | 40 | 83 | KAI6225682.1 RPB6-like protein [Aphelenchoides besseyi] | diamond | 396 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 31279766 | 31279766 | PRJNA562549_P_NODE_26855_length_227_cov_1.957831_g26622_i0 | PRJNA562549 | 26855 | 227 | 1.957831 | 4.44427637 | Soboliphyme baturini | 241478 | Nematoda | Nematoda | 92.4 | 4.040000000000001e-21 | NR | VDP19351.1 | 241478 | g26622 | i0 | 66.2 | 5.52422907488987 | 68 | 23 | 89.9 | 0 | 226 | 23 | 139 | 206 | VDP19351.1 unnamed protein product [Soboliphyme baturini] | diamond | 1254 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini |
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);;