contig_metadata
17 rows where bioproject = "PRJNA431371", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11907138 | 11907138 | PRJNA431371_P_NODE_32370_length_244_cov_1.801170_g32297_i0 | PRJNA431371 | 32370 | 244 | 1.80117 | 4.3948548 | Metazoa | 33208 | Nematoda | Nematoda | 128 | 4.979999999999998e-35 | NR | VDM49891.1 | 6265 | g32297 | i0 | 69.1 | 45.7991803278689 | 81 | 25 | 99.6 | 0 | 243 | 1 | 10 | 90 | VDM49891.1 unnamed protein product [Toxocara canis] | diamond | 11175 | 129 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 15730803 | 15730803 | PRJNA431371_P_NODE_2293_length_710_cov_1.692308_g2220_i0 | PRJNA431371 | 2293 | 710 | 1.692308 | 12.0153868 | Metazoa | 33208 | Nematoda | Nematoda | 254 | 4.9900000000000007e-79 | NR | CDW54356.1 | 36087 | g2220 | i0 | 54.8 | 31.4492957746479 | 217 | 98 | 91.7 | 0 | 710 | 60 | 131 | 347 | CDW54356.1 eukaryotic peptide chain release factor subunit [Trichuris trichiura] | diamond | 22329 | 256 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 20829779 | 20829779 | PRJNA431371_P_NODE_19197_length_292_cov_1.273973_g19124_i0 | PRJNA431371 | 19197 | 292 | 1.273973 | 3.72000116 | Rhabditida | 6236 | Nematoda | Nematoda | 137 | 1.79e-36 | NR | XP_064044047.1 | 51031 | g19124 | i0 | 68.8 | 7.89041095890411 | 96 | 30 | 98.6 | 0 | 3 | 290 | 156 | 251 | XP_064044047.1 hypothetical protein RB195_020037 [Necator americanus] | diamond | 2304 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 20830154 | 20830154 | PRJNA431371_P_NODE_4337_length_564_cov_1.437882_g4264_i0 | PRJNA431371 | 4337 | 564 | 1.437882 | 8.10965448 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 257 | 1.1e-63 | NTclustered | gi|2158424922|ref|XM_045237347.1| | 6238 | g4264 | i0 | 77.556 | 2.89539007092199 | 450 | 85 | 78 | 13 | 1 | 442 | 1992 | 2433 | Caenorhabditis briggsae Protein CBR-EFT-2 (Cbr-eft-2), partial mRNA | blastn | 1633 | 257 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 28134681 | 28134681 | PRJNA431371_P_NODE_23325_length_261_cov_1.500000_g23252_i0 | PRJNA431371 | 23325 | 261 | 1.5 | 3.915 | Metazoa | 33208 | Nematoda | Nematoda | 134 | 2.2e-37 | NR | NP_001367640.1 | 6239 | g23252 | i0 | 64.4 | 15.9310344827586 | 87 | 31 | 100 | 0 | 261 | 1 | 79 | 165 | NP_001367640.1 Phosphatidylethanolamine-binding protein homolog F40A3.3 [Caenorhabditis elegans] | diamond | 4158 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 28497061 | 28497061 | PRJNA431371_P_NODE_9587_length_402_cov_1.811550_g9514_i0 | PRJNA431371 | 9587 | 402 | 1.81155 | 7.282431 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 52.8 | 6.75e-5 | NR | XP_024502458.1 | 34506 | g9514 | i0 | 40.8 | 2.25373134328358 | 76 | 44 | 56 | 1 | 9 | 233 | 798 | 873 | XP_024502458.1 Rab-GTPase-TBC domain and Pleckstrin homology domain and Pleckstrin homology-like domain-containing protein [Strongyloides ratti] | diamond | 906 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 29349513 | 29349513 | PRJNA431371_P_NODE_25929_length_250_cov_0.870056_g25856_i0 | PRJNA431371 | 25929 | 250 | 0.870056 | 2.17514 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 46.6 | 0.0018 | NR | GMT22004.1 | 1538716 | g25856 | i0 | 36.6 | 0.852 | 71 | 38 | 79.2 | 2 | 250 | 53 | 414 | 482 | GMT22004.1 hypothetical protein PFISCL1PPCAC_13301 [Pristionchus fissidentatus] | diamond | 213 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 29633199 | 29633199 | PRJNA431371_P_NODE_26810_length_249_cov_1.312500_g26737_i0 | PRJNA431371 | 26810 | 249 | 1.3125 | 3.268125 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 80.1 | 2.68e-15 | NR | CAD2199784.1 | 390850 | g26737 | i0 | 36.6 | 2.97590361445783 | 82 | 52 | 98.8 | 0 | 2 | 247 | 183 | 264 | CAD2199784.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 741 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 29854677 | 29854677 | PRJNA431371_P_NODE_13271_length_347_cov_3.514599_g13198_i0 | PRJNA431371 | 13271 | 347 | 3.514599 | 12.19565853 | Trichinella murrelli | 144512 | Nematoda | Nematoda | 137 | 3.45e-38 | NR | KRX45829.1 | 144512 | g13198 | i0 | 60.9 | 10.4870317002882 | 110 | 43 | 95.1 | 0 | 1 | 330 | 104 | 213 | KRX45829.1 GTP-binding nuclear protein Ran [Trichinella murrelli] | diamond | 3639 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella murrelli | |
| 30060473 | 30060473 | PRJNA431371_P_NODE_14691_length_333_cov_1.184615_g14618_i0 | PRJNA431371 | 14691 | 333 | 1.184615 | 3.94476795 | Metazoa | 33208 | Nematoda | Nematoda | 49.3 | 4.87e-4 | NR | KAE9417589.1 | 6313 | g14618 | i0 | 61.5 | 1.61261261261261 | 39 | 11 | 31.5 | 1 | 229 | 333 | 173 | 211 | KAE9417589.1 hypothetical protein Angca_003473 [Angiostrongylus cantonensis] | diamond | 537 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Angiostrongylus | Angiostrongylus cantonensis | |
| 30107252 | 30107252 | PRJNA431371_P_NODE_23332_length_261_cov_1.329787_g23259_i0 | PRJNA431371 | 23332 | 261 | 1.329787 | 3.47074407 | Heterodera trifolii | 157864 | Nematoda | Nematoda | 71.2 | 4.41e-12 | NR | KAL3117145.1 | 157864 | g23259 | i0 | 45.5 | 0.885057471264368 | 77 | 41 | 87.4 | 1 | 34 | 261 | 581 | 657 | KAL3117145.1 hypothetical protein niasHT_007548 [Heterodera trifolii] | diamond | 231 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera trifolii | |
| 30265625 | 30265625 | PRJNA431371_P_NODE_22332_length_269_cov_1.178571_g22259_i0 | PRJNA431371 | 22332 | 269 | 1.178571 | 3.17035599 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 67 | 1.51e-10 | NR | XP_024501165.1 | 34506 | g22259 | i0 | 42.2 | 1.94052044609665 | 83 | 44 | 88.1 | 2 | 239 | 3 | 1822 | 1904 | XP_024501165.1 E3 ubiquitin-protein ligase TRIP12 [Strongyloides ratti] | diamond | 522 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 30377013 | 30377013 | PRJNA431371_P_NODE_23712_length_258_cov_1.589189_g23639_i0 | PRJNA431371 | 23712 | 258 | 1.589189 | 4.10010762 | Metazoa | 33208 | Nematoda | Nematoda | 87.8 | 4.78e-18 | NR | VDK59019.1 | 71465 | g23639 | i0 | 48.2 | 4.93023255813953 | 85 | 43 | 98.8 | 1 | 4 | 258 | 310 | 393 | VDK59019.1 unnamed protein product [Cylicostephanus goldi] | diamond | 1272 | 88.6 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Cylicostephanus | Cylicostephanus goldi | |
| 30408520 | 30408520 | PRJNA431371_P_NODE_24173_length_254_cov_1.701657_g24100_i0 | PRJNA431371 | 24173 | 254 | 1.701657 | 4.32220878 | Metazoa | 33208 | Nematoda | Nematoda | 47 | 5.52e-4 | NR | XP_024510218.1 | 34506 | g24100 | i0 | 43.4 | 5.25590551181102 | 53 | 30 | 62.6 | 0 | 250 | 92 | 37 | 89 | XP_024510218.1 Anoctamin-8 [Strongyloides ratti] | diamond | 1335 | 47.4 | 0.991561181434599 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 30882071 | 30882071 | PRJNA431371_P_NODE_9594_length_402_cov_1.550152_g9521_i0 | PRJNA431371 | 9594 | 402 | 1.550152 | 6.23161104 | Metazoa | 33208 | Nematoda | Nematoda | 52.4 | 9.31e-5 | NR | MFH4977786.1 | 75299 | g9521 | i0 | 30.4 | 1.52985074626866 | 102 | 65 | 75.4 | 3 | 351 | 49 | 774 | 870 | MFH4977786.1 hypothetical protein [Gnathostoma spinigerum] | diamond | 615 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gnathostomatidae | Gnathostoma | Gnathostoma spinigerum | |
| 31086845 | 31086845 | PRJNA431371_P_NODE_18475_length_298_cov_1.137778_g18402_i0 | PRJNA431371 | 18475 | 298 | 1.137778 | 3.39057844 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 46.2 | 0.0042 | NR | XP_024510745.1 | 34506 | g18402 | i0 | 37.9 | 3.58389261744966 | 66 | 35 | 66.4 | 1 | 203 | 6 | 346 | 405 | XP_024510745.1 ATP-binding cassette sub-family G member 2 [Strongyloides ratti] | diamond | 1068 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 32793631 | 32793631 | PRJNA431371_P_NODE_12060_length_363_cov_1.327586_g11987_i0 | PRJNA431371 | 12060 | 363 | 1.327586 | 4.81913718 | Caenorhabditis brenneri | 135651 | Nematoda | Nematoda | 94.7 | 6.66e-20 | NR | EGT53893.1 | 135651 | g11987 | i0 | 40 | 4.03305785123967 | 120 | 68 | 99.2 | 2 | 362 | 3 | 208 | 323 | EGT53893.1 hypothetical protein CAEBREN_23563 [Caenorhabditis brenneri] | diamond | 1464 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis brenneri |
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);;