contig_metadata
9 rows where bioproject = "PRJEB10140" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16589998 | 16589998 | PRJEB10140_P_NODE_39134_length_908_cov_5.830035_g25130_i0 | PRJEB10140 | 39134 | 908 | 5.830035 | 52.9367178 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 192 | 5.6e-57 | NR | ESU43996.1 | 5741 | g25130 | i0 | 55.1 | 8.75881057268722 | 176 | 77 | 58.1 | 1 | 861 | 334 | 15 | 188 | ESU43996.1 Peptidyl-prolyl cis-trans isomerase [Giardia intestinalis] | diamond | 7953 | 193 | 0.994818652849741 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 21688265 | 21688265 | PRJEB10140_P_NODE_142918_length_258_cov_1.732057_g125610_i0 | PRJEB10140 | 142918 | 258 | 1.732057 | 4.46870706 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 136 | 5.99e-35 | NR | GIQ85281.1 | 797122 | g125610 | i0 | 68.2 | 1.95348837209302 | 85 | 27 | 98.8 | 0 | 3 | 257 | 1047 | 1131 | GIQ85281.1 phosphatidylinositol Kinase, partial [Kipferlia bialata] | diamond | 504 | 137 | 0.992700729927007 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 27948578 | 27948578 | PRJEB10140_P_NODE_102245_length_358_cov_1.326861_g84947_i0 | PRJEB10140 | 102245 | 358 | 1.326861 | 4.75016238 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 65.5 | 9.77e-10 | NR | CAK8820454.1 | 28002 | g84947 | i0 | 44.7 | 0.787709497206704 | 94 | 45 | 74.6 | 4 | 270 | 4 | 59 | 150 | CAK8820454.1 HINF_052845 [Hexamita inflata] | diamond | 282 | 65.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28763451 | 28763451 | PRJEB10140_P_NODE_223647_length_180_cov_2.335878_g206338_i0 | PRJEB10140 | 223647 | 180 | 2.335878 | 4.2045804 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.9 | 0.00601 | NR | XP_067766909.1 | 348837 | g206338 | i0 | 38.6 | 2.78333333333333 | 57 | 33 | 95 | 1 | 8 | 178 | 44 | 98 | XP_067766909.1 Cysteine-rich membrane protein 1 [Spironucleus salmonicida] | diamond | 501 | 43.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 29085517 | 29085517 | PRJEB10140_P_NODE_71168_length_516_cov_2.805139_g54038_i0 | PRJEB10140 | 71168 | 516 | 2.805139 | 14.47451724 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 52.8 | 1.56e-4 | NR | ESU44488.1 | 5741 | g54038 | i0 | 31.4 | 1.09302325581395 | 188 | 92 | 90.7 | 7 | 20 | 487 | 185 | 367 | ESU44488.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 564 | 52.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29748145 | 29748145 | PRJEB10140_P_NODE_59131_length_620_cov_2.094571_g42490_i0 | PRJEB10140 | 59131 | 620 | 2.094571 | 12.9863402 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 68.6 | 1.16e-9 | NR | XP_037902139.1 | 5741 | g42490 | i0 | 37.2 | 0.624193548387097 | 129 | 61 | 60 | 5 | 9 | 380 | 172 | 285 | XP_037902139.1 High cysteine protein [Giardia intestinalis] | diamond | 387 | 68.6 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31264892 | 31264892 | PRJEB10140_P_NODE_181275_length_211_cov_1.814815_g163966_i0 | PRJEB10140 | 181275 | 211 | 1.814815 | 3.82925965 | Giardia lamblia P15 | 658858 | Fornicata | other_Eukaryota | 50.8 | 3.41e-5 | NR | EFO60902.1 | 658858 | g163966 | i0 | 40.6 | 0.909952606635071 | 64 | 31 | 91 | 2 | 5 | 196 | 159 | 215 | EFO60902.1 VSP [Giardia lamblia P15] | diamond | 192 | 50.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31675977 | 31675977 | PRJEB10140_P_NODE_213497_length_186_cov_2.540146_g196188_i0 | PRJEB10140 | 213497 | 186 | 2.540146 | 4.72467156 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 42.7 | 0.0174 | NR | XP_067766886.1 | 348837 | g196188 | i0 | 35.1 | 0.919354838709677 | 57 | 35 | 91.9 | 1 | 175 | 5 | 345 | 399 | XP_067766886.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 171 | 42.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 31954666 | 31954666 | PRJEB10140_P_NODE_196757_length_198_cov_1.040268_g179448_i0 | PRJEB10140 | 196757 | 198 | 1.040268 | 2.05973064 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 50.8 | 2.87e-5 | NR | ESU35627.1 | 5741 | g179448 | i0 | 42.9 | 7.09090909090909 | 56 | 32 | 84.8 | 0 | 16 | 183 | 34 | 89 | ESU35627.1 Actin related protein [Giardia intestinalis] | diamond | 1404 | 50.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis |
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);;