contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA715462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3256690 | 3256690 | PRJNA715462_P_NODE_15523_length_491_cov_26.504785_g14727_i0 | PRJNA715462 | 15523 | 491 | 26.504785 | 130.13849435 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 292 | 2.5899999999999993e-74 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g14727 | i0 | 81.492 | 4.59470468431772 | 362 | 61 | 73 | 6 | 69 | 427 | 395 | 37 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 2256 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 3256929 | 3256929 | PRJNA715462_P_NODE_24763_length_363_cov_1.551724_g23967_i0 | PRJNA715462 | 24763 | 363 | 1.551724 | 5.63275812 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 220 | 8.92e-53 | NTclustered | gi|3217630|emb|AL023815.1| | 6239 | g23967 | i0 | 78.226 | 43.9504132231405 | 372 | 61 | 99 | 18 | 1 | 362 | 5784 | 6145 | Caenorhabditis elegans Fosmid H28O16, complete sequence | blastn | 15954 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 4534775 | 4534775 | PRJNA715462_P_NODE_64524_length_243_cov_1.764706_g63728_i0 | PRJNA715462 | 64524 | 243 | 1.764706 | 4.28823558 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 150 | 7.55e-32 | NTclustered | gi|374718480|gb|JF326458.1| | 174720 | g63728 | i0 | 80.729 | 64.4814814814815 | 192 | 37 | 79 | 0 | 1 | 192 | 918 | 727 | Strongyloides papillosus eukaryotic translation elongation factor a alpha mRNA, complete cds | blastn | 15669 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 4534931 | 4534931 | PRJNA715462_P_NODE_8344_length_772_cov_1.836910_g7613_i0 | PRJNA715462 | 8344 | 772 | 1.83691 | 14.1809452 | Oscheius tipulae | 141969 | Nematoda | Nematoda | 320 | 1.9199999999999998e-82 | NTclustered | gi|62866514|gb|AY928339.1| | 141969 | g7613 | i0 | 84.953 | 41.7888601036269 | 319 | 44 | 41 | 4 | 2 | 318 | 1080 | 1396 | Oscheius tipulae clone pA1 eukaryotic translation elongation factor 1A (eft-2) mRNA, complete cds | blastn | 32261 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Oscheius | Oscheius tipulae | |
| 9634026 | 9634026 | PRJNA715462_P_NODE_20628_length_406_cov_2.882883_g19832_i0 | PRJNA715462 | 20628 | 406 | 2.882883 | 11.70450498 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 198 | 4.73e-46 | NTclustered | gi|2445357699|ref|XM_003108803.2| | 31234 | g19832 | i0 | 82.883 | 2.45812807881773 | 222 | 36 | 54 | 2 | 86 | 306 | 61 | 281 | Caenorhabditis remanei uncharacterized protein (GCK72_005843), partial mRNA | blastn | 998 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 9634071 | 9634071 | PRJNA715462_P_NODE_22408_length_386_cov_0.955272_g21612_i0 | PRJNA715462 | 22408 | 386 | 0.955272 | 3.68734992 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.037 | NTclustered | gi|690018612|emb|LM525850.1| | 174720 | g21612 | i0 | 100 | 0.0725388601036269 | 28 | 0 | 7 | 0 | 342 | 369 | 31163 | 31190 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000228 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 9634351 | 9634351 | PRJNA715462_P_NODE_34648_length_300_cov_1.709251_g33852_i0 | PRJNA715462 | 34648 | 300 | 1.709251 | 5.127753 | Leptojacobus dorci | 1463561 | Nematoda | Nematoda | 254 | 7.13e-63 | NTclustered | gi|675119105|gb|KJ877432.1| | 1463561 | g33852 | i0 | 83.955 | 30.91 | 268 | 39 | 89 | 4 | 35 | 300 | 443 | 178 | Leptojacobus dorci strain RS9005 small subunit ribosomal protein 14 (rps-14) mRNA, partial cds | blastn | 9273 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Leptojacobus | Leptojacobus dorci | |
| 9634630 | 9634630 | PRJNA715462_P_NODE_48188_length_257_cov_1.434783_g47392_i0 | PRJNA715462 | 48188 | 257 | 1.434783 | 3.68739231 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|1376157371|ref|XM_024646132.1| | 34506 | g47392 | i0 | 100 | 0.11284046692607 | 29 | 0 | 11 | 0 | 141 | 169 | 668 | 640 | Strongyloides ratti Protein of unknown function DUF273 family-containing protein (SRAE_0000026500), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 10909529 | 10909529 | PRJNA715462_P_NODE_20009_length_414_cov_2.302053_g19213_i0 | PRJNA715462 | 20009 | 414 | 2.302053 | 9.53049942 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 340 | 7.589999999999999e-89 | NTclustered | gi|2445392243|ref|XM_003102588.2| | 31234 | g19213 | i0 | 82.487 | 2.14492753623188 | 394 | 64 | 94 | 4 | 25 | 414 | 1 | 393 | Caenorhabditis remanei uncharacterized protein (GCK72_023426), partial mRNA | blastn | 888 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 12185177 | 12185177 | PRJNA715462_P_NODE_36590_length_291_cov_1.766055_g35794_i0 | PRJNA715462 | 36590 | 291 | 1.766055 | 5.13922005 | Diploscapter coronatus | 288516 | Nematoda | Nematoda | 418 | 2.3099999999999995e-112 | NTclustered | gi|1211677252|ref|NC_035106.1| | 288516 | g35794 | i0 | 93.286 | 96.6116838487973 | 283 | 19 | 97 | 0 | 1 | 283 | 7644 | 7926 | Diploscapter coronatus mitochondrial DNA, complete genome, strain: PDL0010 | blastn | 28114 | 418 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter coronatus | |
| 12185346 | 12185346 | PRJNA715462_P_NODE_44430_length_268_cov_1.107692_g43634_i0 | PRJNA715462 | 44430 | 268 | 1.107692 | 2.96861456 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 202 | 2.3e-47 | NTclustered | gi|268531849|ref|XM_002631007.1| | 6238 | g43634 | i0 | 80.769 | 3.66044776119403 | 260 | 48 | 97 | 2 | 8 | 266 | 282 | 540 | Caenorhabditis briggsae Protein CBR-LEC-1 (Cbr-lec-1), partial mRNA | blastn | 981 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 12185487 | 12185487 | PRJNA715462_P_NODE_51630_length_251_cov_0.865169_g50834_i0 | PRJNA715462 | 51630 | 251 | 0.865169 | 2.17157419 | Rhabditis sp. DW-2012 | 1264781 | Nematoda | Nematoda | 248 | 2.7e-61 | NTclustered | gi|426270576|gb|JQ713952.1| | 1264781 | g50834 | i0 | 85.897 | 94.6573705179283 | 234 | 32 | 93 | 1 | 2 | 234 | 939 | 706 | Rhabditis sp. DW-2012 isolate KS594 unc-54 gene, partial cds | blastn | 23759 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Rhabditis | Rhabditis sp. DW-2012 | |
| 12671837 | 12671837 | PRJNA715462_P_NODE_35470_length_296_cov_1.618834_g34674_i0 | PRJNA715462 | 35470 | 296 | 1.618834 | 4.79174864 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 303 | 6.87e-78 | NTclustered | gi|687022643|emb|LM525557.1| | 174720 | g34674 | i0 | 85.324 | 93.6283783783784 | 293 | 43 | 99 | 0 | 1 | 293 | 537948 | 538240 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000003 | blastn | 27714 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 16008206 | 16008206 | PRJNA715462_P_NODE_26373_length_350_cov_1.111913_g25577_i0 | PRJNA715462 | 26373 | 350 | 1.111913 | 3.8916955 | Diploscapter sp. | 55800 | Nematoda | Nematoda | 545 | 1.24e-150 | NTclustered | gi|1938289465|gb|MW300616.1| | 55800 | g25577 | i0 | 95.087 | 99.2942857142857 | 346 | 17 | 99 | 0 | 1 | 346 | 166 | 511 | Diploscapter sp. voucher AL-CMPST cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial | blastn | 34753 | 545 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter sp. | |
| 16009049 | 16009049 | PRJNA715462_P_NODE_67953_length_241_cov_1.928571_g67157_i0 | PRJNA715462 | 67953 | 241 | 1.928571 | 4.64785611 | Loa loa | 7209 | Nematoda | Nematoda | 65.8 | 2.79e-6 | NTclustered | gi|1158596406|ref|XM_020450169.1| | 7209 | g67157 | i0 | 90 | 0.605809128630705 | 50 | 5 | 61 | 0 | 110 | 159 | 1875 | 1826 | Loa loa ZAG-1 protein mRNA | blastn | 146 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Loa | Loa loa | |
| 19832211 | 19832211 | PRJNA715462_P_NODE_13756_length_535_cov_21.880952_g12962_i0 | PRJNA715462 | 13756 | 535 | 21.880952 | 117.0630932 | Pristionchus hoplostomus | 1355913 | Nematoda | Nematoda | 167 | 1.7999999999999998e-36 | NTclustered | gi|524845312|gb|KC819366.1| | 1355913 | g12962 | i0 | 81.166 | 23.0841121495327 | 223 | 28 | 40 | 11 | 73 | 288 | 49 | 264 | Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds | blastn | 12350 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus hoplostomus | |
| 23658997 | 23658997 | PRJNA715462_P_NODE_40979_length_278_cov_1.346341_g40183_i0 | PRJNA715462 | 40979 | 278 | 1.346341 | 3.74282798 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 102 | 2.51e-17 | NTclustered | gi|687866211|emb|LK928092.1| | 6239 | g40183 | i0 | 90.789 | 0.546762589928058 | 76 | 7 | 27 | 0 | 155 | 230 | 46346 | 46421 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000463 | blastn | 152 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 23659517 | 23659517 | PRJNA715462_P_NODE_68199_length_241_cov_1.375000_g67403_i0 | PRJNA715462 | 68199 | 241 | 1.375 | 3.31375 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 261 | 3.31e-65 | NTclustered | gi|268577392|ref|XM_002643633.1| | 6238 | g67403 | i0 | 86.25 | 4.94605809128631 | 240 | 33 | 99 | 0 | 2 | 241 | 345 | 106 | Caenorhabditis briggsae Protein CBR-MLC-2.2 (Cbr-mlc-2.2), partial mRNA | blastn | 1192 | 261 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae |
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);;