contig_metadata
23 rows where bioproject = "PRJNA1028258" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10368914 | 10368914 | PRJNA1028258_P_NODE_84749_length_280_cov_1.345972_g84186_i0 | PRJNA1028258 | 84749 | 280 | 1.345972 | 3.7687216 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 144 | 8.819999999999997e-42 | NR | XP_067763597.1 | 348837 | g84186 | i0 | 69.9 | 0.996428571428571 | 93 | 28 | 99.6 | 0 | 280 | 2 | 7 | 99 | XP_067763597.1 Nucleoside diphosphate kinase [Spironucleus salmonicida] | diamond | 279 | 144 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 19288767 | 19288767 | PRJNA1028258_P_NODE_108356_length_254_cov_1.151351_g107793_i0 | PRJNA1028258 | 108356 | 254 | 1.151351 | 2.92443154 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 80.1 | 2.28e-17 | NR | GIQ89704.1 | 797122 | g107793 | i0 | 48 | 0.885826771653543 | 75 | 39 | 88.6 | 0 | 28 | 252 | 20 | 94 | GIQ89704.1 ornithine decarboxylase, partial [Kipferlia bialata] | diamond | 225 | 80.1 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 21840641 | 21840641 | PRJNA1028258_P_NODE_148258_length_231_cov_1.753086_g147695_i0 | PRJNA1028258 | 148258 | 231 | 1.753086 | 4.04962866 | root | 1 | Root_unresolved | Root_unresolved | 120 | 1.16e-32 | NR | XP_067763597.1 | 348837 | g147695 | i0 | 71.1 | 9.81818181818182 | 76 | 22 | 98.7 | 0 | 230 | 3 | 9 | 84 | XP_067763597.1 Nucleoside diphosphate kinase [Spironucleus salmonicida] | diamond | 2268 | 121 | 0.991735537190083 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 26782003 | 26782003 | PRJNA1028258_P_NODE_45601_length_375_cov_1.369281_g45038_i0 | PRJNA1028258 | 45601 | 375 | 1.369281 | 5.13480375 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 50.1 | 4.64e-4 | NR | CAK8768044.1 | 28002 | g45038 | i0 | 33.7 | 1.328 | 83 | 50 | 64.8 | 2 | 130 | 372 | 404 | 483 | CAK8768044.1 HINF_086844 [Hexamita inflata] | diamond | 498 | 50.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 27604015 | 27604015 | PRJNA1028258_P_NODE_63444_length_321_cov_1.126984_g62881_i0 | PRJNA1028258 | 63444 | 321 | 1.126984 | 3.61761864 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 100 | 1.11e-22 | NR | CAK8746233.1 | 28002 | g62881 | i0 | 45.3 | 1.8411214953271 | 106 | 58 | 99.1 | 0 | 3 | 320 | 4 | 109 | CAK8746233.1 HINF_020048 [Hexamita inflata] | diamond | 591 | 100 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28108802 | 28108802 | PRJNA1028258_P_NODE_29785_length_465_cov_2.676768_g29224_i0 | PRJNA1028258 | 29785 | 465 | 2.676768 | 12.4469712 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 54.7 | 2.78e-5 | NR | CAK8757108.1 | 28002 | g29224 | i0 | 43.8 | 0.929032258064516 | 144 | 72 | 91 | 5 | 462 | 40 | 380 | 517 | CAK8757108.1 HINF_007825 [Hexamita inflata] | diamond | 432 | 54.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28424795 | 28424795 | PRJNA1028258_P_NODE_136546_length_234_cov_0.860606_g135983_i0 | PRJNA1028258 | 136546 | 234 | 0.860606 | 2.01381804 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 90.1 | 6.0100000000000005e-21 | NR | XP_067764835.1 | 348837 | g135983 | i0 | 69.4 | 0.794871794871795 | 62 | 19 | 79.5 | 0 | 8 | 193 | 79 | 140 | XP_067764835.1 Ribosomal protein L23 [Spironucleus salmonicida] | diamond | 186 | 90.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 28551188 | 28551188 | PRJNA1028258_P_NODE_73567_length_300_cov_1.229437_g73004_i0 | PRJNA1028258 | 73567 | 300 | 1.229437 | 3.688311 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 50.1 | 2.05e-4 | NR | KAG9390299.1 | 201153 | g73004 | i0 | 37.8 | 0.74 | 74 | 46 | 74 | 0 | 222 | 1 | 95 | 168 | KAG9390299.1 Leucine-rich repeat [Carpediemonas membranifera] | diamond | 222 | 50.1 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 28614136 | 28614136 | PRJNA1028258_P_NODE_152147_length_231_cov_0.876543_g151584_i0 | PRJNA1028258 | 152147 | 231 | 0.876543 | 2.02481433 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 55.5 | 1e-6 | NR | KAG9390677.1 | 201153 | g151584 | i0 | 44.6 | 0.961038961038961 | 74 | 41 | 96.1 | 0 | 229 | 8 | 165 | 238 | KAG9390677.1 tumor suppressor, Mitostatin [Carpediemonas membranifera] | diamond | 222 | 55.5 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 29056287 | 29056287 | PRJNA1028258_P_NODE_134188_length_235_cov_0.855422_g133625_i0 | PRJNA1028258 | 134188 | 235 | 0.855422 | 2.0102417 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 47 | 9.72e-4 | NR | GIQ82589.1 | 797122 | g133625 | i0 | 50 | 0.612765957446809 | 48 | 24 | 61.3 | 0 | 6 | 149 | 161 | 208 | GIQ82589.1 hypothetical protein KIPB_003753, partial [Kipferlia bialata] | diamond | 144 | 47 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 29182599 | 29182599 | PRJNA1028258_P_NODE_101049_length_260_cov_1.204188_g100486_i0 | PRJNA1028258 | 101049 | 260 | 1.204188 | 3.1308888 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 51.6 | 3.56e-5 | NR | KAG9396651.1 | 201153 | g100486 | i0 | 37.1 | 2.06538461538462 | 89 | 53 | 99.2 | 1 | 3 | 260 | 397 | 485 | KAG9396651.1 DSHCT (NUC185) domain [Carpediemonas membranifera] | diamond | 537 | 51.6 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 29277034 | 29277034 | PRJNA1028258_P_NODE_74329_length_299_cov_0.926087_g73766_i0 | PRJNA1028258 | 74329 | 299 | 0.926087 | 2.76900013 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 45.8 | 0.00427 | NR | GIQ83894.1 | 797122 | g73766 | i0 | 58.1 | 0.642140468227425 | 31 | 13 | 31.1 | 0 | 203 | 295 | 4 | 34 | GIQ83894.1 hypothetical protein KIPB_005295 [Kipferlia bialata] | diamond | 192 | 45.8 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 29340445 | 29340445 | PRJNA1028258_P_NODE_168149_length_227_cov_0.898734_g167586_i0 | PRJNA1028258 | 168149 | 227 | 0.898734 | 2.04012618 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 41.6 | 0.034 | NR | CAK8771002.1 | 28002 | g167586 | i0 | 40 | 0.726872246696035 | 55 | 33 | 72.7 | 0 | 218 | 54 | 54 | 108 | CAK8771002.1 HINF_035050 [Hexamita inflata] | diamond | 165 | 41.6 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 29813857 | 29813857 | PRJNA1028258_P_NODE_46471_length_371_cov_3.162252_g45908_i0 | PRJNA1028258 | 46471 | 371 | 3.162252 | 11.73195492 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 43.1 | 0.0202 | NR | XP_067762115.1 | 348837 | g45908 | i0 | 37.5 | 0.452830188679245 | 56 | 34 | 45.3 | 1 | 187 | 20 | 41 | 95 | XP_067762115.1 Dynein light chain [Spironucleus salmonicida] | diamond | 168 | 43.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 30256595 | 30256595 | PRJNA1028258_P_NODE_37592_length_413_cov_1.348837_g37029_i0 | PRJNA1028258 | 37592 | 413 | 1.348837 | 5.57069681 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 80.9 | 1.19e-14 | NR | CAK8790150.1 | 28002 | g37029 | i0 | 33.1 | 6.15254237288136 | 148 | 83 | 98.8 | 5 | 2 | 409 | 161 | 304 | CAK8790150.1 HINF_096882 [Hexamita inflata] | diamond | 2541 | 80.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 30312028 | 30312028 | PRJNA1028258_P_NODE_159332_length_229_cov_0.887500_g158769_i0 | PRJNA1028258 | 159332 | 229 | 0.8875 | 2.032375 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 111 | 2.32e-27 | NR | XP_067760658.1 | 348837 | g158769 | i0 | 67.1 | 2.97379912663755 | 76 | 25 | 99.6 | 0 | 2 | 229 | 9 | 84 | XP_067760658.1 Mitogen-activated protein kinase [Spironucleus salmonicida] | diamond | 681 | 111 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 30595681 | 30595681 | PRJNA1028258_P_NODE_113913_length_249_cov_1.527778_g113350_i0 | PRJNA1028258 | 113913 | 249 | 1.527778 | 3.80416722 | root | 1 | Root_unresolved | Root_unresolved | 104 | 8.23e-24 | NR | TNJ28992.1 | 5742 | g113350 | i0 | 63 | 9.87951807228916 | 73 | 27 | 88 | 0 | 220 | 2 | 8 | 80 | TNJ28992.1 RNase L inhibitor [Giardia muris] | diamond | 2460 | 104 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 31046438 | 31046438 | PRJNA1028258_P_NODE_62435_length_323_cov_1.677165_g61872_i0 | PRJNA1028258 | 62435 | 323 | 1.677165 | 5.41724295 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 87.4 | 2.66e-19 | NR | CAK8803552.1 | 28002 | g61872 | i0 | 49.4 | 1.5046439628483 | 81 | 41 | 75.2 | 0 | 244 | 2 | 23 | 103 | CAK8803552.1 HINF_063619 [Hexamita inflata] | diamond | 486 | 87.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31172256 | 31172256 | PRJNA1028258_P_NODE_90595_length_271_cov_1.014851_g90032_i0 | PRJNA1028258 | 90595 | 271 | 1.014851 | 2.75024621 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 95.9 | 3.96e-22 | NR | GIQ80663.1 | 797122 | g90032 | i0 | 51.7 | 0.985239852398524 | 89 | 43 | 98.5 | 0 | 3 | 269 | 83 | 171 | GIQ80663.1 glycoside hydrolase, family 25 [Kipferlia bialata] | diamond | 267 | 95.9 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 31710177 | 31710177 | PRJNA1028258_P_NODE_155877_length_230_cov_0.881988_g155314_i0 | PRJNA1028258 | 155877 | 230 | 0.881988 | 2.0285724 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 43.9 | 0.0121 | NR | GKT37085.1 | 2918883 | g155314 | i0 | 31.7 | 0.782608695652174 | 60 | 39 | 78.3 | 1 | 216 | 37 | 269 | 326 | GKT37085.1 Lysine--tRNA ligase [Aduncisulcus paluster] | diamond | 180 | 43.9 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 32058151 | 32058151 | PRJNA1028258_P_NODE_63198_length_321_cov_2.253968_g62635_i0 | PRJNA1028258 | 63198 | 321 | 2.253968 | 7.23523728 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 48.5 | 9.16e-4 | NR | CAK8809694.1 | 28002 | g62635 | i0 | 36.1 | 1.34579439252336 | 72 | 42 | 65.4 | 2 | 109 | 318 | 368 | 437 | CAK8809694.1 HINF_012001 [Hexamita inflata] | diamond | 432 | 48.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32184852 | 32184852 | PRJNA1028258_P_NODE_23258_length_528_cov_2.041394_g22701_i0 | PRJNA1028258 | 23258 | 528 | 2.041394 | 10.77856032 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 48.5 | 0.00571 | NR | CAK8815353.1 | 28002 | g22701 | i0 | 32.4 | 0.778409090909091 | 71 | 46 | 39.8 | 2 | 210 | 1 | 510 | 579 | CAK8815353.1 HINF_013562 [Hexamita inflata] | diamond | 411 | 48.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32343182 | 32343182 | PRJNA1028258_P_NODE_135999_length_234_cov_1.242424_g135436_i0 | PRJNA1028258 | 135999 | 234 | 1.242424 | 2.90727216 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 48.1 | 4.15e-4 | NR | GKT32958.1 | 2918883 | g135436 | i0 | 48.1 | 0.692307692307692 | 54 | 28 | 69.2 | 0 | 2 | 163 | 482 | 535 | GKT32958.1 Small GTPase like protein, partial [Aduncisulcus paluster] | diamond | 162 | 48.1 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster |
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);;