contig_metadata
8 rows where bioproject = "PRJNA1113956" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6600002 | 6600002 | PRJNA1113956_P_NODE_126_length_3348_cov_6.053740_g108_i0 | PRJNA1113956 | 126 | 3348 | 6.05374 | 202.6792152 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 337 | 8.179999999999999e-95 | NR | XP_002669658.1 | 5762 | g108 | i0 | 36.4 | 4.63082437275986 | 645 | 296 | 52 | 16 | 1580 | 3319 | 424 | 1019 | XP_002669658.1 DEAD/DEAH box helicase [Naegleria gruberi] | diamond | 15504 | 337 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 27668355 | 27668355 | PRJNA1113956_P_NODE_22004_length_243_cov_1.358824_g21664_i0 | PRJNA1113956 | 22004 | 243 | 1.358824 | 3.30194232 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 48.9 | 1.7e-4 | NR | KAJ9458201.1 | 91374 | g21664 | i0 | 36.4 | 0.814814814814815 | 66 | 42 | 81.5 | 0 | 27 | 224 | 112 | 177 | KAJ9458201.1 Ras-like GTP-binding protein YPT1 [Diplonema papillatum] | diamond | 198 | 48.9 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 27983920 | 27983920 | PRJNA1113956_P_NODE_3705_length_933_cov_2.823256_g3442_i0 | PRJNA1113956 | 3705 | 933 | 2.823256 | 26.34097848 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 90.5 | 5e-16 | NR | XP_002673745.1 | 5762 | g3442 | i0 | 34.6 | 1.51768488745981 | 188 | 103 | 54.7 | 5 | 758 | 249 | 543 | 728 | XP_002673745.1 uncharacterized protein NAEGRDRAFT_80815 [Naegleria gruberi] | diamond | 1416 | 90.5 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 28426136 | 28426136 | PRJNA1113956_P_NODE_666_length_1988_cov_9.525326_g605_i0 | PRJNA1113956 | 666 | 1988 | 9.525326 | 189.36348088 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 225 | 1.01e-60 | NR | KAJ9461372.1 | 91374 | g605 | i0 | 29.7 | 0.834507042253521 | 553 | 325 | 75.9 | 15 | 1584 | 76 | 91 | 629 | KAJ9461372.1 Proline dehydrogenase 1 [Diplonema papillatum] | diamond | 1659 | 225 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 28804652 | 28804652 | PRJNA1113956_P_NODE_1848_length_1363_cov_1.816279_g1695_i0 | PRJNA1113956 | 1848 | 1363 | 1.816279 | 24.75588277 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 57 | 1.52e-4 | NR | XP_002673421.1 | 5762 | g1695 | i0 | 40 | 0.198092443140132 | 90 | 50 | 18.9 | 1 | 1007 | 750 | 398 | 487 | XP_002673421.1 rabGTPase-activating protein [Naegleria gruberi] | diamond | 270 | 57 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29364440 | 29364440 | PRJNA1113956_P_NODE_5229_length_744_cov_1.417288_g4923_i0 | PRJNA1113956 | 5229 | 744 | 1.417288 | 10.54462272 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 81.6 | 1.36e-13 | NR | XP_044559784.1 | 5763 | g4923 | i0 | 28 | 3.28225806451613 | 193 | 124 | 76.6 | 4 | 584 | 15 | 26 | 206 | XP_044559784.1 uncharacterized protein FDP41_005824 [Naegleria fowleri] | diamond | 2442 | 82 | 0.995121951219512 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 30122092 | 30122092 | PRJNA1113956_P_NODE_3112_length_1041_cov_14.691116_g2878_i0 | PRJNA1113956 | 3112 | 1041 | 14.691116 | 152.93451756 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 49.7 | 0.0156 | NR | XP_002675654.1 | 5762 | g2878 | i0 | 43.4 | 0.962536023054755 | 53 | 30 | 15.3 | 0 | 819 | 977 | 450 | 502 | XP_002675654.1 uncharacterized protein NAEGRDRAFT_80282 [Naegleria gruberi] | diamond | 1002 | 50.1 | 0.992015968063872 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31047718 | 31047718 | PRJNA1113956_P_NODE_10655_length_419_cov_2.867052_g10316_i0 | PRJNA1113956 | 10655 | 419 | 2.867052 | 12.01294788 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 99.4 | 4.4799999999999997e-23 | NR | KAL0480648.1 | 1008807 | g10316 | i0 | 42 | 0.715990453460621 | 100 | 57 | 71.6 | 1 | 300 | 1 | 16 | 114 | KAL0480648.1 2 TM domain-containing transmembrane protein [Acrasis kona] | diamond | 300 | 99.4 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona |
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);;