contig_metadata
15 rows where bioproject = "PRJNA770826", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9675353 | 9675353 | PRJNA770826_P_NODE_34208_length_165_cov_0.896552_g34037_i0 | PRJNA770826 | 34208 | 165 | 0.896552 | 1.4793108 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 92 | 2.2e-20 | NR | TNJ29519.1 | 5742 | g34037 | i0 | 77.2 | 11.0909090909091 | 57 | 10 | 98.2 | 1 | 163 | 2 | 143 | 199 | TNJ29519.1 Kinase, CMGC MAPK [Giardia muris] | diamond | 1830 | 92.8 | 0.991379310344828 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 20333121 | 20333121 | PRJNA770826_P_NODE_14916_length_209_cov_1.300000_g14745_i0 | PRJNA770826 | 14916 | 209 | 1.3 | 2.717 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 96.3 | 6.779999999999998e-24 | NR | GKT24809.1 | 2918883 | g14745 | i0 | 72.6 | 1.76555023923445 | 62 | 17 | 89 | 0 | 209 | 24 | 48 | 109 | GKT24809.1 Histone H4 like protein [Aduncisulcus paluster] | diamond | 369 | 96.3 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 26641692 | 26641692 | PRJNA770826_P_NODE_18021_length_191_cov_1.098592_g17850_i0 | PRJNA770826 | 18021 | 191 | 1.098592 | 2.09831072 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 62.8 | 1.59e-9 | NR | GIQ84406.1 | 797122 | g17850 | i0 | 50.8 | 1.97905759162304 | 63 | 30 | 99 | 1 | 2 | 190 | 466 | 527 | GIQ84406.1 poxvirus/kinetoplastid-type cap-specific nucleoside 2-O-methyltransferase, partial [Kipferlia bialata] | diamond | 378 | 62.8 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 26704877 | 26704877 | PRJNA770826_P_NODE_18801_length_187_cov_1.130435_g18630_i0 | PRJNA770826 | 18801 | 187 | 1.130435 | 2.11391345 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 52 | 9.78e-6 | NR | ESU40463.1 | 5741 | g18630 | i0 | 47.5 | 0.978609625668449 | 61 | 27 | 89.8 | 3 | 172 | 5 | 326 | 386 | ESU40463.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 183 | 52 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 26904735 | 26904735 | PRJNA770826_P_NODE_801_length_927_cov_1.487472_g691_i0 | PRJNA770826 | 801 | 927 | 1.487472 | 13.78886544 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 204 | 2.8300000000000007e-59 | NR | CAK8746233.1 | 28002 | g691 | i0 | 50.5 | 1.22653721682848 | 198 | 90 | 64.1 | 2 | 123 | 716 | 49 | 238 | CAK8746233.1 HINF_020048 [Hexamita inflata] | diamond | 1137 | 204 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 27473677 | 27473677 | PRJNA770826_P_NODE_11883_length_234_cov_1.086486_g11712_i0 | PRJNA770826 | 11883 | 234 | 1.086486 | 2.54237724 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 57.4 | 2.24e-7 | NR | KWX15913.1 | 1394984 | g11712 | i0 | 39.8 | 1.82051282051282 | 83 | 35 | 88.5 | 4 | 217 | 11 | 254 | 335 | KWX15913.1 Calcium-transporting ATPase [Giardia intestinalis assemblage B] | diamond | 426 | 57.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28063920 | 28063920 | PRJNA770826_P_NODE_10445_length_249_cov_1.560000_g10274_i0 | PRJNA770826 | 10445 | 249 | 1.56 | 3.8844 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 125 | 2.4199999999999997e-31 | NR | KAG9393927.1 | 201153 | g10274 | i0 | 77.8 | 2.92771084337349 | 81 | 18 | 97.6 | 0 | 1 | 243 | 325 | 405 | KAG9393927.1 plasma membrane calcium ATPase [Carpediemonas membranifera] | diamond | 729 | 125 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 28632565 | 28632565 | PRJNA770826_P_NODE_7667_length_296_cov_1.263158_g7496_i0 | PRJNA770826 | 7667 | 296 | 1.263158 | 3.73894768 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 48.1 | 9.25e-4 | NR | CAK8791465.1 | 28002 | g7496 | i0 | 38.2 | 0.77027027027027 | 76 | 34 | 73 | 4 | 37 | 252 | 1655 | 1721 | CAK8791465.1 HINF_084023 [Hexamita inflata] | diamond | 228 | 48.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28853126 | 28853126 | PRJNA770826_P_NODE_27268_length_168_cov_0.873950_g27097_i0 | PRJNA770826 | 27268 | 168 | 0.87395 | 1.468236 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 44.7 | 0.0028 | NR | TNJ30320.1 | 5742 | g27097 | i0 | 40.7 | 0.964285714285714 | 54 | 29 | 96.4 | 1 | 167 | 6 | 40 | 90 | TNJ30320.1 VSP protein [Giardia muris] | diamond | 162 | 44.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 29768896 | 29768896 | PRJNA770826_P_NODE_39811_length_163_cov_0.912281_g39640_i0 | PRJNA770826 | 39811 | 163 | 0.912281 | 1.48701803 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 45.8 | 0.00103 | NR | KAG9390023.1 | 201153 | g39640 | i0 | 43.4 | 0.975460122699387 | 53 | 28 | 97.5 | 1 | 162 | 4 | 147 | 197 | KAG9390023.1 Leucine Rich Repeat [Carpediemonas membranifera] | diamond | 159 | 45.8 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30432783 | 30432783 | PRJNA770826_P_NODE_22253_length_171_cov_1.278689_g22082_i0 | PRJNA770826 | 22253 | 171 | 1.278689 | 2.18655819 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 53.5 | 1.61e-6 | NR | GIQ89381.1 | 797122 | g22082 | i0 | 50 | 0.947368421052632 | 54 | 26 | 94.7 | 1 | 3 | 164 | 14 | 66 | GIQ89381.1 40S ribosomal protein S1/3, eukaryotes [Kipferlia bialata] | diamond | 162 | 53.5 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 31737801 | 31737801 | PRJNA770826_P_NODE_11557_length_237_cov_1.377660_g11386_i0 | PRJNA770826 | 11557 | 237 | 1.37766 | 3.2650542 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 137 | 5.2000000000000004e-37 | NR | CAK8823628.1 | 28002 | g11386 | i0 | 80.8 | 19.746835443038 | 78 | 15 | 98.7 | 0 | 236 | 3 | 178 | 255 | CAK8823628.1 HINF_021087 [Hexamita inflata] | diamond | 4680 | 137 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32298271 | 32298271 | PRJNA770826_P_NODE_9719_length_259_cov_1.438095_g9548_i0 | PRJNA770826 | 9719 | 259 | 1.438095 | 3.72466605 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 53.5 | 1.95e-7 | NR | CAK8756973.1 | 28002 | g9548 | i0 | 50 | 1.52895752895753 | 44 | 20 | 51 | 1 | 7 | 138 | 1 | 42 | CAK8756973.1 HINF_007622 [Hexamita inflata] | diamond | 396 | 53.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32614063 | 32614063 | PRJNA770826_P_NODE_15520_length_205_cov_1.333333_g15349_i0 | PRJNA770826 | 15520 | 205 | 1.333333 | 2.73333265 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 43.9 | 0.00909 | NR | KAG9396300.1 | 201153 | g15349 | i0 | 42.6 | 0.790243902439024 | 54 | 29 | 76.1 | 1 | 31 | 186 | 560 | 613 | KAG9396300.1 Piwi domain [Carpediemonas membranifera] | diamond | 162 | 43.9 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 32834408 | 32834408 | PRJNA770826_P_NODE_5480_length_361_cov_18.631410_g5309_i0 | PRJNA770826 | 5480 | 361 | 18.63141 | 67.2593901 | Giardia intestinalis assemblage B | 1394984 | Fornicata | other_Eukaryota | 47.8 | 0.00251 | NR | KWX13038.1 | 1394984 | g5309 | i0 | 37 | 0.606648199445983 | 73 | 42 | 57.3 | 2 | 253 | 47 | 103 | 175 | KWX13038.1 Variant-specific surface protein [Giardia intestinalis assemblage B] | diamond | 219 | 47.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);;