contig_metadata
6 rows where bioproject = "PRJNA395690" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10615727 | 10615727 | PRJNA395690_P_NODE_6509_length_315_cov_6.646617_g6357_i0 | PRJNA395690 | 6509 | 315 | 6.646617 | 20.93684355 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 100 | 1.05e-25 | NR | CAD2132787.1 | 390850 | g6357 | i0 | 82.1 | 0.533333333333333 | 56 | 10 | 53.3 | 0 | 284 | 117 | 1 | 56 | CAD2132787.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 168 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 16989229 | 16989229 | PRJNA395690_P_NODE_35514_length_161_cov_1.366071_g35362_i0 | PRJNA395690 | 35514 | 161 | 1.366071 | 2.19937431 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 98.2 | 3.58e-22 | NR | CAJ0582299.1 | 96644 | g35362 | i0 | 82.7 | 5.77639751552795 | 52 | 9 | 96.9 | 0 | 4 | 159 | 210 | 261 | CAJ0582299.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 930 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 27154915 | 27154915 | PRJNA395690_P_NODE_32862_length_163_cov_1.789474_g32710_i0 | PRJNA395690 | 32862 | 163 | 1.789474 | 2.91684262 | Metazoa | 33208 | Nematoda | Nematoda | 44.3 | 0.00369 | NR | EFP13371.1 | 31234 | g32710 | i0 | 41.2 | 4.98773006134969 | 51 | 28 | 90.2 | 1 | 147 | 1 | 271 | 321 | EFP13371.1 CRE-EMB-4 protein [Caenorhabditis remanei] | diamond | 813 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 28197397 | 28197397 | PRJNA395690_P_NODE_22246_length_181_cov_1.545455_g22094_i0 | PRJNA395690 | 22246 | 181 | 1.545455 | 2.79727355 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 85.5 | 2.67e-19 | NR | KAF8372912.1 | 54126 | g22094 | i0 | 66.1 | 2.90055248618785 | 59 | 20 | 97.8 | 0 | 179 | 3 | 33 | 91 | KAF8372912.1 rps-18 [Pristionchus pacificus] | diamond | 525 | 86.3 | 0.990730011587486 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus | |
| 29949058 | 29949058 | PRJNA395690_P_NODE_7331_length_298_cov_1.228916_g7179_i0 | PRJNA395690 | 7331 | 298 | 1.228916 | 3.66216968 | Heterodera trifolii | 157864 | Nematoda | Nematoda | 93.6 | 2.24e-20 | NR | KAL3073343.1 | 157864 | g7179 | i0 | 48.5 | 0.996644295302013 | 99 | 51 | 99.7 | 0 | 298 | 2 | 153 | 251 | KAL3073343.1 hypothetical protein niasHT_038700 [Heterodera trifolii] | diamond | 297 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera trifolii | |
| 31197552 | 31197552 | PRJNA395690_P_NODE_9495_length_264_cov_1.320930_g9343_i0 | PRJNA395690 | 9495 | 264 | 1.32093 | 3.4872552 | Metazoa | 33208 | Nematoda | Nematoda | 47 | 5.94e-4 | NR | KAH7723331.1 | 70226 | g9343 | i0 | 67.6 | 1.51136363636364 | 34 | 11 | 38.6 | 0 | 161 | 262 | 30 | 63 | KAH7723331.1 60S ribosomal protein L23a [Aphelenchoides avenae] | diamond | 399 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae |
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);;