contig_metadata
12 rows where bioproject = "PRJNA1129273", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6661107 | 6661107 | PRJNA1129273_P_NODE_2666_length_467_cov_4.428934_g2390_i0 | PRJNA1129273 | 2666 | 467 | 4.428934 | 20.68312178 | Metazoa | 33208 | Nematoda | Nematoda | 214 | 1.89e-65 | NR | KRY41729.1 | 6334 | g2390 | i0 | 67.8 | 11.4603854389722 | 149 | 48 | 95.7 | 0 | 21 | 467 | 226 | 374 | KRY41729.1 60S ribosomal protein L27a [Trichinella spiralis] | diamond | 5352 | 216 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 15586184 | 15586184 | PRJNA1129273_P_NODE_4733_length_328_cov_0.905882_g4453_i0 | PRJNA1129273 | 4733 | 328 | 0.905882 | 2.97129296 | Toxocara canis | 6265 | Nematoda | Nematoda | 155 | 3.76e-43 | NR | VDM39791.1 | 6265 | g4453 | i0 | 83.5 | 1.66463414634146 | 91 | 14 | 83.2 | 1 | 326 | 54 | 339 | 428 | VDM39791.1 unnamed protein product [Toxocara canis] | diamond | 546 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 19409130 | 19409130 | PRJNA1129273_P_NODE_3256_length_410_cov_1.160237_g2977_i0 | PRJNA1129273 | 3256 | 410 | 1.160237 | 4.7569717 | Dictyocaulus viviparus | 29172 | Nematoda | Nematoda | 200 | 8.76e-59 | NR | KJH45969.1 | 29172 | g2977 | i0 | 67.4 | 5.8609756097561 | 135 | 44 | 98.8 | 0 | 4 | 408 | 113 | 247 | KJH45969.1 putative histidine--tRNA ligase [Dictyocaulus viviparus] | diamond | 2403 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Dictyocaulus | Dictyocaulus viviparus | |
| 27217193 | 27217193 | PRJNA1129273_P_NODE_3622_length_384_cov_4.678457_g3342_i0 | PRJNA1129273 | 3622 | 384 | 4.678457 | 17.96527488 | Rhabditida | 6236 | Nematoda | Nematoda | 134 | 4.95e-38 | NR | CAD5208042.1 | 6326 | g3342 | i0 | 69.2 | 3.5546875 | 91 | 28 | 71.1 | 0 | 331 | 59 | 1 | 91 | CAD5208042.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 1365 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 27438927 | 27438927 | PRJNA1129273_P_NODE_7503_length_265_cov_1.812500_g7223_i0 | PRJNA1129273 | 7503 | 265 | 1.8125 | 4.803125 | Caenorhabditis | 6237 | Nematoda | Nematoda | 95.1 | 9.84e-24 | NR | NP_001379573.1 | 6239 | g7223 | i0 | 73.6 | 4.17735849056604 | 53 | 14 | 60 | 0 | 213 | 55 | 3 | 55 | NP_001379573.1 Small ribosomal subunit protein uS14 [Caenorhabditis elegans] | diamond | 1107 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 28354251 | 28354251 | PRJNA1129273_P_NODE_6866_length_274_cov_4.970149_g6586_i0 | PRJNA1129273 | 6866 | 274 | 4.970149 | 13.61820826 | Opisthokonta | 33154 | Nematoda | Nematoda | 122 | 8.35e-34 | NR | KAF8363112.1 | 54126 | g6586 | i0 | 69 | 5.44160583941606 | 84 | 25 | 92 | 1 | 20 | 271 | 19 | 101 | KAF8363112.1 hypothetical protein PRIPAC_90035 [Pristionchus pacificus] | diamond | 1491 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 28933588 | 28933588 | PRJNA1129273_P_NODE_3208_length_414_cov_2.390029_g2929_i0 | PRJNA1129273 | 3208 | 414 | 2.390029 | 9.89472006 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 89 | 1.04e-19 | NR | GMT18625.1 | 1538716 | g2929 | i0 | 40.5 | 1.88405797101449 | 131 | 71 | 94.2 | 3 | 2 | 391 | 2 | 126 | GMT18625.1 hypothetical protein PFISCL1PPCAC_9922 [Pristionchus fissidentatus] | diamond | 780 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 29123279 | 29123279 | PRJNA1129273_P_NODE_1609_length_643_cov_2.238596_g1344_i0 | PRJNA1129273 | 1609 | 643 | 2.238596 | 14.39417228 | Ancylostoma duodenale | 51022 | Nematoda | Nematoda | 173 | 3.02e-50 | NR | KIH46789.1 | 51022 | g1344 | i0 | 47.8 | 11.3561430793157 | 182 | 82 | 84 | 4 | 548 | 9 | 33 | 203 | KIH46789.1 papain family cysteine protease [Ancylostoma duodenale] | diamond | 7302 | 173 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma duodenale | |
| 29975546 | 29975546 | PRJNA1129273_P_NODE_1931_length_578_cov_1.584158_g1660_i0 | PRJNA1129273 | 1931 | 578 | 1.584158 | 9.15643324 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 46.6 | 0.0349 | NR | CAK5069761.1 | 390850 | g1660 | i0 | 33 | 0.975778546712803 | 94 | 57 | 48.3 | 3 | 145 | 423 | 728 | 816 | CAK5069761.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 564 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 30659705 | 30659705 | PRJNA1129273_P_NODE_8453_length_252_cov_2.273743_g8173_i0 | PRJNA1129273 | 8453 | 252 | 2.273743 | 5.72983236 | Metazoa | 33208 | Nematoda | Nematoda | 59.7 | 4.35e-8 | NR | EFP12493.1 | 31234 | g8173 | i0 | 43.8 | 9.59523809523809 | 80 | 38 | 86.9 | 1 | 3 | 221 | 296 | 375 | EFP12493.1 CRE-PAB-1 protein [Caenorhabditis remanei] | diamond | 2418 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 31544898 | 31544898 | PRJNA1129273_P_NODE_6096_length_287_cov_1.429907_g5816_i0 | PRJNA1129273 | 6096 | 287 | 1.429907 | 4.10383309 | Rhabditidae | 6243 | Nematoda | Nematoda | 67 | 1.73e-10 | NR | CAJ0947582.1 | 2138241 | g5816 | i0 | 43.6 | 3.97212543554007 | 94 | 51 | 96.2 | 1 | 278 | 3 | 46 | 139 | CAJ0947582.1 unnamed protein product, partial [Mesorhabditis belari] | diamond | 1140 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis belari | |
| 31618920 | 31618920 | PRJNA1129273_P_NODE_9616_length_246_cov_1.757225_g9336_i0 | PRJNA1129273 | 9616 | 246 | 1.757225 | 4.3227735 | Parelaphostrongylus tenuis | 148309 | Nematoda | Nematoda | 43.9 | 0.0147 | NR | KAJ1360850.1 | 148309 | g9336 | i0 | 48.9 | 2.4390243902439 | 47 | 24 | 57.3 | 0 | 244 | 104 | 235 | 281 | KAJ1360850.1 Rio2, N-terminal [Parelaphostrongylus tenuis] | diamond | 600 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Parelaphostrongylus | Parelaphostrongylus tenuis |
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);;