contig_metadata
20 rows where bioproject = "PRJNA270367", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14398921 | 14398921 | PRJNA270367_P_NODE_16332_length_311_cov_1.801527_g16127_i0 | PRJNA270367 | 16332 | 311 | 1.801527 | 5.60274897 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 165 | 6.39e-50 | NR | TNJ26653.1 | 5742 | g16127 | i0 | 75.7 | 0.993569131832797 | 103 | 25 | 99.4 | 0 | 311 | 3 | 7 | 109 | TNJ26653.1 Peptidyl-prolyl cis-trans isomerase B [Giardia muris] | diamond | 309 | 165 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 26743209 | 26743209 | PRJNA270367_P_NODE_26521_length_221_cov_1.220930_g26316_i0 | PRJNA270367 | 26521 | 221 | 1.22093 | 2.6982553 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 45.4 | 0.00318 | NR | ESU42391.1 | 5741 | g26316 | i0 | 52.9 | 1.3710407239819 | 34 | 16 | 46.2 | 0 | 221 | 120 | 997 | 1030 | ESU42391.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 303 | 45.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 27611262 | 27611262 | PRJNA270367_P_NODE_33244_length_190_cov_1.524823_g33039_i0 | PRJNA270367 | 33244 | 190 | 1.524823 | 2.8971637 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 42 | 0.0357 | NR | XP_001705381.2 | 5741 | g33039 | i0 | 60 | 0.947368421052632 | 30 | 12 | 47.4 | 0 | 190 | 101 | 586 | 615 | XP_001705381.2 VSP [Giardia intestinalis] | diamond | 180 | 42 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28432100 | 28432100 | PRJNA270367_P_NODE_20346_length_266_cov_1.663594_g20141_i0 | PRJNA270367 | 20346 | 266 | 1.663594 | 4.42516004 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 50.4 | 9.44e-5 | NR | ESU44771.1 | 5741 | g20141 | i0 | 33.3 | 0.947368421052632 | 84 | 42 | 86.8 | 2 | 5 | 235 | 362 | 438 | ESU44771.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 252 | 50.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28590118 | 28590118 | PRJNA270367_P_NODE_7107_length_507_cov_1.550218_g6909_i0 | PRJNA270367 | 7107 | 507 | 1.550218 | 7.85960526 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 55.8 | 1.43e-5 | NR | ESU42579.1 | 5741 | g6909 | i0 | 29.4 | 3.9585798816568 | 170 | 103 | 97 | 7 | 3 | 494 | 492 | 650 | ESU42579.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 2007 | 55.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28716315 | 28716315 | PRJNA270367_P_NODE_42447_length_166_cov_0.888889_g42242_i0 | PRJNA270367 | 42447 | 166 | 0.888889 | 1.47555574 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 66.6 | 4.95e-11 | NR | KAG9393746.1 | 201153 | g42242 | i0 | 55.6 | 1.89759036144578 | 54 | 24 | 97.6 | 0 | 165 | 4 | 374 | 427 | KAG9393746.1 phospholipase B-like protein [Carpediemonas membranifera] | diamond | 315 | 66.6 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 28937345 | 28937345 | PRJNA270367_P_NODE_35388_length_182_cov_1.721805_g35183_i0 | PRJNA270367 | 35388 | 182 | 1.721805 | 3.1336851 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 47 | 5.3e-4 | NR | XP_067762292.1 | 348837 | g35183 | i0 | 40 | 0.824175824175824 | 50 | 30 | 82.4 | 0 | 160 | 11 | 260 | 309 | XP_067762292.1 putative NOD3 protein [Spironucleus salmonicida] | diamond | 150 | 47 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 28937356 | 28937356 | PRJNA270367_P_NODE_9408_length_436_cov_1.237726_g9207_i0 | PRJNA270367 | 9408 | 436 | 1.237726 | 5.39648536 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 73.6 | 5.22e-12 | NR | KAG9394743.1 | 201153 | g9207 | i0 | 34.3 | 0.701834862385321 | 102 | 64 | 70.2 | 1 | 345 | 40 | 417 | 515 | KAG9394743.1 MAC/Perforin domain [Carpediemonas membranifera] | diamond | 306 | 73.6 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 29821067 | 29821067 | PRJNA270367_P_NODE_14611_length_336_cov_1.104530_g14406_i0 | PRJNA270367 | 14611 | 336 | 1.10453 | 3.7112208 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 43.1 | 0.015 | NR | XP_067762115.1 | 348837 | g14406 | i0 | 37.5 | 0.5 | 56 | 34 | 50 | 1 | 245 | 78 | 41 | 95 | XP_067762115.1 Dynein light chain [Spironucleus salmonicida] | diamond | 168 | 43.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 30263935 | 30263935 | PRJNA270367_P_NODE_41772_length_167_cov_0.881356_g41567_i0 | PRJNA270367 | 41772 | 167 | 0.881356 | 1.47186452 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 42 | 0.0244 | NR | CAK8754079.1 | 28002 | g41567 | i0 | 45 | 1.43712574850299 | 40 | 22 | 71.9 | 0 | 139 | 20 | 94 | 133 | CAK8754079.1 HINF_083967 [Hexamita inflata] | diamond | 240 | 42 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 30737410 | 30737410 | PRJNA270367_P_NODE_26214_length_223_cov_1.017241_g26009_i0 | PRJNA270367 | 26214 | 223 | 1.017241 | 2.26844743 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 50.1 | 7.55e-5 | NR | CAK8808005.1 | 28002 | g26009 | i0 | 39.4 | 0.955156950672646 | 71 | 38 | 95.5 | 3 | 213 | 1 | 448 | 513 | CAK8808005.1 HINF_021720 [Hexamita inflata] | diamond | 213 | 50.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 30850009 | 30850009 | PRJNA270367_P_NODE_2714_length_839_cov_1.467089_g2542_i0 | PRJNA270367 | 2714 | 839 | 1.467089 | 12.30887671 | Giardia | 5740 | Fornicata | other_Eukaryota | 49.3 | 0.0137 | NR | ESU42635.1 | 5741 | g2542 | i0 | 46 | 0.607866507747318 | 50 | 26 | 17.5 | 1 | 688 | 834 | 347 | 396 | ESU42635.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 510 | 49.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31306301 | 31306301 | PRJNA270367_P_NODE_8895_length_449_cov_1.790000_g8696_i0 | PRJNA270367 | 8895 | 449 | 1.79 | 8.0371 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 146 | 2.34e-39 | NR | CAK8746233.1 | 28002 | g8696 | i0 | 49.6 | 0.928730512249443 | 139 | 70 | 92.9 | 0 | 32 | 448 | 1 | 139 | CAK8746233.1 HINF_020048 [Hexamita inflata] | diamond | 417 | 146 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31387546 | 31387546 | PRJNA270367_P_NODE_30096_length_203_cov_1.363636_g29891_i0 | PRJNA270367 | 30096 | 203 | 1.363636 | 2.76818108 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 45.1 | 0.00339 | NR | XP_067766886.1 | 348837 | g29891 | i0 | 50 | 3.26600985221675 | 42 | 19 | 62.1 | 1 | 201 | 76 | 367 | 406 | XP_067766886.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 663 | 45.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 32097164 | 32097164 | PRJNA270367_P_NODE_5818_length_566_cov_1.822050_g5626_i0 | PRJNA270367 | 5818 | 566 | 1.82205 | 10.312803 | Giardia intestinalis ATCC 5 | 5741 | Fornicata | other_Eukaryota | 47 | 0.0229 | NR | EET00319.1 | 598745 | g5626 | i0 | 60 | 0.185512367491166 | 35 | 13 | 18.6 | 1 | 110 | 214 | 245 | 278 | EET00319.1 High cysteine membrane protein Group 2 [Giardia intestinalis ATCC 50581] | diamond | 105 | 47 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32399843 | 32399843 | PRJNA270367_P_NODE_30219_length_202_cov_5.267974_g30014_i0 | PRJNA270367 | 30219 | 202 | 5.267974 | 10.64130748 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.1 | 2.75e-4 | NR | ESU40164.1 | 5741 | g30014 | i0 | 44.6 | 3.47524752475248 | 65 | 31 | 96.5 | 2 | 202 | 8 | 588 | 647 | ESU40164.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 702 | 48.5 | 0.991752577319588 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32508783 | 32508783 | PRJNA270367_P_NODE_19479_length_275_cov_1.017699_g19274_i0 | PRJNA270367 | 19479 | 275 | 1.017699 | 2.79867225 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 121 | 2.08e-30 | NR | GIQ81472.1 | 797122 | g19274 | i0 | 69.5 | 0.894545454545455 | 82 | 25 | 89.5 | 0 | 30 | 275 | 100 | 181 | GIQ81472.1 hypothetical protein KIPB_002433 [Kipferlia bialata] | diamond | 246 | 121 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 32508788 | 32508788 | PRJNA270367_P_NODE_26559_length_221_cov_1.087209_g26354_i0 | PRJNA270367 | 26559 | 221 | 1.087209 | 2.40273189 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 43.9 | 0.0097 | NR | CAK8799595.1 | 28002 | g26354 | i0 | 41.3 | 0.624434389140271 | 46 | 24 | 58.4 | 1 | 24 | 152 | 163 | 208 | CAK8799595.1 HINF_048958 [Hexamita inflata] | diamond | 138 | 43.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32572007 | 32572007 | PRJNA270367_P_NODE_2899_length_813_cov_1.547120_g2723_i0 | PRJNA270367 | 2899 | 813 | 1.54712 | 12.5780856 | Giardia lamblia P15 | 658858 | Fornicata | other_Eukaryota | 67.8 | 1.07e-8 | NR | EFO63768.1 | 658858 | g2723 | i0 | 39 | 0.284132841328413 | 77 | 46 | 28 | 1 | 813 | 586 | 502 | 578 | EFO63768.1 High cysteine membrane protein Group 3 [Giardia lamblia P15] | diamond | 231 | 67.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32809810 | 32809810 | PRJNA270367_P_NODE_36700_length_178_cov_1.000000_g36495_i0 | PRJNA270367 | 36700 | 178 | 1 | 1.78 | root | 1 | Root_unresolved | Root_unresolved | 63.5 | 7.22e-10 | NR | KAG9390876.1 | 201153 | g36495 | i0 | 50.9 | 3.89325842696629 | 55 | 27 | 92.7 | 0 | 1 | 165 | 110 | 164 | KAG9390876.1 Protein tyrosine kinase [Carpediemonas membranifera] | diamond | 693 | 63.5 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera |
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);;