contig_metadata
9 rows where bioproject = "PRJNA316313", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14417062 | 14417062 | PRJNA316313_P_NODE_484372_length_150_cov_5.256637_g482986_i0 | PRJNA316313 | 484372 | 150 | 5.256637 | 7.8849555 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 75 | 2.61e-9 | NTclustered | gi|3810720|emb|AL032641.1| | 6239 | g482986 | i0 | 95.652 | 56.44 | 46 | 2 | 37 | 0 | 105 | 150 | 9331 | 9376 | Caenorhabditis elegans YAC Y5F2A, complete sequence | blastn | 8466 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 23339157 | 23339157 | PRJNA316313_P_NODE_327079_length_187_cov_2.006667_g325693_i0 | PRJNA316313 | 327079 | 187 | 2.006667 | 3.75246729 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 141 | 3.32e-29 | NTclustered | gi|687866032|emb|LK927877.1| | 6239 | g325693 | i0 | 100 | 2.03208556149733 | 76 | 0 | 81 | 0 | 112 | 187 | 78254 | 78179 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000051 | blastn | 380 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 24614939 | 24614939 | PRJNA316313_S_NODE_400_length_314_cov_3.480144_g397_i0 | PRJNA316313 | 400 | 314 | 3.480144 | 10.92765216 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 303 | 7.35e-78 | NTclustered | gi|1376144465|ref|XM_024652690.1| | 34506 | g397 | i0 | 85.05 | 96.859872611465 | 301 | 41 | 95 | 4 | 7 | 305 | 330 | 32 | Strongyloides ratti Actin, alpha cardiac muscle 1 (SRAE_2000170700), partial mRNA | blastn | 30414 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 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);;