contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA788929" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 769694 | 769694 | PRJNA788929_P_NODE_6921_length_721_cov_122.435185_g6290_i0 | PRJNA788929 | 6921 | 721 | 122.435185 | 882.75768385 | Metazoa | 33208 | Nematoda | Nematoda | 216 | 2.44e-67 | NR | CAJ0602523.1 | 53992 | g6290 | i0 | 61.1 | 16.1317614424411 | 162 | 63 | 67.4 | 0 | 649 | 164 | 40 | 201 | CAJ0602523.1 unnamed protein product, partial [Cylicocyclus nassatus] | diamond | 11631 | 216 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Cylicocyclus | Cylicocyclus nassatus | |
| 26778239 | 26778239 | PRJNA788929_P_NODE_7601_length_677_cov_85.793046_g6960_i0 | PRJNA788929 | 7601 | 677 | 85.793046 | 580.81892142 | Rhabditida | 6236 | Nematoda | Nematoda | 133 | 6.970000000000001e-36 | NR | KHN79676.1 | 6265 | g6960 | i0 | 51.2 | 4.98966026587888 | 125 | 60 | 55.4 | 1 | 582 | 208 | 9 | 132 | KHN79676.1 40S ribosomal protein S12 [Toxocara canis] | diamond | 3378 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 27306704 | 27306704 | PRJNA788929_P_NODE_8383_length_635_cov_190.258007_g7735_i0 | PRJNA788929 | 8383 | 635 | 190.258007 | 1208.13834445 | Dracunculus medinensis | 318479 | Nematoda | Nematoda | 122 | 8.04e-32 | NR | VDN56922.1 | 318479 | g7735 | i0 | 56.2 | 1.72913385826772 | 121 | 53 | 57.2 | 0 | 558 | 196 | 3 | 123 | VDN56922.1 unnamed protein product [Dracunculus medinensis] | diamond | 1098 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Dracunculidae | Dracunculus | Dracunculus medinensis | |
| 27874912 | 27874912 | PRJNA788929_P_NODE_20885_length_357_cov_2.580986_g20225_i0 | PRJNA788929 | 20885 | 357 | 2.580986 | 9.21412002 | Caenorhabditis auriculariae | 2777116 | Nematoda | Nematoda | 167 | 2.28e-45 | NR | CAD6185005.1 | 2777116 | g20225 | i0 | 78.5 | 1.79831932773109 | 107 | 22 | 89.1 | 1 | 24 | 341 | 654 | 760 | CAD6185005.1 unnamed protein product [Caenorhabditis auriculariae] | diamond | 642 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis auriculariae | |
| 28853570 | 28853570 | PRJNA788929_P_NODE_12788_length_483_cov_1.765854_g12131_i0 | PRJNA788929 | 12788 | 483 | 1.765854 | 8.52907482 | Caenorhabditis auriculariae | 2777116 | Nematoda | Nematoda | 69.7 | 1.48e-10 | NR | CAD6193562.1 | 2777116 | g12131 | i0 | 38.9 | 0.559006211180124 | 90 | 54 | 55.9 | 1 | 63 | 332 | 264 | 352 | CAD6193562.1 unnamed protein product [Caenorhabditis auriculariae] | diamond | 270 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis auriculariae | |
| 29516697 | 29516697 | PRJNA788929_P_NODE_49250_length_203_cov_6.461538_g48589_i0 | PRJNA788929 | 49250 | 203 | 6.461538 | 13.11692214 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 70.9 | 1.39e-13 | NR | KAE9549433.1 | 2598192 | g48589 | i0 | 64.2 | 3.22167487684729 | 53 | 19 | 78.3 | 0 | 11 | 169 | 88 | 140 | KAE9549433.1 hypothetical protein FO519_007346, partial [Halicephalobus sp. NKZ332] | diamond | 654 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 | |
| 30653875 | 30653875 | PRJNA788929_P_NODE_15553_length_425_cov_35.622159_g14894_i0 | PRJNA788929 | 15553 | 425 | 35.622159 | 151.39417575 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 50.4 | 5.19e-4 | NR | CAJ0575544.1 | 96644 | g14894 | i0 | 39.8 | 0.585882352941177 | 83 | 46 | 57.9 | 3 | 18 | 263 | 210 | 289 | CAJ0575544.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 249 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 30852787 | 30852787 | PRJNA788929_P_NODE_26934_length_307_cov_1.316239_g26273_i0 | PRJNA788929 | 26934 | 307 | 1.316239 | 4.04085373 | root | 1 | Root_unresolved | Root_unresolved | 186 | 8.79e-57 | NR | ETN71555.1 | 51031 | g26273 | i0 | 86.3 | 1.99348534201954 | 102 | 14 | 99.7 | 0 | 2 | 307 | 30 | 131 | ETN71555.1 Replication protein [Necator americanus] | diamond | 612 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 31136894 | 31136894 | PRJNA788929_P_NODE_45535_length_226_cov_10.633987_g44874_i0 | PRJNA788929 | 45535 | 226 | 10.633987 | 24.03281062 | root | 1 | Root_unresolved | Root_unresolved | 47.8 | 4.94e-4 | NR | XP_024510682.1 | 34506 | g44874 | i0 | 84.6 | 4.65929203539823 | 26 | 4 | 34.5 | 0 | 136 | 213 | 10 | 35 | XP_024510682.1 Pyruvate dehydrogenase E1 component subunit beta, mitochondrial [Strongyloides ratti] | diamond | 1053 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 31390321 | 31390321 | PRJNA788929_P_NODE_7796_length_668_cov_41.258824_g7154_i0 | PRJNA788929 | 7796 | 668 | 41.258824 | 275.60894432 | Rhabditida | 6236 | Nematoda | Nematoda | 134 | 4.48e-36 | NR | KHN79676.1 | 6265 | g7154 | i0 | 51.2 | 5.16017964071856 | 125 | 60 | 56.1 | 1 | 104 | 478 | 9 | 132 | KHN79676.1 40S ribosomal protein S12 [Toxocara canis] | diamond | 3447 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 31475943 | 31475943 | PRJNA788929_P_NODE_43396_length_237_cov_9.615854_g42735_i0 | PRJNA788929 | 43396 | 237 | 9.615854 | 22.78957398 | Pristionchus entomophagus | 358040 | Nematoda | Nematoda | 42.7 | 0.0351 | NR | GMS92544.1 | 358040 | g42735 | i0 | 45.7 | 0.582278481012658 | 46 | 25 | 58.2 | 0 | 161 | 24 | 147 | 192 | GMS92544.1 hypothetical protein PENTCL1PPCAC_14719, partial [Pristionchus entomophagus] | diamond | 138 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus entomophagus | |
| 32361871 | 32361871 | PRJNA788929_P_NODE_44659_length_231_cov_2.481013_g43998_i0 | PRJNA788929 | 44659 | 231 | 2.481013 | 5.73114003 | Caenorhabditis bovis | 2654633 | Nematoda | Nematoda | 85.9 | 1.93e-17 | NR | CAB3406122.1 | 2654633 | g43998 | i0 | 57.4 | 1.58441558441558 | 61 | 26 | 79.2 | 0 | 49 | 231 | 1 | 61 | CAB3406122.1 unnamed protein product [Caenorhabditis bovis] | diamond | 366 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis bovis | |
| 32371022 | 32371022 | PRJNA788929_P_NODE_15819_length_421_cov_22.204023_g15160_i0 | PRJNA788929 | 15819 | 421 | 22.204023 | 93.47893683 | Metazoa | 33208 | Nematoda | Nematoda | 146 | 9.48e-41 | NR | KHN80245.1 | 6265 | g15160 | i0 | 85.5 | 66.2850356294537 | 76 | 11 | 54.2 | 0 | 398 | 171 | 168 | 243 | KHN80245.1 ADP-ribosylation factor 1-like 2 [Toxocara canis] | diamond | 27906 | 147 | 0.993197278911565 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis |
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);;