contig_metadata
22 rows where bioproject = "PRJNA1215813", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 331593 | 331593 | PRJNA1215813_P_NODE_11161_length_247_cov_0.896552_g11081_i0 | PRJNA1215813 | 11161 | 247 | 0.896552 | 2.21448344 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 274 | 4.38e-69 | NTclustered | gi|687865697|emb|LK927572.1| | 6239 | g11081 | i0 | 86.64 | 163.291497975708 | 247 | 33 | 100 | 0 | 1 | 247 | 120553 | 120799 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000039 | blastn | 40333 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 2882668 | 2882668 | PRJNA1215813_P_NODE_1903_length_539_cov_1.637339_g1823_i0 | PRJNA1215813 | 1903 | 539 | 1.637339 | 8.82525721 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 289 | 3.71e-73 | NTclustered | gi|1376135693|ref|XM_024647883.1| | 34506 | g1823 | i0 | 79.369 | 60.7736549165121 | 412 | 83 | 76 | 2 | 28 | 438 | 1 | 411 | Strongyloides ratti Histone H3 (SRAE_1000098500), partial mRNA | blastn | 32757 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 19457798 | 19457798 | PRJNA1215813_P_NODE_3576_length_402_cov_1.392097_g3496_i0 | PRJNA1215813 | 3576 | 402 | 1.392097 | 5.59622994 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 167 | 1.32e-36 | NTclustered | gi|1972267160|ref|NM_069458.7| | 6239 | g3496 | i0 | 82.292 | 2.4228855721393 | 192 | 34 | 48 | 0 | 211 | 402 | 256 | 447 | Caenorhabditis elegans Small ribosomal subunit protein RACK1 (rack-1), mRNA | blastn | 974 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 19457806 | 19457806 | PRJNA1215813_P_NODE_4136_length_375_cov_5.231788_g4056_i0 | PRJNA1215813 | 4136 | 375 | 5.231788 | 19.619205 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 294 | 5.37e-75 | NTclustered | gi|268537031|ref|XM_002633606.1| | 6238 | g4056 | i0 | 83.819 | 78.552 | 309 | 50 | 82 | 0 | 67 | 375 | 55 | 363 | Caenorhabditis briggsae Protein CBR-RPS-23 (Cbr-rps-23), partial mRNA | blastn | 29457 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 19457813 | 19457813 | PRJNA1215813_P_NODE_4796_length_350_cov_2.909747_g4716_i0 | PRJNA1215813 | 4796 | 350 | 2.909747 | 10.1841145 | Pristionchus sp. 15 RS5229 | 452809 | Nematoda | Nematoda | 183 | 1.12e-41 | NTclustered | gi|150982147|gb|EF634662.1| | 452809 | g4716 | i0 | 87.821 | 46.2885714285714 | 156 | 19 | 45 | 0 | 149 | 304 | 165 | 10 | Pristionchus sp. 15 RS5229 large subunit ribosomal protein 27a (rpl-27a) mRNA, partial cds | blastn | 16201 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 15 RS5229 | |
| 19457819 | 19457819 | PRJNA1215813_P_NODE_5136_length_340_cov_1.471910_g5056_i0 | PRJNA1215813 | 5136 | 340 | 1.47191 | 5.004494 | Pristionchus sp. 15 RS5229 | 452809 | Nematoda | Nematoda | 183 | 1.0899999999999998e-41 | NTclustered | gi|150984457|gb|EF634871.1| | 452809 | g5056 | i0 | 77.492 | 28.0941176470588 | 311 | 66 | 91 | 3 | 1 | 309 | 324 | 16 | Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds | blastn | 9552 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 15 RS5229 | |
| 23283925 | 23283925 | PRJNA1215813_P_NODE_2599_length_467_cov_1.449239_g2519_i0 | PRJNA1215813 | 2599 | 467 | 1.449239 | 6.76794613 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 292 | 2.4599999999999993e-74 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g2519 | i0 | 81.492 | 8.70663811563169 | 362 | 61 | 77 | 6 | 43 | 401 | 395 | 37 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 4066 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 26742949 | 26742949 | PRJNA1215813_P_NODE_6021_length_318_cov_0.955102_g5941_i0 | PRJNA1215813 | 6021 | 318 | 0.955102 | 3.03722436 | Opisthokonta | 33154 | Nematoda | Nematoda | 131 | 1.35e-36 | NR | TMS35535.1 | 34508 | g5941 | i0 | 63.9 | 9.91509433962264 | 97 | 35 | 91.5 | 0 | 9 | 299 | 53 | 149 | TMS35535.1 hypothetical protein L596_002918 [Steinernema carpocapsae] | diamond | 3153 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 27009301 | 27009301 | PRJNA1215813_P_NODE_9662_length_252_cov_0.871508_g9582_i0 | PRJNA1215813 | 9662 | 252 | 0.871508 | 2.19620016 | Aphelenchoides bicaudatus | 293665 | Nematoda | Nematoda | 60.1 | 3.23e-8 | NR | KAI6175940.1 | 293665 | g9582 | i0 | 44.4 | 1.71428571428571 | 72 | 40 | 85.7 | 0 | 222 | 7 | 1 | 72 | KAI6175940.1 Seryl-tRNA synthetase [Aphelenchoides bicaudatus] | diamond | 432 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides bicaudatus | |
| 27957145 | 27957145 | PRJNA1215813_P_NODE_9425_length_253_cov_0.866667_g9345_i0 | PRJNA1215813 | 9425 | 253 | 0.866667 | 2.19266751 | Caenorhabditis sp. 36 PRJEB53466 | 2970133 | Nematoda | Nematoda | 49.3 | 1.95e-4 | NR | CAI2346016.1 | 2970133 | g9345 | i0 | 56.8 | 3.03557312252964 | 37 | 16 | 43.9 | 0 | 111 | 221 | 11 | 47 | CAI2346016.1 unnamed protein product [Caenorhabditis sp. 36 PRJEB53466] | diamond | 768 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis sp. 36 PRJEB53466 | |
| 28259869 | 28259869 | PRJNA1215813_P_NODE_10026_length_251_cov_0.876404_g9946_i0 | PRJNA1215813 | 10026 | 251 | 0.876404 | 2.19977404 | Rhabditida | 6236 | Nematoda | Nematoda | 50.8 | 1.29e-5 | NR | VDM69699.1 | 40348 | g9946 | i0 | 35.9 | 6.54980079681275 | 78 | 40 | 93.2 | 2 | 245 | 12 | 39 | 106 | VDM69699.1 unnamed protein product [Strongylus vulgaris] | diamond | 1644 | 51.2 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Strongylus | Strongylus vulgaris | |
| 28588774 | 28588774 | PRJNA1215813_P_NODE_9267_length_253_cov_1.300000_g9187_i0 | PRJNA1215813 | 9267 | 253 | 1.3 | 3.289 | Onchocerca ochengi | 42157 | Nematoda | Nematoda | 68.6 | 3.29e-11 | NR | VDK81781.1 | 42157 | g9187 | i0 | 47.4 | 5.64426877470356 | 78 | 38 | 88.9 | 2 | 233 | 9 | 349 | 426 | VDK81781.1 unnamed protein product, partial [Onchocerca ochengi] | diamond | 1428 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Onchocerca | Onchocerca ochengi | |
| 28651724 | 28651724 | PRJNA1215813_P_NODE_847_length_765_cov_3.445087_g780_i0 | PRJNA1215813 | 847 | 765 | 3.445087 | 26.35491555 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 52.4 | 0.00101 | NR | CAJ0581790.1 | 96644 | g780 | i0 | 50 | 1.29411764705882 | 78 | 31 | 29 | 4 | 522 | 743 | 173 | 246 | CAJ0581790.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 990 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 29630148 | 29630148 | PRJNA1215813_P_NODE_7170_length_292_cov_1.068493_g7090_i0 | PRJNA1215813 | 7170 | 292 | 1.068493 | 3.11999956 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 131 | 2.07e-35 | NR | XP_024500476.1 | 34506 | g7090 | i0 | 73.3 | 5.26027397260274 | 86 | 23 | 88.4 | 0 | 6 | 263 | 171 | 256 | XP_024500476.1 40S ribosomal protein S4 [Strongyloides ratti] | diamond | 1536 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 30326008 | 30326008 | PRJNA1215813_P_NODE_4792_length_350_cov_4.122744_g4712_i0 | PRJNA1215813 | 4792 | 350 | 4.122744 | 14.429604 | Ancylostoma caninum | 29170 | Nematoda | Nematoda | 46.6 | 0.0016 | NR | RCN41815.1 | 29170 | g4712 | i0 | 44 | 0.857142857142857 | 100 | 53 | 85.7 | 1 | 51 | 350 | 20 | 116 | RCN41815.1 hypothetical protein ANCCAN_12244 [Ancylostoma caninum] | diamond | 300 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma caninum | |
| 30704531 | 30704531 | PRJNA1215813_P_NODE_6034_length_317_cov_1.918033_g5954_i0 | PRJNA1215813 | 6034 | 317 | 1.918033 | 6.08016461 | Heterodera trifolii | 157864 | Nematoda | Nematoda | 58.9 | 7.48e-8 | NR | KAL3114088.1 | 157864 | g5954 | i0 | 55.8 | 1.98738170347003 | 52 | 19 | 47.3 | 2 | 165 | 16 | 6 | 55 | KAL3114088.1 hypothetical protein niasHT_010902 [Heterodera trifolii] | diamond | 630 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera trifolii | |
| 30755057 | 30755057 | PRJNA1215813_P_NODE_9354_length_253_cov_0.866667_g9274_i0 | PRJNA1215813 | 9354 | 253 | 0.866667 | 2.19266751 | Metazoa | 33208 | Nematoda | Nematoda | 78.6 | 7.46e-17 | NR | KHN75539.1 | 6265 | g9274 | i0 | 80.4 | 91.7786561264822 | 46 | 9 | 54.5 | 0 | 1 | 138 | 46 | 91 | KHN75539.1 60S ribosomal protein L39 [Toxocara canis] | diamond | 23220 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 31368516 | 31368516 | PRJNA1215813_P_NODE_12056_length_243_cov_1.823529_g11976_i0 | PRJNA1215813 | 12056 | 243 | 1.823529 | 4.43117547 | Aphelenchoides avenae | 70226 | Nematoda | Nematoda | 64.3 | 2.06e-11 | NR | KAH7730545.1 | 70226 | g11976 | i0 | 45.8 | 10.1604938271605 | 72 | 37 | 86.4 | 1 | 223 | 14 | 10 | 81 | KAH7730545.1 hypothetical protein AAVH_01593 [Aphelenchoides avenae] | diamond | 2469 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 31861372 | 31861372 | PRJNA1215813_P_NODE_9437_length_253_cov_0.866667_g9357_i0 | PRJNA1215813 | 9437 | 253 | 0.866667 | 2.19266751 | Pristionchus | 54125 | Nematoda | Nematoda | 99.8 | 3.84e-22 | NR | KAF8362053.1 | 54126 | g9357 | i0 | 56 | 3.98418972332016 | 84 | 32 | 99.6 | 1 | 2 | 253 | 563 | 641 | KAF8362053.1 hypothetical protein PRIPAC_88976 [Pristionchus pacificus] | diamond | 1008 | 99.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 32178114 | 32178114 | PRJNA1215813_P_NODE_8298_length_272_cov_1.065327_g8218_i0 | PRJNA1215813 | 8298 | 272 | 1.065327 | 2.89768944 | Rhabditida | 6236 | Nematoda | Nematoda | 54.7 | 3.24e-6 | NR | VDD88345.1 | 51028 | g8218 | i0 | 36.5 | 2.44852941176471 | 74 | 44 | 79.4 | 2 | 6 | 221 | 298 | 370 | VDD88345.1 unnamed protein product [Enterobius vermicularis] | diamond | 666 | 55.1 | 0.992740471869329 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Oxyuridae | Enterobius | Enterobius vermicularis | |
| 32601954 | 32601954 | PRJNA1215813_P_NODE_6680_length_303_cov_1.356522_g6600_i0 | PRJNA1215813 | 6680 | 303 | 1.356522 | 4.11026166 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 44.3 | 0.0219 | NR | CAK5074489.1 | 390850 | g6600 | i0 | 30.1 | 1.7029702970297 | 93 | 48 | 75.2 | 2 | 1 | 228 | 508 | 600 | CAK5074489.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 516 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 32715101 | 32715101 | PRJNA1215813_P_NODE_7800_length_281_cov_1.500000_g7720_i0 | PRJNA1215813 | 7800 | 281 | 1.5 | 4.215 | Opisthokonta | 33154 | Nematoda | Nematoda | 99 | 5.409999999999999e-23 | NR | XP_064059350.1 | 51031 | g7720 | i0 | 48.4 | 6.95017793594306 | 93 | 46 | 99.3 | 1 | 279 | 1 | 142 | 232 | XP_064059350.1 hypothetical protein RB195_013581 [Necator americanus] | diamond | 1953 | 100 | 0.99 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus |
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);;