contig_metadata
15 rows where bioproject = "PRJNA662254", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1904562 | 1904562 | PRJNA662254_P_NODE_7702_length_610_cov_1.486034_g7074_i0 | PRJNA662254 | 7702 | 610 | 1.486034 | 9.0648074 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 356 | 2.5599999999999997e-121 | NR | XP_044557880.1 | 5763 | g7074 | i0 | 85.2 | 1.99672131147541 | 203 | 30 | 99.8 | 0 | 1 | 609 | 52 | 254 | XP_044557880.1 uncharacterized protein FDP41_008374 [Naegleria fowleri] | diamond | 1218 | 356 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 3179263 | 3179263 | PRJNA662254_P_NODE_57583_length_245_cov_0.895349_g56932_i0 | PRJNA662254 | 57583 | 245 | 0.895349 | 2.19360505 | Stephanopogon apogon | 238758 | Heterolobosea | other_Eukaryota | 233 | 7.36e-57 | NTclustered | gi|160337332|gb|EF455760.1| | 238758 | g56932 | i0 | 84.082 | 42.734693877551 | 245 | 35 | 99 | 3 | 1 | 243 | 861 | 1103 | Stephanopogon apogon alpha-tubulin (atub) gene, partial cds | blastn | 10470 | 233 | 1 | Eukaryota | Discoba | Heterolobosea | Stephanopogonidae | Stephanopogon | Stephanopogon apogon | ||||
| 10832439 | 10832439 | PRJNA662254_P_NODE_45509_length_251_cov_0.865169_g44858_i0 | PRJNA662254 | 45509 | 251 | 0.865169 | 2.17157419 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 202 | 2.13e-47 | NTclustered | gi|290991818|ref|XM_002678486.1| | 5762 | g44858 | i0 | 81.275 | 30.8725099601594 | 251 | 45 | 99 | 2 | 1 | 250 | 437 | 686 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_60529), partial mRNA | blastn | 7749 | 202 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 15931156 | 15931156 | PRJNA662254_P_NODE_36973_length_276_cov_1.137931_g36322_i0 | PRJNA662254 | 36973 | 276 | 1.137931 | 3.14068956 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 153 | 4.72e-45 | NR | XP_044556321.1 | 5763 | g36322 | i0 | 75 | 339.989130434783 | 92 | 23 | 100 | 0 | 1 | 276 | 21 | 112 | XP_044556321.1 uncharacterized protein FDP41_010134 [Naegleria fowleri] | diamond | 93837 | 154 | 0.993506493506494 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 18480619 | 18480619 | PRJNA662254_P_NODE_28075_length_312_cov_3.217573_g27424_i0 | PRJNA662254 | 28075 | 312 | 3.217573 | 10.03882776 | Allovahlkampfia sp. | 1874883 | Heterolobosea | other_Eukaryota | 248 | 3.47e-61 | NTclustered | gi|2651357784|gb|PP174299.1| | 1874883 | g27424 | i0 | 91.257 | 56.1634615384615 | 183 | 15 | 59 | 1 | 129 | 311 | 2921 | 3102 | Allovahlkampfia sp. isolate S28D2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 17523 | 248 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Allovahlkampfia | Allovahlkampfia sp. | ||||
| 19755191 | 19755191 | PRJNA662254_P_NODE_23796_length_338_cov_1.162264_g23145_i0 | PRJNA662254 | 23796 | 338 | 1.162264 | 3.92845232 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 124 | 9.03e-31 | NR | XP_002682064.1 | 5762 | g23145 | i0 | 52.7 | 0.994082840236686 | 112 | 53 | 99.4 | 0 | 1 | 336 | 175 | 286 | XP_002682064.1 ammonium transporter AmtA [Naegleria gruberi] | diamond | 336 | 124 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 22305534 | 22305534 | PRJNA662254_P_NODE_31638_length_295_cov_2.067568_g30987_i0 | PRJNA662254 | 31638 | 295 | 2.067568 | 6.0993256 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 204 | 7.139999999999998e-48 | NTclustered | gi|2119449339|ref|XM_044698046.1| | 51637 | g30987 | i0 | 79.655 | 12.4135593220339 | 290 | 53 | 97 | 6 | 3 | 289 | 287 | 1 | Naegleria lovaniensis uncharacterized protein (C9374_008016), partial mRNA | blastn | 3662 | 204 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 23581001 | 23581001 | PRJNA662254_P_NODE_49679_length_249_cov_0.875000_g49028_i0 | PRJNA662254 | 49679 | 249 | 0.875 | 2.17875 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 78.7 | 3.72e-10 | NTclustered | gi|290996503|ref|XM_002680776.1| | 5762 | g49028 | i0 | 76.744 | 0.931726907630522 | 172 | 20 | 64 | 14 | 91 | 249 | 205 | 369 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_64074), partial mRNA | blastn | 232 | 78.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 24854636 | 24854636 | PRJNA662254_P_NODE_54400_length_247_cov_0.885057_g53749_i0 | PRJNA662254 | 54400 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 129 | 1.4099999999999998e-32 | NR | XP_002678219.1 | 5762 | g53749 | i0 | 75.6 | 74.6842105263158 | 82 | 20 | 99.6 | 0 | 1 | 246 | 593 | 674 | XP_002678219.1 P-type II calcium ATPase [Naegleria gruberi] | diamond | 18447 | 130 | 0.992307692307692 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 27934309 | 27934309 | PRJNA662254_P_NODE_47405_length_250_cov_0.870056_g46754_i0 | PRJNA662254 | 47405 | 250 | 0.870056 | 2.17514 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 93.2 | 1.02e-20 | NR | KAL0486964.1 | 1008807 | g46754 | i0 | 45.8 | 7.908 | 83 | 45 | 99.6 | 0 | 2 | 250 | 105 | 187 | KAL0486964.1 hypothetical protein AKO1_001270 [Acrasis kona] | diamond | 1977 | 93.2 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28029115 | 28029115 | PRJNA662254_P_NODE_59305_length_244_cov_0.900585_g58654_i0 | PRJNA662254 | 59305 | 244 | 0.900585 | 2.1974274 | Psalteriomonas lanterna | 31290 | Heterolobosea | other_Eukaryota | 72.4 | 7.29e-13 | NR | ACZ97597.1 | 31290 | g58654 | i0 | 40.7 | 0.995901639344262 | 81 | 48 | 99.6 | 0 | 1 | 243 | 108 | 188 | ACZ97597.1 ADP-ATP carrier protein, partial [Psalteriomonas lanterna] | diamond | 243 | 72.4 | 1 | Eukaryota | Discoba | Heterolobosea | Psalteriomonadidae | Psalteriomonas | Psalteriomonas lanterna | ||||
| 29039619 | 29039619 | PRJNA662254_P_NODE_60048_length_244_cov_0.900585_g59397_i0 | PRJNA662254 | 60048 | 244 | 0.900585 | 2.1974274 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 43.5 | 0.0204 | NR | XP_044563371.1 | 5763 | g59397 | i0 | 32.8 | 0.75 | 61 | 41 | 75 | 0 | 28 | 210 | 417 | 477 | XP_044563371.1 uncharacterized protein FDP41_002478 [Naegleria fowleri] | diamond | 183 | 43.5 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 29260139 | 29260139 | PRJNA662254_P_NODE_24209_length_335_cov_1.412214_g23558_i0 | PRJNA662254 | 24209 | 335 | 1.412214 | 4.7309169 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 100 | 3.0500000000000003e-22 | NR | KAL0488809.1 | 1008807 | g23558 | i0 | 58.3 | 1.77313432835821 | 84 | 33 | 73.4 | 1 | 2 | 247 | 13 | 96 | KAL0488809.1 dnaJ subfamily A protein [Acrasis kona] | diamond | 594 | 100 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 29323378 | 29323378 | PRJNA662254_P_NODE_38109_length_272_cov_1.150754_g37458_i0 | PRJNA662254 | 38109 | 272 | 1.150754 | 3.13005088 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 95.9 | 2.63e-21 | NR | XP_044557751.1 | 5763 | g37458 | i0 | 50 | 1.88602941176471 | 84 | 42 | 92.6 | 0 | 256 | 5 | 29 | 112 | XP_044557751.1 uncharacterized protein FDP41_008702 [Naegleria fowleri] | diamond | 513 | 95.9 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 30776619 | 30776619 | PRJNA662254_P_NODE_34334_length_285_cov_1.235849_g33683_i0 | PRJNA662254 | 34334 | 285 | 1.235849 | 3.52216965 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 127 | 1.7399999999999998e-32 | NR | KAL0477610.1 | 1008807 | g33683 | i0 | 64.9 | 1.97894736842105 | 94 | 33 | 98.9 | 0 | 3 | 284 | 210 | 303 | KAL0477610.1 medium-chain specific acyl-CoA dehydrogenase ACADM, mitochondrial [Acrasis kona] | diamond | 564 | 127 | 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);;