contig_metadata
5 rows where bioproject = "PRJNA1059246", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26972017 | 26972017 | PRJNA1059246_P_NODE_45802_length_308_cov_1.714894_g45176_i0 | PRJNA1059246 | 45802 | 308 | 1.714894 | 5.28187352 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 47 | 0.00231 | NR | KAG9392454.1 | 201153 | g45176 | i0 | 29.7 | 0.983766233766234 | 101 | 69 | 96.4 | 1 | 5 | 301 | 99 | 199 | KAG9392454.1 hypothetical protein J8273_5446 [Carpediemonas membranifera] | diamond | 303 | 47 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27098542 | 27098542 | PRJNA1059246_P_NODE_34562_length_368_cov_1.044068_g33936_i0 | PRJNA1059246 | 34562 | 368 | 1.044068 | 3.84217024 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 45.1 | 0.0196 | NR | CAK8747303.1 | 28002 | g33936 | i0 | 28 | 0.96195652173913 | 118 | 66 | 85.6 | 5 | 24 | 338 | 177 | 288 | CAK8747303.1 HINF_084482 [Hexamita inflata] | diamond | 354 | 45.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 27888169 | 27888169 | PRJNA1059246_P_NODE_50665_length_287_cov_1.439252_g50039_i0 | PRJNA1059246 | 50665 | 287 | 1.439252 | 4.13065324 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 47 | 0.00207 | NR | ESU44403.1 | 5741 | g50039 | i0 | 37.5 | 2.50871080139373 | 80 | 43 | 76.3 | 2 | 278 | 60 | 214 | 293 | ESU44403.1 Protein kinase NEK family protein [Giardia intestinalis] | diamond | 720 | 47 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28614511 | 28614511 | PRJNA1059246_P_NODE_45527_length_310_cov_0.924051_g44901_i0 | PRJNA1059246 | 45527 | 310 | 0.924051 | 2.8645581 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 58.9 | 1.7e-7 | NR | KAG9394637.1 | 201153 | g44901 | i0 | 33.3 | 0.958064516129032 | 99 | 57 | 93.9 | 3 | 291 | 1 | 37 | 128 | KAG9394637.1 Tubulin--tyrosine ligase [Carpediemonas membranifera] | diamond | 297 | 58.9 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 29182984 | 29182984 | PRJNA1059246_P_NODE_45209_length_311_cov_1.294118_g44583_i0 | PRJNA1059246 | 45209 | 311 | 1.294118 | 4.02470698 | Giardia intestinalis assemblage B | 1394984 | Fornicata | other_Eukaryota | 107 | 9.69e-25 | NR | KWX13133.1 | 1394984 | g44583 | i0 | 50 | 0.964630225080386 | 100 | 50 | 96.5 | 0 | 301 | 2 | 178 | 277 | KWX13133.1 TCP-1 chaperonin subunit theta cpn60 chaperonin family protein [Giardia intestinalis assemblage B] | diamond | 300 | 107 | 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);;