contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJEB11748" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1288062 | 1288062 | PRJEB11748_P_NODE_100502_length_416_cov_20.064789_g98332_i0 | PRJEB11748 | 100502 | 416 | 20.064789 | 83.46952224 | Toxocara canis | 6265 | Nematoda | Nematoda | 135 | 4.21e-34 | NR | KHN73621.1 | 6265 | g98332 | i0 | 88.2 | 3.83653846153846 | 76 | 9 | 54.8 | 0 | 23 | 250 | 472 | 547 | KHN73621.1 ATP synthase subunit beta, mitochondrial [Toxocara canis] | diamond | 1596 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 15011663 | 15011663 | PRJEB11748_P_NODE_24352_length_916_cov_16.679532_g22705_i0 | PRJEB11748 | 24352 | 916 | 16.679532 | 152.78451312 | Nematoda | 6231 | Nematoda | Nematoda | 351 | 5.4599999999999985e-115 | NR | KHN79989.1 | 6265 | g22705 | i0 | 65.7 | 1.5 | 230 | 78 | 75 | 1 | 705 | 19 | 171 | 400 | KHN79989.1 Inactive rhomboid protein 1 [Toxocara canis] | diamond | 1374 | 351 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 27538498 | 27538498 | PRJEB11748_P_NODE_214584_length_271_cov_27.952381_g212401_i0 | PRJEB11748 | 214584 | 271 | 27.952381 | 75.75095251 | Mesorhabditis belari | 2138241 | Nematoda | Nematoda | 67.8 | 7.6e-12 | NR | CAJ0960039.1 | 2138241 | g212401 | i0 | 96.4 | 0.309963099630996 | 28 | 1 | 31 | 0 | 81 | 164 | 115 | 142 | CAJ0960039.1 unnamed protein product, partial [Mesorhabditis belari] | diamond | 84 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis belari | |
| 27601853 | 27601853 | PRJEB11748_P_NODE_48604_length_616_cov_21.513514_g46508_i0 | PRJEB11748 | 48604 | 616 | 21.513514 | 132.52324624 | Caenorhabditis auriculariae | 2777116 | Nematoda | Nematoda | 77 | 1.9e-12 | NR | CAD6198734.1 | 2777116 | g46508 | i0 | 41.9 | 1.00811688311688 | 105 | 45 | 51.1 | 1 | 578 | 264 | 766 | 854 | CAD6198734.1 unnamed protein product [Caenorhabditis auriculariae] | diamond | 621 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis auriculariae | |
| 28169914 | 28169914 | PRJEB11748_P_NODE_259646_length_241_cov_2.188889_g257463_i0 | PRJEB11748 | 259646 | 241 | 2.188889 | 5.27522249 | Ancylostoma ceylanicum | 53326 | Nematoda | Nematoda | 139 | 1.0699999999999998e-37 | NR | EPB65693.1 | 53326 | g257463 | i0 | 84.5 | 0.883817427385892 | 71 | 11 | 88.4 | 0 | 6 | 218 | 229 | 299 | EPB65693.1 WD40-like protein, partial [Ancylostoma ceylanicum] | diamond | 213 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma ceylanicum | |
| 28517386 | 28517386 | PRJEB11748_P_NODE_366547_length_189_cov_5.000000_g364364_i0 | PRJEB11748 | 366547 | 189 | 5 | 9.45 | Angiostrongylus costaricensis | 334426 | Nematoda | Nematoda | 50.1 | 3.15e-5 | NR | VDM57338.1 | 334426 | g364364 | i0 | 50 | 1.17460317460317 | 42 | 21 | 66.7 | 0 | 186 | 61 | 164 | 205 | VDM57338.1 unnamed protein product [Angiostrongylus costaricensis] | diamond | 222 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Angiostrongylus | Angiostrongylus costaricensis | |
| 29716855 | 29716855 | PRJEB11748_P_NODE_384210_length_176_cov_8.078261_g382027_i0 | PRJEB11748 | 384210 | 176 | 8.078261 | 14.21773936 | Wuchereria bancrofti | 6293 | Nematoda | Nematoda | 99.8 | 1.2800000000000001e-22 | NR | VDM09662.1 | 6293 | g382027 | i0 | 98 | 0.869318181818182 | 51 | 1 | 86.9 | 0 | 24 | 176 | 362 | 412 | VDM09662.1 unnamed protein product [Wuchereria bancrofti] | diamond | 153 | 99.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 30222320 | 30222320 | PRJEB11748_P_NODE_186292_length_296_cov_2.178723_g184109_i0 | PRJEB11748 | 186292 | 296 | 2.178723 | 6.44902008 | Caenorhabditis brenneri | 135651 | Nematoda | Nematoda | 80.1 | 4.84e-15 | NR | EGT53782.1 | 135651 | g184109 | i0 | 46.1 | 0.902027027027027 | 89 | 48 | 90.2 | 0 | 23 | 289 | 311 | 399 | EGT53782.1 hypothetical protein CAEBREN_30708, partial [Caenorhabditis brenneri] | diamond | 267 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis brenneri | |
| 30469284 | 30469284 | PRJEB11748_P_NODE_355593_length_195_cov_2.492537_g353410_i0 | PRJEB11748 | 355593 | 195 | 2.492537 | 4.86044715 | root | 1 | Root_unresolved | Root_unresolved | 100 | 3.309999999999999e-23 | NR | KAK6048272.1 | 27828 | g353410 | i0 | 75.4 | 2.83076923076923 | 61 | 15 | 93.8 | 0 | 184 | 2 | 316 | 376 | KAK6048272.1 hypothetical protein COOONC_14223 [Cooperia oncophora] | diamond | 552 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Cooperia | Cooperia oncophora | |
| 32049679 | 32049679 | PRJEB11748_P_NODE_139438_length_349_cov_3.298611_g137260_i0 | PRJEB11748 | 139438 | 349 | 3.298611 | 11.51215239 | Opisthokonta | 33154 | Nematoda | Nematoda | 73.9 | 1.12e-12 | NR | KHN87376.1 | 6265 | g137260 | i0 | 71.4 | 7.48710601719198 | 42 | 12 | 36.1 | 0 | 333 | 208 | 328 | 369 | KHN87376.1 Proteasome subunit alpha type-2 [Toxocara canis] | diamond | 2613 | 74.3 | 0.994616419919246 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 32246088 | 32246088 | PRJEB11748_P_NODE_180958_length_301_cov_2.495833_g178775_i0 | PRJEB11748 | 180958 | 301 | 2.495833 | 7.51245733 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 46.6 | 0.00343 | NR | KAE9555067.1 | 2598192 | g178775 | i0 | 35.7 | 0.837209302325581 | 84 | 47 | 82.7 | 2 | 28 | 276 | 1198 | 1275 | KAE9555067.1 hypothetical protein FO519_001728 [Halicephalobus sp. NKZ332] | diamond | 252 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 |
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);;