contig_metadata
11 rows where bioproject = "PRJNA833575" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 824649 | 824649 | PRJNA833575_P_NODE_7241_length_528_cov_2.749455_g7104_i0 | PRJNA833575 | 7241 | 528 | 2.749455 | 14.5171224 | Rhabditida | 6236 | Nematoda | Nematoda | 293 | 3.8099999999999994e-99 | NR | NP_506749.1 | 6239 | g7104 | i0 | 79.1 | 19.6420454545455 | 172 | 35 | 97.7 | 1 | 519 | 4 | 1 | 171 | NP_506749.1 Peptidyl-prolyl cis-trans isomerase 7 [Caenorhabditis elegans] | diamond | 10371 | 293 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 5927643 | 5927643 | PRJNA833575_P_NODE_41945_length_231_cov_0.888889_g41808_i0 | PRJNA833575 | 41945 | 231 | 0.888889 | 2.05333359 | Brugia pahangi | 6280 | Nematoda | Nematoda | 77.8 | 1.37e-14 | NR | VDN93748.1 | 6280 | g41808 | i0 | 62.9 | 0.909090909090909 | 70 | 25 | 89.6 | 1 | 229 | 23 | 363 | 432 | VDN93748.1 unnamed protein product [Brugia pahangi] | diamond | 210 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia pahangi | |
| 16127018 | 16127018 | PRJNA833575_P_NODE_36373_length_243_cov_1.241379_g36236_i0 | PRJNA833575 | 36373 | 243 | 1.241379 | 3.01655097 | Pristionchus sp. 15 RS5229 | 452809 | Nematoda | Nematoda | 167 | 7.5e-37 | NTclustered | gi|150984457|gb|EF634871.1| | 452809 | g36236 | i0 | 82.796 | 24.7448559670782 | 186 | 32 | 77 | 0 | 54 | 239 | 392 | 207 | Pristionchus sp. 15 RS5229 small subunit ribosomal protein 8 (rps-8) mRNA, partial cds | blastn | 6013 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 15 RS5229 | |
| 25455616 | 25455616 | PRJNA833575_P_NODE_36720_length_241_cov_1.720930_g36583_i0 | PRJNA833575 | 36720 | 241 | 1.72093 | 4.1474413 | Rhabditida | 6236 | Nematoda | Nematoda | 110 | 2.57e-29 | NR | EPB69018.1 | 53326 | g36583 | i0 | 72.2 | 4.91701244813278 | 79 | 22 | 98.3 | 0 | 237 | 1 | 12 | 90 | EPB69018.1 putative ribosomal protein L22 [Ancylostoma ceylanicum] | diamond | 1185 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma ceylanicum | |
| 26991094 | 26991094 | PRJNA833575_P_NODE_15282_length_374_cov_2.970492_g15145_i0 | PRJNA833575 | 15282 | 374 | 2.970492 | 11.10964008 | Mesorhabditis belari | 2138241 | Nematoda | Nematoda | 58.5 | 5.76e-8 | NR | CAJ0934453.1 | 2138241 | g15145 | i0 | 33.3 | 1.86096256684492 | 117 | 75 | 91.4 | 2 | 346 | 5 | 19 | 135 | CAJ0934453.1 unnamed protein product, partial [Mesorhabditis belari] | diamond | 696 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis belari | |
| 28822844 | 28822844 | PRJNA833575_P_NODE_44248_length_228_cov_1.672956_g44111_i0 | PRJNA833575 | 44248 | 228 | 1.672956 | 3.81433968 | Aphelenchoides fujianensis | 1052528 | Nematoda | Nematoda | 63.2 | 2.01e-9 | NR | KAI6238382.1 | 1052528 | g44111 | i0 | 54.1 | 1.60526315789474 | 61 | 28 | 80.3 | 0 | 183 | 1 | 226 | 286 | KAI6238382.1 Sorting nexin-2 [Aphelenchoides fujianensis] | diamond | 366 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides fujianensis | |
| 28886135 | 28886135 | PRJNA833575_P_NODE_41428_length_232_cov_0.883436_g41291_i0 | PRJNA833575 | 41428 | 232 | 0.883436 | 2.04957152 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 54.3 | 2.78e-6 | NR | GMT23791.1 | 1538716 | g41291 | i0 | 47.7 | 0.568965517241379 | 44 | 23 | 56.9 | 0 | 205 | 74 | 623 | 666 | GMT23791.1 hypothetical protein PFISCL1PPCAC_15088 [Pristionchus fissidentatus] | diamond | 132 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 28958147 | 28958147 | PRJNA833575_P_NODE_43448_length_229_cov_1.350000_g43311_i0 | PRJNA833575 | 43448 | 229 | 1.35 | 3.0915 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 80.1 | 9.3e-16 | NR | OZC05795.1 | 387005 | g43311 | i0 | 90 | 8.51528384279476 | 40 | 4 | 52.4 | 0 | 224 | 105 | 144 | 183 | OZC05795.1 hypothetical protein X798_07230 [Onchocerca flexuosa] | diamond | 1950 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Onchocerca | Onchocerca flexuosa | |
| 30086139 | 30086139 | PRJNA833575_P_NODE_34932_length_249_cov_2.900000_g34795_i0 | PRJNA833575 | 34932 | 249 | 2.9 | 7.221 | Bursaphelenchus okinawaensis | 465554 | Nematoda | Nematoda | 114 | 6.96e-28 | NR | CAD5224064.1 | 465554 | g34795 | i0 | 62.2 | 1.95180722891566 | 82 | 31 | 98.8 | 0 | 247 | 2 | 12 | 93 | CAD5224064.1 unnamed protein product [Bursaphelenchus okinawaensis] | diamond | 486 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus okinawaensis | |
| 31856190 | 31856190 | PRJNA833575_P_NODE_33777_length_254_cov_1.556757_g33640_i0 | PRJNA833575 | 33777 | 254 | 1.556757 | 3.95416278 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 67.8 | 6.15e-11 | NR | PAV62741.1 | 2018661 | g33640 | i0 | 47.6 | 2.06692913385827 | 84 | 42 | 99.2 | 2 | 252 | 1 | 160 | 241 | PAV62741.1 hypothetical protein WR25_25848 [Diploscapter pachys] | diamond | 525 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 31991259 | 31991259 | PRJNA833575_P_NODE_41078_length_232_cov_0.883436_g40941_i0 | PRJNA833575 | 41078 | 232 | 0.883436 | 2.04957152 | Opisthokonta | 33154 | Nematoda | Nematoda | 112 | 4.05e-30 | NR | KAK6031705.1 | 6317 | g40941 | i0 | 70.1 | 5.92241379310345 | 77 | 23 | 99.6 | 0 | 231 | 1 | 11 | 87 | KAK6031705.1 ribosomal protein L6 [Ostertagia ostertagi] | diamond | 1374 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Ostertagia | Ostertagia ostertagi |
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);;