contig_metadata
8 rows where bioproject = "PRJNA915212", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26834805 | 26834805 | PRJNA915212_P_NODE_41_length_2199_cov_2.728372_g36_i0 | PRJNA915212 | 41 | 2199 | 2.728372 | 59.99690028 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 52.4 | 0.0116 | NR | GIQ80334.1 | 797122 | g36 | i0 | 27.3 | 0.279672578444748 | 205 | 129 | 25.5 | 7 | 526 | 1086 | 719 | 921 | GIQ80334.1 hypothetical protein KIPB_001114, partial [Kipferlia bialata] | diamond | 615 | 52.4 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 27372585 | 27372585 | PRJNA915212_P_NODE_8083_length_205_cov_1.288462_g8045_i0 | PRJNA915212 | 8083 | 205 | 1.288462 | 2.6413471 | Giardia intestinalis ATCC 5 | 5741 | Fornicata | other_Eukaryota | 43.9 | 0.00918 | NR | EES99242.1 | 598745 | g8045 | i0 | 37 | 0.790243902439024 | 54 | 32 | 79 | 1 | 186 | 25 | 957 | 1008 | EES99242.1 High cysteine membrane protein Group 1 [Giardia intestinalis ATCC 50581] | diamond | 162 | 43.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28484735 | 28484735 | PRJNA915212_P_NODE_9366_length_190_cov_1.056738_g9328_i0 | PRJNA915212 | 9366 | 190 | 1.056738 | 2.0078022 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.9 | 1.11e-4 | NR | ESU44104.1 | 5741 | g9328 | i0 | 49.2 | 4.16842105263158 | 59 | 24 | 85.3 | 3 | 181 | 20 | 113 | 170 | ESU44104.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 792 | 48.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29708353 | 29708353 | PRJNA915212_P_NODE_950_length_686_cov_2.901099_g919_i0 | PRJNA915212 | 950 | 686 | 2.901099 | 19.90153914 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 50.8 | 0.00214 | NR | XP_067766779.1 | 348837 | g919 | i0 | 35.4 | 0.494169096209913 | 113 | 62 | 45.9 | 6 | 376 | 62 | 242 | 351 | XP_067766779.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 339 | 50.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 31067439 | 31067439 | PRJNA915212_P_NODE_7715_length_210_cov_1.416149_g7677_i0 | PRJNA915212 | 7715 | 210 | 1.416149 | 2.9739129 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 46.2 | 0.0014 | NR | XP_067766808.1 | 348837 | g7677 | i0 | 40.9 | 0.942857142857143 | 66 | 32 | 90 | 2 | 203 | 15 | 5 | 66 | XP_067766808.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 198 | 46.2 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 31193242 | 31193242 | PRJNA915212_P_NODE_1695_length_511_cov_1.320346_g1660_i0 | PRJNA915212 | 1695 | 511 | 1.320346 | 6.74696806 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 143 | 1.81e-38 | NR | GKT34815.1 | 2918883 | g1660 | i0 | 51.1 | 0.792563600782779 | 135 | 66 | 79.3 | 0 | 81 | 485 | 2 | 136 | GKT34815.1 putative multi-domain containing protein [Aduncisulcus paluster] | diamond | 405 | 143 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 32237844 | 32237844 | PRJNA915212_P_NODE_1018_length_663_cov_1.412052_g987_i0 | PRJNA915212 | 1018 | 663 | 1.412052 | 9.36190476 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 48.5 | 0.0141 | NR | CAK8757751.1 | 28002 | g987 | i0 | 48.5 | 0.298642533936652 | 33 | 17 | 14.9 | 0 | 486 | 584 | 527 | 559 | CAK8757751.1 HINF_090447 [Hexamita inflata] | diamond | 198 | 48.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32900212 | 32900212 | PRJNA915212_P_NODE_1600_length_525_cov_2.264706_g1565_i0 | PRJNA915212 | 1600 | 525 | 2.264706 | 11.8897065 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 110 | 2.7200000000000004e-27 | NR | KAG9392754.1 | 201153 | g1565 | i0 | 39.1 | 0.994285714285714 | 174 | 91 | 97.1 | 7 | 4 | 513 | 1 | 163 | KAG9392754.1 Translationally controlled tumor protein [Carpediemonas membranifera] | diamond | 522 | 110 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera |
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);;