contig_metadata
10 rows where bioproject = "PRJNA453567", tax_clade = "Metamonada" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26823093 | 26823093 | PRJNA453567_P_NODE_23241_length_182_cov_1.613793_g23004_i0 | PRJNA453567 | 23241 | 182 | 1.613793 | 2.93710326 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 74.3 | 2.47e-14 | NR | GKT14968.1 | 2918883 | g23004 | i0 | 76.1 | 2.19230769230769 | 46 | 11 | 75.8 | 0 | 40 | 177 | 85 | 130 | GKT14968.1 Eukaryotic translation elongation factor 2, partial [Aduncisulcus paluster] | diamond | 399 | 74.3 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 27186977 | 27186977 | PRJNA453567_P_NODE_14322_length_240_cov_1.344828_g14085_i0 | PRJNA453567 | 14322 | 240 | 1.344828 | 3.2275872 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 53.5 | 5.51e-6 | NR | TNJ26588.1 | 5742 | g14085 | i0 | 48.9 | 1.7625 | 45 | 23 | 56.3 | 0 | 17 | 151 | 145 | 189 | TNJ26588.1 pVSP [Giardia muris] | diamond | 423 | 53.9 | 0.992578849721707 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 27928998 | 27928998 | PRJNA453567_P_NODE_13625_length_248_cov_1.582938_g13388_i0 | PRJNA453567 | 13625 | 248 | 1.582938 | 3.92568624 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 47.8 | 6.63e-4 | NR | ESU35555.1 | 5741 | g13388 | i0 | 47.6 | 1.48790322580645 | 42 | 22 | 50.8 | 0 | 246 | 121 | 176 | 217 | ESU35555.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 369 | 47.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29602023 | 29602023 | PRJNA453567_P_NODE_11970_length_268_cov_1.181818_g11733_i0 | PRJNA453567 | 11970 | 268 | 1.181818 | 3.16727224 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 58.9 | 9.15e-8 | NR | KAG9390902.1 | 201153 | g11733 | i0 | 49.2 | 0.66044776119403 | 59 | 29 | 64.9 | 1 | 40 | 213 | 267 | 325 | KAG9390902.1 hypothetical protein J8273_7167 [Carpediemonas membranifera] | diamond | 177 | 58.9 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 29823177 | 29823177 | PRJNA453567_P_NODE_6991_length_373_cov_1.794643_g6754_i0 | PRJNA453567 | 6991 | 373 | 1.794643 | 6.69401839 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 102 | 1.92e-24 | NR | KAG9392310.1 | 201153 | g6754 | i0 | 41.3 | 1.93833780160858 | 121 | 70 | 96.5 | 1 | 372 | 13 | 41 | 161 | KAG9392310.1 calcineurin regulatory subunit B [Carpediemonas membranifera] | diamond | 723 | 102 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 29886723 | 29886723 | PRJNA453567_P_NODE_28951_length_163_cov_1.238095_g28714_i0 | PRJNA453567 | 28951 | 163 | 1.238095 | 2.01809485 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 73.6 | 1.73e-13 | NR | CAK8766063.1 | 28002 | g28714 | i0 | 61.1 | 6.95705521472393 | 54 | 21 | 99.4 | 0 | 162 | 1 | 4444 | 4497 | CAK8766063.1 HINF_083375 [Hexamita inflata] | diamond | 1134 | 73.6 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 30155241 | 30155241 | PRJNA453567_P_NODE_31192_length_157_cov_1.283333_g30955_i0 | PRJNA453567 | 31192 | 157 | 1.283333 | 2.01483281 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47 | 3.48e-4 | NR | ESU44104.1 | 5741 | g30955 | i0 | 46.9 | 11.5222929936306 | 49 | 25 | 91.7 | 1 | 4 | 147 | 113 | 161 | ESU44104.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 1809 | 47 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 30581416 | 30581416 | PRJNA453567_P_NODE_21453_length_190_cov_1.490196_g21216_i0 | PRJNA453567 | 21453 | 190 | 1.490196 | 2.8313724 | Giardia lamblia P15 | 658858 | Fornicata | other_Eukaryota | 44.3 | 0.00526 | NR | EFO60884.1 | 658858 | g21216 | i0 | 38 | 0.789473684210526 | 50 | 31 | 78.9 | 0 | 1 | 150 | 279 | 328 | EFO60884.1 VSP with INR [Giardia lamblia P15] | diamond | 150 | 44.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 30661031 | 30661031 | PRJNA453567_P_NODE_26493_length_170_cov_1.616541_g26256_i0 | PRJNA453567 | 26493 | 170 | 1.616541 | 2.7481197 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 45.1 | 0.00216 | NR | CAK8815363.1 | 28002 | g26256 | i0 | 36.7 | 2.68235294117647 | 49 | 31 | 86.5 | 0 | 23 | 169 | 365 | 413 | CAK8815363.1 HINF_013575 [Hexamita inflata] | diamond | 456 | 45.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31624696 | 31624696 | PRJNA453567_P_NODE_18796_length_205_cov_1.255952_g18559_i0 | PRJNA453567 | 18796 | 205 | 1.255952 | 2.5747016 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 54.3 | 1.23e-6 | NR | GIQ83287.1 | 797122 | g18559 | i0 | 41.5 | 0.951219512195122 | 65 | 33 | 90.7 | 2 | 1 | 186 | 143 | 205 | GIQ83287.1 hypothetical protein KIPB_004585 [Kipferlia bialata] | diamond | 195 | 54.3 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata |
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);;