contig_metadata
21 rows where bioproject = "PRJNA688931", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17246412 | 17246412 | PRJNA688931_P_NODE_30834_length_182_cov_2.315789_g30621_i0 | PRJNA688931 | 30834 | 182 | 2.315789 | 4.21473598 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 105 | 7.030000000000001e-27 | NR | KAG9393315.1 | 201153 | g30621 | i0 | 82.5 | 5.63736263736264 | 57 | 10 | 94 | 0 | 172 | 2 | 6 | 62 | KAG9393315.1 Small GTPase superfamily [Carpediemonas membranifera] | diamond | 1026 | 106 | 0.990566037735849 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27030547 | 27030547 | PRJNA688931_P_NODE_21242_length_222_cov_1.433526_g21029_i0 | PRJNA688931 | 21242 | 222 | 1.433526 | 3.18242772 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 67.8 | 4.01e-11 | NR | CAK8777447.1 | 28002 | g21029 | i0 | 46.5 | 1.91891891891892 | 71 | 37 | 95.9 | 1 | 220 | 8 | 8 | 77 | CAK8777447.1 HINF_049255 [Hexamita inflata] | diamond | 426 | 68.2 | 0.994134897360704 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 27050774 | 27050774 | PRJNA688931_P_NODE_40242_length_164_cov_2.530435_g40029_i0 | PRJNA688931 | 40242 | 164 | 2.530435 | 4.1499134 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 45.4 | 0.00122 | NR | GIQ80663.1 | 797122 | g40029 | i0 | 53.3 | 1.26219512195122 | 45 | 21 | 82.3 | 0 | 24 | 158 | 1 | 45 | GIQ80663.1 glycoside hydrolase, family 25 [Kipferlia bialata] | diamond | 207 | 45.4 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 27631059 | 27631059 | PRJNA688931_P_NODE_23804_length_210_cov_0.850932_g23591_i0 | PRJNA688931 | 23804 | 210 | 0.850932 | 1.7869572 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 57 | 1.89e-7 | NR | XP_067760422.1 | 348837 | g23591 | i0 | 58.2 | 2.75714285714286 | 55 | 18 | 78.6 | 2 | 209 | 45 | 53 | 102 | XP_067760422.1 Kinase, CMGC CDK [Spironucleus salmonicida] | diamond | 579 | 57.4 | 0.993031358885017 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 27840171 | 27840171 | PRJNA688931_P_NODE_16444_length_253_cov_2.019608_g16231_i0 | PRJNA688931 | 16444 | 253 | 2.019608 | 5.10960824 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 85.1 | 3.81e-17 | NR | XP_067768571.1 | 348837 | g16231 | i0 | 51.3 | 0.948616600790514 | 80 | 38 | 93.7 | 1 | 14 | 250 | 3 | 82 | XP_067768571.1 Aspartate aminotransferase [Spironucleus salmonicida] | diamond | 240 | 85.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 28041466 | 28041466 | PRJNA688931_P_NODE_6865_length_416_cov_1.356948_g6652_i0 | PRJNA688931 | 6865 | 416 | 1.356948 | 5.64490368 | root | 1 | Root_unresolved | Root_unresolved | 104 | 5.119999999999999e-24 | NR | KAG9389664.1 | 201153 | g6652 | i0 | 41.7 | 1.81009615384615 | 132 | 75 | 95.2 | 1 | 396 | 1 | 99 | 228 | KAG9389664.1 Adenine phosphoribosyl transferase [Carpediemonas membranifera] | diamond | 753 | 104 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 28219045 | 28219045 | PRJNA688931_P_NODE_22866_length_214_cov_1.248485_g22653_i0 | PRJNA688931 | 22866 | 214 | 1.248485 | 2.6717579 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 48.9 | 1.73e-4 | NR | ESU40144.1 | 5741 | g22653 | i0 | 38 | 3.86915887850467 | 71 | 39 | 98.1 | 4 | 214 | 5 | 324 | 390 | ESU40144.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 828 | 48.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28219082 | 28219082 | PRJNA688931_P_NODE_5826_length_455_cov_23.135468_g5614_i0 | PRJNA688931 | 5826 | 455 | 23.135468 | 105.2663794 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 43.1 | 0.0363 | NR | XP_067762115.1 | 348837 | g5614 | i0 | 37.5 | 0.369230769230769 | 56 | 34 | 36.9 | 1 | 252 | 85 | 41 | 95 | XP_067762115.1 Dynein light chain [Spironucleus salmonicida] | diamond | 168 | 43.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 28388629 | 28388629 | PRJNA688931_P_NODE_3986_length_561_cov_2.105469_g3784_i0 | PRJNA688931 | 3986 | 561 | 2.105469 | 11.81168109 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 57.4 | 3.91e-6 | NR | CAK8790396.1 | 28002 | g3784 | i0 | 28.1 | 1.3475935828877 | 153 | 94 | 77.5 | 5 | 7 | 441 | 121 | 265 | CAK8790396.1 HINF_081407 [Hexamita inflata] | diamond | 756 | 57.8 | 0.993079584775087 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28546818 | 28546818 | PRJNA688931_P_NODE_36427_length_168_cov_0.865546_g36214_i0 | PRJNA688931 | 36427 | 168 | 0.865546 | 1.45411728 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 50.8 | 1.82e-5 | NR | CAK8795161.1 | 28002 | g36214 | i0 | 59 | 1.73214285714286 | 39 | 16 | 69.6 | 0 | 121 | 5 | 17 | 55 | CAK8795161.1 HINF_018015 [Hexamita inflata] | diamond | 291 | 50.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28882253 | 28882253 | PRJNA688931_P_NODE_29208_length_188_cov_1.352518_g28995_i0 | PRJNA688931 | 29208 | 188 | 1.352518 | 2.54273384 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 51.6 | 1.33e-5 | NR | ESU40656.1 | 5741 | g28995 | i0 | 47.2 | 2.71276595744681 | 53 | 25 | 84.6 | 2 | 30 | 188 | 429 | 478 | ESU40656.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 510 | 51.6 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 30176990 | 30176990 | PRJNA688931_P_NODE_25492_length_202_cov_1.843137_g25279_i0 | PRJNA688931 | 25492 | 202 | 1.843137 | 3.72313674 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 42.7 | 0.0222 | NR | TNJ30320.1 | 5742 | g25279 | i0 | 43.8 | 0.712871287128713 | 48 | 24 | 71.3 | 1 | 147 | 4 | 35 | 79 | TNJ30320.1 VSP protein [Giardia muris] | diamond | 144 | 42.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 30556067 | 30556067 | PRJNA688931_P_NODE_8253_length_374_cov_1.590769_g8040_i0 | PRJNA688931 | 8253 | 374 | 1.590769 | 5.94947606 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 75.1 | 6.78e-13 | NR | KAG9390677.1 | 201153 | g8040 | i0 | 45.9 | 0.786096256684492 | 98 | 53 | 78.6 | 0 | 309 | 16 | 158 | 255 | KAG9390677.1 tumor suppressor, Mitostatin [Carpediemonas membranifera] | diamond | 294 | 75.1 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30587686 | 30587686 | PRJNA688931_P_NODE_27293_length_195_cov_1.417808_g27080_i0 | PRJNA688931 | 27293 | 195 | 1.417808 | 2.7647256 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 52.4 | 8.05e-6 | NR | ESU40393.1 | 5741 | g27080 | i0 | 32.4 | 2.18461538461538 | 71 | 41 | 98.5 | 2 | 192 | 1 | 291 | 361 | ESU40393.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 426 | 52.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 30808983 | 30808983 | PRJNA688931_P_NODE_14354_length_273_cov_1.375000_g14141_i0 | PRJNA688931 | 14354 | 273 | 1.375 | 3.75375 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 44.7 | 0.0115 | NR | XP_067766637.1 | 348837 | g14141 | i0 | 30.9 | 0.747252747252747 | 68 | 45 | 74.7 | 1 | 252 | 49 | 303 | 368 | XP_067766637.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 204 | 44.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 31662391 | 31662391 | PRJNA688931_P_NODE_23157_length_213_cov_0.896341_g22944_i0 | PRJNA688931 | 23157 | 213 | 0.896341 | 1.90920633 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 50.8 | 3.62e-5 | NR | GKT15179.1 | 2918883 | g22944 | i0 | 54.1 | 2.28169014084507 | 37 | 17 | 52.1 | 0 | 111 | 1 | 234 | 270 | GKT15179.1 Tubulin-tyrosine ligase/Tubulin polyglutamylase like protein [Aduncisulcus paluster] | diamond | 486 | 50.8 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 31725729 | 31725729 | PRJNA688931_P_NODE_26137_length_200_cov_0.973510_g25924_i0 | PRJNA688931 | 26137 | 200 | 0.97351 | 1.94702 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 43.1 | 0.016 | NR | XP_067765691.1 | 348837 | g25924 | i0 | 44.4 | 0.54 | 36 | 20 | 54 | 0 | 109 | 2 | 4274 | 4309 | XP_067765691.1 Dynein heavy chain [Spironucleus salmonicida] | diamond | 108 | 43.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 31788864 | 31788864 | PRJNA688931_P_NODE_29537_length_187_cov_1.130435_g29324_i0 | PRJNA688931 | 29537 | 187 | 1.130435 | 2.11391345 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 47.8 | 2.95e-4 | NR | XP_001705127.2 | 5741 | g29324 | i0 | 42.4 | 1.05882352941176 | 66 | 28 | 89.8 | 2 | 170 | 3 | 501 | 566 | XP_001705127.2 High cysteine membrane protein Group 3 [Giardia intestinalis] | diamond | 198 | 47.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31852263 | 31852263 | PRJNA688931_P_NODE_9837_length_338_cov_1.370242_g9624_i0 | PRJNA688931 | 9837 | 338 | 1.370242 | 4.63141796 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 44.3 | 0.0311 | NR | ESU41862.1 | 5741 | g9624 | i0 | 46.4 | 0.497041420118343 | 56 | 22 | 49.7 | 4 | 243 | 76 | 325 | 372 | ESU41862.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 168 | 44.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32042199 | 32042199 | PRJNA688931_P_NODE_23618_length_210_cov_1.925466_g23405_i0 | PRJNA688931 | 23618 | 210 | 1.925466 | 4.0434786 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 100 | 3.2699999999999995e-23 | NR | GKT35578.1 | 2918883 | g23405 | i0 | 67.6 | 0.971428571428571 | 68 | 22 | 97.1 | 0 | 5 | 208 | 103 | 170 | GKT35578.1 Protein kinase 2 [Aduncisulcus paluster] | diamond | 204 | 100 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 32894742 | 32894742 | PRJNA688931_P_NODE_21800_length_219_cov_1.317647_g21587_i0 | PRJNA688931 | 21800 | 219 | 1.317647 | 2.88564693 | Giardia intestinalis ATCC 5 | 5741 | Fornicata | other_Eukaryota | 42.4 | 0.0379 | NR | EES99242.1 | 598745 | g21587 | i0 | 47.1 | 0.465753424657534 | 34 | 18 | 46.6 | 0 | 18 | 119 | 703 | 736 | EES99242.1 High cysteine membrane protein Group 1 [Giardia intestinalis ATCC 50581] | diamond | 102 | 42.4 | 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);;