contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA688414" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27441695 | 27441695 | PRJNA688414_P_NODE_8043_length_243_cov_0.917647_g8009_i0 | PRJNA688414 | 8043 | 243 | 0.917647 | 2.22988221 | Cervus | 9859 | Chordata | Chordata | 75.5 | 5.83e-14 | NR | OWK10709.1 | 46360 | g8009 | i0 | 67.2 | 1.4320987654321 | 58 | 12 | 66.7 | 2 | 81 | 242 | 1 | 55 | OWK10709.1 hypothetical protein Celaphus_00005025 [Cervus elaphus hippelaphus] | diamond | 348 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Cervus | Cervus elaphus | |
| 28325398 | 28325398 | PRJNA688414_P_NODE_6426_length_251_cov_0.876404_g6392_i0 | PRJNA688414 | 6426 | 251 | 0.876404 | 2.19977404 | Polyporales | 5303 | Fungi | Fungi | 76.3 | 6.46e-14 | NR | PSR75788.1 | 98765 | g6392 | i0 | 85 | 3.35856573705179 | 40 | 6 | 47.8 | 0 | 21 | 140 | 375 | 414 | PSR75788.1 hypothetical protein PHLCEN_2v8905 [Hermanssonia centrifuga] | diamond | 843 | 76.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Meruliaceae | Hermanssonia | Hermanssonia centrifuga | |
| 28471945 | 28471945 | PRJNA688414_P_NODE_8326_length_242_cov_0.923077_g8292_i0 | PRJNA688414 | 8326 | 242 | 0.923077 | 2.23384634 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 3.76e-5 | NR | XP_004037361.1 | 5932 | g8292 | i0 | 45.9 | 0.756198347107438 | 61 | 27 | 73.1 | 2 | 1 | 177 | 106 | 162 | XP_004037361.1 hypothetical protein IMG5_055180 [Ichthyophthirius multifiliis] | diamond | 183 | 51.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 28925303 | 28925303 | PRJNA688414_P_NODE_8308_length_242_cov_0.923077_g8274_i0 | PRJNA688414 | 8308 | 242 | 0.923077 | 2.23384634 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 45.8 | 0.00302 | NR | XP_009168110.1 | 6198 | g8274 | i0 | 50 | 1.30165289256198 | 52 | 26 | 64.5 | 0 | 241 | 86 | 327 | 378 | XP_009168110.1 hypothetical protein T265_04969 [Opisthorchis viverrini] | diamond | 315 | 46.2 | 0.991341991341991 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 29450374 | 29450374 | PRJNA688414_P_NODE_7130_length_248_cov_0.891429_g7096_i0 | PRJNA688414 | 7130 | 248 | 0.891429 | 2.21074392 | Setomelanomma holmii | 210430 | Fungi | Fungi | 162 | 7.249999999999999e-45 | NR | KAF2023980.1 | 210430 | g7096 | i0 | 97.6 | 0.991935483870968 | 82 | 2 | 99.2 | 0 | 247 | 2 | 97 | 178 | KAF2023980.1 phenylalanyl-tRNA synthetase beta chain [Setomelanomma holmii] | diamond | 246 | 162 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Setomelanomma | Setomelanomma holmii | |
| 29829457 | 29829457 | PRJNA688414_P_NODE_7771_length_245_cov_0.877907_g7737_i0 | PRJNA688414 | 7771 | 245 | 0.877907 | 2.15087215 | Polarella glacialis | 89957 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0131 | NR | CAK0854905.1 | 89957 | g7737 | i0 | 44.2 | 0.52653061224489806 | 43 | 22 | 52.7 | 1 | 31 | 159 | 38 | 78 | CAK0854905.1 unnamed protein product [Polarella glacialis] | diamond | 129 | 42.7 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 29924390 | 29924390 | PRJNA688414_P_NODE_7471_length_246_cov_0.901734_g7437_i0 | PRJNA688414 | 7471 | 246 | 0.901734 | 2.21826564 | Prosopis alba | 207710 | Plants | Plants | 48.9 | 2.54e-4 | NR | XP_028796772.1 | 207710 | g7437 | i0 | 62.2 | 0.902439024390244 | 37 | 14 | 45.1 | 0 | 40 | 150 | 304 | 340 | XP_028796772.1 craniofacial development protein 2-like [Prosopis alba] | diamond | 222 | 48.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Neltuma | Neltuma alba | |
| 30303884 | 30303884 | PRJNA688414_P_NODE_6392_length_251_cov_0.876404_g6358_i0 | PRJNA688414 | 6392 | 251 | 0.876404 | 2.19977404 | Glycine soja | 3848 | Plants | Plants | 100 | 1.33e-25 | NR | KAG4983528.1 | 3848 | g6358 | i0 | 100 | 0.537848605577689 | 45 | 0 | 53.8 | 0 | 251 | 117 | 42 | 86 | KAG4983528.1 hypothetical protein JHK87_028277 [Glycine soja] | diamond | 135 | 100 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine soja | |
| 30303885 | 30303885 | PRJNA688414_P_NODE_7872_length_244_cov_0.912281_g7838_i0 | PRJNA688414 | 7872 | 244 | 0.912281 | 2.22596564 | Halicephalobus sp. NKZ332 | 2598192 | Nematoda | Nematoda | 46.2 | 0.00227 | NR | KAE9548284.1 | 2598192 | g7838 | i0 | 40.4 | 0.639344262295082 | 52 | 31 | 63.9 | 0 | 243 | 88 | 562 | 613 | KAE9548284.1 hypothetical protein FO519_008508 [Halicephalobus sp. NKZ332] | diamond | 156 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. NKZ332 | |
| 30714105 | 30714105 | PRJNA688414_P_NODE_8314_length_242_cov_0.923077_g8280_i0 | PRJNA688414 | 8314 | 242 | 0.923077 | 2.23384634 | Exophiala mesophila | 212818 | Fungi | Fungi | 66.6 | 1.37e-10 | NR | XP_016229435.1 | 212818 | g8280 | i0 | 72.7 | 3 | 44 | 12 | 54.5 | 0 | 109 | 240 | 14 | 57 | XP_016229435.1 hypothetical protein, variant [Exophiala mesophila] | diamond | 726 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala mesophila | |
| 31883834 | 31883834 | PRJNA688414_P_NODE_5577_length_259_cov_1.629032_g5543_i0 | PRJNA688414 | 5577 | 259 | 1.629032 | 4.21919288 | Ixodes persulcatus | 34615 | Arthropoda | Arthropoda | 80.1 | 3.05e-15 | NR | CAL6253559.1 | 34615 | g5543 | i0 | 50 | 2.95366795366795 | 64 | 32 | 74.1 | 0 | 3 | 194 | 408 | 471 | CAL6253559.1 unnamed protein product, partial [Ixodes persulcatus] | diamond | 765 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Ixodes | Ixodes persulcatus | |
| 32010505 | 32010505 | PRJNA688414_P_NODE_8318_length_242_cov_0.923077_g8284_i0 | PRJNA688414 | 8318 | 242 | 0.923077 | 2.23384634 | Colocasia esculenta | 4460 | Plants | Plants | 87 | 6.43e-18 | NR | MQL82064.1 | 4460 | g8284 | i0 | 95 | 2.47933884297521 | 40 | 2 | 49.6 | 0 | 241 | 122 | 368 | 407 | MQL82064.1 hypothetical protein [Colocasia esculenta] | diamond | 600 | 87 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Araceae | Colocasia | Colocasia esculenta | |
| 32580178 | 32580178 | PRJNA688414_P_NODE_7059_length_248_cov_0.891429_g7025_i0 | PRJNA688414 | 7059 | 248 | 0.891429 | 2.21074392 | Zostera marina | 29655 | Plants | Plants | 64.3 | 1e-9 | NR | KMZ63807.1 | 29655 | g7025 | i0 | 72.1 | 0.737903225806452 | 61 | 9 | 73.8 | 1 | 52 | 234 | 1 | 53 | KMZ63807.1 Aconitate hydratase, 3-isopropylmalate dehydratase [Zostera marina] | diamond | 183 | 64.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Zosteraceae | Zostera | Zostera marina |
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);;