contig_metadata
13 rows where bioproject = "PRJNA498309", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3031947 | 3031947 | PRJNA498309_P_NODE_51983_length_366_cov_3.273556_g49835_i0 | PRJNA498309 | 51983 | 366 | 3.273556 | 11.98121496 | Nematoda environmental sample | 554024 | Nematoda | Nematoda | 529 | 1.3199999999999996e-145 | NTclustered | gi|1199928069|gb|KY822600.1| | 554024 | g49835 | i0 | 96.061 | 90.2213114754098 | 330 | 3 | 90 | 1 | 23 | 352 | 25 | 344 | Nematoda environmental sample clone OTUNR113 18S ribosomal RNA gene, partial sequence | blastn | 33021 | 529 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Nematoda environmental sample | |||||
| 5585115 | 5585115 | PRJNA498309_P_NODE_88765_length_223_cov_4.069892_g86616_i0 | PRJNA498309 | 88765 | 223 | 4.069892 | 9.07585916 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.02 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g86616 | i0 | 100 | 0.125560538116592 | 28 | 0 | 13 | 0 | 196 | 223 | 53 | 26 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 9410216 | 9410216 | PRJNA498309_S_NODE_26728_length_343_cov_9.094156_g24560_i0 | PRJNA498309 | 26728 | 343 | 9.094156 | 31.19295508 | Pristionchus pacificus | 54126 | Nematoda | Nematoda | 139 | 2.42e-28 | NTclustered | gi|256861442|gb|GQ422181.1| | 54126 | g24560 | i0 | 81.356 | 2.2069970845481 | 177 | 27 | 51 | 6 | 134 | 307 | 531 | 358 | Pristionchus pacificus large subunit ribosomal protein 9 (rpl-9) mRNA, partial cds | blastn | 757 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 10684048 | 10684048 | PRJNA498309_P_NODE_22329_length_612_cov_11.106087_g20458_i0 | PRJNA498309 | 22329 | 612 | 11.106087 | 67.96925244 | Acrostichus sp. RS5083 | 669107 | Nematoda | Nematoda | 874 | 0 | NTclustered | gi|410992296|gb|JX163971.1| | 669107 | g20458 | i0 | 93.825 | 87.2630718954248 | 583 | 32 | 95 | 4 | 22 | 602 | 1597 | 2177 | Acrostichus sp. RS5083 28S ribosomal RNA gene, partial sequence | blastn | 53405 | 874 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Acrostichus | Acrostichus sp. RS5083 | |
| 11312479 | 11312479 | PRJNA498309_P_NODE_99589_length_195_cov_1.708861_g97440_i0 | PRJNA498309 | 99589 | 195 | 1.708861 | 3.33227895 | Rhabditida | 6236 | Nematoda | Nematoda | 84.2 | 5.97e-12 | NTclustered | gi|256861442|gb|GQ422181.1| | 54126 | g97440 | i0 | 96.078 | 1.22051282051282 | 51 | 2 | 26 | 0 | 10 | 60 | 481 | 531 | Pristionchus pacificus large subunit ribosomal protein 9 (rpl-9) mRNA, partial cds | blastn | 238 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 11959778 | 11959778 | PRJNA498309_P_NODE_58270_length_335_cov_3.993289_g56122_i0 | PRJNA498309 | 58270 | 335 | 3.993289 | 13.37751815 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.032 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g56122 | i0 | 100 | 0.0835820895522388 | 28 | 0 | 8 | 0 | 1 | 28 | 25 | 52 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 19606009 | 19606009 | PRJNA498309_P_NODE_108516_length_175_cov_54.768116_g106367_i0 | PRJNA498309 | 108516 | 175 | 54.768116 | 95.844203 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.015 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g106367 | i0 | 100 | 0.16 | 28 | 0 | 16 | 0 | 148 | 175 | 52 | 25 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 22157712 | 22157712 | PRJNA498309_P_NODE_58438_length_334_cov_13.973064_g56290_i0 | PRJNA498309 | 58438 | 334 | 13.973064 | 46.67003376 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.031 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g56290 | i0 | 100 | 0.0838323353293413 | 28 | 0 | 8 | 0 | 307 | 334 | 52 | 25 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 26697095 | 26697095 | PRJNA498309_P_NODE_99441_length_195_cov_2.544304_g97292_i0 | PRJNA498309 | 99441 | 195 | 2.544304 | 4.9613928 | Dracunculus medinensis | 318479 | Nematoda | Nematoda | 46.6 | 8.64e-4 | NR | VDN56879.1 | 318479 | g97292 | i0 | 43.9 | 2.01538461538462 | 41 | 23 | 63.1 | 0 | 11 | 133 | 409 | 449 | VDN56879.1 unnamed protein product, partial [Dracunculus medinensis] | diamond | 393 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Dracunculidae | Dracunculus | Dracunculus medinensis | |
| 30298634 | 30298634 | PRJNA498309_P_NODE_100172_length_193_cov_23.397436_g98023_i0 | PRJNA498309 | 100172 | 193 | 23.397436 | 45.15705148 | Wuchereria bancrofti | 6293 | Nematoda | Nematoda | 64.7 | 6.12e-11 | NR | VDM13183.1 | 6293 | g98023 | i0 | 57.1 | 0.761658031088083 | 49 | 21 | 76.2 | 0 | 169 | 23 | 126 | 174 | VDM13183.1 unnamed protein product [Wuchereria bancrofti] | diamond | 147 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 31546445 | 31546445 | PRJNA498309_P_NODE_13276_length_815_cov_7.830334_g11692_i0 | PRJNA498309 | 13276 | 815 | 7.830334 | 63.8172221 | Rhabditida | 6236 | Nematoda | Nematoda | 305 | 4.32e-100 | NR | KAK5969630.1 | 6319 | g11692 | i0 | 66.5 | 5.25276073619632 | 239 | 79 | 88 | 1 | 793 | 77 | 81 | 318 | KAK5969630.1 hypothetical protein GCK32_013408 [Trichostrongylus colubriformis] | diamond | 4281 | 307 | 0.993485342019544 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Trichostrongylus | Trichostrongylus colubriformis | |
| 31815398 | 31815398 | PRJNA498309_P_NODE_21017_length_632_cov_6.961345_g19173_i0 | PRJNA498309 | 21017 | 632 | 6.961345 | 43.9957004 | Toxocara canis | 6265 | Nematoda | Nematoda | 47.8 | 0.0216 | NR | VDM37845.1 | 6265 | g19173 | i0 | 52 | 0.693037974683544 | 50 | 23 | 23.7 | 1 | 598 | 449 | 41 | 89 | VDM37845.1 unnamed protein product [Toxocara canis] | diamond | 438 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 31941802 | 31941802 | PRJNA498309_P_NODE_84037_length_237_cov_8.410000_g81888_i0 | PRJNA498309 | 84037 | 237 | 8.41 | 19.9317 | Brugia timori | 42155 | Nematoda | Nematoda | 43.9 | 0.00341 | NR | VDO07295.1 | 42155 | g81888 | i0 | 39.4 | 1.26582278481013 | 66 | 31 | 83.5 | 1 | 29 | 226 | 48 | 104 | VDO07295.1 unnamed protein product [Brugia timori] | diamond | 300 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia timori |
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);;