contig_metadata
7 rows where bioproject = "PRJNA554794", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6227189 | 6227189 | PRJNA554794_P_NODE_21505_length_179_cov_1.553846_g17576_i0 | PRJNA554794 | 21505 | 179 | 1.553846 | 2.78138434 | Rhabditida | 6236 | Nematoda | Nematoda | 75.1 | 7.71e-16 | NR | EPB69018.1 | 53326 | g17576 | i0 | 69.5 | 4.94413407821229 | 59 | 18 | 98.9 | 0 | 179 | 3 | 3 | 61 | EPB69018.1 putative ribosomal protein L22 [Ancylostoma ceylanicum] | diamond | 885 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma ceylanicum | |
| 22197845 | 22197845 | PRJNA554794_P_NODE_9178_length_459_cov_0.787805_g5385_i0 | PRJNA554794 | 9178 | 459 | 0.787805 | 3.61602495 | Metazoa | 33208 | Nematoda | Nematoda | 214 | 1.6199999999999998e-67 | NR | KAK6031123.1 | 6317 | g5385 | i0 | 77.9 | 18.2679738562091 | 136 | 30 | 88.9 | 0 | 52 | 459 | 46 | 181 | KAK6031123.1 ribosomal protein L5 [Ostertagia ostertagi] | diamond | 8385 | 215 | 0.995348837209302 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Ostertagia | Ostertagia ostertagi | |
| 27362978 | 27362978 | PRJNA554794_P_NODE_11783_length_299_cov_0.744000_g7854_i0 | PRJNA554794 | 11783 | 299 | 0.744 | 2.22456 | Aphelenchoides avenae | 70226 | Nematoda | Nematoda | 65.1 | 9.59e-10 | NR | KAH7723827.1 | 70226 | g7854 | i0 | 44.9 | 1.59531772575251 | 78 | 39 | 76.3 | 3 | 234 | 7 | 31 | 106 | KAH7723827.1 cathepsin B-like cysteine protease 2 [Aphelenchoides avenae] | diamond | 477 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides avenae | |
| 27913908 | 27913908 | PRJNA554794_P_NODE_23785_length_163_cov_0.956140_g19856_i0 | PRJNA554794 | 23785 | 163 | 0.95614 | 1.5585082 | Rhabditida | 6236 | Nematoda | Nematoda | 84 | 1.43e-17 | NR | KAE9419388.1 | 6313 | g19856 | i0 | 68.5 | 7.95092024539877 | 54 | 17 | 99.4 | 0 | 2 | 163 | 178 | 231 | KAE9419388.1 hypothetical protein Angca_003340 [Angiostrongylus cantonensis] | diamond | 1296 | 84.7 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Angiostrongylus | Angiostrongylus cantonensis | |
| 28387613 | 28387613 | PRJNA554794_P_NODE_11926_length_293_cov_1.344262_g7997_i0 | PRJNA554794 | 11926 | 293 | 1.344262 | 3.93868766 | Rhabditida | 6236 | Nematoda | Nematoda | 140 | 2.48e-36 | NR | KHN74648.1 | 6265 | g7997 | i0 | 68 | 5.95904436860068 | 97 | 30 | 99.3 | 1 | 3 | 293 | 4 | 99 | KHN74648.1 40S ribosomal protein S3a [Toxocara canis] | diamond | 1746 | 141 | 0.99290780141844 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 30061038 | 30061038 | PRJNA554794_P_NODE_13411_length_246_cov_1.431472_g9482_i0 | PRJNA554794 | 13411 | 246 | 1.431472 | 3.52142112 | Opisthokonta | 33154 | Nematoda | Nematoda | 88.6 | 1.47e-19 | NR | CAD5209403.1 | 6326 | g9482 | i0 | 57.7 | 9.80487804878049 | 78 | 33 | 95.1 | 0 | 245 | 12 | 101 | 178 | CAD5209403.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 2412 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 30868062 | 30868062 | PRJNA554794_P_NODE_24814_length_161_cov_0.866071_g20885_i0 | PRJNA554794 | 24814 | 161 | 0.866071 | 1.39437431 | Soboliphyme baturini | 241478 | Nematoda | Nematoda | 81.3 | 4.27e-18 | NR | VDO98973.1 | 241478 | g20885 | i0 | 83 | 0.987577639751553 | 53 | 9 | 98.8 | 0 | 3 | 161 | 18 | 70 | VDO98973.1 unnamed protein product [Soboliphyme baturini] | diamond | 159 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini |
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);;