contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA635874" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 606779 | 606779 | PRJNA635874_P_NODE_16221_length_382_cov_0.886731_g16074_i0 | PRJNA635874 | 16221 | 382 | 0.886731 | 3.38731242 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 167 | 7.829999999999999e-47 | NR | XP_002680773.1 | 5762 | g16074 | i0 | 65.1 | 4.91623036649215 | 126 | 44 | 99 | 0 | 380 | 3 | 150 | 275 | XP_002680773.1 enolase [Naegleria gruberi] | diamond | 1878 | 167 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 13362362 | 13362362 | PRJNA635874_P_NODE_68971_length_242_cov_1.142012_g68824_i0 | PRJNA635874 | 68971 | 242 | 1.142012 | 2.76366904 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 135 | 6.3e-36 | NR | AAG48934.1 | 43695 | g68824 | i0 | 73.8 | 8.92561983471074 | 80 | 21 | 99.2 | 0 | 241 | 2 | 130 | 209 | AAG48934.1 elongation factor 1 alpha, partial [Acrasis rosea] | diamond | 2160 | 136 | 0.992647058823529 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis rosea | ||||
| 27124727 | 27124727 | PRJNA635874_P_NODE_46682_length_251_cov_0.865169_g46535_i0 | PRJNA635874 | 46682 | 251 | 0.865169 | 2.17157419 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 97.8 | 1.7400000000000003e-21 | NR | CAG4714735.1 | 5763 | g46535 | i0 | 56.1 | 1.9601593625498 | 82 | 35 | 98 | 1 | 248 | 3 | 609 | 689 | CAG4714735.1 unnamed protein product [Naegleria fowleri] | diamond | 492 | 97.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 28375775 | 28375775 | PRJNA635874_P_NODE_59346_length_246_cov_0.890173_g59199_i0 | PRJNA635874 | 59346 | 246 | 0.890173 | 2.18982558 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 43.9 | 0.0152 | NR | XP_044566436.1 | 5763 | g59199 | i0 | 36.5 | 1.3780487804878 | 74 | 43 | 87.8 | 2 | 224 | 9 | 646 | 717 | XP_044566436.1 uncharacterized protein FDP41_012380 [Naegleria fowleri] | diamond | 339 | 43.9 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 29291455 | 29291455 | PRJNA635874_P_NODE_73429_length_241_cov_0.916667_g73282_i0 | PRJNA635874 | 73429 | 241 | 0.916667 | 2.20916747 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 77.8 | 1.65e-14 | NR | XP_002673322.1 | 5762 | g73282 | i0 | 51.3 | 0.995850622406639 | 80 | 37 | 99.6 | 2 | 240 | 1 | 557 | 634 | XP_002673322.1 uncharacterized protein NAEGRDRAFT_71525 [Naegleria gruberi] | diamond | 240 | 77.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29449123 | 29449123 | PRJNA635874_P_NODE_64070_length_244_cov_0.900585_g63923_i0 | PRJNA635874 | 64070 | 244 | 0.900585 | 2.1974274 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 137 | 1.39e-38 | NR | XP_002676990.1 | 5762 | g63923 | i0 | 85.2 | 0.995901639344262 | 81 | 12 | 99.6 | 0 | 2 | 244 | 115 | 195 | XP_002676990.1 uncharacterized protein NAEGRDRAFT_67737 [Naegleria gruberi] | diamond | 243 | 137 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29891587 | 29891587 | PRJNA635874_P_NODE_48231_length_251_cov_0.865169_g48084_i0 | PRJNA635874 | 48231 | 251 | 0.865169 | 2.17157419 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 90.1 | 5.13e-21 | NR | KAL0487562.1 | 1008807 | g48084 | i0 | 59.7 | 0.860557768924303 | 72 | 29 | 86.1 | 0 | 13 | 228 | 55 | 126 | KAL0487562.1 profilin [Acrasis kona] | diamond | 216 | 90.1 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 30693777 | 30693777 | PRJNA635874_P_NODE_71573_length_241_cov_1.607143_g71426_i0 | PRJNA635874 | 71573 | 241 | 1.607143 | 3.87321463 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 55.5 | 1.13e-6 | NR | KAL0477258.1 | 1008807 | g71426 | i0 | 55.8 | 1.46887966804979 | 43 | 19 | 53.5 | 0 | 137 | 9 | 51 | 93 | KAL0477258.1 cathepsin C [Acrasis kona] | diamond | 354 | 55.5 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31029061 | 31029061 | PRJNA635874_P_NODE_50855_length_249_cov_1.579545_g50708_i0 | PRJNA635874 | 50855 | 249 | 1.579545 | 3.93306705 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 99 | 7.02e-22 | NR | XP_044563458.1 | 5763 | g50708 | i0 | 63.8 | 2.87951807228916 | 80 | 28 | 96.4 | 1 | 1 | 240 | 2597 | 2675 | XP_044563458.1 uncharacterized protein FDP41_002565 [Naegleria fowleri] | diamond | 717 | 99 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 31249972 | 31249972 | PRJNA635874_P_NODE_31195_length_298_cov_1.026667_g31048_i0 | PRJNA635874 | 31195 | 298 | 1.026667 | 3.05946766 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 146 | 4.25e-42 | NR | XP_044566917.1 | 5763 | g31048 | i0 | 70.4 | 2.97986577181208 | 98 | 29 | 98.7 | 0 | 3 | 296 | 39 | 136 | XP_044566917.1 uncharacterized protein FDP41_012065 [Naegleria fowleri] | diamond | 888 | 146 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 31345038 | 31345038 | PRJNA635874_P_NODE_64236_length_244_cov_0.900585_g64089_i0 | PRJNA635874 | 64236 | 244 | 0.900585 | 2.1974274 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 89.4 | 8.77e-19 | NR | KAL0487233.1 | 1008807 | g64089 | i0 | 52.4 | 1.00819672131148 | 82 | 38 | 99.6 | 1 | 244 | 2 | 246 | 327 | KAL0487233.1 metallopeptidase family M24 protein [Acrasis kona] | diamond | 246 | 89.4 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32072509 | 32072509 | PRJNA635874_P_NODE_71938_length_241_cov_0.916667_g71791_i0 | PRJNA635874 | 71938 | 241 | 0.916667 | 2.20916747 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 51.6 | 2.69e-5 | NR | XP_044553668.1 | 51637 | g71791 | i0 | 62.2 | 0.460580912863071 | 37 | 13 | 46.1 | 1 | 239 | 129 | 665 | 700 | XP_044553668.1 uncharacterized protein C9374_013259 [Naegleria lovaniensis] | diamond | 111 | 51.6 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 32357532 | 32357532 | PRJNA635874_P_NODE_56579_length_247_cov_0.885057_g56432_i0 | PRJNA635874 | 56579 | 247 | 0.885057 | 2.18609079 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 48.1 | 4.86e-4 | NR | XP_002673635.1 | 5762 | g56432 | i0 | 39.3 | 0.740890688259109 | 61 | 36 | 74.1 | 1 | 245 | 63 | 922 | 981 | XP_002673635.1 uncharacterized protein NAEGRDRAFT_58949 [Naegleria gruberi] | diamond | 183 | 48.1 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi |
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);;