contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJEB14664" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7673453 | 7673453 | PRJEB14664_P_NODE_2787_length_544_cov_2.298625_g2669_i0 | PRJEB14664 | 2787 | 544 | 2.298625 | 12.50452 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 162 | 2.9199999999999995e-43 | NR | KAL0487961.1 | 1008807 | g2669 | i0 | 45.7 | 2.86213235294118 | 175 | 92 | 96.5 | 1 | 530 | 6 | 4 | 175 | KAL0487961.1 acyl-CoA oxidase [Acrasis kona] | diamond | 1557 | 162 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 12774825 | 12774825 | PRJEB14664_P_NODE_3391_length_486_cov_2.274945_g3267_i0 | PRJEB14664 | 3391 | 486 | 2.274945 | 11.0562327 | root | 1 | Root_unresolved | Root_unresolved | 207 | 2.24e-65 | NR | XP_044561309.1 | 5763 | g3267 | i0 | 75 | 11.7345679012346 | 128 | 32 | 79 | 0 | 485 | 102 | 3 | 130 | XP_044561309.1 uncharacterized protein FDP41_004495 [Naegleria fowleri] | diamond | 5703 | 208 | 0.995192307692308 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 26937979 | 26937979 | PRJEB14664_P_NODE_17102_length_167_cov_1.515152_g16972_i0 | PRJEB14664 | 17102 | 167 | 1.515152 | 2.53030384 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 110 | 6.200000000000001e-28 | NR | XP_002680196.1 | 5762 | g16972 | i0 | 92.7 | 0.988023952095808 | 55 | 4 | 98.8 | 0 | 166 | 2 | 18 | 72 | XP_002680196.1 60S ribosomal protein L2 [Naegleria gruberi] | diamond | 165 | 110 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 27633446 | 27633446 | PRJEB14664_P_NODE_2084_length_636_cov_5.690516_g1975_i0 | PRJEB14664 | 2084 | 636 | 5.690516 | 36.19168176 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 48.9 | 0.00322 | NR | KAL0481817.1 | 1008807 | g1975 | i0 | 26.2 | 0.665094339622642 | 141 | 74 | 53.3 | 4 | 271 | 609 | 53 | 191 | KAL0481817.1 hypothetical protein AKO1_012399 [Acrasis kona] | diamond | 423 | 48.9 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28138776 | 28138776 | PRJEB14664_P_NODE_14225_length_190_cov_1.290323_g14095_i0 | PRJEB14664 | 14225 | 190 | 1.290323 | 2.4516137 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 48.1 | 1.41e-4 | NR | XP_002678222.1 | 5762 | g14095 | i0 | 48.9 | 1.32631578947368 | 45 | 23 | 71.1 | 0 | 189 | 55 | 114 | 158 | XP_002678222.1 ras family small GTPase [Naegleria gruberi] | diamond | 252 | 48.1 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 28549201 | 28549201 | PRJEB14664_P_NODE_13867_length_193_cov_1.012658_g13737_i0 | PRJEB14664 | 13867 | 193 | 1.012658 | 1.95442994 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 52.8 | 5.36e-6 | NR | XP_002682034.1 | 5762 | g13737 | i0 | 57.4 | 0.948186528497409 | 61 | 22 | 94.8 | 1 | 6 | 188 | 6 | 62 | XP_002682034.1 uncharacterized protein NAEGRDRAFT_78127 [Naegleria gruberi] | diamond | 183 | 52.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29149286 | 29149286 | PRJEB14664_P_NODE_18049_length_161_cov_1.269841_g17919_i0 | PRJEB14664 | 18049 | 161 | 1.269841 | 2.04444401 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 52.4 | 4.86e-6 | NR | XP_002669434.1 | 5762 | g17919 | i0 | 64.3 | 0.782608695652174 | 42 | 14 | 78.3 | 1 | 129 | 4 | 952 | 992 | XP_002669434.1 uncharacterized protein NAEGRDRAFT_82167 [Naegleria gruberi] | diamond | 126 | 52.4 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30286247 | 30286247 | PRJEB14664_P_NODE_1672_length_715_cov_2.583824_g1571_i0 | PRJEB14664 | 1672 | 715 | 2.583824 | 18.4743416 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 64.7 | 5.37e-8 | NR | CAG4717172.1 | 5763 | g1571 | i0 | 28.8 | 1.61118881118881 | 205 | 135 | 84.3 | 5 | 643 | 41 | 195 | 392 | CAG4717172.1 unnamed protein product [Naegleria fowleri] | diamond | 1152 | 64.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 31138576 | 31138576 | PRJEB14664_P_NODE_11775_length_216_cov_1.104972_g11645_i0 | PRJEB14664 | 11775 | 216 | 1.104972 | 2.38673952 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 86.3 | 9.04e-19 | NR | XP_002676748.1 | 5762 | g11645 | i0 | 82 | 0.847222222222222 | 61 | 11 | 84.7 | 0 | 3 | 185 | 156 | 216 | XP_002676748.1 uncharacterized protein NAEGRDRAFT_68050 [Naegleria gruberi] | diamond | 183 | 86.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31575434 | 31575434 | PRJEB14664_P_NODE_3656_length_465_cov_1.683721_g3531_i0 | PRJEB14664 | 3656 | 465 | 1.683721 | 7.82930265 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 85.1 | 4.3e-16 | NR | XP_044564671.1 | 5763 | g3531 | i0 | 52.9 | 1.64516129032258 | 68 | 31 | 43.9 | 1 | 445 | 242 | 171 | 237 | XP_044564671.1 uncharacterized protein FDP41_001111 [Naegleria fowleri] | diamond | 765 | 85.5 | 0.9953216374269 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 31771404 | 31771404 | PRJEB14664_P_NODE_9457_length_251_cov_2.754630_g9327_i0 | PRJEB14664 | 9457 | 251 | 2.75463 | 6.9141213 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 62.8 | 2.33e-10 | NR | KAL0490923.1 | 1008807 | g9327 | i0 | 46.5 | 0.848605577689243 | 71 | 27 | 84.9 | 1 | 36 | 248 | 13 | 72 | KAL0490923.1 ribosomal protein S20 [Acrasis kona] | diamond | 213 | 62.8 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32081360 | 32081360 | PRJEB14664_P_NODE_7358_length_298_cov_1.505703_g7228_i0 | PRJEB14664 | 7358 | 298 | 1.505703 | 4.48699494 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 183 | 4.589999999999999e-55 | NR | XP_044557880.1 | 5763 | g7228 | i0 | 85.9 | 4.98322147651007 | 99 | 14 | 99.7 | 0 | 2 | 298 | 53 | 151 | XP_044557880.1 uncharacterized protein FDP41_008374 [Naegleria fowleri] | diamond | 1485 | 184 | 0.994565217391304 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 32151134 | 32151134 | PRJEB14664_P_NODE_14938_length_183_cov_1.891892_g14808_i0 | PRJEB14664 | 14938 | 183 | 1.891892 | 3.46216236 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 99 | 1.09e-24 | NR | XP_044552838.1 | 51637 | g14808 | i0 | 89.5 | 0.934426229508197 | 57 | 6 | 93.4 | 0 | 3 | 173 | 88 | 144 | XP_044552838.1 uncharacterized protein C9374_000285 [Naegleria lovaniensis] | diamond | 171 | 99 | 1 | 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);;