contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA316313" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27295782 | 27295782 | PRJNA316313_P_NODE_313803_length_187_cov_2.326667_g312417_i0 | PRJNA316313 | 313803 | 187 | 2.326667 | 4.35086729 | Trichinella pseudospiralis | 6337 | Nematoda | Nematoda | 39.7 | 0.0385 | NR | KRY95212.1 | 6337 | g312417 | i0 | 70.8 | 0.385026737967914 | 24 | 7 | 38.5 | 0 | 5 | 76 | 36 | 59 | KRY95212.1 hypothetical protein T4B_14678 [Trichinella pseudospiralis] | diamond | 72 | 39.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella pseudospiralis | |
| 29726844 | 29726844 | PRJNA316313_P_NODE_428910_length_151_cov_4.438596_g427524_i0 | PRJNA316313 | 428910 | 151 | 4.438596 | 6.70227996 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 49.7 | 3.52e-5 | NR | PAV59139.1 | 2018661 | g427524 | i0 | 95.2 | 0.417218543046358 | 21 | 1 | 41.7 | 0 | 2 | 64 | 75 | 95 | PAV59139.1 hypothetical protein WR25_10811 [Diploscapter pachys] | diamond | 63 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 31229140 | 31229140 | PRJNA316313_P_NODE_496775_length_150_cov_3.761062_g495389_i0 | PRJNA316313 | 496775 | 150 | 3.761062 | 5.641593 | root | 1 | Root_unresolved | Root_unresolved | 50.4 | 4.1e-6 | NR | ETN78375.1 | 51031 | g495389 | i0 | 72.4 | 4.64 | 29 | 8 | 58 | 0 | 2 | 88 | 79 | 107 | ETN78375.1 hypothetical protein NECAME_18222 [Necator americanus] | diamond | 696 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 31528367 | 31528367 | PRJNA316313_P_NODE_308796_length_187_cov_2.373333_g307410_i0 | PRJNA316313 | 308796 | 187 | 2.373333 | 4.43813271 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 43.9 | 0.00672 | NR | CAJ0577677.1 | 96644 | g307410 | i0 | 100 | 0.304812834224599 | 19 | 0 | 30.5 | 0 | 74 | 18 | 116 | 134 | CAJ0577677.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 57 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 32509323 | 32509323 | PRJNA316313_P_NODE_422459_length_151_cov_4.780702_g421073_i0 | PRJNA316313 | 422459 | 151 | 4.780702 | 7.21886002 | Heligmosomoides polygyrus | 6339 | Nematoda | Nematoda | 42 | 0.0192 | NR | VDO90088.1 | 6339 | g421073 | i0 | 48.4 | 0.615894039735099 | 31 | 16 | 61.6 | 0 | 145 | 53 | 9 | 39 | VDO90088.1 unnamed protein product [Heligmosomoides polygyrus] | diamond | 93 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heligmosomidae | Heligmosomoides | Heligmosomoides polygyrus | |
| 32526732 | 32526732 | PRJNA316313_S_NODE_1459_length_186_cov_1.275168_g1456_i0 | PRJNA316313 | 1459 | 186 | 1.275168 | 2.37181248 | Caenorhabditis | 6237 | Nematoda | Nematoda | 70.9 | 2.06e-12 | NR | ULT91226.1 | 6238 | g1456 | i0 | 63.5 | 1.67741935483871 | 52 | 19 | 83.9 | 0 | 23 | 178 | 482 | 533 | ULT91226.1 hypothetical protein L3Y34_009079 [Caenorhabditis briggsae] | diamond | 312 | 70.9 | 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);;