contig_metadata
15 rows where bioproject = "PRJNA971593" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12423351 | 12423351 | PRJNA971593_P_NODE_14170_length_320_cov_0.931174_g14021_i0 | PRJNA971593 | 14170 | 320 | 0.931174 | 2.9797568 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 146 | 4.08e-41 | NR | GIQ88066.1 | 797122 | g14021 | i0 | 66 | 6.99375 | 106 | 36 | 99.4 | 0 | 320 | 3 | 61 | 166 | GIQ88066.1 hypothetical protein KIPB_010234, partial [Kipferlia bialata] | diamond | 2238 | 147 | 0.993197278911565 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 26937176 | 26937176 | PRJNA971593_P_NODE_13882_length_323_cov_1.232000_g13733_i0 | PRJNA971593 | 13882 | 323 | 1.232 | 3.97936 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 109 | 4.18e-25 | NR | CAK8776451.1 | 28002 | g13733 | i0 | 56.9 | 7.51393188854489 | 102 | 43 | 93.8 | 1 | 321 | 19 | 1722 | 1823 | CAK8776451.1 HINF_030219 [Hexamita inflata] | diamond | 2427 | 109 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 27405413 | 27405413 | PRJNA971593_P_NODE_8563_length_414_cov_3.642229_g8414_i0 | PRJNA971593 | 8563 | 414 | 3.642229 | 15.07882806 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 57.4 | 1.87e-6 | NR | ESU38322.1 | 5741 | g8414 | i0 | 33.3 | 0.695652173913043 | 96 | 49 | 68.1 | 3 | 309 | 28 | 446 | 528 | ESU38322.1 Furin, partial [Giardia intestinalis] | diamond | 288 | 57.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 27594799 | 27594799 | PRJNA971593_P_NODE_5944_length_499_cov_1.535211_g5796_i0 | PRJNA971593 | 5944 | 499 | 1.535211 | 7.66070289 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 52.8 | 1.63e-4 | NR | TNJ29401.1 | 5742 | g5796 | i0 | 29.5 | 1.22044088176353 | 132 | 61 | 70.9 | 7 | 428 | 75 | 870 | 983 | TNJ29401.1 High cysteine membrane protein [Giardia muris] | diamond | 609 | 52.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 27658017 | 27658017 | PRJNA971593_P_NODE_26344_length_245_cov_0.895349_g26195_i0 | PRJNA971593 | 26344 | 245 | 0.895349 | 2.19360505 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 45.8 | 0.0031 | NR | ESU43965.1 | 5741 | g26195 | i0 | 50 | 1.29795918367347 | 52 | 25 | 62.4 | 1 | 11 | 163 | 269 | 320 | ESU43965.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 318 | 45.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28005361 | 28005361 | PRJNA971593_P_NODE_8325_length_421_cov_1.566092_g8176_i0 | PRJNA971593 | 8325 | 421 | 1.566092 | 6.59324732 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 49.7 | 6.91e-4 | NR | ESU41816.1 | 5741 | g8176 | i0 | 37.5 | 0.684085510688836 | 96 | 53 | 66.3 | 4 | 335 | 57 | 138 | 229 | ESU41816.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 288 | 49.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28289112 | 28289112 | PRJNA971593_P_NODE_28326_length_242_cov_0.911243_g28177_i0 | PRJNA971593 | 28326 | 242 | 0.911243 | 2.20520806 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 42.4 | 0.0118 | NR | XP_067762115.1 | 348837 | g28177 | i0 | 37.5 | 0.694214876033058 | 56 | 34 | 69.4 | 1 | 168 | 1 | 41 | 95 | XP_067762115.1 Dynein light chain [Spironucleus salmonicida] | diamond | 168 | 42.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 28320829 | 28320829 | PRJNA971593_P_NODE_5866_length_502_cov_1.974359_g5718_i0 | PRJNA971593 | 5866 | 502 | 1.974359 | 9.91128218 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 64.7 | 1.27e-8 | NR | ESU42289.1 | 5741 | g5718 | i0 | 32.1 | 1.15338645418327 | 193 | 98 | 99.2 | 10 | 4 | 501 | 144 | 330 | ESU42289.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 579 | 64.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28579853 | 28579853 | PRJNA971593_P_NODE_6847_length_465_cov_1.895408_g6698_i0 | PRJNA971593 | 6847 | 465 | 1.895408 | 8.8136472 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 50.4 | 6.53e-4 | NR | ESU40462.1 | 5741 | g6698 | i0 | 31.6 | 1.90322580645161 | 114 | 63 | 69.7 | 4 | 420 | 97 | 222 | 326 | ESU40462.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 885 | 50.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29078798 | 29078798 | PRJNA971593_P_NODE_16468_length_294_cov_1.045249_g16319_i0 | PRJNA971593 | 16468 | 294 | 1.045249 | 3.07303206 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 117 | 4.75e-28 | NR | GKT21729.1 | 2918883 | g16319 | i0 | 54.6 | 1.98979591836735 | 97 | 44 | 99 | 0 | 2 | 292 | 390 | 486 | GKT21729.1 prolyl-tRNA synthetase, putative, partial [Aduncisulcus paluster] | diamond | 585 | 117 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 29299664 | 29299664 | PRJNA971593_P_NODE_5409_length_523_cov_2.515556_g5262_i0 | PRJNA971593 | 5409 | 523 | 2.515556 | 13.15635788 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 103 | 1.81e-24 | NR | KAG9392754.1 | 201153 | g5262 | i0 | 35.1 | 0.980879541108987 | 171 | 101 | 96.9 | 4 | 518 | 12 | 1 | 163 | KAG9392754.1 Translationally controlled tumor protein [Carpediemonas membranifera] | diamond | 513 | 103 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30973936 | 30973936 | PRJNA971593_P_NODE_10274_length_378_cov_1.373770_g10125_i0 | PRJNA971593 | 10274 | 378 | 1.37377 | 5.1928506 | Giardia intestinalis assemblage B | 1394984 | Fornicata | other_Eukaryota | 60.8 | 7.58e-8 | NR | KWX13596.1 | 1394984 | g10125 | i0 | 29.8 | 1.97619047619048 | 124 | 76 | 93.7 | 4 | 370 | 17 | 29 | 147 | KWX13596.1 Variant-specific surface protein [Giardia intestinalis assemblage B] | diamond | 747 | 60.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31669368 | 31669368 | PRJNA971593_P_NODE_16177_length_297_cov_1.031250_g16028_i0 | PRJNA971593 | 16177 | 297 | 1.03125 | 3.0628125 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 48.5 | 6.65e-4 | NR | ESU44771.1 | 5741 | g16028 | i0 | 32.6 | 2.67676767676768 | 89 | 55 | 89.9 | 2 | 291 | 25 | 350 | 433 | ESU44771.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 795 | 48.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32049027 | 32049027 | PRJNA971593_P_NODE_7198_length_453_cov_1.521053_g7049_i0 | PRJNA971593 | 7198 | 453 | 1.521053 | 6.89037009 | Giardia lamblia P15 | 658858 | Fornicata | other_Eukaryota | 52.4 | 1.49e-4 | NR | EFO61193.1 | 658858 | g7049 | i0 | 30.9 | 0.986754966887417 | 149 | 67 | 84.1 | 9 | 73 | 453 | 420 | 554 | EFO61193.1 VSP with INR [Giardia lamblia P15] | diamond | 447 | 52.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32213652 | 32213652 | PRJNA971593_P_NODE_3158_length_676_cov_1.356551_g3015_i0 | PRJNA971593 | 3158 | 676 | 1.356551 | 9.17028476 | root | 1 | Root_unresolved | Root_unresolved | 57.8 | 9.19e-6 | NR | EFO60902.1 | 658858 | g3015 | i0 | 28.6 | 2.0414201183432 | 161 | 102 | 71 | 5 | 42 | 521 | 123 | 271 | EFO60902.1 VSP [Giardia lamblia P15] | diamond | 1380 | 58.2 | 0.993127147766323 | 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);;