contig_metadata
13 rows where bioproject = "PRJNA437204", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7468179 | 7468179 | PRJNA437204_P_NODE_76446_length_255_cov_1.692308_g76147_i0 | PRJNA437204 | 76446 | 255 | 1.692308 | 4.3153854 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 153 | 8.83e-45 | NR | GKT13522.1 | 2918883 | g76147 | i0 | 76.5 | 136.941176470588 | 85 | 20 | 100 | 0 | 1 | 255 | 11 | 95 | GKT13522.1 Ribosomal protein L10 [Aduncisulcus paluster] | diamond | 34920 | 153 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 26807548 | 26807548 | PRJNA437204_P_NODE_96561_length_248_cov_0.880000_g96262_i0 | PRJNA437204 | 96561 | 248 | 0.88 | 2.1824 | root | 1 | Root_unresolved | Root_unresolved | 44.3 | 0.0106 | NR | GIQ81663.1 | 797122 | g96262 | i0 | 58.8 | 1.08870967741935 | 34 | 14 | 41.1 | 0 | 170 | 69 | 243 | 276 | GIQ81663.1 zinc/iron permease [Kipferlia bialata] | diamond | 270 | 44.3 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 27802586 | 27802586 | PRJNA437204_P_NODE_8724_length_568_cov_2.488889_g8428_i0 | PRJNA437204 | 8724 | 568 | 2.488889 | 14.13688952 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 47.8 | 0.0123 | NR | TNJ28645.1 | 5742 | g8428 | i0 | 33.8 | 1.36267605633803 | 136 | 70 | 70.2 | 7 | 525 | 127 | 161 | 279 | TNJ28645.1 VSP protein [Giardia muris] | diamond | 774 | 47.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 27928747 | 27928747 | PRJNA437204_P_NODE_2425_length_930_cov_1.645274_g2200_i0 | PRJNA437204 | 2425 | 930 | 1.645274 | 15.3010482 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 64.7 | 2.23e-7 | NR | TNJ29110.1 | 5742 | g2200 | i0 | 44.9 | 2.50967741935484 | 69 | 35 | 21.3 | 2 | 61 | 258 | 1314 | 1382 | TNJ29110.1 High cysteine membrane protein [Giardia muris] | diamond | 2334 | 64.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 28149854 | 28149854 | PRJNA437204_P_NODE_44645_length_313_cov_0.933333_g44346_i0 | PRJNA437204 | 44645 | 313 | 0.933333 | 2.92133229 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 49.7 | 3.26e-4 | NR | GIQ82614.1 | 797122 | g44346 | i0 | 33.7 | 0.824281150159744 | 86 | 45 | 76.7 | 2 | 241 | 2 | 703 | 782 | GIQ82614.1 hypothetical protein KIPB_003780 [Kipferlia bialata] | diamond | 258 | 49.7 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 28623509 | 28623509 | PRJNA437204_P_NODE_17807_length_430_cov_2.535014_g17508_i0 | PRJNA437204 | 17807 | 430 | 2.535014 | 10.9005602 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 132 | 1.33e-34 | NR | KAG9391051.1 | 201153 | g17508 | i0 | 55 | 0.837209302325581 | 120 | 52 | 82.3 | 1 | 427 | 74 | 135 | 254 | KAG9391051.1 Ribosomal protein L18/L5 [Carpediemonas membranifera] | diamond | 360 | 132 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 29191815 | 29191815 | PRJNA437204_P_NODE_72329_length_261_cov_1.638298_g72030_i0 | PRJNA437204 | 72329 | 261 | 1.638298 | 4.27595778 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 59.7 | 5.09e-8 | NR | ESU34746.1 | 5741 | g72030 | i0 | 47.1 | 4.81609195402299 | 70 | 27 | 78.2 | 5 | 258 | 55 | 596 | 657 | ESU34746.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 1257 | 59.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29271005 | 29271005 | PRJNA437204_P_NODE_10729_length_523_cov_1.197778_g10431_i0 | PRJNA437204 | 10729 | 523 | 1.197778 | 6.26437894 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 178 | 1.15e-53 | NR | KAG9390140.1 | 201153 | g10431 | i0 | 56.8 | 4.58891013384321 | 162 | 70 | 92.9 | 0 | 12 | 497 | 1 | 162 | KAG9390140.1 Ribosomal protein L22/L17 [Carpediemonas membranifera] | diamond | 2400 | 179 | 0.994413407821229 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30012811 | 30012811 | PRJNA437204_P_NODE_101411_length_247_cov_0.879310_g101112_i0 | PRJNA437204 | 101411 | 247 | 0.87931 | 2.1718957 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 48.1 | 4.98e-4 | NR | ESU38322.1 | 5741 | g101112 | i0 | 37.2 | 2.08906882591093 | 86 | 44 | 93.5 | 3 | 244 | 14 | 408 | 492 | ESU38322.1 Furin, partial [Giardia intestinalis] | diamond | 516 | 48.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 30865687 | 30865687 | PRJNA437204_P_NODE_16314_length_444_cov_2.075472_g16015_i0 | PRJNA437204 | 16314 | 444 | 2.075472 | 9.21509568 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 55.5 | 1.05e-5 | NR | ESU40389.1 | 5741 | g16015 | i0 | 37.4 | 2.62162162162162 | 91 | 39 | 60.1 | 4 | 430 | 164 | 120 | 194 | ESU40389.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 1164 | 55.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31055653 | 31055653 | PRJNA437204_P_NODE_46235_length_309_cov_1.114407_g45936_i0 | PRJNA437204 | 46235 | 309 | 1.114407 | 3.44351763 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 41.6 | 0.0487 | NR | ESU45111.1 | 5741 | g45936 | i0 | 44.2 | 0.504854368932039 | 52 | 23 | 46.6 | 2 | 163 | 306 | 1 | 50 | ESU45111.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 156 | 41.6 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31292918 | 31292918 | PRJNA437204_P_NODE_34555_length_340_cov_1.580524_g34256_i0 | PRJNA437204 | 34555 | 340 | 1.580524 | 5.3737816 | root | 1 | Root_unresolved | Root_unresolved | 75.1 | 1.15e-13 | NR | KAG9389660.1 | 201153 | g34256 | i0 | 37.3 | 7.13823529411765 | 102 | 61 | 90 | 2 | 2 | 307 | 129 | 227 | KAG9389660.1 Phosphoribosyl transferase domain [Carpediemonas membranifera] | diamond | 2427 | 75.5 | 0.994701986754967 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31308102 | 31308102 | PRJNA437204_P_NODE_50975_length_298_cov_1.706667_g50676_i0 | PRJNA437204 | 50975 | 298 | 1.706667 | 5.08586766 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 48.5 | 6.61e-4 | NR | XP_001703913.2 | 5741 | g50676 | i0 | 35.1 | 1.73154362416107 | 74 | 48 | 74.5 | 0 | 35 | 256 | 284 | 357 | XP_001703913.2 VSP [Giardia intestinalis] | diamond | 516 | 48.5 | 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);;