contig_metadata
14 rows where bioproject = "PRJNA884104", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5963824 | 5963824 | PRJNA884104_S_NODE_30605_length_369_cov_1.378378_g29862_i0 | PRJNA884104 | 30605 | 369 | 1.378378 | 5.08621482 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 223 | 3.62e-72 | NR | GIQ84029.1 | 797122 | g29862 | i0 | 81.3 | 4 | 123 | 23 | 100 | 0 | 1 | 369 | 10 | 132 | GIQ84029.1 Ran GTPase [Kipferlia bialata] | diamond | 1476 | 223 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 9788840 | 9788840 | PRJNA884104_S_NODE_4928_length_912_cov_3.190703_g4386_i0 | PRJNA884104 | 4928 | 912 | 3.190703 | 29.09921136 | Ergobibamus cyprinoides | 926446 | Fornicata | other_Eukaryota | 545 | 3.469999999999999e-150 | NTclustered | gi|339759377|dbj|AB600301.1| | 926446 | g4386 | i0 | 80.379 | 79.484649122807 | 739 | 128 | 80 | 14 | 183 | 912 | 1279 | 549 | Ergobibamus cyprinoides gene for beta-tubulin, partial cds, strain: CL | blastn | 72490 | 545 | 1 | Eukaryota | Metamonada | Fornicata | Ergobibamus | Ergobibamus cyprinoides | |||||
| 27055548 | 27055548 | PRJNA884104_S_NODE_52262_length_289_cov_1.782407_g51519_i0 | PRJNA884104 | 52262 | 289 | 1.782407 | 5.15115623 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 76.3 | 1.62e-14 | NR | GKT28404.1 | 2918883 | g51519 | i0 | 55.1 | 1.54671280276817 | 69 | 29 | 70.6 | 2 | 248 | 45 | 17 | 84 | GKT28404.1 Glycoside hydrolase, family 25 like protein [Aduncisulcus paluster] | diamond | 447 | 76.3 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 27189635 | 27189635 | PRJNA884104_S_NODE_18142_length_473_cov_1.707500_g17401_i0 | PRJNA884104 | 18142 | 473 | 1.7075 | 8.076475 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.9 | 0.00265 | NR | XP_037902080.1 | 5741 | g17401 | i0 | 32.6 | 3.32346723044397 | 141 | 78 | 84.4 | 7 | 16 | 414 | 390 | 521 | XP_037902080.1 High cysteine membrane protein Group 1 [Giardia intestinalis] | diamond | 1572 | 48.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 27687648 | 27687648 | PRJNA884104_S_NODE_64284_length_260_cov_1.192513_g63541_i0 | PRJNA884104 | 64284 | 260 | 1.192513 | 3.1005338 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 65.9 | 1.02e-10 | NR | TNJ28365.1 | 5742 | g63541 | i0 | 40.2 | 1.89230769230769 | 82 | 49 | 94.6 | 0 | 5 | 250 | 55 | 136 | TNJ28365.1 Ribosomal protein L10a [Giardia muris] | diamond | 492 | 65.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 28666185 | 28666185 | PRJNA884104_S_NODE_63787_length_261_cov_1.228723_g63044_i0 | PRJNA884104 | 63787 | 261 | 1.228723 | 3.20696703 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 48.1 | 3.56e-4 | NR | GIQ81850.1 | 797122 | g63044 | i0 | 73.1 | 0.298850574712644 | 26 | 7 | 29.9 | 0 | 80 | 3 | 7 | 32 | GIQ81850.1 Ran GTPase [Kipferlia bialata] | diamond | 78 | 48.1 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 28989968 | 28989968 | PRJNA884104_S_NODE_4668_length_936_cov_2.521437_g4139_i0 | PRJNA884104 | 4668 | 936 | 2.521437 | 23.60065032 | root | 1 | Root_unresolved | Root_unresolved | 65.1 | 5.1e-8 | NR | KAG9390301.1 | 201153 | g4139 | i0 | 51.9 | 0.342948717948718 | 52 | 23 | 16.7 | 1 | 930 | 775 | 42 | 91 | KAG9390301.1 Cyst wall protein type 2 [Carpediemonas membranifera] | diamond | 321 | 65.1 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 29360711 | 29360711 | PRJNA884104_S_NODE_25309_length_403_cov_1.400000_g24566_i0 | PRJNA884104 | 25309 | 403 | 1.4 | 5.642 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 48.1 | 0.00276 | NR | TNJ26942.1 | 5742 | g24566 | i0 | 47.7 | 0.327543424317618 | 44 | 21 | 32.8 | 1 | 143 | 274 | 700 | 741 | TNJ26942.1 High cysteine membrane protein [Giardia muris] | diamond | 132 | 48.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 31359043 | 31359043 | PRJNA884104_S_NODE_23076_length_421_cov_1.683908_g22333_i0 | PRJNA884104 | 23076 | 421 | 1.683908 | 7.08925268 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 124 | 6.17e-30 | NR | KAG9394637.1 | 201153 | g22333 | i0 | 47.4 | 6.53444180522565 | 137 | 71 | 96.9 | 1 | 419 | 12 | 153 | 289 | KAG9394637.1 Tubulin--tyrosine ligase [Carpediemonas membranifera] | diamond | 2751 | 124 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31453913 | 31453913 | PRJNA884104_S_NODE_39676_length_328_cov_1.509804_g38933_i0 | PRJNA884104 | 39676 | 328 | 1.509804 | 4.95215712 | Hexamitidae | 5739 | Fornicata | other_Eukaryota | 90.9 | 5.11e-20 | NR | CAK8763111.1 | 28002 | g38933 | i0 | 44.9 | 1.96646341463415 | 107 | 52 | 95.1 | 2 | 13 | 324 | 7 | 109 | CAK8763111.1 HINF_079201 [Hexamita inflata] | diamond | 645 | 90.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31477706 | 31477706 | PRJNA884104_S_NODE_896_length_1958_cov_2.561273_g749_i0 | PRJNA884104 | 896 | 1958 | 2.561273 | 50.14972534 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 59.3 | 7.31e-5 | NR | GIQ80334.1 | 797122 | g749 | i0 | 26 | 0.559244126659857 | 365 | 201 | 49.6 | 15 | 683 | 1654 | 720 | 1057 | GIQ80334.1 hypothetical protein KIPB_001114, partial [Kipferlia bialata] | diamond | 1095 | 59.3 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 32118236 | 32118236 | PRJNA884104_S_NODE_49698_length_297_cov_0.875000_g48955_i0 | PRJNA884104 | 49698 | 297 | 0.875 | 2.59875 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 46.6 | 0.0027 | NR | KAG9393697.1 | 201153 | g48955 | i0 | 33.3 | 2.47474747474747 | 63 | 40 | 63.6 | 1 | 108 | 296 | 75 | 135 | KAG9393697.1 Alpha/beta hydrolase family [Carpediemonas membranifera] | diamond | 735 | 46.6 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 32300403 | 32300403 | PRJNA884104_S_NODE_36119_length_342_cov_1.914498_g35376_i0 | PRJNA884104 | 36119 | 342 | 1.914498 | 6.54758316 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 69.7 | 3.6e-12 | NR | KAG9392754.1 | 201153 | g35376 | i0 | 44.4 | 1.70175438596491 | 81 | 44 | 70.2 | 1 | 102 | 341 | 37 | 117 | KAG9392754.1 Translationally controlled tumor protein [Carpediemonas membranifera] | diamond | 582 | 69.7 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 32395113 | 32395113 | PRJNA884104_S_NODE_8079_length_713_cov_1.995313_g7397_i0 | PRJNA884104 | 8079 | 713 | 1.995313 | 14.22658169 | Giardia intestinalis assemblage B | 1394984 | Fornicata | other_Eukaryota | 48.5 | 0.00674 | NR | KWX14910.1 | 1394984 | g7397 | i0 | 43.5 | 0.61851332398317 | 69 | 34 | 29 | 3 | 518 | 312 | 105 | 168 | KWX14910.1 Variant-specific surface protein [Giardia intestinalis assemblage B] | diamond | 441 | 48.5 | 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);;