contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA796753" and tax_phylum = "Fornicata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27116834 | 27116834 | PRJNA796753_P_NODE_17422_length_347_cov_1.124088_g17110_i0 | PRJNA796753 | 17422 | 347 | 1.124088 | 3.90058536 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 83.2 | 4.98e-17 | NR | KAG9395588.1 | 201153 | g17110 | i0 | 35.1 | 1.92795389048991 | 114 | 72 | 98.6 | 1 | 5 | 346 | 29 | 140 | KAG9395588.1 emp24/gp25L/p24 family/GOLD [Carpediemonas membranifera] | diamond | 669 | 83.2 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27220760 | 27220760 | PRJNA796753_P_NODE_43362_length_248_cov_0.880000_g43050_i0 | PRJNA796753 | 43362 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.4 | 9.27e-4 | NR | ESU39807.1 | 5741 | g43050 | i0 | 36.9 | 3.07258064516129 | 65 | 34 | 72.6 | 2 | 194 | 15 | 572 | 634 | ESU39807.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 762 | 47.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 27559211 | 27559211 | PRJNA796753_P_NODE_3944_length_672_cov_1.542571_g3645_i0 | PRJNA796753 | 3944 | 672 | 1.542571 | 10.36607712 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 72.4 | 1.2e-10 | NR | XP_067766864.1 | 348837 | g3645 | i0 | 29.1 | 0.90625 | 203 | 119 | 87.5 | 10 | 62 | 649 | 336 | 520 | XP_067766864.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 609 | 72.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 27559219 | 27559219 | PRJNA796753_P_NODE_45684_length_247_cov_0.885057_g45372_i0 | PRJNA796753 | 45684 | 247 | 0.885057 | 2.18609079 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 44.3 | 0.0113 | NR | GKT37136.1 | 2918883 | g45372 | i0 | 35.6 | 0.88663967611336 | 73 | 38 | 88.7 | 2 | 241 | 23 | 378 | 441 | GKT37136.1 hypothetical protein ADUPG1_009982, partial [Aduncisulcus paluster] | diamond | 219 | 44.3 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 27559220 | 27559220 | PRJNA796753_P_NODE_45884_length_247_cov_0.885057_g45572_i0 | PRJNA796753 | 45884 | 247 | 0.885057 | 2.18609079 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 63.2 | 2.47e-9 | NR | KAG9392087.1 | 201153 | g45572 | i0 | 46.7 | 0.728744939271255 | 60 | 32 | 72.9 | 0 | 180 | 1 | 62 | 121 | KAG9392087.1 RNA (C5-cytosine) methyltransferase [Carpediemonas membranifera] | diamond | 180 | 63.2 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27726812 | 27726812 | PRJNA796753_P_NODE_19464_length_333_cov_1.184615_g19152_i0 | PRJNA796753 | 19464 | 333 | 1.184615 | 3.94476795 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.8 | 0.00182 | NR | EFO60851.1 | 658858 | g19152 | i0 | 41.5 | 1.77477477477477 | 65 | 37 | 58.6 | 1 | 23 | 217 | 485 | 548 | EFO60851.1 High cysteine membrane protein Group 2 [Giardia lamblia P15] | diamond | 591 | 47.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 27843376 | 27843376 | PRJNA796753_P_NODE_11484_length_412_cov_0.908555_g11172_i0 | PRJNA796753 | 11484 | 412 | 0.908555 | 3.7432466 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 53.5 | 3.91e-5 | NR | XP_001707611.1 | 5741 | g11172 | i0 | 33.3 | 1.86407766990291 | 120 | 63 | 75 | 3 | 312 | 4 | 102 | 221 | XP_001707611.1 High cysteine membrane protein Group 5 [Giardia intestinalis] | diamond | 768 | 53.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29485130 | 29485130 | PRJNA796753_P_NODE_19990_length_329_cov_1.707031_g19678_i0 | PRJNA796753 | 19990 | 329 | 1.707031 | 5.61613199 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 53.9 | 6.93e-6 | NR | TNJ27030.1 | 5742 | g19678 | i0 | 36.1 | 1.51367781155015 | 83 | 52 | 75.7 | 1 | 268 | 20 | 136 | 217 | TNJ27030.1 Translation elongation factor 1-beta [Giardia muris] | diamond | 498 | 53.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 30053694 | 30053694 | PRJNA796753_P_NODE_251_length_1886_cov_23.280199_g209_i0 | PRJNA796753 | 251 | 1886 | 23.280199 | 439.06455314 | Giardia intestinalis assemblage B | 1394984 | Fornicata | other_Eukaryota | 48.1 | 0.0426 | NR | KWX14910.1 | 1394984 | g209 | i0 | 30.1 | 0.295864262990456 | 186 | 101 | 27.8 | 9 | 878 | 354 | 2 | 169 | KWX14910.1 Variant-specific surface protein [Giardia intestinalis assemblage B] | diamond | 558 | 48.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 30622428 | 30622428 | PRJNA796753_P_NODE_30113_length_280_cov_1.048309_g29801_i0 | PRJNA796753 | 30113 | 280 | 1.048309 | 2.9352652 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 52 | 3.27e-5 | NR | XP_067766927.1 | 348837 | g29801 | i0 | 33.3 | 7.5 | 81 | 48 | 86.8 | 2 | 268 | 26 | 306 | 380 | XP_067766927.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 2100 | 52 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 31105483 | 31105483 | PRJNA796753_P_NODE_12015_length_404_cov_0.930514_g11703_i0 | PRJNA796753 | 12015 | 404 | 0.930514 | 3.75927656 | Giardia | 5740 | Fornicata | other_Eukaryota | 47.4 | 0.00497 | NR | ESU40575.1 | 5741 | g11703 | i0 | 44.2 | 1.32178217821782 | 43 | 24 | 31.9 | 0 | 39 | 167 | 296 | 338 | ESU40575.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 534 | 47.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32551894 | 32551894 | PRJNA796753_P_NODE_33759_length_268_cov_1.184615_g33447_i0 | PRJNA796753 | 33759 | 268 | 1.184615 | 3.1747682 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 66.2 | 2.78e-10 | NR | GKT35787.1 | 2918883 | g33447 | i0 | 37.2 | 0.962686567164179 | 86 | 54 | 96.3 | 0 | 267 | 10 | 195 | 280 | GKT35787.1 hypothetical protein ADUPG1_008874 [Aduncisulcus paluster] | diamond | 258 | 66.2 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 32645820 | 32645820 | PRJNA796753_P_NODE_38720_length_251_cov_1.297753_g38408_i0 | PRJNA796753 | 38720 | 251 | 1.297753 | 3.25736003 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 61.6 | 1.5e-9 | NR | GKT34779.1 | 2918883 | g38408 | i0 | 49 | 0.609561752988048 | 51 | 26 | 61 | 0 | 250 | 98 | 98 | 148 | GKT34779.1 hypothetical protein ADUPG1_008070 [Aduncisulcus paluster] | diamond | 153 | 61.6 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster |
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);;