contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA290839" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27010806 | 27010806 | PRJNA290839_P_NODE_1102_length_251_cov_0.876404_g1081_i0 | PRJNA290839 | 1102 | 251 | 0.876404 | 2.19977404 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 105 | 3.76e-25 | NR | EFP00214.1 | 31234 | g1081 | i0 | 92.6 | 0.645418326693227 | 54 | 4 | 64.5 | 0 | 89 | 250 | 1 | 54 | EFP00214.1 CRE-SRJ-7 protein [Caenorhabditis remanei] | diamond | 162 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 27516559 | 27516559 | PRJNA290839_P_NODE_1283_length_248_cov_0.885714_g1262_i0 | PRJNA290839 | 1283 | 248 | 0.885714 | 2.19657072 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 44.3 | 0.0115 | NR | XP_024499784.1 | 34506 | g1262 | i0 | 32.9 | 1.33064516129032 | 73 | 46 | 84.7 | 1 | 237 | 28 | 838 | 910 | XP_024499784.1 Insulin-like growth factor binding protein,N-terminal domain-containing protein [Strongyloides ratti] | diamond | 330 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 27611396 | 27611396 | PRJNA290839_P_NODE_604_length_330_cov_1.042802_g583_i0 | PRJNA290839 | 604 | 330 | 1.042802 | 3.4412466 | Pristionchus mayeri | 1317129 | Nematoda | Nematoda | 86.7 | 2.38e-17 | NR | GMR59452.1 | 1317129 | g583 | i0 | 38.5 | 0.990909090909091 | 109 | 67 | 99.1 | 0 | 2 | 328 | 34 | 142 | GMR59452.1 hypothetical protein PMAYCL1PPCAC_29647, partial [Pristionchus mayeri] | diamond | 327 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus mayeri | |
| 29789735 | 29789735 | PRJNA290839_P_NODE_1511_length_244_cov_0.912281_g1490_i0 | PRJNA290839 | 1511 | 244 | 0.912281 | 2.22596564 | Caenorhabditis nigoni | 1611254 | Nematoda | Nematoda | 95.9 | 7.56e-21 | NR | PIC14317.1 | 1611254 | g1490 | i0 | 96.2 | 0.639344262295082 | 52 | 2 | 63.9 | 0 | 244 | 89 | 49 | 100 | PIC14317.1 hypothetical protein B9Z55_027263 [Caenorhabditis nigoni] | diamond | 156 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis nigoni | |
| 30516504 | 30516504 | PRJNA290839_P_NODE_1013_length_253_cov_1.200000_g992_i0 | PRJNA290839 | 1013 | 253 | 1.2 | 3.036 | Caenorhabditis nigoni | 1611254 | Nematoda | Nematoda | 65.9 | 3.17e-10 | NR | PIC12202.1 | 1611254 | g992 | i0 | 88.9 | 0.853754940711462 | 36 | 4 | 42.7 | 0 | 145 | 252 | 1147 | 1182 | PIC12202.1 hypothetical protein B9Z55_028556 [Caenorhabditis nigoni] | diamond | 216 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis nigoni | |
| 30944998 | 30944998 | PRJNA290839_P_NODE_354_length_449_cov_1.015957_g333_i0 | PRJNA290839 | 354 | 449 | 1.015957 | 4.56164693 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 166 | 9.43e-45 | NR | VDN50986.1 | 318479 | g333 | i0 | 51 | 6.80178173719376 | 147 | 71 | 98.2 | 1 | 448 | 8 | 557 | 702 | VDN50986.1 unnamed protein product [Dracunculus medinensis] | diamond | 3054 | 167 | 0.994011976047904 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Dracunculidae | Dracunculus | Dracunculus medinensis | |
| 30976618 | 30976618 | PRJNA290839_P_NODE_1594_length_243_cov_0.894118_g1573_i0 | PRJNA290839 | 1594 | 243 | 0.894118 | 2.17270674 | Opisthokonta | 33154 | Nematoda | Nematoda | 84 | 1.12e-16 | NR | KAI6192179.1 | 293665 | g1573 | i0 | 51.3 | 5.11111111111111 | 78 | 35 | 92.6 | 1 | 17 | 241 | 136 | 213 | KAI6192179.1 Endo-1,3(4)-beta-glucanase [Aphelenchoides bicaudatus] | diamond | 1242 | 84.7 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides bicaudatus | |
| 31956647 | 31956647 | PRJNA290839_P_NODE_1457_length_245_cov_0.906977_g1436_i0 | PRJNA290839 | 1457 | 245 | 0.906977 | 2.22209365 | Rhabditida | 6236 | Nematoda | Nematoda | 82.8 | 2.98e-16 | NR | MCP9259181.1 | 6287 | g1436 | i0 | 53.1 | 5.73061224489796 | 81 | 36 | 96.7 | 1 | 6 | 242 | 372 | 452 | MCP9259181.1 hypothetical protein [Dirofilaria immitis] | diamond | 1404 | 83.6 | 0.990430622009569 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Dirofilaria | Dirofilaria immitis |
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);;