contig_metadata
22 rows where bioproject = "PRJNA493827", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26743933 | 26743933 | PRJNA493827_P_NODE_84681_length_373_cov_3.966667_g82483_i0 | PRJNA493827 | 84681 | 373 | 3.966667 | 14.79566791 | Giardia | 5740 | Fornicata | other_Eukaryota | 54.3 | 1.38e-5 | NR | ESU34884.1 | 5741 | g82483 | i0 | 36.8 | 0.916890080428954 | 57 | 36 | 45.8 | 0 | 257 | 87 | 343 | 399 | ESU34884.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 342 | 54.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 26760108 | 26760108 | PRJNA493827_P_NODE_120901_length_311_cov_1.092437_g118703_i0 | PRJNA493827 | 120901 | 311 | 1.092437 | 3.39747907 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 47.4 | 0.00189 | NR | CAK8808015.1 | 28002 | g118703 | i0 | 32.6 | 0.829581993569132 | 86 | 52 | 81 | 3 | 298 | 47 | 208 | 289 | CAK8808015.1 HINF_021735 [Hexamita inflata] | diamond | 258 | 47.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 27202947 | 27202947 | PRJNA493827_P_NODE_114162_length_320_cov_1.246964_g111964_i0 | PRJNA493827 | 114162 | 320 | 1.246964 | 3.9902848 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 102 | 7.859999999999999e-23 | NR | GCA62523.1 | 797122 | g111964 | i0 | 44.4 | 2.025 | 108 | 58 | 99.4 | 1 | 2 | 319 | 789 | 896 | GCA62523.1 hypothetical protein KIPB_004062 [Kipferlia bialata] | diamond | 648 | 102 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 27218652 | 27218652 | PRJNA493827_P_NODE_202022_length_247_cov_1.494253_g199824_i0 | PRJNA493827 | 202022 | 247 | 1.494253 | 3.69080491 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 65.1 | 9.87e-11 | NR | CAK8822732.1 | 28002 | g199824 | i0 | 47.6 | 3.91093117408907 | 63 | 32 | 76.5 | 1 | 191 | 3 | 13 | 74 | CAK8822732.1 HINF_033424 [Hexamita inflata] | diamond | 966 | 65.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 27266517 | 27266517 | PRJNA493827_P_NODE_39963_length_577_cov_2.543651_g37784_i0 | PRJNA493827 | 39963 | 577 | 2.543651 | 14.67686627 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 65.9 | 9.07e-9 | NR | ESU44771.1 | 5741 | g37784 | i0 | 32.8 | 1.94974003466205 | 125 | 71 | 59.3 | 4 | 232 | 573 | 405 | 527 | ESU44771.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 1125 | 65.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 27582328 | 27582328 | PRJNA493827_P_NODE_94804_length_352_cov_1.684588_g92606_i0 | PRJNA493827 | 94804 | 352 | 1.684588 | 5.92974976 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 44.7 | 0.0248 | NR | ESU42355.1 | 5741 | g92606 | i0 | 43.5 | 1.15909090909091 | 46 | 24 | 39.2 | 1 | 144 | 281 | 300 | 343 | ESU42355.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 408 | 44.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 27692947 | 27692947 | PRJNA493827_P_NODE_148184_length_281_cov_1.480769_g145986_i0 | PRJNA493827 | 148184 | 281 | 1.480769 | 4.16096089 | root | 1 | Root_unresolved | Root_unresolved | 100 | 2.0199999999999994e-23 | NR | KAG9389664.1 | 201153 | g145986 | i0 | 51.7 | 2.83985765124555 | 89 | 43 | 95 | 0 | 270 | 4 | 166 | 254 | KAG9389664.1 Adenine phosphoribosyl transferase [Carpediemonas membranifera] | diamond | 798 | 101 | 0.99009900990099 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27709122 | 27709122 | PRJNA493827_P_NODE_54564_length_480_cov_1.390663_g52372_i0 | PRJNA493827 | 54564 | 480 | 1.390663 | 6.6751824 | Giardia intestinalis ATCC 5 | 5741 | Fornicata | other_Eukaryota | 50.8 | 5.96e-4 | NR | EET00319.1 | 598745 | g52372 | i0 | 25 | 0.575 | 92 | 68 | 56.9 | 1 | 428 | 156 | 187 | 278 | EET00319.1 High cysteine membrane protein Group 2 [Giardia intestinalis ATCC 50581] | diamond | 276 | 50.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 27709136 | 27709136 | PRJNA493827_P_NODE_89104_length_364_cov_1.000000_g86906_i0 | PRJNA493827 | 89104 | 364 | 1 | 3.64 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 54.7 | 9.48e-6 | NR | ESU41862.1 | 5741 | g86906 | i0 | 37.5 | 0.725274725274725 | 88 | 47 | 70.9 | 4 | 44 | 301 | 269 | 350 | ESU41862.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 264 | 54.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 27834766 | 27834766 | PRJNA493827_P_NODE_175144_length_258_cov_1.437838_g172946_i0 | PRJNA493827 | 175144 | 258 | 1.437838 | 3.70962204 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 59.3 | 6.2e-8 | NR | GIQ83316.1 | 797122 | g172946 | i0 | 44.3 | 1.54651162790698 | 61 | 34 | 70.9 | 0 | 17 | 199 | 83 | 143 | GIQ83316.1 hypothetical protein KIPB_004620 [Kipferlia bialata] | diamond | 399 | 59.3 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 28687676 | 28687676 | PRJNA493827_P_NODE_174047_length_259_cov_1.344086_g171849_i0 | PRJNA493827 | 174047 | 259 | 1.344086 | 3.48118274 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 50.1 | 1.23e-4 | NR | XP_001707902.1 | 5741 | g171849 | i0 | 45.7 | 1.57528957528958 | 46 | 22 | 49.8 | 1 | 160 | 32 | 319 | 364 | XP_001707902.1 High cysteine membrane protein Group 2 [Giardia intestinalis] | diamond | 408 | 50.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28750463 | 28750463 | PRJNA493827_P_NODE_10767_length_1266_cov_32.689858_g9454_i0 | PRJNA493827 | 10767 | 1266 | 32.689858 | 413.85360228 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 274 | 6.370000000000001e-85 | NR | CAK8746233.1 | 28002 | g9454 | i0 | 43.2 | 0.938388625592417 | 396 | 196 | 93.8 | 3 | 31 | 1218 | 3 | 369 | CAK8746233.1 HINF_020048 [Hexamita inflata] | diamond | 1188 | 274 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 29019122 | 29019122 | PRJNA493827_P_NODE_159028_length_272_cov_0.909548_g156830_i0 | PRJNA493827 | 159028 | 272 | 0.909548 | 2.47397056 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 44.7 | 0.011 | NR | ESU40393.1 | 5741 | g156830 | i0 | 28.1 | 1.97426470588235 | 96 | 61 | 97.1 | 1 | 271 | 8 | 285 | 380 | ESU40393.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 537 | 44.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29318823 | 29318823 | PRJNA493827_P_NODE_226189_length_242_cov_1.461538_g223991_i0 | PRJNA493827 | 226189 | 242 | 1.461538 | 3.53692196 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 57.8 | 1.75e-7 | NR | KAG9391109.1 | 201153 | g223991 | i0 | 37.8 | 2.71487603305785 | 74 | 44 | 89.3 | 1 | 23 | 238 | 221 | 294 | KAG9391109.1 MAC/Perforin domain [Carpediemonas membranifera] | diamond | 657 | 57.8 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 29382153 | 29382153 | PRJNA493827_P_NODE_99889_length_343_cov_0.914815_g97691_i0 | PRJNA493827 | 99889 | 343 | 0.914815 | 3.13781545 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 124 | 5.969999999999998e-32 | NR | KAG9391051.1 | 201153 | g97691 | i0 | 54.5 | 2.89504373177843 | 99 | 45 | 86.6 | 0 | 340 | 44 | 110 | 208 | KAG9391051.1 Ribosomal protein L18/L5 [Carpediemonas membranifera] | diamond | 993 | 124 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30108333 | 30108333 | PRJNA493827_P_NODE_182492_length_252_cov_1.418994_g180294_i0 | PRJNA493827 | 182492 | 252 | 1.418994 | 3.57586488 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 89 | 3.02e-20 | NR | KAG9392706.1 | 201153 | g180294 | i0 | 57.4 | 1.61904761904762 | 68 | 29 | 81 | 0 | 250 | 47 | 87 | 154 | KAG9392706.1 Translation elongation factor IF5A [Carpediemonas membranifera] | diamond | 408 | 89 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30218787 | 30218787 | PRJNA493827_P_NODE_59032_length_458_cov_2.031169_g56836_i0 | PRJNA493827 | 59032 | 458 | 2.031169 | 9.30275402 | Giardia | 5740 | Fornicata | other_Eukaryota | 53.1 | 8.01e-5 | NR | XP_001709621.2 | 5741 | g56836 | i0 | 28 | 4.30349344978166 | 164 | 74 | 97.6 | 6 | 452 | 6 | 86 | 220 | XP_001709621.2 VSP [Giardia intestinalis] | diamond | 1971 | 53.5 | 0.992523364485981 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 30661181 | 30661181 | PRJNA493827_P_NODE_170473_length_262_cov_1.365079_g168275_i0 | PRJNA493827 | 170473 | 262 | 1.365079 | 3.57650698 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.9 | 3.02e-4 | NR | XP_067760707.1 | 348837 | g168275 | i0 | 37.5 | 1.86641221374046 | 80 | 46 | 89.3 | 2 | 235 | 2 | 9 | 86 | XP_067760707.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 489 | 48.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 31119200 | 31119200 | PRJNA493827_P_NODE_42315_length_557_cov_38.559917_g40129_i0 | PRJNA493827 | 42315 | 557 | 38.559917 | 214.77873769 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 59.7 | 1.1e-6 | NR | CAK8753212.1 | 28002 | g40129 | i0 | 27 | 1.12567324955117 | 159 | 87 | 71.1 | 6 | 425 | 30 | 830 | 986 | CAK8753212.1 HINF_005767 [Hexamita inflata] | diamond | 627 | 59.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31119208 | 31119208 | PRJNA493827_P_NODE_62115_length_445_cov_2.357527_g59918_i0 | PRJNA493827 | 62115 | 445 | 2.357527 | 10.49099515 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 191 | 5.23e-60 | NR | GCA62516.1 | 797122 | g59918 | i0 | 75.6 | 0.802247191011236 | 119 | 29 | 80.2 | 0 | 21 | 377 | 1 | 119 | GCA62516.1 peptidyl-prolyl cis-trans isomerase, FKBP-type [Kipferlia bialata] | diamond | 357 | 191 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 32258471 | 32258471 | PRJNA493827_P_NODE_147818_length_281_cov_2.538462_g145620_i0 | PRJNA493827 | 147818 | 281 | 2.538462 | 7.13307822 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 49.3 | 3.03e-4 | NR | CAK8776449.1 | 28002 | g145620 | i0 | 34.4 | 1.8576512455516 | 64 | 37 | 63 | 1 | 179 | 3 | 1208 | 1271 | CAK8776449.1 HINF_030216 [Hexamita inflata] | diamond | 522 | 49.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32448282 | 32448282 | PRJNA493827_P_NODE_239519_length_214_cov_11.950355_g237320_i0 | PRJNA493827 | 239519 | 214 | 11.950355 | 25.5737597 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 44.3 | 6.55e-4 | NR | XP_067767588.1 | 348837 | g237320 | i0 | 54.5 | 1.5 | 33 | 15 | 46.3 | 0 | 195 | 97 | 4 | 36 | XP_067767588.1 Dpy-30 motif-containing protein [Spironucleus salmonicida] | diamond | 321 | 44.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida |
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);;