contig_metadata
19 rows where bioproject = "PRJNA734348", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1992849 | 1992849 | PRJNA734348_P_NODE_106462_length_247_cov_1.770115_g105764_i0 | PRJNA734348 | 106462 | 247 | 1.770115 | 4.37218405 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 457 | 4.05e-124 | NTclustered | gi|687865956|emb|LK928046.1| | 6239 | g105764 | i0 | 100 | 83.5303643724696 | 247 | 0 | 100 | 0 | 1 | 247 | 46405 | 46159 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000432 | blastn | 20632 | 457 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 6301278 | 6301278 | PRJNA734348_P_NODE_37525_length_319_cov_1.516260_g36829_i0 | PRJNA734348 | 37525 | 319 | 1.51626 | 4.8368694 | Diplogasteridae | 50861 | Nematoda | Nematoda | 283 | 9.74e-72 | NTclustered | gi|675118776|gb|KJ877247.1| | 1538690 | g36829 | i0 | 84.828 | 50.4294670846395 | 290 | 34 | 89 | 9 | 1 | 285 | 3164 | 3448 | Butlerius sp. VS-2014 28S ribosomal RNA gene, partial sequence | blastn | 16087 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Butlerius | Butlerius sp. VS-2014 | |
| 9645392 | 9645392 | PRJNA734348_P_NODE_110668_length_246_cov_1.722543_g109970_i0 | PRJNA734348 | 110668 | 246 | 1.722543 | 4.23745578 | Diploscapter sp. JU359 | 479134 | Nematoda | Nematoda | 453 | 5.2100000000000006e-123 | NTclustered | gi|158821895|gb|EU195959.1| | 479134 | g109970 | i0 | 100 | 89.0731707317073 | 245 | 0 | 99 | 0 | 2 | 246 | 1184 | 940 | Diploscapter sp. JU359 28S ribosomal RNA gene, partial sequence | blastn | 21912 | 453 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter sp. JU359 | |
| 18570732 | 18570732 | PRJNA734348_P_NODE_80355_length_260_cov_2.101604_g79657_i0 | PRJNA734348 | 80355 | 260 | 2.101604 | 5.4641704 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 481 | 2.55e-131 | NTclustered | gi|412977031|emb|AL110479.3| | 6239 | g79657 | i0 | 100 | 2 | 260 | 0 | 100 | 0 | 1 | 260 | 282058 | 281799 | Caenorhabditis elegans YAC Y105C5B, complete sequence | blastn | 520 | 481 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 27052518 | 27052518 | PRJNA734348_P_NODE_111242_length_246_cov_1.063584_g110544_i0 | PRJNA734348 | 111242 | 246 | 1.063584 | 2.61641664 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 62.4 | 4.66e-9 | NR | PAV75994.1 | 2018661 | g110544 | i0 | 96.6 | 0.707317073170732 | 29 | 1 | 35.4 | 0 | 158 | 244 | 1681 | 1709 | PAV75994.1 hypothetical protein WR25_26632 [Diploscapter pachys] | diamond | 174 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 28000209 | 28000209 | PRJNA734348_P_NODE_127325_length_242_cov_1.384615_g126627_i0 | PRJNA734348 | 127325 | 242 | 1.384615 | 3.3507683 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 49.3 | 1.82e-4 | NR | PAV84384.1 | 2018661 | g126627 | i0 | 88.5 | 0.322314049586777 | 26 | 3 | 32.2 | 0 | 230 | 153 | 974 | 999 | PAV84384.1 hypothetical protein WR25_16440 [Diploscapter pachys] | diamond | 78 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 28347275 | 28347275 | PRJNA734348_P_NODE_125086_length_243_cov_0.905882_g124388_i0 | PRJNA734348 | 125086 | 243 | 0.905882 | 2.20129326 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 94 | 5.8100000000000006e-21 | NR | PAV61371.1 | 2018661 | g124388 | i0 | 80.3 | 1.50617283950617 | 61 | 12 | 75.3 | 0 | 199 | 17 | 1 | 61 | PAV61371.1 hypothetical protein WR25_26378 isoform B [Diploscapter pachys] | diamond | 366 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 28820591 | 28820591 | PRJNA734348_P_NODE_119848_length_244_cov_0.900585_g119150_i0 | PRJNA734348 | 119848 | 244 | 0.900585 | 2.1974274 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 68.9 | 1.68e-11 | NR | PAV80989.1 | 2018661 | g119150 | i0 | 94.4 | 0.885245901639344 | 36 | 2 | 44.3 | 0 | 4 | 111 | 95 | 130 | PAV80989.1 hypothetical protein WR25_04784 [Diploscapter pachys] | diamond | 216 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 28947525 | 28947525 | PRJNA734348_P_NODE_92988_length_251_cov_0.865169_g92290_i0 | PRJNA734348 | 92988 | 251 | 0.865169 | 2.17157419 | Caenorhabditis angaria | 860376 | Nematoda | Nematoda | 94 | 3.89e-20 | NR | CAI5446223.1 | 860376 | g92290 | i0 | 63 | 2.60557768924303 | 73 | 27 | 87.3 | 0 | 219 | 1 | 376 | 448 | CAI5446223.1 unnamed protein product [Caenorhabditis angaria] | diamond | 654 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis angaria | |
| 29073719 | 29073719 | PRJNA734348_P_NODE_67348_length_272_cov_2.030151_g66651_i0 | PRJNA734348 | 67348 | 272 | 2.030151 | 5.52201072 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 90.1 | 6.37e-20 | NR | PAV62172.1 | 2018661 | g66651 | i0 | 100 | 0.529411764705882 | 48 | 0 | 52.9 | 0 | 26 | 169 | 85 | 132 | PAV62172.1 hypothetical protein WR25_16976 [Diploscapter pachys] | diamond | 144 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 29199981 | 29199981 | PRJNA734348_P_NODE_128109_length_242_cov_0.911243_g127411_i0 | PRJNA734348 | 128109 | 242 | 0.911243 | 2.20520806 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 108 | 5.1100000000000005e-26 | NR | PAV65693.1 | 2018661 | g127411 | i0 | 98.1 | 0.669421487603306 | 54 | 1 | 66.9 | 0 | 163 | 2 | 297 | 350 | PAV65693.1 hypothetical protein WR25_17212 [Diploscapter pachys] | diamond | 162 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 29231540 | 29231540 | PRJNA734348_P_NODE_129809_length_242_cov_0.911243_g129111_i0 | PRJNA734348 | 129809 | 242 | 0.911243 | 2.20520806 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 46.2 | 0.00212 | NR | PAV61142.1 | 2018661 | g129111 | i0 | 84 | 0.309917355371901 | 25 | 4 | 31 | 0 | 12 | 86 | 357 | 381 | PAV61142.1 hypothetical protein WR25_13341 [Diploscapter pachys] | diamond | 75 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 30400487 | 30400487 | PRJNA734348_P_NODE_90413_length_252_cov_1.435754_g89715_i0 | PRJNA734348 | 90413 | 252 | 1.435754 | 3.61810008 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 62.8 | 3.63e-9 | NR | PAV89503.1 | 2018661 | g89715 | i0 | 72.7 | 0.523809523809524 | 44 | 12 | 52.4 | 0 | 23 | 154 | 8 | 51 | PAV89503.1 hypothetical protein WR25_06164 [Diploscapter pachys] | diamond | 132 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 31126344 | 31126344 | PRJNA734348_P_NODE_98455_length_249_cov_2.738636_g97757_i0 | PRJNA734348 | 98455 | 249 | 2.738636 | 6.81920364 | Haemonchus contortus | 6289 | Nematoda | Nematoda | 47.8 | 6.98e-4 | NR | CDJ87103.1 | 6289 | g97757 | i0 | 65.5 | 2.09638554216867 | 29 | 10 | 34.9 | 0 | 87 | 1 | 436 | 464 | CDJ87103.1 Haem peroxidase domain containing protein, partial [Haemonchus contortus] | diamond | 522 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Haemonchus | Haemonchus contortus | |
| 31579758 | 31579758 | PRJNA734348_P_NODE_127656_length_242_cov_0.911243_g126958_i0 | PRJNA734348 | 127656 | 242 | 0.911243 | 2.20520806 | Rhabditida | 6236 | Nematoda | Nematoda | 120 | 9.16e-30 | NR | NP_001367002.1 | 6239 | g126958 | i0 | 66.2 | 9.71900826446281 | 77 | 24 | 95.5 | 1 | 3 | 233 | 338 | 412 | NP_001367002.1 Serine/threonine-protein phosphatase 5 [Caenorhabditis elegans] | diamond | 2352 | 121 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 31737614 | 31737614 | PRJNA734348_P_NODE_89217_length_253_cov_1.311111_g88519_i0 | PRJNA734348 | 89217 | 253 | 1.311111 | 3.31711083 | root | 1 | Root_unresolved | Root_unresolved | 97.8 | 1.52e-21 | NR | KAK6031666.1 | 6317 | g88519 | i0 | 57.8 | 4.6600790513834 | 83 | 32 | 97.2 | 2 | 252 | 7 | 214 | 294 | KAK6031666.1 prepilin-type cleavage/methylation protein [Ostertagia ostertagi] | diamond | 1179 | 98.2 | 0.995926680244399 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Ostertagia | Ostertagia ostertagi | |
| 31790661 | 31790661 | PRJNA734348_P_NODE_92957_length_251_cov_0.865169_g92259_i0 | PRJNA734348 | 92957 | 251 | 0.865169 | 2.17157419 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 42.7 | 0.04 | NR | PAV82159.1 | 2018661 | g92259 | i0 | 56.3 | 0.382470119521912 | 32 | 14 | 38.2 | 0 | 98 | 193 | 328 | 359 | PAV82159.1 hypothetical protein WR25_19251 [Diploscapter pachys] | diamond | 96 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 32012280 | 32012280 | PRJNA734348_P_NODE_104838_length_248_cov_0.880000_g104140_i0 | PRJNA734348 | 104838 | 248 | 0.88 | 2.1824 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 61.6 | 8.6e-9 | NR | CAD5222373.1 | 6326 | g104140 | i0 | 67.6 | 0.44758064516129 | 37 | 12 | 44.8 | 0 | 142 | 32 | 5 | 41 | CAD5222373.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 111 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 32644388 | 32644388 | PRJNA734348_P_NODE_109500_length_247_cov_0.885057_g108802_i0 | PRJNA734348 | 109500 | 247 | 0.885057 | 2.18609079 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 50.8 | 4.89e-5 | NR | PAV81939.1 | 2018661 | g108802 | i0 | 82.1 | 0.340080971659919 | 28 | 5 | 34 | 0 | 3 | 86 | 281 | 308 | PAV81939.1 hypothetical protein WR25_26866 [Diploscapter pachys] | diamond | 84 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys |
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);;