contig_metadata
7 rows where bioproject = "PRJNA833575", tax_clade = "Discoba" and tax_phylum = "Heterolobosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13578157 | 13578157 | PRJNA833575_P_NODE_5731_length_590_cov_3.804223_g5594_i0 | PRJNA833575 | 5731 | 590 | 3.804223 | 22.4449157 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 300 | 2.1099999999999996e-99 | NR | XP_044557880.1 | 5763 | g5594 | i0 | 80 | 3.75254237288136 | 185 | 36 | 94.1 | 1 | 557 | 3 | 7 | 190 | XP_044557880.1 uncharacterized protein FDP41_008374 [Naegleria fowleri] | diamond | 2214 | 301 | 0.996677740863787 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 14852340 | 14852340 | PRJNA833575_P_NODE_31632_length_264_cov_1.374359_g31495_i0 | PRJNA833575 | 31632 | 264 | 1.374359 | 3.62830776 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 167 | 4.3899999999999997e-48 | NR | KAL0482140.1 | 1008807 | g31495 | i0 | 82.8 | 20.7613636363636 | 87 | 15 | 98.9 | 0 | 3 | 263 | 173 | 259 | KAL0482140.1 histone deacetylase [Acrasis kona] | diamond | 5481 | 167 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 27157643 | 27157643 | PRJNA833575_P_NODE_34382_length_252_cov_1.180328_g34245_i0 | PRJNA833575 | 34382 | 252 | 1.180328 | 2.97442656 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 148 | 1.03e-41 | NR | XP_002668652.1 | 5762 | g34245 | i0 | 79.5 | 3.95238095238095 | 83 | 17 | 98.8 | 0 | 2 | 250 | 187 | 269 | XP_002668652.1 uncharacterized protein NAEGRDRAFT_60075 [Naegleria gruberi] | diamond | 996 | 148 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 27528524 | 27528524 | PRJNA833575_P_NODE_32563_length_260_cov_1.272251_g32426_i0 | PRJNA833575 | 32563 | 260 | 1.272251 | 3.3078526 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 97.1 | 1.5600000000000002e-21 | NR | KAL0481506.1 | 1008807 | g32426 | i0 | 51.2 | 0.992307692307692 | 86 | 42 | 99.2 | 0 | 3 | 260 | 205 | 290 | KAL0481506.1 glucan 1,3-beta-glucosidase [Acrasis kona] | diamond | 258 | 97.1 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31255262 | 31255262 | PRJNA833575_P_NODE_31835_length_263_cov_1.484536_g31698_i0 | PRJNA833575 | 31835 | 263 | 1.484536 | 3.90432968 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 86.3 | 2.3e-19 | NR | KAL0484278.1 | 1008807 | g31698 | i0 | 49.4 | 0.96958174904943 | 85 | 43 | 97 | 0 | 9 | 263 | 4 | 88 | KAL0484278.1 ribosomal protein L34 [Acrasis kona] | diamond | 255 | 86.3 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31540111 | 31540111 | PRJNA833575_P_NODE_31756_length_263_cov_2.226804_g31619_i0 | PRJNA833575 | 31756 | 263 | 2.226804 | 5.85649452 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 94.7 | 2.35e-21 | NR | XP_002671543.1 | 5762 | g31619 | i0 | 56.1 | 1.893536121673 | 82 | 34 | 92.4 | 2 | 1 | 243 | 126 | 206 | XP_002671543.1 uncharacterized protein NAEGRDRAFT_73314 [Naegleria gruberi] | diamond | 498 | 94.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32434620 | 32434620 | PRJNA833575_P_NODE_7719_length_514_cov_1.132584_g7582_i0 | PRJNA833575 | 7719 | 514 | 1.132584 | 5.82148176 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 173 | 1.34e-46 | NR | XP_044548004.1 | 51637 | g7582 | i0 | 47.4 | 10.9785992217899 | 171 | 83 | 99.8 | 3 | 2 | 514 | 213 | 376 | XP_044548004.1 uncharacterized protein C9374_005527 [Naegleria lovaniensis] | diamond | 5643 | 174 | 0.994252873563218 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis |
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);;