contig_metadata
22 rows where bioproject = "PRJNA611476", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24815733 | 24815733 | PRJNA611476_P_NODE_40140_length_336_cov_1.638783_g39349_i0 | PRJNA611476 | 40140 | 336 | 1.638783 | 5.50631088 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 170 | 6.0499999999999996e-52 | NR | XP_067763597.1 | 348837 | g39349 | i0 | 71.6 | 9.92857142857143 | 109 | 31 | 97.3 | 0 | 336 | 10 | 12 | 120 | XP_067763597.1 Nucleoside diphosphate kinase [Spironucleus salmonicida] | diamond | 3336 | 170 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 26827162 | 26827162 | PRJNA611476_P_NODE_3841_length_994_cov_3.771987_g1542_i1 | PRJNA611476 | 3841 | 994 | 3.771987 | 37.49355078 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 119 | 1.71e-25 | NR | CAK8747405.1 | 28002 | g1542 | i1 | 41.6 | 0.413480885311871 | 137 | 78 | 41.3 | 1 | 79 | 489 | 4 | 138 | CAK8747405.1 HINF_098669 [Hexamita inflata] | diamond | 411 | 119 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 27174838 | 27174838 | PRJNA611476_P_NODE_62762_length_280_cov_1.285024_g61971_i0 | PRJNA611476 | 62762 | 280 | 1.285024 | 3.5980672 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 59.7 | 6.33e-8 | NR | TNJ26588.1 | 5742 | g61971 | i0 | 38.9 | 0.964285714285714 | 90 | 47 | 92.1 | 5 | 270 | 13 | 101 | 186 | TNJ26588.1 pVSP [Giardia muris] | diamond | 270 | 59.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 27806978 | 27806978 | PRJNA611476_P_NODE_57584_length_289_cov_1.416667_g56793_i0 | PRJNA611476 | 57584 | 289 | 1.416667 | 4.09416763 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 103 | 6.1999999999999986e-24 | NR | KAG9394225.1 | 201153 | g56793 | i0 | 47.9 | 1.95155709342561 | 94 | 49 | 97.6 | 0 | 284 | 3 | 230 | 323 | KAG9394225.1 Actin-related protein [Carpediemonas membranifera] | diamond | 564 | 103 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27933003 | 27933003 | PRJNA611476_P_NODE_22305_length_424_cov_2.945869_g21514_i0 | PRJNA611476 | 22305 | 424 | 2.945869 | 12.49048456 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 43.1 | 0.03 | NR | XP_067762115.1 | 348837 | g21514 | i0 | 37.5 | 0.39622641509434 | 56 | 34 | 39.6 | 1 | 240 | 73 | 41 | 95 | XP_067762115.1 Dynein light chain [Spironucleus salmonicida] | diamond | 168 | 43.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 28122484 | 28122484 | PRJNA611476_P_NODE_7225_length_722_cov_3.385208_g6460_i0 | PRJNA611476 | 7225 | 722 | 3.385208 | 24.44120176 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 107 | 1.62e-22 | NR | CAK8757278.1 | 28002 | g6460 | i0 | 32 | 1.00138504155125 | 241 | 133 | 99.3 | 6 | 1 | 717 | 601 | 812 | CAK8757278.1 HINF_008052 [Hexamita inflata] | diamond | 723 | 107 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28198509 | 28198509 | PRJNA611476_P_NODE_32926_length_363_cov_0.900000_g32135_i0 | PRJNA611476 | 32926 | 363 | 0.9 | 3.267 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 51.6 | 1.09e-4 | NR | ESU40178.1 | 5741 | g32135 | i0 | 45.8 | 1.61157024793388 | 59 | 27 | 47.1 | 3 | 6 | 176 | 284 | 339 | ESU40178.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 585 | 52 | 0.992307692307692 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28577616 | 28577616 | PRJNA611476_P_NODE_75327_length_256_cov_1.480874_g74536_i0 | PRJNA611476 | 75327 | 256 | 1.480874 | 3.79103744 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 59.3 | 6.21e-8 | NR | CAK8808191.1 | 28002 | g74536 | i0 | 41.2 | 7.6875 | 85 | 38 | 99.6 | 1 | 2 | 256 | 3 | 75 | CAK8808191.1 HINF_071869 [Hexamita inflata] | diamond | 1968 | 59.7 | 0.993299832495812 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28596215 | 28596215 | PRJNA611476_P_NODE_20667_length_439_cov_1.051913_g19876_i0 | PRJNA611476 | 20667 | 439 | 1.051913 | 4.61789807 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 45.8 | 0.0187 | NR | GCA62762.1 | 797122 | g19876 | i0 | 45.5 | 0.300683371298405 | 44 | 24 | 30.1 | 0 | 16 | 147 | 99 | 142 | GCA62762.1 hypothetical protein KIPB_005636 [Kipferlia bialata] | diamond | 132 | 45.8 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 29038325 | 29038325 | PRJNA611476_P_NODE_102288_length_245_cov_0.895349_g101497_i0 | PRJNA611476 | 102288 | 245 | 0.895349 | 2.19360505 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 63.9 | 1.29e-9 | NR | TNJ30320.1 | 5742 | g101497 | i0 | 47.5 | 0.722448979591837 | 59 | 30 | 72.2 | 1 | 43 | 219 | 35 | 92 | TNJ30320.1 VSP protein [Giardia muris] | diamond | 177 | 63.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 29164648 | 29164648 | PRJNA611476_P_NODE_50029_length_308_cov_0.982979_g49238_i0 | PRJNA611476 | 50029 | 308 | 0.982979 | 3.02757532 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 99 | 6.259999999999999e-23 | NR | GIQ82205.1 | 797122 | g49238 | i0 | 54.6 | 1.88961038961039 | 97 | 35 | 94.5 | 2 | 293 | 3 | 151 | 238 | GIQ82205.1 hypothetical protein KIPB_003299 [Kipferlia bialata] | diamond | 582 | 99 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 29764096 | 29764096 | PRJNA611476_P_NODE_17971_length_467_cov_1.581218_g17181_i0 | PRJNA611476 | 17971 | 467 | 1.581218 | 7.38428806 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 123 | 7.389999999999999e-31 | NR | KAG9391426.1 | 201153 | g17181 | i0 | 43.2 | 2.02997858672377 | 155 | 79 | 99.6 | 3 | 465 | 1 | 66 | 211 | KAG9391426.1 Hydrogenosomal membrane protein 31-like [Carpediemonas membranifera] | diamond | 948 | 123 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 29795710 | 29795710 | PRJNA611476_P_NODE_25411_length_401_cov_4.246951_g24620_i0 | PRJNA611476 | 25411 | 401 | 4.246951 | 17.03027351 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 84.3 | 5.85e-16 | NR | CAK8756227.1 | 28002 | g24620 | i0 | 43 | 1.9002493765586 | 86 | 49 | 64.3 | 0 | 142 | 399 | 211 | 296 | CAK8756227.1 HINF_014185 [Hexamita inflata] | diamond | 762 | 84.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 30459773 | 30459773 | PRJNA611476_P_NODE_45873_length_319_cov_1.252033_g45082_i0 | PRJNA611476 | 45873 | 319 | 1.252033 | 3.99398527 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 47 | 0.00304 | NR | CAK8815351.1 | 28002 | g45082 | i0 | 34 | 1.49529780564263 | 53 | 33 | 48 | 1 | 315 | 163 | 386 | 438 | CAK8815351.1 HINF_013559 [Hexamita inflata] | diamond | 477 | 47 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 30491036 | 30491036 | PRJNA611476_P_NODE_9933_length_618_cov_4.730275_g9149_i0 | PRJNA611476 | 9933 | 618 | 4.730275 | 29.2330995 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 129 | 7.009999999999999e-34 | NR | KAG9397400.1 | 201153 | g9149 | i0 | 36.5 | 6.37378640776699 | 192 | 112 | 93.2 | 3 | 42 | 617 | 1 | 182 | KAG9397400.1 EF-hand domain pair [Carpediemonas membranifera] | diamond | 3939 | 129 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30522441 | 30522441 | PRJNA611476_P_NODE_105973_length_244_cov_0.900585_g105182_i0 | PRJNA611476 | 105973 | 244 | 0.900585 | 2.1974274 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 67.4 | 1.6e-12 | NR | GKT25222.1 | 2918883 | g105182 | i0 | 50.7 | 1.7827868852459 | 75 | 31 | 88.5 | 2 | 226 | 11 | 7 | 78 | GKT25222.1 Sdc1/DPY30 like protein [Aduncisulcus paluster] | diamond | 435 | 67.4 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 30617245 | 30617245 | PRJNA611476_P_NODE_76753_length_253_cov_1.711111_g75962_i0 | PRJNA611476 | 76753 | 253 | 1.711111 | 4.32911083 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 57.4 | 3.01e-7 | NR | CAK8815351.1 | 28002 | g75962 | i0 | 35.6 | 0.865612648221344 | 73 | 41 | 84.2 | 2 | 4 | 216 | 370 | 438 | CAK8815351.1 HINF_013559 [Hexamita inflata] | diamond | 219 | 57.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31850134 | 31850134 | PRJNA611476_P_NODE_117057_length_241_cov_0.916667_g116266_i0 | PRJNA611476 | 117057 | 241 | 0.916667 | 2.20916747 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 60.5 | 1.99e-8 | NR | XP_067766953.1 | 348837 | g116266 | i0 | 42.7 | 1.0207468879668 | 82 | 38 | 94.6 | 5 | 3 | 230 | 227 | 305 | XP_067766953.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 246 | 60.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 31944955 | 31944955 | PRJNA611476_P_NODE_2057_length_1373_cov_4.443846_g1542_i0 | PRJNA611476 | 2057 | 1373 | 4.443846 | 61.01400558 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 253 | 9.46e-72 | NR | CAK8747405.1 | 28002 | g1542 | i0 | 38 | 0.943918426802622 | 432 | 243 | 94.2 | 7 | 79 | 1371 | 4 | 411 | CAK8747405.1 HINF_098669 [Hexamita inflata] | diamond | 1296 | 253 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32103283 | 32103283 | PRJNA611476_P_NODE_13878_length_527_cov_1.854626_g13088_i0 | PRJNA611476 | 13878 | 527 | 1.854626 | 9.77387902 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 52 | 2.79e-5 | NR | GIQ89704.1 | 797122 | g13088 | i0 | 41.4 | 0.330170777988615 | 58 | 34 | 33 | 0 | 175 | 2 | 20 | 77 | GIQ89704.1 ornithine decarboxylase, partial [Kipferlia bialata] | diamond | 174 | 52 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 32325130 | 32325130 | PRJNA611476_P_NODE_109499_length_243_cov_0.905882_g108708_i0 | PRJNA611476 | 109499 | 243 | 0.905882 | 2.20129326 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 49.3 | 1.84e-4 | NR | CAK8809518.1 | 28002 | g108708 | i0 | 29.9 | 2.04938271604938 | 77 | 53 | 93.8 | 1 | 8 | 235 | 379 | 455 | CAK8809518.1 HINF_011985 [Hexamita inflata] | diamond | 498 | 49.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32401375 | 32401375 | PRJNA611476_P_NODE_106599_length_244_cov_0.900585_g105808_i0 | PRJNA611476 | 106599 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 87 | 3.23e-18 | NR | ESU45417.1 | 5741 | g105808 | i0 | 48.7 | 3.86065573770492 | 78 | 36 | 95.9 | 2 | 4 | 237 | 228 | 301 | ESU45417.1 Cathepsin B-like cysteine proteinase, partial [Giardia intestinalis] | diamond | 942 | 87 | 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);;