contig_metadata
18 rows where bioproject = "PRJEB66218", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6509360 | 6509360 | PRJEB66218_P_NODE_138686_length_252_cov_1.952880_g136257_i0 | PRJEB66218 | 138686 | 252 | 1.95288 | 4.9212576 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 85.1 | 2.67e-17 | NR | CAK8795161.1 | 28002 | g136257 | i0 | 58.1 | 14.5714285714286 | 62 | 26 | 73.8 | 0 | 65 | 250 | 177 | 238 | CAK8795161.1 HINF_018015 [Hexamita inflata] | diamond | 3672 | 85.9 | 0.990686845168801 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 24357222 | 24357222 | PRJEB66218_P_NODE_150140_length_241_cov_2.144444_g147711_i0 | PRJEB66218 | 150140 | 241 | 2.144444 | 5.16811004 | Giardia ardeae | 5743 | Fornicata | other_Eukaryota | 58.4 | 4.66e-4 | NTclustered | gi|10951|emb|X58290.1| | 5743 | g147711 | i0 | 94.595 | 0.269709543568465 | 37 | 2 | 15 | 0 | 1 | 37 | 1167 | 1131 | G.ardeae genes for 5.8S rRNA, LSU rRNA and SSU rRNA | blastn | 65 | 58.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia ardeae | |||
| 26622435 | 26622435 | PRJEB66218_P_NODE_39061_length_564_cov_1.254473_g36666_i0 | PRJEB66218 | 39061 | 564 | 1.254473 | 7.07522772 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 86.7 | 1.8e-17 | NR | GIQ87528.1 | 797122 | g36666 | i0 | 31.9 | 0.867021276595745 | 163 | 92 | 86.7 | 4 | 491 | 3 | 6 | 149 | GIQ87528.1 hypothetical protein KIPB_009578, partial [Kipferlia bialata] | diamond | 489 | 86.7 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 26844285 | 26844285 | PRJEB66218_P_NODE_105721_length_296_cov_2.195745_g103292_i0 | PRJEB66218 | 105721 | 296 | 2.195745 | 6.4994052 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 88.2 | 7.92e-18 | NR | KAG9395874.1 | 201153 | g103292 | i0 | 46.4 | 3.94256756756757 | 97 | 50 | 98.3 | 1 | 4 | 294 | 4296 | 4390 | KAG9395874.1 Dynein heavy chain and region D6 of dynein motor [Carpediemonas membranifera] | diamond | 1167 | 88.2 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27097127 | 27097127 | PRJEB66218_P_NODE_137782_length_253_cov_1.755208_g135353_i0 | PRJEB66218 | 137782 | 253 | 1.755208 | 4.44067624 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 59.3 | 6.34e-8 | NR | GKT36386.1 | 2918883 | g135353 | i0 | 44.9 | 0.818181818181818 | 69 | 33 | 79.4 | 2 | 202 | 2 | 1393 | 1458 | GKT36386.1 Deoxyribonuclease II like protein [Aduncisulcus paluster] | diamond | 207 | 59.3 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 28107705 | 28107705 | PRJEB66218_P_NODE_13485_length_1146_cov_2.319816_g11788_i0 | PRJEB66218 | 13485 | 1146 | 2.319816 | 26.58509136 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 103 | 1.34e-20 | NR | KAG9396190.1 | 201153 | g11788 | i0 | 47.2 | 0.659685863874346 | 123 | 56 | 31.4 | 3 | 2 | 361 | 228 | 344 | KAG9396190.1 Deoxyribonuclease II [Carpediemonas membranifera] | diamond | 756 | 103 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 28328807 | 28328807 | PRJEB66218_P_NODE_153106_length_239_cov_1.483146_g150677_i0 | PRJEB66218 | 153106 | 239 | 1.483146 | 3.54471894 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 68.6 | 2.82e-11 | NR | XP_067767205.1 | 348837 | g150677 | i0 | 54.7 | 2.4979079497908 | 64 | 28 | 79.1 | 1 | 228 | 40 | 321 | 384 | XP_067767205.1 Cytosolic heat shock protein 70 [Spironucleus salmonicida] | diamond | 597 | 68.6 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 28795182 | 28795182 | PRJEB66218_P_NODE_168947_length_228_cov_1.526946_g166517_i0 | PRJEB66218 | 168947 | 228 | 1.526946 | 3.48143688 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 51.6 | 2.21e-5 | NR | ESU40352.1 | 5741 | g166517 | i0 | 48.9 | 2.78947368421053 | 47 | 22 | 59.2 | 1 | 14 | 148 | 146 | 192 | ESU40352.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 636 | 51.6 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29528917 | 29528917 | PRJEB66218_P_NODE_74730_length_369_cov_1.288961_g72305_i0 | PRJEB66218 | 74730 | 369 | 1.288961 | 4.75626609 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 92.4 | 6.32e-19 | NR | XP_037902385.1 | 5741 | g72305 | i0 | 36.4 | 3.83739837398374 | 118 | 65 | 95.9 | 1 | 3 | 356 | 421 | 528 | XP_037902385.1 Outer-arm dynein beta, partial [Giardia intestinalis] | diamond | 1416 | 92.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 30160116 | 30160116 | PRJEB66218_P_NODE_126632_length_266_cov_1.268293_g124203_i0 | PRJEB66218 | 126632 | 266 | 1.268293 | 3.37365938 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 50.1 | 1.36e-4 | NR | GIQ80145.1 | 797122 | g124203 | i0 | 38.6 | 1.59022556390977 | 83 | 37 | 81.2 | 3 | 252 | 37 | 1019 | 1098 | GIQ80145.1 hypothetical protein KIPB_000894, partial [Kipferlia bialata] | diamond | 423 | 50.1 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 30160255 | 30160255 | PRJEB66218_P_NODE_91352_length_324_cov_2.323194_g88925_i0 | PRJEB66218 | 91352 | 324 | 2.323194 | 7.52714856 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 99 | 2.4e-22 | NR | KAG9391426.1 | 201153 | g88925 | i0 | 55.3 | 0.787037037037037 | 85 | 38 | 78.7 | 0 | 323 | 69 | 48 | 132 | KAG9391426.1 Hydrogenosomal membrane protein 31-like [Carpediemonas membranifera] | diamond | 255 | 99 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30287166 | 30287166 | PRJEB66218_P_NODE_151772_length_240_cov_1.452514_g149343_i0 | PRJEB66218 | 151772 | 240 | 1.452514 | 3.4860336 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 85.1 | 4.41e-17 | NR | GIQ81354.1 | 797122 | g149343 | i0 | 56.8 | 1.7875 | 74 | 30 | 92.5 | 1 | 223 | 2 | 3797 | 3868 | GIQ81354.1 hypothetical protein KIPB_002301, partial [Kipferlia bialata] | diamond | 429 | 85.1 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 30444853 | 30444853 | PRJEB66218_P_NODE_108333_length_292_cov_1.593074_g105904_i0 | PRJEB66218 | 108333 | 292 | 1.593074 | 4.65177608 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 75.9 | 1.45e-13 | NR | KAG9396852.1 | 201153 | g105904 | i0 | 41.6 | 1.84931506849315 | 89 | 52 | 91.4 | 0 | 12 | 278 | 407 | 495 | KAG9396852.1 EF-hand domain pair [Carpediemonas membranifera] | diamond | 540 | 75.9 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30634176 | 30634176 | PRJEB66218_P_NODE_236713_length_203_cov_0.915493_g234282_i0 | PRJEB66218 | 236713 | 203 | 0.915493 | 1.85845079 | Giardia intestinalis ATCC 5 | 5741 | Fornicata | other_Eukaryota | 59.7 | 2.35e-8 | NR | EES99125.1 | 598745 | g234282 | i0 | 43.3 | 5.39408866995074 | 60 | 34 | 88.7 | 0 | 199 | 20 | 3782 | 3841 | EES99125.1 Dynein heavy chain [Giardia intestinalis ATCC 50581] | diamond | 1095 | 59.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31259237 | 31259237 | PRJEB66218_P_NODE_80055_length_353_cov_1.554795_g77629_i0 | PRJEB66218 | 80055 | 353 | 1.554795 | 5.48842635 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 138 | 1.86e-38 | NR | KAG9396057.1 | 201153 | g77629 | i0 | 63.4 | 6.62039660056657 | 112 | 39 | 95.2 | 1 | 352 | 17 | 103 | 212 | KAG9396057.1 Uracil phosphoribosyltransferase [Carpediemonas membranifera] | diamond | 2337 | 138 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31607148 | 31607148 | PRJEB66218_P_NODE_90956_length_325_cov_2.079545_g88529_i0 | PRJEB66218 | 90956 | 325 | 2.079545 | 6.75852125 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 91.3 | 9.74e-19 | NR | KAG9397111.1 | 201153 | g88529 | i0 | 45.5 | 2.00307692307692 | 110 | 54 | 98.8 | 4 | 322 | 2 | 2774 | 2880 | KAG9397111.1 hypothetical protein J8273_1019 [Carpediemonas membranifera] | diamond | 651 | 91.3 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31899009 | 31899009 | PRJEB66218_P_NODE_62857_length_412_cov_2.814815_g60435_i0 | PRJEB66218 | 62857 | 412 | 2.814815 | 11.5970378 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 75.5 | 9.15e-13 | NR | KAG9396467.1 | 201153 | g60435 | i0 | 33.3 | 1.04854368932039 | 144 | 82 | 99 | 6 | 3 | 410 | 101 | 238 | KAG9396467.1 Galactose oxidase, central domain [Carpediemonas membranifera] | diamond | 432 | 75.5 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 32057075 | 32057075 | PRJEB66218_P_NODE_191698_length_214_cov_1.457516_g189268_i0 | PRJEB66218 | 191698 | 214 | 1.457516 | 3.11908424 | Giardia intestinalis ATCC 5 | 5741 | Fornicata | other_Eukaryota | 53.5 | 3.46e-6 | NR | EES99819.1 | 598745 | g189268 | i0 | 34.3 | 2.1588785046729 | 70 | 39 | 88.3 | 2 | 197 | 9 | 41 | 110 | EES99819.1 Cathepsin B precursor [Giardia intestinalis ATCC 50581] | diamond | 462 | 53.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);;